DSXchange

Define Job parameter name as T_NAME and Value as SAPSLP."/GKV/CM00_PROCU" and in Oracle Stage provide query like : SELECT CLAIM FROM #T_NAME#. Above is working fine for me. Hi, it's a problem of case sensitivity. If i write the tablename in Upper Case the query runs fine. It works with al...

Odd. Perhaps try putting the double-quotes in the sql itself and not the parameter value? SELECT CLAIM FROM SAPSLP."#Job_Parameter#" The same result: Prepare failed for: GenericStmt_1 >query is: SELECT CLAIM FROM SAPSLP."/gkv/cm00_procu" >sqlcode is: -942 >esql complaint: ORA-00...

Are the quotes being stripped when using a job parameter? If so, have you tried escaping them? Hi, If I use the Jobparameter with value: "/gkv/cm00_procu" the following error-message appears: >Prepare failed for: GenericStmt_1 >query is: SELECT CLAIM FROM SAPSLP."/gkv/cm00_procu"...

I have tested the same senario , created table called SAPSLP./GKV/CM00_PROCU with one field REG_NO. It is working fine using this command in Oracle Stage : select REG_NO from "SAPSLP./GKV/CM00_PROCU" and one more created table /GKV/CM00_PROCU assume SAPSLP is schema name than use below co...