Executing Two dos commands in Execute Command Activity
Moderators: chulett, rschirm, roy
Executing Two dos commands in Execute Command Activity
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.
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.
With regards,
Xpert
Xpert
You mean something like "cd c:\temp | dir"?[/b]
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I am trying to give my JOBS parameters to connect to sqlplus, but it is not connecting... can anyone help me in this...kumar_s wrote:move #Old_Pdath#\#Old_Filename# #New_Path#\#New_Filename##Date_parameter# ...
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.
Regards,
Sunny Sharma.
Sunny Sharma.
Try this
In the Command box and in the Parameters box
In the Command box
Code: Select all
sqlplus -s
Code: Select all
#userid#/#passwd#@#domain# && select * from tab;
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
This is not working, output iskris007 wrote:Try this
In the Command boxand in the Parameters boxCode: Select all
sqlplus -s
Code: Select all
#userid#/#passwd#@#domain# && select * from tab;
the command is getting genrated but its not showing the output. If i hardcode the values of userid, passwd and domain, its working fine...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:
wht is the problem i m not getting
Regards,
Sunny Sharma.
Sunny Sharma.
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?sqlplus -s userid/passwd@domain && select * from tab;
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
kris007 wrote: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?sqlplus -s userid/passwd@domain && select * from tab;
I am able to run
from command line...print "select * from tab;" | sqlplus -s #userid#/#passwd#@#domain#
i want to execute a single statement in the stage...
Regards,
Sunny Sharma.
Sunny Sharma.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: