Novice-Techies

Creating library project in flex

2010-05-14T04:40:00.000-07:00

Creating library project:

Open Flex builder 3
Navigate to File->New->Flex Library Project
In the New Flex Library Project dialog

Enter the project name as "FirstLibProject"
Click on Next
Select the Classes tab
In the Main source folder item click on Browse
In select Source folder dialog select the project
Click on New button
A new folder will be added under the projects
Click Ok
Select the checkbox for the src folder (All the classes in this folder will be included in library swc)
Click on Finish button

Create an mxml component under src folder by right clicking on src folder and name it "LibrarySample.mxml"
Create an Action script class under src and name it as "LibraryAS.as"
In the bin folder a swc file will be created by name FirstLibProject.swc

In our mxml if we want to use these Files which we created above we can include the swc file to our project.

Including the swc file in a project:
In the project "Xyz" which we want to include the swc copy the swc which we created above:

Copy the FirstLibProject.swc to some path (c:\lib)
Open the project "Xyz" in Flex builder
Right click on the project "Xyz" (in navigator view) click on Properties
Select Flex Build Path in the Properties dialog
Select Library path tab
Click on Add SWC and browse for C:\temp\FirstLibProject.swc and click Ok
In this project we can use the classes LibrarySample and LibraryAS

Find in CF

2010-05-12T04:43:00.000-07:00

Finds the first occurrence of a substring in a string, from a specified start position. The search is case-sensitive.
A number; the position of substring in string; or 0, if substring is not in string.
Syntax:
Find(substring, string [, start ])

Parameter Description
substring A string or a variable that
contains one. String for which to search.
string A string or a variable that contains one.
String in which to search.
start Start position of search.

Program :

#find("the",stringToSearch)#

#find("the",stringToSearch,35)#

#find("no such substring",stringToSearch)#

Source :
http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functi80.htm#wp1104451

MVS SYSTEM CODES-S813

2010-05-10T04:39:00.000-07:00

The data set name in the JCL did not match the data set name on the tape.

1. The JCL volume serial number was wrong.
2. The data set name in the JCL was misspelled.
3. The wrong tape was mounted.
4. The incorrect data set sequence number was specified in the label parameter.
5. The data set does not exist on the magnetic tape. Verify that the JCL is correct, and resubmit the job.

Ref: www.ibmmainframes.com

How to find out Version Of Oracle Application in Unix-2

2010-05-08T04:37:00.000-07:00

c. Class file version
Step 1. Go to the UNIX box
Step 2. Go to the class file location
$strings -a grep Header

d. Apachhe Version
Step 1. Go to the UNIX box
Step 2. Go to the $iAS or $IAS_CONFIG_HOME
Step 3. Then go to Apachhe/Apachhe/bin directory
Step 4. run the following Command
$httpd -version

The output will be
bash-2.03$ httpd -version
Server version: Oracle HTTP Server Powered by Apache/1.3.19 (Unix)
Server built: Jan 26 2005 11:06:44 (iAS 1.0.2.2.2 rollup 5)

How to find out Version Of Oracle Application-1

2010-05-06T04:35:00.000-07:00

Whenever you are working in oracle application you will face some situation where you have to know the version of the products you are using in your Oracle Application. Though the env file help you a lot to reduce the need of the versions as it makes the system user friendly. In some issue solving cases such as upgrade, patching or some specific issues you must have to know the versions.

The products we are using can be of almost three types -
1. Components related to Application
2. Components related to Database
3. Components related to some useful utilities and OS

Components related to Application:
a. The version of the oracle application.
Step 1. First open the Oracle Application Frontend
Step 2. Open any form session in it
Step 3. Go to help
Step 4. Click on "About Oracle Application"

b. Version of Oracle Application Forms or Reports.
Step 1. Go to the UNIX box
Step 2. Go to the $CUSTOM_TOP location
Step 3. Then go to /11.5.0/forms/US/
Step 4. Run the following command

Call a class private method from another class

2010-05-04T04:30:00.000-07:00

while googling, i have came accross a interesting thing, these blog is just to share the information with you all.
Here i am calling private method method1() in PrivateMethodClass from another class CallingMethod. the below is the source code, which i tried.

Source Code:
PrivateMethodClass.java
package com.src;
public class PrivateMethodClass {
private void method1(int a,int b){
System.out.println("Var:a:"+a+"::Var b:"+b);
int c = a+b;
System.out.println("Var c:"+c);
}

public void method2(int a,int b){
System.out.println("Var:a:"+a+"::Var b:"+b);
int c = a+b;
System.out.println("Var c:"+c);
}
}

CallingMethod.java
package com.src;
import java.lang.reflect.Method;
public class CallingMethod {
public static void main(String[] args) {
Class klass;
try {
klass = PrivateMethodClass.class;
PrivateMethodClass pmc = new PrivateMethodClass();
Class[] param = {Integer.TYPE,Integer.TYPE};
Method m[] = klass.getDeclaredMethods();
int c =0;
int a[] = {1,2};
for(int i=0;i System.out.println("Method name is "+m[i].getName());
m[i].setAccessible(true);
m[i].invoke(pmc,1,2);
}
} catch (Exception e) {
System.out.println("Exception::"+e.getMessage());
}
}
}

The Output Result:
Method name is method1
Var:a:1::Var b:2
Var c:3
Method name is method2
Var:a:1::Var b:2
Var c:3

Source: http://vishalnjain.blogspot.com/

MVS SYSTEM CODES-S913

2010-05-02T04:34:00.000-07:00

An error occurred in opening a magnetic tape data set.

1. The error occurred during open or end-of-volume processing. The data set was password protected, and a correct password was not entered.

2. The error occurred in opening a checkpoint data set which was concatenated to a non-checkpoint data set.

1. Supply the correct password, and resubmit the job.

2. Eliminate any concatenations of checkpoint and non-checkpoint data sets.

Ref: www.ibmmainframes.com

MVS SYSTEM CODES -SA13

2010-05-01T04:29:00.000-07:00

An error occurred in opening a tape data set.

1. The file sequence number was wrong on a multi-volume tape data set.

2. The file sequence number was wrong, or it was less than that of the first data set on the tape.

3. The volume serial number was wrong.

4. The job which wrote the tape did not write all the data sets.

Steps:
1. Verify that the JCL is correct, and resubmit the job.

2. If the desired data set does not exist on the tape, recreate the tape.
Ref: www.ibmmainframes.com

Value restricions

2010-04-30T04:27:00.000-07:00

Some primitive value besides a conrete data-type may have a predefined set of values. And the value can be set only to one of that variants, like enumerations. XML schema allows us to restrict the value of a given type by a set of enumerated values. From the other hand we can restrict some value by defining its min/max bounds:

http://www.w3.org/2001/XMLSchema">

…

…

…

…

…

source: java-tips.org

DataBase Links

2010-04-28T04:25:00.000-07:00

A database link is a pointer in the local database that allows you to access the data on a remote database.
For example: If we want to access the database of a different server other than the one we are working on. we cannot access that database directly if we don’t have access.In such cases we use Database links to access the remote database.
There is no special syntax fort using these Dblinks.we should just add that link after the table name as shown below.

Select * from emp where emp_id=’1111111’;

This is the actual query.using this query we should access the remote database to which we don’t have access.In this case you can access that remote database if it has a DBlink available to connect to our database.

For Example if GOAT is the Dblink used to access the database of Goat,then the above query should be given in this way

Select * from emp@GOAT where emp_id=’1111111’

In this way by using DBlinks we can access remote databases.

Tired of including configuration files in your scripts

2010-04-26T04:24:00.000-07:00

I am often tired of including configuration files in my scripts. Even if it is a single file it becomes important to include that file in our scripts otherwise we wont get the necessary variables set. Once when I started searching for a workaround for it, I found that we can configure it right in one place and say PHP take care of this headache.
Yes, We can do it.

1.Place all your configuration files in one folder in the server. Say "DOCUMENT_ROOT/config/lib"
2. Create a new file with a name preinclude.php
3. Declare or include (again include ) all your common variables, config files in this file.
4.In the DOCUMENT_ROOT folder create a .htaccess file
5. Write the following code in this:

# Code starts here
php_value auto_prepend_file "path to include directory/preinclude.php"
# Code ends here

We can include whichever file which we feel should be executed before each and every file execution here.

Advantage of SYNC Class

2010-04-24T04:23:00.000-07:00

The SYNCHRONIZED clause is sometimes used with USAGE IS COMP or USAGE IS INDEX items. It is used to optimize speed of processing but it does so at the expense of increased storage requirements.
The word SYNC can be used instead of SYNCHRONIZED.
The SYNCHRONIZED clause is used to explicitly align COMP and INDEX items along their natural word boundaries. Without the SYNCHRONIZED clause, data-items are aligned on byte boundaries.
Example: 01 TWO-BYTE PIC S9(4) COMP SYNC.

Optimize SOAP Messages

2010-04-22T04:22:00.000-07:00

As we all know SOAP content is nothing but a XML.Though XML is descriptive, sometimes it might be typically larger due to the volume of tags. So given the case,if you have any performance problems in using SOAP XML's, consider using Message Transmission Optimization Mechanism (MTOM), which builds on XML-binary Optimized Packaging (XOP). XOP provides a more efficient serialization of XML by using MIME encoding. MTOM uses XOP to encode portions of SOAP messages,while still presenting an XML Infoset to the SOAP application.

Another, more recent alternative is to use XFire. XFire is an open source,standards-compliant SOAP framework that uses the latest technologies, including a StAX parser, to boost SOA messaging performance. As i spoke about StAX,i will give a brief intro about that here…

StAX:Streaming API for XML:
StAX is a parser API that falls between the tree-navigation DOM and push event-based SAX interfaces. It works serially on an XML document as SAX does, but it allows tokens to be pulled by the application.
Again, unless your performance is unacceptable, you should be fine with regular XML SOAP messages. However, if you are providing services to a large community of clients, you may need to boost your performance using one of the above mentioned alternatives.

Show data with JTable

2010-04-20T04:19:00.000-07:00

