RE: Logical File with Field being substringed as a Key

Agreed.  A sample should be provided where it converts 
character data into numeric.  Or at least mention this!  
Perhaps if we print out the part on the end on how to 
make the manual more readable and submit this suggestion 
then it might make a difference.  I've had people that 
said they've had good luck in the past getting positive 
responses from IBM.





dpanco43@ix.netcom.com on 03/27/2000 02:36:55 PM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      
Fax to: 
Subject:        RE: Logical File with Field being substringed as a Key

Rob,

Yes, that's cool.  I tell ya though, the sequel book that I have is terrible
at describing it's functions.  I read the section on Decimal and it is just
awful.  It really doesn't explain it very well.

Thanks.

Debbie

> -----Original Message-----
> From: owner-midrange-l@midrange.com
> [mailto:owner-midrange-l@midrange.com]On Behalf Of Rob Berendt
> Sent: Monday, March 27, 2000 10:32 AM
> To: MIDRANGE-L@midrange.com
> Subject: RE: Logical File with Field being substringed as a Key
>
>
> SELECT DATAFIELD, SUBSTR(DATAFIELD,1,2),
> DECIMAL(SUBSTR(DATAFIELD,1,2)), 5*DECIMAL(SUBSTR(DATAFIELD,1,2))
> FROM ROB/TESTSQL
>
> DATAFIELD                       SUBSTR              DECIMAL
> Numeric Expression
> 01ABC                             01                      1
>                 5
> ********  End of data  ********
>
>
> Cool?
>
> Sorry for trying to solve the wrong problem.
>
>
>
>
> dpanco43@ix.netcom.com on 03/27/2000 10:20:03 AM
> Please respond to MIDRANGE-L@midrange.com@Internet
> To:   MIDRANGE-L@midrange.com@Internet
> cc:
> Fax to:
> Subject:      RE: Logical File with Field being substringed as a Key
>
> Rob,
>
> It is my understanding that the digits function converts numeric data to
> character.  What I want is the opposite.  I want to take a 25 character
> alpha field and extract positions 8 & 9 that I know will always contain
> numeric data.  then I want to call those 2 positions a numeric
> field so that
> I can do calcs with it.  I don't see how your digits function will help me
> here.
>
> Debbie
>
> > -----Original Message-----
> > From: owner-midrange-l@midrange.com
> > [mailto:owner-midrange-l@midrange.com]On Behalf Of Rob Berendt
> > Sent: Friday, March 24, 2000 3:40 PM
> > To: MIDRANGE-L@midrange.com
> > Subject: Re: Logical File with Field being substringed as a Key
> >
> >
> > Look at it from the other way around.  Instead of trying to
> > move the fallen oak tree from your leg, dig out some dirt from
> > under your leg.
> >
> > In other words, make the other field string.  For example.
> > Select * from filea where substr(field1,1,3) =
> digits(OfSomeNumericField)
> >
> > digits converts into string.
> >
> >
> >
> >
> >
> > dpanco43@ix.netcom.com on 03/24/2000 03:14:33 PM
> > Please respond to MIDRANGE-L@midrange.com@Internet
> > To: MIDRANGE-L@midrange.com@Internet
> > cc:
> > Fax to:
> > Subject:    Re: Logical File with Field being substringed as a Key
> >
> > When using a logical files substring function, is there anyway
> to further
> > define that substringed portion as numeric.  We have a
> situation where we
> > sometimes want to pick some information out of a character field
> > and use it
> > as input into a sequel.  We then often want to do calculations on that
> > information.  If we could use the logical to redefine the alpha data as
> > numeric, that would help immensely.
> >
> > Debbie
> >
> > +---
> > | This is the Midrange System Mailing List!
> > | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> > | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to
> > MIDRANGE-L-UNSUB@midrange.com.
> > | Questions should be directed to the list owner/operator:
> > david@midrange.com
> > +---
> >
> >
> > +---
> > | This is the Midrange System Mailing List!
> > | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> > | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to
> > MIDRANGE-L-UNSUB@midrange.com.
> > | Questions should be directed to the list owner/operator:
> > david@midrange.com
> > +---
> >
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
>
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
>

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---