how do i access the file inside library which is inside qsys on remote system.

[satya]

Hi i have been trying to access a particular file inside a lib which is inside library qsys

I have been able to browse till qsys using

connect rmtdb
,set path =qsys
select * from file a --working
however is ther any specific set command to go into lib inside qsys
and then do a select on file.




Thanks
Satya

[satya]

Hi i have been trying to access a particular file inside a lib which is inside library qsys

I have been able to browse till qsys using

connect rmtdb
,set path =qsys
select * from file a --working
however is ther any specific set command to go into lib inside qsys
and then do a select on file.




Thanks
Satya

Isee the problem is setting the path it looks like the set path command is setting the path OF THE LIBRARY WITH QUOTES when i checked it using "select current_path from sysibm.sysdummy1"

.I need to set the path without quotes.and i have heard its changed in custom properties section .


Please find the thread referring to

https://stackoverflow.com/questions/24144538/why-do-i-get-sqlcode-204-sqlstate-42704-with-db2-luw-and-websphere-app-server