Runnig a script in datastage

mdtauseefhussain · Post by **mdtauseefhussain** » Thu Jul 13, 2006 9:06 am

I have a script for renaming the file ,when iam running the script in Unix command prompt it working fine,but when iam runing in Datastage
After job subroutine on ExecSH it is throwing error

The script is
mv /data/datastage/Data/EMEA/sampleV.txt /data/datastage/Data/EMEA/sampleV$(date '+%Y%m%d')".txt"

Plaese help me out

DSguru2B · Post by **DSguru2B** » Thu Jul 13, 2006 9:15 am

You dont $. Thats to reference it inside the script. And note date is surrounded by ` and not '(quote). Just copy paste my code in the execsh.

Code: Select all

mv /data/datastage/Data/EMEA/sampleV.txt /data/datastage/Data/EMEA/sample`date +"%Y%m%d"`.txt

chulett · Post by **chulett** » Thu Jul 13, 2006 9:20 am

ps. That's not a script.

mdtauseefhussain · Post by **mdtauseefhussain** » Thu Jul 13, 2006 10:07 pm

I need to concatenate time stamp along with the date the file name should be like this

Sample20060713000000

shamshad · Post by **shamshad** » Thu Jul 13, 2006 10:56 pm

Use this example to make your command. You can change the date parameter to get the correct verion. The below example adds only dates to the file

mv dmi2.txt /global/site/vendor/Datastage/io/output/dmi3_$(date +'%d%m%Y').txt

chulett · Post by **chulett** » Thu Jul 13, 2006 11:09 pm

mdtauseefhussain wrote:I need to concatenate time stamp along with the date

If you are trying to say that you don't know how to add a time portion to the already provided date solutions, it's just this:

Code: Select all

%H%M%S

mdtauseefhussain · Post by **mdtauseefhussain** » Fri Jul 14, 2006 1:26 am

i tried with concatenating %h%m%s but iam getting the output as

"FileTestSort20060713Jul07%s" the time stam part is not coming properly

kumar_s · Post by **kumar_s** » Fri Jul 14, 2006 3:21 am

For these unix comand help, type

Code: Select all

>man date

from your unix command prompt. You will have the possible list of attibutes and parameters that need to be passed.

For HP-UX that I tried, gave me the following.

Code: Select all

>date "+%Y%m%d%H%M%S"
20060714191923

ray.wurlod · Post by **ray.wurlod** » Fri Jul 14, 2006 5:42 am

Note that the date pattern components (a) are case sensitive and (b) are enclosed in (specifically) double quotes.

kumar_s · Post by **kumar_s** » Fri Jul 14, 2006 6:35 am

Though the point b given in Ray post doesnt give any big impact, the point a, is important.

chulett · Post by **chulett** » Fri Jul 14, 2006 6:57 am

mdtauseefhussain wrote:i tried with concatenating %h%m%s

Yes, exactly - case sensitive. Who said anything about using '%h%m%s'?

mdtauseefhussain · Post by **mdtauseefhussain** » Fri Jul 14, 2006 7:14 am

What if we want to bring the date format like this with file name

Sample 2006-07-14 22:25:30.txt

DSguru2B · Post by **DSguru2B** » Fri Jul 14, 2006 7:17 am

It has a space in between. Who keeps a space in a unix file.
If you do, then good luck in opening it.

chulett · Post by **chulett** » Fri Jul 14, 2006 7:27 am

Then put spaces where you want spaces and colons where you want colons. How hard is this to figure out?

mdtauseefhussain · Post by **mdtauseefhussain** » Fri Jul 14, 2006 7:56 am

Sorry guys iam very new to unix and datagstge ,please forgive me if iam asking silly questions

DSXchange

Runnig a script in datastage

Runnig a script in datastage

Re: Runnig a script in datastage