Tool list documentation -- V6R1M0       Date of last refresh -- Jan 15, 2010

Click the tool NAME (below) for a brief description of the tool. Click the definition for the full documentation.

Category *DBF -- Data base file

Tool Name Definition Date added 

ADDDATMBR

Add Date Member

October 15, 2008 

ADDDFTRCD

Add Default Record

June 1, 2002 

ADDSRCMBR

Add Source Member

May 1, 1996 

ADDUNQMBR

Add Unique Member

January 1, 2008 

ADPMBR

Adopt Member

May 1, 1996 

ALCDBF

Allocate Data Base File

April 1, 1995 

ALCTMPMBR

Allocate Temporary Member

April 1, 1995 

ANZFLD

Analyze Field

August 15, 2003 

BLDDBFOVR

Build DBF Override

August 1, 1998 

CHGDDMF2

Change DDM File 2

June 15, 2001 

CHGPF2

Change Physical File 2

December 1, 2004 

CHKALLDBD

Check All Data Base Dependencies

May 1, 1996 

CHKARAFLD

Check Area Code Field

April 15, 2006 

CHKBLKFLD

Check Blank Fields

May 15, 2008 

CHKBOF

Check Based on File

May 1, 1996 

CHKDBD

Check Data Base Dependencies

April 1, 1995 

CHKDBF

Check Data Base File

April 1, 1995 

CHKDBFDAT

Check Data Base File Date

February 1, 1997 

CHKDBFMBR

Check Data Base File Member

October 15, 2009 

CHKDUPAP

Check Duplicate Logical File

December 1, 2004 

CHKFILSRC

Check File Source

July 1, 1999 

CHKFLDSPE

Check Field Spelling

February 1, 1997 

CHKMBR2

Check Member Nbr 2

May 1, 1996 

CHKNAMFLD

Check Name Field

November 15, 2005 

CHKNAMFLD2

Check Name Field 2

September 15, 2006 

CHKOBJSRC

Check Object Source

February 1, 2001 

CLCDBFHSH

Calculate Data Base File Hash

December 15, 2002 

CLPDBR

CLP Data Base Record

September 1, 2004 

CLRALLPFM

Clear All Physical File Members

June 1, 1997 

CLRLFM

Clear Logical File Member

April 1, 1995 

CMPDBF

Compare Data Base File

April 1, 1995 

CMPDBFFMT

Compare Data Base Formats

August 1, 1998 

CMPDBF2

Compare Data Base File 2

January 1, 2008 

CMPLFD

Compare Logical File Description

July 1, 1999 

CMPLVLID

Compare Level ID

November 15, 2005 

CMPPFD

Compare Physical File Description

July 1, 1999 

CNFDLTRCD

Confirm Delete Record

April 15, 2009 

CPRDBF

Compress Data Base File

May 1, 1998 

CPRDLTRCD

Compress Deleted Records

September 15, 2000 

CPYCHGMBR

Copy Changed Members

April 1, 1995 

CPYDBFSRC

Copy Data Base Source

February 1, 2001 

CPYFOMIT

Copy File With Omit

July 15, 2006 

CPYFRMCSV

Copy From Comma Delimited File

April 15, 2009 

CPYNONGEN

Copy Non Generic

January 15, 2010 

CPYNULLFLD

Copy Null Fields

April 15, 2009 

CPYSHFLFT

Copy and Shift Left

February 15, 2006 

CPYSPLFDTA

Copy Spooled File Data

April 15, 2006 

CPYSPLF2

Copy Spooled File 2

May 1, 1997 

CPYSRCHDR

Copy Source Header

June 15, 2001 

CPYUNQKEY

Copy Unique Key Records

April 15, 2006 

CPYWTHDLT

Copy With Deleted Records

September 15, 2000 

CRTCLPDCL

Create CLP DCL

December 1, 2004 

CRTCLPEXT

Create CLP Extract

December 1, 2004 

CRTCLPINS

Create CLP Insert

December 1, 2004 

CRTDBFJRN

Create DBF with Journal Fields

November 15, 1999 

CRTDUPPF

Create Duplicate Physical File

May 1, 1996 

CRTLFSRC

Create Logical File Source

May 1, 1996 

CRTPRTPGM

Create Print Program

April 1, 1995 

CRTSFLPGM

Create Subfile Program

August 15, 2005 

CRTSFLPGM2

Create Subfile Program 2

November 15, 2005 

CRTTSTDTA

Create Test Data

September 15, 2007 

CRTXREFLF

Create QADBXREF File

March 1, 1998 

CVTALLDBD

Convert All Data Base Dependencies

March 15, 2003 

CVTDBFFMT

