Hi,
My requiremnet is to update a SQL table .
SQL table has field with BIGINT.they are not willing change type to VARCHAR
I wrote a custom code to push the data.I am using DBCO for this process.
I am getting a dump when i push this data.
below is the source code.
Any ideas ?
DATA: BEGIN OF itab OCCURS 0,
matnr like marc-matnr,
maktx LIKE makt-maktx,
werks LIKE marc-werks,
bismt LIKE mara-bismt,
END OF itab.
EXEC SQL.
CONNECT TO 'TEST' AS 'V'
ENDEXEC.
EXEC SQL.
SET CONNECTION 'V'
ENDEXEC.
loop at itab.
shift itab-matnr left deleting leading '0'.
EXEC SQL.
INSERT INTO SapProducts
( ProductID<bigint>, ProductName)
VALUES
(:ITAB-MATNR, :ITAB-MAKTX)
ENDEXEC.
endloop.
Database error text........: "Error converting data type nvarchar to bigint."
Database error code........: 8114
Triggering SQL statement...: "INSERT INTO SapProducts ( ProductID, ProductName
) VALUES ( ? , ? )"
Internal call code.........: "[DBDS/NEW DSQL]"
Please check the entries in the system log (Transaction SM21).
If the error occures in a non-modified SAP program, you may be able to
find an interim solution in an SAP Note.
If you have access to SAP Notes, carry out a search with the following
keywords:
"DBIF_DSQL2_SQL_ERROR" "CX_SY_NATIVE_SQL_ERROR"
"ZCMP_SHELF_UPDATE" or "ZCMP_SHELF_UPDATE"
Edited by: PRAVEEN s on Feb 28, 2008 10:14 PM
Bluesky
