Hi，Everyone，I Have a question to ask, That is Can I use Dynamic SQL in Native SQL??? I used it in my program , Compile is Ok!
But after Run ,the result was not right.....Why?
The following is my sample code:
"LV_CODES" is the Dynamic String. Useing SQL/PLUS i can get result with this select....But In ABAP Code , The Result is initial,But
sy-subrc = 0. Please Help Me! Thanks a lot!
*******************************************************************************************************************************************
CONCATENATE LV_CODE '''' WA_ZTPM_ODS_CONFIG-PROVCODE '''' INTO LV_CODES.
EXEC SQL.
OPEN dbcur
FOR SELECT OBJ_ID,
to_char(opt_time,'yyyymmddhh24missff') as opt_time,
DATA_TABLECODE,
DATA_OBJID,
DB_OPERATION,
DATA_SPC,
CODE_EQUIP,
OPT_SYS
FROM EQU_GG_DBOPT_INDEX
WHERE opt_time > to_timestamp(:L_MAXUPDATETS,'yyyymmddhh24missff')
AND (DATA_SPC = :C_DATA_SPC_L OR DATA_SPC = :C_DATA_SPC_S)
AND (DATA_TABLECODE = :C_DATA_TABLECODE_XLFD
OR DATA_TABLECODE = :C_DATA_TABLECODE_XL
or REGEXP_LIKE (DATA_TABLECODE,'^[0-9]*$') )
AND OPT_SYS = :C_OPT_SYS_PMS
and substr(CODE_EQUIP,1,2) IN ( :LV_CODES )
ENDEXEC.
Bluesky
