DSXchange

try using an empty string ("") instead of the @NULL value.

Nagesh,

could you show us what you actually entered in the modify stage? The function should work, I can recall having tried it in the past. Also you might tell us the data type and contents as well as the actual error message you received - is it a compile or a runtime error?

If you export your jobs without clicking on the 1st drop-down (Job Designs) enabled, you won't get any design-time information; it is independant of the the "executable" and "source" export attributes in the Manager for jobs. The settings for routines are a bit different, you only have two choices t...

How are you doing the row merging in your job, it looks like you are not initializing a string appropriately in that logic.

Elavenil, what is the issue - the DSExecute() call won't return until the program it calls finishes - so if your external batch script finishes after the job then it must be starting off a background process. Is your intent to have the DataStage job wait until the other background process completes?...

Try using the debugger and stepping through the values on the output side of the FTP to see if you really have leading zeroes prepended to char fields at that point. Also, it looks like a "0" is put before and after the values - could it be the column separator; perhaps you could try using " as a qu...

How do you know that the padding is done in the FTP stage? Normally I would never expect a CHAR field to be automatically padded with leading zeroes so my first guess is that this is happening on your output. If you use a FTP stage and either write straight to a non-delimited, fixed width, no termin...

How many records does your job log show coming out of your source database- 76 or 68? What is the key on your staging table? Could you be overwriting duplicate records on staging?

Use all the values in one string and use a character that doesn't appear in the string as a separator. Lets say your paramter string looks like "1;2;3;5;7;11;13;17;19;23". If you want to exclude records where a column contains one of these values you can add an extra ";" separator to the string and ...

mmanes, in that case I'll rephrase my previous comment:

When you use the "-server" option I think that dsjob assumes you are going to another machine so it probably wants you to also specify a userid and password. Have you tried that?

1. go into the manager, edit the routine "CheckAlphaNumeric", make a change like adding a single space to the code somewhere so that the "save" button is no longer greyed out. Save the job. If the save doesn't work then you probably have a protected project and need to talk to your admin. If the sav...

SonShe, have you tried using the search facility for "the RPC daemon is not running"? I did, and found 40 results. This is a common error message when communications are down or the DataStage server is down.

When you tell dsjob to use another server I think it wants you to also specify a userid and password.

It's hard to see how to help you, murali; you need to explain your problem a bit more. Is your project protected? Why can't you compile your routine (because it give an error? Because the "compile" button is greyed out?) Were you able to use the "test" button in the manager to test it or does i was ...

Your string contains double quotes that you don't want? You can use the ereplace to remove them from the string. Or perhaps your output sequential file declarations specify a double-quote as the quote character and you are seeing that. The StringToRaw() is a PX function that doesn't exist in the ser...