Weigh the pros and cons of technologies, products and projects you are considering.


Weigh the pros and cons of technologies, products and projects you are considering.

  • Error with MYLIB function

     Continue Reading

  • Read records on a subfile

    One user writes, "How can I read all records on a subfile? Using READC opcode, one can read only the changed records. I have been working with the SFLNXTCHG keyword but without success. A simple example illustrating the subfile DDS, as well as the ... Continue Reading

  • Green screens taken over by .NET

    iSeries software vendor ASNA recently updated its Monarch software, which migrates green-screen applications onto Microsoft .NET. Continue Reading

  • midrange

    In general, midrange refers to computers that are more powerful and capable than personal computers but less powerful and capable than mainframe computers. Continue Reading

  • SQL view that SELECTS on functions

    This user was having an issue with his SQL view on his iSeries that SELECTS on a few functions. Db2 Expert Kent Milligan explained what was going on. Continue Reading

  • Scheduling a SQL update statement

    One user writes, "I need to run a SQL Update statement after hours, and it would be nice to schedule it. I saw your posting about the RUNSQLSTM command, but I've had no success with it. I tried saving my command in the STRSQL run, which it saved to ...Continue Reading

  • Error message of null values

    One user wrties, "In V5R3 I got the error message of null values not allowed in column or variable ZORD#T for SQL update." DB2 expert Kent Milligan offers some advice.Continue Reading

  • Import a text file to a DB2 table

    One user writes, "I need to "import" a text file located in the user computer to a DB2 table in the database, what's the best way to do this?" DB2 expert Kent Milligan offers some advice.Continue Reading

  • Recommended index not used

    One user writes, "Using SQL performance monitor of Operation Navigator, an index was recommended. I created the recommended index, but it looks like the system doesn't use it. I find it strange that the index is recommended and then not used. Is ...Continue Reading

  • Connecting WebSphere to a DB2 database

    One user writes, "How can I connect WebSphere on my iSeries to a DB2 database on an AIX machine? We've tried a number of different methods configuring JDBC drivers, but nothing seems to work." Web development expert Jim Mason offered some advice.Continue Reading

  • RPG-free routine to calculate dates

    One user writes, "I thought that I saw somewhere an RPG-free routine using %DATE (bif) to calculate the day of the week. For example, MON, TUE, etc.? I need to place the day on a screen." Development expert John Blenkinsop responds.Continue Reading

  • Interrupting a user's session

    One user writes, "I want to send the user a message that will interrupt their session and remind them to transmit the payroll. Right now I send break messages throughout the day. The user doesn't want the reminder if they already executed the job....Continue Reading

  • Manipulating a file

    One user writes, "How would I go about taking a list of users and making it a file that I can manipulate? For example, "wrkusrprf *all"." Thankfully, development expert John Blenkinsop was one hand to offer some advice.Continue Reading

  • SQL statement help needed

    This user had a few questions regarding SQL statements. DB2 UDB expert Kent Milligan was on hand to help him out.Continue Reading

  • Migrating from a batch-based HP3000 environment

    This user is migrating from a batch-based HP3000 environment to an iSeries and ran into a little trouble. Thankfully, site expert John Blenkinsop was on hand to lend a hand.Continue Reading