MVSFORUMS.com

[satyenderd]

Hi I am getting the following error while creating a table as an existing table, Could anyone of you pls help me. Thanks in Advance.

CREATE TABLE TABLE02 00010023
AS (SELECT * FROM creator.tablename);
---------+---------+---------+---------+---------+---------+---------+---------+
DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "<END-OF-STATEMENT>". SOME
SYMBOLS THAT MIGHT BE LEGAL ARE: DATA WITH <IDENTIFIER>
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 502 0 0 -1 104 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'000001F6' X'00000000' X'00000000' X'FFFFFFFF'
X'00000068' X'00000000' SQL DIAGNOSTIC INFORMATION
_________________
Satya