Skip to Content
0
Former Member
Jan 29, 2008 at 01:27 PM

Native SQL

72 Views

Dear All,

Im trying to get a feild called 'DO' from table 'partinfo' from native SQL .

EXEC SQL .

SELECT LOTID, EQPID, DO

INTO :ITAB1

FROM partinfo

WHERE LOTID = '12345'

ENDEXEC.

But SAP is throwing this error.

Database error text........: "ORA-00904: "DO": invalid identifier"

I tried without 'Do', It is working Fine.

I cant change the Table or its feild, Bcos other teams also using this table.

Thanks & regards,

Chakri.