How to create Sequence file with date stamp?

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

How to create Sequence file with date stamp?

Post by SURA »

Hi,

I need to create a sequence file in daily basic with current date as the part of the file name.

Eg: If i run the job today then the file name should be Out_12_01_08.txt

How to do this?

Pls help me.


Sura
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You either need to pass the 'stamp' in as a job parameter (we do this) and then use #it# in the name, or create a constant filename and then rename it in the O/S after job. It's been discussed here a bajillion times.
-craig

"You can never have too many knives" -- Logan Nine Fingers
samsuf2002
Premium Member
Premium Member
Posts: 397
Joined: Wed Apr 12, 2006 2:28 pm
Location: Tennesse

Post by samsuf2002 »

hi sam here
just4u_sharath
Premium Member
Premium Member
Posts: 236
Joined: Sun Apr 01, 2007 7:41 am
Location: Michigan

Post by just4u_sharath »

Usually a sequence starts with a user variables activity. In that activity create a new row and give the name as "date" and on the right side give value as 'out_':DSjobStartdate( this is DSmacro):'.txt'. Now in the output file name use "#uservariable activity name.date#'. If this process looks weird you can directly use as a parameter called directly form sequencer
Post Reply