DSXchange

Re-check the job that originally created the Data Set.

Space allocated to variables local to the routine should be freed. Or you might be able to use static variables.

The Sort stage is perfect to use if the data are already sorted. Specify the sort mode property as "don't sort, already sorted". This prevents DataStage from inserting a tsort operator into the step (= job).

Does backslash work as a quote character? If so you can have

Can you try Final Delimiter = "End" ?

Relating to "duplicates coming out of Remove Duplicates" stage, no-one seems to have picked up on the possibility that the data are not partitioned on the keys used to identify duplicates. This would cause the symptom described.

Or just click the Help button or press F1 when next on that page.

You have specified a delimiter that is not in the data. DataStage has given up searching for the first occurrence of the delimiter, having not found one in the first 100000 bytes of data.

Not off the top of my head. Right now I am working with version 8, not version 7. You should be able to find all this information in the installation manuals.

Is this Oracle 9i data source the one from which you wish to import table definitions? (I don't have QS version 7 right now, am working with version 8, so all this has to be from memory.) Is the ODBC DSN a user DSN or a system DSN ?

Is this the same machine as the one on which you are experiencing the installation problem? If the pattern file (which is the source data for the frequency reports) is being produced, then I can think of no reason other than badly-installed software that the frequency reports are not being produced....

This is the correct approach, and requires also that the data are partitioned and sorted by state.

Test a bit further, and find that the documentation is incomplete rather than wrong. It should include "if the field number is greater than 1".
Field(Mystring, "/", 1) ;* returns the entire string.
Field(Mystring, "/", 2) ;* returns "".

Is DATA a reserved word in your database? Is "DATA" a nullable column in this table?