Re: Read only one record of a file with SQL

This assumes a unique key, it seems - one can't make that assumption safely.

-------------- Original message -------------- 
From: "Raul A. Jager W." <raul@xxxxxxxxxx> 

> SELECT db_field1, db_field2 ... from lib/table where key = search_fiield 
> into :pgm_field1, :pgm_field2... 
> 
> >Hi list, 
> > 
> >How can is do that? 
> > 
> > 
> >Peter Vidal 
> >PALL Corporation / SR Programmer Analyst, IT Development Group 
> >10540 Ridge Rd., Ste 203, New Port Richey, FL 34654-5111 
> >http://www.pall.com 
> > 
> >"At any rate, I am convinced that He [God] does not play dice." 
> >Albert Einstein (1879-1955), In a letter to Max Born, 1926 
> > 
> > 
> 
> 
> -- 
> 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. 
>