IBM Support

IBM i Access for Windows Toolkit - Data manipulation

A listing of sample programs to help develop applications using the IBM i Access for Windows data manipulation APIs.

data manipulation,windows toolkit,ibm i access for windows toolkit

The following sample programs are available to help develop applications using the IBM i Access for Windows data manipulation APIs:


ActiveX automation objects

  • d_allobj.exe – Delphi 4 sample using the IBM i Access for Windows automation objects.

    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
  • vballobj.exe – Visual Basic sample using the IBM i Access for Windows automation objects.

    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
  • vbdbauto.exe – Visual Basic sample using the database automation objects.

    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.

  • vbsallob.exe – Visual Basic Script sample using the IBM i Access for Windows automation objects.

    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.


C/C++ APIs

[{"Product":{"code":"HW1A1","label":"IBM Power Systems"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"--","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

More support for:
IBM Power Systems

Software version:
Version Independent

Operating system(s):
IBM i

Document number:
664457

Modified date:
03 May 2021

UID

isg3T1027243

Manage My Notification Subscriptions