sqlsym

Description

SQLSYM is a tool which execute 'select' request against a Rdb database and return the results into DCL symbols.

This version has been build with the help of André Roelants (aroelant@be.oracle.com) que je remercie.

It can be, also, download from Metalink.

Example

$ sqlsym/database=my_database - select rdb$relation_name,rdb$cardinality, rdb$created - from rdb$relations limit to 2 rows $ sh sym *_1 RDB$CARDINALITY_1 == "215" RDB$CREATED_1 == "25-MAY-1999 10:54:12.72" RDB$RELATION_NAME_1 == "TABLE_A " $ sh sym *_2 RDB$CARDINALITY_2 == "3060" RDB$CREATED_2 == "25-MAY-1999 10:54:14.31" RDB$RELATION_NAME_2 == "TABLE_B " $ sh sym *count* SQLSYM_ROWCOUNT == "2" Construction SQLSYM.ZIP includes the sources, the build procedure, the object files, and the executable. These build procedures are for Rdb V7.0 and OpenVMS Alpha V7.2. The objects and executable are from a build on the same versions. SQLSYM will also run on other Rdb and VMS versions as well as on a VAX, but the build procedures will need some modifications. After building sqlsym.exe, define the command: $ set command sqlsym $ define sqlsym disk:[directory]sqlsym.exe Files: Sources: SQL_DYNAMIC.C SQL_DYNAMIC_C.SQLMOD SQLSYM.C SYMROW.C Command Definition: SQLSYM.CLD Procédures de construction: BUILD_SQLSYM.COM LC.TPU Fichiers créés:

SQL_DYNAMIC_C.H SQLSYM.OBJ SQL_DYNAMIC.OBJ SQL_DYNAMIC_C.OBJ SYMROW.OBJ SQLSYM.EXE

Download

sqlsym.zip