Page 1 of 1

how to generate alphanumeric sequence

Posted: Tue Jun 17, 2008 5:15 am
by shailesh_pendkar
Wanted to know how to generate alphanumeric sequence in datastage server Edition?

Posted: Tue Jun 17, 2008 6:24 am
by chulett
Define what you mean and include an excellent example so we don't go chasing the wild gooses.

Re: how to generate alphanumeric sequence

Posted: Tue Jun 17, 2008 10:01 am
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