DSXchange

Change the job to write to a text file with quoted character strings, , to see what your job is really producing. Adjust as necessary.

This can be a "problem" in any database; if it's been locked or quiesced (for backup, perhaps), then DataStage won't be able to load into it. The only consolation is that nothing else can, either.

I think you'll find pivot.pdf is the manual for the server job Pivot stage. But they're very similar in operation.

The Log view in Director is filtered to the most recent 100 rows by default, to limit the amount of data that must be sent back to the client every time the Director refreshes. To change this invoke the Filter (Ctrl-T, or right-click in the background area). The row count filter is at the bottom of ...

Etiquette Note/Gripe I answered the question as you posed it. That was my design freeze. If you change the specification that's a different question. If you were hiring me, it would be extra money. Please ask the question you really want answered. Construct a design to read the entire record. Use t...

All you need to do is to specify an appropriate date picture for the TO_DATE function in your INSERT or UPDATE statement.

They create separate resource records in RT_STATUSnnn, so ought to preserve separate UserStatus values (which are stored therein). That's the theory. Let us know what really happens.

Why are you selecting those columns if you're only going to drop them? Don't select them in the first place!

Let me change the punctuation to indicate what I meant.

You can do it in SQL with SQL functions, not with DataStage functions, as Ken indicated.

Gosh, they must be channeling me also!

Welcome aboard. :D

I'm not sure what you mean. Can you paraphrase it? Do you mean a GUID generated by a stored procedure? What kind of database are you using?

Mandatory properties show up red in the stage properties dialog, and should leave a warning icon on the stage, if no value is supplied. The message indicates that there is a mandatory property called xml_source_column for which you have not provided a value. What is the full error text? In particula...

Read the file with a Sequential File stage into two integer columns, specifying "/" as the field delimiter property.

Set up a stage variable (say svCounter) initialized to 0. Derive it by adding 1 if the delimiter string is seen, or leaving it alone if not.

Your Sequential File stages are probably operating in sequential mode. If they are fixed width format, enable parallel mode. Where does the second input for the Join stage come from? Are you relying on (Auto) partitioning or explicitly specifying Hash or Modulus partitioning on the Join keys? You ar...