Truncate of S_SRC_POSTN
Hello,
I need to empty S_SRC_POSTN table just before fill it again (both operation with the same EIM).
When I run the EIM, I have an error message saying :
SBL-EIM-00404 : Error getting interface table names
Here is my IFB file:
;=====================================================
;Commentaire : INITIALISATION LIENS CAMPAGNE POSITION
;=====================================================
[Siebel Interface Manager]
PROCESS = CAMPAGNE
[CAMPAGNE]
TYPE = SHELL
INCLUDE = "DELETE TABLE"
INCLUDE = "CAMPAGNE POSITION"
[DELETE TABLE]
TYPE = DELETE
BATCH = $BATCH_RANGE
TABLE = EIM_SRC
DELETE ALL ROWS = TRUE
ONLY BASE TABLES = S_SRC_POSTN
[CAMPAGNE POSITION]
TYPE = IMPORT
BATCH = $BATCH_RANGE
TABLE = EIM_SRC
USING SYNONYMS = FALSE
USE INDEX HINTS = TRUE
INSERT ROWS = S_SRC, FALSE
0