AS/400 Tag Directory

Featured AS/400 Questions

  • 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:
  • AS/400 email stopped

    Hi, Email from our iSeries stopped. How do I check what's wrong? Devan

    devan405 pointsBadges:
  • Retrieving data from AS/400 tables with PHP?

    I think I will die! Does anyone know how to get data from a table on AS/400 displayed with PHP through ODBC? I'm starting to go mad. I tried ODBC drivers (iSeries Access client, Client Access). Nothing helps. I have Apache server as localhost on my machine and PHP installed and that works fine. The...

    Avrelivs80 pointsBadges:
  • Trimming leading zeros in as/400

    Hi, I have a character input parameter of length 8. I have a customer number which may vary according to a query that user enters. This customer number is searched in an input file where the key field is numeric. I want to change this input parameter to numeric without any trailing zeros/blanks....

    Sangay635 pointsBadges:
  • DB2 to Text File Conversion and Transfer

    I have created a Text File from my AS/400 DB2 table. I want to transfer this file from one iSeries system to another. How to do this?

    gvdsswami20 pointsBadges:
  • 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

    Geek51185 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,850 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...

    ITKE440,495 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...

    ITKE440,495 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,735 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,365 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.