Arne Gehlhaar wrote:
Hi,
I've run into another problem with SAP-DB. We are trying to port a rather large Perl project from Adabas to SAP-DB. But whenever an insert statement uses date or time columns in INTERNAL format it cause an error:
DBD::ODBC::db prepare failed: [unixODBC][SAP AG][LIBSQLOD SO][SAP DB]Datetime field overflow;-3048 POS(113) Invalid date format:ISO. (SQL-22008)(DBD: st_prepare/SQLPrepare err=-1)
I've checked all the docs but could not find any command to change the default date or time format.
[...]
There is the command SET FORMAT ... to change this, but it doesn't work in ODBC mode because the ODBC driver parses the values. So it has to know the format. If you want to keep the application portable between Adabas D and SAP DB, you could use ISO format and execute SET FORMAT ISO in the Adabas D case.Is there any chance SAP-DB will take INTERNAL date/time values with Perl??
Daniel Dittmar
--
Daniel Dittmar
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
