I have flat file (sequential file), having one column containing date values in AIX unix environment.
Since its format is fixed as dd-mm-yyyy, I can suitably define char(10) data type for it. When I go for View data for that stage, it is displaying data properly.
If I try to load the same data in DataSet through transformer in between, the job is not working. DataSet also has data type as char(10).
If I change this Data Type to Varchar, all works as expected. Is there any restriction in using char datatype with datasets?
Char data type compatibility with DataSets.
Moderators: chulett, rschirm, roy
Char data type compatibility with DataSets.
Thanks with regards,
videsh.
videsh.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Char(10) (called string[10] in the record schema) is fully supported in Data Sets. But you must provide exactly 10 characters to store in one.
We need to know the precise error message if we are to help you to resolve your issue.
We need to know the precise error message if we are to help you to resolve your issue.
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:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Your two VarChar fields are unbounded (they have no maximum length). Is this deliberate?
Also, what you posted is not the record schema (which you can find from the generated OSH).
Please post the exact text of any error message you have received from this job. Otherwise we're guessing.
Also, what you posted is not the record schema (which you can find from the generated OSH).
Please post the exact text of any error message you have received from this job. Otherwise we're guessing.
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.