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
DataStage can use much larger strings. Oracle and DB2, for instance, have limits on VarChar() sizes and I am fairly certain that the ODBC definition also limits strings.
Specifically, which database and version are you interested in?
Specifically, which database and version are you interested in?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 9
- Joined: Fri Jul 17, 2009 11:42 am
Important is also your table definition, I would think that if your table definition as well as ODBC definition is VarChar(4000) that should go through without a problem.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- 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.