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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DB2: Extract definition of a global temp table created using “as select”
Frederico, Version is Db2 9.7. Operating system=linux. The type of temp table is GTT (global temporary table). Inside the DBI Pert script, the GTT is created in database A using "create temporary table xyz as select a.column1, b.column2, ...". Then, in the same DBI Perl script, I need to... -
DB2: Extract definition of a global temp table created using “as select”
In a perl dbi script, I create a db2 temp table on database A using "as select" to define columns. Then, I need to redefine the temp table on another database B. Does any of you have any hints on how to generate the ddl of the global temp table on database A?
