Hi,
Iam using varchar(max), varchar(4000) and varchar(5000) in the ODBC Source.
I think such large types are not allowed.
Can sombody tell me what is the max type I can use for datastage.
Thanks!
What is the maximum length of varchar allowed
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Fri Jul 17, 2009 11:42 am
-
- Participant
- Posts: 9
- Joined: Fri Jul 17, 2009 11:42 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DataStage IS able to do so, but may you have to tune the maximum number of columns and, probably, maximum buffer size for the DSN. You do this in the uvodbc.config file using MAXFETCHCOLS and MAXFETCHBUFF parameters. Of course, the maximum size of a VarChar column is limited by the ODBC driver itself. It's probably 4096. Beyond that you have to go to LongVarChar, which goes to 65536 for most ODBC drivers.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.