RE: Informix 4GL function
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------ =_NextPart_001_01BEFAEA.C50CC784
Content-Type: text/plain
Art is this available in dbaccess's SQL or in Informix Stored
Procedures. Would be very handy.
Uday
-----Original Message-----
From: Art S. Kagel [mailto:kagel@bloomberg.net]
Sent: Thursday, September 09, 1999 11:50 AM
To: informix-list@iiug.org
Subject: Re: Informix 4GL function
maronq@my-deja.com wrote:
>
> I am a newbie in INformix 4GL programming. I need a function which
> converts an ascii number to its relative CHAR. Also want to know how
to
> get the successor of a CHAR, such as returning 'B' if giving 'A'.
> Sorry for such simple questions.
> Thanks
DEFINE val INTEGER, new_char CHAR(1)
LET val = ORD( "A" )
LET new_char = ASCII (ORD( "A" ) + 1 )
Art S. Kagel
------ =_NextPart_001_01BEFAEA.C50CC784
Content-Type: text/html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.1960.3">
<TITLE>RE: Informix 4GL function</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Art is this available in dbaccess's SQL or in Informix Stored Procedures. Would be very handy.</FONT>
</P>
<P><FONT SIZE=2>Uday</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Art S. Kagel [<A HREF="mailto:kagel@bloomberg.net" TARGET="_blank">mailto:kagel@bloomberg.net</A>]</FONT>
<BR><FONT SIZE=2>Sent: Thursday, September 09, 1999 11:50 AM</FONT>
<BR><FONT SIZE=2>To: informix-list@iiug.org</FONT>
<BR><FONT SIZE=2>Subject: Re: Informix 4GL function</FONT>
</P>
<BR>
<P><FONT SIZE=2>maronq@my-deja.com wrote:</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> I am a newbie in INformix 4GL programming. I need a function which</FONT>
<BR><FONT SIZE=2>> converts an ascii number to its relative CHAR. Also want to know how to</FONT>
<BR><FONT SIZE=2>> get the successor of a CHAR, such as returning 'B' if giving 'A'.</FONT>
<BR><FONT SIZE=2>> Sorry for such simple questions.</FONT>
<BR><FONT SIZE=2>> Thanks</FONT>
</P>
<P><FONT SIZE=2>DEFINE val INTEGER, new_char CHAR(1)</FONT>
</P>
<P><FONT SIZE=2>LET val = ORD( "A" )</FONT>
<BR><FONT SIZE=2>LET new_char = ASCII (ORD( "A" ) + 1 )</FONT>
</P>
<P><FONT SIZE=2>Art S. Kagel</FONT>
</P>
</BODY>
</HTML>
------ =_NextPart_001_01BEFAEA.C50CC784--
"Marichamy, Udaykumar" wrote:
>
> Art is this available in dbaccess's SQL or in Informix Stored
> Procedures. Would be very handy.
These functions are 4GL library functions and not available to SQL or
SPL. Of course once IDS.2000 gets here one can always write a UDF to do
this and solve the problem.
Art S. Kagel
> Uday
>
> -----Original Message-----
> From: Art S. Kagel [mailto:kagel@bloomberg.net]
> Sent: Thursday, September 09, 1999 11:50 AM
> To: informix-list@iiug.org
> Subject: Re: Informix 4GL function
>
> maronq@my-deja.com wrote:
> >
> > I am a newbie in INformix 4GL programming. I need a function which
> > converts an ascii number to its relative CHAR. Also want to know how
> to
> > get the successor of a CHAR, such as returning 'B' if giving 'A'.
> > Sorry for such simple questions.
> > Thanks
>
> DEFINE val INTEGER, new_char CHAR(1)
>
> LET val = ORD( "A" )
> LET new_char = ASCII (ORD( "A" ) + 1 )
>
> Art S. Kagel
<HTML SNIPPED>