Re: SQL string conversion

[Mark Lazarus <mlazarus@xxxxxxxx>]

Simon,

At 12:57 AM 2/2/98 +1100, you wrote:

>>  What I wanted to do is something like this:  SELECT * WHERE VAL( SUBST(
>> DATA, 15, 7 ) ) > 100.  Or assign it to a numeric field an on update.  I
>> realize that there is no VAL function.  Is there an equivalent function or
>> workaround?

>I don't believe SQL/400 supports TO_NUMBER although some other SQL
dialects do.  You can however 
>accomplish the task with OPNQRYF using the MAPFLD keyword:

>       MAPFLD((NEWFLD '%sst(DATA 15 7)' *ZONED 7))
>
>Then you can use the mapped field in the selection clause:
>
>       QRYSLT('*MAPFLD/NEWFLD > 100')
>
>Once the ODP has been built you can move NEWFLD to the target database
field or host variable and 
>perform the update.  The update can be performed with native I/O or SQL/400.
>Isn't it great! 

 Yes it is!  I didn't know you can use an OPNQRYF ODP w/ SQL/400.  Thanks!

 -mark 

+---
| 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
+---