All Forums UDA
Sreekanth-4565 7 posts Joined 07/07
01 Jul 2007
3707, Syntax error expected something like a name between ',' and the 'TYPE' keyword.

Hi all, I'm looking for the solutions for below mentioned issues while using fastload to load data from oracle to teradata using informatica.My environment is Windows. Issue 1)UTY8001 RDBMS failure in Stmt Check: 3707, Syntax error, expected something like a name between ',' and the 'TYPE' keyword. I have TYPE keyword in the control file which is mentioned in double quotes. .Field TRIM_CD 2408 CHAR(30) NULLIF TRIM_CD= '*' ;.Field TRIM_CD_I 2438 CHAR(50) NULLIF TRIM_CD_I = '*' ;.Field "TYPE" 2488 CHAR(30) NULLIF "TYPE"= '*' ;.Field TYPE_I 2518 CHAR(50) NULLIF TYPE_I = '*' ;.Field UOM 2568 CHAR(30) NULLIF UOM 2568 CHAR(30) NULLIF UOM Issue 2) Do we need to make this control file as read only.If so i get an error unable to open the input file.(bookshelf says to keep it as read only). If i don't keep read only the same is getting overwritten. Can some one throw some light on the same Thanks in advance

DGiabbai 47 posts Joined 07/04
02 Jul 2007

Could you please attach the whole script?Informatica is an ETL tool that should generate Teradata scripts accordingly to what you have defined. So, could the problem be related to Informatica?

Sreekanth-4565 7 posts Joined 07/07
02 Jul 2007

