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
ODBC columns limit
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
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
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
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