UNIX for Dummies Questions & Answers

Hi,

I need help to write generic shell script for below log file
Requirement : Get some values from this log file and load them into one stats tables
1. Initializing session time (it will be available in first line) it is start time of the the job.
2. Target Load Summary like Table name, Output Rows, Affected Rows, Applied Rows, Rejected Rows. Here the values will be one table, sometimes many different tables.
3. Last line will need to capture time which is end time of the job.
4. I want to pass 3 variables to this script
a. job name
b. sub jobname
3. location where the log file stores.
finally i want few parametars so i can insert them into the table.
Values need for:
Starttime
job name
sub job name
Location
Table name,
Output Rows,
Affected Rows,
Applied Rows,
Rejected Rows.

I need help to write this shell script as this is the first time i am working on unix. Please help to write scripts.

Log file :

DIRECTOR> TM_6014 Initializing session [s_LoadPaymethod] at [Tue Mar 20 11:02:00 2012].
ANAGER> PETL_24005 Starting post-session tasks. : (Tue Mar 20 11:02:05 2012)
MANAGER> PETL_24029 Post-session task completed successfully. : (Tue Mar 20 11:02:05 2012)
MAPPING> TM_6018 The session completed with [0] row transformation errors.
MANAGER> TE_7216 Deleting cache files [/devl/infa/v9/Cache/PMJNR15328_10_0_387389.dat] for transformation [JNRTRANS].
MANAGER> TE_7216 Deleting cache files [/devl/infa/v9/Cache/PMJNR15328_10_0_387389.idx] for transformation [JNRTRANS].
MANAGER> PETL_24002 Parallel Pipeline Engine finished.
DIRECTOR> PETL_24012 Session run completed successfully.
DIRECTOR> TM_6022
SESSION LOAD SUMMARY
================================================
DIRECTOR> TM_6252 Source Load Summary.
DIRECTOR> CMN_1740 Table: [SQ_Shortcut_to_SBL_PAY_METHODS_VW] (Instance Name: [SQ_Shortcut_to_SBL_PAY_METHODS_VW])
Output Rows [33341], Affected Rows [33341], Applied Rows [33341], Rejected Rows [0]
DIRECTOR> CMN_1740 Table: [S_ORG_EXT_BU_C] (Instance Name: [S_ORG_EXT_BU_C])
Output Rows [28464], Affected Rows [28464], Applied Rows [28464], Rejected Rows [0]
DIRECTOR> TM_6253 Target Load Summary.
DIRECTOR> CMN_1740 Table: [R_ORG_EXT_XM] (Instance Name: [Shortcut_to_R_ORG_EXT_XM])
Output Rows [33300], Affected Rows [33300], Applied Rows [33300], Rejected Rows [0]
DIRECTOR> CMN_1740 Table: [R_ORG_EXT_XM1] (Instance Name: [Shortcut_to_R_ORG_EXT_XM])
Output Rows [31000], Affected Rows [31000], Applied Rows [31000], Rejected Rows [0]
DIRECTOR> TM_6023
===================================================
DIRECTOR> TM_6020 Session [s_LoadPaymethod] completed at [Tue Mar 20 11:02:05 2012].

Needing help with, and expecting delivery of, a script are not the same things.

What have you done so far?