DSXchange

It would be courteous were you to share them with us.

Null is not permissible as a key value in a hashed file.

Expected=Date,Actual=

suggests that the data type is not given in the column definition in your job (or in the database).

Which NLS parameter did you set (and to what value), and does it fix the problem to reverse that setting?

The one mentioned on the IBM website as being required for that version of DataStage on that particular operating system. On Windows there are three or four possibilities, such as the .NET Visual C++ compiler.

Hi, You r not toled where u get stricked in useing surrogate key stge and there is different methdes in useing skey in Datastage stage 7.5*2 and 8.0.1 First tell me the version :?: While we appreciate that English may not be your first language, please try to be more professional when using DSXchan...

Your unwillingness to change is severely limiting your options. Did you try simply enabling inter-process row buffering as I suggested? Create some jobs to determine where the bottleneck is. For example: DRS ---> Transformer ---> SeqFile with a constraint of @FALSE in the Transformer stage will show...

Only UniVerse (and Hashed Files) and UniData support dynamic normalization. But, in this design, you can do normalization while selecting from the UniVerse table.

Save the new job before it has any stages. Let us know the result (including the exact error message, if any).

Run fewer jobs at once? Really one can not offer advice because we have no information at all about resources demanded by your jobs, resources available on your system, where any bottlenecks might be occurring, which jobs are scheduled to run simultaneously, and so on. The only information we have i...

What user credentials for each database did you provide when installing Information Server? (Check the installation response file.) Use these to access XMETA and IADB. But... why do you want to?

If the ls command reports no filenames, then the External Source stage will report 0 records imported. The whole thing depends on the value of the job parameter.

Any transformation must have the column(s) to which it applies present on the Transformer stage input link - it must be there explicitly, it cannot be provided via RCP. So, unless this transformation exists for all of your generic possibilities, it looks to me like you're going to need more than one...