DSXchange

Hi,

you can try the commands what you use in command,
try the same in the command stage.

with regards,
T Sankar

Hi,

Use Parameters in the job.
Once you run the job, the parameter will ask for values,
you can enter values. through this you can achieve.
do you need steps how to do the parameter.

with regards,
T Sankar

Hi,

you ca pass parameter value to ExecDos routine, place the batch file in the ftp system or server system, you pass the batch filename with the path as the parameter value to the ExecDos routine. you can try this. I hope it will do.

with regards,
T Sankar

Use
"* como on filename *"
in the command line

after this you execute the command, the executed command and other related stuff will be stored in the system directory & como &. you can verify it in the command line.

with regards,
T Sankar

Hi All In a seq 1, runs a job1, if job1 executed successfully, it will execute seq 2,runs job2, if job2 executed successfully, it will execute seq 3,runs job3, if seq 3 is warning,i need rollback the action took in job2. In job2 i am updating a flatfile, i want to rollback the update. Thanks in Adva...

Hi All In a seq 1, runs a job1, if job1 executed successfully, it will execute seq 2,runs job2, if job2 executed successfully, it will execute seq 3,runs job3, if seq 3 is warning,i need rollback the action took in job2. In job2 i am updating a flatfile, i want to rollback the update. Thanks in Adva...

Hi,

Use the scheduler, in the Director. create a schedule for the job you want to run every 2 hours. you check the scheduler service in windows nt is started, if not start the service.

with regards,
T Sankar

Hi,

you can do it in the Job Control code itself as Ray suggest.
You can pass parameters from the Job Control code to other attached jobs in the job control code.

with regards,
T Sankar

Hi All, Merry Christmas. Assume I have a Date 25-OCT-2002.I require the Output as "Twenty fifth October Two Thousand Two".Which DSFunction has to be used in DataStage to get the above output. If I need the same result in oracle.I will use the follwing Function. Select sysdate,to_char(sysda...

Hi All, Merry Christmas. When we are trying to format date using the following function OConv(Iconv(SourceLink.Doc,"D2"),"D-DMY[2,A3,A]") I got the output for the date 11/03/1990 as follows 11-Mar-HORSE. Is this a syntax Error or Explain us the output refering the animal name in ...

Hi Cklesis,

It works fine with NT.
It is working with before-subroutine Execdos aslo.
You try with full path while copy

copy c:a.txt+c.txt c:ac.txt /b/y

T Sankar

Hi Cklesis,

It works fine with NT.
It is working with before-subroutine Execdos aslo.
You try with full path while copy

copy c:a.txt+c.txt c:ac.txt /b/y

T Sankar

Hi Cklesis,

It works fine with NT.
It is working with before-subroutine Execdos aslo.
You try with full path while copy

copy c:a.txt+c.txt c:ac.txt /b/y

T Sankar

Hi All,

Requirement is like this:

Mail ids will be in INI file.

How to access the INI file and its value from DataStage.
the value has to send to DSSendmail as an input value.

Thanks in Advance,
T Sankar

Thanks Ray.
DSSendmail is working great.