• FTP to non QGPL

    One user writes, "How can I send files from a PC running a VB program straight to a designated library within iSeries without going to QGPL? We have sales representatives that run Visual Basic (VB)...

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

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

  • List of who changed the system date

    One user writes, "Is there a way we can see the list of all the persons who changed the system date?" Systems management expert Dan Reusche was on hand to offer some advice.

  • Printer output file won't open

    One user writes, "Within iSeries Navigator, I tried to open a printer output file and it wouldn't open, and I'm not receiving any error messages. The Navigator I'm using has iSeries Access for Wind...

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

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

  • Finding passwords that are close to expiration

    One user writes, "Is there a file that can be queried or a report that can be run that will show users with passwords close to the expiration date?" Thankfully, security expert Carol Woodbury was o...

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

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

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

  • WebSphere error during login process

    One user writes, "We have installed WebSphere Development Studio Client (WDSC) 5.1.2 to reface an iSeries green-screen application and create a browser-based user interface using the IBM WebFacing ...

  • WebFacing error: User ID or password invalid

  • Connecting to a separate LAN for printing

  • Bringing a system out of restricted state

  • Printing errors since power outage occurred

    One Search400.com member writes, "One of the companies I work with recently had a power outage. Since then, any spool file created acts like it is going to print (status WTR) then immediately goes ...

  • Why am I receiving the error SQL7008?

    This user is receiving the error SQL7008 message. Site expert Kent Milligan offers some advice.

  • iSeries and LAN are not playing nice

    This user acquired a used iSeries and he was having trouble getting it to talk to his LAN. Systems management expert Glen Bunnell has some suggestions.

  • Setting up a shared directory in the IFS

    One user writes, "How can I set up a shared directory in the IFS? That is, a directory in which different users can delete files created by other users. I have tried using the SETGID and CHGRP comm...

  • Why are users getting the "not authorized" message?

    One user writes, "My users are getting "not authorized" messages when they run queries. They have run these queries for years. The PUBLIC authority on the queries and the library objects is *CHANGE...