DSXchange

I have the following recordset (2 columns oldpolid,newpolid). eg is as follows
a,b
b,c
c,d
d,e

I want the following record set
a,e
b,e
c.e
d.e

i.e. I need the final answer but also all the intemediate .
I would appreciate any help, thanks guys

any advice would be appreciated, a job aborted with the following errors: ds_seqput: error in 'write()' - Error 0 ds_seqput: error in 'write()' - There is not enough space in the file system. This job runs once a month and has always been successful in the past.The job is fairly complex and takes 20...

Ray, thanks very much, problem solved, it worked a treat. I really appreciate your help

Regards
Tal

Hi Ray, I am using version 6.0.1.5, thanks for spending time to look at the Scenario, I apologise if my explanation is not clear, its sometimes difficult to describe I did the following On Input (Sequential File Stage) , on the 'Filter Command' tab ,I typed 'sort'. I got the following error : Sequen...

Thanks Ken for your post. My source comes from Sybase. We are not allowed permissions to create procedures, just select statements. Does anyone know if I can do this in Sybase (I could possibly copy it to DB2 and manipulate it there). I think the cleanest 1 job approach would be using DataStageBasic...

Unfortunately , the above didnt work , any other solutions would be greatly appreciated

I have a record set like below in a csv file (can be *.txt) OLDPOLID, NEWPOLID AJRZE3J0313A, AJPZE3J0313A NOCP42M0836A, NOCP43M0836A LWA73ARAH02R, LWA73ARAH01R LWA73ARAH01R, LWA63ARAH01R AJPZE3J0313A, AJPZE3F0313A LWA63ARAH01R, LWA63ARAH01Q LWA63ARAH01Q, LWA63ARAH01A This file (csv or txt) hold poli...

raju_chvr wrote:Did u give it a try with stage variables and RowProcGetPreviousValue() ?

I think that should work. In the constraints you should have a condition

RowProcGetPreviousValue(NewPolid) <> OldPolid

to write into output.

IHTH

This didnt work, any ideas why or other methods, thanks in advance

Hi all, i have a file/table that holds 2columns OldPolicy,NewPolicy eg: OldPolid , NewPolid AA , AB AB , AC AC , AD BA , BB BB , BC AA became AB,AB became AC, AC became AD.The net result is that AA became AD and similarly BA became BC . I need to reflect this as: OldPolid , NewPolid AA , AD BA , BC ...

I have a one line text file. The data in this line is: 541015210154301 I still want to keep the data on one line but after every 5th character I need to put some text in [ then enclose the answer in () ] eg: The output I need is: (el1="54101" or el1="52101" or el1="54301&quo...

I have a user defined routine [ UDR ] which accepts 1 argument and I am trying to call this UDR from within a second UDR. its not working see below: ####################################### FileName = "testfile.txt" Deffun RunJobWrapper(FileName) Calling "DSU.RunJobWrapper" Call R...

i need last row from Transform not last row from a FlatFile. I think you have given me a solution for choosing the last row from a flat file to a TRANSFORM. I need to get the last line from a TRANSFORM/(Input Link) and then output it to a flatfile. I was trying to put a constraint in the transform e...

how do I output the last row from a transform to a flat file, there doesnt seem to be a max function or last row function


Thank You