DB2 Version 9.7 for Linux, UNIX, and Windows

REXX samples

AIX directory: sqllib/samples/rexx. Windows directory: sqllib\samples\rexx.

Table 1. REXX sample program files.
Sample file name	File description
`blobfile.cmd`	Demonstrates Binary Large Object (BLOB) manipulation.
`chgisl.cmd`	Demonstrates the CHANGE ISOLATION LEVEL API.
`client.cmd`	Demonstrates the SET CLIENT and QUERY CLIENT APIs.
`d_dbconf.cmd`	Demonstrates the API: GET DATABASE CONFIGURATION DEFAULTS
`d_dbmcon.cmd`	Demonstrates the API: GET DATABASE MANAGER CONFIGURATION DEFAULTS
`db_udcs.cmd`	Demonstrates the CREATE DATABASE and DROP DATABASE APIs to simulate the collating behavior of a DB2 for MVS/ESA CCSID 500 (EBCDIC International) collating sequence
`dbcat.cmd`	Demonstrates the following APIs: `CATALOG DATABASE CLOSE DATABASE DIRECTORY SCAN GET NEXT DATABASE DIRECTORY ENTRY OPEN DATABASE DIRECTORY SCAN UNCATALOG DATABASE`
`dbcmt.cmd`	Demonstrates the following APIs: `CHANGE DATABASE COMMENT GET ERROR MESSAGE INSTALL SIGNAL HANDLER`
`dbconf.cmd`	Demonstrates the following APIs: `CREATE DATABASE DROP DATABASE GET DATABASE CONFIGURATION RESET DATABASE CONFIGURATION UPDATE DATABASE CONFIGURATION`
`dbinst.cmd`	Demonstrates the following APIs: `ATTACH TO INSTANCE DETACH FROM INSTANCE GET INSTANCE`
`dbmconf.cmd`	Demonstrates the following APIs: `GET DATABASE MANAGER CONFIGURATION RESET DATABASE MANAGER CONFIGURATION UPDATE DATABASE MANAGER CONFIGURATION`
`dbstart.cmd`	Demonstrates the START DATABASE MANAGER API
`dbstat.cmd`	Demonstrates the following APIs: `REORGANIZE TABLE RUN STATISTICS`
`dbstop.cmd`	Demonstrates the following APIs: `FORCE USERS STOP DATABASE MANAGER`
`dcscat.cmd`	Demonstrates the following APIs: `ADD DCS DIRECTORY ENTRY CLOSE DCS DIRECTORY SCAN GET DCS DIRECTORY ENTRY FOR DATABASE GET DCS DIRECTORY ENTRIES OPEN DCS DIRECTORY SCAN UNCATALOG DCS DIRECTORY ENTRY`
`dynamic.cmd`	Demonstrates the use of a "CURSOR" using dynamic SQL
`ebcdicdb.cmd`	Demonstrates the CREATE DATABASE and DROP DATABASE APIs to simulate the collating behavior of a DB2 for MVS/ESA CCSID 037 (EBCDIC US English) collating sequence
`impexp.cmd`	Demonstrates the EXPORT and IMPORT APIs
`lobeval.cmd`	Demonstrates deferring the evaluation of a LOB within a database
`lobfile.cmd`	Demonstrates the use of LOB file handles
`lobloc.cmd`	Demonstrates the use of LOB locators
`lobval.cmd`	Demonstrates the use of LOBs
`migrate.cmd`	Demonstrates the MIGRATE DATABASE API
`nodecat.cmd`	Demonstrates the following APIs: `CATALOG NODE CLOSE NODE DIRECTORY SCAN GET NEXT NODE DIRECTORY ENTRY OPEN NODE DIRECTORY SCAN UNCATALOG NODE`
`quitab.cmd`	Demonstrates the API: QUIESCE TABLESPACES FOR TABLE
`rechist.cmd`	Demonstrates the following APIs: `CLOSE RECOVERY HISTORY FILE SCAN GET NEXT RECOVERY HISTORY FILE ENTRY OPEN RECOVER HISTORY FILE SCAN PRUNE RECOVERY HISTORY FILE ENTRY UPDATE RECOVERY HISTORY FILE ENTRY`
`restart.cmd`	Demonstrates the RESTART DATABASE API
`sqlecsrx.cmd`	An example of a collating sequence
`updat.cmd`	Uses dynamic SQL to update a database