DSXchange

Use a stage variable to store your last record's value, if it is sorted descending then you need to ignore everything after the first read row; if sorted ascending you need to output the "last row read" data when the key changes plus deal with the last row of data. Sorting descending is by far the e...

One cannot insert into the middle of a sequential file. When programs seem to do this they actually overwrite the original and/or use interim files. One solution that you can use is to write your data out to a temporary hashed file, adding a numeric key column containing your @OUTROWNUM value. You c...

Is the sequential file comma delimited and do the strings have a valid quote character? If yes, then DS can read it correctly. You will have to specify in the column definition of the source file "column contains delimiters". Good File format: 1,2,"Hello, Goodbye",4,5 Unusable File format: 1,2,Hello...

PX routines are c++, server routines are DS/Basic and one compiler can't touch code in the other. You need to compile your C++ code and load the entrypoint into a library object, then point the definition of the routine to that object.

Reddy - what is not working the way you would like by using the DataTypePicS9 conversion?

The string functions in PX a bit more limited that Server, but you can use the INDEX(In.Column,'T/A',1) function to get a 0 (no match) or another integer (match).

This is easy to do if you use a stage variable to store your previous value and you can sort your incoming data according to the first column.

I did a couple of HACMP and other automated failover mechanism projects with the underlying database system and none of the solutions we ever came up with was truly 0-downtime and invisible to the users. Trying to make a DataStage project runtime environment failover gracefully is going to be a lot ...

Craig - I did a quickie search to see if I could find it documented but couldn't find a limitation anywhere. But after this is submitted I'm sure it will show up in the future documentation.

You have specified "delete file" in the create options for your hashed files and the part that executes the UNIX "rm" part of that to get rid of the file is failing. This is because of UNIX permissions, as Jeanne has already posted. Whether the umask for your user has changed or if you are perhaps r...

Perhaps you can do that. First of all, is the Japanese text in Romaji (english characters) or in Japanese (Hiragana,Katakana,Kanji)? If the latter you can run it through web translation tools such as Babelfish translation web sitet . If you have Romaji I am sure that there are other sites that will ...

No, there are no parallel stages that will allow you to call server routines. They exist in completely different environments and are not compatible that way. You can only use a server routine from a BASIC transform stage in PX.

Hadi, do Students and/or Pensioners require premium access? I think that the normal contents should be sufficient for the old and retired DS people and those still studying. The fee is geared to professionals who use DataStage as part of their work. The current minimum wage in Australia equates to a...

Create a new dummy account and copy the contents into that path. Later on delete the dummy acount. Do not copy a live account.

If you use the routine in a BASIC transformer stage in PX it will get executed on every row of the data and will slow down the job. If you use it at the job level of a PX job it will only get executed once.

What is your server routine supposed to be doing?