DBG/400 Latest News Updated Debian on the server only to find it broke something in Foswiki :( I have the same combination of Debian Wheezy and Foswiki 1.1.9 working ...
Running HMC commands from the System i Background We've just upgraded to a System i 550 with an HMC (Hardware Management Console). One of the things this lets us ...
Run Program Trace/Print Program Trace Details Tracks all executed statements when a program is run, and prints an indented listing of the source showing how many ...
.********************************************************************** .* MOVOUTQ: Help text for Move output queue .* Copyright (C) 2001 Martin Rowe .* .* This ...
************************************************************************ * DBGFMT00: Field Mapping Table for .csv field conversion * Copyright (C) 2001 Martin ...
/******************************************************************************/ /* Copyright (c) Tom Liotta http://zap.to/tl400 Used with permission */ ...
Wetherby Linux User Group Are you a Linux user based in or around Wetherby? Would you be interested in forming/joining a local LUG for Wetherby? I've been going to ...
Ubuntu Linux on a Hewlett Packard Pavilion dv1000 (dv1066ea) notebook The HP dv1066ea notebook This page is left here as a historical reference only. The dv1066 ...
******************************************************************************************** * DBG186R4: Work with user outqueue/spoolfile * Copyright (C) 2000 ...
******************************************************************************************** * DBG103R4: Maintain script entries in DB link file * Copyright ...
************************************************************************ * DBG041R4: Format text lines parse line into words. * Copyright (C) 2000 Martin ...
************************************************************************ * DBG040R3: Format text lines with limited word wrapping. * Copyright (C) 2000 ...
Privacy Policy What information is collected Apache server logs. IP addresses and the name they resolve to, if any, are probably the only sensitive information. ...
.********************************************************************** .* EDTFLDMAP: Help text for Edit Field Mapping rules .* Copyright (C) 2001 Martin Rowe ...
.********************************************************************** .* CRTCSVDTA: Help text for Create .csv Data .* Copyright (C) 2001 Martin Rowe .* .* This ...
DBG/400 News 2005 On Wednesday I added some more RAM to this server but the graphics card died in the process :( I ordered a replacement off eBay (a Matrox Millenium ...
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 ...
************************************************************************ * DBGSQLK2: Logical over Document Keyword Index * Copyright (C) 2000 Martin Rowe ...
************************************************************************ * DBGDFTK2: Logical over Document Keyword Index * Copyright (C) 2000 Martin Rowe ...
CRTCSVDTA Create .csv data from iSeries files Details EDTFLDMAP, CRTCSVDTA CRTCSVSTMF These three commands should help you create .csv files from any iSeries i5 ...
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 ...
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 ...
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 ...
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 ...
.********************************************************************** .* CVTNULFLD: Help text for Convert Null to non null defaults .* Copyright (C) 2002 Martin ...
************************************************************************ * DBGOLDK1: Logical over Document Keyword Index * Copyright (C) 2000 Martin Rowe ...
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 ...
Example code for using the List Job Schedule Entries (QWCLSCDE) API ************************************************************************************** ...
************************************************************************ * DBG045R3: Send Non Program Message (frontend to QMHSNDM API) * Copyright ...
.********************************************************************** .* DBG020PG: Help text for Edit text document .* Copyright (C) 2000 Martin Rowe .* .* This ...
DBG/400 Latest News Upgraded TWiki to the latest version 4.2.1 which was released on the 3rd Aug Main.MartinRowe 05 Aug 2008 Upgraded TWiki to the latest version ...
Editing iSeries source members with the Vim text editor Why Vim Because I like it :) Back when I used Windows I used the excellent TextPad editor, but it didn't work ...
Installation instructions SRCPARSER packaged code The full code is distributed in just two files. SRCPARSER.MBR is CL code that creates all the required source physical ...
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 ...
Progress Meter pseudo graphical display of progress for 5250 screens. Details for DBG202R4 This simple program generates something to look at while your routine ...
RPGLE Source Members * DBG005R4 Work with on line documents * DBG006R4 Rebuild index for selected document * DBG010R4 Display Document text * DBG015R4 ...
RPG Source Members * DBG020R3 Display Document text * DBG040R3 Format text lines limited word wrapping * DBG042R3 Merge data lines:map parm 1 onto parm ...
DDS Source Members * CCHGPWD01D Change password 8x20 hand held scanner version * DBGDEP01 System Cross Reference Dependancies by logical * DBGDFTD0 Document ...
This is a subscription service to be automatically notified by e mail when topics change in this DBG400 web. This is a convenient service, so you do not have to come ...
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 ...
This page is obsolete... This page used to host a mirrored download of a Debian virtual machine running TWiki 4.0.4 (by now a very old, and insecure, version). I ...
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 ...
Ubuntu packages for x5250 These Ubuntu .debs have been built using checkinstall after building x5250 from source (on 9.04 Jaunty systems). Installation instructions ...
ATOM News Feeds Find out What's New There are several ways to find out what's new in each web: 1. Visit WebChanges to see recent changes 1. Subscribed in WebNotify ...
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 ...
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 ...
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 ...
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 ...
DBG/400 News 2006 There have been a number of changes to the site, principally to move content from the old static site into the wiki. That's given me the chance to ...
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 ...
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 ...
UNDEL2 Undelete records from an iSeries file User state UNDEL2 (2.0.4) utility available Dave McKenzie has released a new version of his UNDEL utility: The user state ...
Ubuntu Linux on a Dell Inspiron 6400n Notebook The Inspiron 6400n Notebook My son's ageing, second hand, Inspiron 2650 had been having graphics problems for a while ...
.********************************************************************** .* CHGOUTQSPL: Help text for Change OUTQ spoolfiles by CMD parm . Copyright (C) 2006 Martin ...
PNLGRP Source Members * ACTOUTQ Help text for Action Output Queue Spoolfiles * CHGOUTQSPL Helptext for Change *OUTQ spool files by CMD parm * CRTCSVDTA Help ...
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 ...
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 ...
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 ...
WRKUSROUTQ A WRKSPLF/WRKOUTQ hybrid with extra functions Details WRKUSROUTQ lets you work with spool files across multiple output queues and users, filtering the ...
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 ...
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 ...
Code Samples This page links to various examples code programs I've posted, as a response to mailing list postings (to lists such as Midrange L and RPG L). It's ...
These links contain all the source code used by my utilities. I may pull in the static page content for each command and create a cross reference listing all the code ...
/******************************************************************************/ /* Copyright (c) Tom Liotta http://zap.to/tl400 Used with permission */ ...
*/ /* / / 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 ...
*/ /* / / 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: Help text for Execute SQL statement .* Copyright (C) 2001 Martin Rowe .* .* This ...
.********************************************************************** .* DLTOUTQSPL: Help text for Delete Output Queue Spoolfiles .* Copyright (C) 2003 Martin Rowe ...
.********************************************************************** .* DBG030PG: Help text for View text document .* Copyright (C) 2000 Martin Rowe .* .* This ...
.********************************************************************** .* CRTCSVSTMF: Help text for Create .csv Streamfile .* Copyright (C) 2001 Martin Rowe . ...
/* **********************************************************************/ / DBG046CL: Create duplicate object from first occurence in library list / / ...
************************************************************************ * DBGSQLK1: Logical over Document Keyword Index * Copyright (C) 2000 Martin Rowe ...
************************************************************************ * DBGOLDK2: Logical over Document Keyword Index * Copyright (C) 2000 Martin Rowe ...
************************************************************************ * DBGDFTK1: Logical over Document Keyword Index * Copyright (C) 2000 Martin Rowe ...
************************************************************************ * DBG043R3: Character to Number conversion * Copyright (C) 2000 Martin Rowe ...
******************************************************************************************** * SETHLPTXT: Upload helptext to On Line document files * Copyright ...
******************************************************************************************** * GETHLPTXT: Download helptext from On Line document files * Copyright ...
******************************************************************************************** * DBG201R4: Copy to field delimited format (.csv) * Copyright ...
******************************************************************************************** * DBG188R4: Retrieve spoolfile info by User Profile or #OUTQ * ...