• Can not able to declare character field with the length of 6000 in SQLRPGLE program.

    Hi, I am declaring a stand alone character field with the length of 6000 in my SQLRPGLE program, but when i debug the program to see the the values in this character field i could find only 1024 length is allocated for this field. Could anyone please help me urgently to declare a character field...

    Mohan K695 pointsBadges:
  • SQL Precompiled Failed

    In SQLRPG program, when a compile a program it is showing the error SQL Precompiled Failed. I have given the sql syntax correctly. but I cant able to find the error. What may be reason for it? Please clarify.   Jayashree V.

    VJayashree185 pointsBadges:
  • Sqlrpgle

    I have two pf are PF1 & PF2. PF1 has 100 records & PF2 has 90 records.how to i find the unmatched records ? PF1 Fields are typ1,typ2 Pf2 Fields are Typ3 ,typ2. plz guide me.....

    shyedajmal285 pointsBadges:
  • AS400 – SQLRPGLE

    Hi, We are moving Values to Database Fields using Embedded SQL Concept. In Embedded SQL, We can decide the Variable Names dynamically. Is it possible with Display File? why?

    rajeshece1,215 pointsBadges:
  • SQLCODE 30 on fetch SQLRPGLE

    Hello All,  I'm trying to execute a fetch into DS on a SQL statement and keep getting code 30: Number of host variables less than result values. The DS and SELECT statement both have the same number of values as far as I can see.  Here's the DS and select fields code: D ClaimRecDS      ds  ...

    Dcantwell470 pointsBadges:
  • Files-Sqlrpgle

    ******************************************************** C                   READ      OUTSRC               C                   EVAL      MBR  = mlname         C/EXEC...

    shyedajmal285 pointsBadges:
  • Improve performance for SQL query reading file having milions of recods (AS/400 – SQLRPGLE program)

    I am fetching only 14 records each time from a customer file(physical file)  having milions of records. This file has 46 fields. Fetch is done in the follwoing manner, but it takes longer time - SELECT * FROM  CUSTOMER A WHERE A.CLINM1 LIKE 'B%' AND (CLINM1 <> '' OR  CLIPR1 <> '')...

    AnjaliR65 pointsBadges:
  • Cursor

    Hi, I have posted my SQLRPGLE program, output is not showing down,what mistake i did in my program,please correct it, FMA01F     IF   E           K DISK    FMA01FTES  IF A E    K DISK   RENAME(RMA01F:REMA01F) PREFIX(P_)   D COMNO          ...

    22917510 pointsBadges:
  • sqlrpgle-6

    query to find n'th Highest salary in a file?

    shyedajmal285 pointsBadges:
  • Convert RPGLE to SQLRPGLE

    How do I convert RPGLE program to SQLRPGLE?

    Nutangujar895 pointsBadges:
  • Record Locking in SQLRPGLE

    Hi All I have a SQLILE pgm which updates files through SQL statements. How to get the user id/job number which is locking the PF record through the program... if any data structure supports, whats the position of it... -Varun

    Varun123190 pointsBadges:
  • Commitment control in SQLRPGLE

    Hi All As we know that using COMMIT keyword at file level, to acheive commitment control, however I would like to know how to acheive commitment control using SQLRPGLE with out defining the COMMIT.

    Kar425 pointsBadges:
  • Embedded SQL using SUM or some other method to total up qty and display 1 unique record

    I have an sqlrpgle pgm setup, I want to add another sql select statement. I have a file that contains barcode label data, where multiple records can be assigned to the same Master serial #. My sqlrpg pgm is display various sorts in a screen inquiry. I want to setup my select, to display one record...

    Dobie80 pointsBadges:
  • Single commitment control in RPGLE program

    I have a rpgle program that uses 3-4 sql statements to update and insert data in 3-4 tables . Now what i want is that when program runs successfully then only these changes in tables should reflect else roll back . So for this is there any way to provide a single commitment control for all queries?...

    munduuu435 pointsBadges:
  • Embedded SQL in RPGLE hdr, dtl fetch for subfile build

    I am trying to join a header and a detail file and select all fields into data structures defined as external(filename). D dswtchdr      E DS                  EXTNAME(wtchdr) D dswtcdet      E DS                  EXTNAME(wtcdet) C     $CreateCsr   ...

    NickHutcheson11,380 pointsBadges:
  • Embedded SQLRPGLE Books, guides, how to’s

    Does anyone know of some good SQL books for RPGLE other than the IBM manuals? I need to learn more to keep afloat!

    NickHutcheson11,380 pointsBadges:
  • Embedded SQL in rpg for subfile build SQLCOD

    My fetch next in sql is getting sqlcod = -000000181 and sqlstt = '22007'.  I looked this up.  It says invalid date or time. Pointing to date data types in the file I am trying to read. The records contain two date fields and two time fields. How can I get around this?   Thanks in advance. Nick

    NickHutcheson11,380 pointsBadges:
  • How to handle record lock using embedded SQL?

    I am using SQLRPGLE program,need to handle record lock in sql statement ..plz suggest?

    Samule400160 pointsBadges:
  • CPF5032 and SQL RPG

    How do I unlock the data file to avoid halt ? CL used to sort file and call an RPG that cleared a field (followed by further processing). When I switch to an SQLRPG to clear the field, I get CPF5032 in the next program. Yes, I tried the UNLOCK op code in the SQLRPG but same result. No halt using...

    aceofdelts1,930 pointsBadges:
  • SQLRPGLE Error in UPDATE Query

    Hello, I have a SQL Statement in SQLRPGLE which Updates a 3 fiels in a file with 30 fields. SQL Statement is as below. UPDATE TABLE1 SET TXDATE = :SYSDATE, TXTIME = :SYSTIME, SETFLAG = :w_Set, MSG = :w_ERR, Comment = ' ' WHERE ID = :W_ID This works fine on one iSeries server and throws...

    sim400305 pointsBadges:

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following