REXX Tips & Tricks, Version 2.80


Inf-HTML [About][Toc][Index] 0.9b (c) 1995 Peter Childs


REXXGDB2


Name     REXXGDB2 - A REXX interface 
         to DB/2 databases 
         (needs IBM DB2/2 Version 2.x)
Version  Version 1.30 8/97
Author   Simon Husin 
         (see EMail Addresses)
Distrib. Freeware 
Type     REXX DLL 
Price    -
Note     There is an additional archive 
         called REXXGUDB.* 
         that contains the version of 
         the DLL that is necessary to 
         access the 
         DB/2 Universal Database 
         version 5.0 for OS/2.
Source   BBS 
         Name: REXGDB2.* 

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) 
   

Inf-HTML End Run - Successful