IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

conversion from Alphanumeric to Numeric type


IBM Mainframe Forums -> CA Products
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
PRV

New User


Joined: 16 Apr 2009
Posts: 15
Location: Pune

PostPosted: Fri Jun 26, 2009 12:42 pm
Reply with quote

I have one task which needs the conversion of alphanumeric field into numeric .
Can we convert alphanumeric field into numeric type field ?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Fri Jun 26, 2009 1:24 pm
Reply with quote

a) What product are you using#
b) What happened when you tried it
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Fri Jun 26, 2009 1:29 pm
Reply with quote

if a field has been defined as alphanumeric ,
and the content is alphanumeric
Your approach will just lead to trouble,
whatever language, database, dataset organization, operating system, user program, utility, ..., ..., ...
You would be using
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Jun 26, 2009 7:20 pm
Reply with quote

Hello,

Quote:
Can we convert alphanumeric field into numeric type field
Only if the alphanumeric field will always contain only a valid numeric value. Anything other than a valid numeric will most likely cause an abend at some point (unless the data is programmatically validated before conversion/use).
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CA Products

 


Similar Topics
Topic Forum Replies
No new posts 10 byte RBA conversion DB2 2
No new posts 10 byte RBA conversion -non applicati... JCL & VSAM 1
No new posts file manager is doing string conversion IBM Tools 3
No new posts SMF record type 30 JCL & VSAM 8
No new posts Convert HEX to Numeric DB2 3
Search our Forums:

Back to Top