DB2: Extract definition of a global temp table created using “as select”

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dbadmin
    New Member
    • May 2015
    • 2

    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?

    Mike
Working...