DSXchange

You can only call one before/after job routine in a job. But there is nothing that will stop you from calling one or more additional routines from that one, as Venky has stated.

Each one of the links going into your sequential file stage graphical object on the Designer canvas has it's own path information, and you need to give different file paths & names in both places. Are you sure that you have done this?

When a process aborts (with a core in UNIX) or someone did a "kill -9" on it it will show up in the lock tables with an associated pid of 0. The simplest and best short- and longterm solution is to get your admin to start the DataStage deadlock daemon which will automatically clean up conditions lik...

You can't migrate hashed files to PX; you need to redesign the jobs. The same re-design applies to almost all Server jobs in order to take advantage of the parallelism possible in PX. The migration should be approached assuming the products are quite different, i.e. you will need to do some project ...

I assume you are referring to a lookup file set and a data set. Lookup filesets are used in lookup stages only, datasets can be used in lookup stages as well as elsewhere. The lookup file set gives superior performance in lookups to datasets [according to the documentation, I've done some tests in t...

The commit frequency is the transaction size in your stage.

titto, I think the "next quarter" is understood when it is 3 months away from your data date. But you haven't explained ... so that is is '03'. as per logic i want next earliest quarter would be 05 what that logic is based on. Is the next quarter to be calculated from today's date? I think that the ...

You need to apply some rules to avoid this error, since you cannot attach to your own job. Get your current job's name MyJobName = DSGetJobInfo(DSJ.ME,DSJ.JOBNAME) and in your loop through all elements put in a line IF LoopJobName = MyJobName THEN Handle = DSJ.ME ELSE Handle = DSAttachJob...

ravij, I am assuming you mean "processes", since a processor is synonymous with a CPU. The number of processes is affect by many factors and there is no single answer. You can have hundreds of processes running if they are not active and don't use too much memory and still have an acceptable perform...

As Balaji has already said, it is not possible; particularly when those transform stages are executed in separate processes. You should pass the data downstream by adding a column with the variable's value to the next transform.

1. If you have a string declared as varchar(10) and you try to insert "Hello World" into the Db you will get this warning message.

As long as you have your DataSets put in another physical location, the contents of the scratch should not be required, particularly if you look at the file dates and delete the oldest ones.

You can download IBM UniVerse User Reference Guide V10 and look at the information starting at page 1-162 for a starter.

Using INDEX("HELP","EL",1) will return a 0 if it is not found or a positive integer value if it is.

Create a hashed file with just two columns, "CustNo" and "Data". Do a lookup on the customer number for each row in your input file. Use one of the substring functions (INDEX,LOCATE,MATCHES,etc.) to see if your attribute text is in the data portion. If not, write the record back with the new attribu...