Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
conversion from Alphanumeric to Numeric type

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
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    Post subject: conversion from Alphanumeric to Numeric type
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: 8593
Location: Back in jolly old England

PostPosted: Fri Jun 26, 2009 1:24 pm    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10308
Location: italy

PostPosted: Fri Jun 26, 2009 1:29 pm    Post subject: Reply to: conversion from Alphanumeric to Numeric type
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

Site Director


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

PostPosted: Fri Jun 26, 2009 7:20 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Setting Font Type for XMIT satish.ms10 All Other Mainframe Topics 3 Fri Sep 15, 2017 10:01 pm
No new posts Remove leading spaces from numeric field rexx77 SYNCSORT 6 Wed Sep 06, 2017 2:15 am
No new posts Return a Non Numeric value from REXX Learncoholic CLIST & REXX 3 Fri Sep 01, 2017 8:33 pm
No new posts Select numeric portion from CHAR data... balaji81_k DB2 6 Sat Aug 19, 2017 1:51 am
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us