RE: Running SQL statement from CLP or CLLE

[David FOXWELL <David.FOXWELL@xxxxxxxxx>]

How about OPNQRYF followed by RCVF?
 

> -----Message d'origine-----
> De : rpg400-l-bounces@xxxxxxxxxxxx 
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] De la part de Bernd Dworrak
> Envoyé : vendredi 6 août 2010 14:02
> À : rpg400-l@xxxxxxxxxxxx
> Objet : WG: Running SQL statement from CLP or CLLE
>
>  
>
>  
>
> Von: Bernd Dworrak
> Gesendet: Freitag, 6. August 2010 07:24
> An: 'rpg400-l-bounces@xxxxxxxxxxxx'
> Betreff: Running SQL statement from CLP or CLLE
>
>  
>
> Hello,
>
> I'm not sure whether this is the right forum to ask the 
> following question but I try.
>
> I have a CLP in which I want to get information from a file.
>
> As the file is quite big I do not want to get the info from 
> it by RCVF command because it could take a lot of time to get 
> the information back.
>
> MYFILE1 is a keyed file with MYFIELD1,.2,.3,.4 as unique key.
>
> Of course I could call a RPG program from the CLP to get the 
> requested info returned by a parameter, but why not getting 
> it by a single "SELECT" statement?
>
> The point is, that I want to do it like this: "SELECT MYFIELDx FROM
> MYLIB/MYFILE1 WHERE MYFIELD1 = &PARM1 AND MYFIELD2 = &PARM2 
> AND MYFIELD3 = &PARM3 AND MYFIELD4 = &PARM4 ".
>
> I haven't found any info or examples yet. 
>
> Maybe one of you know how to do it best or has another brilliant idea.
>
> Thanx in advance
>
> Bernd
>
>  
>
> --
> This is the RPG programming on the IBM i / System i 
> (RPG400-L) mailing list To post a message email: 
> RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change 
> list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/rpg400-l.