• Activation Groups, RPGLE, and Open Files

    Hello Everyone, We have a couple question regarding activation groups, RPGLE, and Open files. In our H specs for RPGLE and SQLRPGLE programs, some of our programs use dftactgrp(*yes), some use dftactgrp(*no), and some use dftactgrp(*no) actgrp(*caller). What are the differences? And, should all of...

    Dcantwell470 pointsBadges:
  • SQLRPGLE: How to evaluate field value in where condition

    Dear RPG users, Can we evaluate field value in where condition? I am looking for help in below query: select * from File_name where Date_Field + 2 days = Today_Date Date_field = 8P 0 Today_date = 8P 0 What I am looking for is the records which have passed 2 days as per today's date.

    rpgprogrammer200365 pointsBadges:
  • Null dates coming in as 2001-01-01 SQLRPGLE

    Our SQL statement is literally trying to put '0001-01-01' into a field and it's still coming back as 2001-01-01... Any ideas?

    Dcantwell470 pointsBadges:
  • Error in Prepare statment in SQLRPGLE

    Hi Group, I'm having a problem with the prepare statement in SQLRPGLE. Here my code: Eval q_str = 'SELECT ' + 'EMPCDE, EMPDEP, CLSS, STRYER, ' + 'SUBSTR(CHAR(UPDTTM),1,10) AS ENTRY ' + 'FROM EMPMAS ' If vnum <> *BLANKS Eval q_str = %TRIM(q_str)+ ' WHERE ' + 'SRLNO = '+ vnum+' ' EndIf c/Exec...

    Sureyz2,420 pointsBadges:
  • SQLRPGLE program results nothing

    Hi,  I am new to SQLRPGLE. I have coded something, which finally shows nothing.Please have a look on my code & kindly help me to get the output. This is my program         *************** Beginning of data ************************************ 0001.00 HDEBUG(*YES)                  ...

    HABBIE820 pointsBadges:
  • SQLRPGLE Cursor not open error

    Hi, I have written some thing on SQLRPGLE. I am facing few issues.I request you to kindly look at the code & let me know the mistakes.Please forgive me ,If I made any blunders on this.   This is my file. 0001.00                 R EMP                             0002.00  ...

    HABBIE820 pointsBadges:
  • Learning SQLRPGLE in AS/400

    Hi, I am looking for something where I can learn SQLRPGLE & Stored procedures in AS/400. I tried with few few sites, but none of them are clear. Kindly let me know, where I can get some programming knowledge on SQLRPGLE procedures.

    HABBIE820 pointsBadges:
  • Records not writing into subfile in SQLRPGLE

    Hi Im trying to create a simple sqlrpgle subfile program.Its selecting the records file. but when i try to write the records in the subfile its giving session or device error occured error.Program flow ::Declare Cursor C1, and Query (will return one record)Open C1Whenever NOT FOUND goto Enddow...

    Sureyz2,420 pointsBadges:
  • iSeries stored procedure isn’t returning value when calling RPG program

    Our team currently has a stored procedure that calls an SQLRPGLE program. It's running great as we have verified the debugger and it sends the return value as expected. But the problem is what is returned when we're looking at cmd.Parameters["@ISMATCH"].Value = {} Here's our stored procedure:...

    ITKE346,220 pointsBadges:
  • Like in SQLRPGLE

    Hi, I am using the below query in SQLRPGLE Select count(data) into :cntrec from sample where data like '%' "+:tpnumber+" '%'. I am getting an error "Token "+:tpnmber+" was not valid" . The tpnumber is a character field(10a). Sample file is a flat file I even tried '%' +:tpnumber+" '%' and '%'...

    Prashanth123255 pointsBadges:
  • Base compiler program in SQLRPGLE

    I'm writing a compiler program in SQLRPGLE that will be used in a lot of programs that will run throughout my system. Obviously, I want to get it right so that I don't have a bunch of problems down the road, and right now it doesn't work.  Could you take a look at what I'm trying to do and suggest...

    ITKE346,220 pointsBadges:
  • Source size limit in SQLRPGLE

    I've been having some problems compiling a 25,000 line program and I'm figuring that a line limit is causing all of my errors. Is there a limit to what the SQL pre-complier can handle for a SQLRPGLE source object?

    ITKE346,220 pointsBadges:
  • SQL Syntax issue via Free-Form RPGLE

    I'm having difficulty with a select statement.  As below, it works .  If I remove the '//' comment-out tags, it doesn't, so obviously there's an issue with those statements.  I'm trying to populate an output 3-char field with either Yes, No, or N/A.  The Y/N comes from the contents of a field...

    Eric Witham690 pointsBadges:
  • Joining More Than 2 Files

    What is the best way to join more than 2 files using SQLRPGLE with embedded sql?

    TJSDAD35 pointsBadges:
  • Error in AS/400 code?

    Fstdt if e disk Dnam s 10a Ddept s 3a C/exec sql C+ SELECT NAME, BRANCH INTO :nam, :dept FROM stdt WHERE STDID < 10 C+ C/end-exec C seton lr Hai all ..! I have this code .. But i'm not getting the output.. how can i get the result?

    Sureyz2,420 pointsBadges:
  • Delete all records from file using SQLRPGLE

    How to delete all the records from file(bpro1) using sqlrpgle?

    Minuvinu35 pointsBadges:
  • Variable not found when calling a SQLRPGLE program

    Variable not found when calling a SQLRPGLE program with parameters in CL program CALL PGM(LIBXYZ/TESTRPG1) PARM(&LIBNAM &FILNAM) here LIBNAM AD FILNAM are passed with VALUES to the SQLRPGLE program and at sql statemet ie. insert INTO LIB/FILl( LIB is having the value and FILL is not getting...

    ravula700 pointsBadges:
  • Problem with updating status of PF1 in SQLRPGLE

    Please help. I am trying to execute the below code but the update doesn't seems to be happening. DDATS E DS EXTNAME(PF1) C/EXEC SQL C+ DECLARE TESTC CURSOR FOR SELECT * FROM PF1 ORDER BY NUMBER C+ FOR UPDATE OF STATUS C/END-EXEC *OPEN the CURSOR C/EXEC SQL C+ OPEN TESTC C/END-EXEC C/EXEC SQL C+...

    juslikdat1440 pointsBadges:
  • What is the difference between using RPGLE and SQLRPGLE when updating a file?

    What is the difference in updating a file using RPGLE or SQLRPGLE?

    mcasantoshrai55 pointsBadges:
  • How to write multiple SQLRPGLE records into a printer file

    C/EXEC SQL C+ SELECT DISTINCT(CTP),COUNT(*) INTO :$Ctp,:#Ctotl FROM CUSTPF C+ GROUP BY CTP C/END-EXEC CTP is CustomerType in Customer File. Here actually I am getting 3 records as output. But I don't know how to write those 3 records into a printer file. Can anybody explain me how to write the...

    Sasikumarr195 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