DB2 Backup

 
Description: This is a multithreaded Perl program to backup a DB2 (UDB) database. The program uses 5 threads to perform that backup. Currenlty this script has been tested on AIX.

New in version 1.5:

Added two new command line parameters (-od and -os) to allow for the override of the database name and/or schema.

Version: 1.5 | File size: 12.98 Kb
Added on: 08-Dec-2004 | Downloads: 310
Home page | Details

PeopleSoft Trace File Analyzer

 
Description: This Perl program will take a PeopleSoft SQL trace file and build all of the statments listed from the trace along with the bind variables.
Version: 1.2 | File size: 8.12 Kb
Added on: 24-Jun-2004 | Downloads: 460
Home page | Details

sqr-analyzer

 
Description: SQR Source Code Analyzer - Version 3.2

This program will take an SQR source file (or SQC) and create list of all the SQC that are included, a list of all the functions in the source and any included SQC's, a list of all the define variables, and then create a function call "tree" of the source.

Changes:

• Fixed the $SQC_List array so that the key names no longer include a path, there were issues when the main program passed on the command line include a path, this is now stripped out and put in the location part of the array.
  
• In the get_file_location function, if a filepath is not determined from the search path, check the file name to see if it includes a path, if it does, strip it out and return that.
  
• Added a check in the process_function_call_tree function to verify the existence and value of a defined location so as to no pre-pend the source file name with a null path and a directory delimiter.
  
• Added a check in the print_sqc_tree_node function to ensure that the parent element of the array exists before trying to run a compare.
  
• Added checks in the initial_scan function to verify that the child_sqc_check and location elements of the array exist before running checks.
  

Version: 3.2 | File size: 14.07 Kb
Added on: 12-Dec-2005 | Downloads: 456
Home page | Details

sqr-analyzer - v2.7

 
Description: SQR Source Code Analyzer - Old Version 2.7

This program will take an SQR source file (or SQC) and create list of all the SQC that are included, a list of all the functions in the source and any included SQC's, a list of all the define variables, and then create a function call "tree" of the source.

This code is released under the GNU GPL.

Version: 2.7 | File size: 11.53 Kb
Added on: 28-Nov-2003 | Downloads: 370
Home page | Details

sqr-analyzer - v2.8

 
Description: SQR Source Code Analyzer - Old Version 2.8

This program will take an SQR source file (or SQC) and create list of all the SQC that are included, a list of all the functions in the source and any included SQC's, a list of all the define variables, and then create a function call "tree" of the source.

Changes:

• Added all command line flag to switch all command option on or off.
  
• Added code to issua a warning about other SQC re-defining variables (#DEFINE).
  
• Reworked the command-line argument parsing.
  
• Added switches to list #DEFINEs in either alphabetical or by SQC.
  

This code is released under the GNU GPL.
Version: 2.8 | File size: 12.26 Kb
Added on: 02-Dec-2003 | Downloads: 344
Home page | Details

sqr-analyzer - v2.9

 
Description: SQR Source Code Analyzer - Old Version 2.9

This program will take an SQR source file (or SQC) and create list of all the SQC that are included, a list of all the functions in the source and any included SQC's, a list of all the define variables, and then create a function call "tree" of the source.

Changes:

• Added code to work with the precompiler #IF statements (eg. #IF {TEST} = 'N')
  
• Added a new command line parameter (-sk) to specify procedures NOT TO trace when processing a file. The paramater takes a coma separated list of procedure names.
  

Version: 2.9 | File size: 12.71 Kb
Added on: 18-Feb-2004 | Downloads: 390
Home page | Details

sqr-analyzer - v3.0

 
Description: SQR Source Code Analyzer - Old Version 3.0

This program will take an SQR source file (or SQC) and create list of all the SQC that are included, a list of all the functions in the source and any included SQC's, a list of all the define variables, and then create a function call "tree" of the source.

Changes:

• Added the use Config command to the program can determine the operating system.
  
• Added code so the windows path names and *nix path names get treated correctly after the program determines the correct operating system (Thanks to Peter Mroz for finding this problem).
  
• Subroutine rm_path_from_filename added.
  
• Global flag $Win_Flag added.
  

Version: 3.0 | File size: 13.22 Kb
Added on: 03-Nov-2004 | Downloads: 328
Home page | Details

sqr-analyzer - v3.1

 
Description: This program will take an SQR source file (or SQC) and create list of all the SQC that are included, a list of all the functions in the source and any included SQC's, a list of all the define variables, and then create a function call "tree" of the source.

Changes:

• Added the command line parameter -e <num> to specify the number of elapsed lines before the procedure name appears on the end-procedure line.
  </num>
• Subroutine change_elapsed_count added.
  
• Global variable $Elapsed_Line_Limit added.
  

Version: 3.1 | File size: 13.61 Kb
Added on: 16-Nov-2004 | Downloads: 387
Home page | Details