DSXchange

Hello

I should not use CFF as i need to produce XML chunks in the output and i need to join those chunks

thanks

Hi I have a requirement where i would be getting a string from sequential file stage in column i.e 000006200H 000005139{ 000002345A 000003456J The last character of the string is alphabet and it might also have some special character. My requirement is i need to convert those special characters to s...

Hi I have a problem while converting packed decimal. I have a Fixed widht flat file coming from Mainframe. I have imported the cobol copy book definions and saved as table definitions and i am trying to read the Fixed width flat file by using sequential file stage. I am using column import to parse ...

Hello

I am wondering whether we can use XML stages in v7.5.1A parallel extender. Because the XML pack Designer guide always talk about using xml plug-in stage in server jobs??

Thanks

Hello Ray, There are 4 fields delimited by % and the record delimiter is ^%^. There might be more than 2 records. As i need to matc the file name with each record i tried that using Nested Loop and User variable activity stages but could not match the File name with the delimited values. Probably i ...

Hello I have a requirement where i need to read the File name using Sequence (Execute Command Stage i.e ls -t | head -1) and Match that Filename with some delimited values which are in a separate SeqFile. For Example in the sequence i am reading the File name by Execute command stage i.e (ls -t | he...

i did not see any thing like select multiple rows

i did not see any thing like select multiple rows

Sorry i gave the wrong requirement. I need the output format to be

1 NAP AB CD EF

Regards

Hello

Thanks for your reply.

Where should i select multiple rows returned from the link

Thanks

Hi All, I have data like this, Soucre file has (seq file) col1 col2 1 NAP Lookup data from database (oracle stage0 col1 col2 1 AB 1 CD 1 EF 2 HJ I want to retrieve multiple rows from lookup data My final target data file should like as below col1 col2 col3 1 NAP AB 1 NAP CD 1 NAP EF Please help Thanks

yes i am able to execute that in a unix script.

Thanks

Hi I am executing a after job sub-routine ExecSH. The script is not getting executed. Below is the error i was able to see in the diretor. Error when executing command: nawk 'NR == 1 || substr($0,63,5) ~ /H... / && \ _++ == 2 { fn && close(fn); fn = "part_" ++c; _ = 1 } { p...

Hello Chulett, thanks for the reply. In the previous post i have given sample data for 4 invoices. So the out put should be 2 out files with each file having 2 invoices (as we want to have 2 invoices for file) After splitting the first file should have 2 invoices 4H000 000 000 4H000A000 000 4L003M00...

Hello I have a requirement where i will have fixed width flat file with multiple invoices. Each invoice can be indentified by its First line's second character , which is "H" and sixth character would be " " (space) and each invoices last line's second character would be "T&...