DSXchange

Hello, For each DS-Job, which retrieves data from a database, I want to put the start- and endtime and some more information in a database table. For the starttime-entry I use a StageVariable RowCount. When RowCount = 1 I write the start of the Job in the table. For the end of the DS-Job I have been...

Hello,

Thanks for the information.

Kind regards,

Jan

Hello, In a DS- Job I have created a hashed file, containing 26 columns. I want to use this hashed file in several DS-Jobs. In one of these jobs I need only 4 columns of this hashed file. What I did is I loaded the definition of the hashed file, deleted the columns I did not need in this job. When I...

The question was not complete. I needed the dropped columns (date valid from and to) to determine wether I could drop rows.

Thanks all,

Jan

I understood that it can be solved by making your own User Defined Functions in MSS.
Using a job paramater is unfortunately not possible as I have only the year and month and have to determine the end of month.

Thanks all.

Jan

Hello, We have build a DS Job using the Transformer. The only thing which is done is retrieving data from a database on a MSS SQL Server drop columns and rows and write the result in another database on a MSS SQL Server. My question is whether there is a more efficient DS-Stage than the transformer ...

Hello, I made a routine to determine end of month (YYYY-MM-DD) based on year and month in DataStage (typed Transform Function). Therefore I can use this function in the Transformer to drop rows. This works. Actually I wanted to use this function in the WHERE-clause of my SQL statement as this looks ...