Warning issue with CFF
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 40
- Joined: Tue Oct 14, 2008 3:30 pm
- Location: London
Warning issue with CFF
I have created a job to read ebcdic binary file and convert it to ascii unpacked file. My design of the job as follows
CFF --> Transformer --> Sequential file stage
CFF is reading ebcdic file and is converting it to ascii unpacked file. Job is running fine , but i am getting the following warning message
Complex_Flat_File_Stg: When checking operator: On output data set 0: When binding output interface field "REC_DATE" to field "REC_DATE": Implicit conversion from source type "decimal[8,0]"to result type "string".
How can i overcome this warning message? I tried using type conversion function in transformer, but nothing worked
Thanking you in advance
CFF --> Transformer --> Sequential file stage
CFF is reading ebcdic file and is converting it to ascii unpacked file. Job is running fine , but i am getting the following warning message
Complex_Flat_File_Stg: When checking operator: On output data set 0: When binding output interface field "REC_DATE" to field "REC_DATE": Implicit conversion from source type "decimal[8,0]"to result type "string".
How can i overcome this warning message? I tried using type conversion function in transformer, but nothing worked
Thanking you in advance
What is the COBOL copybook definition for that column?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 40
- Joined: Tue Oct 14, 2008 3:30 pm
- Location: London
-
- Premium Member
- Posts: 40
- Joined: Tue Oct 14, 2008 3:30 pm
- Location: London
-
- Premium Member
- Posts: 40
- Joined: Tue Oct 14, 2008 3:30 pm
- Location: London
And your output is declared as Char(8) or Varchar(8), right? You can demote the warning mesage to informational, or declare the column as decimal or integer and in a later change convert from numeric to string.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 40
- Joined: Tue Oct 14, 2008 3:30 pm
- Location: London
Thanks Craig, i will do that.
Thanks Arnd for your reply. My output is declared as date. Also how can i demote the warning message to informational.
In my job using CFF i have imported cobol def. CFF in turn has done the implicit conversion of col (PIC S9(8) COMP-3) decimal to date and i have mapped the output to Seq file which is a ascii unpacked file.
I am using CFF for the first time, so not sure whether i have missed out on anything.
Thanks Arnd for your reply. My output is declared as date. Also how can i demote the warning message to informational.
In my job using CFF i have imported cobol def. CFF in turn has done the implicit conversion of col (PIC S9(8) COMP-3) decimal to date and i have mapped the output to Seq file which is a ascii unpacked file.
I am using CFF for the first time, so not sure whether i have missed out on anything.
Re: Warning issue with CFF
Are you certain that it is declared as "date"? DataStage cannot convert a number to date implicitly. There are job and project level handlers you can define. Right-Mouse click on the warning message in question the director, then choose ""add rule to message handler".senthil_tcs wrote:I...When binding output interface field "REC_DATE" to field "REC_DATE": Implicit conversion from source type "decimal[8,0]"to result type "string".
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 40
- Joined: Tue Oct 14, 2008 3:30 pm
- Location: London