mfnewbie
New User
Joined: 26 Oct 2006 Posts: 2 Location: White Plains, NY
|
|
|
|
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 |
|