TAA Tools

Date of this refresh -- Apr 15, 2017

Click the tool name for a brief description of the tool. Click the definition for the full documentation.

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
RTVLSTCHG Retrieve Last Change April 1, 1995
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 Data Base 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

Home Page Return to Category List Up to Top