CA IDMS IUA EIUA

Expand all | Collapse all

SQL in ADSO?

Jump to Best Answer
  • 1.  SQL in ADSO?

    Posted 01-23-2013 05:29 AM
    Hi,

    Having a poke around with SQL functionality with ADSO, with the trusty CA IDMS SQL manual by my side. Having some(?) issues with getting a comparatively simple SELECT statement to work within a Premap.

    ADSC seems to accept the Select statement, but trying to declare Host Variables seems to be rejected EG :

    EXEC SQL BEGIN DECLARE SECTION END-EXEC.
    --
    --
    EXEC SQL END DECLARE SECTION END-EXEC.

    The manual informs that this is the correct format, the compilation error describes this as an unrecognised command. The manual only gives very COBOL centric definitions and examples, and not how to integrate into ADSO.

    I may just go back to DML...something I know and I'm comfortable with!

    Thanks.
    Liam.


  • 2.  RE: [Application Developer Issues] SQL in ADSO?
    Best Answer

    Posted 01-23-2013 07:30 AM
    Are your declaratives in your PREMAP or in your DECLARATION module?
    On the ADSC “Process Modules” panel, there is a module type of Declaration (type = 1).

    Charles (Chuck) Hardee
    Senior Systems Engineer
    Database Administration
    Information Technology Services
    Thermo Fisher Scientific
    300 Industry Drive
    Pittsburgh, PA 15275
    Direct: 724-517-2633
    FAX: 412-490-9230
    Chuck.Hardee@ThermoFisher.com

    From: CA IDMS (IUA EIUA) Global User Community [mailto:CommunityAdmin@communities-mail.ca.com]
    Sent: Wednesday, January 23, 2013 5:29 AM
    To: mb.15281477.100098101@myca-email.ca.com
    Subject: [Application Developer Issues] SQL in ADSO?

    Hi,

    Having a poke around with SQL functionality with ADSO, with the trusty CA IDMS SQL manual by my side. Having some(?) issues with getting a comparatively simple SELECT statement to work within a Premap.

    ADSC seems to accept the Select statement, but trying to declare Host Variables seems to be rejected EG :

    EXEC SQL BEGIN DECLARE SECTION END-EXEC.
    --
    --
    EXEC SQL END DECLARE SECTION END-EXEC.

    The manual informs that this is the correct format, the compilation error describes this as an unrecognised command. The manual only gives very COBOL centric definitions and examples, and not how to integrate into ADSO.

    I may just go back to DML...something I know and I'm comfortable with!

    Thanks.
    Liam.
    Posted by:liam.dutton
    --
    CA Communities Message Boards
    100100641
    mb.15281477.100098101@myca-email.ca.com
    https://communities.ca.com


  • 3.  RE: [Application Developer Issues] SQL in ADSO?

    Posted 01-24-2013 04:37 AM
    Thanks for the answer, that's exactly what I was looking for.

    Regards,
    Liam.