AS/400 Tag Directory

Featured AS/400 Questions

  • AS/400: How to reuse field indicator

    How to reuse field indicator in a display file in AS/400?

    Amitkshukl15 pointsBadges:
  • QZDASOINIT job?

    Hi , am recieving the following error messages Message . . . . : Error occurred while calling program or procedure *LIBL/NBCUNQSN (C G D F). caused by the QZDASOINIT job. I presume this is a ODBC job that runs in QSERVER, any ideas as to what has to be done. The backup is running currently and this...

    harisudhan211,005 pointsBadges:
  • Clearing a display file buffer in AS/400

    How do you clear a display file buffer in AS/400

    dsloan20 pointsBadges:
  • How to run query in AS/400?

    New user, like to know in detail how to run query in AS/400 with snapshot will be better.

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

    ToddN2000102,585 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:
  • 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 record.how 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,110 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:

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