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

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

    GHENDER200 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:
  • 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:

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