EGL Development User Group

EGL Development User Group

EGL Development User Group

The EGL Development User Group is dedicated to sharing news, knowledge, and insights regarding the EGL language and Business Developer product. Consisting of IBMers, HCL, and users, this community collaborates to advance the EGL ecosystem.

 View Only
Back to discussions
Expand all | Collapse all

egl build descriptor question

  • 1.  egl build descriptor question

    Posted Fri August 31, 2018 03:36 PM

    i have a build descriptor as below. I would like to set the following at runtime rather then during development:

    sqlDB="jdbc:as400:IBMISERIES;prompt=false;naming=system;date format=usa;transaction isolation=none;autocommit=off;"

    The value of "ibmiseries" will change based on the system i am running on (test/production).

    So at runtime i would like to prompt user for which system they want to run against and just point to that system.

     

     

    <?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE EGL PUBLIC "-//IBM Corporation, Inc.//DTD EGL Build Parts 6.0//EN" "">
    <EGL>
    <BuildDescriptor
        name="servicesprjJavaBuildOptions"
        genProject="servicesprj"
        system="WIN"
        J2EE="NO"
        genProperties="GLOBAL"
        genDataTables="YES"
        deploymentDescriptor="servicesprj"
        linkage="qqqpgms"
        serverType="TOMCAT6.X"
        sqlJNDIName="jdbc/qqq"
        sqlValidationConnectionURL="jdbc:as400:IBMISERIES;prompt=false;naming=system;"
        sqlDB="jdbc:as400:IBMISERIES;prompt=false;naming=system;date format=usa;transaction isolation=none;autocommit=off;"
        sqlJDBCDriverClass="com.ibm.as400.access.AS400JDBCDriver"
        sqlID="xxx"
        sqlPassword="crypto:xxx"
        dbms="DB2"
        >
    </BuildDescriptor>
    <BuildDescriptor
        name="servicesprjDebugBuildOptions"
        genProject="servicesprj"
        system="WIN"
        J2EE="NO"
        genProperties="GLOBAL"
        genDataTables="YES"
        deploymentDescriptor="servicesprj"
        linkage="qqqpgms"
        serverType="TOMCAT6.X"
        sqlJNDIName="jdbc/qqq"
        sqlValidationConnectionURL="jdbc:as400:IBMISERIES;prompt=false;naming=system;"
        sqlDB="jdbc:as400:IBMISERIES;prompt=false;naming=system;date format=usa;transaction isolation=none;autocommit=off;"
        sqlJDBCDriverClass="com.ibm.as400.access.AS400JDBCDriver"
        sqlID="xxx"
        sqlPassword="crypto:xxx"
        dbms="DB2"
    >
    </BuildDescriptor>
    <LinkageOptions name="qqqpgms">
        <description><![CDATA[qqq iseries programs]]></description>
        <callLink >
            <remoteCall pgmName="CW000013" library="*LIBL"  location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"/>
            <remoteCall pgmName="CW00002"  library="*LIBL"  location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00003"  library="*LIBL"  location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00004" library="*LIBL"   location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00005"  library="*LIBL"  location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00006" library="*LIBL"   location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00007" library="*LIBL"   location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00008" library="*LIBL"   location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00009" library="*LIBL"   location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW000092" library="*LIBL"   location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />        
            <remoteCall pgmName="CW00010"  library="*LIBL"  location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00011" library="*LIBL"   location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00012"  library="*LIBL"  location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00013"  library="*LIBL"  location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00014" library="*LIBL"   location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00015"  library="*LIBL"  location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00016"  library="*LIBL"  location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00017" library="*LIBL"   location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00018" library="*LIBL"   location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00018C" library="*LIBL"   location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00018C2" library="*LIBL"   location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />                
            <remoteCall pgmName="CW00019"  library="*LIBL"  location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00020"  library="*LIBL"  location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00021" library="*LIBL"   location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00022" library="*LIBL"   location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00223" library="*LIBL"   location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00224" library="*LIBL"   location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00025"  library="*LIBL"  location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="RUIPGM21" library="*LIBL"  location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="RUIPGM22C" library="*LIBL" location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00026C" library="*LIBL"  location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00026C1" library="*LIBL"  location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00227C" library="*LIBL"   location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00228C" library="*LIBL"   location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00030"  library="*LIBL"  location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00031"  library="*LIBL"  location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />        
            <remoteCall pgmName="CW00036C"  library="*LIBL"  location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00037"  library="*LIBL"  location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00041"  library="*LIBL"  location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CH032505" library="*LIBL"   location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />                
            <remoteCall pgmName="CW00043"  library="*LIBL"  location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW00045"  library="*LIBL"  location="IBMISERIES" remoteBind="GENERATION" remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />        
            <remoteCall pgmName="CW000194" library="*LIBL"  location="IBMISERIES"  remoteBind="GENERATION"  remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CW000195" library="NTCOLL"  location="IBMISERIES"  remoteBind="GENERATION"  remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="CH0302C" library="*LIBL"  location="IBMISERIES"  remoteBind="GENERATION"  remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />
            <remoteCall pgmName="GETSYSNAME" library="*LIBL"  location="IBMISERIES"  remoteBind="GENERATION"  remoteComType="JAVA400" remotePgmType="STATEFUL" conversionTable="CSOE037" javaWrapper="YES" luwControl="SERVER" refreshScreen="YES"  />    
        </callLink>
    </LinkageOptions>
    </EGL>

    nick_tn


  • 2.  Re: egl build descriptor question

    Posted Fri August 31, 2018 06:54 PM

    Hi Nick,

     

    I believe you can explore the functions of egl sqllib.connect ();

    https://www.ibm.com/support/knowledgecenter/SSMQ79_9.1.1.1/com.ibm.egl.lr.doc/topics/regl_data_sql_lib.html

    https://www.ibm.com/support/knowledgecenter/SSMQ79_9.1.1.1/com.ibm.egl.lr.doc/topics/regl_data_sql_connect.html

    databaseName
    The name of your database. The name varies depending on your environment, your database management software, and other factors. For more information, see Creating an SQL database connection in the EGL Programmer's Guide.
    If your code is running as a Java™ program, the following statements apply:
    • You can find the physical database name by looking up the vgj.jdbc.database.server property, where server is the name of the server specified in the vgLib.connectionService() call. If this property is not defined, the server name that is specified in the vgLib.connectionService() call is used as is.

     

     I'm going to try to build a sample next week to get it working.

     

    Hsieh

    Hsieh


  • 3.  Re: egl build descriptor question

    Posted Tue September 04, 2018 12:18 PM

    Hi Nick,

     

    Basically you need to do the following:

     

    1. Include the following parameters in rununit.properties

    vgj.jdbc.database.DBTEST=jdbc:as400:DBTEST;prompt=false;naming=system;date format=usa;transaction isolation=none;autocommit=off

    vgj.jdbc.databaseDBPROD=jdbc:as400:DBPROD;prompt=false;naming=system;date format=usa;transaction isolation=none;autocommit=off

     

     

    2. In the egl code you must include the instruction:

    sqllib.connect("database_server_name", "userId", "password");

    database_server_name is DBTEST or DBPROD

     

    let me know if it worked?

     

    Regards,

     

    Hsieh

     

    Hsieh


  • 4.  Re: egl build descriptor question

    Posted Tue September 04, 2018 01:06 PM

    Thanks Hsieh.

     

    I will implement as suggested.

    nick_tn


Related Content