DSXchange

Have you checked "Log Warnings after activities that finish with status other than OK". This will cause the warning

Might be, you have checked "Automatically Handle Activities that fail" in the job properties of your sequencer, which will treat that routine has failed if it returns value other than 1. Uncheck it and try running the job. Or is there any triggers from your routine activity, which is causi...

Yes, dont let your routine to complete until all the jobhandles are 0. The current loop will execute until all the jobs are assigned, so start a loop after this, which will execute untill all jobhandles are 0. I would request to stop the process for a small amount of time by using SLEEP, instead of ...

Ken Bland has a nice utility in his website, for doing this. if you want to change your code, the first thing you have to remove is DSWaitForJob(JobHandleArray(k)), it only make the control to wait until the job finishes. And other thing is, i dont see DSDetach anywhere in your code. Have you posted...

Might be this script will help you. ::****************Begin Export Loop For /F "tokens=1" %%i in (C:\export\DsxList.txt) do ( echo **** Exporting Job %%i C:\Progra~1\Ascential\DataStage7.5\dsexport /H=HOSTNAME /U=USERID /P=PASSWORD /JOB=%%i PROJECTNAME c:\export\aa.dsx type C:\export\aa.ds...

What exactly is DataStage Pack for PeopleSoft Enterprise? What does it contain?

How it is differed from OEM provided by EPM?

Convert the ^~ to a single delimeter by using CONVERT and use the field function

Search the forum for OCONV or look into help for OCONV

Easiest way should be , store the value as you need, because anyway someone has to create the parameter file, you can istruct them how you want to read the parameter and ask them to store in the same format. or you need to custom routine, where you need to parse all the values and construct the para...

Yes , you can do that. You can define a job parameter, like SEQFILENAME.
and in the filename textbox, just give like #SEQFILENAME#, it will be repalced by the value what you are passing in the job parameter.

dsimport will import a particular DSX file, if your dsx file has executables also, it will import it.

CLEAR.&PH& wont clear the log files, as you are thinking. For clearing the log file , you need to execute the command CLEAR.FILE RT_LOGXXX where XXX is the job number. you can get the job number by querying DS_JOBS. but if you just execute this , it will clear your auto purge settings also. ...

You can actually do it, but it will be like concatenation of all the columns to a single column, and you have to decide in your further transformations how you want to split it. And lot of work has to be done for the Select statement also. Define a Job parameter , say DYNAMICSELECT. Define a single ...

dsimport (client exe) will import the job into the server. You can write a bat file and do the looping to import the jobs, or the simple way could be concatenate all the 50 jobs to a single dsx and import the concatenated dsx.

System variable @LOGNAME will give you the user login name.