[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

[sqr-users] DB2 Global Temporary Table Command




In SQL server I have created a temporary table within a sqr using the Create
table  ##tablename   within DB2 this does not seem to work.  Can someone
give me an example of how to create a temp table in DB2 using the Declare
Global Temporary table command.  The examples I have use a 'like' command
and I am wanting to use a 'emplid CHAR (6), effdt DATE'  type of format

Thanks

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users