DSXchange

What has changed?

Is there any other message, such as failed to delete /opt/etlbatch/hashfiles/HAdcCharge_026 ?

You need to import the metadata first. In Manager choose Import > Table Definition then choose COBOL FD (or DCLGen, if that's what you have) from the list of available sources. For a COBOL FD table definition you must provide the column number in which the 01 level item appears. Once you've done tha...

Changing these parameters will only affect code -14 errors in extremely specific circumstances. Please desist from suggesting that it's a cure-all. Code -14 is most usually caused by the machine being overloaded, so that there are insufficient resources remaining to allow the job to start within 60 ...

A Link Collector adds unnecessary complexity, to my mind. You are seeking to perform seven separate operations. Make your design modular; use seven separate (and simple to maintain) jobs.

It is not possible to use a shared container without supplying values to its parameters. Therefore there is no mechanism provided that allows for default values for those parameters.

Windows is no different from UNIX in this regard. The configuration file determines absolutely the maximum number of processing nodes.

You can take a look at the RT_SC367/OshExecuter.sh script and see what is happening that might raise a SIGILL signal. Otherwise report it to your support provider. Let us know the outcome.

There is a small group of environment variables (accessible from the Administrator client) that relate to the compiler and linker. You might investigate these also.

This is very much a do-it-yourself exercise. There's definitely nothing "out of the box". Because everyone's ETL is different (with the possible exception of PeopleSoft applications) there can never really be a generic solution. There are even differences in what different people want tested. I assu...

What table name are you using? Most ODBC drivers for Excel treat worksheet names as system table names (you need a trailing "$"). Check also that your DSN correctly selects the pathname of the workbook (the XLS file).

Compared to what? The biggest con is the cost of joins; contrast a start schema model, with some redundant data and very few joins (queries are very fast) with trying to find the appropriate join paths in a fully normalized model. In short, OLTP models are tuned for update performance, OLAP models a...

Of course VarChar(40) will be irrecoverably truncated if loaded into a VarChar(30) column. How could it be otherwise?

TZ is a standard UNIX environment variable. You could therefore define it for PX with a default value of $ENV.
System() is a BASIC function. You could therefore create a routine to be invoked from a Routine activity in a job sequence.

Of course you can cat all the files. You just need some extra commands in the pipeline (like tail +1 and head +1) to strip off the header and trailer lines.

Timestamped 3 hours before yours. Something weird is happening. Or maybe my dial-up line is even slower than I thought!