Sequence values as 0000-9999,AA-ZZ & Space in same colum

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
jimgowtham
Participant
Posts: 34
Joined: Thu Feb 16, 2006 8:34 am
Location: mumbai

Sequence values as 0000-9999,AA-ZZ & Space in same colum

Post by jimgowtham »

Hi

I want to generate a values for Column A, the values should be in the range 0000-9999 and next value should be AA-ZZ & Space.This Column is not populated from the source file. My job design is ....




Source_Sequential_File-------->Transformer---------->Target_Seq_File

Thanks & regards
M.Gowthaman :?
M.Gowthaman,
Accenture Service Pvt Ltd, M2A.
Mobile: +91 9819713784
Ext No: 4323
“Developing Software & Walking through water are easy, if it is frozen..."
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You will need to write this yourself. Use a Routine that stores the current value in a variable declared to be in COMMON.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply