<div>
Ok Tom, thanks again for your reply.<br />
<br />
I tried the OPTION(*SYS), and then qualified my files in the Select statement, and the program creates the package and all that. However, the file is not being found when I run my program, like it is ignoring the qualification. Can you elavorate a little on the &quot;controlling the library list, perhaps via a SQL CALL....&quot; I am not sure I am smart enough to do this.... 
</div>


Ok Tom, thanks again for your reply.

I tried the OPTION(*SYS), and then qualified my files in the Select statement, and the program creates the package and all that. However, the file is not being found when I run my program, like it is ignoring the qualification. Can you elavorate a little on the "controlling the library list, perhaps via a SQL CALL...." I am not sure I am smart enough to do this....

<div>
Hey Guys...<br />
<br />
After a while I found that the library can be added just by calling an exeternal command like QCMDEXC. <br />
<br />
Thanks for your attention 
</div>


Hey Guys...

After a while I found that the library can be added just by calling an exeternal command like QCMDEXC.

Thanks for your attention

<div>
Somewhat incomplete instructions
</div>


<div>
<div class="content wysiwyg-content">
Since I am accessing data in a remote system, I am using the CONNECT statement and then compiling with DFTRDBCOL =&quot;library name&quot;. However, my SQL statements include files in more that one library. What should I do, in order to access files in several libraries in the remote system? 
</div>
</div>


Since I am accessing data in a remote system, I am using the CONNECT statement and then compiling with DFTRDBCOL ="library name". However, my SQL statements include files in more that one library. What should I do, in order to access files in several libraries in the remote system? 

DFTRDBCOL Parameter with more than one library?

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.