DEVCALLHISTORY.CTransformerStage1.DSLink4: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO pubs.guest.CALL_HISTORY (CallID, SiteID, CustomerDetailID, RepAssigned, CallStatus, CallType, CallPriority, CallDate) VALUES (?,?,?,?,?,?,?,?)
SQLSTATE=22005, DBMS.CODE=0
[Ardent][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
CallID = 1496371
SiteID = SF132402-1
CustomerDetailID = 3
RepAssigned = DMO63370
CallStatus = C
CallType = PJ
CallPriority = P3
CallDate = "03-06-2000 15:10:34
The CallDate is a Timestamp type in a SQL 7 database. Anyone know how I can get rid of this message or what Im doing wrong.
Timestamp Problem
Mike,
I think your date is backwards it should be 2000-03-06 15:10:34 Try using the d-ymd[4,2,2] conversion instead of d4-.
Mark
-----Original Message-----
From: Roosa, Mike [mailto:Mike.Roosa@getronics.com]
Sent: Thursday, August 03, 2000 11:20 AM
To: informix-datastage@oliver.com
Subject: Timestamp Problem
DEVCALLHISTORY.CTransformerStage1.DSLink4: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO pubs.guest.CALL_HISTORY (CallID, SiteID, CustomerDetailID, RepAssigned, CallStatus, CallType, CallPriority, CallDate) VALUES (?,?,?,?,?,?,?,?)
SQLSTATE=22005, DBMS.CODE=0
[Ardent][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
CallID = 1496371
SiteID = SF132402-1
CustomerDetailID = 3
RepAssigned = DMO63370
CallStatus = C
CallType = PJ
CallPriority = P3
CallDate = "03-06-2000 15:10:34
The CallDate is a Timestamp type in a SQL 7 database. Anyone know how I can get rid of this message or what Im doing wrong.
I think your date is backwards it should be 2000-03-06 15:10:34 Try using the d-ymd[4,2,2] conversion instead of d4-.
Mark
-----Original Message-----
From: Roosa, Mike [mailto:Mike.Roosa@getronics.com]
Sent: Thursday, August 03, 2000 11:20 AM
To: informix-datastage@oliver.com
Subject: Timestamp Problem
DEVCALLHISTORY.CTransformerStage1.DSLink4: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO pubs.guest.CALL_HISTORY (CallID, SiteID, CustomerDetailID, RepAssigned, CallStatus, CallType, CallPriority, CallDate) VALUES (?,?,?,?,?,?,?,?)
SQLSTATE=22005, DBMS.CODE=0
[Ardent][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
CallID = 1496371
SiteID = SF132402-1
CustomerDetailID = 3
RepAssigned = DMO63370
CallStatus = C
CallType = PJ
CallPriority = P3
CallDate = "03-06-2000 15:10:34
The CallDate is a Timestamp type in a SQL 7 database. Anyone know how I can get rid of this message or what Im doing wrong.
HERE IS THE CODE THAT I USE TO CREATE A DATETIME STAMP
Oconv(DATE(),"D-YMD[4,2,2]"):" ":Oconv(TIME(),"MTS")
Mark Griffin
AMP Sr. Application Developer
Data Warehouse Systems
CIGNA Healthcare
Two College Park Drive, 454
Hooksett, NH 03106
Phone: 603-430-7610
603-268-7239
Fax: 603-268-7909
email: griffimk@hlthsrc.com
>>> mark.auclair@ardentsoftware.com 08/03 12:13 PM >>>
Mike,
I think your date is backwards it should be 2000-03-06 15:10:34 Try using the d-ymd[4,2,2] conversion instead of d4-.
Mark
-----Original Message-----
From: Roosa, Mike [mailto:Mike.Roosa@getronics.com]
Sent: Thursday, August 03, 2000 11:20 AM
To: informix-datastage@oliver.com
Subject: Timestamp Problem
DEVCALLHISTORY.CTransformerStage1.DSLink4: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO pubs.guest.CALL_HISTORY (CallID, SiteID, CustomerDetailID, RepAssigned, CallStatus, CallType, CallPriority, CallDate) VALUES (?,?,?,?,?,?,?,?)
SQLSTATE=22005, DBMS.CODE=0
[Ardent][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
CallID = 1496371
SiteID = SF132402-1
CustomerDetailID = 3
RepAssigned = DMO63370
CallStatus = C
CallType = PJ
CallPriority = P3
CallDate = "03-06-2000 15:10:34
The CallDate is a Timestamp type in a SQL 7 database. Anyone know how I can get rid of this message or what Im doing wrong.
------------------------------------------------------------------------------
CONFIDENTIALITY NOTICE: If you have received this e-mail in error, please immediately notify the sender by e-mail at the address shown. This e-mail transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity of whom it is intended even if addressed incorrectly. Please delete from your files if you are not the intended recipient. Thank you for your compliance.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Oconv(DATE(),"D-YMD[4,2,2]"):" ":Oconv(TIME(),"MTS")
Mark Griffin
AMP Sr. Application Developer
Data Warehouse Systems
CIGNA Healthcare
Two College Park Drive, 454
Hooksett, NH 03106
Phone: 603-430-7610
603-268-7239
Fax: 603-268-7909
email: griffimk@hlthsrc.com
>>> mark.auclair@ardentsoftware.com 08/03 12:13 PM >>>
Mike,
I think your date is backwards it should be 2000-03-06 15:10:34 Try using the d-ymd[4,2,2] conversion instead of d4-.
Mark
-----Original Message-----
From: Roosa, Mike [mailto:Mike.Roosa@getronics.com]
Sent: Thursday, August 03, 2000 11:20 AM
To: informix-datastage@oliver.com
Subject: Timestamp Problem
DEVCALLHISTORY.CTransformerStage1.DSLink4: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO pubs.guest.CALL_HISTORY (CallID, SiteID, CustomerDetailID, RepAssigned, CallStatus, CallType, CallPriority, CallDate) VALUES (?,?,?,?,?,?,?,?)
SQLSTATE=22005, DBMS.CODE=0
[Ardent][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
CallID = 1496371
SiteID = SF132402-1
CustomerDetailID = 3
RepAssigned = DMO63370
CallStatus = C
CallType = PJ
CallPriority = P3
CallDate = "03-06-2000 15:10:34
The CallDate is a Timestamp type in a SQL 7 database. Anyone know how I can get rid of this message or what Im doing wrong.
------------------------------------------------------------------------------
CONFIDENTIALITY NOTICE: If you have received this e-mail in error, please immediately notify the sender by e-mail at the address shown. This e-mail transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity of whom it is intended even if addressed incorrectly. Please delete from your files if you are not the intended recipient. Thank you for your compliance.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++