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
 
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 Moving UDB database to Db2 on z/OS Keith Hooley DB2 4 Wed Sep 27, 2017 12:38 am
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

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