• 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.?

    GHENDER175 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:
  • Need to hold/resend AS/400 spool file on print failure

    Printing reports from an AS400 to a Xerox printer. If the printer fails no one knows until the next day. Trying to find the file the next day is horrid. Is there anyway to confirm and hold the file if it failed?

    Daowebe20 pointsBadges:
  • how many programmes are using any perticular database file in as400

    hi all, i m working on rpgile,if i have a logical file & i want to know list of programmes that r using that logical file ,what should i do? is there any command ??? thanks

    Ambrish 82310 pointsBadges:
  • excel report from rpg or sql

    How do I produce an excel report via RPG or SQL inside an RPG program.

    Taborly0820 pointsBadges:
  • Is a DB on AS400 always DB2 ?

    Please, I want to know if possible : when we speak about a data base on AS400, exactly a data base used by RPG, is it allways a DB2 database ? Is AS400 a database. Is it the same as DB2/400 ? I hope to be clear enough. Sincerely

    Poussines50 pointsBadges:
  • command execution

    thanks a lot!! for the help... but meanwhile i have got another problem...in my project- i have to use COMPILE commands such as CRTPF, CRTCLPPGM, CRTRPGPGM and so on...in a program and this has to be transparent to the user. in CL these programs cannot be used... how can i do this? plz help me out!

    Sairolla0 pointsBadges:
  • Sql statement

    After running a query interactively, how can I retrieve the SQL statement of that query defenition.

    Danielkiekens0 pointsBadges:
  • System Setting For Created Libraries

    Hi Everyone. An odd question, when we create new libraries on the 400 they are automatically flagged in the SETUPBCKUP screens for Daily/Weekly and Monthly backup. Where can I change this attribute for new libraries created on the system? Thanks, Rayden.

    RaydenR0 pointsBadges:
  • Retrieve data from a PC to an iSeries

    Katie wrote in with this question recently: Where can I get information to be able to retrieve data from a PC (or possibly be able to access data from IFS all day long) to the iSeries. I need to be able to have the iSeries open in communication all day long to a PC, PC Server or IFS to be able to...

    DebraTart0 pointsBadges:
  • Subfiles

    I am writing a RPG program using Subfiles for the first time. My program calls okay but my subfile is doing something strange. When i call the program, it dispalys the subfile starting from the last page of the subfile, what i need to do is display the subfile from the first record it finds. Can...

    Hazermark0 pointsBadges:
  • Retreive program atrributes and save information in a file

    I need to create a program that will check the activation group for all our ILE programs. I know that using DSPPGM command I can see the activation group for a specific object. Is there a way that I can have similar results but have the information stored in a file? Then I can read the file and...

    MayraPR5 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