Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Recommended Posts

  • 4 weeks later...

Hi Chris,

 

Just like physical tables, you can either specify columns or use CREATE TABLE AS SELECT...

Here is the syntax:

 

CREATE[LOCAL]{TEMP | TEMPORARY} TABLE table-name{table-element-commalist}[ ON COMMIT {PRESERVE | DELETE} ROWS]

 

or:

 

CREATE[LOCAL]{TEMP | TEMPORARY} TABLE table-nameAS QUERY_EXPRESSION

 

NOTE, this works only in 7.0.4 and above.

 

Regards, Jason

Link to comment
Share on other sites

  • 1 month later...
  • 1 year later...

I don't think you can do this in an SQL Script, but rather, against a published database from an external db application.

 

Jason can correct me if I'm wrong.

 

Given the age of this post, if you need more help, it might be better to raise a new question.

Link to comment
Share on other sites

×
×
  • Create New...