Skip to Content
0
Former Member
Jul 05, 2006 at 07:22 AM

DBIF_RSQL_SQL_ERROR

35 Views

Hi There,

I am loading historical data into an ODS.

This is the error mesage in ST22.

Name of runtime error: DBIF_RSQL_SQL_ERROR

Exception: CX_SY_OPEN_SQL_DB

There is lots of space in the DB02.

Here is the ABAP code where to program fails.

The program fail on the bold line.

See below.

FORM INSERT_ODS

TABLES P_T_DATA

USING P_REQUESTID LIKE RSMONOUT-RNR

P_DATAPAKID TYPE RSDATAPID

P_PARTNO TYPE RSPARTVAL

CHANGING P_TARGET_FOUND TYPE C

P_SUBRC LIKE SY-SUBRC.

  • Local data declarations

DATA: L_T_DATA LIKE /BIC/B0000119004 OCCURS 0,

L_S_DATA LIKE /BIC/B0000119004.

  • Initialization

P_TARGET_FOUND = RS_C_TRUE.

CLEAR: P_SUBRC.

  • Try to insert the records into the ODS table

<b>INSERT /BIC/B0000119004 FROM TABLE P_T_DATA</b>

ACCEPTING DUPLICATE KEYS.

IF SY-SUBRC NE 0.

  • Roll back work and try to find the duplicates

ROLLBACK WORK.

  • select * from /BIC/B0000119004

  • into table l_t_data

  • for all entries in p_t_data

  • where request = p_t_data-request

  • and datapakid = p_t_data-datapakid

  • and record = p_t_data-record.

  • Doesn't work because p_t_data has no structure

  • Do something with the found records !

P_SUBRC = 13.

ENDIF.

ENDFORM. "INSERT_ODS

Hope anyone can help.

Thanks.

Andre.