Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Create Schema: getting the error -104

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
rameshvs
Currently Banned

New User


Joined: 10 Aug 2007
Posts: 30
Location: atlanta

PostPosted: Tue Sep 18, 2007 11:13 pm    Post subject: Create Schema: getting the error -104
Reply with quote

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.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Sep 19, 2007 3:19 am    Post subject:
Reply with quote

Hello,

What is "ETPDBKR"?

Have you talked with your DBA(s)? That would be a good place to start.
Back to top
View user's profile Send private message
rameshvs
Currently Banned

New User


Joined: 10 Aug 2007
Posts: 30
Location: atlanta

PostPosted: Fri Sep 21, 2007 7:31 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Sep 21, 2007 9:28 pm    Post subject:
Reply with quote

You're welcome icon_smile.gif

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

Thank you for posting what you found icon_biggrin.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm
This topic is locked: you cannot edit posts or make replies. Rexx to create GDG by scanning JJ result krish.deepu CLIST & REXX 5 Tue Oct 25, 2016 5:32 pm
No new posts Error during restore rename archanamuthukrishnan All Other Mainframe Topics 2 Fri Oct 14, 2016 3:30 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us