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 "JOE". 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;

Am I missing anything that is supposed to be a prerequisite for creating schema. I tried some mauals but did not get lot of help.

Thanks for all the help.

you can't explicit create a schema in DB2/zos. There is not such 'create schema' stmt.

But you can implicit create it. For example
CREATE TABLE NIDM.TABLE1;
or
CREATE FUNCTION NIDM.FUNC1.

DB2 will create schema 'NIDM' for you(if not exists yet)

Thanks for the response NIDM.

I did the other approach you have mentioned.

So when you say there is not such thing as CREATE SCHEMA for DB2 on z/OS do you mean that command is not available only on DB2 for z/OS but is present with DB2 UDB etc. because I can very well see that command documented in the manual please find the link below.

http://publib.boulder.ibm.com/infoce...n/t0004972.htm

Please let me know if I am missing something here.

the manual you are referring to is DB2 for LUW, not DB2 for z/OS. Although we are trying very hard to make both DB2 compatible, there is still gap.

That is another reason that post with the DB2 spec is encouraged here. :-)

Thanks for clarifying NIDM. I guess I just searched the web with Create SCHEMA and got a LUW manual. I need to better choose my manuals I guess.

Thanks again for letting me know about this.