1
  • 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?

    DJA65 pointsBadges:
  • READE & SETLL

    File: exam .................. No . name .................. 2 chow 2 siva 3 mical 4 swami 4 radha 2 lord .................. I need only equal records: 2-chow,2-siva,2-lord but I got the wrong output:2-chow, 2-siva,2-lord, 2-lord. it's reading the last rec 2 times. Please correct the below code. And...

    chowas400620 pointsBadges:
  • 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 SFNLXTCHG?

    6r1,765 pointsBadges:
  • Repositioning a Physical File

    Hi all, I have a physical file with no key defined. I want it to re-position the pointer to the top of file. Should I Open and Close the file each time, as SETLL works only on keyed files. Thanks

    hunshabbir72,805 pointsBadges:
  • Physical File Without Key

    Hi guys, Currently i'm using RPGLE language. If i have a Physical File that without key, How am i going to set my pointer. I can't CHAIN,SETLL and SETGT as well. In order to use them, u need have a key. Am i rite? Is there any idea to solve this matter? Thanks!!!!

    SoulReaper20 pointsBadges:
  • SETLL & DOU

    When I use SETLL and DOU , the loop is being executed only once. I am not able to process the next records. My actual code is @Key Setll File1 DoU %EoF Read File1 If ......... EndIf Enddo After reading 1st record it is coming out of loop. Please anyone help me.

    NAN4AS400105 pointsBadges:
  • Search argument for SETLL

    Hi! I have LF files to order addresses by: - name, city, state - city, name, state - e-mail, name, city, state. Search is made by typing some characters for name/city/e-mail. As LF-keys have different lengths, I indicate as search argument for the SETLL op-code a field whose length equals the one...

    argasoft100 pointsBadges:
  • What is the difference beween %found and %equal?

    What is the difference between %found and %equal? With SETLL we can use both %found and %equal but with CHAIN we can use only %found. It will be good if someone can please clarify this.

    ankit2002770 pointsBadges:
  • Use SETLL to read set of records

    Hi I have a set of records whose key has duplicates. Can SETLL be used to read these set of records? I need this to be done as part of a loop.

    Flint20 pointsBadges:
  • Equivalent commands to SETLL

    Hi, I'm venkat. I've got a small question.Can anybody clarify this question please? Are there any equivalent commands to SETLL*LOVAL in CL?

    itanswers0 pointsBadges:
  • SETLL

    Hi, I want to read a physical file sequentially. The physical file has no key. I use SETLL and READ. *LOVAL is not allowed when I use SETLL (because no key in the pf?) so I set a 1 in factor 1. 1 SETLL READ 90 *IN90 IFEQ *ON ... Is this ok? When I have a key in the file could I then use the...

    withcareandsoon5 pointsBadges:
  • READE – RPGLE

    When doing a.. SETLL (parm1:parm2:parm3) READE (parm1:parm2:parm3) IF %FOUND OCCASIONALLY IT COMES BACK AS FOUND WHEN THE RECORD IS CLEARLY NOT IN THE FILE. ANY IDEAS? THIS IS THE STRANGEST THING.

    Bix25 pointsBadges:
  • SETLL and READ

    Hi, I have the following problem: I need to make SETLL and READE for several LF based on 1 PF by selection. Is it any smart way to do it without to duplicate the READE and %eof() for each LF? Thank you.

    YuVa471,300 pointsBadges:
  • SETGT and SETLL

    I have tried using SETLL and SETGT command to read a record which is not present in file FILEA eg: A B D E Suppose in my program I have given the value C to read the file FILEA using command: C SETGT FILEA C READE FILEA and C SETLL FILEA C READE FILEA But the values retrieved are NULL. Can any1...

    Sangay635 pointsBadges:
  • Read opcode

    Hi Can i use the record format in place of a file name for all types of READs available in RPG/400 along with SETLL n SETGT?

    ten20081,150 pointsBadges:
  • Setting lower limits In CL

    I know how to declare a file and read through the data in CL....but how can you reset it? Like setll in CL. I have searched and searched but nothing works. I have closed opend...etc.. Any ideas? Example: PGM DCLF FILEA Loop: RCVF FILEA If %EOF ne '0' DO Goto Loop: Enddo. Now I want to read through...

    RonKoontz1,780 pointsBadges:
  • How to access all records in RPGILE

    hi all, suppose i have a report with input criteria 'machine code' and requirement it that if i input a perticular 'machine code' then it should COME only that , otherwise all records of all 'machine codes' should come , in clp i use %WLDCRD for that. but i need to do it in rpgile , is there any...

    Ambrish 82310 pointsBadges:
  • 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...

    Klw50 pointsBadges:
  • SETLL and SETGT

    hi, Can any1 tell me the most and simple difference between SETLL and SETGT.

    Sidd30 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following