AnsweredAssumed Answered

SQL in ADSO?

Question asked by liam.dutton on Jan 23, 2013
Latest reply on Jan 24, 2013 by liam.dutton
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.

Outcomes