DSXchange

Based on your job design it appears that you are not doing any change data detection and are updating all 600,000 rows. If that is true I would question whether it is necessary to update every row every time your job runs. If only a small percentage of the records are changing on an incremental basi...

The pivot stage is not installed automatically when datastage is installed. It is a plugin that is an option when installing the datastage server. If you are not seeing it I would guess that it is not installed. Check the Plug-in installation guide for details on how to get the Pivot installed in yo...

The easiest way that I know to do this is with stage variables in a transformation following the pivot. The rows generated will be in the same order that the columns were so Dol_day1 will be the first row followed by day2, day3 and so on. So create a stage variable that loops from 1 to 31 and assign...

You can use the pivot stage to convert columns to rows.

This topic has been discussed many times before. You can do a search on 'table usage' or just check out this post.

I think your problem might that you are trying to use a Unix command in Windows.

Yes, you can use parameters in your SQL. The only thing I think you might need are ticks around your date. We use SQL Server and the dates are required to be enclosed in ticks.

Could you just add a current record flag? Then as you process a record you would check to see if it has a current one. If it does create your new -1 record, set the flag on the old one to false and create the new one with the flag set to true. If no record exists just create the new record with the ...

Could you provide a few more details about what you are trying to do?

If you just want the last record update in a table it would be a simple Select statement

A previous session may have crashed and was not able to release the job. This topic has been discussed many times before such as thislink.

You import DSX files and XML documents through Datastage manager. Go into manager and select Menu/Datastage components from the menu. Here you will be able to import your DSX file.

Check out this post. It identifies a tool that Chuck Smith created that can be used to search a project for file or table usage.

You can accomplish this in one job exactly like you show in your example. Datastage will process from the source to the flat file and once that finishes it will process from the flat file to the target. You should get the results you're looking for and avoid the locking problem that you were having.

You can enter values in the derivation to get the results you want. You don't have to map a column from your source table to each column in the target table.

If you want a blank just put '' in the derivation. If you want a null value in your target enter @NULL in the derivation.

Is it possible to update just a single column in a hash file without losing the rest of the data on the record? I have a hash file records that consists of a key, a status, and some other data. I want to just update the status but when I do just the single field the rest of the data is cleared. Is i...