Topic
  • 3 replies
  • Latest Post - ‏2013-05-13T09:24:20Z by giocot
giocot
giocot
164 Posts

Pinned topic How to set library list iSeries

‏2013-05-12T20:01:30Z |

Hi all

i have created this following Service part but i receive the error : 

message:EGL0504E GET: [SQL0204] QCUSTCDT in myiSeriesUser of *file type not found [sqlstate:42704][sqlcode:-204]

Two questions:

1- why i try to find the file in library with my User name ?

2- how can set library list in Service part

Thanks

package services;
import records.qCustCdtRec;
// service
service SQLService
    // Variable Declarations
    variableName string;
    function getAllCust() returns(qCustCdtRec[])
        custArray qCustCdtRec[];
        get custArray with
            #sql{
                select
                      STATE , sum(baldue) as baldue
                from QCUSTCDT
                group by state
                order by state
            };
        return(custArray);
    end

end
 

Updated on 2013-05-12T20:02:00Z at 2013-05-12T20:02:00Z by giocot
  • TuukkaIlomäki
    TuukkaIlomäki
    80 Posts

    Re: How to set library list iSeries

    ‏2013-05-13T07:44:59Z  

    The attachment attachment_14697467_CallingSystemI.ppt by Mark Evans in this thread gives a good overview of calling System i Programs from EGL. From that document:

    • QVGNSETP invoked to set library list if needed (CAN BE CUSTOMIZED)
    • QVGNRNCL is invoked from user library (REQUIRED TO BE COPIED THERE) to set commitment control

    This concerns calling EGL programs; I assume calling services running on System i can be controlled by similar measures.

  • giocot
    giocot
    164 Posts

    Re: How to set library list iSeries

    ‏2013-05-13T08:05:01Z  

    The attachment attachment_14697467_CallingSystemI.ppt by Mark Evans in this thread gives a good overview of calling System i Programs from EGL. From that document:

    • QVGNSETP invoked to set library list if needed (CAN BE CUSTOMIZED)
    • QVGNRNCL is invoked from user library (REQUIRED TO BE COPIED THERE) to set commitment control

    This concerns calling EGL programs; I assume calling services running on System i can be controlled by similar measures.

    Hi Thanks for your reply

    another question . how can i avoid that my SQL service try to find the table in a library with the same myuseriSeries's name ?

    when i run my SQL service should search table in the job's library list

    thanks in advance

     

  • giocot
    giocot
    164 Posts

    Re: How to set library list iSeries

    ‏2013-05-13T09:24:20Z  
    • giocot
    • ‏2013-05-13T08:05:01Z

    Hi Thanks for your reply

    another question . how can i avoid that my SQL service try to find the table in a library with the same myuseriSeries's name ?

    when i run my SQL service should search table in the job's library list

    thanks in advance

     

    Hi

    i found the solution, i have modified the .eglbld file : i put:

    sqlDB="jdbc:as400:myiseries;prompt=false;naming=system;libraries=*LIBL"

    and now runs ok

    Thanks