how to generate a dynamic file name

Angel · Post by **Angel** » Wed Sep 03, 2003 2:57 am

Hi,
I want to create a file name during run time. There is the DSJobStartDate macro, but probably I not used it correctly. How can I use it?.

I am writing this one in the Sequential file stage:
File Name: /var/opt/aat/p/sl/shr/carga_fz_SLDIOMQ:'_':DSJobStartDate
but the file name result is carga_fz_SLDIOMQ:'_':DSJobStartDate and not carga_fx_SLDIOMQ_2003_09_03.

Thanks,
Angel

spracht · Post by **spracht** » Wed Sep 03, 2003 3:16 am

Angel

afaik, this can't be done in a sequential file stage. All you can do there to derive a file name is to use job parameters.

Stephan

ariear · Post by **ariear** » Wed Sep 03, 2003 6:45 am

Hi,

You must enclose the macros like regular params i.e. #SomeDefinedParam#_#DSJobStartDate#_#DSJobStartTime#

spracht · Post by **spracht** » Wed Sep 03, 2003 7:11 am

You live and learn! (or better: YLAL [:D])

Stephan

raju_chvr · Post by **raju_chvr** » Mon Sep 29, 2003 12:45 pm

TestDate_#DSJobStartDate#_#DSJobStartTime#.txt

this is the filename that has been generated when I have used:
#SomeDefinedParam#_#DSJobStartDate#_#DSJobStartTime#

ariear, Can anyone tell me what is the proper syntax for this and also the proper 'Type' I should use for the job parameter.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 29, 2003 5:50 pm

The syntax looks OK, provided that the references to job parameters or macros are properly spelled and cased.
The parameter type can be String or Pathname. I'd recommend Pathname, because (a) you can then locate the text file anywhere in the file system, and (b) the operator gets a browser when being prompted for the file name.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

raju_chvr · Post by **raju_chvr** » Tue Sep 30, 2003 7:11 am

I have done it using Pathname and the problem still persists.

the filename that is being generated is:

TestDate_#DSJobStartDate#_#DSJobStartTime#.txt

the macros are not being evaluated into values, and also i am not enclosing the above in any quotes.

Can Ray.Wurlod or ariear comment on this, please ?

thanks

Optico · Post by **Optico** » Tue Sep 30, 2003 7:58 am

I don't know if there will be any other comments that you can use, but using the DSJobStartDate encompassed by '#' in the filename works perfectly on a 5.1 installation running on W2K.
Unfortunately you cannot browse the file from the Designer afterwards but you can from the explorer.

B. Sorensen,
Optico IT ApS

raju_chvr · Post by **raju_chvr** » Tue Sep 30, 2003 8:21 am

great it worked!!.. thanks

can it also create folders dynamically?

ray.wurlod · Post by **ray.wurlod** » Tue Sep 30, 2003 5:10 pm

In general, no. The Sequential File stage works with files. However, if you need to create a directory you can set up ExecSH (or ExecDOS on a Windows platform) as a before-stage subroutine with an appropriate mkdir command in the InputArg field. You can use job parameters and macros here too.
You might want to include a test for existence before trying to mkdir because, if ExecSH fails, the job aborts. For example:[-d #pathname#] !! mkdir #pathname# && chmod 664 #pathname#

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518