Skip to Content
0
Former Member
May 15, 2008 at 06:09 AM

other DB Access

21 Views

Hi Experts,

Need to get the datas from other DB like SQL. The connection was created. While select the values from SQL it gives the exception CX_SY_NO_HANDLER

The code is pasted below. Plz suggest if any error.....

EXEC SQL .

CONNECT TO 'NUMERICUPS' as 'NUMCON'

ENDEXEC.

EXEC SQL.

set connection 'NUMCON'

endexec.

exec sql .

SELECT * INTO :itab FROM DBO.NUM_TAB // here the error has come

endexec.

Regards,

Anita .B