how can use sql cursor in ecc6.0 version

[Former Member]

Hi All,

We are migrating from 4.6c to ECC6.0.The Extended programee check gives instead of using native sql ,we can use SQL CURSOR.So how can we use dis Sql cursor.Here i am giving my statements,pls go through and rectify th problem.

EXEC SQL PERFORMING MAIN_LINE.

SELECT * INTO :WA_CHKDAT FROM R3P01QGPL/CHECKDATA

ENDEXEC.

Note: R3P01QGPL/CHECKDATA is a tables,But this was not laying in R/3 level instead it will in Database level.

Thanks

[Former Member]

Hi All,

We are migrating from 4.6c to ECC6.0.The Extended programee check gives instead of using native sql ,we can use SQL CURSOR.So how can we use dis Sql cursor.Here i am giving my statements,pls go through and rectify th problem.

EXEC SQL PERFORMING MAIN_LINE.

SELECT * INTO :WA_CHKDAT FROM R3P01QGPL/CHECKDATA

ENDEXEC.

Note: R3P01QGPL/CHECKDATA is a tables,But this was not laying in R/3 level instead it will in Database level.

Thanks

[sourabhshah]

hi,

Check this

http://help.sap.com/saphelp_erp2005vp/helpdata/en/40/13120f2fa511d3a98100a0c9449261/frameset.htm

Regards,

Sourabh