Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2007
    Posts
    3

    Unanswered: Problem with Create Schema

    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.

  2. #2
    Join Date
    May 2003
    Posts
    113
    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)


    Quote Originally Posted by new_here
    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.

  3. #3
    Join Date
    Sep 2007
    Posts
    3
    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.

  4. #4
    Join Date
    May 2003
    Posts
    113
    Quote Originally Posted by new_here
    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. :-)

  5. #5
    Join Date
    Sep 2007
    Posts
    3
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •