Exception when trying to insert into AS400 DB2 from VB.NET
I have an ODBC connection setup to a DB2. I am trying to insert into a table from VB.NET, the code as follows:
Dim info as String = "'abc123'"
Dim insert as String = "INSERT INTO LIBRARY.FILE (LABEL) VALUES ('"& info &"')"
adpODBC.SelectCommand = New OdbcCommand(insert, odbcConnection)
After doing the Fill command, I get the following excepton:
System.OverflowException: "Arithmetic operation resulted in an overflow"
The LABEL (or FIELD) in the TABLE (or FILE) that I am using is of length 150. The Value trying to be inserted is much smaller than that, hence, I am stuck finding out why an overflow exception. Could it be a wrong syntax?