DSXchange

Try ereplace

Ask Mr. Gates !!

Wow, do you really mean 20 lookups linked? Hmmm, lemme guess, you are using teradata, so must be there are large volumes. The whole thing might just be crashing. Did you check with your unix admin, during the job run did you run out of scratch etc (although datastage usually throws scratch problems ...

No

Hey! Thanks for your reply! :) How to see CPU usage for a particular stage.. :roll: In director, right click on the job and choose Monitor. Read through the columns that appear - if you don't find %CP right click on the columns and choose that. Alternatively, you can set the APT_PM_PLAYER_TIMING en...

How about just a change in the scale and precision ... since it is a change from smaller scale and precision to bigger the default conversion should be just fine. Have you tried that?

Looking at that error even God will not be able to help you. For a start, this is a common error you will get from the stored proc stage unless you set it up (pass all parameters and all with right datatypes etc.) correctly. You have to check and re-check every property you are setting within the st...

To me it looks like since the record type is fixed, datastage is reading the record length number of characters. Now, there should be spaces for the columns E and F in the first record since they are null, but if there are none, datastage will read upto the second record and then look for a record d...

Solved the Issue!. It turned out that while defining the column for MQ stage I had less number of bytes that Column size filed. Hard to belive!, but once i changed the display field as that of column size, problem solved. Interesting, so was the data ACTUALLY getting truncated or was it just a view...

You have to create a buildop where you have to count the number of delimiters and then spit out as many records as required.

Did somebody switch off job monitoring altogether? Is the row count not available for just one link or all links in the job?

Do you know if there is any limit set regarding the number of processes that one user can start of simultaneously? Check with your unix/datastage admin.

Ummm no, actually it won't do that. The link ordering in the transformer, as far as I know, helps determine the order of execution of the constraint expressions and that's about it. In parallel mode, even if data gets pushed into the two links one after the other the subsequent stages will start pro...

Thanks for reply. Than I am not aware of it.Can you please guide me ... Thanks ... Well, do this: in your job sequence, take a notification activity from the palette and open it's properties (the place where you have to mention the to and from addresses as well as the subject and body) and look for...

Well, the sed/awk commands can be executed in shell(you can use execsh from datastage) and use a "> filename" to store the output in a file and use the new file instead.