• Trigger program lock.

    When a trigger program is locked because the physical file is locked, how can we promote a program through MKS when it is locked. We have over 40 warehouses with a copy of the same file so getting everyone out of the individual files would be a chore. Can we use a CL for the trigger program or is...

    UARTJ170 pointsBadges:
  • Dynamic subfile fields in AS/400

    Hi, I would like to design a file query tool, Subfile fields should be displayed based on file structure I select. I don't want do define a single long field and assign data into that. I may use the same screen for editing the field data as well. Thanks, Elango G

    as400dev620 pointsBadges:
  • AS/400 Embedded SQL, RPGLE free format, compilation

    1. My Problem: I am not able to compile a RPGLE free format PGM with embedded SQL. 2. My simple basic code: exec sql select RAGNA from RPFAGE ; *inlr = *on ;  (RPGAGE is the PF name and RAGNA is one of the fields in PF RPGAGE PF contains 100 records) 3, Member type is SQLRPGLE 4. Compile command:...

    anandx625 pointsBadges:
  • AS/400 user profiles hard coded in programs

    Is there a way to find profiles that are hard coded into programs?

    Rrbond07440 pointsBadges:
  • AS/400 Direct Access vs Pasthru

    I'm trying to determine how many users are directly logging onto an AS/400 system versus ones that are using strpasthr. Is there a way to determine that?

    DBHP4504020 pointsBadges:
  • Adopting authority in CL program

    I've already created an outfile of all the user profiles and related information. I now want to write a CL program that will read the file-taking each profile and running command DSPPGMADP. Can command DSPPGMADP be used in a CL program?

    Rrbond07440 pointsBadges:
  • How could IBM have settled at ‘Q’ while naming its system objects?

    for e.g. QSYS, QSJSENDER, QCMDEXC, QDDSSRC

    rajat01170 pointsBadges:
  • AS/400 Backups

    Hi team, Is it possible to backup AS/400 using Veritas Backup Exec tool?

    Gayathri123925 pointsBadges:
  • AS/400 journal receiver modification

    Is it applicable to modify in journal receiver content? and if it is applicable who has the authorization to make this modification? and how to detect who do such modification

    sameer8435 pointsBadges:
  • How to monitor external ODBC connection(s) for failures and reasons for same

    I am trying to monitor ODBC connections from our website to the iSeries 8 server and find reasons for any failures. Can't seem to find a method.

    randy95975 pointsBadges:
  • How can I find the list of temporary indexes created by the system of my iSeries AS/400 server?

    How can I find the list of temporary indexes created on my iSeries server? Can I also find the file name and key fields on which the indexes are created. I have a query running fast on one server which has not been IPLed for quite some time. Same query takes much longer on a server which was...

    JohnsonMumbai1,480 pointsBadges:
  • IBM Clusterproven initiative

    Does anyone have an idea on what happened to the IBM Clusterproven certification program? Has it been replaced by PowerHA? Were there any official IBM announcements made? I googled quite a bit but could not find a straight answer from the various articles with regards to what actually happened to...

    Jpjawili165 pointsBadges:
  • AS/400 command to print system status

    I need a command to print system status (dspsyssts & wrkdsksts). I.E, I need a spool file for this. Can someone help?

    MAHAshankar10 pointsBadges:
  • Check expiry date of tape (using iSeries and BRMS)

    I am chasing a simple CL program to check if the currently loaded tape has the data as *expired so it can be written to under BRMS. It shouldn't be that hard but I've searched for literally days and can't find anyone to help.

    GarryS15 pointsBadges:
  • klist chain not finding existing record

    I've got a logical keyed on field 1, field 2 and field 3. In my RPG I've got a chain to that logical with a key list where the values appear to match those in Field 1, 2 and 3. The chain fails to locate the record. A setll followed by a reade fails to find it. But a setll followed by a read does...

    mrwilf55 pointsBadges:
  • Unable to connect to AS/400 server

    I have downloaded as400 emulator TN5250 (free trial version). After installing the setup it took the IP address automatically. But if I say connect by giving a session name, it says "Sorry, unable to connect to the selected mainframe"

    Anugwag40 pointsBadges:
  • iSeries query for most recent data stored

    How do I write a query on the iSeries to return the record with the most recent data stored?

    ttcheri5 pointsBadges:
  • IBM PC5250 Display Shows Blank Space once Windows upgrade to 10

    Once Windows upgrade to 10, usual IBM PC5250 login screen did not appear. All the Characters are there and can be login, but lines are missing in where UserID Password input. it is totally black. Is this a resolution issue?

    Anshan150 pointsBadges:
  • Subfile whats the difference between in READC and SFLNXTCHG

    Hi Friends, I am new learner of AS/400. Can somebody tell me what's difference between in READC and SFLNXTCHG. Can somebody give me a practical example of sflnxtchg means why and when we use this keyword. Thanks in advance.

    Swapniln35 pointsBadges:
  • Creation of an app to interface with AS/400

    We have an AS/400 running our production line at our plant is expanding to a larger one. I get requests to print production tickets from the AS/400. I was wandering is there a way for me to create an APP to connect to the AS/400 via smart phone to be able to print from the plant floor and not have...

    MTSmith765 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