• Data queues in RPG

    Has somebody used a data queue in a RPG program.If so, what is the advantage of using a data queue. Can I have an example.

    A1b2c3330 pointsBadges:
  • CPF8361 Error after V6R1 Upgrade

    After upgrading from V5R4 to V6R1 we have begun to encounter CPF8361 errors related to Committment Control running embeded SQL.    Transactions get hung up in RDB and then processes get stuck.   Is this specifically related to the upgrade and is there a simple process to correct the issue. 

    Shadow4412265 pointsBadges:
  • Create a calender using RPG

    my requirement is to create a calender using rpg.first it show the present date calender,after user select month,year.then it show that month calender.please give example code

    madhuchowdary350 pointsBadges:
  • Reorganizing AS/400 Files While Active

    I work for a company which is a 24/7 company. I cannot get them tp give up the system for any length of time. As a result, any type of maintenance is almost impossible. My biggest problem is reorganizing our files. I have heard that you can do a reorg while active but you must have journaling...

    GHENDER190 pointsBadges:
  • AS400 – RPG

    What is the difference between *NAMVAR and *DTAARA in RPG Programming

    rajeshece1,215 pointsBadges:
  • SQL in CLP

    Hi, I have to create a command that permits a user to copy records from one file to another and then remove those records from the first file. We've been doing it all manually using CPYF and INCREL and then deleting the records using an SQL Delete statement. I got the idea to create a command and...

    Floyd02320 pointsBadges:
  • Finding source physical files

    Can you help this iSeries user? He wants to know how he can find only source physical files in any library (Ex: QDDSSRC, QCLSRC, etc.). Thanks! Michelle Davidson Editor Search400.com

    MichelleDavidson435 pointsBadges:
  • AS400 RPG – last three digits of microseconds always zero!

    We noticed in a couple of programs where we were using timestamps that the rightmost three positions are consistently zero and never otherwise. I have tested this with even just a simple ILE RPG program that dsplys a %char(%timestamp()); and still only get zeros for the last three digits....

    Koohiisan5,020 pointsBadges:
  • Calling runtime errors in AS/400

    Program A calls program B with invoice# ( 10S 0) as a parameter. Program B receives Invoice# as a incoming parameter ( Invoice# is a file field). But when program b is called i get a runtime error " PGMB 400 decimal-data error in field (C G S D F)" Help me to fix this error. Code goes as follows:...

    22917510 pointsBadges:
  • CL AS400 iSeries ILE Retrieve Source

    Is there any way to retrieve source for an ILE CL program? I'm looking for a function equivalent to the RTVCLSRC command we use for retrieving the source for a CLP ?

    RIRedCheryl0 pointsBadges:
  • Days of the week in AS/400 V5R4

    I know how to determine the day of the week a date falls on. However, I was wondering if there was an easy way to figure the following information: 02/01/10 was the 5th Monday of year 2010, 01/07/11 is the 1st Friday of 2011, etc.?

    GHENDER190 pointsBadges:
  • When using IfNull in my SQL, records are ignored

    I know my data table has nulls in it. If my select statement doesn't include those fields, I get hundreds of records. If I include those fields with an IfNull, it skips all but 4 records. Here's my testing snippet: C/Exec sql C+ DECLARE C1 CURSOR FOR C+ SELECT C+ accountID, C+ ifNull(address,' ')...

    Frydaze120 pointsBadges:
  • Stored Procedures called from RPG programs

    I created a stored procedure that returns a result set. I am using it in a PHP program and all works great. Pass in a account Id and returns all hits for valid records for that account. We have a excel report and subfile screen that runs off a green screen that needs to retreive this same data. My...

    nu40400 pointsBadges:
  • How to create menu using RPG program?

    how to create menu using rpg program

    1307845 pointsBadges:
  • Timestamp Data Type

    Hi I am writing an RPG400 program which is populating a file, this file has one field in it defined as a TIMESTAMP field of 26 long. How do i populate this field with RPG400, everything i have tried so far has failed. Thanks in advance for any help

    Hazermark0 pointsBadges:
  • Journal

    How can i retrieve a record from a journal so that i can update the said record to another physical file. Because i want to retrieve the record created or updated from the journal so that i can update the other file. Thank you.

    102219790 pointsBadges:
  • Using Encrpt Data API

    Has anyone been successful in using the encrypt data API QC3ENCDT (OPM) in RPG IV? When using algorithm description format name ALGD0200, I get error message CPF9DEE, Reserved field not null. "Reserved" is a one character field; and the sixth parameter on the format data structure. Documentation...

    Lamont0 pointsBadges:
  • Authorization problem on DDM file in RPG program

    I have a RPG program that accesses three DDM files on another iSeries. The program compiles, but I receive error CPF9822-Not authorized to file XXXX in library XXXX. Cannot open DDM file. I have *SECOFR rights on both machines. Can someone help me?

    Freckles0 pointsBadges:
  • Tom – Subfile post in April

    [small _extended="true" class="upper">POSTED:  Apr 21, 2010  8:02 AM (GMT)[/small] [!-- end summary --] [I _extended="true">SFLNXTCHG sets all records in the subfile to be marked as changed… SFLNXTCHG only sets the tag for the subfile records that are written when SFLNXTCHG is on. It only...

    NickHutcheson11,380 pointsBadges:
  • Impact Analysis – None Answered till now

    Hi all, I have a question and submitted long back. But till now i didn't get any reponse. Task: If there is any change in the length of a field or a new field added into the existing file, we need to do some Impact Analysis which is time consuming.So i thought of developing a utility for that....

    Kumari0 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