DSXchange

YOU can define the encoding using stage properties. The defaults are different for different stage types (Compare, Difference, Change Capture).

You forgot to post the actual errors.

That's a devilish FTP site you're using!

My belief is that the manuals were produced when no-one in Ascential really had any idea of how the Orchestrate stuff worked, so the poor old technical writers were just thrown in at the deep end. Unfortunately, there has not been a whole lot done to improve things in the interim. Even the version 8...

I doubt it's the Funnel stage - the Funnel stage does not get compiled, it simply generates a funnel operator in the generated OSH. The Funnel type (continuous, sort funnel or sequential) is just a command line option for the funnel operator. Examine the generated OSH. Sequential funnel is only usef...

Vector.

It could be a missing quote character - 32KB is a heck of a long string literal - maybe the compiler is still searching for the closing quote. I'd be prepared to bet that your entire code is less than 32KB in size!

Open the table definition in Manager or Designer Repository view. Choose the Layout tab. View the metadata as SQL, COBOL or Orchestrate schema format. But it's all the same metadata. And you can answer your question about PIC S9(9) USAGE COMP.

The example showed least recent salary date. Glad I'm not covered but THAT payroll system! For most recent, of course, use MAX() rather than MIN().

Best practice is to detect any condition that fails a business rule prior to attempting to load the row into the target table. This is part of the "T" of "ETL". Your choice of Write Method is then irrelevant as far as clean data is concerned and you can base the decision on appropriate criteria: whe...

Once you have rationalized your use of hashed files (note: not "hash" files) search the forum for T30FILE. This is both the name of the table and of the configuration parameter (in the uvconfig file) for setting its size. You will also need to research - either here or in the manuals - how to reconf...

It's time to have a major re-think about your design. UtilityRunJob was originally a quick fix - it does not have all the functionality that a job sequence offers. Begin by documenting (in English, not in IT-speak) precisely what needs to happen under each circumstance. You will find that this leads...

That command is OK as far as it goes, but it does not execute any commands once in sqlplus and never returns from sqlplus. If you want to build up the entire script in the variable called cmd, separate each line with a field mark (@FM). These will automatically be translated to line terminators on s...

A Before SQL statement will be executed once, before the first row in the job is processed. Hence its name.

"Identifier" is usually the column or table name, not the text value itself. In DataStage you can set VarChar up to 65535. The restriction, however, may be in the data browser itself rather than in the database connection - post the full error message, which should indicate its source.

More 2. If you use server side tracing clean these files from the &COMO& directory once you've finished with them.