FTP changing file names

homer2018 · Post by **homer2018** » Thu Jul 14, 2005 1:53 am

Hi

I'm looking for some expert advice on the following problem.

We need to daily FTP a file and load it to a DB2 environment. The filename contains a date stamp and therefore changes daily. What would you recommend as a solution for automating this.

Can I pass the system date as a parameter in the job to the FTP stage?

Any suggestion is appreciated.

Toon

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jul 14, 2005 2:43 am

You can use the date as part of your parameter for file name.

sudharsanan · Post by **sudharsanan** » Thu Jul 14, 2005 10:31 pm

Hi Gurus,

In the same topic, i need some expert advice on how to design. Now my existing jobs have a parameter = param1 in a sequence job which calls a routine. This routine will return me the corresponding value from a hashfile.

Now I have a new requirement to change the parameter as =param1#x#. The value for x will be passed automatically from a shell script. I tried giving the same option in my job but it was not able to pick the value from the hashfile. Can someone tell me how to appened a text with the Sequence variable?.. Any help would be really helpful to me.

Thanks
Sudharsanan A N

sudharsanan · Post by **sudharsanan** » Thu Jul 14, 2005 11:37 pm

Hi All,

I got the answer by using the following way to implement the requirement.

Code: Select all

Parameter = 'param1':x

in the Sequence variable.

where x is the parameter that i am passing to the sequence. I tried all other options finally got the answer. It is great fun learning Datastage...

Thanks
Sudharsanan[/code]