Re: Re[2]: Field value

[Rob Berendt <rob@xxxxxxxxx>]

I stand corrected.  I didn't understand what you were trying to 
do.  Your attempt at correction, and some others interpretation, 
enlightened me.

Probably the best way to do this is to use imbedded SQL in your 
RPGIV program.  Then you can construct your SQL statement on the 
fly and use the PREPARE and EXECUTE clause.
1)  Do you have SQL loaded on your 400?  STRSQL command will show 
you if you do.
2)  If you do and need some hints on the imbedding of SQL, 
statement construction, or whatever, drop a message.

Again my apologies to all because of my misinterpretation.  
Although I still think the pointer method was neat and will work 
in some situations.





Vini.Kolathur@msasaro.com on 04/13/2000 03:07:46 PM
Please respond to RPG400-L@midrange.com@Internet
To:     RPG400-L@midrange.com@Internet, boldt@ca.ibm.com@Internet
cc:      
Fax to: 
Subject:        Re[2]: Field value

     Hans,
        I have a file which holds a list of customers in one field  and 
     fields "names" in another field. These fields mean that they are 
     mandatory fields for that particular customer in the Master database. 
     This idea came just to make the validation routine more generic since 
     diff customers have diff conditions for a field being mandatory or 
     not. So if the validation routine finds any of these "fields" not 
     having a value in the master database then it triggers of a email and 
     so on. 
     
     Vini


______________________________ Reply Separator _________________________________
Subject: Re: Field value
Author:  boldt@ca.ibm.com at ARO-INTERNET
Date:    4/13/00 12:17 PM


     
     
Vini wrote:
>Hi ,
>Just wanted to make sure if this is possible in RPG/400 or ILE. Can
>i treat the value of a field as a field and do a comparison operation. 
>
>For eg: Field X= "STATUS" , this STATUS is the name of field using 
>this can i access the value of the field STATUS.
>I guess i am clear in my question .
     
No, you can't do that in ILE RPG.  And even in those 
programming languages where you can do that (such as 
Perl), it's not recommended.
     
What exactly are you trying to do?
     
Cheers!  Hans
     
Hans Boldt, ILE RPG Development, IBM Toronto Lab, boldt@ca.ibm.com
     
     
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com. 
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com 
+---
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---


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