This Java Swing tip illustrates a method of showing data in database in a JTable. JTable act as a output for the database. The developer may use this to display a part of data (for example data generated form a query) to the user in a table. The table gives user an impression of database.

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.table.*;
public class DatabaseTest extends JFrame {
JTextField hostField;
JTextField queryField;
QueryTableModel qtm;

public DatabaseTest() {
super("Database Test Frame");
setDefaultCloseOperation(EXIT_ON_CLOSE);
setSize(350, 200);
qtm = new QueryTableModel();
JTable table = new JTable(qtm);
JScrollPane scrollpane = new JScrollPane(table);
JPanel p1 = new JPanel();
p1.setLayout(new GridLayout(3, 2));
p1.add(new JLabel("Enter the Host URL: "));
p1.add(hostField = new JTextField());
p1.add(new JLabel("Enter your query: "));
p1.add(queryField = new JTextField());
p1.add(new JLabel("Click here to send: "));
JButton jb = new JButton("Search");

jb.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
qtm.setHostURL(hostField.getText().trim());
qtm.setQuery(queryField.getText().trim());
}
} );

p1.add(jb);
getContentPane().add(p1, BorderLayout.NORTH);
getContentPane().add(scrollpane, BorderLayout.CENTER);
}
public static void main(String args[]) {
DatabaseTest tt = new DatabaseTest();
tt.setVisible(true);
}
}

Source: java-tips.org

Creating a Confirm Dialog Box

2010-04-18T04:19:00.000-07:00

The easiest way to create a Yes/No/Cancel dialog box is to use showConfirmDialog(Component, Object) method of JOptionPane class.
The following example uses a confirm dialog box with a text message and stores response in the response variable:
int response;
response = JOptionPane.showConfirmDialog(null, "Should i delete all files?");

source: java-tips.org

Restarting Windows Without Restarting Your PC

2010-04-16T04:18:00.000-07:00

A modern PC with Vista Home Edition takes about one and a half minutes to boot. An older machine with XP is about the same. That’s 30 seconds for the PC itself (the BIOS) to boot up, plus a minute for the Windows operating system to boot. Sometimes, you need to reboot Windows (e.g. when installing new software), but there is no need to restart BIOS, too. However, the default is to reboot both. (That’s called doing a “cold boot,” rather than a “warm boot.”) There’s a trick that works on both XP and Vista to get it to do a warm boot instead, thus saving you 30 seconds per cycle.
The trick is to hold down the SHIFT key when invoking the restart.
Select Start. Select “Shut Down…”. Change the drop-down combo box under “What do you want the computer to do?” to “Restart”. Hold down the SHIFT key while clicking on the “OK” button.

Source: www.masternewmedia.org

Lotus notes: Change your password

2010-04-14T04:17:00.000-07:00

In my previous article about lotus notes, we have seen how to configure an email account in Lotus notes.Today we will look into the topic, how to change the password of your Lotus notes account.
Open the Lotus notes client,1. Go to File-> Security-> User Security2. In the 'User Security' window, go to 'Your Login and Password Settings' section3. Click on the 'Change Password' button4. Change Password Pop up window is displayed 5. Type the new password, then reenter the new password and click OK6. A popup message box is dispayed "Your Password Change succeeded".
Now you can access your email with your new password.

AS/400 Tips 17

2010-04-12T04:16:00.000-07:00

Retaining Customization
It is often required or desirable to customize certain system attributes from how they are set out of the box. For example, you may want to change certain command defaults from the IBM-shipped defaults.
When you do an O/S upgrade however, you'll find that your changes were erased. Unless you kept very good documentation, you'll be hard pressed to remember which changes you made.
A good workaround to this is to create a CL source member that contains all the commands you've customized your system with. Keep the source member up to date and include thorough comments.Compile this member into a program, and simply run the program whenever you've done an upgrade.

Source: http://midwareservices.com/tipstricks/windows.htm

AS/400 Tips 18

2010-04-10T04:15:00.000-07:00

POP UP COMMNAD LINES
It's pretty common to be several programs deep in an application when you suddenly have the need for a command line. There's any easy way to allow this without having to back out or switch to a different session.
Program QUSCMDLN is the IBM supplied API to call a command line. No parameters are required. You may want to add a function key to your application programs (perhaps F21) to call this program.
If you don't want to go through this much work, simply change your user profile (CHGUSRPRF) and set QUSCMDLN as your attention key handling program.

Source: http://midwareservices.com/tipstricks/command_lines.htm

Turn off Indexing to speed up XP

2010-04-08T04:14:00.000-07:00

Windows XP keeps a record of all files on the hard disk so when you do a search on the hard drive it is faster. There is a downside to this and because the computer has to index all files, it will slow down normal file commands like open, close, etc. If you do not do a whole lot of searches on your hard drive then I suggest turnning this feature off:
1. Control Panel
2. Administrative Tools
3. Services
4. Disable Indexing Services

Source: www.tweakxp.com

Unload .dll’s to Free Memory

2010-04-06T04:13:00.000-07:00

Windows Explorer caches DLLs (Dynamic-Link Libraries) in memory for a period of time after the application using them has been closed. This can be an inefficient use of memory.

1. Find the key [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer].

2. Create a new sub-key named 'AlwaysUnloadDLL' and set the default value to equal '1' to disable Windows caching the DLL in memory.

3. Restart Windows for the change to take effect.
I tried this after running a intense program, then watched the task manager; memory recovered it self.

Source: www.tweakxp.com

Input Dialog Box

2010-04-04T04:12:00.000-07:00

An input dialog box asks a question and uses a text field to store the response.
The easiest way to create an input dialog in Java is to use showInputDialog(Component, Object, String, int) method of JOptionPane class.

The following example uses this method to create an input dialog box:

String response = JOptionPane.showInputDialog(null, "What is your name?", "Enter your name", JOptionPane.QUESTION_MESSAGE);

Source: java-tips.org

Message Dialog Box

2010-04-02T04:11:00.000-07:00

A message dialog box is a simple window that displays information. A message dialog box can be created with a call to the showMessageDialog(Component, Object) method of JOptionPane class.

The following statement creates a message box:
JOptionPane.showMessageDialog(null, "I am happy.");

Source: java-tips.org

MVS SYSTEM CODES -SB37

2010-04-01T06:57:00.000-07:00

An error occurred during end-of-volume processing of a data set. The system was unable to fulfill a request for more space.

1. A program loop caused too many records to be written to the output data set.
2. Insufficient space was allocated to this data set in the JCL.
3. There was no more room available to receive any more output on the output volume, and another volume could not be mounted.

1. Verify that there are no program loops or logic errors.
2. Increase the primary and/or secondary allocations for the data set.
3. Change the JCL to request that the data set be created on a volume with more space.

Ref: http://www.ibmmainframes.com/

MS WORD SHORTCUT KEYS

2010-03-30T06:04:00.000-07:00

