Is there a more efficient way? Post: 93104

Sponsored Content

Top Forums Shell Programming and Scripting Is there a more efficient way? Post 93104 by SelectSplat on Thursday 15th of December 2005 01:29:01 PM

12-15-2005

Registered User

Is there a more efficient way?

I'm using korn shell to connect to oracle, retrieve certain values, put them in a list, and iterate through them. While this method works, I can't help but think there is an easier method.

If you know of one, please suggest a shorter, more efficient method.

PHP Code:


###############  FUNCTIONS  ####################################################################

check_for_sqlplus_error() 

{

    # $1 = $? (results of last command)

    # $2 = user defined error code

  if [ $1 -ne 0 ]; then

   write_log " ERROR - sqlplus execution failure at: "$2

   exit 1

  fi

  return 0

}    



run_query()

{

    # $1 - db login

    # $2 - user defined error code

    # $3 - SQL to execute

    # $4 - logfile to re-direct to

$SQLPLUS -s $1<<EOF |  sed '/^$/d' > $4

  set HEADING   OFF  

  set FEED OFF

  set TRIMOUT   ON 

  set TRIMSPOOL ON 

  $3;

EOF



check_for_sqlplus_error $? "code "$2

return 0

}



run_proc()

{

    # $1 - db login

    # $2 - user defined error code

    # $3 - SQL to execute

    # $4 - logfile to re-direct to

$SQLPLUS -s $1<<EOF |  sed '/^$/d' > $4

  set pagesize 0

  set AUTOT ON

  set serveroutput on SIZE 50000

  $3;

EOF



check_for_sqlplus_error $? "code "$2

return 0

}



write_log ()

{

  echo `date +"%m/%d/%Y %H:%M:%S"`" "$1

}



#################  MAIN  ########################################################################

# SQL*PLUS code:200 - Get the list of batches for this load 

write_log " Get the Batch List..."

run_query $ODS 200 "select distinct batch_num from cr_batch where load_desc = '$SOURCE_SYSTEM_DESC'"  $LOGPATH$SOURCE_SYSTEM_DESC.batch.lst



if [ -s $LOGPATH$SOURCE_SYSTEM_DESC.batch.lst ]; then

  write_log " Begin Processing Batches..."

  while read BATCH_NUM

  do

    if [ $BATCH_NUM ]; then

       # SQL*PLUS code:300 - Run the batch load stored procedure for this batch 

       write_log " Calling p_stage_load with $SOURCE_SYSTEM_DESC , $LOAD_RUN_NUM, $BATCH_NUM "

       run_proc $STAGING 300 "exec p_stage_load('$SOURCE_SYSTEM_DESC', $LOAD_RUN_NUM, $BATCH_NUM )"  $LOGPATH$SOURCE_SYSTEM_DESC.$BATCH_NUM.log &

    else 

      write_log " No batches found for '$SOURCE_SYSTEM_DESC'"

    fi

  done < $LOGPATH$SOURCE_SYSTEM_DESC.batch.lst

else 

    # if there are no batches, lets just exit

    write_log " No batches for "$SOURCE_SYSTEM_DESC" were found!...Exiting"

    exit

fi

SelectSplat

View Public Profile for SelectSplat

Find all posts by SelectSplat

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Efficient Dispatching

Does anyone know what's new with Efficient dispatching in the Solaris 2.8 release (vs Solaris 2.6) release? Specifically, does anyone know of a good website to get detailed information on thread dispatching using efficient dispatching in solaris 2.8? Thank you.

2. Shell Programming and Scripting

Efficient way of Awk

Hi, Can someone let me know if the below AWK can be made much simpler / efficient ? I have 200 fields, I need to substr only the last fields. So i'm printing awk -F~ 'print {$1, $2, $3....................................$196,$197 , susbstr($198,1,3999), substr($199,1,3999)..}' Is there a...

3. Shell Programming and Scripting

Can you suggest a more efficient way for this?

Hi I have the following at the end of a service shutdown script used in part of an active-passive failover setup: ### # Shutdown all primary Network Interfaces # associated with failover ### # get interface names based on IP's # and shut them down to simulate loss of # heartbeatd ...

4. Shell Programming and Scripting

help on most efficient search

Hello, We have a directory with 15 sub-directories where each sub-directory contains 1.5 to 2 lakhs of files in it. Daily, around 300-500 files will be uploaded to each sub-directory. Now, i need to get the list of files received today in most efficient way. I tried using "find with newer...

5. Shell Programming and Scripting

Is there a way to make this more efficient

6. Shell Programming and Scripting

efficient search

Hi, i have 2 files each with 200K lines. Each line contains a number. Now, i need to get the list of numbers existing in one fine and NOT in other file. I'm doing this by reading each number from 1 file and grepping on other file. But this taking LOT of time. Is there any efficient way of doing...

7. UNIX for Advanced & Expert Users

efficient repace

some of the data i receive has been typed in manually due to which there are often places where i find 8 instead of ( and the incorrect use of case what according to you is the best way to correct such data. The data has around 20,000 records. The value i want to change is in the 4th field....

8. UNIX for Dummies Questions & Answers

Is this regex efficient?

I want to match the red portion: 9784323456787-Unknown Phrase with punctuation "Some other PhrASE." Is this the best regex to match this? '978\{10\}-*'

9. UNIX for Advanced & Expert Users

Efficient way to grep

Hi Experts, I've been trying simple grep to search for a string in a huge number of files in a directory. grep <pattern> * this gives the search results as well as the following - grep: <filename>: Permission denied grep: <filename>: Permission denied for files which I don't have...

10. Shell Programming and Scripting

Help with Efficient Looping

Hello guys My requirement is to read a file with parent-child relationship we need to iterate through each row to find its latest child. for eg. parent child ABC PQR PQR DEF DEF XYZ Expected Output ABC XYZ PQR XYZ DEF XYZ Script Logic : read parent from file seach child...