AS/400 Tag Directory

Featured AS/400 Questions

  • AS/400 Macros causing program crash/lockup

    My IT guy at my company is not familiar with using macros, so has been of limited help on this issue. I have some macros setup just to insert a string of letters for item#. Example, LUDCSS4. I have the macro set on the keyboard to Alt+A. They worked fine until the session was changed to fix another...

    randyatDL85 pointsBadges:
  • Subfile processing – Incorrect record number in subfile SFLRCDNBR or SFLSIZ field.

    I am getting the above error - This the dds specs: A A R SUBDTB SFL A SUBPART 35A B 6 18 A R SUBCTLB SFLCTL(SUBDTB) A*%%TS SD 20031114 134548 KAUSC REL-V5R2M0 5722-WDS A SFLSIZ(0020) A SFLPAG(0010) A ROLLUP A ROLLDOWN A 60 SFLDSPCTL A N61 OVERLAY A 61 SFLCLR A 62 SFLDSP A 70 SFLEND(*MORE) A LSTRRNB...

    Manyquestions65 pointsBadges:
  • In a single CL Program, can we read a database file more than once?

    In a single CL Program, can we read a database file more than once

    Chraghuveer25 pointsBadges:
  • F22 step into in STRDBG not working

    Using STRDBG, I use to be able to hit f22 to step into a program or procedure but now nothing happens when I hit the key. Is there a setting that enables this?

    kglen0160 pointsBadges:
  • How are DB2 files different from Physical files in AS/400?

    May i know how database tables are different from Physical files in as400

    Geek51180 pointsBadges:
  • Field validation in AS/400

    Hi, I want to throw error messages based on following validation on the display screen. 1) If field type is character and it's length is 50 and if someone put numeric value in it's first position then error message should be populated as following:- "The value of 1 is not valid for this field" It...

    6r1,640 pointsBadges:
  • Screen size from INFDS

    I'm trying to get the size of the screen from the INFDS for the display file. According to the IBM manual it should be available in the INFDS positions 67-70 after a POST. After working on this for a couple of hours and searching the internet for another hour or two I'm at a loss. I can get other...

    Vatchy1,415 pointsBadges:
  • What causes the last used date to be updated on a file?

    I have a library that has a number of files with very recent last used dates. This library is left over from the original application install and is not used anywhere that I can find. The only mention of the library is on a dsppgmref listing for the base application programs, where the library is...

    ITKE376,290 pointsBadges:
  • *UTCD field type

    Hi All, We have just upgraded from V5.4 to V6.1 and have run into a problem with a program that does a sndpgmmsg of CPF1241.  The date and time parameters are data types *UTCD and *UTCT.  What should be used to populate those parameters when sending the message?  Everything I've tried so far...

    ITKE376,290 pointsBadges:
  • Reading a file in Reverse Order in CL Program

    ) In CL program how can we read a data base file in reverse order.

    Chraghuveer25 pointsBadges:
  • AS/400: Use PUSH Button for a numeric field

    How to use a push button with numeric field? I mean I have a numeric field of six length which is showing 456789 (for Ex). When I click this value like a button it need to show another window. Thanks in advance. Surey

    Sureyz2,655 pointsBadges:
  • Records in subfile are put in another order

    We implemented an iSeries v7r1 over the weekend . In a particular display the user enters records in a subfile in last name order, when he/she pages down to another screen in the subfile the records change to a different order. The display, physical, logicals and programs have not been changed...

    JCunha70 pointsBadges:
  • Best way to migrate big data from Oracle to DB2 for i

    Hi. I've tried some methods (SQL, plain text files...) but, I'd like to be sure on what is the best method to implement a migration of big data files.

    iredin5 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:
  • Maximum number of records that can be stored on AS/400 file

    What is the Maximum number of records that can be stored on an AS/400 data file?

    JohnsonMumbai1,280 pointsBadges:
  • Problem occured while running a QSH command

    The following command wrote ABC to my data area. (As a text value).

    munduuu435 pointsBadges:
  • Increase QDLS Maximum File Size

    I get the message 'write operation beyond the maximum file size for a file in file system QDLS' with output from a ASC Sequel (*delimited). It seems to stop at 2Gb. How can I increase the maximum file size allowed in QDLS? Thanks, Brian

    6735 pointsBadges:
  • RPG Debugger

    I work for a small AS/400 shop. For the most part, we are still coding in RPGIII and doing green screen applications. Due to a recent Lawson upgrade, we have had to convert a large chunk of our code to ILE. Myself and the other programmer here are used to the Interactive debugger and using the old...

    Willhud69205 pointsBadges:
  • Printer Problem AS/400

    We have a client using AS/400 model 150 using Machine 36. We have connected a network printer through OS. EVery time they go to print a document the printer ends with message CPF1164 and ending code of 20. This cause with job ending code of 20 is 'The job exceeded end severity (ENDSEV job...

    Semd041970 pointsBadges:
  • Date Function AS400

    I need the Date function of DB2. Actually I want to subtract the Date however I have used the follwoing: select current date -1 from sysibm.sysdummay1; But It occures an error. Is there any way to subtract the date in the query. I am using iSeries DB2 AS400

    Mr. SEA130 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.