DSXchange

Hello, I have read that the first column of a hashed file should be a keyfield. In the application I work on I have seen that this is not always the case although the job does what it has to do. Can you tell me what the consequences are when the first column in a hashed file is not a keyfield and wh...

Hello, I started a DataStage-job yesterday. After a 6 hours run it did get the status 'Finished'. Also all the subjobs have the status 'Finished'. When I look in the Task Manager there are no usvh.exe jobs active. In the event viewer I see in the tab Application warnings of source Escential DataStag...

Dear Chulett,

Thanks for the information and sorry for the inconvenience.
I was not sure if my post was looked upon after you had answered it and my addition to the post was today while the post was yesterday's.

Kind regards,

Jan

Dear chulett, I do not use an empty table anymore to clear/truncate a table. Using truncate I meet the following problem. I have two tables TableA and TableB there is a foreign key constraint between the two tables. When I use truncate for TableA it succeeds but when I use truncate for TableB I get ...

Dear chulett,

Thanks for your reply.

The 'Truncate table then insert row' is available. I should have looked at all the options in the 'update action' instead of the option used.

The other remark about not needing an empty table I will use also.

Thanks,

Jan

Hi, I want to clear tables using DataStage. The way I do it know is to read an empty table. In the target table I have selected in the update action 'Clear table then insert rows'. I have the impresion that tables are cleared via the SQL statement delete from while I would prefer truncate table, whi...

Hi ArndW,

As soon as this situation occurs again I will let you know.

Kind regards,

Jan

Hello, I have the impression that although my DataStage job has finished due to an abort an USVH.exe job stays active sometimes, not always. How can I be sure that when a job finishes due to an abort also the USVH.exe jobs come to an end. At the moment before I start a DataStage job I check whether ...

Hi,

How can I get an overview of commands which can be used from the command line in the DataStage administrator Client and the function of these commands.

Thanks in advance.

Kind rgrds,

Jan

Hello, I want to select within the combination of DUNS_NO (char) and DATE (timestamp) the DUNS_NO with the most recent date. The data comes from a hash-file with DUNS_NO and DATE as keyfields. A SORT reads the hash-file, the output goes into an AGGREGATOR and the output is another hash-file. In the ...

Hello,

Is it possible to find out in which DS-jobs a hash file is used.
I am trying to find this out via the DS Manager usage analysis but can't find it.

Kind regards and thank in advance,

Jan

Hello, I am building a routine in which I want to use the YearFromDate function. When compiling this routine I get the following message: Array 'YearFromDate' never dimensioned. I have the impression that I have to include ($INCLUDE) something to make this function available in this routine. If so, ...

Thnks for all the information.

Jan

Thanks Kumar_s

Hello,

Is it possible within DataStage to select more than one job for compilation.

Kind regards,

Jan