Serious storage condition may exist.
Our sys admin left the company and we are now getting this message CPF0907 Serious storage condition may exist. I’ve followed thru the menus and I’m still unsure of what needs to be done. I’m an operator and would apprecriate any help on this.

Answer Question   |  December 13, 2005  11:29 AM
AS/400

Anyone ever use the SNDRPY command in CL?
I am using the CHGPF command to change a file. I know it will result in data loss, and I will get a messaage that I must reply “I” to ignore and then it will change the file. The file is used all day long and I would like to have a CL program change [...]

Answer Question   |  December 14, 2005  4:56 PM
AS/400, CLP, DB2 Universal Database, RPG, RPGLE

ISeries Security
Is there a way to allow a user to change passwords for other users without giving them access to the entire user profile? We have a small shop, and I’d like to share this ability with some of our late night staff. However, I’m reluctant to give them the ability to change user type, special [...]

Answer Question   |  December 9, 2005  9:37 AM
AS/400

query 400 or Sequel statement for month
I have a field in AS400 called CSDATE that gives year and month in the following format: 200511 I want to create query statement to compare current year and month to select only those records from the same year, prior month. For example, I would run the report on December 1st 2005 and want to [...]

Answer Question   |  December 9, 2005  9:55 PM
AS/400, IBM

FTP error on site commands as400 to as400 transfer
I disribute files between a number of AS400′s. As part of the procedure I send a remote command to restore the files. The remote command stopped working. The time difference between the two transfers (successful and not) was 2 hours and in the middle of a busy work day. No changes were made to operating [...]

Answer Question   |  November 21, 2009  9:22 AM
AS/400, Networking

Special characters
I’ve got a situation where the users are entering characters into fields on the screen that I do not want them to enter. In COBOL, I can check these fields for alphabetic and numeric but I am under the impresion that this would not allow certain special characters that I do want to allow. Is [...]

Answer Question   |  December 8, 2005  4:35 PM
CLP, COBOL

Display OUTQ with
Is there any way I can display all my iSeries output queues with the corresponding autostart printers’ IP address? Thanks, Gerry

Answer Question   |  December 5, 2005  6:46 AM
AS/400, Networking

OS400 V5R3 and Domino/Lotus Notes
I am currently running a 170 on V5R1 and Lotus Notes 6.5. I want to upgrade to V5R3. Has anyone run into any issues with Lotus Notes 6.5 and V5R3? Or any issues with it during the upgrade process? Thanks! Bob

Answer Question   |  December 5, 2005  1:35 PM
AS/400, Lotus Domino, Platform Issues

iSeries any beyond
I’ll start by introducing myself and my background and then hopefully explain what information i’m looking for. I’m a COBOL developer for an insurance company based here in Ireland. I’d like to think of myself as been proficient at programming and at navigating my way around the AS/400. I have experience in other non-AS/400 languages, [...]

Answer Question   |  December 3, 2005  6:31 AM
AS/400, Data analysis, Database, DB2, Development, Oracle

Retrieve Job Lock (QWCRJBLK) thread ID
Does anyone know how I would get the thread ID of another job in order to retrieve the job lock info? This is the fifth parameter of QWCRJBLK. I will be using the QUSLOBJ API to retrieve all jobs on the system and then want to determine certain locks on those jobs. QUSLOBJ does not [...]

Answer Question   |  November 11, 2010  10:55 PM
AS/400, RPGLE

SET verb in COBOL
Hi The SET verb in COBOL set the value of a particular variable to a specified value. Now say I decalred a variable as 05 WS-SWITCH PIC X(01). 88 VALID-VALUES VALUE ‘A’, ‘B’, ‘C’. 88 NOT-VALID-VALUES VALUE ‘D’, ‘E’, ‘F’. If I want to set the value of WS-SWITCH as ‘A’, we can do as [...]

Answer Question   |  December 3, 2005  3:36 AM
AS/400, CLP, DB2 Universal Database, RPG, RPGLE

RPG/ILE re-entering workforce
I am 45 & want to re-enter workforce after 3 years out of IT. I used RPG for 15 years(not even ILE) and have BPCS experience. I have just picked up a couple of books (SQL and Free-format RPG) to study at home. I think it will be very difficult to get back in …. [...]

Answer Question   |  June 18, 2008  7:39 PM
RPG, RPG ILE, RPGLE, SQL

Moving spool files round the system
Hi, I’m trying to find an easy way of moving large quantities of spool files around our AS400. We are currently using a program called Mastermind but frankly I think its probably one of the worst pieces of software I’ve actually used. Could anyone give me some suggestions for an easy way of moving them [...]

Answer Question   |  November 11, 2010  11:40 PM
AS/400

What is correct syntax for SQL for Maxrecords in OS400/DB2?
What is correct syntax for SQL for Maxrecords in OS400/DB2? We have a process automatically generating SQL code. However, our iSeries doesn’t recognise the code it generates for maxrecords. Here are the examples of what I mean. The DB2 database seems happy with SELECT I1PHON,I1ACC,I1ACC1, FROM “TRNGDATA1″.”OICRT1″ FETCH FIRST 1 ROWS ONLY However the standard [...]

Answer Question   |  November 20, 2009  12:10 PM
AS/400, DB2 Universal Database, SQL Server

Utility to Print RPG Output Specs
Does anyone recall or use a utility that was used in “the old days” to print a listing of the O-specs in RPG II. The utility would review an RPG source member. It would then print a listing of what the output heading and detail lines would look like. It used “X”s and “9″s to [...]

Answer Question   |  November 20, 2009  12:23 PM
RPG, RPG ILE

System data area
Here’s one: How can I find the data specs for the SDS to be used in RPG? In my last shop, someone else had placed the specs in a PF so it was easy…

Answer Question   |  November 28, 2005  12:21 PM
AS/400

write in a PF file
Hi everyone! I have an RPGLE program that creates four physical files (using the QCMDEXC program). These physical files have no DDS. In the same program, I read another physical file (that’s a copy of a spool file). If the line (s) read met some specified criteria, it needs to be written to one of [...]

Answer Question   |  November 28, 2005  10:03 AM
CLP, RPG, RPG ILE, RPGLE

Setting a Network Printer to a Print Server, CRTDEVPRT
Hi,I need to CRTDEVPRT a network printer in AS/400. This *LAN printer is connected to a Server and I don’t wish to vary on the device all the time so I need to create a permanent on device everytime the AS/400 subsystem is up.I managed to create one device description but somehow everytime after I [...]

Answer Question   |  November 20, 2009  7:11 AM
AS/400

QSH error “find: 001-2191 The ending ‘;’ character was not found.”.
I have attempted to use two approaches (from postings on Search400) in order to clean up the IFS. Both of these use QSH. I have a problem in that both iSeries machines at my disposal ignore the “;” at the line end, and return the error “find: 001-2191 The ending ‘;’ character was not found.”. [...]

Answer Question   |  November 20, 2009  10:43 PM
AS/400, Linux, Software, Tech support

QSYS2/SYSCOLUMNS missing
When using ACCESS or EXCEL queries via ODBC to AS400 files (V5R1) I get an error “SYSCOLUMNS is missing” How can I rebuild it? Thanks

Answer Question   |  November 20, 2009  4:40 AM
AS/400