Convert Data Base File Format

May 1, 1996 

CVTDLTSPC

Convert Deleted Space

December 15, 2002 

CVTFD

Convert File Description

October 15, 2003 

CVTFMT

Convert File Format

August 1, 1998 

CVTJRNDBF

Convert Journaled Data Base Files

February 28, 2000 

CVTLFMD

Convert Logical File Member Description

December 1, 2004 

CVTLIBDBF

Convert Library Data Base Files

May 1, 1996 

CVTMBRD

Convert Member Description

February 28, 2000 

CVTMBRLST

Convert Member List

April 23, 2001 

CVTPCKFLD

Convert Packed Field

August 1, 1997 

CVTRCDLCK2

Convert Record Locks 2

February 1, 2001 

CVTTAAFMT

Convert TAA Format

June 15, 2001 

DLTDBFRCD

Delete Data Base Records

February 28, 2000 

DLTDEPLGL

Delete Dependent Logical Files

April 1, 1995 

DLTDUPRCD

Delete Duplicate Records

June 15, 2004 

DMOVALKEY

Key Validation

August 1, 1998 

DSPACCPTH

Display Access Path

May 1, 1996 

DSPBOF

Display Based On File

March 21, 2008 

DSPCCSID

Display File CCSIDs

April 15, 2006 

DSPDB

Display Data Base

April 1, 1995 

DSPDBF

Display Data Base File

April 1, 1995 

DSPDBFA

Display Data Base File Attributes

November 15, 1999 

DSPDBFALW

Display Data Base File Allow Functions

October 15, 2008 

DSPDBFDTA

Display DB File Data

February 1, 1997 

DSPDBFKEY

Display Data Base File by Key

June 30, 2007 

DSPDBFREL

Display Data Base File Relations

May 1, 1996 

DSPDBFSTAT

Display Data Base File Statistics

September 15, 2006 

DSPDFTRCD

Display Default Records

January 1, 2007 

DSPDLTSPC

Display Deleted Space

December 15, 2002 

DSPDTATYP

Display Data Types - DSPDTATYP

February 28, 2000 

DSPDUPFLD

Display Duplicate Field

March 31, 2004 

DSPEMTMBR

Display Empty Members

October 15, 2009 

DSPFLDA

Display Field Attributes

May 1, 1996 

DSPFMT

Display Format

May 1, 1996 

DSPF2

Display File 2

May 1, 1996 

DSPLFMD

Display Logical File Member Description

September 1, 2004 

DSPMBRCPC

Display Member Capacity

October 15, 2008 

DSPMBRD

Display Member Description

April 1, 1995 

DSPMBRLST

Display Member List

March 31, 2004 

DSPMBRS

Display Members

May 1, 1996 

DSPMBRSTAT

Display Member Statistics

February 28, 2000 

DSPMLTFMT

Display Multi-Format Files

October 15, 2008 

DSPOUTFILE

Display Outfile

January 1, 1998 

DSPRCDLCK2

Display Record Locks 2

February 1, 2001 

DSPSELOMT

Display Select Omit

September 15, 2007 

DSPSRCMBRS

Display Source Members

February 1, 2005 

DTAARC

Data Archive

April 15, 2006 

DUPDBN

Duplicate Data Base Network

May 1, 1996 

DUPFILFMT

Duplicate File Format

April 1, 1995 

EDTDBF

Edit Data Base File

February 28, 2000 

FIXDBFFLD

Fix Data Base Field

January 15, 2009 

FIXDECERR

Fix Decimal Errors

September 15, 2007 

FNDRNMRSTF

Find Renamed Restore File

June 1, 2005 

FNDRNMRSTM

Find Renamed Restore Members

November 15, 2005 

GNLDBF

General Data Base File

August 1, 1996 

LOCKMSG

Producing a Message on a Locked Record

April 1, 1995 

MOVM

Move Member

April 1, 1995 

PMTFLD

Prompt Field

December 1, 1996 

PRTDB

Print Data Base File

May 1, 1997 

PRTDBFANL

Print Data Base File Analysis

April 1, 1995 

PRTDBFEXP

Print Data Base File Exceptions

April 1, 1995 

PRTDBFSIZ

Print Data Base File Size

February 28, 2000 

PRTDLTRCD

Print Deleted Record Numbers

April 1, 1995 

PRTLVLCHK

Print Level Check

August 1, 1998 

PRTMBRSUM

Print Member Summary

February 15, 2006 

QRYUSE

Query Use

March 15, 2002 

RBLDBF

Rebuild Data Base File

April 1, 1995 

RGZALLPFM

Reorganize All PFM

November 1, 1997 

RGZLIB

