Error during file comparision
Moderators: chulett, rschirm, roy
Error during file comparision
Hi,
I am trying to compare two files through the compare stage,i have imported the metadata of two files and set all the required properties.I have also checked for the metadata imported for the field "cnvrt_trd_crrnb_rt" and it is Decimal with length 15 and no scale,but when i try running the job i get the below quoted error.
BIOS_C069_OUTNA_OWNDELT_FILE: At field "cnvrt_trd_crrnb_rt": When validating import/export function: APT_GFIX_Decimal::validateParameters: Decimal "text" format is variable length and no external length is specified. Possibly you should specify an appropriate "width" property? External format: {text, padchar=32, nofix_zero, precision=15, scale=0, round=trunc_zero, ascii}
Can anyone help me out in knowing the possible reason for the above error.
Thx,
Rajee
I am trying to compare two files through the compare stage,i have imported the metadata of two files and set all the required properties.I have also checked for the metadata imported for the field "cnvrt_trd_crrnb_rt" and it is Decimal with length 15 and no scale,but when i try running the job i get the below quoted error.
BIOS_C069_OUTNA_OWNDELT_FILE: At field "cnvrt_trd_crrnb_rt": When validating import/export function: APT_GFIX_Decimal::validateParameters: Decimal "text" format is variable length and no external length is specified. Possibly you should specify an appropriate "width" property? External format: {text, padchar=32, nofix_zero, precision=15, scale=0, round=trunc_zero, ascii}
Can anyone help me out in knowing the possible reason for the above error.
Thx,
Rajee
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I dont find any attribute named "width" in either the sequential file stage or the compare stage.instead there is an attribute named "lenght" and that is assigned a value as 15.Can you let me know where you expect the "width" to be set.ray.wurlod wrote:It's all in the message - the Field Width property is not set. ...
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Go to the Columns grid. Right click on the appropriate row and choose Edit Row...
This should open a dialog in which the extended properties of the column you are editing are displayed, and you should find field width among them.
This should open a dialog in which the extended properties of the column you are editing are displayed, and you should find field width among them.
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.
Thanks ray,i got rid of the above error.But now I get the below info in the director and i have no clue about it.ray.wurlod wrote:Go to the Columns grid. Right click on the appropriate row and choose Edit Row...
This should open a dialog in which the extended properties of the column you are editing are displayed, and you sh ...
OUTNA_OWNDELT_FILE,0: Input buffer overrun at field "W8_S", at offset: 38..
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: