• Can AS/400 trigger program read the file of the trigger itself?

    I wrote a trigger program on a file. Can this program read/use this file itself? In case of an ADD in the file I have to read the last record of the file, is this possible?

    MarjanMelsen20 pointsBadges:
  • AS/400: How to read a file in CL program

    How we read a file in CL program and which command is used?

    vivekntt21190 pointsBadges:
  • AS/400 commands: Difference between CPYF vs. CRTDUPOBJ

    What is the difference between CPYF VS CRTDUPOBJ?

    vivekntt21190 pointsBadges:
  • AS/400 occurrence arrays

    What are occurrence arrays and in which case it is used in RPGLE?

    vivekntt21190 pointsBadges:
  • Select statement stopped listing records

    The statement is only selecting syntax and not listing records. Process parameter is *RUN. It was working earlier.

    gamurtuza35 pointsBadges:
  • AS/400 Physical file

    How to find the physical file associated with a logical file?

    vivekntt21190 pointsBadges:
  • Listing Supplement Groups from a AS/400 user profile

    I need to create a file (I am thinking from using query) that will list a user's Supplemental Group(s) as a separate line item for each supplement group listed in their profile. I need this so our security person can run a program they have for some kind of report. Is there a way to configure this...

    Rrbond07440 pointsBadges:
  • Suppress type ZR in AS/400 audit journaling

    the size of our audit journal has exploded. In looking at the entries, we have a ton more of type ZR (object read access). Is there any way to suppress those from being captured in the audit journaling?

    dpa165 pointsBadges:
  • Rebooting and changing boot-mode through display on iSeries

    We need to reboot iSeries but can only access through display at front of iSeries. I need help with meaning af symbols in display-window and how to change these.

    JensOrkla25 pointsBadges:
  • Display Panel of AS/400

    This is displaying on the display panel: "01 B N V=F T" What does this mean?

    mklein5 pointsBadges:
  • Outfile for profile authorizations

    Can anyone tell me what command will give me the following information. The fields for the information begin with OA, but I can't figure out what command will generate the information. OADCEN OADDAT OADTIM OAUSR OAOBJA OAOPR OAOMGT OAEXS OAREAD OAADD OAUPD OADLT OAAMGT OAANAM OANAME OALIB OATYPE...

    Rrbond07440 pointsBadges:
  • AS/400 ODBC connection

    How can I restrict SQL reporter to run update and delete query via ODBC connection? I don't want to restrict some profile which are being used by other application to write some records in specific file. Please advise.

    KapilTiwari201850 pointsBadges:
  • DSPOBJD for Library size and # of objects

    Is there a command/way of just getting the number of objects and total size of libraries other than selecting the *PRINT option? I wanted to dump the information to a file so I can query over it. I can dump the library names to a file, but I had to produce a listing as well so I can get the number...

    Rrbond07440 pointsBadges:
  • PTF installation

    Installed latest CUM PTF on V7R2 machine. Once PTF was done, restarted system through HMC. Now, restart operation is stuck in C20081FF status (waiting to receive the continue acknowledgement from System Licensed Internal Code). Now, the system license also expired. Hence, have requested license...

    sri8707165 pointsBadges:
  • How to update server DB file from web browser?

    We have a web page served directly off our IBMi system (out of the IFS). We want users to be able to maintain data from there (equivalent to green screen work-with & maintenance, but in a browser). I've tried looking for examples of how to update a database from JavaScript but they don't make...

    GregManzo2,315 pointsBadges:
  • How to disable auto audentity of a DB2/400 table

    Hello, For a migration data project (from SQL/Server to DB2/400), we need to disable the auto identifiers of a DB2/400 table. On SQL Server, the equivalent command is "set identity_insert MyTable off". Thank you in advance JC Cherid

    TheWorldAsGarp5 pointsBadges:
  • Accessing IBM MQ via a batch job running on an iASP

    I have an IBM i batch job BATCH1 that is running under a user profile PRF1 with an independent ASP IASP1 defined in the job description JOBD1 used by PRF1. BATCH1 is running under commitment control, *JOB scoped. I have a queue manager configured in *SYSBAS (QMGR library in *SYSBAS). I am getting...

    Jpjawili165 pointsBadges:
  • Writing a record to a physical file from CL

    Can I write a record to a physical file from CL? Once I do a test on a record, and before I delete the record, I wanted to write it to a physical file so later I can query over it to list what records were deleted.

    Rrbond07440 pointsBadges:
  • RPG SQL Nomain Module with DSPF

    I have Cycle Program with embedded SQL that updates table using display file. What do I have to do to create a module, so it will be compiled to *PGM object?

    FlashSmile5 pointsBadges:
  • Status of a receiver in AS/400

    When I do command WRKJRNA QAUDJRN  then Shift+F3 it will display the "Work with receiver directory". Under the Status column it will list as SAVED, ONLINE, PARTIAL or ATTACHED. Does anyone know what IBM file where I can grab that field value? I want to do a test on it for the SAVED status and...

    Rrbond07440 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