DSXchange

Nodes are grouped into pools in the configuration file. It is pointless to do so, however, with a single node configuration. The same applies to disk pools. A node pool is a subset of the possible nodes in a configuration; it makes more sense to use node pools in an MPP environment. Stages can be re...

What is happening to make you say "it doesn't work"? That is not a particularly specific symptom description.

If you've used NullToEmpty to remove nulls from the column, also lose the second COALESCE from the sql statement. It's unnecessary.

Take two passes through the file. The first does nothing other than verify that each header record has detail and trailer records that belong to it. This is all done with stage variables and relies on the file being sorted (use a Sort stage if you need it). It might also populate a hashed file from ...

Extract ----> Transformer ----> Transformer ----> Database | | | | V V Rejects Exceptions from DB When processing exceptions, use DBMSCODE and LASTERR link variable to obtain diagnostic information.

Open a CMD shell (Start > Run > cmd)
Type in CMD /?
Read what's displayed.
Type EXIT to exit from shell.

ALPHAnumeric was specified in the subject.

You require DB2 Connect software installed and configured on your DataStage server machine. Others have done this - search the forum.

By "Sorter" do you mean a Sort stage? For efficiency I'd be inclined to pre-process this file to count the rows beginning with "H" and the rows beginning with "T" to make sure that they're the same. This could be done quite quickly in a shell script. Of course, it does not guarantee that there are m...

How about you give us your thoughts first?

How many outputs does this job have? What is the layout of each?

Can you do it in a single job? If not, why not?

See page 8-8 of the QualityStage User Guide (version 7.5) for information about running QualityStage jobs from the UNIX command line. I am talking about using multiple QS plug-ins in a DataStage job, not in a QualityStage job. These can stream the data into and out of QualityStage; they do not requi...

Is it dsdesign.exe that is eating the CPU on your PC? Use the Processes tab in Task Manager; click on the CPU column heading to sort by CPU.

It's somewhat less meaningful in a parallel job, since you will get different counts on different partitions. How do you intend to handle that? Running in sequential mode? You may as well use a server job (which is quite fast with sequential files). The easiest technique, if you have a Transformer s...

Obviously they are expecting you to resolve their confusion. Get agreement on definition of terms, in writing and signed ("CYA"). For example, a reject is a row that fails ETL processing because some business rule is violated; an exception is a row that is not a reject but which violates some constr...

Assuming that you want everything ahead of the first space character, and everything after the first space character, then the Field() function is what you need.