Can someone see something here that would be causing this error? Im loading from teh SAP plugin into a MDB. All the fields are described as "Nullable".
Thanks,
dave
S701Extract.PickGoodRecords.BreederStatsUploadODBC: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO `BreederStatsUpload`(RRN, ORDER, PROCESS_DATE, PLANT, FARM, AGE_WK, MOVED, CAPITL, HENS_ON_FARM, MALES_ON_FARM, CLASS1_EGGS, CLASS2_EGGS, CLASS3_EGGS, S701_ZGP_PROCES, S701_ZGP_WEEK, S701_ZGP_YEAR, PLACE_DATE) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
SQLSTATE=37000, DBMS.CODE=-3502
[Ardent][SQL Client][ODBC][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
RRN = 8529
ORDER = "000100768668"
PROCESS_DATE = "07/07/01"
PLANT = "LP20"
FARM = "LP2P4082"
AGE_WK = 21
MOVED = NULL
CAPITL = NULL
HENS_ON_FARM = 0
MALES_ON_FARM = 0
CLASS1_EGGS = NULL
CLASS2_EGGS = NULL
CLASS3_EGGS = NULL
S701_ZGP_PROCES = "20010707"
S701_ZGP_WEEK = "40"
S701_ZGP_YEAR = "2001"
PLACE_DATE = "02/10/01"
Syntax error in INSERT? The SQL stmt is generated by DS(?)
Are all the column names spelled exactly correctly? (In particular should S701_ZGP_PROCES be S701_ZGP_PROCESS and CAPITL be CAPITAL?). Sometimes MS Access wants (single) quotes around the parameter markers, at other times it seems not to. I have had weird problems with differences between Access 97 and Access 2000 in this vein.
Thanks, Ray, I look at it and see if this is the issue.
Regards,
W. David Daugherty
Pilgrims Pride Corporation
(903) 855-4397 Voice
(903) 855-4133 Fax
-----Original Message-----
From: Ray Wurlod [mailto:ray.wurlod@Informix.Com]
Sent: Thursday, July 05, 2001 5:45 PM
To: datastage-users@oliver.com
Subject: RE: Syntax error in INSERT? The SQL stmt is generated by DS(?)
Are all the column names spelled exactly correctly? (In particular should S701_ZGP_PROCES be S701_ZGP_PROCESS and CAPITL be CAPITAL?). Sometimes MS Access wants (single) quotes around the parameter markers, at other times it seems not to. I have had weird problems with differences between Access 97 and Access 2000 in this vein.
Regards,
W. David Daugherty
Pilgrims Pride Corporation
(903) 855-4397 Voice
(903) 855-4133 Fax
-----Original Message-----
From: Ray Wurlod [mailto:ray.wurlod@Informix.Com]
Sent: Thursday, July 05, 2001 5:45 PM
To: datastage-users@oliver.com
Subject: RE: Syntax error in INSERT? The SQL stmt is generated by DS(?)
Are all the column names spelled exactly correctly? (In particular should S701_ZGP_PROCES be S701_ZGP_PROCESS and CAPITL be CAPITAL?). Sometimes MS Access wants (single) quotes around the parameter markers, at other times it seems not to. I have had weird problems with differences between Access 97 and Access 2000 in this vein.