AS/400 Tag Directory

Featured AS/400 Questions

  • DB2i SQL select max(field) not using keyed access path

    I have a file that contains a timestamp field. This field is also the key field for the file. I am running a select statement in a UDF for the max value of that field, but according to the Query Access Plan: arrival sequence access was used for the file because the left-most key of the access path...

    BigKat8,915 pointsBadges:
  • WC3270 Emulator

    Hi Team, Does WC3270 emulator has access to perform all the system admin activities of IBM i?

    Gayathri123190 pointsBadges:
  • How to upload (savf) file from PC to AS400 without using FTP

    Hi, I have already the savf in my pc and i need to transfer it to as400. what will i need to do? anyone that can help me. Thank you in advance.

    Tomenio15 pointsBadges:
  • CPYTOIMPF error code 3025

    I am new to AS/400 and I wanted to transfer a file from AS/400 to PC using CPYTOIPMF as per advised here. But I am receiving an error, "File system error occurred" (Error number 3025) What's wrong?

    Radycal45 pointsBadges:
  • Key Mapping Error when writing records in AS/400

    When i try to write to record, i am getting Key Mapping error.Please let me know if somebody has faced this type of error

    C.naveen09140 pointsBadges:
  • Why a breakpoint is used while debugging?

    Is/are there any better alternative(s)?

    rajat0175 pointsBadges:
  • Synon/2E – No member source genned

    I created a file in the model and it did not generate a source member.

    Jeanmcjax5 pointsBadges:
  • Synon: Record Changed Error Message with no changes

    In Synon 2E: I am getting an error in an EDTFIL telling me "Update not accepted - record has been changed by another user ... " but no previous change has been made. New file and in dev only so I know no changes have been made. Can someone tell me what I have missed?

    Lbuser5 pointsBadges:
  • Error Messages on AS/400

    Dear All, Friends i want to know how to show all error messeges using AS400. For example criticle messages, other messages. Regards, Tahir

    tahirliaqat1150 pointsBadges:
  • Is it possible to use ADDRDBDIRE to connect to Oracle database?

    Is it possible to connect to Oracle database from IBM i? How to do that (I have IP address user ID, password and SID)? Thank you.

    VadimR5 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:
  • AS/400 SRC 000000E0

    This morning our old test AS/400 9402 was off. When we tried to IPL, we got the attention light on and an code 000000E.  Does someone knows what that error mean ? Any suggestion to revive that old thing ? Thanks in advance

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

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

    devan405 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:

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