Shell Programming and Scripting

 
# ora.sh
 
awk -v Outfile=ora.txt '
/^ORA-/ {
split($0, f, "\"");
Target_schema = f[2];
Target_table = f[4];
Ora_error = $0;
}
 
/Targ Rowid=/ { 
Rejected_count++ ;
Get_detail++;
printf "#%d => %s\n", Rejected_count, Ora_error;
next;
}
 
/^)/ && Get_detail {
print Rejected_count,Values_detail > Outfile;
Values_detail = "";
Get_detail = 0;
next;
}
 
Get_detail {
sub(/\(.*\):/,"=");
Values_detail = Values_detail $0 "|"
}
 
END {
print "Total Lines in Session Log",FILENAME,"is :",NR;
print "Total Nr of Rejected Records Captured in Sesslog is :",Rejected_count;
} 
' ora.log

awk -v Outfile=ora.txt '
. . .
' ora.log

/^ORA-/ {
   split($0, f, "\"");
   Target_schema = f[2];
   Target_table = f[4];
   Ora_error = $0;
}

/Targ Rowid=/ { 
   Rejected_count++ ;
   Get_detail++;
   printf "#%d => %s\n", Rejected_count, Ora_error;
   next;
}

/^)/ && Get_detail {
   print Rejected_count,Values_detail > Outfile; 
   Values_detail = "";
   Get_detail = 0;
   next;
}

Get_detail {
   sub(/\(.*\):/,"=");
   Values_detail = Values_detail $0 "|"
}

END {
   print "Total Lines in Session Log",FILENAME,"is :",NR;
   print "Total Nr of Rejected Records Captured in Sesslog is :",Rejected_count;
}

SMA_FEED_RECEIVED_ID (SMA_FEED_RECEIVED_ID:UniChar.40:): "MASTER_MATERIAL_ATTR_222222"
SMA_SOURCE_SYSTEM_INSTANCE (SMA_SOURCE_SYSTEM_INSTANCE:UniChar.40:): "BRE0222202"
SMA_MATERIAL (SMA_MATERIAL:UniChar.18:): "2222B"
SMA_OBJVERS (SMA_OBJVERS:UniChar.1:): "2222A"
SMA_CHANGED (SMA_CHANGED:UniChar.1:): ""
SMA_DIVISION (SMA_DIVISION:UniChar.2:): "02221"
SMA_MATL_GROUP (SMA_MATL_GROUP:UniChar.9:): "2227131"
SMA_MATL_TYPE (SMA_MATL_TYPE:UniChar.4:): "ZSTK"

 
Hi frnd,

My main problem is that

We need to identify the keyword Targ Rowid=  and “)” . Then we need to read the block of data (column values ) resides between those search pattern. Ok.

And we hav to loop through the entire log file to pick all required column values. Fine

Now in ur script, you have onse function named “Get_detail” which replace unwanted data with = symbol and make the block of data into single line with | delimited. Fine

When ur calling the function , y hv you mention ++ symbol. (ie., Get_detail++) . whether it is calling the function or just a normal variable declaration. If its declaration whats the use of it. 
What is the use of next; how its helping us to fulfill our requirement here.?

In the 3rd , we have like  /^)/ && Get_detail { . whats the use of Get_detail here. Is it a function calling? If so how its working. And why get_detail=0;


my main question is that,

we want to identify the both seach pattern and get the block of data and the block of data with pipe delimited. And need to loop through the entire log file.

You hv achived it in ur script. That is great. But I want understand how it capture the block of data .how this script loop through the session log for same purpose.

Plz explin the control flow in the script( ie., when ,which line ll get executed ?) explain me line by line. Plz frnd plzz .. even I couldn't sleep well since I couldn't understand the script.

Note: plz don't give overview explaination of the scriopt as you gave earlier. Plz little pit deeper. Line by line I want . I want control flow in the script.Plz dont ignor this post.


Send me the explination to my mail id:   gopal.narayanan@tcs.com