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 |