• Cursor is returning previous values in SQLRPGLE

    I have an SQLRPGLE program which accepts the SQL statement as an input parameter to the program from an RPGLE program. (The SQL is entered by user .) My intention is to validate the SQL and make a prepare statement out of it, and then initiates a Fetch Next from C1 into a :wSTR. Check for the...

    RamvishakRamesh2,505 pointsBadges:
  • Validate SQL and display the output

    I have a screen where the user can enter an SQL script, I need to validate whether the SQL query is a valid one, if so then display the output on to the screen. I am planning to execute a SQL prepare statement out of the script entered and then use SQLCOD to determine whether it is valid or not....

    RamvishakRamesh2,505 pointsBadges:
  • Viewing stored procedure statements in AS/400

    Hi, I created many stored procedures using STRSQL. And I called those procedures using SQLRPGLE program. It worked but I need to view those statements. I don't know how to view stored procedure statements which was created using STRSQL. Can anybody help me?

    LakNar270 pointsBadges:
  • SQLRPGLE- Query Not fetching records in program

    Hi I have below query in my program , when i executed it interactively thro strsql , its fetching records but the same query is not fetching records when i execute it in my program. Please provide your valuable answers as soon as possible.. as i need it very urgently... As si mentioned it has...

    Hamsu95 pointsBadges:
  • Using cursor in SQLRPGLE

    Can i use single cursor for multiple SQL statements? ex:  declare c1 cursor for select * from ....... also declare c1 cursor for select * from xxx

    varad40 pointsBadges:
  • SQLRPGLE producing invalid output

    I've got an SQLRPGLE program used to determine, among other things, whether data in one file member does or does not exist - if data exists in the current version but not in the previous a record is written to a transaction file. Thing is, I'm getting multiple records being written even though the...

    Splat9,025 pointsBadges:
  • How to acheive FULL OUTER JOIN on three files in IN SQLRPGLE program.

    Hi, I have 3 seperate files called Duty, Freight and Brokerage and i need to process all the records from all the three files into one output file based on key values matching across all the files, if i dont find the match in anyother two files then i need to populate coresponding fields with...

    Mohan K695 pointsBadges:
  • SQLRPGLE Cursors and Recursion

    I'm trying to recursively call a PI in my SQLRPGLE program. Problem is, I get an SQLCODE error of -519 and I'm sure it has to do with cursors and the prepare statement in my PI. Here's the code: pprintPrograms    b      dprintPrograms    PI      d...

    Dcantwell475 pointsBadges:
  • how to write more than one sql statement under EXEC SQL in SQLRPGLE.

    Hi, Can anyone please help me to write more than one SQL statements under single EXEC SQL and END EXEC as below. Since i have 10 sql statements and wanted to include all those 10 statements under single block of EXEC SQL and END EXEC by using any seperator like below. C/EXEC SQL C+Insert into A...

    Mohan K695 pointsBadges:
  • 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  ...

    Dcantwell475 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          ...

    22917560 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:

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