Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 3 Tools : @STATICSQL

@STATICSQL
Defines and generates static SQL to be used to access DB2 data. (E)
Invocation
Do one of the following:
Usage Notes
Pressing Enter displays the screen illustrated here:

 
Defining Static SQL for use by DB2 Server
Assemble modules generated Link Static SQL Handlers Re-Bind DB2 Server
Member DB2
MetaStor Table DB2 Table Status Pre/Suffix Vers
---------------- ---------------------------------------- ------ -- ----> ----
_ @DB2FSTRXDB HURON.HRNTRXDB
_ @EXTNDB2TRXDB EZSA0.TRXDB
_ @SYSCOLUMNS SYSIBM.SYSCOLUMNS
_ @SYSTABLES SYSIBM.SYSTABLES
_ DAT2 ABC20.PREDICATE_TABLE
_ DB2 FGH30.CLAIMS82
_ DB2_BRANCH OST00.BRANCH G PFC V2.3
_ DB212 USR20.PREDICATE_TABLE
_ DB251 USR20.PREDICATE_TABLE
_ DB5 USR20.STRUCTURE_TABLE
_ HAIG_DB2 OST68.HRNPREMIUM
_ NJSDB2 MNO30.T00 I T00 V2.3
_ NJSDB2COL SYSIBM.SYSCOLUMNS
_ NJSDB2COL6000 DB26000.SYSIBM.SYSCOLUMNS
_ NJSDB2TBL SYSIBM.SYSTABLES
G=GENERATE R=REMOVE
PFKEYS: 1=HELP 3=GENERATE(ONLINE) 15=GENERATE(BATCH) 12=CANCEL

 
See Also
TIBCO Service Gateway for DB2 Installing and Operating for information on @STATICSQL.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved