MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » February 1998

Re: SQL string conversion


  • Subject: Re: SQL string conversion
  • From: John Carr <74711.77@xxxxxxxxxxxxxx>
  • Date: Sun, 1 Feb 1998 10:02:42 -0500

fixed



RE:     Re:  SQL string conversion
<SNIP>
>A related, ugly problem: 
>Extracting a packed or signed value embedded in a large character field 
>by a HLL program using a data structure. Can get a character string 
>representing the number out, but with (too) many function calls, could be 
>possible with one. Then apply TO_NUMBER, and your vendor package with the 
>"interesting" database is fully queryable. Should it be this hard?

>MAP_PACKED and MAP_SIGNED functions sure would help here.

Hmm
Using an Relational Data Base language to handle Non-Relational Data 
Base stuff?  Hmm.  Fix the data base. Or use a HLL to handle that 
dirty work.  Stored Procedures?

Is  TO_NUMBER an ANSI standard function?  How many Platform specific
builtin neat things are being taught/used that can't be ported over
to other ANSI platforms?  
Just Curious

I bet we'll see ALOT of this type of thing
with JAVA (thanks M$).   The nice thing about standards is that there
are so many to chose from.


JPC
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@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
+---






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact