AddNew Fails when too many fields are added

[baskar]

Hi,

I have a table with 90 fields. When I try to use the recordset with
addnew and set all the 90 fields and then update the record set it
fails the following error seen in the log,

[IBM][CLI Driver][DB2] SQL0117N The number of values assigned is not
the same as the number of specified or implied columns.
SQLSTATE=42802

But I'm able to set 40 fields and insert the record successfully. But
I'm able to update the table with all the 90 fields.

Is there any restriction with the recordset to insert maximum number
of fields or problem with the database (Using DB2 on Mainframes)

Can some one help me?

Thanks in Advance !

-Baskar

[Val Mazur]

Hi,

Some databases have a limit on a total length of the data, passed in one
record. For example, in a case of SQL Server you could have up to 1024
columns in a table, but the maximum number of bytes per row is 8,060. Also
some providers have limitations on a number of columns used in statements. I
think this is your case.

--
Val Mazur
Microsoft MVP
"baskar" <cb******@yahoo.co.in> wrote in message
news:b5**************************@posting.google.c om...

Hi,

I have a table with 90 fields. When I try to use the recordset with
addnew and set all the 90 fields and then update the record set it
fails the following error seen in the log,

[IBM][CLI Driver][DB2] SQL0117N The number of values assigned is not
the same as the number of specified or implied columns.
SQLSTATE=42802

But I'm able to set 40 fields and insert the record successfully. But
I'm able to update the table with all the 90 fields.

Is there any restriction with the recordset to insert maximum number
of fields or problem with the database (Using DB2 on Mainframes)

Can some one help me?

Thanks in Advance !

-Baskar

[Kums]

"Val Mazur" <gr******@hotmail.com> wrote in message news:<eH**************@TK2MSFTNGP09.phx.gbl>...

Hi,

Some databases have a limit on a total length of the data, passed in one
record. For example, in a case of SQL Server you could have up to 1024
columns in a table, but the maximum number of bytes per row is 8,060. Also
some providers have limitations on a number of columns used in statements. I
think this is your case.

--
Val Mazur
Microsoft MVP
"baskar" <cb******@yahoo.co.in> wrote in message
news:b5**************************@posting.google.c om...

Hi,

I have a table with 90 fields. When I try to use the recordset with
addnew and set all the 90 fields and then update the record set it
fails the following error seen in the log,

[IBM][CLI Driver][DB2] SQL0117N The number of values assigned is not
the same as the number of specified or implied columns.
SQLSTATE=42802

But I'm able to set 40 fields and insert the record successfully. But
I'm able to update the table with all the 90 fields.

Is there any restriction with the recordset to insert maximum number
of fields or problem with the database (Using DB2 on Mainframes)

Can some one help me?

Thanks in Advance !

-Baskar

Baskar,

DB2 allows 1012 columns/fields to be added. Is there a possiblity that
your record has lesser number of fields you are inserting than what is
in the table structure as is implied in the error message?