Shell Programming and Scripting

hi all

I am using awk utility to parse the file and fetching two different vaues from two different record of a record set.

I am able to see the result, now i want to store the result and perform some check of each values form database to mark valid and invalid.

could you please help me to write korn shell script.

to fetch all values for first pattern from file: awk '/'"$PATTERN1"'/' $FILE |cut -f3 -d ' '|sed 's/ //g'

to fetch all values for second pattern from file: awk '/'"$PATTERN2"'/' $FILE |cut -f3 -d ' '|sed 's/ //g'

the output is coming like

Pattern1

ABC
DEF
ABC
KLM

Pattern2

123
234
abc
r4e

etc.

i need to call oracle store procedure to check for validaity of these values.

Thanks in Advance

Singhal

One way is to use sqlloader to load the data in a table and validate the data with SQL.
Google for sqlloader if you don't have experience with it.

Regards

i want to pass both pattern values as arguments to a sql stored procedure for validation. i am aware about the sqlloader. i want to store both result set into array and access one by one both to validate. could you give me some example in KSH.

Thanks

Singhal

There are a lot of threads regarding this item, search for sql stored procedure with the search function.

Regards