Code:
Set define off;
insert into CFG_FRG_EVENT_SRC (FRG_EVENT_SRC_KEY, SWI_ID, FILE_PATH, FILE_NAME_MASK, CONVERTER_NAME, BACKUP, BACKUP_PATH,CVT_FILE_PATH, ERR_FILE_PATH, SEQ_NBR_LWR_LMT, SEQ_NBR_UPR_LMT,KEEP_REC_CAT_STATS, VALIDATE_DETAILS, PROC_ORDER_BY, SEQ_NBR_GAP_TOLERANCE, FILE_DTTM_GAP_TOLERANCE, SEQ_NBR_RANGE_TOLERANCE, ENABLED, MISSING_FILES_DETECT_FLAG, NUM_CYCLES_TO_PROCESS, NUM_FILES_PER_CYCLE, DUP_CHK_SCHM_CODE, DESCRIPTION, USERNAME, GROUPID) values (10000, 'FT_SWI','${string1}','PSTINVOPR1_%4%.idr', 'cvt_passthrough', 1, '$IB_HOME_DIR/FRGFOLDER/backup','$IB_HOME_DIR/output','$IB_HOME_DIR/FRGFOLDER/error',0, 9999, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 0, 'PSTINVOPR1', 'SYS', null);
commmit;
~