AS/400 Tag Directory

Featured AS/400 Questions

  • How to Add column (field) in ODBC to physical file?

    When I add a new field in ODBC, I can't find it in the physical file in the iSeries.

    afayek675 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:
  • What will happen in AS/400 if I use H dump?

    H  DUMP     what will happen to the program

    chakramdhar60 pointsBadges:
  • Creating a AS/400 database

    Hi, Till now I have worked as a Developer & recently I got a task on creating a database on AS/400. Can any one please let me know, what are the steps to be taken before I start creating database on AS/400 server.Is there any kind of tools so that I can connect with my server & to create...

    HABBIE820 pointsBadges:
  • AS400 database

    Hi,I have some kind of database, tables are from SQL server around 10 tables each having 1000 records. Now I need to convert these SQL tables into physical files & i need to store the same SQL records into these created physical files & finally should make the database as db2/400 database...

    HABBIE820 pointsBadges:
  • Connecting to a AS/400 database

    Hi, I am new to the database activities on AS/400. What is the difference between DB2/400 &DB2/LUW. What is a federation server? How can I connect to a particular database using tn5250 terminal? Is it possible to see multiple databases using this emulator tn5250. Kindly help me out

    HABBIE820 pointsBadges:
  • AS400 Suddenly Out Of Space

    I have an AS400 V5R1 that was at 60% and now over the weekend shot up to 99 % full. I have no ideas why I lost all the space. This happend last week as well and I removed an old library but still happening. Reclaim Storage and Splfiles Does Nothing. Is there a Journal that could have gone nuts ??...

    400Admini5 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:
  • Email configuration in AS/400

    Hi Group! I have been checking so many articles related to email configuration on iSeries. I just need to add an option in our application like a compose mail option and when they fill the message body and  it should go to one default mail id for ex. as400@xxx.com with their USER PROFILE NAME. How...

    Sureyz2,380 pointsBadges:
  • AS/400: Joining multiple files and getting multiple duplicates

    I am a novice AS/400 user and have been thrown into the lions den. I need to pull info from 4 files that have at least 1 common field. Regardless of using 1 or multiple tests I get a lot of duplicates. There has to be a way to not get them. Our former and now deceased AS/400 guru did queries all of...

    Rsm42525 pointsBadges:
  • SQL / DB2 Optimization (timing out)

    I put together a simple VB program to run SQL commands on any of our 4 I-series machines to return a simple grid view. I have run across a strange problem and was told it may have to do with optimization. For example if I run the following SQL ( I just want a count of parts (pm) that have not been...

    ToddN20009,915 pointsBadges:
  • AS400 – displaying window in *DS3 screen size over SFL in *DS4 screen size

    I want to be able to display a window with a 24x80 screen size, without removing the background SFL which is displayed with a 27x132 screen size. Haven't been able to do it. I have tried 2 different formats in one display file, using 2 line and position definitions per field (one for DS3 and...

    Zack250 pointsBadges:
  • Flip Dates

    Hi, I have a file with numeric field which contain date values. The file is huge in size and some of the date values are in DDMMYYYY format and rest of them are in YYYYMMDD. The program writing the date values in DMY is fixed recently but I need to flip the previous records which is in DDMMYYYY...

    NicyChn110 pointsBadges:
  • AS/400 disk space command

    I need to know the command in the AS/400 that will show me the total disc space.

    Bunkin6920 pointsBadges:
  • ‘convert as/400 dates ’0001-01-01′ to SQL Server 2000′

    How do I convert ISO dates of '0001-01-01' to SQL Server 2000 Datetime format?

    Jld10 pointsBadges:
  • as400 db2 to sql server 2005

    how can we take a db2 backup tape and dump to a sql server 2005 database?

    Mingo5 pointsBadges:
  • Steps to debug the batch job which is active

    If a job is in held state, we can give STRSRVJOB and STRDBG and RLSJOB to debug the PGM. But I need the steps to debug the batch job which is active?

    dinuas400510 pointsBadges:
  • DB2 HADR configuration

    Hi, wanted to check if anyone of you have experience in DB2 HADR configuration with 'reads on standby' enabled. We are looking for auto fail over between the nodes and balance the reads between the nodes. Does anyone has any prior experience with this configuration on the AIX environment? Thanks.

    kbsantosh15 pointsBadges:
  • AS/400 debug

    How can I do a batch debug?

    prblomes25 pointsBadges:
  • AS/400 via Access, update query

    Hi all, My DB is on AS/400 and I use Microsoft Access to run queries. However, whenever I try to run an update query, I receive the following error message: "[IBM][ISeries Access ODBC Driver][DB2 UDB]SQL7008 - table in library not valid for operation. (#-7008)" Any idea what is missing? Thanks in...

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

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following