DSXchange

Hi Kumar,

I take my statement back . I agree with you that you cannot pass the columns in the aggregator without applying some kind of aggregate function. I was thinking about something else in my mind, when I answered your post. Sorry for the confusion.

Hi Kumar, Contrary to your subject for this post "simple question reg aggregator". Your second half of the post is quite confusing. :wink: Anyway, from what I have understood about your problem, here is my take on it. I could not find any simple solution for this simple task. I just need t...

They can also be used for eliminating duplicates.

Hi Vinay,

I dont think I have ever got that error. Like you said in an other post, you seem to have a license issue, which would explain this error too.

This great achievement has been possible only because of the Top Posters who have answers to virually any problem that you might have in Datastage. On behalf of all the Dsx users, I would like to thank all the Top Posters for spending so much of their valuable time and expertise, in making the Dsx c...

Hi Kaps,

I guess that he meant "each line"

Hi dsrules,

Could you please correct the format (allignment of your data and column names) of your example?. Its very unreadable now.

Hi NaveenD,

I don't think there is any direct way to do that, as Datastage processes only one row at a time.

Hi NaveenD,

Good that it works for you now. :D Why wasn't it working earlier?. What was the mistake?

Hi NaveenD,

I have used a similar technique in a lot of jobs. It should work for you too. Try to use the Debugger and monitor the values of OLTRAN and NEWTRAN. That will give you an idea of why its not working.

Hi Phani, As far as I know, there is no plugin for PX that will let you directly access VSAM files residing on mainframe. However, there might be some mechanism to directly read from mainframe in DS390. In PX, You need to first ftp the VSAM file from the mainframe to the UNIX box and then convert it...

Hi Fernando, You can use a simple server job, But your actual job design depends on 1) How are you getting the data from mainframe?. 2) Is it through directly reading DB2 tables? 3) Are you being provided the mainframe data in a flat file or mainframe dataset? You need to provide more details about ...

Hi,

select * from ds_jobs where category='ELDM\DIMENSIONS'; >/HOME/USER6/TRIAL.TXT

Take off the ; at the end of the select and try

Hi NaveenD, Its Simple, use stage variables like shown below Derivation StageVar NEWVAL OLDVAL INPUTVAL NEWVAL Then use both the above variables which has old transaction no (OLDVAL) and the new transaction no (NEWVAL) to check your condition

Hi,

What kind of error are you exactly getting?.