• Page at a time subfile

    I want to code loading a single page subfile in SQLRPGLE. How do I handle the page up and page down key, posotion to in that program? thanks, NG

    Nutangujar895 pointsBadges:
  • How to handle deletion in RPG

    I have a file(A) that needs to have records deleted from it based off information in another file(B). I think the logic should be... Read A Chain to B if criteria met delete record. Is there a better/cleaner way to do this? I do not have much experience with RPG.

    Adeaver20 pointsBadges:
  • The most-watched IT questions this week: Oct. 20, 2009

    Here are the 5 most watched questions on ITKE: There's some great discussions going on ranging from SQL to diagnosing app crashes. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1.ORA-31672 in oracle 11g tops the list, with...

    Michael Morisy8,588 pointsBadges:
  • Sending email via AS400 SNDDST

    How can I use SNDDST to send email to an email group in Lotus Notes? I know how to send to a specific email address but not to an email group.

    Rodesa0 pointsBadges:
  • Journaling a file

    Hi,   I recieve the following error when i journal a file Damage prevents object  from being journaled.    Cause . . . . . :   A damaged object previously journaled to this journal       prevents journaling from being started for object in library   type *QDDS.  If the object is an...

    Knowledgeseekerone30 pointsBadges:
  • User Id in Pgm DS in case of Scheduled Batch Job.

    Hi All. An user's id can be retrieved inside the pgm from system Data Structure which contains the User Id invoking the pgm. Normally this is passed to a file field before writing/updating the file. If the file is updated by a Batch pgm then the Id of user submitting the job goes to the system DS...

    Dipendra0 pointsBadges:
  • OPNQRYF vs. Logical

    Hi, I am not very clear as to when should we use OPNQRYF and when should we use Logical file? Since logical file also offers DYNSLT facility, when is the use of OPNQRYF desirable?? Please advise.

    A1b2c3335 pointsBadges:
  • OPNQRYF vs Logical files

    What are the advantages and disadvantages of logical files over OPNQRYF command??

    A1b2c3335 pointsBadges:
  • Question on OVRDBF command

    Suppose, in my CL program, I am using the following command: OVRDBF file(file1) tofile(file2) The question is: In my RPG program, which file will be read in C specs..will it be Read file1 or Read file2?? Thanks.

    A1b2c3335 pointsBadges:
  • Scalar functions in GROUP BY

    Is there a reason why I cannot use a SCALAR function in a Group BY clause? I have a table with a column that is of type timestamp. I want to get a count of all dates for which there are multiple rows. So I devise a query of the sort SELECT COUNT(*), DAYS(TMSTP_COL) FROM MYTAB A GROUP BY...

    Sumithar0 pointsBadges:
  • WRKQRY Security Flaw / Users can Alter/ Replace Data in Production Files

    Can a user change or replace data, members, or the file itself (a prodcution file in a production lib) using WRKQRY...??? I have an auditor who believes in the "Define the Query" display, 2nd to last option ("Select output type and output form") you can specify 3 in the output type (3 = datafile...

    Gambitt7160 pointsBadges:
  • How to pop up login when using STRPCCMD

    How do you pop up loginwindow when using STRPCCMD?

    Bpulido35 pointsBadges:
  • Suppress FTP messages

    I've got a program that FTP's (put) files to another system. I always used the program in batch mode. Now I'm trying to ref the program interactively. But message 'Press ENTER to end terminal session.' requires user intervention. Does any know how I can suppress FTP messages while running in...

    Mtspudgun45 pointsBadges:
  • ftp spooled os/400(iseries) to pc format text or pdf

    i looking for solutions to help me the asking into the subject i looking for prices of solutions i looking freewere and i looking anything about the subject

    Luizmereb0 pointsBadges:
  • Error Reset Key

    I have a request that I have not done before. In my display file I use the IBM messages when there is an error. When the screen is displayed again it displays the field in question highlighted and then the user has to press the error reset key. Is there away so the user does not have to press the...

    RonKoontz1,780 pointsBadges:
  • Justify right in COBOL

    I have data where the format has been changed slightly by the carrier and now this change is causing my job to abend. The last page number of each file reads ex.'160 OF 160' however, the new format must read '160 of 160' which means that the last page number needs to justfied to the right to pos...

    Tm200930 pointsBadges:
  • STRQMQRY in batch on i5

    Can STRQMQRY be run in batch? I am getting error message: Global variable prompting is not allowed in batch mode. I am passing 2 parameters from a display screen

    TOASTY35 pointsBadges:
  • Purpose of binding directory in CGIDEV2?

    I'm a little stuck.  I'm trying to follow some guides regarding using CGIDEV2 on my iSeries V6R1 to do AJAX.  I've looked at easy400.net as well as some other references, but I keep having the same issue.  I keep getting error CPF980F 'Binding directory [dir] in library *libl not found.' Do I...

    Koohiisan5,045 pointsBadges:
  • Callin CLP with parameter

    Hi, I have a CL program which needs two Parametersa as a input, when i call a pgm with values, the value are not properly passed. It gives me decimal data error. For instance i gave values as Call pgm(clpgm) Parm('14' 'aaaaa') But it takes value as F1F44040404040. Hel me out soon. Thanks in advance...

    Keepsmilin5 pointsBadges:
  • Adopted Authority

    I am extemely new to RPG so I am looking for a simple code that uses adopted authority of SECOFR to an operator temporarily simply to enable users. I know that it can be done, but I would like to know the structure of it from and RPG standpoint. Thanks in advance.

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

Thanks! We'll email you when relevant content is added and updated.

Following