DSXchange

Welcome Aboard!

Oconv converts to an output format, Iconv to an internal storage format.

Given that there are so many different conversions that can be acheived with Oconv and Iconv the easiest way to learn about them is to read the documentation or press help.

Am I missing something here?

What sort of file? Sequential? Hash?

Just for everybody's information.

The changes suggested (ie use hash files and unix sorts) have sped the job up from 3 hours to 35 mins. (In initial testing anyway put its a very promising sign!! :D )

Thanks again to everybody who put forward suggestions.

Hi All I have a query regarding the difference between the datatypes XML and CLOB as used by Oracle 9.2. Are both of them long datatypes? And how will this interact with the ORAOCI8 stage. I have an issue where I am trying to capture rejected XML records. When a record is rejected the xml record is ...

Thanks for your ideas, but with your methods I think I can't have a file with this structure: header 1 ligne 1 ligne 2 header 2 ligne 1 ligne 2 Is there any link between the header and the detail? ie So you know which detail lines belong to which header, or is it just write header, 2 detail lines, ...

Can't you just use a unix command in a before or after subroutine?

eg cat detail.txt >> header.txt

Important thing is, the file will have only one Header and one Trailer records . Ok now you have lost me again. Do you mean that you are processing one file at a time and each file only has one header record and one trailer record? If that is the case then do as Ray suggests, just check the file fo...

I hope I have made my ideas clear. Please correct me if I have to follow a much better approach. Not really that clear unfortunately? I am assuming that you are writing the Trailer record to a hash file and then using some sort of key value to match that trailer record to a detail record. If there ...

Hi All, There is some more logic to be implemented in this job. 1. Need to check if both Trailer (T) and Header (H) records are present in the file. 2. The Detail (D) records should be processed only if the file consists of both Header and Trailer records. 3. The Trailer will have date, time and ID...

You could read the sequential file with a seq file stage with one column. Set this column to have a delimeter of 000 and a quote of 000. Connect it to a transformer and select the first character of each row into a stage variable. Have 3 outputs to sequential files, each containing the one row and ...

You could read the sequential file with a seq file stage with one column. Set this column to have a delimeter of 000 and a quote of 000. Connect it to a transformer and select the first character of each row into a stage variable. Have 3 outputs to sequential files, each containing the one row and s...

Use the five-argument variant of Ereplace() in which you can specify the starting occurrence and number of occurrences. But I still think Cats() or Splice() is a neater solution. Have already implemented and tested the 5 argument version. Thanks for the suggestion of cats or splice - i will give th...

Ok I have figured it out! :o :D It was the variable ReplacedFirstRow that was the problem. The substring value of the ereplace was set to pick up the value of the first row, when it found other instances of the value it replaced them also. All I need to do is limit the replacement to the first insta...

Tell/show us how Prefix is defined/derived. Investigate the Cats() function and the Splice() function for easier mechanisms for adding a prefix to each element of a dynamic array. Cats(Reuse(Prefix:","),input.data) Splice(Reuse(Prefix), ",", input.data) Hi Ray Prefix = input.fil...

Hi All Back again and totally confused as usual. We have a job which reads from a folder stage into a transformer and out to a sequential file. Folder ---> Transform ---> Seq File In the transform stage there are several stage variables whose aim is to append a prefix to each row. The variables are ...