MVSFORUMS.com

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

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

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

CREATE TABLE TABLE02
AS (SELECT * FROM CREATOR.TABLE);
_________________
Satya

jsharon1248 · Posted: Mon Jul 14, 2008 12:46 pm Post subject:

What tool are you using? SPUFI? QMF? CLP? Did you try this with the entire CREATE statement on one line?

kolusu · Posted: Mon Jul 14, 2008 1:01 pm Post subject:

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

Thanks for your response.

sorry for the above statement....

here is the correct one which i am using:

CREATE TABLE TABLE02
AS (SELECT * FROM CREATOR.TABLE);
_________________
Satya

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

Nic Clouston · Posted: Mon Jul 14, 2008 1:26 pm Post subject:

You still appear to have numbering on. Turn numbers off. (Make sure cols 73-80 are blank)
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

Terry_Heinze · Posted: Mon Jul 14, 2008 1:31 pm Post subject:

Satyender,
Please use BBCode to make your code more readable.
_________________
....Terry

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73