Shell Script Tutorial

Objectives:



Steps to Register Shell Script as a concurrent program

Sample Shell Script to copy the file from source to destination

Basic Shell Script Commands

Steps to Register Shell Script as a concurrent program



step 1:

=======

Place the .prog script under the bin directory for your

applications top directory.



For example, call the script XXXX_DEMO.prog and place it under

$CUSTOM_TOP/bin



step 2:

=======

Make a symbolic link from your script to $FND_TOP/bin/fndcpesr

For example, if the script is called XXXX_DEMO.prog use this:



ln -s $FND_TOP/bin/fndcpesr XXXX_DEMO



This link should be named the same as your script without the

.prog extension.



Put the link for your script in the same directory where the

script is located.



step 3:

=======

Register the concurrent program, using an execution method of

‘Host’. Use the name of your script without the .prog extension

as the name of the executable.



For the example above:

Use XXXX_DEMO



step 4:

=======

Your script will be passed at least 4 parameters, from $1 to $4.



$1 = orauser/pwd

$2 = userid(apps)

$3 = username,

$4 = request_id







Any other parameters you define will be passed in as $5 and higher.

Make sure your script returns an exit status also.



Sample Shell Script to copy the file from source to destination



#Note: If you see # in front of any line it means that it’s a comment line not the actual code

#** ********************************************************************

# Created By :

# Creation Date :

# Script Name : XXXXXXXX.prog

# Description : This Script accepts three parameters

# 1)Data File Name

# 2)Source Directory Path

# 3)Target Directory Path

# Then copy the file from source location to target location.

# If copy fails send the error status/message to concurrent program so that user can see status.

#

# ========

# History

# ========

# Version 1 Prudhvi A 19-FEB-2008 Created for erpschools.com users

#

#** ********************************************************************

#Parameters from 1 to 4 i.e $1 $2 $3 $4 are standard parameters

# $1 : username/password of the database

# $2 : userid

# $3 : USERNAME

# $4 : Concurrent Request ID

DataFileName=$5

SourceDirectory=$6

TargetDirectory=$7

echo “————————————————–”

echo “Parameters received from concurrent program ..”

echo ” Time : “`date`

echo “————————————————–”

echo “Arguments : ”

echo ” Data File Name : “${DataFileName}

echo ” SourceDirectory : “${SourceDirectory}

echo ” TargetDirectory : “${TargetDirectory}

echo “————————————————–”

echo ” Copying the file from source directory to target directory…”

cp ${SourceDirectory}/${DataFileName} ${TargetDirectory}

if [ $? -ne 0 ]

# the $? will contain the result of previously executed statement.

#It will be 0 if success and 1 if fail in many cases

# -ne represents not “equal to”

then

echo “Entered Exception”

exit 1

# exit 1 represents concurrent program status. 1 for error, 2 for warning 0 for success

else

echo “File Successfully copied from source to destination”

exit 0

fi

echo “****************************************************************”



Basic Shell Script Commands



# Create Directory

mkdir

# Remove Directory

rmdir

#remove folder with files

rm -r -f

# Change Directory

cd

# Create new file

vi

#insert data into file

vi

esc i

#Save file

esc :wq enter

# exit without saving changes

esc :q! enter

# open existing file

vi

#remove file

rm

# copy file with same name

cp /

# copy file with new name

cp / /

# Move file with same name

mv /

# move file with data appended to filename in the front

mv / /`date+%H%M%d%m%y`

#print line

echo “your text here to print”

#PRINT DATE

echo `date`