DSXchange

Sreenivasulu,

The before-job routine returns an error-code, if this is non-zero the job will fail.

saadmirza, first of all, in this case I would say not to use NLS at all in DataStage; let DataStage just pass through the values unchanged and unmapped. Secondly, you would need to look at what happens to a specific character; just saying that "i don't see the desired output" isn't really going to h...

No, unfortunately one of the side effects of the automated parallelization is that the debugging mechanism does not function. I really miss that functionality from the Server side but haven't even dreamed of putting in an enhancement request as I doubt the architecture will allow implementation of a...

I did not include the list of enhancements - there are some nice ones there as well. I think that these documents are readily available on the Ascential website but just happened to have the CD in my drive when you posted your question. We have 7.5.1 on our AIX box right now and, apart from new spor...

Here is a list of fixes at 7.5.1 from the README files: Problems fixed at this release ============================== IQBulk12 creates incorrect *sql file, commit statement is missing (ecase 4560) ----------------------------------------------------------------- Added commit after LOAD TABLE stateme...

gopskrish, if you do a cat <mydataset.ds> or more <mydataset.ds > at unix you will, apart from quite a bit of other text, see one or more UNIX paths and filenames. You can then attach to that directory to delete the datafiles. Your PX installation will also contain default locations for these datase...

In addition to what Ray has detailed, don't forget to modify your startup and shutdown script(s) if they have been modified to start and/or stop the DataStage server engine.

Flash, are you intentionally deleting and re-creating the file on each job run? Unless you have specified this the job should never branch into the CREATE statement after the first job run. The CLEAR.FILE is no problem unless you have multiple processes running that read/write to this file; but even...

Have you checked to see if the UNIX process(es) behind the jobs are still running? If you execute a stop command to the job does it stop (after a couple of minutes)? Do the log files after a stop and after a reset show any additional information? How large is the output file (2Gb?)

Peter, the "lock" you are referring to is odd; it is not likely that you will get a filelock; most likely the file is open by another user while you try to delete it. Are your problem files in the DataStage project directly or are they remote pointers? I wonder if you could also check your permissio...

This has been covered sometime last week. If you don't have the hidden file .Type30 in the directory, then DataStage assumes you have a 1/19 file which is a directory - where each "key" is a file-system file and each "record" is that file's contents. If you do a CREATE.FILE xxx DYNAMIC or use DS to ...

Diamondabhi, I won't post any jobs or code for this, but will elaborate a bit: If you have numerics that need to be masked use the RND() function which returns a pseudo-random number [it is important to seed it with a constant value if you need reproduceable numbers on subsequent runs]. So if you ha...

Saadmirza - if this continues it would be best to open up a new thread, or else we'll be accussed of thread-hijacking. In your case, read from Oracle and write the data straight back to Oracle unchanged. Is your input and output data identical? Reading your earlier post, it seems that you are saying...

In the past I've written a number of jobs that take the "live" data and run it through a transform which either randomizes columns or masks information, depending upon what needs to be done. In many cases randomizing would ruin the correlations (i.e. if the customer name is the key for a lookup), so...

Hi Arnd, Is "orchadmin rm <the descriptor file>" equivalent to deleting the dataset from Dataset Management. How would you set up OrchAdmin in Unix? Pls share with us. Regards Saravanan No magic to that - if you set up your user's environment with the correct settings for PX then the orchadmin comm...