Skip to main content

XAR Configuration (XDB) SQLCODE -19702

  • July 8, 2020
  • 1 reply
  • 0 views
D

Hello,

I have added a new XAR to my ES instance:

- ID: DB7R

- Name: XDBCA

- Module: ESP\\xar\\ESXDBXA.dll

- Open String: "SRV=ESPC0087,LOC=LOCBANK,USER=MFUSER"

 

My XDB database is already created and I can access it through SQL Wizard.

However:

- When I run an online program, I receive SQLCODE -19702 after the first EXEC SQL statement

- When I run a batch program usin DSN SYSTEM(DB7R), the JCL fails with "database OPEN call failed DB7R"

 

It is like some configuration is missing but I don't know how to solve this.

Help is very much appreciated.


#EnterpriseDeveloper

    1 reply

    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • July 15, 2020

    Hello,

    I have added a new XAR to my ES instance:

    - ID: DB7R

    - Name: XDBCA

    - Module: ESP\\xar\\ESXDBXA.dll

    - Open String: "SRV=ESPC0087,LOC=LOCBANK,USER=MFUSER"

     

    My XDB database is already created and I can access it through SQL Wizard.

    However:

    - When I run an online program, I receive SQLCODE -19702 after the first EXEC SQL statement

    - When I run a batch program usin DSN SYSTEM(DB7R), the JCL fails with "database OPEN call failed DB7R"

     

    It is like some configuration is missing but I don't know how to solve this.

    Help is very much appreciated.


    #EnterpriseDeveloper

    The solution is:

    1. ESXDBOPC.dll must be in ED bin folder (not in the same system/region folder as ESXDBXA.dll)

    2. Preprocessor must be XDB instead of OpenESQL

    3. SQL directive SQL(COPY) must be enabled (otherwise SQL statements can give compilation errors)


    Terms & ConditionsAccessibility statement