Can you give me a sample for tFileOutputMSPositional

One Star

Can you give me a sample for tFileOutputMSPositional

Hello,
Please can you give me an example for using tFileOutputMSPositional?
I have input: mysql Tables, and one row for header with special informations.
and for output: i have a positional file.
Thanks.

One Star

Re:Can you give me a sample for tFileOutputMSPositional

It is important to fill in all columns defining the schemas, otherwise you get weird errors.

One Star

Re:Can you give me a sample for tFileOutputMSPositional

Thank you Furnica.

One Star

Re:Can you give me a sample for tFileOutputMSPositional

I have very similar case, I want to write positional multischema file.
I am using TOS 3.1.1 in Windows and Linux environment.
There is a problem:
Let say that we have:
- Orders with order_id
- Order_lines with order_line_id and the order_id (One order consists of several order_lines).
So there are two kinds of rows, order and order_line. There is relation by order_id between them.
I feed the tFileOutputMSPositional from the two DB tables, order and order_line into different schemas.
- Table order has one row (One order).
- Table order_line has four rows which refers by order_id to the one order in order table.
In the tFileOutputMSPositional:
1) When the child row has its own key defined as order_line_id and prent key as order_id, as it should be:
SHEMA-----PARENT ROW-----PARNET KEY COLUMN-----KEY COLUMN
order------ ------ ------ ------
order_line------ order------ order_id ----- order_line_id
- It produces only the parent row, the order, no order_lines at all.
2) When the child row has its key defined as order_id, as it should NOT be:
SHEMA-----PARENT ROW-----PARNET KEY COLUMN-----KEY COLUMN
order------ ------ ------ ------
order_line------ order------ order_id ----- order_id
- It produces the order row and four order_lines, BUT every line is the last order_line row in the order_line table,
not the all four different order_lines as expected.
No matter what I do, the tFileOutputMSPositional is only producing the last row multiple times
or no rows at all.
Do you have any more examples how to use the tFileOutputMSPositional or how
to produce multischema positional file?

One Star

Re:Can you give me a sample for tFileOutputMSPositional

Can any one give me sample scenario for tFileOutputMSPositional