how to generate alphanumeric sequence

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
shailesh_pendkar
Participant
Posts: 5
Joined: Thu Sep 08, 2005 3:28 am
Location: india

how to generate alphanumeric sequence

Post by shailesh_pendkar »

Wanted to know how to generate alphanumeric sequence in datastage server Edition?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Define what you mean and include an excellent example so we don't go chasing the wild gooses.
-craig

"You can never have too many knives" -- Logan Nine Fingers
nivas
Participant
Posts: 117
Joined: Sun Mar 21, 2004 4:40 pm

Re: how to generate alphanumeric sequence

Post by nivas »

use 2 stage varaibles to increment two numbers. First one pass as a parameter to CHAR() and concatename this to the second second incremented stage variables. This is an outline. For example You can achieve as follows. Or you can achieve many sequences

A1, B1, C1....Z1
A2,B2,C2...Z2
Post Reply