Reading COMP-3 fields with Sequential file stage

emblem_user · Post by **emblem_user** » Tue Aug 28, 2012 3:32 pm

Hi,

I am reading MF file using Seq File stage and the file does have comp-3 fields. I have 4 regions files that I need to process with same code. For one region job works fine but fails for other with error below:
so was wondering if I can use Seq File Stage to read data in COMP-3 fields or If I am converting anything wrong.

Please let me know.
Thanks.

Error:
APT_CombinedOperatorController,1: APT_Decimal::ErrorBase: From: the source decimal has even precision, but non-zero in the leading nybble, or is too large for the destination decimal..Record sent to reject dataset.

ray.wurlod · Post by **ray.wurlod** » Tue Aug 28, 2012 5:22 pm

Did you Search DSXchange? I'm pretty certain this exact question has been answered more than once in the past.

emblem_user · Post by **emblem_user** » Wed Aug 29, 2012 4:13 pm

I read some posts and did not find what can be the issue for my job.

Below is what I think is causing the issue:
15 I_PCT COMP-3 PIC 9(3)V9(6).
15 I_PCT_C REDEFINES
I_PCT COMP-3 PIC 9(1)V9(8).
15 I_PCT_A REDEFINES
I_PCT_C PIC X(5).

Till now I handled Numeric columns redefined as Char columns and Vice Versa.
Can you tell me how can I use Sequential File stage to read the coumns that are redefined as above? the only reason trying to use Seq stage is its performance is much better than CFF stage.

Thanks in advance.

ArndW · Post by **ArndW** » Thu Aug 30, 2012 2:28 am

Can you use a server job for this? If so, there are server routines to perform COBOL type conversions which you can use.