Interesting warning error before modify stage!
Moderators: chulett, rschirm, roy
Interesting warning error before modify stage!
I have a job as follows:
DataSet -> Xfm1 -> Modify -> SequentialFile
I have 1 specification in the Modify stage as:
OutCol1:decimal[10]=decimal_from_string(InCol1)
The job runs fine other than a few warnings. I had questions about 2 specific
warnings:
1)Xfm1: When checking operator: Dropping component "OutCol1" because of a prior component with the same name.
2)Xfm1: When checking operator: When binding output schema variable "APT_TRoutput0Rec0": When binding output interface field "InCol1"
to field "OutCol1": Conversion from source type "string[12]" to result type "decimal[10,0]": Possible range limitation.
This doesn't make sense to me. My questions are:
1)On warning #1:
There is no column in either the input or output tab of the transformer named OutCol1.
2)On warning #2: Why would these warnings come from the transformer stage? There is no column in either the input or output tab of the transformer named OutCol1. This column is on the output tab of the modify stage. There is no conversion happening on the transformer. It is being used as a straight copy.
DataSet -> Xfm1 -> Modify -> SequentialFile
I have 1 specification in the Modify stage as:
OutCol1:decimal[10]=decimal_from_string(InCol1)
The job runs fine other than a few warnings. I had questions about 2 specific
warnings:
1)Xfm1: When checking operator: Dropping component "OutCol1" because of a prior component with the same name.
2)Xfm1: When checking operator: When binding output schema variable "APT_TRoutput0Rec0": When binding output interface field "InCol1"
to field "OutCol1": Conversion from source type "string[12]" to result type "decimal[10,0]": Possible range limitation.
This doesn't make sense to me. My questions are:
1)On warning #1:
There is no column in either the input or output tab of the transformer named OutCol1.
2)On warning #2: Why would these warnings come from the transformer stage? There is no column in either the input or output tab of the transformer named OutCol1. This column is on the output tab of the modify stage. There is no conversion happening on the transformer. It is being used as a straight copy.
I added the transformer because I didn't want to use a KEEP specification for so many columns. Anyway, I removed it and I also unchecked RCP. Now, I get the warning on the target sequential file stage:
SequentialFile: When checking operator: When binding input interface field "LoanNumber" to field "LoanNumber": Implicit conversion from source type "decimal[10,0]" to result type "int32": Possible range limitation.
SequentialFile: When checking operator: When binding input interface field "LoanNumber" to field "LoanNumber": Implicit conversion from source type "decimal[10,0]" to result type "int32": Possible range limitation.
Input data type is char(12) and output is integer(10). The specification I used is:
OutCol1:decimal[10]=decimal_from_string(InCol1)
A different question to everyone. To convert from string to integer, it seems like I have to do 2 modify stages, one to convert to decimal from string and another to convert to integer from decimal. Does anybody have any other way?
OutCol1:decimal[10]=decimal_from_string(InCol1)
A different question to everyone. To convert from string to integer, it seems like I have to do 2 modify stages, one to convert to decimal from string and another to convert to integer from decimal. Does anybody have any other way?
-
- 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:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: