DB2的临时表建立(CGTT)
摘要:
1CreateGLOBALTEMPORARYTABLE<table_name>(2<column_name><column_datatype>,3<column_name><column_datatype>,4…)5ONCOMMIT[PRESERVE|DELETE]ROWS6[NOTLOGGED|LOGGED]ONROLLBACK[PRESERVE|DELETE]ROWS7DISTRIBUTEBYHASH(col1,..)8IN<tspace-name>;9 阅读全文
posted @ 2011-07-27 22:22 gongwei911 阅读(3588) 评论(0) 推荐(0) 编辑