Lectures: (current)
     - Array.
     - Array 2.
     - Command line arguments.
     - If() then-else if() then-else -endif statement.
     - while()...end statement.
     - switch()...case ...breaksw ... endsw statement.
     - Lesson 3
     - More on awk
     - More on awk and Unix shell scripting.
     - Script to modife date format.
        - SqlReport C-shell file.
        - Sql file.
     - Perl array.
     - Perl DBI using Mysql., Form to use in conjunction with the Perl DBI script.
     - Running Msqyl at the Unix prompt

Lessons: (old)
• Contents of lesson 2.
• More on array and awk command.
• Contents of lesson 3.
• Contents of lesson 4.
• A Korn shell script that operates on the Order_Details.csv file.  (Click here for the Order_Details.csv file.)
     - Click here for the manyOrders.awk script that is needed to work with the manyOrders.ksh script.
  Awk scripts:
  • An awk script to do string comparison..
  • An awk script to show how to use printf()..
  • An awk script to show how to find the length of a string.
  CGI scripts in Perl:
  • getOrder.htm, getOrders.txt (use Netscape to read this file. IE does not work properly)
  • getOrderById.html, getOrderById.txt (use Netscape to read this file. IE does not work properly)
  • queryByDate.html, queryByDate.txt (use Netscape to read this file. IE does not work properly)
  • queryByRange.html, queryByRange.txt (use Netscape to read this file. IE does not work properly)
  • queryByEmpId.html, queryByEmpId.txt (use Netscape to read this file. IE does not work properly)