• Character in Cast argument not valid

    I need to retrieve the RRN and use it within my RPGLE program. I have the Select RRN(file) statement, but I get a Character in Cast argument not valid when executing. Any suggestions?

    trishahles10 pointsBadges:
  • How to write SQLRPGLE query with many select criteria

    I have a report to print using SQLRPGLE. The Report criteria screen has around 15-20 select conditions. Based on the conditions entered by the user, I build a query of type: Select * from emp1 where val1 = ? and val2 =? and val3 = ? and........... This is the first time I'm dealing with so many...

    Nutangujar895 pointsBadges:
  • Fetching multiple rows in SQLRPGLE

    Hi, When I try to fetch more records, I couldn't do it. Please see my code below and explain. Thanks.

    as400dev480 pointsBadges:
  • Cursor in SQLRPGLE

    Hi friends, Please explain the difference between the Scrollable, Non-scrollable and Dynamic scrollable cursors in SQLRPGLE with simple example. Thanks in advance.

    shyedajmal285 pointsBadges:
  • Why cursors are less efficient than RPGLE?

    I had created two programs for reading a PF and writing into another PF. 1) In RPGLE -- Runs very faster 2) IN SQLRPGLE using cursor -- Takes more time.. Why this CURSOR is slow? Both are AS/400 utilities right?

    dinuas400510 pointsBadges:
  • SQL logging

    How do we prevent our SQLRPGLE programs from creating so many job log records when executing?

    COOPERL10 pointsBadges:
  • SQLCOD 30 error

    I have a Fetch statement like this Exec Sql Fetch FileCursor into :FileDS. I am gettting SQLCOD as 30 and JOBLOG says Number of host variables less than result values. Declaration of FileDS is D FileDS E DS EXTNAME(FileNAme) Can anyone tell me the reason for this?

    RamvishakRamesh2,505 pointsBadges:
  • Dynamic operator on WHERE statement

    I have a file that has 2-fields that will be used to select records from file B. File A, field 1 = date_a & field 2 = Operator. I want to select records from File B and based on the value within the operator ( EQ, LT, LE, GT, GE) and the date_a. Ex: If in File A, the value of the field Operator...

    ibBusy4sure50 pointsBadges:
  • SQLRPGLE program executing at log off

    I wrote a simple SQLRPGLE program. It accepts a "from" and "to" code, deletes all records with the "to" code, then copies all "from" records, replacing the "from" code with the "to" code. It runs fine, produces expected results. When I log off the session which ran the program, even hours later, it...

    LynnPorgy20 pointsBadges:
  • RPG – Roll your own level breaks

    Has anyone every heard of 'Roll your own Level Breaks' in RPG? Can you enlighten me on how it works? I have to mimic a program that does this already with a different set of data. Here is a basic overview of the application. A selection screen allows you to select a date range, region, territory,...

    NickHutcheson11,380 pointsBadges:
  • Delete 72 hours old record from a file using SQLRPGLE

    I have a file containing two fields...First one contains date with century and second one contains time in time stamp format. I want to delete 72 hours old record from this file using SQLRPGLE.

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

    Splat7,235 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...

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

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