Reorganize Library

August 1, 1997 

RMVALLLFM

Remove All Logical File Members

May 1, 1996 

RMVEMTMBR

Remove Empty Members

October 15, 2009 

RMVM2

Remove Member 2

May 1, 1996 

RMVOLDMBR

Remove Old Member

July 1, 1998 

RMVOLDMBR2

Remove Old Member 2

July 1, 1998 

RPLLF

Replace Logical File

April 1, 1995 

RPLPF

Replace Physical File

April 1, 1995 

RSTFIL

Restore File

April 1, 1995 

RTVCCSID

Retrieve File CCSID

April 15, 2006 

RTVCURMBR

Retrieve Current Member

January 15, 2004 

RTVDBFA

Retrieve Data Base Attributes

April 1, 1995 

RTVDBFM

Retrieve Library Data Base File Members

September 15, 2006 

RTVDBFOVR

Retrieve Data Base Overrides

July 15, 2006 

RTVDBFRR

Retrieve Data Base File by Relative Record

January 1, 2007 

RTVDBR

Retrieve Data Base Relations

February 28, 2000 

RTVDLTRCD

Retrieve Deleted Records

April 1, 1995 

RTVDTATYPD

Retrieve Data Type Description

August 15, 2001 

RTVFLDA

Retrieve Field Attributes

May 1, 1996 

RTVFLDARR

Retrieve Field Array

May 1, 1996 

RTVFMT

Retrieve Format

January 1, 1998 

RTVGENMBR

Retrieve Generic Member

April 1, 1995 

RTVKEYLST

Retrieve Key List

February 28, 2000 

RTVLFA

Retrieve Logical File Attributes

April 1, 1995 

RTVLFMD

Retrieve Logical File Member Description

September 1, 2004 

RTVLFSRC

Retrieve Logical File Source

July 15, 2009 

RTVLIBSRCF

Retrieve Library Source Files

March 1, 1999 

RTVLSTCHG

Retrieve Last Change

April 1, 1995 

RTVMBRD2

Retrieve Member Description 2

June 1, 2002 

RTVMBRD3

Retrieve Member Description 3

June 1, 2005 

RTVMBRLST

Retrieve Member List

August 1, 1996 

RTVMBRLST2

Retrieve Member List 2

August 1, 1996 

RTVMBRSTAT

Retrieve Member Statistics

February 28, 2000 

RTVMBRSUM

Retrieve Member Summary

August 15, 2005 

RTVPFA

Retrieve Physical File Attributes

April 1, 1995 

RTVPFJRNA

Retrieve Physical File Journal Attributes

May 1, 1996 

RTVPFSRC

Retrieve PF Source

April 1, 1995 

RTVRCDLCK2

Retrieve Record Lock 2

February 1, 2001 

SAVDBDLF

Save DBD LFs

August 15, 2005 

SAVICHDTA

Save Interchange Data

April 1, 1995 

SAVSNDM

Save Send Member with FTP

January 1, 2007 

SCNACCPTH

Scan Access Path

October 1, 1996 

SCNDBFFLD

Scan Data Base Field

January 15, 2010 

SCNDBFLEN

Scan Data Base Record Length

September 15, 2002 

SCNDTA

Scan Data

June 1, 1997 

SCNDUPRCD

Scan Duplicate Records

August 1, 1998 

SCNFLDTYP

Scan DBF Field Type

September 15, 2002 

SCNLFA

Scan Logical File Attributes

July 15, 2009 

SCNOPNQRYF

Scan for OPNQRYF

October 1, 1996 

SCNPFA

Scan Physical File Attributes

July 15, 2009 

SCNUPDDTA

Scan and Update Data

June 1, 1997 

SELDBF

Select Data Base File

March 15, 2002 

SELMBR

Select Data Base Member

March 15, 2002 

SORTDB

Sort Data Base File

April 1, 1995 

SORTDBF

Sort Data Base File

March 15, 2002 

SORTDB2

Sort Data Base 2

August 1, 1998 

STRKEY

Start Key

April 1, 1995 

TRNDLTRCD

Truncate Deleted Records

September 15, 2000 

UPDFLD

Update Field

April 1, 1995 

UPDPFILE

Update PFILE DDS Source

August 1, 1998 

VALDBF

Validate Data Base File

April 1, 1995 

WRKF2

Work File 2

September 15, 2002 

WRKMBRS

Work Members

September 15, 2002 

WRTDBF

Write Data Base File

April 1, 1995 


Home Page Return to Category List Up to Top

Powered by AS/400Powered by AS/400 Last modified on January 12, 2010 © 1995, 2010 - Jim Sloan, Inc.