Stage Variable Maximum Length

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
patonp
Premium Member
Premium Member
Posts: 110
Joined: Thu Mar 11, 2004 7:59 am
Location: Toronto, ON

Stage Variable Maximum Length

Post by patonp »

A couple of simple questions...

Is there a maximum length for stage variables? How about variables used within routines?

Thanks!

Peter
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

I seem to recall that the length can be quite long, but only the first 32 characters are used to differentiate.
patonp
Premium Member
Premium Member
Posts: 110
Joined: Thu Mar 11, 2004 7:59 am
Location: Toronto, ON

Post by patonp »

Does this mean that if I compare two different stage variables that are 40 characters long, only the first 32 characters will actually be used in the comparison?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I'm guessing that Arnd meant the name of the stage variable.
-craig

"You can never have too many knives" -- Logan Nine Fingers
patonp
Premium Member
Premium Member
Posts: 110
Joined: Thu Mar 11, 2004 7:59 am
Location: Toronto, ON

Post by patonp »

OK - My question is actually about the maximum length of the value that may be stored in a variable.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

To answer the question you didn't ask - it's something 63 significant characters to the variable name.

To answer your real question :)

You can keep on adding length to DataStage variables until you run out of virtual process memory. The space is not allocated contiguously, either.
patonp
Premium Member
Premium Member
Posts: 110
Joined: Thu Mar 11, 2004 7:59 am
Location: Toronto, ON

Post by patonp »

Great! Thanks to both of you for the quick response!
Post Reply