DSXchange

May I know, who can we make the Windows DS stages to read unix files. I never used windows as server.

I guess even Informatica has launched PX editon recently.

nekkalapudi wrote:Thanks for the information. Fixed the problem using trim :
Trim(out_to_trans.R1VSHP)[1,1] = ''. This worked.

Thanks

If this is the case, Trim(out_to_trans.R1VSHP) = '' should have also worked. Was that not working?

Just noted, the first Post under this new forum.

BTW: The records getting reject for a business rule constraint shouldnt be a technical error in all cases.

I used "code 139" and exact match option, I got 10 hits including this post.
What are you trying to do in your job with the intervention of any of the external soruces?

clickart wrote:This looks like a UNIX process time-out error. We used to get a similar error when the DataStage job continues running more than the time-out limit set in UNIX.

Could you elaborate more on this. May I know what is the parameter that helps in unix to extapolate the time-out limit for a process?

For more detail about the ibm products you can check here.
http://ibm.ascential.com/products/websp ... stage.html

What version of enterprise editon you have?
It will come with the package of Server as well as PX editon. You need to key in seperated licience key for each while installaion.

madhukar wrote:Is your invisible characters seems to be link "squares"? if yes then ur pad character defined is null character. change into space and try trim function.

The representation of "squar box".. depends on the editor you look into.
If it is null, IsNull() should work.

Explaining the job design will help even better.

Perhaps you can write a Batch file (DOS) which will invoke C:\Program Files\Ascential\DataStage\dscmdimport.exe with necessary parameters passes.

Have you tried the option given on the post.
Closely monitor the scratch disk space during the job run. If it reaches 90%, its time for you to increase it. Clear left out file, if any, in the temp directory.

I guess we might be directed to use ibm.boulder.ftp....

If you have any unix operation to be performed, you can wrap it in a shell. And this shell can be called by a Executecommand (or Before/After subroutine). This will be a part of flow in the datastage. For example, if you need to deleter any file or move any file from one place to other or copy actio...