getting account number invalid format using icetool



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

getting account number invalid format using icetool

Postby thotlma » Tue Feb 12, 2019 2:09 pm

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
thotlma
 
Posts: 25
Joined: Tue Sep 18, 2018 8:05 pm
Has thanked: 0 time
Been thanked: 0 time

Re: getting account number invalid format using icetool

 

Re: getting account number invalid format using icetool

Postby Garry F Carroll » Tue Feb 12, 2019 2:24 pm

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
Garry F Carroll
 
Posts: 26
Joined: Wed Sep 19, 2018 8:20 pm
Has thanked: 0 time
Been thanked: 0 time

Re: getting account number invalid format using icetool

Postby thotlma » Tue Feb 12, 2019 5:17 pm

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.
thotlma
 
Posts: 25
Joined: Tue Sep 18, 2018 8:05 pm
Has thanked: 0 time
Been thanked: 0 time

Re: getting account number invalid format using icetool

Postby enrico-sorichetti » Tue Feb 12, 2019 5:35 pm

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
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2927
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 154 times

Re: getting account number invalid format using icetool

Postby Garry F Carroll » Tue Feb 12, 2019 6:01 pm

I can't replicate your results. Can you show the job and the control cards you are submitting?

Garry
Garry F Carroll
 
Posts: 26
Joined: Wed Sep 19, 2018 8:20 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post