I'm attempting to run this sql through WinSql.
export to orders.del of del
select * from session.temp_em p
;
The session.temp_em p is a temporary table. I'm trying to extract the records out of the tempoary table into a flat file. I'm getting the following error message:
Error: SQL0104N An unexpected token "ORDERS" was found following "". Expected tokens may include: "IS <HEXSTRING> <CHARSTRING> <GRAPHSTRING> ". SQLSTATE=42601
(State:42601, Native Code: FFFFFF98)
Any help would be appreciated? Is export the right command in DB2?
export to orders.del of del
select * from session.temp_em p
;
The session.temp_em p is a temporary table. I'm trying to extract the records out of the tempoary table into a flat file. I'm getting the following error message:
Error: SQL0104N An unexpected token "ORDERS" was found following "". Expected tokens may include: "IS <HEXSTRING> <CHARSTRING> <GRAPHSTRING> ". SQLSTATE=42601
(State:42601, Native Code: FFFFFF98)
Any help would be appreciated? Is export the right command in DB2?