DSXchange

Private Message received: Hi, I want to develop a job that reads data from a sequential file and formats it into XML. This XML has to be messaged using the MQseries. can you please give some guidelines towards developing this? Thanks and regards, Aravind. Approaches via private message or private em...

Actually, hashed files can have "" as a primary key (since 6.0). But never NULL as a primary key.

Arnd learned about hashed files before that.

Read about Sequential File stage and XML. Search the forum. Search the forum also for "vertical pivot". Search the forum also for "urgent". We don't do "urgent" here.

When a Hashed File stage (or DataStage BASIC routine) writes to a hashed file, if the key value is one that already exists on the hashed file, the old record is destroyed and the new one replaces it completely. That's why it's called destructive. However, this is all one operation in hashed files (n...

If you have NLS enabled, prefer UNISEQ to SEQ.

UniVerse System Description is probably the best start point. Of course none of these manuals will make any reference at all to DataStage. Next should probably be UniVerse SQL Reference.

Is uvodbc.config readable by the user ID under which DataStage runs(permissions)? Is uvodbc.config empty? What is in .odbc.ini ?

You need to pass at least one other column through the stage. Having a column generates a schema for the stage. Or you can specify a schema file or runtime column propagation in the stage properties.

That suggests one of two things - either it's not Arabic, or you do not know how it is encoded. You definitely do need to know that. Then, once the encoding is known, you will probably need to build that NLS map for DataStage (done from the NLS button in the Administrator client) and use it either f...

Welcome aboard. :D Is this happening when you explicitly try to open these in jobs (that is, opening them is part of your job design), or when you are simply working with jobs? Can you be more exact with the error messages that are generated? The RT_... hashed files store run time information - conf...

Writes to hashed files (note: it's "hashed", not "hash") are destructive overwrites.

Holidays - of necessity - must be table (or hashed file) driven. Some holidays change year to year, such as Ramadan or Easter.

Left(Oconv(TheDate, "DWB"),1) = "S" is a convenient test for a weekend day in English.

Missed this earlier. You needed

The "L" in the Oconv second argument gives the alphabetic components in title case.

As the tool currently exists, the only way you could do this would be to script it, including the acknowledgments that each phase is complete. It's a bit more streamlined in the next version, but it's still really a step-at-a-time methodology.