AS/400 Tag Directory

Featured AS/400 Questions

  • I’m new to the 400 and green screens

    What is the most efficient / quickest way to learn as/400 system admin/mgmt from the ground up? I'm looking for a logical path where each step builds on the previous. I have a windows background and understand the basic system admin tenets. I started with MC Press Primer and IBM Redbooks.

    sumguy5 pointsBadges:
  • Documenting column in SQL table in QADBIFLD (AS400)

    When a table is created with SQL, several fields in the system cross-reference file QADBIFLD gets content (headings, defults a.o). I noticed that the QADBIFLD table contains a column named DBIREM (length 2000 bytes..). I also noticed that the old S36 IDDU actually put some documentation into this...

    DanTheDane2,555 pointsBadges:
  • Display fields and subfile side by side

    Hi all I am using V5R1. I have to design a screen where some fields should be on left side and a subfile on right side (both side by side). I have tried a lot but couldn't succeeded yet. I have made two separate record formats one for all fields on left side and the other one is subfile. but when I...

    hunshabbir7700 pointsBadges:
  • AS/400 Error handling for multiple selection in subfile

    I want to throw error message, when user selects multiple options in a subfile field with '1' as  valid selection. In this for all records in the subfile, I need to select only one record at time, but not multiple records. Suggest any DDS keyword/function which will validate only one selection,...

    poojaary85 pointsBadges:
  • AS400 Suddenly Out Of Space

    I have an AS400 V5R1 that was at 60% and now over the weekend shot up to 99 % full. I have no ideas why I lost all the space. This happend last week as well and I removed an old library but still happening. Reclaim Storage and Splfiles Does Nothing. Is there a Journal that could have gone nuts ??...

    400Admini5 pointsBadges:
  • Position to Specific Records in AS/400 Subfile

    Hi! For example when we display the records in a subfile normally it is listing out all the records from the first record of a physical file. In the same, I want to show all the records in a subfile but when they view it, it should show the page related to the current month or date. In my physical...

    Sureyz2,375 pointsBadges:
  • Adding workstation to subsystem

    I have a sub system named SBSIT and I've added the IT* workstation in order to put all workstations under that sub system like IT1,IT2.... but all users signing on to system ...their workstations set under QINTER ,what should i do to solve it? Detailed description...

    msokkar5 pointsBadges:
  • Position cursor when back to subfile

    I have to position the cursor of a subfile in the same field where i am selected after back from some other screen validation. The subfile type is SFLSIZ>SFLPAG . Please help

    Nammy5 pointsBadges:
  • How can I remove hard disk from AS/400 server model 800?

    How can I remove a hard disk from an AS/400 server model 800?

    Afzal8350 pointsBadges:
  • AS/400: Adding a F4 prompt to 2 subfiles over/under

    I am modifying a 2 subfile screen, one subfile over the other. The TOP subfile is using the EXFMT statement while the BOTTOM subfile is a WRITE statement. I need to add an F4 prompt to the BOTTOM subfile using the customer number that was keyed into the TOP subfile to search with. When I key in the...

    UARTJ105 pointsBadges:
  • Design wider subfile in AS/400

    How can I design a wider subfile, meaning I have about 20 fields to show in a subfile with variable length. How I can display them to-gather in a single subfile and implement horizontal scrolling also. Thanks in advance.

    hunshabbir7700 pointsBadges:
  • Storage of AS/400 user profile

    when I DSPUSRPRF myprofile,it shows the storage like 16M. After I delete all the objects owned by myprofile (using WRKOBJOWN myprofile to check the objects),it still shows 16M. how can I do to down size the storage of myprofile? many thanks for helping me.

    Gaoshen10035 pointsBadges:
  • Problem with Load Forwarded Subfile.

    Hi,I am new to this technology.Below is My Load Forwarded subfile code.This is just a program to copy more than 9999 records nothing more than that. I was facing some Relational error in the program( Coded in Red colour).it was displaying only first 5 records on the screen. Kindly help me to...

    HABBIE795 pointsBadges:
  • Fetching Duplicate records from a file

    Hi,I have file EMP: with ID,name,Department columns. Id as key field. There are more than a billion records with 50,000 duplicate records .I just want to fetch only those duplicate records on a single query. Thanks

    HABBIE795 pointsBadges:
  • Searching a field in Load-all Subfile

    Hi, I am trying to display the contents of tables present in a library. The contents of tables will have the following details 1. Count of records 2. File name 3. Last change date 4. Last change time There can be around 3000 files in this library. I have used Load all subfile Is it advisable to use...

    Prashanth123255 pointsBadges:
  • Subfile Identification

    Hi,Is it possible to find out , what kind of a subfile(Load All/Load Forward/Single page) it is? By just seeing the subfile screen itself.

    HABBIE795 pointsBadges:
  • Synon related: Searching calling program in Synon (PRTFIL).

    How can be search external program (outside Synon) which is calling print file function (PRTFIL). Actually, I know to search all function which are calling print file by the option 91 or take U at subfile selector or 95 at object usage screen but that approach can only work to identify internal...

    dilipsynonexpert80 pointsBadges:
  • Query on Subfile

    Have Display File - Subfile with Few Numeric Fields. SUBSIZ = 45, SUBPAG = 10. In RPGLE, Getting to Value from another Data Queue, Writing in to the Subfile if Record if there and incrementing the RRN and Line Number. Writing in to Subfile even there is no record in Data Queue. Here incrementing...

    rajeshece1,215 pointsBadges:
  • Using AS/400 SQL to replace a variable string

    I need to do a scan and replace in a flat file. File has one field 80 characters long. Possibly one or more of the records in the file contain a specific value, such as '%ABC%' and I want to update the record replace ABC with XYZ. This value could be anywhere within the record. I do not want to...

    CharlieBrowne41,370 pointsBadges:
  • Update Data SQL Server From AS400

    Hi, some help me. I want to write data to SQL Server from AS400 in RPGLE. Some have code for make this. Thanks for advance.

    JLH5 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