DSXchange

I didn't say it would be more efficient or faster, but it shows recursion AND string maths.

ray.wurlod wrote:...Is it not said that before you can define recursion you need to define recursion?

Only in the Department Of Redundancies Department

Ray, actually it works somewhat differently in PX. When you "append" to a dataset, the PX engine does not append to the existing data files, it creates new sequential files and adds their path to the descriptor. Thus, in order for concurrent to work, the descriptor file is the important one to contr...

The directory you specified for the dataset descriptor file does not exist. Or the directory exists but your userid doesn't have sufficient access to create the file.

The Advanced PX Developer's Guide states: APT_SORT_INSERTION_CHECK_ONLY When sorts are inserted automatically by DataStage, if this is set, the sorts will just check that the order is correct, they won't actually sort. This is a better alternative to shutting partitioning and sorting off insertion o...

You should ask your support provider for a definitive answer. I would think that in 99%+ of cases this will work, but in the one case you might lose a whole data file out of the data set if the concurrency control isn't guaranteed.
Please do post your answer, I am very curious if this will work.

When you declare the unique key to be "CustID" on a hashed file, the last write will overwrite the previous data. Can you sort your data so that the first names always appear before the surnames?

For those interested in recursion, you could write a very short factorial program for string math as follows: Factorial(Arg1) DEFFUN Factorial(Arg1) CALLING "DSU.Factorial" IF Arg1="2" THEN Ans = "2" ELSE Ans = SMUL(Arg1,Factorial(SSUB(Arg1,1)...

Meena - if you use the same to_char() function to convert the date in SQL (i.e. not using DataStage) what results do you get ?

Kasgang, the suggestion was already made to use string maths in DataStage if the number exceeds the limits imposed. It will significantly reduce the speed, but will be able to handle your factorial.

No, unfortunately there is no control over the naming of scratch directory files. There are some options for setting reporting switches that output all sorts of logging information, and I think I might have seen temp file names in the output of one of them. I'm not at a DS machine at present, but I ...

The expression is valid and I am certain that the record in not being dropped as part of that use of "col1". Where else in the transform are you using "col1", perhaps in the constraint?

DataSets cannot be concurrently written to. Each instance will have to write to a separate DS and then the files need to be merged when all writes have finished. Update - Let me retract that. When you append to a dataset the engine will create new data files and add them to the descriptor. So each j...

Ray - although those with UniVerse experience know that, I think that many here do not, and would be stumped with error messages or problems after breaking a lengthy resize. Just to avoid that type of problem I recommend the create and then copy method.

Ray - I recently had work cleaning up after someone cntrl-C'd a large and lenghtz resize. The exclusive file lock was kept on file, just as it always has.

RK - I'll trade you answers. If you can tell me what the blinking red light on my car dashboard (the one in the top left corner) means and how to fix it, I'll help you with the CFF issue. p.s. In case the post above was too subtle - please add some more information to your problem description; i.e. ...