Create Schema: getting the error -104

rameshvs · New User Joined: 10 Aug 2007 Posts: 30 Location: atlanta

Hi..

I am trying to execute the following query through SPUFI and am getting the error -104. Anyone has any idea of what the possible reason could be

DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "ETPDBKR". SOME SYMBOLS THAT
MIGHT BE LEGAL ARE: TABLESPACE

I am new to this create schema thing .. This is my query

CREATE SCHEMA JOE AUTHORIZATION JOE;

Thanks for all the help.

dick scherrer · Posted: Wed Sep 19, 2007 3:19 am

Hello,

What is "ETPDBKR"?

Have you talked with your DBA(s)? That would be a good place to start.

rameshvs · New User Joined: 10 Aug 2007 Posts: 30 Location: atlanta

Hi Dick,

Thanks for your response, I am sorry for not getting back to you soon. I have searched some other forums and figured out that CREATE SCHEMA statement is not valid in DB2 for z/OS. Apparently the manual I was looking earlier was that of DB2 for LUW.

The workaroud for creating a schema is if you want a schema JOE to be created create a table JOE.* in the database and DB2 creates the schema.

Thanks
Ramesh.

dick scherrer · Posted: Fri Sep 21, 2007 9:28 pm

You're welcome

Too many versions of sql running around that are not the same

Thank you for posting what you found