DSXchange

The required width for Decimal[m,n] is (m+2); m is the number of significant digits, but you also need one character position for the sign (even if it is " ") and one for the decimal placeholder.

Why?

Runtime column propagation is anathema! It destroys any hope you might have of performing lineage or even accurate impact analysis.

The logic is essentially the same; consult the Parallel Job Developer's Guide (the chapter on programming with the API) for examples.

Did you specify to use a write cache? FILE.STAT reports on distribution of records, in particular overflowed groups. The same information can be collected via the ACCOUNT.FILE.STATS program. HASH.HELP suggests a new file type, modulo and separation but beware that it calculates separation first. HAS...

Welcome aboard.

Read the section about null handling in the Parallel Job Developer's Guide - in particular the difference between in-band and out-of-band nulls. This should make it clear what you need to do.

Not directly. The only way to do this earlier than version 8.0 is to create a DataStage job that includes a QualityStage stage to invoke the job, plus RTI (SOAP edition) components that allow you to publish the DataStage job as a service.

I did.

For only a few cents per day you can obtain premium membership, which would let you see the entire post. This revenue is 100% used to help pay for the bandwidth charges for DSXchange.
There's a link from the home page that you can use to sign up.

When job type is selected from the drop down list, could it be passed through some form of validation? For example, if you choose Parallel but you're in the Server forum, a message indicating that the Parallel forum might be more appropriate could pop up. If you choose Server or Parallel and you're ...

Is your server shared container violating one of the rules in Chapter 2 of the Parallel Job Developer's Guide ? If not, you have probably uncovered a small but annoying bug. Within the server shared container you might be able to use routines from a Transformer stage to interrogate the job parameter...

DELETE INDEX in the Open command of the ODBC Enterprise stage and CREATE INDEX in the Close command of the ODBC Enterprise stage for the MDX file. DROP TABLE and CREATE TABLE for the DBF file. Or invoke the same SQL statements via a script called from before-job and after-job subroutines.

Welcome aboard. Yes it is possible, but you will need to write your own routine, and specify NONE as the map - otherwise the map will attempt to convert the Korean characters into UV-UTF8 encoding of Unicode, which is used internally by DataStage. The functions you may need are: BYTELEN() BYTE() BYT...

ERRORLEVEL returns the exit status of dsjob. If the -jobstatus option is not given, then the exit status indicates whether or not dsjob was successful in submitting the job request. If the -dsjobstatus was given, the exit status of dsjob is that of the job that was run, as documented in the JOBCONTR...

My guess is that the unbounded string is the result of string_from_decimal(). Check with your support provider. Can you post the actual text of your conversion specification as it now stands?

Use a Complex Flat File stage and specify flattening of the array.

All jobs are look up jobs. it contains an OCI -> Transformer -> Hash file. Clearly this one is NOT a "look up job". It's a job that loads a hashed file. Always check the first warning first. The alert that DataStage is attempting to clean up after an abort is not interesting in the context of tryin...