AS/400 Tag Directory

Featured AS/400 Questions

  • 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.

    rajat01130 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?

    Gayathri123665 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.)

    rajat01130 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,000 pointsBadges:
  • WC3270 Emulator

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

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

    rajat01130 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.

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

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