DSXchange

For less than 30c ( approximately 1 ringgit) per day you can buy premium membership which, among other things, allows you to read the entirety of premium posters' posts. Premium membership is one of the ways in which hosting and bandwidth costs of DSXchange are funded. It really is good value! On t...

If @MONTH = 1 Then (Oconv(@DATE,"DY") - 1) : "-12-" : Oconv(@DATE,"DD") Else Oconv(@DATE,"DY") : "-" : (Oconv(@DATE,"DM") - 1) : "-" : Oconv(@DATE,"DD") Some furth...

It may have been fixable before you starting deleting things. Why do you say it was corrupted? What error messages were generated? You now need to delete both D_PREPAID_SUBSCRIBER_HASH and PREPAID_SUBSCRIBER_HASH from the operating system, and (if you created the hashed file in an account), you also...

No it's not. /opt/sp310/pi/hash/ is the pathname of the folder. That's what you should have in the Directory field. PIPO_01 is the name of the hashed file that will be created in that folder. This is in the File Name field of the Hashed File stage. Yes, a folder called PIPO_01 (containing files call...

For "non-numeric where numeric required" error inspect the remainder of the error message where the values are reported. A non-numeric value will usually have quote characters surrounding it. Find it and fix it. "Required column missing" indicates that your metadata for the sequential file do not ma...

Eliminate possibilities. Remove the connection to database, replace it with a Sequential File stage or a Peek stage. Are rows getting out of the Transformer stage? If so, then you can replace the database stage and narrow the focus of your diagnosis to that. You can even use the data in the sequenti...

Sorry you misinterpreted my intention - it was acknowledging that you are diligent in helping us to help you. Not everyone is.

You still have not described exactly what you are doing in the SCD stage which is what was requested.

Are you involving your support provider in all these "doubts"? It is important for your support provider to be aware of the problems at your site if proper support is to be provided.

The DataStage Conductor process uses rsh to invoke Section Leader processes on nodes that are different from the Conductor's node. This is probably the remsh scripts that you are seeing.

Or you can simply put the shell executable (e.g. /bin/sh) or a source command in the Command field, and the entire command in the Parameters field.

Your problem is not related to partitioning given that your data are hash partitioned on the reference keys already. The problem is a deadlock in the SQL Server database. Were you to search the forum you would find that updating the same table you are querying is a common cause of (self-)deadlock. Y...

IBM does have a "what's new in version 8" set of offerings for DataStage, from memory the course code is DX800.

You can't pass the row "without any value". Your choices are to pass null (either in-band or out-of-band) or constrain the output so that rows are only passed if the input value of name is "a", "b" or "c".

Is the difference between input and output in any case larger than 0.0000004 ? Since you have nowhere near 31 significant digits in your numbers (based on the sample you gave) can you try reducing the precision to, say, 22 - that is, try Decimal[22,11] ? That allows for 11 digits to the left of the ...