Page 1 of 1
ODBC columns limit
Posted: Wed May 09, 2001 2:02 am
by admin
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
Posted: Wed May 09, 2001 2:19 am
by admin
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
Posted: Wed May 09, 2001 10:23 pm
by admin
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