DSXchange

The Change and Ereplace functions are the same (except when evaluating an emptyr string). You might write a normal Server job to read you source file, parse it and write it back out to another sequential file, which your PX job then reads. It will make maintenance and debugging easier and might even...

balajisr, when you have interprocess turned on the transform stages will be executing in different processes and any COMMON block information will not be shared between them; this is why that page recommends not using COMMON blocks to share data between stages. If you use a COMMON block to store per...

I find it odd that the encrypt has 4 parameters (unabalanced in your post) and the decrypt only 1. Is that correct?

Kryt0n, you mean the inode limit on the partition or the UNIX variant's limit on number of files in a tree (32767 on AIX)? You can temporarily work around that problem by converting your RT_LOG<nnn> and RT_STATUS<nnn> files from type 30 (which use 1 directory and 3 files for 4 inodes) to Type 2 (whi...

Rachel, try writing a job that reads a sequential file, uses the key management routines and wrietes to a sequential file (or to a sequential file in /dev/null) to see the actual speed on your system. The speeds should not be 24 rows per second, even on an overloaded system. Most system should give ...

There was a post by Jim:

We had the same problem on my current project and raised a case with Ascential. They supplied as with a patch - a new DLL (vmdsjsgn.dll) which need to be installed on the client and the jobs then had to be recompiled. Seems to have fixed the problem!

in the thread.

You can set the column attributes on fixed-length input files to have "contains delimiters" and then use a derivation along the lines of "CONVERT(CHAR(10):CHAR(13),'',In.ColumnName)" to strip out the unwanted <cr> and <lf> characters.

The scheduler will call "dsjob" which takes user/password as parameters. What does the failure look like - there has to be some entry, either in AT or in the DataStage director. If nothing shows up in the director itmight be that the path to the dsjob command has changed or that the user's ENVironme...

Craig - I did check it, but went straight to the bottom without looking at the details and just saw an entry stating "contact Ascential support" so I assumed that it meant that someone needed to submit a bug report. I just re-read it and found the reference in the middle of the thread. Mea Culpa, I ...

It would seem that the scheduler (at) on Windows is not running your job as user A. Look at the DataStage Administrator to modify your project settings in the "schedule" tab.

Gateleys, you can create a server job, then leave the canvas empty and create your loop in DS/BASICN in the Job Control portion and use the drop-down list at the top to create your skeleton code to call a job (it automagically will creat the attach,set params, reset & run, wait for completion an...

I changed my test job to call a sequence from the main sequence and had no problem in getting it to execute 1000 times in a row at 7.5.1 Therefore the answer isn't obvious so you will need to do some debugging and testing on your system. The first step in isolating the problem is to change your main...

I just wrote a sequence that calls a job in a loop from 1 to 10000 step 2 and it has run through successfully 5000 times (it was a short job, just print out the parameter value which is the loop counter variable from the sequence).

What else do you have in your loop?

This is a known issue with the client - you need to call your support provider for a windows patch that will fix your problem.

Try to reindex using DS.TOOLS from the TCL prompt or from the ADMIN tool; it might be as simple as a case of currupted indices.