Re: Read only one record of a file with SQL

Yeah, I assumed the opposite direction, I guess. 

Birgitta mentioned the FETCH FIRST ROW ONLY, which is very cool - it first 
appeared at V5R1 and has a couple variants and 1 row is the default

FETCH FIRST ROWS ONLY

FETCH FIRST n ROW ONLY

FETCH FIRST n ROWS ONLY
-------------- Original message -------------- 
From: Michael_Schutte@xxxxxxxxxxxx 

> I thought the same thing, but there was no specification... so I just gave 
> the one that I can think of. LOL. 
> 
> I use DBU or WRKQRY 
> 
> Michael Schutte 
> 
> 
> 
> 
> vhamberg@comcast. 
> net 
> Sent by: To 
> midrange-l-bounce Midrange Systems Technical 
> s@xxxxxxxxxxxx Discussion 
> 
> cc 
> 05/03/2006 11:11 
> AM Subject 
> Re: Read only one record of a file 
> with SQL 
> Please respond to 
> Midrange Systems 
> Technical 
> Discussion 
> > nge.com> 
> 
> 
> 
> 
> 
> 
> 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. 
> > 
> -- 
> 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. 
>