INT( AMOUNT ) ?
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Fawaz Ashraff
Sent: Thursday, March 04, 2004 2:43 PM
To: U2 Users Discussion List
Subject: RE: [UD] 8 Bite Integers
Hi David,
Thanks for the info. May be I didn't explain my
problem correctly. I have a Unidata numeric field
(Amount- 100.00 or -100.00) and I need to convert it
to a 8 Bite integer so that Informix will recognise
it.
Cheers
Fawaz
--- "Logan, David (SST - Adelaide)" <> wrote:
> Hi Fawaz,
>
> Is this what you are looking for?
>
> SEQ function
>
> Syntax
> SEQ (expression)
>
> Description
>
> Use the SEQ function to convert an ASCII character
> to its numeric string
> equivalent. Expression evaluates to the ASCII
> character to be converted.
> If expression
> evaluates to the null value, null is returned.
>
> The SEQ function is the inverse of the CHAR
> function.
>
> In NLS mode, use the UNISEQ function to return
> Unicode values in the
> range
> x0080 through x00F8.
>
> Using the SEQ function to convert a character
> outside its range results
> in a
> run-time message, and the return of an empty string.
>
> For more information about these ranges, see the
> UniVerse NLS Guide.
> PICK, IN2, and REALITY Flavors
>
> In PICK, IN2, and REALITY flavors SEQ(" ") is 255
> instead of 0. In IDEAL
> and
> INFORMATION flavor accounts, use the SEQ.255 option
> of the $OPTIONS
> statement to cause SEQ(" ") to be interpreted as
> 255.
>
> Example
> G="T"
> A=SEQ(G)
> PRINT A, A+1
> PRINT SEQ("G")
> 11-632 UniVerse BASIC
> /productinfo/alldoc/UNIVERSE10/basic/Ch11
> 1/9/02
>
> This is the program output:
> 84 85
> 71
>
> Regards
>
> David Logan
> Database Administrator
> HP Managed Services
> 139 Frome Street,
> Adelaide 5000
> Australia
>
> +61 8 8408 4273
> +61 417 268 665
>
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> On Behalf Of Fawaz Ashraff
> Sent: Friday, 5 March 2004 5:34 AM
> To: U2 Users Discussion List
> Subject: [UD] 8 Bite Integers
>
>
> Good Afternoon.
>
> We are moving part of our application to
> Informix(From
> Unidata). I need to convert some of the data Fields
> to
> 8 bite Integers through a UniBasic program and write
> it to a flat file. Having problem converting data to
> 8
> Bite Integers. Any suggestions would be highly
> appreciated.
>
> Cheers
>
> Fawaz
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Search - Find what you're looking for faster
> http://search.yahoo.com
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
__________________________________
Do you Yahoo!?
Yahoo! Search - Find what you're looking for faster
http://search.yahoo.com
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
Notice of Confidentiality: The information included and/or attached in this
electronic mail transmission may contain confidential or privileged
information and is intended for the addressee. Any unauthorized disclosure,
reproduction, distribution or the taking of action in reliance on the
contents of the information is prohibited. If you believe that you have
received the message in error, please notify the sender by reply
transmission and delete the message without copying or disclosing it.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
