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