Re: Read only one record of a file with SQL

That would need to be embedded SQL in a program - it's not clear that that is 
the case here - could be in a QMQRY or in STRSQL or in RUNSQLSTM or iSeries 
Navigator or whatever, so no fetch available.

This reminds me that embedded SQL is probably the least used methodology for 
database access using SQL. Whadya think, y'all?

-------------- Original message -------------- 
From: Michael_Schutte@xxxxxxxxxxxx 

> By just performing the Fetch one time... 
> 
> Michael Schutte 
> 
> 
> 
> 
> Peter Vidal 
> > .com> To 
> Sent by: midrange-l@xxxxxxxxxxxx 
> midrange-l-bounce cc 
> s+michael_schutte 
> =bobevans.com@mid Subject 
> range.com Read only one record of a file with 
> SQL 
> 
> 05/03/2006 09:49 
> AM 
> 
> 
> Please respond to 
> Midrange Systems 
> Technical 
> Discussion 
> > nge.com> 
> 
> 
> 
> 
> 
> 
> 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. 
> 
> 
> 
> -- 
> 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. 
>