Routine Argument maximum size

jonathanhale · Post by **jonathanhale** » Tue Jan 13, 2009 10:39 am

does anyone know how big an argument passed to a datstage routine is allowed to be? (maximum size in chars)

chulett · Post by **chulett** » Tue Jan 13, 2009 10:47 am

Don't know for sure, but pretty darn big... assuming max string size for your machine architecture. What kind of sizes are you pondering using?

jonathanhale · Post by **jonathanhale** » Tue Jan 13, 2009 12:52 pm

hoping it will work with a 4MB char string?

chulett · Post by **chulett** » Tue Jan 13, 2009 12:56 pm

Hmmm... interesting you would specify a size in megabytes rather than a character count. We'll need to see what one of the Grognards has to say on the subject.

jonathanhale · Post by **jonathanhale** » Tue Jan 13, 2009 1:00 pm

I'm slightly concerned I'll end up regretting this post... but who or what are Grognards?

chulett · Post by **chulett** » Tue Jan 13, 2009 1:12 pm

"Grognard" is French for "grumbler" and something Napoleon called his Old Guard, his grizzled veterans. I mean some of the folks here who've been involved with DataStage since Day 1 and actually worked for the various companies involved, authored some of this stuff... people like Ray or Arnd, for example.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 13, 2009 2:43 pm

There is no limit in the product. There is a physical limit based on how much memory is available.

LenGreenwood · Post by **LenGreenwood** » Wed Jan 14, 2009 4:23 am

DSEngine's Virtual Machine will have an upper limit of about 2GB on the length of a string variable that it can represent. In practice you don't get near that because of physical limitations, as Ray said.

jonathanhale · Post by **jonathanhale** » Wed Jan 14, 2009 10:43 am

in testing DataStage is happy to receive and process 40000 char as an arg to a routine. I haven't yet got test data for the threatened 4 MB, but it's looking good...