Ctrl + A Select all contents of the page
Ctrl + B Bold highlighted selection
Ctrl + C Copy selected text
Ctrl + X Cut selected text
Ctrl + N Open new/blank document
Ctrl + O Open options
Ctrl + P Open the print window
Ctrl + F Open find box
Ctrl + I Italicize highlighted selection
Ctrl + K Insert link
Ctrl + U Underline highlighted selection
Ctrl + V Paste
Ctrl + Y Redo the last action performed
Ctrl + Z Undo last action
Ctrl + G Find and replace options
Ctrl + H Find and replace options
Ctrl + J Justify paragraph alignment
Ctrl + L Align selected text or line to the left
Ctrl + Q Align selected paragraph to the left
Ctrl + E Align selected text or line to the center
Ctrl + R Align selected text or line to the right
Ctrl + M Indent the paragraph
Ctrl + T Hanging indent
Ctrl + D Font options
Ctrl + Shift + F Change the font
Ctrl + Shift + > Increase selected font +1
Ctrl + ] Increase selected font +1
Ctrl + Shift + < Decrease selected font -1
Ctrl + [ Decrease selected font -1
Ctrl + Shift + * View or hide non printing characters
Ctrl + f Move one word to the left
Ctrl + g Move one word to the right
Ctrl + h Move to beginning of the line or paragraph
Ctrl + i Move to the end of the paragraph
Ctrl + Del Delete word to right of cursor
Ctrl + Backspace Delete word to left of cursor
Ctrl + End Move cursor to end of document
Ctrl + Home Move cursor to beginning of document
Ctrl + Space Reset highlighted text to default font
Ctrl + 1 Single-space lines
Ctrl + 2 Double-space lines
Ctrl + 5 1.5-line spacing
Ctrl + Alt + 1 Change text to heading 1
Ctrl + Alt + 2 Change text to heading 2
Ctrl + Alt + 3 Change text to heading 3
F1 Open help
Shift + F3 Change case of selected text
Shift + Insert Paste
F4 Repeat last action performed (Word 2000+)
F7 Spell check selected text and/or document
Shift + F7 Activate the thesaurus
F12 Save as
Ctrl + S Save
Shift + F12 Save
Alt + Shift + D Insert the current date
Alt + Shift + T Insert the current time
Ctrl + W Close document

Sticky Notes as your Browser Homepage

2010-03-28T06:55:00.000-07:00

Sticky Screen(http://stickyscreen.org) is a simple online version of the yellow Post-It Note that you can set as your browser homepage.
You just have to type something onto the sticky note and set that website as your browser home page. No need to register anywhere and there’s no save button.
The yellow sticky note will show up whenever you start the web browser. The magic is due to a cookie that gets saved locally so the sticky note will change to the default one if you decide to clear the cookies someday.
For something more permanent, check these Post It Notes for Desktop.

findnocase in CF

2010-03-26T06:53:00.000-07:00

Finds the first occurrence of a substring in a string, from a specified start position. If substring is not in string, returns zero. The search is case-insensitive.
The position of substring in string; or 0, if substring is not in string.

Syntax:
FindNoCase(substring, string [, start ])

Parameter Description
substring A string or a variable that contains one. String for which to search.
string A string or a variable that contains one. String in which to search.
start Start position of search.

Program:

#findnocase("the",stringToSearch)#
#findnocase("the",stringToSearch,5)#
#findnocase("no such substring",stringToSearch)#

Source : http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functi81.htm#wp1104504

Getting into the .NET runtime

2010-03-24T06:50:00.000-07:00

The IISAPIRuntime interface acts as the interface point between the unmanaged code coming from the ISAPI extension (directly in IIS 6 and indirectly via the Named Pipe handler in IIS 5). If you take a look at this class you’ll find a ProcessRequest method with a signature like this:

[return: MarshalAs(UnmanagedType.I4)]
int ProcessRequest([In] IntPtr ecb, [In, MarshalAs(UnmanagedType.I4)]
int useProcessModel);

The ecb parameter is the ISAPI Extension Control Block (ECB) which is passed as an unmanaged resource to ProcessRequest. The method then takes the ECB and uses it as the base input and output interface used with the Request and Response objects. An ISAPI ECB contains all low level request information including server variables, an input stream for form variables as well as an output stream that is used to write data back to the client. The single ecb reference basically provides access to all of the functionality an ISAPI request has access to and ProcessRequest is the entry and exit point where this resource initially makes contact with managed code.

The ISAPI extension runs requests asynchronously. In this mode the ISAPI extension immediately returns on the calling worker process or IIS thread, but keeps the ECB for the current request alive. The ECB then includes a mechanism for letting ISAPI know when the request is complete (via ecb.ServerSupportFunction) which then releases the ECB. This asynchronous processing releases the ISAPI worker thread immediately, and offloads processing to a separate thread that is managed by ASP.NET.

ASP.NET receives this ecb reference and uses it internally to retrieve information about the current request such as server variables, POST data as well as returning output back to the server. The ecb stays alive until the request finishes or times out in IIS and ASP.NET continues to communicate with it until the request is done. Output is written into the ISAPI output stream (ecb.WriteClient()) and when the request is done, the ISAPI extension is notified of request completion to let it know that the ECB can be freed. This implementation is very efficient as the .NET classes essentially act as a fairly thin wrapper around the high performance, unmanaged ISAPI ECB.

ref:west-wind

findoneof in CF

2010-03-22T06:51:00.000-07:00

Finds the first occurrence of any one of a set of characters in
a string, from a specified start position. The search is case-sensitive.
The position of the first member of set found in string; or 0, if no
member of set is found in string.

Syntax:
FindOneOf(set, string [, start ])

Parameter Description
set A string or a variable that contains one.
String that contains one or more characters to search for.
string A string or a variable that contains one. String in which to search.
start Start position of search.

Program:

#findoneof("aeiou",stringToSearch)#

#findoneof("aeiou",stringToSearch,4)#

#findoneof("@%^*()",stringToSearch)#

Source: http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functi82.htm#wp1104557

MVS SYSTEM CODES - SC13

2010-03-20T06:45:00.000-07:00

An error occurred in opening a concatenated partitioned data set.
1. A concatenated data set was opened for output. 2. A data set was opened twice. Be sure that the concatenated partitioned data set is being opened properly.

Ref: www.ibmmainframes.com

MVS SYSTEM CODES -SD37

2010-03-18T06:44:00.000-07:00

An error occurred in writing to a data set which had not been allocated enough space. 1. A secondary allocation was not specified, and all of the primary space had been used. 2. There was a program loop.

1. Check through the program logic for a loop.
2. Allocate more space to the data set by specifying larger primary and/or secondary quantities in the space parameter in the JCL DD statement.

Ref: www.ibmmainframes.com

Notepad as a diary

2010-03-17T06:43:00.000-07:00

1. Open a blank Notepad file
2. Write .LOG as the first line of the file, followed by a enter. Savethe file and close it.
3. Double-click the file to open it and notice that Notepad appends the current date and time to the end of the file and places the cursor on the line after.
4. Type your notes and then save and close the file.
5. Each time you open the file, Notepad repeats the process, appending the time and date to the end of the file and placing the cursor below it

OTA, an API for extending Quality Center

2010-03-15T05:24:00.000-07:00

Quality Center API
The manipulation API is called Quality Center API and allows the interaction with Quality Center.

It also allows you to interact with the database through the API making the interactions more secure. Also, it avoids your DBA (DataBase Administrator) having to provide an access to the database server(s) hosting the Quality Center database(s).The API has only 1 entry point which is the TDConnection object. From this object, you can access a lot of Quality Center functionalities. The API functions are accessible through VBScript and any COM aware programming languages. It means that you can use this API as a standalone .VBS application, a macro in an Excel file, a script in QuickTest Professional or any other application where you would like to integrate such functionalities.As an example, we are going to download all the defects that are stored on a Quality Center project using the Excel application.The steps involve:
Connect to the project Run a query to retrieve a list of defects Store the result in an Excel worksheet

1. Connect to the project:
Each project stored in a Quality Center server is identified by its pair Domain/Project and a project is accessible only if the user belongs to this project. The connection to a server can be done by using only 4 lines of code:Dim QCConnection‘ Return the TDConnection object.Set QCConnection = CreateObject(“TDApiOle80.TDConnection”)QCConnection.InitConnectionEx “http:///qcbin”QCConnection.login “”, “”‘ DEFAULT = Domain, QualityCenter_Demo = ProjectQCConnection.Connect “DEFAULT”, “QualityCenter_Demo”

2. Execute a query:
To execute a query in Quality Center, you have several options available.The first one is to use the Command object. This object can run SQL queries for any Quality Center table. However, you need to be aware of what table to query and make sure you know what you do because you can mess up Quality Center. Also, this Command object can be used only if you are part of the TDAdmin group in this project.The second one is to use a Factory object. The factory object returns objects that are part of the API, restricting the user from making mistakes. This is the method we’ll be using in this article. To access the defects, we are using the BugFactory:Dim BugFactory, BugListSet BugFactory = QCConnection.BugFactorySet BugList = BugFactory.NewList(“”) ‘ Get a list of all the defects.

3. Store the result in an Excel worksheet:
We assume that you are running this script from a VBS file. Consequently, we have to open Excel first, then store the data in an Excel worksheet:

Dim Bug, Excel, Sheet
Set Excel = CreateObject(“Excel.Application”) ‘ Open Excel
Excel.WorkBooks.Add() ‘ Add a new workbook
‘ Get the first worksheet.
Set Sheet = Excel.ActiveSheetDim Bug, Row
Row = 1
‘ Iterate through all the defects.
For Each Bug In BugList
‘ Save a specified set of fields.
Sheet.Cells(Row, 1).Value = Bug.Field(“BG_BUG_ID”)
Sheet.Cells(Row, 2).Value = Bug.Summary
Sheet.Cells(Row, 3).Value = Bug.DetectedBy
Sheet.Cells(Row, 4).Value = Bug.Priority
Sheet.Cells(Row, 5).Value = Bug.Status
Sheet.Cells(Row, 6).Value = Bug.AssignedTo
Row = Row + 1
Next‘ Save the newly created workbook and close Excel.
Excel.ActiveWorkbook.SaveAs(“c:\QualityCenter_Demo_DEFECTS.xls”)
Excel.Quit

Workflow Authoring - Workflow Foundation WF32

2010-03-13T05:19:00.000-08:00

Workflow Authoring:
Authoring of workflows can use code, markup languages, or a combination of both code and markup.

Types of Authoring modes:
1. Code only:
The default authoring mode for windows workflow foundation is code only. This provides the code behind mode.(C# or VB) to declare the workflow structure. A code only workflow must be compiled. This mode shoud be choosed only if the workflow solution will not change over a time.
2. No Code:
This mode provides the author a workflow by using workflow markup. we can then compile the workflow with the Windows Workflow Foundation command-line workflow compiler, or we can load the workflow markup file into the workflow runtime engine.
If we have a workflow definition entirely in XOML we can use workflow activation and avoid compilation. Activation is useful when building a large number of dynamic workflows. We merely need to pass the XML into the workflow runtime to have a run-able instance of a workflow.
Eg:

3. Code seperation:
This mode provides us to define workflows by using workflow markup and combining it with C# or Visual Basic code-behind implementations—similar to the ASP.NET model.The code only workflow must be compiled. This mode is choosed if the workflow will change over a time.Also complex business rules can be handled in this mode.

RSS to PDF believe me its possible

2010-03-11T05:34:00.000-08:00

Many of you must have felt the same as myself with busy schedule and always on move or offline. Just happen to view your RSS reader found something interesting but don’t have time to read it online. If you are facing the same problem, at last I have found a solution to it. Now you can convert your RSS feeds to PDF online and that too free of cost and read it when you are on move or offline.

RSS 2 PDF (http://www.rss2pdf.com/) is a free online service that turns any RSS feed to PDF document at a lightening speed. Along with RSS, this service also converts other sources like ATOM and OPML to PDF. The only problem with the service is - images of the RSS source are not part of the output PDF. Due to server resource usage restrictions, the creator of the service temporarily disabled images in the output.

So what are you waiting for, start converting your favorite feed and read at your leisure time.

Cross-site scripting (XSS)

2010-03-09T05:02:00.000-08:00

Cross-site scripting (XSS) attacks exploit vulnerabilities in Web page validation by injecting client-side script code. Common vulnerabilities that make your Web applications susceptible to cross-site scripting attacks include failing to properly validate input, failing to encode output, and trusting the data retrieved from a shared database. To protect your application against cross-site scripting attacks, assume that all input is malicious. Constrain and validate all input. Encode all output that could, potentially, include HTML characters. This includes data read from files and databases.

The injected script code embeds itself in response data, which is sent back to an unsuspecting user. The user's browser then runs the script code. Because the browser downloads the script code from a trusted site, the browser has no way of recognizing that the code is not legitimate, and Microsoft Internet Explorer security zones provide no defense. Cross-site scripting attacks also work over HTTP and HTTPS (SSL) connections.

One of the most serious examples of a cross-site scripting attack occurs when an attacker writes script to retrieve the authentication cookie that provides access to a trusted site and then posts the cookie to a Web address known to the attacker. This enables the attacker to spoof the legitimate user's identity and gain illicit access to the Web site.

source : msdn

Java program for image decompression

2010-03-07T05:00:00.000-08:00

This is a java program to decompress the given image.we have first initialized the given file using file input stream reader and read character by character from input file and copied into the target file and displayed the size of the image.The program is as follows.

import java.io.*;
import java.util.zip.*;
class Izip{public static void main(String args[])throws Exception
{
InflaterInputStream in=new InflaterInputStream(new FileInputStream("Ashes.zip"));
FileOutputStream sout=new FileOutputStream("Ashes.bmp");
int b;
while((b=in.read())!=-1)
sout.write(b);
in.close();
sout.close();
File f1=new File("Ashes.zip");
File f2=new File("Ashes.bmp");
System.out.println("The size of zipped file is "+f1.length());
System.out.println("The size of unzipped file is "+f2.length());
}
}

OUTPUT:
C:\jdk1.3\bin>javac Izip.java
C:\jdk1.3\bin>java IzipThe size of zipped file is 1372The size of unzipped file is 589878

List of EIB fields in DFHEIBLK member in CICS

2010-03-05T04:57:00.000-08:00

EIBCALEN(COMMAREA Length): It will be the length of the Communication area.
EIBAID(AID Key pressed): It gives the attention of the user has entered any attention key or not
EIBCPOSN(CURSOR Position): It gives positions of the cursor
EIBDATE(Task DATE (00YYDDD)): It gives Task Date
EIBTIME(Task Time (0HHMMSS)): It gives Task time
EIBTRNID(Transaction ID of Task): It gives the transaction of task has stored
EIBTRMID(Terminal ID of Task): It has the terminal ID and it is different from entry in PCT
EIBRSRCE(Resource Recently): Recently used Resource Name
EIBDS(Data Set): Recently accessed Data Set
EIBFN(Final CICS Command): Last CICS Command
EIBRESP(Response): Completion Status
EIBRESP2(Response2): More Completion Status
EIBRCODE(Response Code (OLD)): Response Code (OLD)

compare in ColdFusion

2010-03-03T04:54:00.000-08:00

Performs a case-sensitive comparison of two strings.

-1, if string1 is less than string2
0, if string1 is equal to string2
1, if string1 is greater than string2

Syntax :
Compare(string1, string2)

Parameter Description

string1 A string or a variable that contains one

string2 A string or a variable that contains one

Compares the values of corresponding characters in string1 and string2.

Coding :

Source: http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functi37.htm#wp1101820

Facilities used in CICS.

2010-03-01T04:51:00.000-08:00

Facilities used in CICS:
- Transaction Dump
- Execution Diagnostic Facility(EDF)
- Command Level Interpreter

Transaction Dump:
It Contains useful information which shows the status of the program at the time of an ABEND

Execution Diagnostic Facility(EDF):
- CICS supplied transaction
- Monitors the execution of an application program as an interactive debugging aid

Command Level Interpreter:
- CICS supplied transaction that performs syntax checking
- To invoke

CECI (CICS command to be interpreted)
CEBR Transaction(CICS transaction which browses Temporary Storage Queue (TSQ) Invoking CEBR directly)

One of Unix Command

2010-02-28T04:50:00.000-08:00

1.Esc :set nonu
This command is used to take off the line numbers that gets displayed in a unix program.

2.Esc :set nu
This brings back the Line numbers of the Unix program.

Get up-to-the minute data with Excel’s automatic Web queries

2010-02-26T04:49:00.000-08:00

An Excel Web query allows you to bring data from a Web site into an Excel worksheet. It will find any tables on the Web page and let you select the ones containing data you want to put into your worksheet, allowing for dynamic updates from the Web page. Web queries are not just useful for pulling information from standard HTML pages. They can also be used quite nicely in situations where a standard ODBC connection would be difficult or impossible to create or maintain, such as a worksheet that’s used by salespeople around the country.I am going to explain how to use the web query through a basic example to get a feel for how Web queries operate. Before delving into minute details, here is a basic procedure to import data through web query.

Getting started:
To demonstrate the process, we’re going to start with a simple Web query using cricinfo score card. To create the Web query:
1.Select the first cell in which you want results to appear.
2.Choose Data Import External Data New Web Query to open the dialog box shown (see attachment , Fig A)
3. Enter the URL to query in the Address area and click the Go button ( see attachment, Fig B)
4. Navigate to the desired page. Select the table you want to use for the query ( see attachment, fig C)
5. Click the Import button. In the next dialog, enter cell number or worksheet where you want to import data
That’s it. The data is now in your worksheet ( see attachment , Fig D)
6. Once the table is loaded, you can right click anywhere on it and say Refresh Data! and it would fetch the new data from web automatically

Some ISPF Tips

2010-02-24T04:48:00.000-08:00

Tip1:
While trying to open any member in a PDS, we sometimes come across "member in use" message. In that situation, if you want to know who is using the member currently, press F1 twice.

Tip2:
To find the last 10 datasets those we have accessed
1. GO TO ISPF 3.4 option.
2. On the top, there is a MENUBAR. Select REFLIST
3. Select Option 1 in it.
Using this option you can find out the last 30 datasets that you have accessed….

Tip3:
To know what are the last 25 COMMAND LINE commands that issued from ISPF panel.
To get that issue RETP on the Command line.

Tip 4:
Suppose you are in a ISPF Screen and want to know in which TSO Region ( Development, Production, or other TSO regions) you are now .
Issue on the command line : SAREA
ISPF STATISTICS Pop-up window will show you the region( and other info too)

Tip 5:
When we issue CUT , we know that the CUT content are placed in a clipboard. And when we issue PASTE, the clipboard content are pasted. But is it possible for us to view/edit the clipboard ?
One can view the clipboard after any valid CUT command was issued.
To view the clipboard, issue : CUT DISPLAY.
Clipboard manager will pop up and gives us options to edit or browse the content.

Tip 6:
Here is another tip on ISPF CUT. I have a dataset with 10,000 lines.I want to cut the first 10 lines and last 10 lines and paste into another dataset.When I cut the first 10 lines and then again the last 10 lines ,only the last 10 lines are pasted into the new dataset. Is there anyway out (other than doing a 2 cut & paste)?
The answer for the above question is to:
1.first cut 10 lines, then issue CUT APPEND
2.then cut last 10 lines, then issue CUT APPEND
3.When you PASTE it, you got both.

Ref:www.fresherscircle.com

Replace in CF

2010-02-22T04:45:00.000-08:00

Replaces occurrences of substring1 in a string with substring2, in a specified scope. The search is case-sensitive.

Syntax:
Replace(string, substring1, substring2 [, scope ])

Parameter Description
string String in which to search
substring1 String for which to search
substring2 String that replaces substring1
scope one: replace the first occurrence (default)
all: replace all occurrences

To remove a string, specify the empty string ("") as substring2.
You do not need to escape comma characters in strings.

Program:
#Replace(FORM.myString, FORM.MySubstring1, FORM.mySubString2)#

Source: http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functa68.htm#wp1111342

Getting Cookie ID

2010-02-20T04:44:00.000-08:00

This code gets the cookie id of current page without using WebUtil in QTP.

theCookie= Browser("micClass:=Browser").Page("micClass:=Page").Object.Cookie
pos=InStr(1,theCookie,"/",1)
cookieID= mid(theCookie, pos + 1, 16)

Getting Active Object deatils

2010-02-18T04:43:00.000-08:00

Browser("").page("").Object.activeElement.Name
Browser("").page("").Object.activeElement.Value
Browser("").page("").Object.activeElement.ID

Asynocronous Data Table Loading

2010-02-16T04:42:00.000-08:00

When you have a very large datatable and QTP starts to read the datatable objects before it is getting fully loaded. Also if the the .sync is not working
You can use Asynocronous Data Table Loading

oldRowCount=0
While (oldRowCount<>B().P().WebTable().RowCount)
oldRowCount=B().P().WebTable().RowCount
Wait 3Wend

Point to remember while using Sybase Central

2010-02-14T04:40:00.000-08:00

Problem:
Sybase central's SQL window is different from oracle's sql+ in atleast one way. If we have done updates or deletes accidentally in the SQL+ window, in oracle we can just issue a rollback and get back whatever we have lost but sybase central doesnt provide us with any such luxury. The only way to get back the data is to manually insert it again.

Hence it is very important for us to take control of transactions. So before we do any processing give this command

begin tran my_tran
do all the processing in the transaction andfinally after we are done with everything, if we need to rollback we just have to issue a rollback
rollback my_tran which will rollback all the statements issued inside the transaction.
Hence make sure you start each SQL window of sybase central with begin tran tran_name

From Browser to ASP.NET

2010-02-13T06:24:00.000-08:00

Let’s start at the beginning of the lifetime of a typical ASP.NET Web Request. A request starts on the browser where the user types in a URL, clicks on a hyperlink or submits an HTML form (a POST request). Or a client application might make call against an ASP.NET based Web Service, which is also serviced by ASP.NET. On the server side the Web Server – Internet Information Server 5 or 6 – picks up the request.

At the lowest level ASP.NET interfaces with IIS through an ISAPI extension. With ASP.NET this request usually is routed to a page with an .aspx extension, but how the process works depends entirely on the implementation of the HTTP Handler that is set up to handle the specified extension. In IIS .aspx is mapped through an ‘Application Extension’ (aka. as a script map) that is mapped to the ASP.NET ISAPI dll - aspnet_isapi.dll. Every request that fires ASP.NET must go through an extension that is registered and points at aspnet_isapi.dll.

Depending on the extension ASP.NET routes the request to an appropriate handler that is responsible for picking up requests. For example, the .asmx extension for Web Services routes requests not to a page on disk but a specially attributed class that identifies it as a Web Service implementation. Many other handlers are installed with ASP.NET and you can also define your own. All of these HttpHandlers are mapped to point at the ASP.NET ISAPI extension in IIS, and configured in web.config to get routed to a specific HTTP Handler implementation. Each handler, is a .NET class that handles a specific extension which can range from simple Hello World behavior with a couple of lines of code, to very complex handlers like the ASP.NET Page or Web Service implementations.

For now, just understand that an extension is the basic mapping mechanism that ASP.NET uses to receive a request from ISAPI and then route it to a specific handler that processes the request.

Ref:west-wind

The ISAPI Connection

2010-02-11T06:23:00.000-08:00

ISAPI is a low level unmanged Win32 API. The interfaces defined by the ISAPI spec are very simplistic and optimized for performance. They are very low level – dealing with raw pointers and function pointer tables for callbacks - but they provide he lowest and most performance oriented interface that developers and tool vendors can use to hook into IIS. Because ISAPI is very low level it’s not well suited for building application level code, and ISAPI tends to be used primarily as a bridge interface to provide Application Server type functionality to higher level tools. For example, ASP and ASP.NET both are layered on top of ISAPI as is Cold Fusion, most Perl, PHP and JSP implementations running on IIS as well as many third party solutions such as my own Web Connection framework for Visual FoxPro. ISAPI is an excellent tool to provide the high performance plumbing interface to higher level applications, which can then abstract the information that ISAPI provides. In ASP and ASP.NET, the engines abstract the information provided by the ISAPI interface in the form of objects like Request and Response that read their content out of the ISAPI request information. Think of ISAPI as the plumbing.

For ASP.NET the ISAPI dll is very lean and acts merely as a routing mechanism to pipe the inbound request into the ASP.NET runtime. All the heavy lifting and processing, and even the request thread management happens inside of the ASP.NET engine and your code.

As a protocol ISAPI supports both ISAPI extensions and ISAPI Filters. Extensions are a request handling interface and provide the logic to handle input and output with the Web Server – it’s essentially a transaction interface. ASP and ASP.NET are implemented as ISAPI extensions. ISAPI filters are hook interfaces that allow the ability to look at EVERY request that comes into IIS and to modify the content or change the behavior of functionalities like Authentication. Incidentally ASP.NET maps ISAPI-like functionality via two concepts: Http Handlers (extensions) and Http Modules (filters).

ref:west-wind

Retrieving the contents of a ZIP file

2010-02-09T06:22:00.000-08:00

This Java tip illustrates a method of listing the contents of a ZIP file. Developer may use this as a functionality for its users to first see the contents of the ZIP file and then decompress the chosen one.
try {
ZipFile sourcefile = new ZipFile("source.zip");
for (Enumeration entries = sourcefile.entries(); entries.hasMoreElements();) {
String zipEntryName = ((ZipEntry)entries.nextElement()).getName();
}
} catch (IOException e) {
}

Source: java-tips.org

cfsilent in CF

2010-02-08T06:20:00.000-08:00

cfsilent:
Suppresses output produced by CFML within a tag's scope.
This tag requires an end tag.

Syntax:

…

Program:

cfsilent

Inside cfsilent block
b-a = #c#

b-a = #c#

Source : http://livedocs.adobe.com/coldfusion/6.1/htmldocs/tags-pc7.htm#wp1103549

Factors to differentiate entity bean and session bean

2010-02-06T06:19:00.000-08:00

The following factors differentiate entity and session bean. They are - :

persistence
Shared access
Primary key
Relationship
Container managed persistence
Abstract schema
Multiplicity in container managed relationship
Direction in container managed relationship

Source : http://www.hi.is/pub/cs/2002-03/hv1/j2eetutorial/doc/EJBConcepts4.html

How do you make a link open in a new window or tab?

2010-02-05T06:18:00.000-08:00

This tip that helps us to make links open up in new tabs or windows. When you create the hyperlink, add target="_blank" just after you mention the url and before you close the tag.

For example, you want to hyperlink Click here to navigate to Google Maps and you want that to open up in a new window, then this is how you do it --
you say: Click Here

Change the Internet Properties in a single command!!

2010-02-03T06:17:00.000-08:00

1) Press WINDOWS+ R key to get the Run command box.
2) Type "Inetcpl.cpl" to get the Internet Properties window. Make the necessary changes in that Screen.

View your site in different Browsers

2010-02-01T06:16:00.000-08:00

I usually test my site for Firefox and Internet Explorer 6. Firefox has a very useful extension called IE Tab than allows you to view web pages in Firefox using the Internet Explorer engine.
This is where Browsershots.org will come in handy for many. Browsershots takes screenshots of your web page for different browsers.
To view the web design for different browsers:
1. Go to Browsershots.
2. Submit your URL and Click Start.
This will lead you to a 'Select browsers and configurations' page where you can specify the browsers and other configurations like javascript, screen resolutions, color depth etc…Click Submit Jobs.
3. On submission, your website will be added to a job queue. You can view the queue status from the Queue page.The screenshots of your site will appear after some time in the Screenshots page.

Source: http://txpress.blogspot.com/2006_12_01_archive.html

Sharing info on MQ Cluster

2010-01-30T02:36:00.000-08:00

A cluster is a network of queue managers that are logically associated in some way. In a Web Sphere MQ network using distributed queuing without clustering, every queue manager is independent. If one queue manager needs to send messages to another it must have defined a transmission queue and a channel to the remote queue manager.If you group queue managers in a cluster, the queue managers can make the queues that they host available to every other queue manager in the cluster.

Then, assuming that you have the necessary network infrastructure in place, any queue manager can send a message to any other queue manager in the same cluster without the need for explicit channel definitions, remote queue definitions, or transmission queues.There are two different reasons for using clusters: to reduce system administration and to improve availability and workload balancing.

Use special characters from Windows

2010-01-28T02:37:00.000-08:00

Symbols like £ (UK Pound), © (Copyright), ¥(Japanese Yen) can be easily used by following a few simple steps:
1. Firstly, these characters are not provided as keys with the keyboard. So stop staring at the keyboard.
2. Go to Start >> Programs >> Accessories >> System Tools >> Character Map.This opens the Character Map as shown below.
3. This window displays all the possible charaters you can enter.

Click on any of the symbols to get an enlarged view.
Then, click on the Select button to select a character.
To copy the selected symbol, press the Copy button (the symbol is actually copied to the clipboard).

4. That's it! Now you can paste the character where you need it.

Also notice the lower-right corner of the Character Map screen. This displays the keystroke required to produce the character you want.
In the figure above its Alt+0163. This means if you Press and Hold the ALT key and type 0163, you will get the UK Pound symbol.
( NOTE: the numbers must be typed from the keys to the right of your keyboard and NOT from the keys above the character keys).

Source: http://txpress.blogspot.com/2006/11/use-special-characters-from-windows.html

Few commands on MQM

2010-01-26T02:35:00.000-08:00

To create a queue manager: crtmqm (to make it the default, specify theParameter /q)To start the queue manager: strmqm
To start the utility in an interactive mode: runmqsc
To run Mq commands in a wrapper : runmqadm

cfinclude in ColdFusion

2010-01-24T02:34:00.000-08:00

cfinclude
Embeds references to ColdFusion pages in CFML.
You can embed cfinclude tags recursively.

Syntax :

ColdFusion searches for included files in the following sequence:
In the directory of the current page
In directories mapped in the ColdFusion Administrator for the included file
The included file must be a syntactically correct and complete CFML page.For example, to output data from within the included page, you must have a cfoutput tag, including the end tag, on the included page, not the referring page. Similarly, you cannot span a cfif tag across the referring page and the included page; it must be complete within the included page.

Program:

Source :
http://livedocs.adobe.com/coldfusion/6.1/htmldocs/tags-p63.htm#wp1100248

Flex Development on Visual Studio

2010-01-22T02:33:00.000-08:00

Well, this is came a little late but I think anticipated. Though not from Microsoft itself, but seems developers on Visual studio are also feeling it. After all the noise regarding the new front ends from all around; AJAX, SilverLight, JAVAFX etc, SWF seems to be on top. Here are two more IDEs for SWF development and that to on Flex Framework and on top of Visual Studio. Amethyst and Tofino.

Amethyst comes in 2 flavors Personal and Professional. Personal Edition is Free as well. According to its makers, SapphireSteel Software, The personal edition will be completely free and may optionally be installed into the free Visual Studio ‘shell’ edition. Amethyst Personal (beta) will be available from Amethyst site in the 2nd week of December 2008. Amethyst Professional will be released in beta in the first quarter of 2009 and the final version is expected to ship in the 2nd quarter.

Tofino is from the company named Ensemble . Its ready to be downloaded from their site and as per the company, Ensemble Tofino is available for free.

Some of the Control commands in CICS

2010-01-20T02:30:00.000-08:00

Interval Control: All these commands can control the intervals(time)
- ASKTIME
- FORMATTIME
- DELAY
- POST
- WAIT EVENT
- START
- RETRIEVE
- CANCEL

ASKTIME:
- To request the current data and time

FORMATTIME:
- To receive information of date and time in various formats

DELAY:
- Used to DELAY the processing of a task

START:
- Used to start a transaction at the specified terminal and at the specified time or interval
- Data can be passed to the new transaction

RETRIEVE:
- Used to retrieve the data passed by the START

CANCEL:
- Used to cancel the Interval Control requests like DELAY,POST and START
- Identified by REQID.

Task control commands in CICS

2010-01-18T01:50:00.000-08:00

Task Control: We have some commands to control the Task, and command are given below.
- SUSPEND
- ENQ
- DEQ

SUSPEND:
- After the execution of higher priority tasks, control will be returned to the suspended task

EXEC CICS
SUSPEND
END-EXEC

ENQ:
- To gain exclusive control over a resource

Syntax:
EXEC CICS ENQ
RESOURCE(data area)
[LENGTH(data value)]
[NOSUSPEND]
END-EXEC

DEQ:
- To free the exclusive control from the resource gained by ENQ

Syntax:
EXEC CICS DEQ
RESOURCE(data_area)
[LENGTH(data_value)]
[NOSUSPEND]
END-EXEC.

cfhtmlhead in ColdFusion

2010-01-16T01:48:00.000-08:00

Writes text to the head section of a generated HTML page. It is useful for embedding JavaScript code, or putting other HTML tags, such as meta, link, title, or base in an HTML page header.
Syntax:

Note:
If you use this tag after the cfflush tag on a page, an error is thrown.

Program:

">

Source: http://livedocs.adobe.com/coldfusion/6.1/htmldocs/tags-p57.htm#wp1099843

Rich Internet Applications(RIA’s)

2010-01-14T01:47:00.000-08:00

Rich Internet applications (RIAs) offer a rich, engaging experience that improves user satisfaction and increases productivity. Using the broad reach of the Internet, RIAs can be deployed across browsers and desktops.

Benefits of RIAs:
RIAs offer organizations a proven, cost-effective way to deliver modern applications with real business benefits:

Offer users a richer, more engaging experience.
Keep pace with users' rising expectations.
Increase customer loyalty and generate higher profits.
Leverage existing personnel, processes, and infrastructure.

Source : http://www.adobe.com/resources/business/rich_internet_apps/

Technologies to develop Rich Applications

2010-01-12T01:46:00.000-08:00

Technologies for building Rich applications:

Adobe Flex : http://www.adobe.com/products/flex/
Microsoft Silverlight: http://silverlight.net/
JavaFX: http://javafx.com/
OpenLaszlo: http://www.openlaszlo.org/

Building first Flex App

2010-01-10T01:44:00.000-08:00

Prerequisites:
1.Download Flex Builder 3 from
http://www.adobe.com/cfusion/entitlement/index.cfm?e=flex3email
2.Install Flex Builder
3.Install Adobe Flash player 9 plugin for Internet explorer

Creating first project in Flex:
1.Run the Flex builder
2.Click on File -> New -> Flex Project
3.In the New Flex Project dialog: >Enter Project Name as "MyFirstApp" >Check the Use Default Location checkbox >Select Web application as Application type >Select Application Server type as None >Click on Finish
4.MyFirstApp.mxml will be opened in the editor
5.In between the tag add the line below, which adds a label with text My First Appin blue color to the application:

Windows tabs Shortcut

2010-01-08T01:43:00.000-08:00

Try this shortcut !
Instead of using ALT + TAB,
Try, windows key + TAB.
Press ENTER to open the active window

END task in windows

2010-01-06T01:41:00.000-08:00

If an application or a page is hanged, normally we would go to task manager and select that application or page and then we would click on End Task !
It would take sometime to end that application, we got look at the hanged monitor till it closes it and then resume our work.
But, do we know that we have an easier way to close that application ?
Here is it !
Goto the task manager window, and select the Processes tab, and then select the corresponding process and say end process.
It will immediately close it !
The only difficulty is, to find the corresponding process.
The key is that the process would be named in relation to the application.
For eg : notepad.exe, OUTLOOK.EXE, iexplore.exe ( Browser window )
You will get used to finding the process, once you start using it !

Unix Command on sessions

2010-01-04T01:39:00.000-08:00

Unix command to check all the active sessions which are currently running.
ps –ef grep rts
ps : Reports the process status
-e: List information about every process now running.
-f: Generate a full listing
rts:Request To Send, RTS is a signal sent by a communications device, such as a modem, to verify if the other device is ready for data to be sent to it.

If you have some issues in unix for example like “license on the server expired”, by giving the above command you can find all the active sessions running on that server.So by killing all the unused or expired sessions your issue may be resolved.Command to kill the session
kill %pid
Kill: cancels a job
Pid-A job control job ID that identifies a background process group to be signaled.

Reading a zip file

2010-01-02T01:38:00.000-08:00

This sample code read the name of all files from a zip file. It uses ZipInputStream to read zip file.

import java.io.*;
import java.util.zip.*;

public class ZipFileRdrExp {

public static void main(String[] args) {

try {

FileInputStream fis = new FileInputStream("C:\\MyZip.zip");
ZipInputStream zis = new ZipInputStream(fis);
ZipEntry ze;
while((ze=zis.getNextEntry())!=null){
System.out.println(ze.getName());
zis.closeEntry();
}

zis.close();

} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
}

Source: java-tips.org

Writing a Zip file

2009-12-31T01:37:00.000-08:00

This sample code shows the method to create a Zip file and add files to it. It uses ZipOutputStream to write zip file.

import java.io.*;
import java.util.zip.*;

public class ZipFileWrtExp {

public static void main(String[] args) {

try {
FileOutputStream fos = new FileOutputStream("C:\\MyZip.zip");
ZipOutputStream zos = new ZipOutputStream(fos);
ZipEntry ze= new ZipEntry("C:\\file1.txt");
zos.putNextEntry(ze);
zos.closeEntry();

ze= new ZipEntry("C:\\file2.txt");
zos.putNextEntry(ze);
zos.closeEntry();
zos.close();

} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}

}
}

Source: java-tips.org

Sample MAP complier in CICS.

2009-12-29T01:36:00.000-08:00

This is the samle map complier, you can use this to compile the maps.

//MAPCOM@ JOB MSGCLASS=X,MSGLEVEL=(1,1),CLASS=A,
// REGION=5M,NOTIFY=&SYSUID
//STEP1 EXEC DFHMAPS,
// DSCTLIB='&HLQ.CICS.COPY',
// MAPLIB='&LOADHLQ.CICS.LOAD',
// MAPNAME='&MAPNAME'
//COPY.SYSUT1 DD DSN=&HLQ.CICS.BMS(MEMBER),DISP=SHR

Listing the image formats that can be read and written

2009-12-27T01:35:00.000-08:00

This Java tip illustrates a method of listing the image formats that can be read and written. The complete list of available readable and writeable formats can be retrieved by calling ImageIO.getReaderFormatNames() and ImageIO.getWriterFormatNames(). By default, the javax.imageio package can read GIF, PNG, and JPEG images and can write PNG and JPEG images.

// Get list of unique supported read formats
String[] formatNames = ImageIO.getReaderFormatNames();
formatNames = unique(formatNames);
// e.g. png jpeg gif jpg

// Get list of unique supported write formats
formatNames = ImageIO.getWriterFormatNames();
formatNames = unique(formatNames);
// e.g. png jpeg jpg

// Get list of unique MIME types that can be read
formatNames = ImageIO.getReaderMIMETypes();
formatNames = unique(formatNames);
// e.g image/jpeg image/png image/x-png image/gif

// Get list of unique MIME types that can be written
formatNames = ImageIO.getWriterMIMETypes();
formatNames = unique(formatNames);
// e.g. image/jpeg image/png image/x-png

// Converts all strings in 'strings' to lowercase
// and returns an array containing the unique values.
// All returned values are lowercase.
public static String[] unique(String[] strings) {
Set set = new HashSet();
for (int i=0; i String name = strings[i].toLowerCase();
set.add(name);
}
return (String[])set.toArray(new String[0]);
}

source:java-tips.org

cfobjectcache in CF

2009-12-25T01:32:00.000-08:00

The main function is to clear the occupied memory
and free the memory space.Flushes the query cache.

Syntax:

Attribute Req/Opt Description

action Required clear:Clears queries from the cache in the Application scope

Source : http://livedocs.adobe.com/coldfusion/6.1/htmldocs/tags-b11.htm#wp2310692

Risks to e-mail

2009-12-23T07:53:00.000-08:00

There are several inherent risks in the way e-mail functions. When you send e-mail to a recipient, it travels to an SMTP (Simple Mail Transfer Protocol) server either directly (if you’re using an e-mail client such as Outlook) or via a Web server (if you’re using Web-based mail, such as Hotmail). The recipient will receive your e-mail directly from the SMTP server or via a Web server.
During this journey, any unauthorized person can access your messages by exploiting vulnerabilities on the SMTP or Web servers. Your messages can be read and copied by anyone who has access to the computers and networks through which your messages travel. In fact, authorized system administrators on the SMTP servers can also read, copy, save, delete, and modify your messages before sending them on.
During this ‘eavesdropping’, it may be possible to gain access to your usernames and passwords. The mischief-monger can then wreak havoc by sending messages on your behalf. You may also receive messages from known e-mail IDs that have been created and sent by unauthorized users; such messages usually contain viruses, Trojans or ask you to reply to the message with sensitive personal information, such as bank-account or credit-card details.
What’s more, mail backups on SMTP servers store the e-mail in plain text; sometimes, messages that you sent or received years ago are easily available on these backups, long after you have deleted them.
The issues with e-mail are, therefore, manifold - the sender’s e-mail ID may be stolen and misused, without the recipient knowing about it; messages may be intercepted; or messages may be stored such that their content is easily accessible.
Encryption, digital signatures, and digital certificates are some ways of securing e-mail from these threats.

Ref:India syndicate

Reading an Image from a file, inputStream, or URL

2009-12-21T07:52:00.000-08:00

This Java tip illustrates a method of reading an Image from a file, inputStream, or URL. This tip also includes displaying of an image on the screen. Further, javax.imageio package is used to read an image from a file. This example works only above J2SE 1.4.

Image image = null;
try {
File sourceimage = new File("source.gif");
image = ImageIO.read(sourceimage);

InputStream is = new BufferedInputStream(
new FileInputStream("source.gif"));
image = ImageIO.read(is);

URL url = new URL("http://java-tips.org/source.gif");
image = ImageIO.read(url);
} catch (IOException e) {
}

JFrame frame = new JFrame();
JLabel label = new JLabel(new ImageIcon(image));
frame.getContentPane().add(label, BorderLayout.CENTER);
frame.pack();
frame.setVisible(true);

Ref: java-tips.org

Need to know more about file extensions?

2009-12-19T07:51:00.000-08:00

Its a very intresting site to search more about the file extensions….

There are just TOO many of them this days.

ComputerFileExtensions.com that seem to be a nice resource for file extension and file formats.

On that site there exist a big database of all kind of file extensions you may come across and a good search facility to make it easier to find any file type you may looking for. I found there MXML and as too. Anyway, there is a way to see details on each file extension and it tells that extension.

Compiling Flex application from command line

2009-12-17T07:49:00.000-08:00

Prerequisites:
1. If Flex builder is not installed download Flex 3 SDK from http://www.adobe.com/products/flex/flexdownloads/index.html#sdk
2. Unzip it to c:\adobe\. In this case installDir = c:\adobe\
3. If Flex builder 3 is already installed check the install directory. Assuming installDir = c:\Adobe\
4. Java should be installed in the system.
5. Flash player should be installed in the system.

Creating and compiling Flex Application:
Open notepad or any editor and copy the code below:

http://www.adobe.com/2006/mxml" layout="vertical" width="100%" height="100%">

1. Save it as Text.mxml in c:\temp\
2. Open command prompt window.
3. installDir\sdks\3.x.x\bin\mxmlc.exe c:\temp\Test.mxml (installDir = c:\adobe)
4. It should be compiled to Test.swf in c:\temp

MVS SYSTEM CODES -S80A

2009-12-15T07:48:00.000-08:00

The storage needed to execute the program was not available.
1. The region parameter did not specify enough storage.
2. The region parameter was omitted, and the default storage amount was too small to run the correct program.
3. Block sizes were increased or buffers were added, and the region size was not increased.
4. A logic error caused excessive storage to be obtained but not freed.

1. Increase the region size.
2. Look for logic errors which may cause excessive calls to other programs or requests for storage.

Ref: www.ibmmainframes.com

Digital IDs and Signatures

2009-12-13T07:47:00.000-08:00

Having a digital ID enables you to add another layer of security to your e-mail via digital signatures. A digital ID ties your identity information—name or e-mail ID, for instance—with your public key.
When you use this ID to digitally sign your messages, a part of your message is encrypted with your private key, so that the recipient knows that the message came from you; if you encrypt the message in addition, then the signature and the message are encrypted with your public key. This enables the recipient to know whether the message has been accessed or modified en route.
Digital IDs are provided via e-mail certificates, which are usually issued by external certification authorities (CAs). In organizations, sometimes, the administrator of your Exchange Server generates these certificates for users.
If you use Outlook, you can get e-mail certificates from CAs. Some like Comodo offer these free of charge for personal use; for commercial use, different schemes are available from various CAs. source:India syndicate

Concept of 3G

2009-12-11T07:46:00.000-08:00

There will be a wide range, from simple single-application devices such as voice-only phones, to multi-purpose communicators capable of handling several voice, data and video services in parallel.

To date, the "terminal" for accessing mobile services has been the mobile phone. With the coming of 3G, we can expect to see a broadening of this concept to include a whole host of new terminals. These will be both general-purpose computing and communications devices, and devices with more specific purposes to serve particular marker segments. There will still be recognizable mobile phones. But many of these will have larger screens to display Internet pages or the face of the person being spoken to. There will be smaller "smart-phones" with limited web browsing and e-mail capabilities. The addition of mobile communications capabilities to laptop and palmtop computers will speed up the convergence of communications and computing, and bring to portable computing all the functions and features available on the most powerful desktop computers. There will be videophones, wrist communicators, palmtop computers, and radio modem cards for portable computers. Innovative new voice based interfaces will allow people to control their mobile communication services with voice commands.

We will also see the integration of 3G into a very wide range of devices and products other than user terminals. For example, the "telephone-on-a-card" will allow mobile services to be built into business equipment, vehicles and household appliances, for dedicated applications. Devices such as phones, computers and digital cameras will also be able to communicate with each other using short-range radio. Digital cameras will be able to use wide-area radio communications in real time and reduce the need for bulky memory and other components.

How to enable HOT deployment scanner in JBoss ?

2009-12-09T07:43:00.000-08:00

Steps :

Open the file $JBOSS_HOME/server/[Instance Name]/conf/jboss-service.xml
Search for "ScanEnabled"
The enable to the Hot deployment scanner as below
true
You can set the Automatic scan period for Hot deployment,
5000
Restart the service once you made the changes.

cfupdate in CF

2009-12-07T07:41:00.001-08:00

Updates records in a data source from data in a ColdFusion form or form Scope.

Syntax :

Attribute - description

dataSource- Name of the data source that contains the table. tableName- Name of table to update. tableOwner- For data sources that support table ownership tableQualifier- For data sources that support table qualifiers. username- Overrides username value specified in ODBC setup.password- Overrides password value specified in ODBC setup.formFields-Comma-delimited list of form fields to update.

Note :
If a form field is not matched by a column name in the database, ColdFusion throws an error.
The formFields lies must include the database table primary key field, which must be present in the form. It can be hidden.

Program :

SELECT Course_Number, Course_ID, DescriptFROM CoursesWHERE Course_ID = #Trim(url.Course_ID)#ORDER by Course_Number

Source : http://livedocs.adobe.com/coldfusion/6.1/htmldocs/tags-c19.htm#wp1104662

Saving a BufferedImage to a PNG file

2009-12-05T07:39:00.000-08:00

You can save a BufferedImage object using write method of the javax.imageio.ImageIO class. The signutaure of the method is like this:
public static boolean write(RenderedImage im,
String formatName,
File output)
throws IOException

Here im is the RenderedImage to be written, formatName is the String containg the informal name of the format (e.g. png) and output is the file object to be written to. An example usage of the method for PNG file format is shown below:
ImageIO.write(image, "png", file);

You can also use getReaderFormatNames method of the same class to learn available informal format names understood by the current set of registered readers.

source: java-tips.org

Protecting Worksheet Names in Excel!!

2009-12-03T07:38:00.000-08:00

If you are developing workbooks for others to use, you may want your worksheets to retain whatever names you give them. Excel normally allows users to change worksheet names, as desired. If you don't want them to change, the only way to prevent it is to lock the workbook. You can take these steps if you are using a version of Excel prior to Excel 2007:

1.Display the Review tab of the ribbon.
2.Click Protect Workbook in the Changes group. Excel displays the Protect Structure and Windows dialog box. (Click here to see a related figure.)
3.Make sure that the Structure check box is selected.
4.Enter a password in the Password box.
5.Click on OK. Excel displays the Confirm Password dialog box, prompting you to reenter the password.
6.Reenter the password and click on OK.

The user can no longer make changes to the names of the worksheet tabs, nor to anything else that affects the structure of the workbook. (For instance, they cannot enter new worksheets or delete existing ones.)

If you want to protect the workbook under the control of a macro, then you can use this code:
ActiveWorkbook.Protect Password:="MyPassword", Structure:=TrueAll you need to do is provide password you want to use in place of the "MyPassword" example.

Source: http://excel2007.tips.net/Pages/T0102_Protecting_Worksheet_Names.html

Adobe squeezes AIR out of beta for Linux users

2009-12-01T07:37:00.000-08:00

Adobe just released the beta version of Adobe AIR for Linux on Adobe Labs!
This Labs release of AIR has all features implemented for Linux, except support for DRM and badge installations. Major new features include support for system tray icons, keyboard shortcuts, localization, internationalized input (IME support), filetype registration, SWF and PDF in HTML, multi-monitor support, fullscreen mode, encrypted local storage, support for V4L2 cameras and printing.

The list of supported distributions has also been updated to:
1. Ubuntu 7.10
2. Fedora 8
3. OpenSuSE 10.3

Any AIR application that works on Windows/Mac AIR release version 1.1 should ideally work on Linux too

IIS 6 – Viva the Application Pool

2009-11-30T07:36:00.000-08:00

IIS 6 changes the processing model significantly in that IIS no longer hosts any foreign executable code like ISAPI extensions directly. Instead IIS 6 always creates a separate worker process – an Application Pool – and all processing occurs inside of this process, including execution of the ISAPI dll. Application Pools are a big improvement for IIS 6, as they allow very granular control over what executes in a given process. Application Pools can be configured for every virtual directory or the entire Web site, so you can isolate every Web application easily into its own process that will be completely isolated from any other Web application running on the same machine. If one process dies it will not affect any others at least from the Web processing perspective.

In addition, Application Pools are highly configurable. You can configure their execution security environment by setting an execution impersonation level for the pool which allows you to customize the rights given to a Web application in that same granular fashion. One big improvement for ASP.NET is that the Application Pool replaces most of the ProcessModel entry in machine.config. This entry was difficult to manage in IIS 5, because the settings were global and could not be overridden in an application specific web.config file. When running IIS 6, the ProcessModel setting is mostly ignored and settings are instead read from the Application Pool. I say mostly – some settings, like the size of the ThreadPool and IO threads still are configured through this key since they have no equivalent in the Application Pool settings of the server.

Because Application Pools are external executables these executables can also be easily monitored and managed. IIS 6 provides a number of health checking, restarting and timeout options that can detect and in many cases correct problems with an application. Finally IIS 6’s Application Pools don’t rely on COM+ as IIS 5 isolation processes did which has improved performance and stability especially for applications that need to use COM objects internally.

ref:west-wind

MVS SYSTEM CODES-S804

2009-11-28T07:33:00.000-08:00

The storage needed to execute the program was not available.

1. The region parameter did not specify enough storage.
2. The region parameter was omitted, and the default storage amount was too small to run the correct program.
3. Block sizes were increased or buffers were added, and the region size was not increased.
4. A logic error caused excessive storage to be obtained but not freed.

1. Increase the region size.
2. Look for logic errors which may cause excessive f calls to other programs or requests for storage.

Ref: www.ibmmainframes.com

Encrypting e-mail

2009-11-26T07:35:00.000-08:00

Encryption means scrambling the text of your message to a seemingly gibberish combination of letters and numbers, so that anyone who reads it en route can make no sense of it. Only the recipient is able to decrypt the message.
Using public keys is the most common form of encryption. This requires the use of two keys - a public key and a private key. The private key resides on your computer and you share the public key with the recipients to which you wish to send encrypted messages. When you wish to send the message, you encrypt it with the public key. On the other end, the recipient needs its own private key and your public key to decrypt the message. Since the message is decrypted using your public key, it proves that you sent the message. You can encrypt messages as well as attachments.
If you use Outlook as your e-mail client, encryption is built into it via digital IDs, which enable you to encrypt your message and digitally sign it as well. You can also use the popular public-key encryption system, PGP (Pretty Good Privacy), with Outlook itself and with other e-mail clients. This utility is available as freeware on Source: www.pgpi.org.

IIS 6 – Viva the Application Pool

2009-11-24T07:34:00.000-08:00

Although IIS 6 application pools are separate EXEs, they are highly optimized for HTTP operations by directly communicating with a kernel mode HTTP.SYS driver. Incoming requests are directly routed to the appropriate application pool. InetInfo acts merely as an Administration and configuration service – most interaction actually occurs directly between HTTP.SYS and the Application Pools, all of which translates into a more stable and higher performance environment over IIS 5. This is especially true for static content and ASP.NET applications.

An IIS 6 application pool also has intrinsic knowledge of ASP.NET and ASP.NET can communicate with new low level APIs that allow direct access to the HTTP Cache APIs which can offload caching from the ASP.NET level directly into the Web Server’s cache. In IIS 6, ISAPI extensions run in the Application Pool worker process. The .NET Runtime also runs in this same process, so communication between the ISAPI extension and the .NET runtime happens in-process which is inherently more efficient than the named pipe interface that IIS 5 must use. Although the IIS hosting models are very different the actual interfaces into managed code are very similar – only the process in getting the request routed varies a bit.

MVS SYSTEM CODES-S806

2009-11-22T07:31:00.000-08:00

A module requested by the program could not be found.

1. The module requested did not exist in the data sets specified in the STEPLIB or JOBLIB.
2. A JCL STEPLIB or JOBLIB DD statement was missing or incorrect.
3. The module name was misspelled.
4. An I/O error occurred in searching for the module in the library directory.

1. Verify that the correct program is being requested.
2. Ensure that the appropriate STEPLIB or JOBLIB DD statements are in the JCL.
3. If necessary, recreate the data set.
Ref: www.ibmmainframes.com

AS/400 Tip 2

2009-11-20T07:29:00.000-08:00

Data Areas are chunks of memory to hold a few control values. A typical use is to keep track of the last invoice number for a system.

To create a data area, use the command
CRTDTAARA (Create Data Area).
For example, to create a 100 character data area named LASTINV#:
CRTDTAARA DTAARA(MYLIB/LASTINV#) TYPE(*CHAR) LEN(100)
Now, load the first 10 positions with the value "AA12345678" with the CHGDTAARA (Change Data Area) command
CHGDTAARA DTAARA(QTEMP/LASTINV# (1 10)) VALUE('AA12345678')
Look at the value of the data area with DSPDTAARA (Display Data Area):
DSPDTAARA MYLIB/LASTINV# A CL program can retrieve the value with RTVDTAARA.
An RPG program uses the "IN" operation to retrieve the value and the "OUT" operation to change it. There is a special Data Area known as the LDA (Local Data Area). It is 1024 characters and is associated with a job. So, any display session has an LDA associated with it. Not only that, when a job is submitted to run in batch, the LDA gets sent with the job so the batch job can read the LDA of the display session that submitted it.

View and change your LDA by using *LDA instead of a data area name:
DSPDTAARA *LDA CHGDTAARA DTAARA(*LDA (1 10)) VALUE('AA12345678')
Using the LDA is considered by many to be an obsolete style. Older programs use the LDA to store and pass parameters.

Source: http://www.texas400.com/b400tip1.html

AS/400 Tip 1

2009-11-18T07:30:00.000-08:00

Converting an AS/400 database file to a CSV file
You may find yourself in a situation where you want to run a Query on a file, save the information to a database,and then convert that information to a Comma Separated Variable (CSV) file. This is especially true when you need the data to be used in a "spread sheet" format like Excel.
The simplest way to do this is to copy the information from the data file to your newly created CSV file.

Enter this command:
CPYTOIMPF FROMFILE(*LIBL/DTAFIL) TOFILE(USER999/CSVPC)
Hit Enter, and then again 3 times and you have now created a Comma Separated Variable (CSV) File.
Remember that you need a 'destination file' before you can use this command. To create a 'destination file', you will need to use the Create Physical File command. To create a file named CSVPC that is 200 characters in length, type in the command:
CRTPF FILE(USER999/CSVPC)
Hit F4 to prompt the command, and type in the record length you need, for Member, be sure to name it CSV.

Source: http://www.texas400.com/b400tip23.html

CHARSET Statement

2009-11-16T07:27:00.000-08:00

The CHARSET statement specifies the contents of one or more of the character segments of a library character set module. A library character set module consists of header information followed by 64 character segments. Each character segment contains the character's 6-bit code for a WCGM location, its scan pattern, and its pitch. You can use the INCLUDE statement to copy an entire module, minus any segments deleted using the DELSEG keyword. In addition, you can use the CHARSET statement to select character segments from any module named with a library character set ID or the GCM keyword. The CHARSET statement can also specify the scan pattern and characteristics for a new character.

The CHARSET statement must always be followed by a NAME statement, another CHARSET statement, or one or more data statements. The CHARSET statement must be preceded by an OPTION statement with the DEVICE parameter if you want to create library character set modules in the 3800 Model 3 compatibility mode module format. The CHARSET statement can be preceded by an INCLUDE statement. More than one CHARSET statement can be coded in the operation group. The operation group can include CHARSET statements that select characters from existing modules and CHARSET statements that create new characters. The CHARSET statement, preceded by an INCLUDE statement, can be used to delete one or more segments from the copy of an existing module to create a new module.

A CHARSET statement with no operands specified, followed by a NAME statement that identifies a library character set module, is used to format and print the module.

Source : http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dgt1u104/7.5.7?DT=19990113105507

INCLUDE Statement

2009-11-14T07:26:00.000-08:00

When an IEBIMAGE operation group is used to create a new module, the INCLUDE statement can identify an existing image library module to be copied and used as a basis for the new module. When the operation group is used to update an image library module, the INCLUDE statement identifies the module to be referred to and must be specified.

When the INCLUDE statement is coded in an operation group, it must precede any FCB, COPYMOD, TABLE, GRAPHIC, or CHARSET statements.

Only one INCLUDE statement should be coded for each operation group. If more than one is coded, only the last is used; the others are ignored.

You can code an INCLUDE statement for an FCB module only if the DEVICE=4248 parameter is specified on the OPTION statement. Either 3211 format or 4248 format FCBs may be included. IEBIMAGE tries to locate the 4248 format FCB first; if it is not found, IEBIMAGE looks for the 3211 format. You cannot copy a 3800 FCB module with INCLUDE.

Source : http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dgt1u104/7.5.8?DT=19990113105507

Different ways to shut down your PC

2009-11-12T07:24:00.000-08:00

There are so many different ways to turn off your Windows XP computer, let's look at some of them:
1. The standard approach - click the Start Button with your mouse, then select the Turn Off menu and finally click the Turn Off icon on the Turn Off computer dialog.
2. Press Ctrl+Esc key or the Win key and press U two times - the fastest approach.
3. Get the Shutdown utility from Download.com - it adds the shut down shortcuts for you. Else create them yourself using approach (4).
4. Create a shutdown shortcut on your desktop. Right click on the desktop, choose New Shortcut and type shutdown -s -t 00 in the area where you are asked to specify the location of the program file. Now you can just double click this icon to turn off the computer. The best location would be your quick launch bar.
5. Press the Win key + R key to open the run window. Type shutdown -s -t 00. [s means shutdown while t means the duration after which you want to initiate the shutdown process]. If some open processes or application won't let you turn off, append a -f switch to force a shutdown by closing all active processes.
6. Win+M to minimize all windows and then Alt+F4 to bring the Turn Off computer dialog.
7. Open Windows Task manager (by right clicking the Windows Task bar or Alt+Ctrl+Del) and choose Shut down from the menu. Useful when the Windows are not responding.
8. open task manager - click on shutdown - hold the ctrl key and click on Turn off, pc will be turned off in 3 secs. Fastest method other than hard shutdown.

Create and Format an Excel in Asp.net

2009-11-10T07:19:00.000-08:00

A simple code snippet to create excel and write some date to cell from C#.
Step 1: Add reference to " microsoft excel 12.0 object library " in the project.
Step 2: Include the namespace " using Excel = Microsoft.Office.Interop.Excel; "
Step 3: In the click event of export button:
string strCurrentDir = Server.MapPath(".") + "\\";
Excel.Application excel = new Excel.ApplicationClass();
excel.Visible = false;
Excel._Workbook workbook = excel.Workbooks.Add(Missing.Value);
Excel.Sheets sheets = workbook.Worksheets;
Excel._Worksheet exlSheet = (Excel.Worksheet)sheets.get_Item("Sheet1");
summarySheet.Name = "Report Name";
Excel.Range headerRng = (Excel.Range)exlSheet .get_Range("A1", "B1");
headerRng.MergeCells = true; headerRng.Value2 = "Report Header";
headerRng.Font.Bold = true;
headerRng.Font.Name = "Arial";
headerRng.Font.Size = 18;
headerRng.WrapText = true;
headerRng.HorizontalAlignment = Excel.Constants.xlCenter;
headerRng.Interior.Color = System.Drawing.Color.Gray.ToArgb();
headerRng.Borders.Weight = 3;
headerRng.Borders.LineStyle = Excel.Constants.xlSolid;
headerRng.Cells.RowHeight = 30;
headerRng.EntireColumn.AutoFit();

workbook.SaveAs(strCurrentDir + "ExportReport.xls", Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, null, null, false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlShared, false, false, null, null, null);

Verifying a connection between the AS/400 and RPM

2009-11-08T03:46:00.000-08:00

To make a TCP/IP connection to RPM, the TELNET command may be used. To verify a connection, perform the following telnet test.

At the AS/400 command prompt, type TELNET and press F4
In the Start TCP/IP TELNET (TELNET) screen, press F9 to view "all parameters."
In the Remote System field, type *INTNETADR. Enter the IP address of the RPM host in the Internet Address field.
Locate the Port parameter and enter 515, then press Enter.

If RPM is configured to relax the 'port in range' requirement, this will input-inhibit the session if a connection is made. Close RPM (Windows 9x) or restart the RPM service (RPM Elite/Select) to release the AS/400 session. Then restart RPM and check the RPM log for new message.

If RPM is not configured this way, a new message should be displayed in the RPM log stating:
Client port xxxx out of range
Although this message is a warning, it verifies that a connection was made to RPM at port 515.

Source: http://www.brooksnet.com/faq/101-11.html

Finding and displaying hyperlinks in a web page

2009-11-06T03:43:00.000-08:00

The Java application written below uses regular expressions to find and display hyperlinks contained within a Web page. After compiling the file, you should save a Web page to the same folder that contains ShowLinks.class.

import java.io.*;
import java.util.regex.*;
public class ShowLinks {
public static void main(String[] arguments) {
if (arguments.length < 1) {
System.out.println("Usage: java ShowLinks [page]");
System.exit(0);
}
String page = loadPage(arguments[0]);
Pattern pattern = Pattern.compile(" Matcher matcher = pattern.matcher(page);
while (matcher.find()) {
System.out.println( matcher.group(1));
}
}

private static String loadPage(String name) {
StringBuffer output = new StringBuffer();
try {
FileReader file = new FileReader(name);
BufferedReader buff = new BufferedReader(file);
boolean eof = false;
while (!eof) {
String line = buff.readLine();
if (line == null)
eof = true;
else
output.append(line + "\n");
}
buff.close();
} catch (IOException e) {
System.out.println("Error – " + e.toString());
}
return output.toString();
}
}

java-tips.org