HELP PLEASE - Informix SQL Error -479 
Author Message
 HELP PLEASE - Informix SQL Error -479

Quote:

> The message received reads as follows :

> EXECUTE Cannot prepare statement: stmtFldP : SQL: -479: The number of
> DESCRIBED columns is greater than the allocated space.

> I am using Perl DBI to do INSERT INTO on the table rows in my database.
> This particular table has 261 columns,row size 2107

> Is this table too big?     If not, how can i find out what descriptors exist
> in the database so I can change them via the ALLOCATE DESCRIPTOR command
> so I can grab all 261 columns.

One of the nastier features of the SQL DESCRIPTOR system is that you have
to know in advance how many columns you might need to describe.  Somewhere
in dbdimp.ec there's a line which says:

        EXEC SQL ALLOCATE DESCRIPTOR :nm_obind WITH MAX 128;

It's line 1155 in my current version.  Change the 128 to some suitable
larger number, such as 261...  Or hack the code to do something more
intelligent and send me the result.  Or really hack the whole of the code
to use sqlda structures instead of SQL DESCRIPTORS and send me that!
Thanks -- that'd be a wonderful Christmas present, and I don't mind if it's
a day or two late.

Yours,



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. SQL Server 6.5 (6.50.479) & sp_rename

2. PLEASE HELP --- Informix SE and Uniface 6 --- PLEASE HELP

3. Informix ODBC 3.32 ERROR - PLEASE HELP

4. COMBO BOX, PLEASE HELP, PLEASE HELP, PLEASE HELP!

5. Accessing Informix data (Informix experts - please help)

6. Please Help !!! SQL 7 Error 22274 (SQL-DMO)

7. Please help, SQL Server Agent and SQL DMO Error (URGENT)

8. Please help, SQL Server Agent and SQL DMO Error (URGENT)

9. Please Help: Experiencing trouble setting up SQL Links 3.5 and Informix

10. ODBC MS SQL Server and Informix help please

11. INFORMIX ODBC error , [State=S1000][Error=-406][INTERSOLV][ODBC Informix driver][Informix]Unable


 
Powered by phpBB® Forum Software