3707, Syntax error expected something like a name between ',' and the 'TYPE' keyword.

UDA

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
2 REPLIES

Re: 3707, Syntax error expected something like a name between ',' and the 'TYPE' keyword.

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?

Re: 3707, Syntax error expected something like a name between ',' and the 'TYPE' keyword.

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 tagDML
Do insert for missing update rows;
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
;
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 & Regards
Sreekanth