ACTOUTQ Action output queue Details This is a companion utility to MOVOUTQ that lets you release, hold, save and delete spooled files on an output queue, based on ...

Example code for using the List Job Schedule Entries (QWCLSCDE) API ...

BLDLIBINFO Build library information database Details Running a DSPLIB to ! PRINT is a handy way of getting the total size of a library but there isn't an ! OUTFILE ...

Message Break Handling Program Details The basic function is to execute commands on behalf of a user when requested by helpdesk/support staff. It's handy when you ...

CHGOUTQSPL Apply CHGSPLA parms to selected spooled files Details CHGOUTQSPL allows you to select spooled files on an output queue and run a CHGSPLFA on each matching ...

CHKEVALS Check EVAL statements for potential MCH1210 errors Details CHKEVALS analyses RPGLE source code, checking EVAL statements for potential MCH1210 errors (receiver ...

CHKLVLCHK Check Level Checks Details CHKLVLCHK is a routine I wrote around 1994 to save a lot of time and headaches. We had been working on changes to some of our ...

CHKTMPSTG Check temporary storage used by active jobs on the system Details CHKTMPSTG displays a list of jobs using temporary storage over a preset threshold. Handy ...

/ / / DBG005CL: Work with On Line Documents / / Copyright (C) 2000 Martin Rowe / / ...

/ / / DBG010CL: Get program text for On Line Document heading / / Copyright (C) 2000 Martin Rowe / / ...

MartinRowe 24 Jun 2005

/ / / DBG046CL: Create duplicate object from first occurence in library list / / Copyright (C) 2000 Martin Rowe / / ...

/ / / DBG102CL: Execute database generation scripts / / Copyright (C) 2000 Martin Rowe / / ...

/ / / DBG103CL: Copy subset of files records / / Copyright (C) 2000 Martin Rowe / / ...

/ / / DBG104CL: Get member size number of records / / Copyright (C) 2000 Martin Rowe / / ...

/ / / DBG105CL: Select field from a file / / Copyright (C) 2000 Martin Rowe / / ...

/ / / DBG106CL: Create database generation scripts / / Copyright (C) 2000 Martin Rowe / / ...

/ / / DBG107CL: CRTDBGSCP Validity Check pgm / / Copyright (C) 2000 Martin Rowe / / ...

/ / / DBG108CL: Create program file set / / Copyright (C) 2000 Martin Rowe / / ...

/ / / DBG109CL: Check program referenced object (CRTPGMFSET) / / Copyright (C) 2000 Martin Rowe / / ...

/ / / DBG110CL: Menu for all the DBG utilities / / Copyright (C) 2000 Martin Rowe / / ...

/ / / DBG112CL: Edit database generation scripts / / Copyright (C) 2000 Martin Rowe / / ...

/ / / DBG114CL: Execute database generation scripts / / Copyright (C) 2000 Martin Rowe / / ...

/ / / DBG186CL: WRKUSROUTQ CPP Work with User Outque / / Copyright (C) 2000 Martin Rowe / / ...

/ / / DBG187CL: WRKUSROUTQ Screen option processor / / Copyright (C) 2000 Martin Rowe / / ...

/ / / DBG193CL: Purge output queue of old spoolfiles / / Copyright (C) 2000 Martin Rowe / / ...

/ / / DBG194CL: Move output queue / / Copyright (C) 2001 Martin Rowe / / ...

/ / / DBG196CL: Delete spoolfiles from output queue / / Copyright (C) 2001 Martin Rowe / / ...

/ / / DBG197CL: Action spoolfiles on output queue (Release/Hold/Save/Delete) / / Copyright (C) 2003 Martin Rowe / / ...

/ / / DBG198CL: Change outq spoolfiles by CMD parms / / Copyright (C) 2006 Martin Rowe / / ...

/ / / DBG200CL: Field Mapping Selection / / Copyright (C) 2001 Martin Rowe / / ...

/ / / DBG201CL: External to flat file .csv conversion / / Copyright (C) 2001 Martin Rowe / / ...

/ / / DBG203CL: Create .csv Streamfile / / Copyright (C) 2001 Martin Rowe / / ...

/ / / DBG204CL: Convert null fields to non null defaults / / Copyright (C) 2002 Martin Rowe / / ...

/ / / DBG205CL: DASD monitor (disk temp storage use) / / Copyright (C) 2003 Martin Rowe / / ...

/ / / DBG206CL: MSGQ break handling pgm for DASDMON / / Copyright (C) 2003 Martin Rowe / / ...

/ / / DBG207CL: End DASD Monitor / / Copyright (C) 2003 Martin Rowe / / ...

/ / / EXCSQL: Execute SQL request / / Copyright (C) 2001 Martin Rowe / / ...

PGM PARM( SYSTEM03 SYSTEM04) DCL VAR( SYSTEM03) TYPE( CHAR) LEN(10) ...

/ / / Program: GETHDWRSC / / Title: Get hardware resource ...

/ / / GETHLPTXTC: Download helptext from On Line Document system / / Copyright (C) 2000 Martin Rowe / / ...

/ / / MAKECRTCSV: Make all required CRTCSVDTA utility objects / / Copyright (C) 2001 Martin Rowe / / ...

/ / / MAKEDBG: Make all required DBG objects / / Copyright (C) 2000 Martin Rowe / / ...

/ / / MAKEDBGSPL: Make all required DBG WRKUSROUTQ utility objects / / Copyright (C) 2000 Martin Rowe / / ...

/ / / MAKEDBGTDY: Make all required DBG TDYPGMFSET utility objects / / Copyright (C) 2000 Martin Rowe / / ...

/ / / MAKEPRGOUT: Make all required PRGOUTQ utility objects / / Copyright (C) 2001 Martin Rowe / / ...

/ / / Copyright (c) Tom Liotta http://zap.to/tl400 Used with permission / / ...

/ / / SRCPARSER: Parse source members from single member / / Copyright (C) 2000 Martin Rowe / / ...

CL Source Members Member Description DBG005CL Work with on line documents CPP DBG010CL Get program text (for document heading) DBG045CL Remove ...

Clam Anti Virus on IBM iSeries using PASE Introduction Who should read this HOWTO This HOWTO is intended for anyone interested in installing and using the free ClamAV ...

CHGAUTDRAW This CL program runs as a background task on our iSeries monitoring for new streamfiles created by a specific user in a specific IFS directory. As new files ...

/ / / ACT0UTQ: Delete/Hold/Release/Save output queue spooled files / / Copyright (C) 2003 Martin Rowe / / ...

/ / / CHG0UTQSPL: Change output queue spooled files by CMD parms / / Copyright (C) 2006 Martin Rowe / / ...

/ / / CRTCSVDTA: Create .csv data file from AS/400 database member / / Copyright (C) 2000 Martin Rowe / / ...

/ / / CRTCSVSTMF: Create .csv Streamfile / / Copyright (C) 2001 Martin Rowe / / ...

/ / / CRTDBGSCP: Create database generation scripts / / Copyright (C) 2000 Martin Rowe / / ...

/ / / CRTPGMFSET: Create program's file set / / Copyright (C) 2000 Martin Rowe / / ...

/ / / CRTNULFLD: Convert null fields to non null defaults / / Copyright (C) 2002 Martin Rowe / / ...

/ / / DBG: DataBase Generation commands / / Copyright (C) 2000 Martin Rowe / / ...

/ / / DLT0UTQSPL: Delete output queue spooled files / / Copyright (C) 2003 Martin Rowe / / ...

/ / / / This program is free software; you can redistribute it and/or modify / / it under the terms of the GNU General Public License as published by ...

/ / / EDTDBGSCP: Edit DataBase Generation scripts / / Copyright (C) 2000 Martin Rowe / / ...

/ / / EDTFLDMAP: Edit field mapping / / Copyright (C) 2001 Martin Rowe / / ...

/ / / ENDDASDMON: End DASD Monitor / / Copyright (C) 2003 Martin Rowe / / ...

/ / / / This program is free software; you can redistribute it and/or modify / / it under the terms of the GNU General Public License as published by ...

/ / / EXCSQL: Execute SQL request / / Copyright (C) 2001 Martin Rowe / / ...

CMD PROMPT('Find tape drive') PARM KWD(SYSTEM03) TYPE( SNAME) LEN(10) PROMPT('Name of system with slot ...

/ / / Copyright (c) Tom Liotta http://zap.to/tl400 Used with permission / / ...

CMD PROMPT('Move 3583 tape drive to LPAR') PARM KWD(LPAR) TYPE( SNAME) LEN(10) RSTD( YES) VALUES(SYS01 SYS02 ...

/ / / MOVOUTQ: Move output queue / / Copyright (C) 2001 Martin Rowe / / ...

/ / / PRGOUTQ: Purge output queue of old spoolfiles / / Copyright (C) 2000 Martin Rowe / / ...

/ / / Copyright (c) Tom Liotta http://zap.to/tl400 Used with permission / / ...

/ / / Copyright (c) Tom Liotta http://zap.to/tl400 Used with permission / / ...

/ / / STRDASDMON: DASD monitor (disk temp storage use) / / Copyright (C) 2003 Martin Rowe / / ...

CMD Source Members Member Description ACTOUTQ Action output queue spooled files RLS/HLD/DLT/SAV CHGOUTQSPL Change output queue spooled files by ...

/ / / WRKOLD: Work with on line documents / / Copyright (C) 2000 Martin Rowe / / ...

/ / / WRKUSROUTQ: Work with user OUTQ/spoolfiles / / Copyright (C) 2000 Martin Rowe / / ...

Code Samples This page links to various examples code programs I've posted, as a response to mailing list postings (to lists such as and RPG L). It's a wiki fied ...

CRTCSVDTA Create .csv data from iSeries files Details EDTFLDMAP, CRTCSVDTA CRTCSVSTMF These three commands should help you create .csv files from any iSeries i5 ...

CvtNulFld Convert Null fields Details CvtNulFld Convert Null fields. This utility was designed to work with my CRTCSVDTA tool which cannot (yet) handle null capable ...

DASDMON a background disk temporary storage monitor Details DASDMON is run as a background job that monitors system DASD, and temporary storage used by active jobs ...

DataBase Generation Details What is it? DBG/400 is a collection of integrated utilities that help in setting up a test environment with any required files and data ...

DDS Source Members DBGDEP01 System Cross Reference Dependancies by logical DBGDFTD0 Document Formatted Text DBGDFTD1 Document Formatted Text: Document ...

DBG/400 downloads Individual utilities You'll find all of the downloads linked to from the individual utility pages which includes the relevant Installation instructions ...

DBG005DF: Work with on line documents Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBG020DF: Screen for edit text utility Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBG030DF: Display Document text Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBG100DF: Maintain database generation links Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or ...

DBG100DF: Maintain database generation links Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or ...

DBG110DF: Menu for DBG utilities Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBG186DF: Work with User Output queues Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

A %%TS SD 20010223 145932 MROWE REL V4R4M0 5769 PW1 A A DBG200DF: Select ...

Editing iSeries source members with the Vim text editor Why Vim Because I like it :) Back when I used Windows I used the excellent editor, but it didn't work very ...

EMS Electronic Message System Details A single machine messaging system that's a bit more user friendly than SNDMSG/DSPMSG. Users can send, reply, copy delete messages ...

EXCSQL Execute SQL Statements Details EXCSQL a command to run SQL statements. This relies on Query Management Queries rather than IBM's Interactive STRSQL utility ...

Feedback I've received a number of emails from people who've found either a utility or information on this site that has been useful. So far people from around 20 ...

GETMSGD Get Message Descriptions Details GETMSGD generates a CLP member with code to recreate all the messages in a message file. It's how I put the messages into ...

DBG/400 Free software for the AS/400 / iSeries / System i This is the home page for my DataBase Generation utilities, aka DBG/400. News You'll find the latest news ...

Installation instructions SRCPARSER packaged code The full code is distributed in just two files. MBR is CL code that creates all the required source physical files ...

DBG1861W: List of spool files Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBGDEP01: System Cross Reference Dependancies by logical Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute ...

DBGDFTD1: Logical over Document Text Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBGDFTD2: Logical over Document Text Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBGDFTH1: Logical over Document Index Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBGDFTK1: Logical over Document Keyword Index Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and ...

DBGDFTK2: Logical over Document Keyword Index Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and ...

DBGDPRO1: Logical over DSPPGMREF OUTFILE Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBGDPRO2: Logical over DSPPGMREF OUTFILE Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBGOLDD1: Logical over Document Text Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBGOLDH1: Logical over Document Index Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBGOLDK1: Logical over Document Keyword Index Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and ...

DBGOLDK2: Logical over Document Keyword Index Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and ...

DBGSQLD1: Logical over Document Text Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBGSQLH1: Logical over Document Index Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBGSQLK1: Logical over Document Keyword Index Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and ...

DBGSQLK2: Logical over Document Keyword Index Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and ...

Links Reciprocal links These are all sites that have kindly included links to here Jack Woehr's www.well.com/~jax/rcfb/as400.html RCFB site. Among other things ...

MOVOUTQ Move selected spooled files from one output queue to another Details MOVOUTQ is designed to make moving spoolfiles around much easier. You can use the standard ...

Netshare400 I used to have a free account with Netshare400, courtesy of the site's owner John Ross. It's there that I tested and packaged most my utilities, as well ...

DBG/400 Latest News Upgraded TWiki to the latest version 4.2.0 which was released on the 22nd Jan MartinRowe 24 Jan 2008 Apologies for the site outage for the ...

DBG1860W: List of spool files Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBGDFTD0: Document Text Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify it under ...

DBGDFTH0: Document Index Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify it ...

DBGDFTK0: Document Keyword Index Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBGDGL00: Database generation links Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBGDPRO0: OUTFILE for DSPPGMREF command Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBGFMT00: Field Mapping Table for .csv field conversion Copyright (C) 2001 Martin Rowe This program is free software; you can redistribute ...

DBGOLD0W: Document Index Workfile Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBGOLDD0: Document Text Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify it under ...

DBGOLDH0: Document Index Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify it ...

DBGOLDK0: Document Keyword Index Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBGSQLD0: Document Text Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify it under ...

DBGSQLH0: Document Index Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify it ...

DBGSQLK0: Document Keyword Index Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBGUOL00: WRKUSROUTQ User OUTQ list Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBGWUS00: WRKUSROUTQ User settings Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

. . ACTOUTQ: Help text for Action Output Queue Spoolfiles . Copyright (C) 2003 Martin Rowe . . This program is free software; you can redistribute it and/or ...

. . CHGOUTQSPL: Help text for Change OUTQ spoolfiles by CMD parm . Copyright (C) 2006 Martin Rowe . . This program is free software; you can redistribute ...

. . CRTCSVDTA: Help text for Create .csv Data . Copyright (C) 2001 Martin Rowe . . This program is free software; you can redistribute it and/or modify . ...

. . CRTCSVSTMF: Help text for Create .csv Streamfile . Copyright (C) 2001 Martin Rowe . . This program is free software; you can redistribute it and/or modify ...

. . CVTNULFLD: Help text for Convert Null to non null defaults . Copyright (C) 2002 Martin Rowe . . This program is free software; you can redistribute it ...

. . DBG020PG: Help text for Edit text document . Copyright (C) 2000 Martin Rowe . . This program is free software; you can redistribute it and/or modify . ...

. . DBG030PG: Help text for View text document . Copyright (C) 2000 Martin Rowe . . This program is free software; you can redistribute it and/or modify . ...

. . DLTOUTQSPL: Help text for Delete Output Queue Spoolfiles . Copyright (C) 2003 Martin Rowe . . This program is free software; you can redistribute it and ...

. . EDTFLDMAP: Help text for Edit Field Mapping rules . Copyright (C) 2001 Martin Rowe . . This program is free software; you can redistribute it and/or modify ...

. . EXCSQL: Help text for Execute SQL statement . Copyright (C) 2001 Martin Rowe . . This program is free software; you can redistribute it and/or modify ...

. . MOVOUTQ: Help text for Move output queue . Copyright (C) 2001 Martin Rowe . . This program is free software; you can redistribute it and/or modify . it ...

. . PRGOUTQ: Help text for Purge output queue . Copyright (C) 2001 Martin Rowe . . This program is free software; you can redistribute it and/or modify . ...

PNLGRP Source Members ACTOUTQ Help text for Action Output Queue Spoolfiles CHGOUTQSPL Helptext for Change OUTQ spool files by CMD parm CRTCSVDTA Help ...

PRGOUTQ Purge an Output Queue of old spooled files Details PRGOUTQ is a simple purge old spooled files command. You specify an output queue and the number of days ...

Privacy Policy What information is collected Apache server logs. IP addresses and the name they resolve to, if any, arew probably the only sensitive information. ...

Progress Meter pseudo graphical display of progress for 5250 screens. Details for DBG202R4 This simple program generates something to look at while your routine ...

DBG015PF: Display Documement Text Printout Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or ...

DBG020R3: Display/edit document text Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBG040R3: Format text lines with limited word wrapping. Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute ...

DBG042R3: Merge Data Lines Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBG043R3: Character to Number conversion Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute it and/or modify ...

DBG044R3: Send Program Message (frontend to QMHSNDPM API) Copyright (C) 2000 Martin Rowe This program is free software; you can redistribute ...

DBG045R3: Send Non Program Message (frontend to QMHSNDM API) Copyright (C) 1993, 2003 Martin Rowe ...

RPG Source Members DBG020R3 Display Do