REXXGDB2

Description from the author:

"REXXGDB2.DLL is a library of REXX functions for IBM OS/2 (WARP) that allow REXX programs to manipulate data in IBM Database 2 for OS/2 (DB2/2) database tables through SQL statements.

These REXX functions are designed to perform some SQL-specific tasks, rather than as a common REXX DB2/2 API for all SQL statements like IBM's SQLEXEC (which is included with each copy of IBM DB2/2).

The design allows the REXX functions to use static SQL (when they were built) and to be fine-tuned separately which make them overall faster compared to SQLEXEC."

The external REXX functions contained are (sorted alphabetically):

G2Commit

Issue DB2/2 SQL Commit to make changes permanent
G2ConnectExclusive
Connect to a DB2/2 database in exclusive mode
G2ConnectReset
Disconnect a previously connected DB2/2
G2ConnectShare
Connect to a DB2/2 database in share mode
G2CurDate
Get and return CURRENT (server system) DATE (as RESULT)
G2CurExplSnap
Get and return CURRENT EXPLAIN SNAPSHOT (as RESULT)
G2CurFuncPath
Get and return CURRENT FUNCTION PATH (as RESULT)
G2CurQueryOpt
Get and return CURRENT QUERY OPTIMIZATION (as RESULT)
G2CurServer
Get and return CURRENT SERVER name (as RESULT)
G2CurTime
Get and return CURRENT (server system) TIME (as RESULT)
G2CurTimeStamp
Get and return CURRENT (server system) TIMESTAMP (as RESULT)
G2CurTimeZone
Get and return CURRENT (server system) TIMEZONE (as RESULT)
G2DropFuncs
Unload (drop) all functions from internal memory
G2GetToken
Execute a DB2/2 SQL to obtain and increase a surrogate key
G2H
Write a string to a flat file, with or without HTML tag(s)
G2HSelect2Clob
Execute a DB2/2 SQL Select statement to get a CLOB and write it to a flat file
G2HSelect2Img
Execute a DB2/2 SQL Select statement to get a BLOB and write it to a flat file as HTML image element
G2HSelect2Input
Execute a DB2/2 SQL Select statement to get rows and columns of fields and write them to a flat file as HTML input elements
G2HSelect2List
Execute a DB2/2 SQL Select statement to get rows of data and write them to a flat file as HTML list elements
G2HSelect2Listbox
Execute a DB2/2 SQL Select statement to get rows and columns of fields and write them to a flat file as HTML select and option elements.
G2HSelect2Table
Execute a DB2/2 SQL Select statement to get rows and columns of fields and write them to a flat file as HTML table elements.
G2HSelect2Textarea
Execute a DB2/2 SQL Select statement to get rows and columns of fields and write them to a flat file as an HTML textarea element.
G2Immediate
Execute a DB2/2 SQL Execute Immediate for some SQL statements
G2LoadFuncs
Load all functions in the library into internal memory
G2Rollback
Issue DB2/2 SQL Rollback to cancel all uncommitted changes
G2SelectBlob
Execute a DB2/2 SQL Select statement to get a binary large object into a file.
G2SelectClob
Execute a DB2/2 SQL Select statement to get a text/character large object into a file.
G2SelectCols
Execute a DB2/2 SQL Select statement to get selected column names, datatype, and length in a 1-dimensional stem.
G2SelectData
Execute a DB2/2 SQL Select statement to get one or specified number of rows of raw data in a 2-dimensional stem.
G2SelectForm
Execute a DB2/2 SQL Select statement to get one or specified number of rows of formatted data and one heading line in a 1-dimensional stem.
G2SelectOne
Execute a DB2/2 SQL Select statement to return one row-column data (as RESULT)
G2SetConnection
Set database connection to current (from dormant)
G2SetCurExplSnap
Set CURRENT EXPLAIN SNAPSHOT (to NO, YES, or EXPLAIN)
G2SetCurPkgSet
Set CURRENT PACKAGESET (to use another collection)
G2SetCurQueryOpt
Set CURRENT QUERY OPTIMIZATION (to 0, 1, 3, 5, or 9)
G2User
Get and return the (connected) USER id. (as RESULT)

---

[Back: REXX/SQL]
[Next: RXSQL - REXX Interface for Sybase SQL-Server]