SQL in ADSO?

[Anon Anon]

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.

[Legacy User]

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: [phone]
[e-mail]

From: CA IDMS (IUA EIUA) Global User Community [mailto:[e-mail]]
Sent: Wednesday, January 23, 2013 5:29 AM
To: [e-mail]
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
[e-mail]
https://communities.ca.com

[Anon Anon]

Thanks for the answer, that's exactly what I was looking for.

Regards,
Liam.