The whole control file is pasted below======================================== There are Columns with name "TYPE" which are mentioned in double quotes.But in the error log (pasted below the control file) shows error at TYPE. Can someone tell me why the error is occuring. .DATEFORM ANSIDATE; .LOGON /,; .LOGTABLE DT_RMW..LT_W_HOUSEHOLD_SCD0;DROP TABLE DT_RMW..ET_W_HOUSEHOLD_SCD0 ;.ROUTE MESSAGES WITH ECHO TO FILE 'file:///C:/InformaticaPowerCenter7.1.2/Server/TgtFiles/w_household_scd2.out.ldrlog' ;.BEGIN LOAD ERRORTABLE DT_RMW.ET_W_HOUSEHOLD_SCD0 ERRLIMIT 5000 CHECKPOINT 0 TENACITY 4 SESSIONS 2 SLEEP 6 SERIALIZE ON PACK 5 ROBUST OFF NOMONITOR; /* Begin Layout Section */ .Layout InputFileLayout;.Field DATASOURCE_NUM_ID 1 CHAR( 12) ;.Field ETL_PROC_WID 13 CHAR( 12) ;.Field INTEGRATION_ID 25 CHAR( 30) ;.Field ROW_WID 55 CHAR( 12) KEY ;.Field SCD_END_DT_WID 67 CHAR( 12) ;.Field SCD_START_DT_WID 79 CHAR( 12) KEY ;.Field AVERAGE_AGE 91 CHAR( 24) NULLIF AVERAGE_AGE = '*' ;.Field CREATED_DT 115 CHAR( 19) NULLIF CREATED_DT = '*' ;.Field CREDIT_SCORE 134 CHAR( 24) NULLIF CREDIT_SCORE = '*' ;.Field DEPENDS_NUM 158 CHAR( 12) NULLIF DEPENDS_NUM = '*' ;.Field HH_INCOME 170 CHAR( 24) NULLIF HH_INCOME = '*' ;.Field HH_REVENUE 194 CHAR( 24) NULLIF HH_REVENUE = '*' ;.Field MAIL_FLG 218 CHAR( 1) NULLIF MAIL_FLG = '*' ;.Field MEDIAN_AGE 219 CHAR( 12) NULLIF MEDIAN_AGE = '*' ;.Field NUM_CONTACTS 231 CHAR( 12) NULLIF NUM_CONTACTS = '*' ;.Field NUM_PROD 243 CHAR( 12) NULLIF NUM_PROD = '*' ;.Field U_EXCH_DT 255 CHAR( 19) NULLIF U_EXCH_DT = '*' ;.Field U_HH_INCOME 274 CHAR( 24) NULLIF U_HH_INCOME = '*' ;.Field U_HH_REVENUE 298 CHAR( 24) NULLIF U_HH_REVENUE = '*' ;.Field U_WEALTH_AMT 322 CHAR( 24) NULLIF U_WEALTH_AMT = '*' ;.Field WEALTH_AMT 346 CHAR( 24) NULLIF WEALTH_AMT = '*' ;.Field ANNUAL_INCOME 370 CHAR( 30) NULLIF ANNUAL_INCOME = '*' ;.Field ANNUAL_INCOME_I 400 CHAR( 50) NULLIF ANNUAL_INCOME_I = '*' ;.Field BU_NAME 450 CHAR( 100) NULLIF BU_NAME = '*' ;.Field CATEGORY 550 CHAR( 30) NULLIF CATEGORY = '*' ;.Field CATEGORY_I 580 CHAR( 50) NULLIF CATEGORY_I = '*' ;.Field CON_FST_NAME 630 CHAR( 50) NULLIF CON_FST_NAME = '*' ;.Field CON_LST_NAME 680 CHAR( 50) NULLIF CON_LST_NAME = '*' ;.Field GROUP_NAME 730 CHAR( 100) NULLIF GROUP_NAME = '*' ;.Field HHOLD_ADDRESS 830 CHAR( 200) NULLIF HHOLD_ADDRESS = '*' ;.Field HHOLD_CITY 1030 CHAR( 50) NULLIF HHOLD_CITY = '*' ;.Field HHOLD_COUNTRY 1080 CHAR( 30) NULLIF HHOLD_COUNTRY = '*' ;.Field HHOLD_STATE 1110 CHAR( 50) NULLIF HHOLD_STATE = '*' ;.Field HHOLD_ZIP 1160 CHAR( 30) NULLIF HHOLD_ZIP = '*' ;.Field INCOME_RANGE 1190 CHAR( 30) NULLIF INCOME_RANGE = '*' ;.Field INCOME_RANGE_I 1220 CHAR( 50) NULLIF INCOME_RANGE_I = '*' ;.Field MAIN_PH_FAX_NUM 1270 CHAR( 40) NULLIF MAIN_PH_FAX_NUM = '*' ;.Field MAIN_PH_NUM 1310 CHAR( 40) NULLIF MAIN_PH_NUM = '*' ;.Field MKT_SEGMENT 1350 CHAR( 30) NULLIF MKT_SEGMENT = '*' ;.Field MKT_SEGMENT_I 1380 CHAR( 50) NULLIF MKT_SEGMENT_I = '*' ;.Field NAME 1430 CHAR( 100) NULLIF NAME = '*' ;.Field OWNERSHIP 1530 CHAR( 30) NULLIF OWNERSHIP = '*' ;.Field OWNERSHIP_I 1560 CHAR( 50) NULLIF OWNERSHIP_I = '*' ;.Field PARENT_NAME 1610 CHAR( 30) NULLIF PARENT_NAME = '*' ;.Field PR_CON_ID 1640 CHAR( 30) NULLIF PR_CON_ID = '*' ;.Field REGION 1670 CHAR( 40) NULLIF REGION = '*' ;.Field STATUS 1710 CHAR( 30) NULLIF STATUS = '*' ;.Field STATUS_I 1740 CHAR( 50) NULLIF STATUS_I = '*' ;.Field "TYPE" 1790 CHAR( 30) NULLIF "TYPE" = '*' ;.Field TYPE_I 1820 CHAR( 50) NULLIF TYPE_I = '*' ;.Field U_CURCY_CD 1870 CHAR( 20) NULLIF U_CURCY_CD = '*' ;.Field WEALTH_RANGE 1890 CHAR( 30) NULLIF WEALTH_RANGE = '*' ;.Field WEALTH_RANGE_I 1920 CHAR( 50) NULLIF WEALTH_RANGE_I = '*' ;.Filler EOL_PAD 1970 CHAR( 2) ;/* End Layout Section */ /* begin DML Section */ .DML Label tagDMLDo insert for missing update rows;UPDATE DT_RMW.W_HHOLD_SCDSET DATASOURCE_NUM_ID = ATASOURCE_NUM_ID , ETL_PROC_WID = :ETL_PROC_WID , INTEGRATION_ID = :INTEGRATION_ID , SCD_END_DT_WID = :SCD_END_DT_WID , AVERAGE_AGE = :AVERAGE_AGE , CREATED_DT = :CREATED_DT , CREDIT_SCORE = :CREDIT_SCORE , DEPENDS_NUM = EPENDS_NUM , HH_INCOME = :HH_INCOME , HH_REVENUE = :HH_REVENUE , MAIL_FLG = :MAIL_FLG , MEDIAN_AGE = :MEDIAN_AGE , NUM_CONTACTS = :NUM_CONTACTS , NUM_PROD = :NUM_PROD , U_EXCH_DT = :U_EXCH_DT , U_HH_INCOME = :U_HH_INCOME , U_HH_REVENUE = :U_HH_REVENUE , U_WEALTH_AMT = :U_WEALTH_AMT , WEALTH_AMT = :WEALTH_AMT , ANNUAL_INCOME = :ANNUAL_INCOME , ANNUAL_INCOME_I = :ANNUAL_INCOME_I , BU_NAME = :BU_NAME , CATEGORY = :CATEGORY , CATEGORY_I = :CATEGORY_I , CON_FST_NAME = :CON_FST_NAME , CON_LST_NAME = :CON_LST_NAME , GROUP_NAME = :GROUP_NAME , HHOLD_ADDRESS = :HHOLD_ADDRESS , HHOLD_CITY = :HHOLD_CITY , HHOLD_COUNTRY = :HHOLD_COUNTRY , HHOLD_STATE = :HHOLD_STATE , HHOLD_ZIP = :HHOLD_ZIP , INCOME_RANGE = :INCOME_RANGE , INCOME_RANGE_I = :INCOME_RANGE_I , MAIN_PH_FAX_NUM = :MAIN_PH_FAX_NUM , MAIN_PH_NUM = :MAIN_PH_NUM , MKT_SEGMENT = :MKT_SEGMENT , MKT_SEGMENT_I = :MKT_SEGMENT_I , NAME = :NAME , OWNERSHIP = WNERSHIP , OWNERSHIP_I = WNERSHIP_I , PARENT_NAME = ARENT_NAME , PR_CON_ID = R_CON_ID , REGION = :REGION , STATUS = :STATUS , STATUS_I = :STATUS_I , "TYPE" = :"TYPE" , TYPE_I = :TYPE_I , U_CURCY_CD = :U_CURCY_CD , WEALTH_RANGE = :WEALTH_RANGE , WEALTH_RANGE_I = :WEALTH_RANGE_I WHERE ROW_WID = :ROW_WID AND SCD_START_DT_WID = :SCD_START_DT_WID ; INSERT INTO DT_RMW.W_HHOLD_SCD ( DATASOURCE_NUM_ID , ETL_PROC_WID , INTEGRATION_ID , ROW_WID , SCD_END_DT_WID , SCD_START_DT_WID , AVERAGE_AGE , CREATED_DT , CREDIT_SCORE , DEPENDS_NUM , HH_INCOME , HH_REVENUE , MAIL_FLG , MEDIAN_AGE , NUM_CONTACTS , NUM_PROD , U_EXCH_DT , U_HH_INCOME , U_HH_REVENUE , U_WEALTH_AMT , WEALTH_AMT , ANNUAL_INCOME , ANNUAL_INCOME_I , BU_NAME , CATEGORY , CATEGORY_I , CON_FST_NAME , CON_LST_NAME , GROUP_NAME , HHOLD_ADDRESS , HHOLD_CITY , HHOLD_COUNTRY , HHOLD_STATE , HHOLD_ZIP , INCOME_RANGE , INCOME_RANGE_I , MAIN_PH_FAX_NUM , MAIN_PH_NUM , MKT_SEGMENT , MKT_SEGMENT_I , NAME , OWNERSHIP , OWNERSHIP_I , PARENT_NAME , PR_CON_ID , REGION , STATUS , STATUS_I , "TYPE" , TYPE_I , U_CURCY_CD , WEALTH_RANGE , WEALTH_RANGE_I ) VALUES ( ATASOURCE_NUM_ID , :ETL_PROC_WID , :INTEGRATION_ID , :ROW_WID , :SCD_END_DT_WID , :SCD_START_DT_WID , :AVERAGE_AGE , :CREATED_DT , :CREDIT_SCORE , EPENDS_NUM , :HH_INCOME , :HH_REVENUE , :MAIL_FLG , :MEDIAN_AGE , :NUM_CONTACTS , :NUM_PROD , :U_EXCH_DT , :U_HH_INCOME , :U_HH_REVENUE , :U_WEALTH_AMT , :WEALTH_AMT , :ANNUAL_INCOME , :ANNUAL_INCOME_I , :BU_NAME , :CATEGORY , :CATEGORY_I , :CON_FST_NAME , :CON_LST_NAME , :GROUP_NAME , :HHOLD_ADDRESS , :HHOLD_CITY , :HHOLD_COUNTRY , :HHOLD_STATE , :HHOLD_ZIP , :INCOME_RANGE , :INCOME_RANGE_I , :MAIN_PH_FAX_NUM , :MAIN_PH_NUM , :MKT_SEGMENT , :MKT_SEGMENT_I , :NAME , WNERSHIP , WNERSHIP_I , ARENT_NAME , R_CON_ID , :REGION , :STATUS , :STATUS_I , :"TYPE" , :TYPE_I , :U_CURCY_CD , :WEALTH_RANGE , :WEALTH_RANGE_I ) ; /* end DML Section */ /* Begin Import Section */ .Import Infile 'file=\\.\pipe\w_household_scd2.out' Layout InputFileLayout Format Unformat Apply tagDML ;/* End Import Section */ .END LOAD;.LOGOFF; ERROR LOG CORRESPONDING TO THIS PARTICULAR CONTROL FILE=============================================================0007 .BEGIN LOAD ERRORTABLE ET_W_HHOLD_SCD0 ERRLIMIT 5000 CHECKPOINT 0 TENACITY 4 SESSIONS 5 SLEEP 6 SERIALIZE ON PACK 5 ROBUST OFF NOMONITOR ; ======================================================================== = = = Processing TPump Statements = = = ========================================================================0008 /* Begin Layout Section */ .Layout InputFileLayout;0009 .Field DATASOURCE_NUM_ID 1 CHAR( 12) ;0010 .Field ETL_PROC_WID 13 CHAR( 12) ;0011 .Field INTEGRATION_ID 25 CHAR( 30) ;0012 .Field ROW_WID 55 CHAR( 12) KEY ;0013 .Field SCD_END_DT_WID 67 CHAR( 12) ;0014 .Field SCD_START_DT_WID 79 CHAR( 12) KEY ;0015 .Field AVERAGE_AGE 91 CHAR( 24) NULLIF AVERAGE_AGE = '*' ;0016 .Field CREATED_DT 115 CHAR( 19) NULLIF CREATED_DT = '*' ;0017 .Field CREDIT_SCORE 134 CHAR( 24) NULLIF CREDIT_SCORE = '*' ;0018 .Field DEPENDS_NUM 158 CHAR( 12) NULLIF DEPENDS_NUM = '*' ;0019 .Field HH_INCOME 170 CHAR( 24) NULLIF HH_INCOME = '*' ;0020 .Field HH_REVENUE 194 CHAR( 24) NULLIF HH_REVENUE = '*' ;0021 .Field MAIL_FLG 218 CHAR( 1) NULLIF MAIL_FLG = '*' ;0022 .Field MEDIAN_AGE 219 CHAR( 12) NULLIF MEDIAN_AGE = '*' ;0023 .Field NUM_CONTACTS 231 CHAR( 12) NULLIF NUM_CONTACTS = '*' ;0024 .Field NUM_PROD 243 CHAR( 12) NULLIF NUM_PROD = '*' ;0025 .Field U_EXCH_DT 255 CHAR( 19) NULLIF U_EXCH_DT = '*' ;0026 .Field U_HH_INCOME 274 CHAR( 24) NULLIF U_HH_INCOME = '*' ;0027 .Field U_HH_REVENUE 298 CHAR( 24) NULLIF U_HH_REVENUE = '*' ;0028 .Field U_WEALTH_AMT 322 CHAR( 24) NULLIF U_WEALTH_AMT = '*' ;0029 .Field WEALTH_AMT 346 CHAR( 24) NULLIF WEALTH_AMT = '*' ;0030 .Field ANNUAL_INCOME 370 CHAR( 30) NULLIF ANNUAL_INCOME = '*' ;0031 .Field ANNUAL_INCOME_I 400 CHAR( 50) NULLIF ANNUAL_INCOME_I = '*' ;0032 .Field BU_NAME 450 CHAR( 100) NULLIF BU_NAME = '*' ;0033 .Field CATEGORY 550 CHAR( 30) NULLIF CATEGORY = '*' ;0034 .Field CATEGORY_I 580 CHAR( 50) NULLIF CATEGORY_I = '*' ;0035 .Field CON_FST_NAME 630 CHAR( 50) NULLIF CON_FST_NAME = '*' ;0036 .Field CON_LST_NAME 680 CHAR( 50) NULLIF CON_LST_NAME = '*' ;0037 .Field GROUP_NAME 730 CHAR( 100) NULLIF GROUP_NAME = '*' ;0038 .Field HHOLD_ADDRESS 830 CHAR( 200) NULLIF HHOLD_ADDRESS = '*' ;0039 .Field HHOLD_CITY 1030 CHAR( 50) NULLIF HHOLD_CITY = '*' ;0040 .Field HHOLD_COUNTRY 1080 CHAR( 30) NULLIF HHOLD_COUNTRY = '*' ;0041 .Field HHOLD_STATE 1110 CHAR( 50) NULLIF HHOLD_STATE = '*' ;0042 .Field HHOLD_ZIP 1160 CHAR( 30) NULLIF HHOLD_ZIP = '*' ;0043 .Field INCOME_RANGE 1190 CHAR( 30) NULLIF INCOME_RANGE = '*' ;0044 .Field INCOME_RANGE_I 1220 CHAR( 50) NULLIF INCOME_RANGE_I = '*' ;0045 .Field MAIN_PH_FAX_NUM 1270 CHAR( 40) NULLIF MAIN_PH_FAX_NUM = '*' ;0046 .Field MAIN_PH_NUM 1310 CHAR( 40) NULLIF MAIN_PH_NUM = '*' ;0047 .Field MKT_SEGMENT 1350 CHAR( 30) NULLIF MKT_SEGMENT = '*' ;0048 .Field MKT_SEGMENT_I 1380 CHAR( 50) NULLIF MKT_SEGMENT_I = '*' ;0049 .Field NAME 1430 CHAR( 100) NULLIF NAME = '*' ;0050 .Field OWNERSHIP 1530 CHAR( 30) NULLIF OWNERSHIP = '*' ;0051 .Field OWNERSHIP_I 1560 CHAR( 50) NULLIF OWNERSHIP_I = '*' ;0052 .Field PARENT_NAME 1610 CHAR( 30) NULLIF PARENT_NAME = '*' ;0053 .Field PR_CON_ID 1640 CHAR( 30) NULLIF PR_CON_ID = '*' ;0054 .Field REGION 1670 CHAR( 40) NULLIF REGION = '*' ;0055 .Field STATUS 1710 CHAR( 30) NULLIF STATUS = '*' ;0056 .Field STATUS_I 1740 CHAR( 50) NULLIF STATUS_I = '*' ;0057 .Field TYPE 1790 CHAR( 30) NULLIF TYPE = '*' ;0058 .Field TYPE_I 1820 CHAR( 50) NULLIF TYPE_I = '*' ;0059 .Field U_CURCY_CD 1870 CHAR( 20) NULLIF U_CURCY_CD = '*' ;0060 .Field WEALTH_RANGE 1890 CHAR( 30) NULLIF WEALTH_RANGE = '*' ;0061 .Field WEALTH_RANGE_I 1920 CHAR( 50) NULLIF WEALTH_RANGE_I = '*' ;0062 .Filler EOL_PAD 1970 CHAR( 2) ;0063 /* End Layout Section */ /* begin DML Section */ .DML Label tagDML Do insert for missing update rows;0064 UPDATE DT_RMW.W_HHOLD_SCD SET DATASOURCE_NUM_ID = ATASOURCE_NUM_ID , ETL_PROC_WID = :ETL_PROC_WID , INTEGRATION_ID = :INTEGRATION_ID , SCD_END_DT_WID = :SCD_END_DT_WID , AVERAGE_AGE = :AVERAGE_AGE , CREATED_DT = :CREATED_DT , CREDIT_SCORE = :CREDIT_SCORE , DEPENDS_NUM = EPENDS_NUM , HH_INCOME = :HH_INCOME , HH_REVENUE = :HH_REVENUE , MAIL_FLG = :MAIL_FLG , MEDIAN_AGE = :MEDIAN_AGE , NUM_CONTACTS = :NUM_CONTACTS , NUM_PROD = :NUM_PROD , U_EXCH_DT = :U_EXCH_DT , U_HH_INCOME = :U_HH_INCOME , U_HH_REVENUE = :U_HH_REVENUE , U_WEALTH_AMT = :U_WEALTH_AMT , WEALTH_AMT = :WEALTH_AMT , ANNUAL_INCOME = :ANNUAL_INCOME , ANNUAL_INCOME_I = :ANNUAL_INCOME_I , BU_NAME = :BU_NAME , CATEGORY = :CATEGORY , CATEGORY_I = :CATEGORY_I , CON_FST_NAME = :CON_FST_NAME , CON_LST_NAME = :CON_LST_NAME , GROUP_NAME = :GROUP_NAME , HHOLD_ADDRESS = :HHOLD_ADDRESS , HHOLD_CITY = :HHOLD_CITY , HHOLD_COUNTRY = :HHOLD_COUNTRY , HHOLD_STATE = :HHOLD_STATE , HHOLD_ZIP = :HHOLD_ZIP , INCOME_RANGE = :INCOME_RANGE , INCOME_RANGE_I = :INCOME_RANGE_I , MAIN_PH_FAX_NUM = :MAIN_PH_FAX_NUM , MAIN_PH_NUM = :MAIN_PH_NUM , MKT_SEGMENT = :MKT_SEGMENT , MKT_SEGMENT_I = :MKT_SEGMENT_I , NAME = :NAME , OWNERSHIP = WNERSHIP , OWNERSHIP_I = WNERSHIP_I , PARENT_NAME = ARENT_NAME , PR_CON_ID = R_CON_ID , REGION = :REGION , STATUS = :STATUS , STATUS_I = :STATUS_I , TYPE = :TYPE , TYPE_I = :TYPE_I , U_CURCY_CD = :U_CURCY_CD , WEALTH_RANGE = :WEALTH_RANGE , WEALTH_RANGE_I = :WEALTH_RANGE_I WHERE ROW_WID = :ROW_WID AND SCD_START_DT_WID = :SCD_START_DT_WID ; 0065 INSERT INTO DT_RMW.W_HHOLD_SCD ( DATASOURCE_NUM_ID , ETL_PROC_WID , INTEGRATION_ID , ROW_WID , SCD_END_DT_WID , SCD_START_DT_WID , AVERAGE_AGE , CREATED_DT , CREDIT_SCORE , DEPENDS_NUM , HH_INCOME , HH_REVENUE , MAIL_FLG , MEDIAN_AGE , NUM_CONTACTS , NUM_PROD , U_EXCH_DT , U_HH_INCOME , U_HH_REVENUE , U_WEALTH_AMT , WEALTH_AMT , ANNUAL_INCOME , ANNUAL_INCOME_I , BU_NAME , CATEGORY , CATEGORY_I , CON_FST_NAME , CON_LST_NAME , GROUP_NAME , HHOLD_ADDRESS , HHOLD_CITY , HHOLD_COUNTRY , HHOLD_STATE , HHOLD_ZIP , INCOME_RANGE , INCOME_RANGE_I , MAIN_PH_FAX_NUM , MAIN_PH_NUM , MKT_SEGMENT , MKT_SEGMENT_I , NAME , OWNERSHIP , OWNERSHIP_I , PARENT_NAME , PR_CON_ID , REGION , STATUS , STATUS_I , TYPE , TYPE_I , U_CURCY_CD , WEALTH_RANGE , WEALTH_RANGE_I ) VALUES ( ATASOURCE_NUM_ID , :ETL_PROC_WID , :INTEGRATION_ID , :ROW_WID , :SCD_END_DT_WID , :SCD_START_DT_WID , :AVERAGE_AGE , :CREATED_DT , :CREDIT_SCORE , EPENDS_NUM , :HH_INCOME , :HH_REVENUE , :MAIL_FLG , :MEDIAN_AGE , :NUM_CONTACTS , :NUM_PROD , :U_EXCH_DT , :U_HH_INCOME , :U_HH_REVENUE , :U_WEALTH_AMT , :WEALTH_AMT , :ANNUAL_INCOME , :ANNUAL_INCOME_I , :BU_NAME , :CATEGORY , :CATEGORY_I , :CON_FST_NAME , :CON_LST_NAME , :GROUP_NAME , :HHOLD_ADDRESS , :HHOLD_CITY , :HHOLD_COUNTRY , :HHOLD_STATE , :HHOLD_ZIP , :INCOME_RANGE , :INCOME_RANGE_I , :MAIN_PH_FAX_NUM , :MAIN_PH_NUM , :MKT_SEGMENT , :MKT_SEGMENT_I , :NAME , WNERSHIP , WNERSHIP_I , ARENT_NAME , R_CON_ID , :REGION , :STATUS , :STATUS_I , :TYPE , :TYPE_I , :U_CURCY_CD , :WEALTH_RANGE , :WEALTH_RANGE_I ) ; 0066 /* end DML Section */ /* Begin Import Section */ .Import Infile '\\.\pipe\w_household_scd1.out' Layout InputFileLayout Format Unformat Apply tagDML ;0067 /* End Import Section */ .END LOAD;**** 12:15:41 UTY8001 RDBMS failure in Stmt Check: 3707, Syntax error, expected something like a name between ',' and the 'TYPE' keyword.**** 12:15:41 UTY6651 Error preparing upsert SQL for DML label TAGDML. Insert will be done for missing update.**** 12:15:41 UTY6609 Starting to log on sessions...**** 12:15:42 UTY6610 Logged on 5 sessions. ======================================================================== = = = TPump Import(s) Beginning = = = ========================================================================**** 12:15:42 UTY6630 Options in effect for following TPump Import(s): . Tenacity: 4 hour limit to successfully connect load sessions. . Max Sessions: 5 session(s). . Min Sessions: 4 session(s). . Checkpoint: 0 minute(s). . Errlimit: 5000 rejected record(s). . Restart Mode: SIMPLE. . Serialization: ON. . Packing: 5 Statements per Request. . StartUp Rate: UNLIMITED Statements per Minute.**** 12:15:42 UTY8001 RDBMS failure in Stmt Check: 3707, Syntax error, expected something like a name between ',' and the 'TYPE' keyword. ======================================================================== = = = Logoff/Disconnect = = = ========================================================================**** 12:15:42 UTY6215 The restart log table has NOT been dropped.**** 12:15:43 UTY6212 A successful disconnect was made from the RDBMS.**** 12:15:43 UTY2410 Total processor time used = '0.1875 Seconds' . Start : 12:15:38 - SUN JUL 01, 2007 . End : 12:15:43 - SUN JUL 01, 2007 . Highest return code encountered = '8'.Thanks & RegardsSreekanth

You must sign in to leave a comment.