Executing Two dos commands in Execute Command Activity

[Xpert]

Hi,

Pls anyone tell me, how to execute two DOS commands in Execute Command. One command is to move the file from one directory to another and another command is to rename that moved file by adding current date with that file name. And also i have to pass the file name by parameter.


My Scenario is,

Once the file is processed sucessfully then i have to move that file to another directory by adding processed date with that file name. Pls help me, Thnx in Advance.

[ArndW]

You mean something like "cd c:\temp | dir"?[/b]

[kumar_s]

move #Old_Pdath#\#Old_Filename# #New_Path#\#New_Filename##Date_parameter#

[Xpert]

move #Old_Pdath#\#Old_Filename# #New_Path#\#New_Filename##Date_parameter# ...

Hi Kumar,

Thanx a lot......

[Xpert]

move #Old_Pdath#\#Old_Filename# #New_Path#\#New_Filename##Date_parameter# ...

Here we are hardcoding the date value by passing parameter. how to use DSJobStartDate in this condition.

[kumar_s]

DSJobStartDate of what? If its the for the job that produce the file, you can use UserVariable Activity or Routine activity and use the same command DSJobStartDate and pass as UserStatus.

[ersunnys]

move #Old_Pdath#\#Old_Filename# #New_Path#\#New_Filename##Date_parameter# ...

I am trying to give my JOBS parameters to connect to sqlplus, but it is not connecting... can anyone help me in this...

i am using...

print "select * from tab;" | sqlplus -s #userid#/#passwd#@#domain#


please correct me if this command is wrong and tell me how to do the same.

[kris007]

Try this
In the Command box

Code: Select all

 sqlplus -s 

and in the Parameters box

Code: Select all

#userid#/#passwd#@#domain# && select * from tab;

[ersunnys]

[ersunnys]

Try this
In the Command box

Code: Select all

 sqlplus -s 

and in the Parameters box

Code: Select all

#userid#/#passwd#@#domain# && select * from tab;

This is not working, output is

Executed: sqlplus -s userid/passwd@domain && select * from tab;
Reply=0
Output from command ====>

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Sep 14 18:27:39 2006

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Enter user-name:

the command is getting genrated but its not showing the output. If i hardcode the values of userid, passwd and domain, its working fine...

wht is the problem i m not getting

[kris007]

sqlplus -s userid/passwd@domain && select * from tab;

I don't think you can even execute this complete statement from the command line too. What exactly are you trying to do from the execute command stage? Do you want to run a script or run some sql commands?

[ersunnys]

sqlplus -s userid/passwd@domain && select * from tab;

I don't think you can even execute this complete statement from the command line too. What exactly are you trying to do from the execute command stage? Do you want to run a script or run some sql commands?

I am able to run

print "select * from tab;" | sqlplus -s #userid#/#passwd#@#domain#

from command line...

i want to execute a single statement in the stage...

[ray.wurlod]

That IS a single statement.