DSXchange

Level number is straight out of COBOL and refers to the ability to create subrecords. Similarly vectors are straight out of COBOL and refer to "repeating groups". The Column Generator stage does include the ability to generate data into these structures, but do you really have a need to do so? The a...

I don't understand. Or are you after a "no" answer to help justify the upgrade? At one level ODBC is ODBC so, if you have the appropriate driver, then DataStage is just another client application. On the other hand, DataStage 6.0 may only support ODBC 2.0 protocols, which may limit some of the funct...

Yes, but you could do that with regular stage types as well. For example you could read the file with each line being a single VarChar column, and parse it within the job, possibly with an appropriate Column Import stage, possibly with a Transformer stage. Or, particularly if there are not too many ...

D-do Run Run

Erk. Recovering the VOC file is not as simple as just recovering the VOC file. None of your routines will be cataloged, for example. You might try running Multi Job Compile (and include Routines) after restoring the physical VOC file. Any commands you may have saved from the Administrator client's C...

What ever happened to "urgent"?

What ever happened to "urgent"?

It's worth trying, of course, particularly if you believe you've lost that metadata from XMETA.

Without performing a physical inspection, however, it's impossible to determine what's missing and what's not. That's why you need to involve your local support provider.

A job sequence can do all of that.

The WHERE clause is empty. This suggests that no column is identified as Key. Do you really want to update every row in the table for each row processed by DataStage?

Have you tried it?

Why not?

And please mark the thread as Resolved.

Professionalism Note Please eschew SMS-style abbreviations. DSXchange is not a mobile phone; we expect a professional standard of writing. The Row Generator can generate data in any of the simple data types, of which Integer is one. (It can not generate vectors or subrecords, which are non-simple d...

Beware that, if you have RCP enabled, they may not be dropped by a Copy stage.
More precisely, they may be dropped and then propagated!

In its entirety please. We need to see what's inside those curly braces. Obfuscate your data if you need to, but not anything produced by the framework. For example, I suspect that the "cs" is a "case sensitive" sub-option to a sort, but can not be sure without the remainder of the information.