ODBC columns limit

Post by **admin** » Wed May 09, 2001 2:02 am

Hi, all

Ive got a problem with ODBC Stage. I tried to update almost 100 columns. but job ran aborted without any prompt. After trying several times, I found out it seems that ODBC Stage have a limit of 80 columns. is it right?

Does anybody have experience and idea about this problem.

Thanks in advance.

Xiong

Post by **admin** » Wed May 09, 2001 2:19 am

The column limit is 400 by default for the ODBC stage.
This can be changed by setting MAXFETCHCOLS in the uvodbc.config file.

Some databases (e.g. MS Access) limit a result set to 256 columns.

Some ODBC drivers also impose a limit. This is not a DataStage issue.

-----Original Message-----
From: Xiong Li [mailto:Xiong.Li@nzbsg.co.nz]
Sent: Wednesday, 09 May 2001 12:03
To: informix-datastage@oliver.com
Subject: ODBC columns limit

Hi, all

Ive got a problem with ODBC Stage. I tried to update almost 100 columns. but job ran aborted without any prompt. After trying several times, I found out it seems that ODBC Stage have a limit of 80 columns. is it right?

Does anybody have experience and idea about this problem.

Thanks in advance.

Xiong

Post by **admin** » Wed May 09, 2001 10:23 pm

Xiong,

Hong has run into this problem before at Bluestar. He ended up logging a call with informix support and the workaround was to split the (select in his case) into two.

Phil.

> -----Original Message-----
> From: Xiong Li [SMTP:Xiong.Li@nzbsg.co.nz]
> Sent: Wednesday, May 09, 2001 2:03 PM
> To: informix-datastage@oliver.com
> Subject: ODBC columns limit
>
> Hi, all
>
> Ive got a problem with ODBC Stage. I tried to update almost 100
> columns. but job ran aborted without any prompt. After trying several
> times, I found out it seems that ODBC Stage have a limit of 80
> columns. is it right?
>
> Does anybody have experience and idea about this problem.
>
> Thanks in advance.
>
> Xiong