EXEC SQL PERFORMING

Former Member — Thu, 13 Mar 2008 02:05:23 GMT

when run the following program ,it reported error as

"the error occurred in the current database connection "DEFAULT".

how to solve the problem ?

=================================

DATA : BEGIN OF WA,

CLIENT(3),

ARG1(3),

ARG2(3),

END OF WA.

DATA F3 VALUE '1'.

EXEC SQL PERFORMING LOOP_OUTPUT.

SELECT CLIENT , ARG1 INTO :WA FROM TABLE_001 WHERE ARG2 = :F3.

ENDEXEC.

FORM LOOP_OUTPUT.

WRITE : / WA-CLIENT,WA-ARG2.

ENDFORM.

==================================

Re: EXEC SQL PERFORMING

Former Member — Thu, 13 Mar 2008 03:36:34 GMT

try

SELECT * FROM TABLE_001 INTO CORRESPONDING FIELDS OF WA WHERE ARG2 = F3.

KUMAR