DSXchange

yes, the engine needs to be up while doing the options (2) and (4) and you should ensure that no users are in DataStage.

You get the job handle using DSAttachJob(YourJobName,DSJ.ERRNONE)

Sankar, you will need to start numbers (2) to rebuild the indices and (4) to check integrity of job files. Jim, the DataStage $DSHOME directory has a file called "dsdlock.config" with a line that reads either start=1 or start=0 to control whether or not the lock daemon is fired off when DataStage is...

... APT_ORCHHOME\bin ;C:\Oracle\Ora81\bin;C:\Program Files\Oracle\jre\1.1.7\bin;C:\PROGRA~1\MKSTOO~1\bin;C:\PROGRA~1\MKSTOO~1\bin\X11;C:\PROGRA~1\MKSTOO~1\mksnt;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;;C:\Ascential\ODBC ... The text in red looks wrong, it needs to contain the ...

PX is very picky about formats; the date formatting you give *must* be fixed length and your variable length entries won't work. You will need to change your date string into one of the correct format and then do the date conversion. You can use the FIELD(MY_DATE_STRING,'/',1), ...2) and ...3) to ge...

A job that just hangs there forever without doing anything is most likely waiting on a lock - any playing around with "kill -9" or other hanky-panky with the engine process might lead to a lock left over that isn't going to get cleared. It looks like the lock is on the hashed file, which is why runn...

Your simplest method would be to write your own function "GetDBRows(Jobname,LinkName,StageName)" which uses the appropriate DSGetLinkInfo() call to return that number of rows; and use the RoutineActivity stage in your sequence. This might better have beend posted as a new thread - makes it easier fo...

I've used what Ken described many times in jobs to do this; plus this interim file should be declared as a pipe to avoid I/O and speed up processing.

no comment.

sundar,

could you add some echo or type commands to your script that print out the parameters as the script sees them? Perhaps the command isn't being called the way you expect it; i.e. the parameters aren't resolved correctly or there is an issue with a relative or absolute path.

How about using Occam's Razor and going for the option to join all 3 tables in Oracle and passing that to DataStage for further processing?

Tasneem, what is your value for the APT_ORCHHOME environment variable? Also, can you run the command orchadmin check? If not then you do need to set up your environment correctly. Also, it might help if you told us that this is a new installation, or that it has stopped working since some change, or...

Jim, that's a good approach; since there are any number of UNIX utilities available to return you the holiday status and it's easy to parse the result of an external command from a DS Basic program. Keeps the scheduler simple and the overhead of calling up a sequencer or job is not that high if it i...

You will need to tell us why these rows are getting rejected before anyone can come up with suggestions for you.

You can schedule the job to run Mondays through Fridays at the specified intervals; but the AT scheduler doesn't know anything about the calendar and it's relation to holidays. If you need a job to specifically not run on weekdays that are holidays in the place where the server resides you will need...