DSXchange

To correct Ray, I believe he meant a frozen block of hash.

There are only the two mechanisms mentioned already. Either you have NO definitions in the job and stages by using RCP OR you develop your DataStage stages and jobs in a VERY structured, disciplined and methodical way with the use of Table Definitions. Using the latter means you maintain the table d...

The Project env variables are found in the file DSParams in the Projects/<Project> subdirectory. This file can be copied to any other project and editted to suit. Obviously be careful in doing so since it is a hack.

The MQSeries Stage might give you an argument on whether some data elements are "nice to have". I believe there are some internal data elements of this stage that would make them mandatory. Are there others?

Yes, this is what I do. I set the NULL_VALUE to "" - the EMPTY String. It ONLY works if I NULL the date fields, otherwise the date fields will fill with asterisks. Using space(10) is almost as bad as asterisks. Luckily I use the APT_ALLOW_ZERO_LENGTH_NULL_ON_EXPORT_BLAH_BLAH_BLAH set to TR...

It makes no difference, Andet. Nor can one set a stage variable to null. I had to revert to SetNull() in the derivation of the columns. This worked but I no likee.

I prefer not to muck with the definition of the date fields. However, I agree it is probably something to do with defining the output as tick tick. My real question is, granted it works that way, how can I change the default behavior?

I am converting some date fields from our default of 1900-01-01 to the empty string (''). I am writing them out to a sequential stage with a datatype of date nullable and a format of %dd/%mm/%yyyy. They are beng written to the file as **********. I used to do a SetNull on the fields but thought maki...

I have used the MQSeries stage to run 24X 7-ish. We shut it down every Sunday night. You are very close in your last post. There are three ways to stop a DS Server job that takes queue messages as input. 1. By number of messages read 2. After a certain amount of inactivity. 3. With a Stop message. W...

To be precise, it is not 75% of 79 or you can miss 19 out of 79. The questions are weighted by category, I believe.

I see the defaults defined in the import stage in the outputs tab in the format tab in the stage. Both in the table definition and Manager therefore I don't understand the question. In the format tab at the record level is clearly the final_delimiter = end and at the field defaults level is delimite...

You have two options;
1. Do a search on the site because this well known problem is discussed a million times.
2. Cough up the $99? to see Ray's answer.

You've managed to hit two of the DS Gods' pet peeves in a single post! Not searching and not paying.

I can't read Ray's long winded response and by long winded I mean over two lines. Did he tell you to define this:

APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL
Value - true

as a Project variable in Administrator?

In the Sequential file properties tab is an option for a schema file. This defines the fields and other formatting of the sequential file. You might try paramterizing the schema file property of the Sequential file so that you can use different schema files run through the same job. Using a schema f...

Or save the Sequential file column definition to a table definition and edit it. Go to the Parallel tab and select the schema file radio button and it will be generated for you.