DSXchange

DataStage itself doesn't encrypt or decrpyt data, it can call external routines which do so; and you can choose your preferred encoding.

Does job_link get assigned correctly?

Meena, the "ID" column is not extracted from Oracle, otherwise it would be in the format of {LinkName}.{ColumnName}. I assume it is a stage variable computed somehow. You haven't yet told us what your warning is and my assumption that it was the reject link is probably wrong. Could you post the actu...

The basic method remains the same, the command line to list a job's log requires a project and a job name. I would do a dsjob -ljobs for a project into a text file, then edit that file to execute the dsjob -log for each of the jobs found.

And where does the value of "ID" come from? (no need to quote previous posts)

Can you not use a loop activity in a job sequence which calls your actual job inside the loop and passes the counter/concatenated string as a parameter to your job?

...even after using this transforamtion , the job is getting aborted because of 4 rows. I have used the rejection in the job . I am not able to see the data in the 3 columns for 4 rows which are getting rejected. What is your rejection constraint? Also, it would help if you could tell the source an...

Use a shell script that uses the dsjob command, it first gets the list of jobs in a project and then loops through all elements in that list to put the log contents into a sequential file.

anntaylor wrote:We are having a similar issue. We are going to change the kernel default config settigns. The Install and Upgrade manual suggests the kernel may need to be rebuilt. I'll let you know what we find.

You don't need to rebuild the OS kernel for ulimit changes. Which manual were you referring to?

Yes, the query is a DataStage SQL one and is hardware and platform independant.

DataStage servers residing on Windows platforms are much less of a problem than the other components involved - mainly the database. Historically Windows has been seen as a "immature" OS trying to live up to it's more mature UNIX sibling. This has certainly changed in the past couple of years, but I...

This is because the directory in which this command resides is not set in your PATH environment variable. This is a UNIX setting.

The most common reason is that you are using a different login id to the person who created the file in the first place and your "umask" settings are incorrect. Can you check the UNIX permissions on that RT_CONFIG1 in the project directory?

There are no absolutes to make this choice. If the site has already invested in UNIX hardware and infrastructure, putting in a Windows-based solution would not be a good idea; conversely a Windows shop shouldn't throw in a couple of "rogue" UNIX servers unless there are other reasons to do so. If ne...

You can't specify that in a XML stage. But you could write relatively simple job which reads each line and adds it to an output buffer, which is only written when you get a an XML terminator "</{name}>". This would be just one transform stage and a stage variable. If I could program in awk or sed I ...