Hi Forum,
I'm using a virtual machine running Linux and my job is reading a
sequential file as bulk, one field defined as varchar (1000), and
parsing the fields with column import stage. The next stage is a
Transformer and finally write in a dataset.
The parsing convert the input field in 3 new fields, including the
original column (property Keep Import Column = Yes) and the transformer
complete the final structure (8 columns) with other functions
(string and numeric).
The final structure is:
OrderNum
RecType
Name
OrderDate
ProductID
Qty
RecordNum
RecIn
When i run the job is finished ok and i can view the dataset result
in the viewer, but when use the "Dataset Management" and shown the
schema, the fields are disordered
Name
OrderDate
ProductID
Qty
RecordNum
OrderNum
RecType
RecIn
this behavior is normal?? or there is an error in the dataset definition??
Dataset schema is disordered
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 133
- Joined: Wed Mar 05, 2003 4:19 pm
- Location: Lima - Peru. Sudamerica
- Contact:
Dataset schema is disordered
Saludos,
Miguel Seclén
Lima - Peru
Miguel Seclén
Lima - Peru
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's normal (optimized) and it's standard across most databases - you do not control the order in which the database server decides to store columns. Most, in my experience, try to put the fixed-length ones first and the variable-length ones later. In rare cases this can be tunable.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No explanation - DataStage does as it pleases with column order, for various reasons ostensibly related to optimization. The same thing can - and often does - occur with Peek stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.