|
View previous topic :: View next topic
|
| Author |
Message |
noorkh
New User
Joined: 06 Mar 2006
Posts: 76
Location: Chennai
|
|
|
|
I have input file in which field has been defined with x(20) and the same
field has been defined as s9(9) comp in the loading table.
Can you please help me how to convert the alphanumeric field into integer?
Is there any way to load alphanumeric field into table as a binary field?
Thanks
Rajkumar |
|
| Back to top |
|
 |
ap_mainframes
Active User
Joined: 29 Dec 2005
Posts: 181
Location: Canada
|
|
|
|
I think it would be a lengthy process thru cobol.
Why not get it converted with a sort and then use it in your program???
( You can convert 'X' to ZD/PD using SFF)
Any corrections are welcome !!!
ap_mainframes |
|
| Back to top |
|
|
DavidatK
Active Member
Joined: 22 Nov 2005
Posts: 700
Location: Troy, Michigan USA
|
|
|
|
Rajkumar,
an you give us an example of what the alphanumeric data will look like and what the conversion value to integer will be?
Thanks,
Dave |
|
| Back to top |
|
|
noorkh
New User
Joined: 06 Mar 2006
Posts: 76
Location: Chennai
|
|
|
|
| DavidatK wrote: |
Rajkumar,
an you give us an example of what the alphanumeric data will look like and what the conversion value to integer will be?
Thanks,
Dave |
Hi Dave,
The alphanumeric will contain numeric(some time will begin with char)
eg:
34523
667900123
pol3002333
qte5003444
I would appreciate, if u could give me a good solution.
Thanks,
Rajkumar. |
|
| Back to top |
|
|
prasadvrk
Active User
Joined: 31 May 2006
Posts: 200
Location: Netherlands
|
|
|
|
| Do you want to load the data only if it contains numeric data or either way. You can not load the non numeric data into a column defined as integer. |
|
| Back to top |
|
|
|
|
