Shell Script

Bram · Post by **Bram** » Sun Feb 27, 2005 1:40 am

Hello every one,

Does anybody tell me how to write a shell script, it should run a sql in oracle, rename the file like , file name and on which date the script ran (file name+mm/dd/yyyy) and do ftp on to the ftp server.

Thanks in advance,
Bram

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Sun Feb 27, 2005 3:39 am

The requirements can be performed using DataStage itself.

dsxuserrio · Post by **dsxuserrio** » Sun Feb 27, 2005 10:50 am

Bram
The / may pose a problem in unix filenames Do you want date as mm/dd/yy ?? Or is mm-dd-yyyy is fine??

Bram · Post by **Bram** » Sun Feb 27, 2005 1:16 pm

Hi Sainath,

Could you please more elaborate? That is also iam looking at.

Thanks
Bram

Bram · Post by **Bram** » Sun Feb 27, 2005 1:17 pm

mm-dd-yyyy is fine?? Also iam want to schedule it using Cron

Thanks
Bram

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Sun Feb 27, 2005 2:24 pm

Use OracleOCI stage with your SQL (and configuration values) followed by a seq file and link them.

It is good practice to use a transformer between them.

Pass the date (in your required format) as parameter and substitute it in the file name derivation.