IBM i Access for Windows Toolkit - Data manipulation

This Delphi 4 sample uses the IBM i Access for Windows automation objects to perform the following:

• Retrieve the list of IBM i systems which have previously been connected
• Specify a new IBM i system to access
• Retrieve information about an IBM i, such as the: IP address, host version and release levels, password expiration date, number of active connections, etc.
• Call an IBM i Access for Windows API to retrieve a list of user libraries on the system
• Call an IBM i API to retrieve a list of data queues in a library
• Create and delete libraries
• Create and delete data queues
• Query the attributes of data queues
• Send and receive data using data queues
• Convert strings and numeric data between host and PC formats
• Retrieve information about the IBM i Access for Windows code installed on the PC

• Download d_allobj.exe (EXE, 124KB)

This Visual Basic sample uses the IBM i Access for Windows automation objects to perform the following:

• Retrieve the list of System is which have previously been connected
• Specify a new System i to access
• Retrieve information about an System i, such as the: IP address, host version and release levels, password expiration date, number of active connections, etc.
• Call an System i API to retrieve a list of user libraries on the system
• Call an System i API to retrieve a list of data queues in a library
• Create and delete libraries
• Create and delete data queues
• Query the attributes of data queues
• Send and receive data using data queues
• Convert strings and numeric data between host and PC formats
• Retrieve information about the IBM i Access for Windows code installed on the PC

• Download vballobj.exe (EXE, 34.2KB)

This Visual Basic samples uses the database automation objects to:

• Download an IBM i database file to an ASCII text file or to the display
• Upload an ASCII text file to an existing database file, by appending to the file or by replacing the contents of the file.

The IBM i Access for Windows conversion objects are also used to convert the data between IBM i and PC formats.

** Note: This samples requires service pack SF57098 or later in order to run.

• Download vbdbauto.exe (EXE, 84KB)

This Visual Basic Script sample uses the IBM i Access for Windows automation objects to perform the following:

• Retrieve the list of IBM i systems which have previously been connected
• Specify a new IBM i to access
• Retrieve information about an IBM i, such as the: IP address, host version and release levels, password expiration date, number of active connections, etc.
• Call an IBM i API to retrieve a list of user libraries on the server
• Call an IBM i API to retrieve a list of data queues in a library
• Create and delete libraries
• Create and delete data queues
• Query the attributes of data queues
• Send and receive data using data queues
• Convert strings and numeric data between host and PC formats
• Retrieve information about the IBM i Access for Windows code installed on the PC

This sample requires the file cwbxvbs.inc which is installed in the Include directory as part of the IBM i Access for Windows Toolkit. This file must be in the same directory as the files from this sample.

Note: If you get the following error while running this script:
"ActiveX component can't create object: 'createobject'"
please see Microsoft Knowledge Base article Q195826.

• Download vbsallob.exe (EXE, 31.3KB)

This sample demonstrates how an application might use the cwbNL_ConvertCodePages to convert files between ASCII and EBCDIC.

The sample expects four parameters:

1. source file name
2. source code page
3. target file name
4. target code page

The sample reads the source file, converts it from the source code page to the target code page, and saves the result to the target file.

• Download convsamp.exe (EXE, 20.8KB)

This sample demonstrates using the IBM i Access for Windows Remote Program Call APIs, National Language Support APIs, and the Service APIs to call an OS/400 API and return its output to the PC.

• Download rcsamp1x.exe (EXE, 22KB)

This sample demonstrates using the IBM i Access for Windows Run Command API to call an OS/400 command and if an error occurs, retrieve message help for the error message.

• Download rcsamp2x.exe (EXE, 22KB)

This program allows the user to pick which translation should be executed from a standard Windows pull-down menu. For each type of translation there is a dialog box that will be displayed on the screen to allow the user to enter values to be translated. When the OK button is pressed, or the enter key is pressed with the cursor in the entry field, the translation will be performed and the results will be displayed. This process will continue until the Cancel button is pressed.

• Download wdtsampx.exe (EXE, 28.8KB)