I am trying to redefine the columns in the target complex flat file stage but it is giving me the below error.
Error when checking operator: At field "XXXXX": "redefines" property cannot appear in an export schema
I am trying to write a value in comp-3 field. incase, if it is default I would want to pass character in the same file. Hence, I would want to redefine the COMP-3 filed with the field with varchar field. Seems like this is not the way to do it. Please help me find the right way to do it. I have tried searching and couldnt really find anything relevant to this.
You can't do any kind of true "redefines" as you've found. What kind of character value are you needing to pass, and what do you mean by "default" in this context?
-craig
"You can never have too many knives" -- Logan Nine Fingers
Thanks for the reply. I almost thought it went unanswered.
Well, all I need to do is write the data in the target file in COMP-3 format. incase, if the field has a null value then I would want to write in a character format(tried redefining, didnt work )
You need to ask what is expected there when there is no value for that field. For COBOL and COMP-3 they may just want "low values", in any case there's no need to redefine anything.
-craig
"You can never have too many knives" -- Logan Nine Fingers
yes, thats right. they just need the low values but the issue is for null in comp-3 it would write zero's with a sign bit(like C, F or D) which they dont want. at times whenever it is null they want just zeros without the sign bit(so that they would be able to distinguish between the actual zeros and the null values).
So, part of the same issue you posted last month? Perhaps this might help. That or an exact search for "low values" to see if any previous conversation on the topic sheds some light on it.
-craig
"You can never have too many knives" -- Logan Nine Fingers