9/30/08 Use SQL to have i5/OS automatically handle a data type conversion

Use SQL (or any other HLL) to compare character and graphic data in two different products where their database CCSIDs are different (e.g. CCSID 65535 and CCSID 13488). This can be done without handling the data type conversion within SQL itself. All you need to do is to ensure the SQL program is running with job attributes that point to a system CCSID. When this is done, i5/OS automatically handles the conversion.


Disclaimer: Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held liable for the accuracy of information nor its compatibility in your own environment. Please review and test thoroughly before implementing. © Copyright 2008, Vision Solutions, Inc. All rights reserved. IBM, System i, iSeries, i5/OS and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.

09/23/08 How to always see correct field names for a physical file

To quickly see the fields that are available in a physical file without having to run a SQL statement use the DSPFFD command.

  1. Type from command line DSPFFD
  2. Press F4
  3. Type the File name and the Library where it is located
  4. Press Enter
You will see the all the column names in the file along with their descriptions.

This simple command is often superior to running a SQL statement because the names of fields in a file are not always correctly shown when using SQL. The DSPFFD command will always return the correct naming convention of the column names.



Disclaimer: Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held liable for the accuracy of information nor its compatibility in your own environment. Please review and test thoroughly before implementing. © Copyright 2008, Vision Solutions, Inc. All rights reserved. IBM, System i, iSeries, i5/OS and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.

09/16/08 How to map an IFS drive from a Windows PC

1. Go to My Computer and click Tools, then select Map Network Drive.
2. Select any drive Letter that in not in use. In the folder section you would put \\systemname\directory you would like access to, for example: \\PROD\TESTING.
3. You will be prompted for your user ID, which is your domain user ID (for example, Vision\AS400 Login ID), and your passoword, which is your i5/OS login password.

You will now have access to folders and files in this portion of the IFS. Going forward, all you need to do is go to My Computer and click on your mapped drive.


Disclaimer: Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held liable for the accuracy of information nor its compatibility in your own environment. Please review and test thoroughly before implementing. © Copyright 2008, Vision Solutions, Inc. All rights reserved. IBM, System i, iSeries, i5/OS and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.

9/09/08 Display contents of a command string

When you use an i5/OS command that is an IBM command, if you want to see what your command string is going to look like when it is executed, press F14 from the command line. The Display Command String screen will appear and show you all of the parms that you have changed. The screen will look something like this:

Display Command String


CPYF FROMFILE(HALA0A/EPIC)

TOFILE(QTEMP/EPIC)

CRTFILE(*YES)


This command is especially handy with longer commands. It is also useful if you need to cut and paste a command to another system.



Disclaimer: Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held liable for the accuracy of information nor its compatibility in your own environment. Please review and test thoroughly before implementing. © Copyright 2008, Vision Solutions, Inc. All rights reserved. IBM, System i, iSeries, i5/OS and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.

9/1/08 Change the default Java Runtime Environment for a specific user

To use a different version of Java as the default runtime environment for a specific user, create a new STMF file on the IFS within the home directory for the user as follows:

/home/UserPrf/SystemDefault.properties

Note: Replace underscored values with appropriate values.

This file should contain one line (e.g. 1.4, but it can be any version that is installed on the system), i.e.: java.version=1.4

Save and exit the file and that User will now be using this specified version of Java.



Disclaimer: Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held liable for the accuracy of information nor its compatibility in your own environment. Please review and test thoroughly before implementing. © Copyright 2008, Vision Solutions, Inc. All rights reserved. IBM, System i, iSeries, i5/OS and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.