Re: Sql help

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Add to the WHERE clause of the detail SQL something like

d.model = :xmodel and d.id = :xid

where xmodel and xid are the program variables that were populated 
when you ran the header select. The colon (":") indicates a host 
variable, a program variable whose value is inserted into the SQL 
statement. And you don't need to worry about doubling up apostrophes 
(single quotes).

HTH
Vern

At 06:03 AM 11/10/2005, you wrote:

> Hi group, I need a little help in sql coding.
>
> I have two files, and Header (H) and Details (D) with join fields Model and
> Id.
>
> Since the users can browse them indipendently I devoleped programs to:
>
> - input/validate parameters
> - paramter parser to sql select
> - reader program to feed pages to front end presentation
> - front end programs
>
> on both the files.
>
> Now I would like to add to the detail selections the headers selections.
>
> The parameters parser will produce:
>
> Detail: select * from d where item = 'XX'....
>
> Header: select * from h where customer = 'YY'...
>
> How can code to make detail include only the records present in header
> select without writing a new parser (a change in the detail is a must but
> not a copy of header paraser)?
>
> Has to be SQLRPGLE and without temp files.
>
> Thanks fro your help
> Marco
>
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.