Page 1 of 1

getting account number invalid format using icetool

PostPosted: Tue Feb 12, 2019 2:09 pm
by thotlma
Hi All

iam using below code to get the results in csv file but getting phone number invalid format
could you please help to get correct format for account number.remaing fields are getting correct format but issue with thie field


INREC FIELDS=(1,200)                              
OUTFIL FNAMES=FNLCSV,                            
             BUILD=(3,15,C',',19,3,C',',23,1,C',',
                    C'"',26,2,C'"',C',',          
                    30,30,C',',62,8,C',',        
                    72,8,C',',                    
                    C'"',80,15,C'"',C',',        
                    98,44,C',',                  
                    C'"',142,5,C'"',199:X)        
                                                 


output:

phone NUMBER
710020937
1.40402E+11
1.41442E+11
1.41942E+11
1.41942E+11
2.26921E+11
2.26923E+11
2.26923E+11
3.20872E+11
3.21047E+11
3.23422E+11

Re: getting account number invalid format using icetool

PostPosted: Tue Feb 12, 2019 2:24 pm
by Garry F Carroll
It would be helpful if you could provide a sample of the input dataset, the RECFM and LRECL. At which position in the input is the phone number? Is the output you show for one or more records?

Garry

Re: getting account number invalid format using icetool

PostPosted: Tue Feb 12, 2019 5:17 pm
by thotlma
Thanks Garry for responding this one
record length=200 and RECFM=FBA
please see the below example 1 record

00000712340837 ,FDA,2,"02",HELD FOR COLLECTION           ,02/07/19,02/111/19,"         800.00",REASONABLE CAUSE REGCC 1                    ,"03200"


Coded to maintain correct presentation of data. Do it yourself next time.

Re: getting account number invalid format using icetool

PostPosted: Tue Feb 12, 2019 5:35 pm
by enrico-sorichetti
it would have been wiser to post the records corresponding to the data in the initial post
so that the people answering might have been able to explain the different behaviour

Re: getting account number invalid format using icetool

PostPosted: Tue Feb 12, 2019 6:01 pm
by Garry F Carroll
I can't replicate your results. Can you show the job and the control cards you are submitting?

Garry