DSXchange

You haven't really explained the problem. Why can't you use the table in a custom server routine?

At version 8 you can now generate such sequential numbers directly in the Transform stage. Look into the details tab "Surrogate Key" of the transform stage in the designer.

Read them using sequential file stage.

Identify the process ids and then use the "truss -p {pid}" command to see what these processes might be doing.
Does this mean if you start the job from the director it does not get "stuck"? What does the job do?

ag_ram - I'm confused as to your question. Kim just stated that the RT_BP isn't used for PX jobs and you just asked that answer back as a question. If a PX job has Job Control, then this is BASIC code and the code is written to the RT_BPnnnn directory; otherwise it is unused.

For each column you can go to the details (click on the column name, right-mouse-click and "edit row" and from there you can specify whether the character column is "EBCDIC" or "ASCII". This is the same in versions 7 and 8.

What map is your single-byte kana? And what map is the multibyte one supposed to be?

Use DecimalToString(In.ColumnName,"suppress_zero") and I'm fairly certain it will work.

Or sorting the data (either through sort stage or implicitly) and a transform stage using a stage variable.

I'm not at a DS window to test but would think that if you declare the output sequential file as varchar and do a DecimalToString conversion that these leading and trailing zeroes would disappear. Have you tried this?

The first two errors are UNIX access permission issues with your userid. Correct this in order to see if the last error persists.

I think we had this question last week, and unfortunately the remove duplicates stage does not do this; you will have to use another method to do this.

This UNIX function is described in this Wiki article

Try doing a multiple job compile on all jobs and monitoring that - perhaps you have some sort of file corruption.

If you have NLS enabled then you can have DS do this automatically by defining the appropriate and correct mappings. Which Half-Kana representation are you using? (Don't some or many character sets actually have both representations defined? I seem to remember being able to choose representations wh...