Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by spine
-
System table name
You can get schemas and associated tablenames with this SQL. SELECT tabschema, tabname FROM sysstat.tables -
stored procedure in db2
Stored Procedures are written Java or C++ with the SQL embedded in the Java. Build an SQL String and use Prepared Statement Object to pass it to Db2 through default Connection. Default connection is what you use to connect to DB2 from a remote program.
