DSXchange

Hi Craig... The calls that Riccardo mentions are indeed what you need and are described also in the DataStage Development Kit chapter of the DS Server Developers guide, and have been part of DS since 3.0, so will be in your version of DS. They are actually part of a command set that can be used in D...

Hi Pedro... another method to use is a hash table. Multiple streams from a single transformer stage, or multiple transformer stages, can be brought into the same hash table, and then, as needed, taken from there via another output link, and into a sequential stage. Its an extra pass of the data, but...

Hi craig, you can test job status code with DSGetJobInfo(JobHandle,InfoType) then you can use DSRunJob(JobHAndel,RunMode) to reset the job. Check help online for more info. I hope it will help u. Riccardo ----- Original Message ----- From: To: Sent: Friday, November 16, 2001 5:18 PM Subject: Job to ...

Pedro.. unfortunately it is not. The NT operating system (which I assume you are running on) only supports one process having write access to a file at a time. I havent tried to reproduce your problem, but I am assuming that the job allows one of the processes to run first and then the other (in ess...

Hello to all again. Yes its me again with the same basic questions, well im just starting... I wonder if any of you nice people can help-me? Im using two different transformer stages to input data into an sequential file, the data exiting in the two transformer stages is equal, the columns are the s...

Im curious if anyone here can help me out with this... Im hoping I can find a way to write a batch job that could go thru all current jobs in a project and identify which ones are in an aborted state. Once those are encountered, Id like to email myself a list of the jobs that it found in that state ...

Celeste When you put something in the selection field then look at the generated query. It will add a WHERE before the selection clause. You can trick it by adding a 1=1 and then your ORDER BY clause. The ORDER BY Key2 needs a DESC to order in descending order. The generated query will look like thi...

Celeste, In the situation you describe, I would do the following... KEY GROSS.AMT === ========= A-0-00-H-000082*101 100.00 A-0-00-H-000082*103 500.00 A-0-00-H-000082*102 300.00 In the Unidata stage, order the data by the Key so that it will be reordered as such. KEY GROSS.AMT === ========= A-0-00-H-...

Hi Celeste, I have a suggestion, hopefully I interpret your requirements accurately. However there are some turnarounds for you to get the data. Step 1 ======= DataStage read from the Unidata file, and goes through a transformer, and output to a flat file. (I suppose your key number is increasing se...

Hi Kev, Thanks for your help. But I do not understand what are you saying here. I have written a routine and place it at Constraint at Transformer stage, but it didnt work. My main concern is to get the most recent key. This is the transaction data and Im really trying very hard to get this problem ...

Celeste I have not used Unidata with DataStage but normally you would ORDER BY field DESC. If you turn off cache then you select ascending. This the last record over the previous. I assume you are writing with the same key. With the write cache on DataStage does not overwrite a previous written key....

Nothing specific about datastage here... Ive seen this problem many times, I can never figure out why a current items table doesnt exist, ie; Key=A-0-00-H-000082,Data=103. Anyway, at a fundemental level, you just need to create a definition that returns your "select true" condition where the key=pri...

Hi there! Can anyone help me with this problem? Pls refer illustration below. KEY GROSS.AMT === ========= A-0-00-H-000082*101 100.00 A-0-00-H-000082*103 500.00 A-0-00-H-000082*102 300.00 I want to retrieve the most up-to-date KEY, which is A-0-00-H-000082*103. So, how do i do that in DataStage? My D...

Dear all Probably a simple question ... How can I compute a value in one stage of a job (say total of all values in a particular field) and use it in a subsequent stage (eg add a computed-field thats essentially FieldValue/SumOfAllFieldValues)? I was hoping to use a something like a "stage-variable"...

Hello, I am having trouble using the select criteria on a HASHed File stage. When my criteria is based on a column that I have hardcoded in an earlier transformer stage, it works as expected. But I have another column, allergy_desc, that is an MV field. I have successfully normalized the data the wa...