• Stop AS/400 job purge program

    I have a requirement where i have to submit a PGM in batch. This program is a SQLRPGLE program that deletes record from a file. I have scheduled it at 8pm and I want to stop its purging at 10pm. This means this job will run for 2 hours every day after which it should be stopped. How can I achieve...

    Supriyoas400165 pointsBadges:
  • Inserting records from 1 to 99 in a file

    Hi, How to insert records in a file of 2 field lets say field1 and field2 field1 is constant like 'Name' and field 2 needs to be increased by 1 up to 99. How to write SQLRPGLE program for this?

    6r1,590 pointsBadges:
  • 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,475 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)                  ...

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

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

    HABBIE845 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,475 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:...

    ITKE351,290 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...

    ITKE351,290 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?

    ITKE351,290 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,475 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:

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