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
 

 

Understanding SQLID and database qualifier specified in qrys

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

New User


Joined: 26 Oct 2006
Posts: 2
Location: White Plains, NY

PostPosted: Fri Nov 21, 2008 2:36 am    Post subject: Understanding SQLID and database qualifier specified in qrys
Reply with quote

Hi,

First time I am working with DB2 and I am trying to understand the difference between in setting SQLID and a database qualifier specified in executing dynamic sql statements in SPUFI.

I have a situation where I am using database qualifier ABC.<table-name> in SPUFI where as some of my colleagues been successful in running the same query with XYZ.<table-name>.

When I did to execute a query with select * from XYZ.<table-name>; it resulted me in errors giving SQLCODE = -204, saying undefined name in DB2 subsystem.

But when I tried to execute in this manner it executed successfully:
set current sqlid = 'xyz';
select count(*) from <table-name>;

I would like to understand is that Userids accessing DB2 tables matters in this scenario. Appreciate in your knowledge share on this topic.

Thanks
mfnewbie
Back to top
View user's profile Send private message

pankaj_kulkarni111

New User


Joined: 17 Aug 2006
Posts: 13
Location: Pune

PostPosted: Wed Dec 17, 2008 2:58 am    Post subject: Reply to: Understanding SQLID and database qualifier specifi
Reply with quote

Hi There,

Type_Description_Herehttp://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.cc.doc/db2_390/setcurrentsqlid.htm
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 IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts Need Help in understanding what is th... mainakdalal PL/I & Assembler 9 Mon Oct 03, 2016 8:03 pm
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
No new posts Database access from COBOL amitmahalkar DB2 1 Wed Jan 27, 2016 11:33 am
No new posts Database backup on IMS DB HABBIE IMS DB/DC 1 Wed Aug 12, 2015 9:02 pm


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