DSXchange

You will need to exchange your server licence. That would be true for any change-of-UNIX strategy (such as HP-UX to Solaris) - it's not specific to Linux. Make sure you have a compatible Linux; DataStage is very choosy about working on Linux - basically it won't work on unsupported ones, and even if...

Welcome aboard. Three mechanisms spring to mind. One is to use stage variables as accumulators, and detect change of record type. The second is to pre-process the file (since you have counts of the number of child records) to flatten the multi-row "record" into a single record. The other is to use a...

Why not just use the CurrentDate() or CurrentTimestamp() function?

DATE.TAG is for server jobs.

This suggests that you have some other application that is using the same name as one of the Visual Basic controls in the DataStage client, and this other application was installed after DataStage client so that it's DLL is the most recently loaded. From the error message there is no way to determin...

... but does U want to?

What is your Commit interval? For testing purposes, try running with rows per transaction and array size set to 1.

With a great deal of caution you can add the appropriate entries to the DSParams file. Look at an existing project that has auto-purge set, and seek out the [Auto-Purge] section, which is four lines long including the header. In your script make sure it's not already present, then append to the DSPa...

DS.REINDEX ALL may pause part way through waiting for you to "Press any key to continue...". Use the Respond button to provide that "any key".

You need EXCLUSIVE as well as ALL access to the project.

How many columns have you got in your Columns grid? Are you certain that this number of pipe-delimited fields exists in every row of your data? If not, have you set any of the "Missing Column" rules in the Columns grid? Which of the fields is supposed to be the decimal value? How are you trying to "...

(a) in Arnd's post includes the -stop option of the dsjob command. Note, however, that jobs - particularly parallel jobs - can take literally minutes to respond to such a request; give them that grace time before attempting anything more. Be patient. Like a run request a stop request is asynchronous...

Double comma indicates that the cell was empty. In the Columns definition right click on this particular column definition, choose Edit Row, and make the column nullable with a Null Field Value of "" (or a Null Field Length of 0).

Of course, if you were to contemplate TWO database stages, the answer would probably be more to your liking.

When Write Method property is set to Write, you are streaming rows into the database to be written directly into the table. Array size is not relevant.

AuditStage is the product formerly known as Quality Manager. Its purpose is to profile source data, auditing conformity to business rules. Why not visit IBM's web site and search for some information there?

The problem is almost certainly permissions at UNIX level. Check that your new UNIX user belongs to the group associated with all the file system objects (directories and files) in the DataStage project. There may also be a more general UNIX group, for accessing the software on the server, to which ...