• Invoking a stored procedure from a COBOL program

    One user writes, "I am attempting to invoke a stored procedure (SQL) from a COBOL program. The stored procedure returns ONE result set, so the last (meaningful) statement in the stored procedure is...

  • Problems printing a graph

    I have a spool file with Print Device Type *AFPDS specified. The output has an imbedded graph. The graph seem to print on an *IPDS defined printer only. Is there a way to print to a non-IPDS prin...

  • Software recommendation needed

    One user writes, "I'm looking for software to convert a iSeries spool file to a PDF file and then store them into a directory. What product do you recommend?" Printing and output expert Chip Milosc...

  • Changing a default printer

    One user writes, "I'd like to change the printer a usrprf has assigned. Can you tell me the best way to go about that?" Printing an output expert Chip Milosch offer some advice.

  • Setting the font size for reports

    I need to set the font size to Arial 13 in my reports (PRTF). How can I do this?

  • Problems converting a FLOAT8 field

    I am trying to convert a FLOAT8 field to a 17 6 packed and the results are showing a reduction of 1/100000th in value. This is causing a tax calculation to be off by pennies. What can I do?

  • Storing system documentation on the iSeries

    I'm trying to store system documentation on my system, specifically MS Word documents on a shared drive in the IFS. This works fine, but Word always creates a hidden backup of each document which f...

  • WRKENVVAR character limit

    I use the WRKENVVAR to set the variable CLASSPATH. The issue is that the CLASSPATH has already been filled up. How can I increase the length of the Value Field?

  • Migrating users' passwords

    We have upgrading from V4R5 to V5R3 LPAR on another machine. Is it possible to migrate the users' current passwords?

  • Using password expiration intervals

    I am trying to use the user profiles report to determine if any users have had their password expiration intervals set to something other than the system value. When I run the profiles report, all...

  • Disabling the QSECOFR password

    Can you disable the QSECOFR password?

  • Tape encryption solutions

    What are the different tools available to take encrypted tape backup of iSeries?

  • Error with MYLIB function

  • iSeries to PC printing on HP printers

    How can I send an Escape <esc> seq in RPG so the printer can understand? Is it HEX 27 or ASCII 027?

  • Enabling FTP on your iSeries

    FTP is not configured on this user's server, so when he uses STRTCPFTP he's getting an error. What's going on and how can this be fixed? Search400.com expert Shahar Mor has some advice.

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

  • Condense ILE service program procedures

    One Search400.com member asked, "My mission is to encapsulate ILE service program procedures and make them available as Web services. While evaluating WebSphere Development Studio Client (WDSC), I ...

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

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

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