Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts FTP Skip or ignore error and process ... AJAYREDDY All Other Mainframe Topics 3 Wed Sep 27, 2017 8:12 pm
No new posts Assembler Macro Copybook converted to... Ziquilix PL/I & Assembler 4 Tue Sep 26, 2017 3:07 am
No new posts FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 1 Mon Sep 18, 2017 4:31 pm
No new posts Create procedure issues -628 when add... chandraBE DB2 1 Mon Sep 18, 2017 12:16 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us