DSXchange

the minimum modulus was left at default of 1.

Having written 655,000 rows of a single vchar field of 10bytes to hash file, I believe that the max size would be (10+2)*655,000 = 1.31Mb. The total size of the hash file (data+over) is 21.6MB. Can anyone explain this.

Hi, Can you give a bit more specific info? (are you getting errors?, can you write a simple ascii file there?,...) There are no errors. The file allocates as a Variable Blocked (VB) file successfully, but all fields are fixed width and customer wants to read a Fixed Block (FB) file. Ascential says ...

We are using FTP stage to write a file to IBM enterprise server, with fixed width fields, nothing between the fields and cannot create anything but VB files. How do we cause the file to be FB?

Thanks everyone. Putting the transform stage in works fine and I see the reason to have it - for capturing rejects.

Here is a gross pictorial view.
TransformLink1-700rows->Link Collector-->Oracle Stage
TransformLink2- 2rows-->

To be more specific, why does every field in every row contain zeros after passing through the collector?

Sorry, I was in the log, but I only provided you with one warning message from the log. Here are two warning messages, that will more completely show where my confusion comes from. How does the Link_Collector stage know about an Oracle error message? PlanSignoffMerge..Link_Collector_14: ORA-01840: i...

Output to Link Collector is two links from the same Transformer stage. Link Collector has one link to Oracle8i stage. From transformer, first link passed 700 rows and second link passed two rows. Received many warning messages from Oracle due to a date field being too small. In fact, all fields cont...

Thanks Shawn. I went into job properties and changed the flags to enable inter-process row buffering and it compiled. Dan..

When compiling a server job, the error message is "Link Collector stage does not support in-process active-to-active inputs or outputs". The Link Collecter has two output links from the same transformer and an input link to one Oracle stage. I don't have a clue what this error message is t...