SQL Subfile and position to ability
I have a subfile that can be sorted by any of 4 fields, so I want to use imbedded SQL to read the data out of my PF in order to populate the subfile.I want to be able to allow the user to enter position to information, and position to that entry - normally, I would do a SETLL to the file based on...
View Answer
| Aug 14 2008 7:03 PM GMT
| asked by
Klw
Subfile, SQL Subfile, SELECT
SETLL
Hi, Im venkat.Ive small question.Can any body clarify this question please? is there any equelent commands to SETLL*LOVAL in cl?
View Answer
| Aug 1 2008 1:05 PM GMT
| asked by
Ibmi5
RPG/400, SETLL
updating pf using simple rpg/400 code.
How can i update a pf using simple rpg code.and please also explain with examples use of setll, chain, setgt, Readc and sflnxtchg?
View Answer
| May 27 2008 4:37 AM GMT
| asked by
6r
PF/LF, EXCPT, CHAIN
SETGT and SETLL
I have tried using SETLL and SETGT command to read a record which is not present in file FILEA eg:ABDESuppose in my program I have given the value C to read the file FILEA using command:C SETGT FILEAC READE FILEAand C SETLL FILEAC READE FILEABut the values retrieved are NULL.Can any1 explain me why...
View Answer
| Feb 25 2008 12:18 AM GMT
| asked by
Sangay
AS/400, SETGT, SETLL
SETLL and SETGT
hi,Can any1 tell me the most and simple difference between SETLL and SETGT.
View Answer
| Feb 22 2008 7:34 PM GMT
| asked by
Sidd
AS/400, SETGT, SETLL
SETLL vs. LOOKUP
Fact based opinions requested. Is it faster to perform a SETLL on a file to do an existence test or read the file (note: it has a very small number of records) into a program array during *INZSR and then do a LOOKUP to do the existence test?
View Answer
| Dec 13 2007 4:51 PM GMT
| asked by
DJA
iSeries applications, LOOKUP/XFOOT/MOVEA operations, *INZSR
