| Category *DBF -- Data base file |
| Tool Name |
Definition |
Date Added |
| ACTDLTRCD |
Activate Deleted Relative Record Number |
January 15, 2013 |
| ADDDATMBR |
Add Date Member |
October 15, 2008 |
| ADDDFTRCD |
Add Default Record |
June 1, 2002 |
| ADDINZRCD |
Add Initialized Record |
January 15, 2013 |
| 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 |
| CHGDBFDAT |
Change Data Base File Date |
April 15, 2011 |
| CHGDBFINC |
Change Data Base Increments |
October 15, 2013 |
| CHGDDMF2 |
Change DDM File 2 - Multiple DDM Files |
June 15, 2001 |
| CHGDSPOBJO |
Change DSPOBJD Outfile |
April 15, 2011 |
| CHGLF2 |
Change Logical File 2 - Multiple Logical Files |
October 15, 2013 |
| CHGMAXMBR |
Change Maximum Members |
January 15, 2014 |
| CHGPF2 |
Change Physical File 2 - Multiple Physical Files |
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 |
April 15, 2013 |
| CHKFMT |
Check Format |
January 15, 2011 |
| CHKMBRSPE |
Check Member Spelling |
October 15, 2013 |
| CHKMBR2 |
Check Member 2 - Escape Message If Found |
May 1, 1996 |
| CHKMLTMBR |
Check Multiple Members |
April 15, 2013 |
| CHKNAMFLD |
Check Name Field - Names in a File |
November 15, 2005 |
| CHKNAMFLD2 |
Check Name Field 2 - Checks Input Value |
September 15, 2006 |
| CHKOBJSRC |
Check Object Source |
February 1, 2001 |
| CHK1STMBR |
Check 1st Member |
July 15, 2012 |
| 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 |
| CLRGENMBR |
Clear Generic Members |
April 15, 2011 |
| CLRLFM |
Clear Logical File Member |
April 1, 1995 |
| CMPDBF |
Compare Data Base File - Comp 2 Members by RR |
April 1, 1995 |
| CMPDBFFMT |
Compare Data Base Formats |
August 1, 1998 |
| CMPDBF2 |
Compare Data Base File 2 - Comp Unique Key |
January 1, 2008 |
| CMPDBF3 |
Compare Data Base File 3 - Comp 2 Members by Value |
April 15, 2012 |
| CMPLFD |
Compare Logical File Description |
July 1, 1999 |
| CMPLIBFMT |
Compare Library Format |
April 15, 2010 |
| CMPLVLID |
Compare Level ID |
November 15, 2005 |
| CMPMBRD |
Compare Member Description |
July 15, 2011 |
| 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 |
| CPYDBFDAT |
Copy Data Base File Date |
April 15, 2010 |
| CPYDBFDTAQ |
Copy Data Base File to Data Queue |
April 15, 2013 |
| 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 |
| CPYRFMT |
Copy and Reformat |
April 15, 2010 |
| CPYSHFLFT |
Copy and Shift Left |
February 15, 2006 |
| CPYSPCDBF |
Copy User Space to Data Base File |
April 15, 2013 |
| CPYSPLFDTA |
Copy Spooled File Data |
April 15, 2006 |
| CPYSPLF2 |
Copy Spooled File 2 - Adds Blank Lines/New Page |
May 1, 1997 |
| CPYSRCHDR |
Copy Source Header |
June 15, 2001 |
| CPYTOCSV |
Create Delimiter IFS File |
July 15, 2010 |
| CPYTOFLAT |
Copy to Flat File |
April 15, 2012 |
| 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 |
| CRTINZRCD |
Create Initialized Record |
January 15, 2013 |
| CRTLFSRC |
Create Logical File Source |
May 1, 1996 |
| CRTPRTPGM |
Create Print Program |
April 1, 1995 |
| CRTSFLPGM |
Create Subfile Program - Assumes No Changes |
August 15, 2005 |
| CRTSFLPGM2 |
Create Subfile Program 2 - Assumes Change |
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 - Allows SRCTYP/Chg Date |
April 23, 2001 |
| CVTPCKFLD |
Convert Packed Field |
August 1, 1997 |
| CVTRCDLCK |
Convert Record Lock - All Locks on a Member |
July 15, 2013 |
| CVTRCDLCK2 |
Convert Record Locks 2 - All Locks for a Job |
February 1, 2001 |
| CVTTAAFMT |
Convert TAA Format |
June 15, 2001 |
| DLTDBFDAT |
Delete Data Base Date |
April 15, 2010 |
| 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 - One Record Per Display |
April 1, 1995 |
| DSPDBF |
Display Data Base File - Front End to RUNQRY |
April 1, 1995 |
| DSPDBFA |
Display Data Base File Attributes |
November 15, 1999 |
| DSPDBFALW |
Display Data Base File Allow Functions |
October 15, 2008 |
| DSPDBFDMG |
Display Data Base Damage |
January 15, 2011 |
| DSPDBFDTA |
Display DB File Data |
February 1, 1997 |
| DSPDBFFLD |
Display Data Base Field |
April 15, 2012 |
| DSPDBFJOIN |
Display Data Base Join Files |
January 15, 2014 |
| 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 |
| DSPDEPLGL |
Display Dependent Logical |
July 15, 2010 |
| DSPDFTRCD |
Display Default Records |
January 1, 2007 |
| DSPDLTSPC |
Display Deleted Space |
December 15, 2002 |
| DSPDTATYP |
Display Data Types |
February 28, 2000 |
| DSPDUPFLD |
Display Duplicate Field |
March 31, 2004 |
| DSPDUPKEY |
Display Duplicate Key |
January 15, 2014 |
| DSPEMTDBF |
Display Empty Data Base File |
October 15, 2010 |
| DSPEMTMBR |
Display Empty Members |
October 15, 2009 |
| DSPFLDA |
Display Field Attributes |
May 1, 1996 |
| DSPFMT |
Display Format |
May 1, 1996 |
| DSPFMTSEQ |
Display Format Sequence |
January 15, 2013 |
| DSPF2 |
Display File 2 - Allows Generic Name |
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 - Display Locks for a Job |
February 1, 2001 |
| DSPSELOMT |
Display Select Omit |
September 15, 2007 |
| DSPSRCMBRS |
Display Source Members |
February 1, 2005 |
| DSPTRGSTS |
Display Trigger Status |
January 15, 2013 |
| DSPUNQKEY |
Display Unique Key |
October 15, 2013 |
| DSPUNQKEYT |
Display Unique Key Totals |
October 15, 2013 |
| DTAARC |
Data Archive |
April 15, 2006 |
| DUPDBN |
Duplicate Data Base Network |
May 1, 1996 |
| DUPFILFMT |
Duplicate File Format |
April 1, 1995 |
| DUPFILFMT2 |
Duplicate File Format 2 - Requires Only *USE Auth |
October 15, 2013 |
| 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 - Rmv Whether Exist Or Not |
May 1, 1996 |
| RMVOLDMBR |
Remove Old Member - Rmv Based on Retention Date |
July 1, 1998 |
| RMVOLDMBR2 |
Remove Old Member 2 - Rmv Based on Nbr Members |
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 |
| RTVCCSIDPF |
Retrieve CCSID from PF |
July 15, 2012 |
| 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 |
| RTVMBRD2 |
Retrieve Member Description 2 - Addl Parameters |
June 1, 2002 |
| RTVMBRD3 |
Retrieve Member Description 3 - HLL Use |
June 1, 2005 |
| RTVMBRLST |
Retrieve Member List - Member Names |
August 1, 1996 |
| RTVMBRLST2 |
Retrieve Member List 2 - Member Information |
August 1, 1996 |
| RTVMBRSTAT |
Retrieve Member Statistics |
February 28, 2000 |
| RTVMBRSUM |
Retrieve Member Summary |
August 15, 2005 |
| RTVNXTID |
Retrieve Next ID |
July 15, 2010 |
| 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 - Retrieves Counts |
February 1, 2001 |
| SAVDBDLF |
Save Data Base Dependent Logical Files |
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 |
| SCNDBF |
Scan Database File |
October 15, 2014 |
| SCNDBFFLD |
Scan Data Base Field |
January 15, 2010 |
| SCNDBFFLD2 |
Scan Data Base Field 2 - Intended for Nam/Addr |
January 15, 2013 |
| 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 |
| SCNMBRA |
Scan Member Attributes |
October 15, 2013 |
| 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 - Front End to FMTDTA |
April 1, 1995 |
| SORTDBF |
Sort Data Base File - Front End to OPNQRYF |
March 15, 2002 |
| SORTDB2 |
Sort Data Base 2 - Front End to FMTDTA with FrmTo |
August 1, 1998 |
| STRKEY |
Start Key |
April 1, 1995 |
| TRGSAMPLE |
Trigger Sample |
January 15, 2013 |
| TRNDLTRCD |
Truncate Deleted Records |
September 15, 2000 |
| UPDFLD |
Update Field |
April 1, 1995 |
| UPDPFILE |
Update PFILE DDS Source |
August 1, 1998 |
| UPDPFILE2 |
Update PFILE 2 - Multiple Members |
January 15, 2013 |
| VALDBF |
Validate Data Base File |
April 1, 1995 |
| WRKDBFUNIT |
Work DataBase File Unit |
April 15, 2016 |
| WRKF2 |
Work File 2 - Addl Options |
September 15, 2002 |
| WRKMBRS |
Work Members |
September 15, 2002 |
| WRTDBF |
Write Data Base File |
April 1, 1995 |
