DSXchange

None of the other NLS parameters has any effect if NLSMODE is 0.

Search for "uvregen" or "uv -admin -regen" either here or in your DataStage manuals.

Doesn't Search work in your browser?

Enable RCP, let it generate the output columns, then save the record schema from that.

Otherwise read the description in the Parallel Job Developer's Guide about how to set up a record schema containing appropriate subrecords.

At a pince, simply define three VarChar output columns.

Timestamps (in ISO 8601 format YYYY-MM-DD HH:MM:SS) can be compared directly as strings - you don't need any functions at all.

Welcome aboard.

Whenever you get this message you also get an invitation to view the output of the command (osh script) that View Data tried to use. Accept that invitation, and post here what you see if it does not make sense to you.

There is no directly related functionality.

There are many specific conversion functions - read about these in the Parallel Job Developer's Guide

Do you mean that jmckeever's list is incomplete, or some other list that you are using? What did you discern to be missing?

Welcome aboard. :D Easy answer; these are functions. It's not possible to invoke a function from the command line in ANY product. There is a command line interface (dsjob) that you can use from the operating system level that yields most of the functionality of the DataStage API. You can read about ...

rrsivaraghava wrote:can u plz tell the detail stage variable for this

U hasn't logged in to DSXchange for a couple of months. I assume that plz is a town in the Balkans somewhere.

Welcome aboard. :D There's no specific equivalent of the Make Vector stage, but you can do it easily with the multi-value handling capabilities of a UniVerse stage. Create a table definition that supports multi-valued fields. Load the dynamically normalized table then select from the un-normalized t...

That's part of what ETL is about. I gave the main reason in my earlier post - you retain complete control, and don't update the target table until you're ready to do so. If your data volumes are large, you can use the "bucket file" to reduce the volume of rows needed from the target. Essentially thi...

What is your workaround?

What is your stage type? If Sequential File stage, have you investigated the File Name Column property?

Perform lookups against (local copies of) the target table. Dump the output into a staging area. That way you can run and re-run the referential integrity checking and surrogate key generation phase over and over until you get it right, and you have a good basis for building restart-recovery into yo...

Ask for tab-delimited. It's a common format, most user tools can produce it.

Welcome aboard. The answer is yes, but why would you want to? That's what the Aggregator stage is for. And it works MUCH, MUCH BETTER if the data are sorted on the grouping key(s) and you assert this fact on the input link to the Aggregator. The Transformer stage method REQUIRES sorted input to be s...