DSXchange

Bulk load can be enabled in the DSN in all versions 8.1 or greater. Go to the .odbc.ini file and add this to the DSN EnableBulkLoad=1 BulkBinaryThreshold=32 BulkCharacterThreshold=-1 BulkLoadBatchSize=1024 BulkLoadOptions=0 Change the odbc driver from the classic driver: Driver=/opt/IBM/Information...

The Data Set stage does not support input and output links in the same job. A better approach would be to use a sequence to prevent the job from executing if the file is not present. ... Of course a sequence is best to handle this and we will do so. But we want to prevent that if somebody accidente...

Thanks very much for the quick reply . I will study your proposal.

We have job with the following logic. Insert the contents of a file to a table but first truncate the table. If the file cannot be read (wrong format or is not available) the job should fail and the truncate should not happen. Is this possible in a job ?

we got deadlocks when doing updates on a table which didn't have an index on the key column

We upgraded to 8.5 FP1 and noticed the following in the Designer client : - the fan-symbols on the links have disappeared. However, you can still see them in the pop-up that comes up when you move your mouse over the job-name in the repository window - in the sequential file stages, you can use DOS ...

Then I am afraid that I can't help, these things are handled by the guys from infrastructure.

Check if you have a valid license key.

ray.wurlod wrote:For example, you might create a shared container for generic error handling. Within the container additional columns could be added for the job name, the job start time, etc.

Can you give an example of this ?

We are new to DataStage. We are struggling with the SybaseIQ bulk load stage, especially with the transaction control. Does anybody have any experience on this ?

Thanks