DSXchange

Isnt the year part of you Iconv should have 4 digit to convert

But you can always speak to your support. They can give you a secrete patch . (Based on the pressure you create to them )

You cannot straight away goahead and clean up all the resource displayed in the DS director. If your are sure about nothing is been used or no job is running, it is better to restart the server once. There is a bug in the (Java code) Job monitor. As you might have aware, by canging the time based mo...

May I know what is Postgres?

Or have a routine to send mail regarding the status of each job in AferJobSubroutine.
Anyway by having the unconditional trigger of each job, you dont have to abort the sequence untill all finishes. So the same routine in after the sequence gets over.

Search for dsclient_xpsp2 or look for ecase60128.

You can check the other post "Runnig a script in datastage" with the same sort of issue for naming the file.

Perhaps I guess, this was an issue with logging(Status). Since it has a common hashed file to log all the log of the multiple instance job instantiated at same time, locking issue might have occured.
Stilln not sure about it.

Though the point b given in Ray post doesnt give any big impact, the point a, is important.

Perhaps another temp table with row commit.

Give the output delimiter as none (000).

If your table is of Load and clear type, you can simply count the number of rows in the table before the job start and start processing the rest from the input. Else keep a track of number of records. It can be simply as, @OUTROWNUM to a sequential file. And read this file for each time and pass the...

Alright, By passing different invocation Id to the JobSequence the sequencer can be made to rerun. But if you have the same invocation Id (hard coded) for the job in the job activity, it will refer to the same job which is already been made to run. For testing purpose you can pass the same invocatio...

You will get a unique number (checksum) for each input.
This is used for several purpose, for example, duplicate check, dedupliacation, Surrogate key generation, lookup....
You can easily get more information by doing a search on the same keyword.

Range lookup in PX What is the volume of record you are dealing with. If it is considerablly small, you can try to extapolate the records in an order. Say New File B: BB1 B2 B3 0 U 1 U 2 V 3 V 4 W .. .. And do a direct lookup. Else you can build you own custom routine to acheive this.