DSXchange

Umberto, I am not sure about what you need to do; you posted the question as a UNIX server one, but are asking about DOS; you stated that you want a "before routine" to do something after the job completes successfully. If you has a DOS server installation, you can simply execute date /t > pippo.dat...

This is not an uncommon error and has been posted in many threads (remember that search is your friend). Do you get the problem if you try to connect using another client program such as the manager or administrator? Are you sure that the server has been started correctly (is there a dsrpcd process ...

Yes, it can be used with any latin alphabet based text. The algorithm for the Russell soundex is quite simple and will also work (a bit) with Polish. The formula is to keep the first letter then to remove all a, e, h, i, o, u, w, y in the string and then to assign numbers to the remaining letters (a...

Your date is coming in as a string in the format dd/mm/yy . You don't care about the dd portion and can do a substring on the month and year and perform you math on those. Even though it could be done as a single line in a derivation, a small routine would be best: Routine Subtract4MonthsfromDate...

If you system administrator recycled DataStage by doing "kill -9"s on everything then your problem is that the indices have been corrupted. Go to the ADMINistrator tool, call up the command "DS.TOOLS" and use the option to regenerate indexes and you should be back up and running in no time.

The values do match between prstat/vmstat and what is shown in the monitor - at least for for that process. All of the routines compute %CPU by taking the ratio of CPU-time times and REAL-time. Differences will always arise because on a real system these values change dramatically second-by-second a...

The BP subirectory for a job is a type 19 (directory) file that contains the generated source code for a job, and the BP.O contains the compiled objects. If you are not logging in as the user who original created this job then it is most likely a UNIX permissions issue that is preventing you from op...

Most likely causes are that the hashed file doesn't exist or that you don't have sufficient permissions.

Kjj,

don't you think that after 2 years this slot might already be filled?

Hello Sheltzer, could you put a dummy sequential file output with your string and the value of LEN(yourstring) or add a column with the derivation of LEN() and use the designer's debugger to see if the non-trimmed and trimmed values are acutally 3? What stage are you using to write to your target an...

@INROWNUM and @OUTROWNUM are just numbers and have nothing to do with the contents of the data in the rows. If you are looking to output a row or not depending upon its contents you will need to do something else; perhaps sorting the data and comparing your current row contents with those from the l...

I'm at loss in that case; I don't know why you are getting mangled data. Can you work around it by copying and gunzipping outside of DataStage?

Are you looking to do this in a transform stage? If so, you could use . Or are you looking to do this elsewhere?

Mark,

the full client list is a guarded piece of information, but you could browse Ascential showcased customers at Ascential Customer Showcase

Use the convert function to remove all spaces, i.e. . It will only convert one char to another so is more limited than EREPLACE, but it is more efficient.