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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
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.
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...