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:
  • How to import data from a .CSV or .XLSX file to an AS/400 file?

    I want to import the data of a .CSV or .XLSX file to a AS400 file. How can I accomplish this? Also, the .CSV/.XLSX file has two columns that I would like to keep in the AS/400 File. Any inputs would be really appreciated.

    Jorame5 pointsBadges:
  • WC3270 Emulator

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

    Gayathri123925 pointsBadges:
  • Encrypting AS/400 database file

    I need to encrypt a database file residing on the AS/400 and FTP to a destination. Can I use QC3ENCDT to do this?

    Jeffm135 pointsBadges:
  • How to update/view records of a flat file with packed decimal fields?

    Using RUNQRY, it shows the values in packed format that are hard to understand/decrypt for a human.

    rajat01170 pointsBadges:
  • Migrate from DMS2 database to DB/400

    Hi team, Is it possible to migrate from DMS2 database (unisys database) to DB/400? If so, what are the migration steps? If not , is it possible to migrate the DMS2 to DB2 on Linux or Unix?

    Gayathri123925 pointsBadges:
  • How to create a single member file for each member of a given multi-member file?

    Let the file be 'Employee' and its members be 'Trainee', 'Associate', 'Professional', and 'Expert'. I wish to cut the superset of 'Employee', and just get dedicated PFs for 'Trainee', 'Associate', 'Professional' and 'Expert' (so that they can be queried as a first member.)

    rajat01170 pointsBadges:
  • Transform DB2 to XML from AS/400

    I have been requested to create XML files from AS/400 DB2 files to be used to update data on a client's web server. I have looked at IBM's XML Toolkit for iSeries, but the examples are all about parsing XML input and nothing about creating XML from native AS/400 database files. Is there something...

    LBurkett99850 pointsBadges:
  • Releasing lock in AS/400

    how to find which record is locked and who locked that to release the lock by ourselves.please explain in detail.i'm new to as/400.

    Kaly470 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:
  • Default User-ID AS400 problem

    When some user's log into the AS400 they get the dialogbox where they have to fillout the user-id and password. Some users get an default user-id that's not correct. How can I change this?

    Davidfromnetherlands15 pointsBadges:
  • File Level identifier Vs. Record Format Level Identifier vs. Member level identifier

    Hi,   Please let me know the difference b/n File Level identifier, Record Format Level Identifier and Member level identifier with an example

    AS400B20 pointsBadges:
  • 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...

    BigKat9,090 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?

    Radycal60 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)?

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

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.