DFTRDBCOL Parameter with more than one library?

Posted on 2010-01-07
Last Modified: 2012-05-08
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?
Question by:spr-electrolux
    LVL 26

    Accepted Solution

    AFAIK, only one library (collection) can be the "default" library (collection). If you access outside of the named default, you need to qualify the names with the appropriate library (collection).

    Is the remote system expected and intended to be another AS/400? If so, then you probably should use OPTION(*SYS) and consider controlling the library list, perhaps via a SQL CALL prior to data access or some similar method of remote invocation within the same unit of work.


    Author Comment

    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....

    Author Comment

    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

    Author Closing Comment

    Somewhat incomplete instructions

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Title # Comments Views Activity
    How to silent print from safari browser 6 97
    java ^ examples 8 48
    allStar challenge 1 27
    endX challenge 2 31
    Purpose To explain how to place a textual stamp on a PDF document.  This is commonly referred to as an annotation, or possibly a watermark, but a watermark is generally different in that it is somewhat translucent.  Watermark’s may be text or graph…
    This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
    In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now