AS/400 Tag Directory

Featured AS/400 Questions

  • Bad data in as/400 database.. cant display record

    We have a user that insists on using cut and paste to enter data into our system. The problem is bad hex/ascii chars are causing errors trying to retrieve the data. If you try to edit the data using STRDFU it gives the message "The retrieved record contains invalid data." To make things worse you...

    ToddN2000100,095 pointsBadges:
  • Input capable fields in AS/400 database file

    This inquiry is regarding 'Usage' clause for physical and logical files (position 38). IBM manual says options in this position are: Blank, B, I and N. Here is a snippet of what I experimented unsuccessfully R RZ0101R1      F0 5A I      F1 5P 2O notice I and O in pos(38) This gives me an...

    anandx625 pointsBadges:
  • Retrieve RRN from SFL within a window displayed but not active on the screen

    A window displaying multiple items within an order is displayed on a screen in which additional items are to be added or an existing item, from within the window, is to be retrieved and updated. The SFL is defined as size=100 and page=7. If I click on one of the items in the window, by using the...

    Zack310 pointsBadges:
  • How to disable hyperlinks/email addresses in a subfile on AS/400

    I created a RPGLE maintenance program on AS/400 with a subfile. In that subfile there is a field which contains email addresses, Even when the field is in output in the subfile, I can click on it and then I get a screen to create a new email for that email address. How can I prevent this? I only...

    MarjanMelsen20 pointsBadges:
  • How to create AS/400 menus

    Hi, I am new to work with Menus. I have to Create menus. How do I need to start ? I need information from the scratch. Here I am using CRTMNU MENU(PAYLIB/PAYROLL) TYPE(*DSPF) ... Here onwords I don’t know how to proceed . Last time I have sent the same request , but some one send me link for...

    Khadar90 pointsBadges:
  • Calculator on DSPF screen on AS/400

    Screen- 0 to 9 buttons , and +,-,= button. If I click 0 to 9, it will be display on screen and click = then show the result on the screen. Please give me the screen shot.

    Satyamohanty65 pointsBadges:
  • After what kind of changes in a display file (*DSPF), it must be re-compiled?

    For e.g. If I change the display size, the program using the DSPF auto-understand the display size change. Hence I need not to compile it. So what all are the scenarios post which I must compile the DSPF?

    rajat01170 pointsBadges:
  • How To get The Cursor position on particular field?

    My display File Contains three Fields as like name= ........  Roll =........  Marks=.......  But In that Case when Program Call, First Cursor Pos On name When Name Will Enter Roll No will Automaticalyy Disply. But I have To Modify Marks Field,,, So When I will Enter Name After That I want To...

    Sms121185 pointsBadges:
  • DFU with VARCHAR fields?

    Can I use DFU to maintain VARCHAR fields in a table? If not, is there another easy utility that I can give users to add text to such a file?

    markhod5 pointsBadges:
  • Getting info on DFU usage

    I'm embarrassed to ask, but ... Is there a way to find occurrences of DFU usage? Even better if it excludes DSPDTA. TMI - The prior regime here was pro DFU. So just revoking all authority to it would be disruptive in the short run. So identifying users/data files/dates would be a good start toward...

    aceofdelts2,465 pointsBadges:
  • DSPFD command throws message CPF3061

    I am trying to delete members from a physical file if the member size is reaced. I have written code in CL as below -> dclf file(qtemp/ehutmp) opnid efile create outfile by dspfd-> dspfd file(ehub) type(*mbrlist) output(*outfile) outfile(qtemp/ehutmp) and then read file and delete old member...

    mohit123210 pointsBadges:
  • Delete members from multimember physical file

    I have to remove members which are were created before six months from two physical files in a single CL program if the member size is reached in physical files. I am creating outfile using DSPFD command and then deleting records that are created before 6 months. EHUBTMP and EHUPTMP will be the...

    mohit123210 pointsBadges:
  • DLTOVR

    Why we have to use DLTOVR after OVRDBF command?

    dkumarvats90920 pointsBadges:
  • AS/400: How to know whether field having value in a display file

    I have a display file with 1 field having length 2 Alphanumeric. I want to know whether that field having value or not without any I/O operation on DSPF (i.e. without Hit ENTER or press Function keys). Since I need to auto pop up the window as soon (i.e. at second position/last position of that...

    Nikrajpapa250 pointsBadges:
  • DFU (UPDDTA) and changing Keys

    DFU (UPDDTA) and changing keys - We support a number of users of the same software. then we try to change a key field in a file with DFU it doesn't always allow us to do so. Sometimes the user does not have access to the key field, sometimes they do. Each user is the owner of the file and has...

    Bamba6125 pointsBadges:
  • We set a PF to share(*yes) but when we do a DSPFD it shows a blank in the atshar field

    I created a file from the DSPFD command using the type of *basatr. when I query the file the atshar field is blank. However we use the DSPFD and display it and the ii shows *yes on the display. I'm not understanding the mismatch.

    chaze15 pointsBadges:
  • Remove message from display file

    In my program I'm placing this message on the display after pressing page down again after the end of subfile has already been reached. When paging back up, control doesn't return to the program because the records exist in the subfile. How do I go about displaying this message, then removing it...

    JohnGalt177635 pointsBadges:
  • Looking for less complex DSM interfaces

    We have recently developed a business application using external definitions stored in a database file - such as fields definitions, data structures, validity checks, and so on. One of the uses of this external data has been to generate a DDS source that is then compiled into a DSPF. I would like...

    AS400 - Ask the Expert485 pointsBadges:
  • Scrolling Message in RPGLE

    Does anyone know how to create a scrolling message on the bottom of a display screen? I am programming on the AS/400 in RPGLE.

    GHENDER220 pointsBadges:
  • While connecting to the console after system save, we’re unable to get to the login page

    In our data center, we have run the system save manually through console using DSP01. But we're  unable to get the login prompt. In bottom line getting 9030 .. on DSP01 login page. What should we do?

    TamilselviK30 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