DSXchange

In this case you are only changing one character to another, so the CONVERT('/','',In.Column) is quite efficient and sufficient

Either replace your DB/2 write stage with a sequential file stage and measure your speed to determine if the DB/2 is the bottleneck. Also, what %age CPU do your 3 transform stage show? If they are at less than 30% on a long run with a moderately busy system then perhaps you don't need splitting into...

The Doc Tool in the Manager existed at Version 4, as far as my remembery tells me.

Everyone is free to form an opinion - they are neither good nor bad and are always right (which is why they aren't called anything but opinions ). I'm lucky that I wasn't the brunt of the comment since I tend to be much less forthcoming sometimes and have a shorter on-line fuse that Ray. Fortunately...

Hello Vic, I look at Server and PX/EE as two separate languages, like Cobol and C++. Knowing how syntax and semantics works will help you learn a second language when you already know one, but you will still need to do a bit of studying, training and practising. The common front-end makes it easy to...

If network traffic/collisions is the source, you should see bad performance when you FTP a file (manually) between the machines. Take a 10Mb file and see how long that takes to transfer; a .13 turnaround time is very fast and doesn't point to a network problem.

compressed data is binary. The first bytes of the file determine what the type is, so in your case the first packet (and most likely all subsequent ones) are being mangled. Can you output the mqseries compressed data straight to a unix file without using datastage? I am willing to bet that it isn't ...

I would have shot myself at about job number 5. If you list DS_JOBOBJECTS and look at the majik keywords in field 2 you should be able to come up with an automated means of getting your information. If these jobs are in a project you can use the built-in tools, i.e. get the ACCESS tables from from t...

Parag, you can set the UNIX or WINDOWS environment variables in a transform stage but the changes are only going to be visible inside that transform and in no other places. This is because actions are performed by different processes that run independantly of each other. The only common environment ...

The before-job routine will automatically fail the job if the return code from the shell is non-zero. So make your shell script return an error.

Make a copy of your load job and write to a sequential file (/dev/null) to see what speed you job is capable of without writing to Oracle. That way you will be 100% certain that the loading to Oracle is the culprit in your case. I am assuming that the Oracle database is on a remote system from your ...

Can you print out the values of the password in both instances? Change it from "encrypted" type to string if necessary. The first entry of the director log will show that parameter's runtime value.

xli - there are not too many objects in your projects. The reason for doing a COUNT DS_JOBOBJECTS was to make DS traverse the whole set of file keys to make sure that each link was working, otherwise you would have gotten a fatal error message. Can you try to create a very simple server job with no ...

The DS_USERNO is something different. If you look at your initial error message regarding the FTP stage and failure of the password to work - how are you setting the password in the FTP stage? Is it hardcoded?

There is no direct scripting language in DataStage - there is a DataStage BASIC programming language and perhaps Sequences might be considered and advanced scripting language.

Why a scripting language? Hmmm... why not?