DSXchange

On UNIX, there are three type of priviledge: User - Group - Everyone. You can only have ONE specific type of access right for each file - although there might be some UNIX flavors out there that provided an extension of that. If anyone knows of any, let us know. You can restrict specific jobs to eac...

The following document (as part of your DataStage PDF library), parjdev.pdf, have a chapter on this: Chapter 55: Specifying your own parallel stages.

How well do you know C++?

There are sample files within the PXEngine directory that you could use for custom stages.

Or buy DataStage EE and let the code do the work for you most of the time.

Do a search for "Orchestrate" or "Modify" and "Null"

On your parjdev.pdf document, read chapter 4 ("Data Set Stage") and Chapter 6 ("File Set Stage").

The PDF is provided with every client installation of DataStage, unless it was turned off.

Happy reading.

You are attempting to sort on all (or less) of the keys you're trying to remove duplicate on. You need to sort on all keys, PLUS one data field.

No. You shouldn't separate groups. In fact, you can not really separate groups on a Project-wide level. However, you CAN force an umask to 755, requring the user sole access to that file to run/edit/whatever, but strange things can happen when you attempts that. Why can't you set different groups on...

Actually, I believe you can adjust priorities in Windows. However, I do not know whether DataStage adheres to this NT feature, or even provide any control for this feature. For a clear indication that Windows does have this feature, go to Windows Task Manager, click on Processes tab, and right click...

Aha!

Hmm.

Something tells me that Oracle is switching metadata on you. I am not sure why, or how. I do not have access to Oracle at the moment to play around with it. Best solution - Switch the metadata to whatever Oracle forces DataStage to use, and the warnings will go away.

Sort the file and pass it to a Transformer stage . Use stage variable to compare the previous row , if its changes write to different file , else write to the same file. Like wise you may have accounts.txt and address.txt ..etc by using constraints mechanism. This does not address the "unknown...

Yes, but it suffer from the problem I mentioned above: Each node is independent of each other for the most part. It have little idea of what each other is doing. So.. Open and Close basically get run by all nodes. So for a 4 nodes job, you have 4 DB2 stages asking to drop the same index and recreate...

If you have a metadata of "Number" -- it defaults to (38,0) (or in some versions of DataStage - (38,10)). You will need to do a manual conversion (DecimalToString() - and handle the null if there's one) if you want to use it as an integer. It's just the way things are with certain database...

Contact Ascential for the latest copy of the DB2 Connectivity document. I believe it is called "DataStage EE Remote DB2 Configuration". There might also be a copy on the Ascential's forum download section. The guideline within the manual is incorrect. Hopefully you will find the document u...

Unfortunately, if you wish for the user to develop, run, and manage several jobs -- this would be very difficult to manage. That user will require general access to the DataStage engine (by default: dstage), and general access to the project folder in question. I am sure that it is possible somehow,...

Yup. This is what's going on right now:

ETL::Dev([path])> ps -ef |grep DSD.RUN
[username] 606412 913512 0 11:07:30 - 0:00 phantom DSD.RUN [job] 0/0 [parameters]

The parent process is Director I have open right now.