Thanks RudiC!!
I have modified the script little bit, now its failing in the DB connection part.I am able to connect to the DB through UNIX when i run the only DB script part(in another script) but i am unable to execute that in the entire script,Please look into the code and correct me
Code:
#!/bin/sh
set -x
# Check to see if source file path is given
if [ -z "$1" ]
then
echo "Usage: Source Path is required in position 1"
exit 1
else
SRCFILEPATH=$1
echo "Source path: $SRCFILEPATH"
fi
# Check to see if the file name pattern is given
if [ -z "$2" ]
then
echo "Usage: File Name Pattern is required in position 2"
exit 1
else
FILENAMEPAT=$2
echo "File Name Pattern: $FILENAMEPAT"
fi
#Moving to src directory
cd $SRCFILEPATH
pwd
FILECOUNT=`ls *"$FILENAMEPAT"*|wc -l`
echo $FILECOUNT
for file in "$FILENAMEPAT"*;
do
if [ "$FILECOUNT" -gt 1 ]
then
user="GLOBALDATA"
pass="duVuqi50"
ServiceName="xxxx"
sqlplus -S $user/$pass@ServiceName <<_EOF_
SELECT * FROM SEARCH_TERM ;
exit;
_EOF_
else
echo "file has no records to process"
exit 1
fi
done
#End of Script
Error I am getting
Code:
etluser@avocado1:/var/local/ei/etl/Scripts>sh test_2.sh var/local/ei/etl/Scripts Search_Term
+ '[' -z var/local/ei/etl/Scripts ']'
+ SRCFILEPATH=var/local/ei/etl/Scripts
+ echo 'Source path: var/local/ei/etl/Scripts'
Source path: var/local/ei/etl/Scripts
+ '[' -z Search_Term ']'
+ FILENAMEPAT=Search_Term
+ echo 'File Name Pattern: Search_Term'
File Name Pattern: Search_Term
+ cd var/local/ei/etl/Scripts
test_2.sh: line 32: cd: var/local/ei/etl/Scripts: No such file or directory
+ pwd
/var/local/ei/etl/Scripts
++ wc -l
++ ls Search_Term_Delete.sh Search_Term_Manual.txt
+ FILECOUNT=2
+ echo 2
2
test_2.sh: line 52: warning: here-document at line 43 delimited by end-of-file (wanted `_EOF_')
test_2.sh: line 53: syntax error: unexpected end of file
Moderator's Comments:
Please use CODE tags for data as well, as required by forum rules!
Last edited by RudiC; 08-23-2017 at 12:00 PM..
Reason: Added CODE tags.
hi all,
i tried the following source codes:
fork1.c:
main()
{
printf("demo of fork\n");
fork();
printf("hello");
}
output:
demo of fork
hello hello
fork2.c:
main() (3 Replies)
i have been working on this for a about 12 hours today say's end of file un expected any idea's
using the bourne shell and its driving me nuts worked fine in bash but prof says make it work in bourne and good luck worth 13%
any help would be awesome
#!/bin/sh
trap "rm mnt2/source/tmp/* 2>... (1 Reply)
this my source file
************* fixed ***************
Begin
equipmentId : d9
processor : fox
number : bhhhhhh
Variable # 1:
Id : 100
Type : 9
nType : s
gType : 5f
mType : 4
LField : England
DataField : london
Length ... (6 Replies)
I am new to unix and trying to execute sql script from unix. I have function already in database and trying to execute it from Cygwin unix and getting stuck. Can someone guide me where I wrote the shell script wrong
sqlplus -s scott/tiger
declare
a number:=3;
b number:=4;
c number;
d... (2 Replies)
Hi,I confused how to use sed to deal with big file.
example:
the big file have some different urls just with filename.
how can i use sed to fetch url except file name and replace to other urls with filename?
thanks!!! (11 Replies)
Hi Team,
I created one file like tst.pl, it contains
#!/usr/bin/perl
use Spreadsheet::ParseExcel;
During execution it's showing error like use: command not found.
Pleast let me suggest how to use this perl menthods in Unix.
Thanks in Advance,
Reards,
Harris (5 Replies)
I want to implement a feature in my project where I want to attach the virtual IP on the interface present at the top in Routing table. I know the command to print the routing table, its "netstat -r". But I need a system call, so that I don't have to go for parsing . Can someone please provide any... (1 Reply)
How to find a word in a directory which contains many files?
i just want to count how many such words are present in all the files?
This is the code which i tried for a single file
echo "Enter the file name:"
read file
echo "Enter the word to search:"
read word
if
then
echo "The count... (4 Replies)
Discussion started by: Meeran Rizvi
4 Replies
LEARN ABOUT PHP
locale_get_display_script
LOCALE_GET_DISPLAY_SCRIPT(3) 1 LOCALE_GET_DISPLAY_SCRIPT(3)Locale::getDisplayScript - Returns an appropriately localized display name for script of the input locale
Object oriented style
SYNOPSIS
publicstatic string Locale::getDisplayScript (string $locale, [string $in_locale])
DESCRIPTION
Procedural style
string locale_get_display_script (string $locale, [string $in_locale])
Returns an appropriately localized display name for script of the input locale. If is NULL then the default locale is used.
PARAMETERS
o $locale
- The locale to return a display script for
o $in_locale
- Optional format locale to use to display the script name
RETURN VALUES
Display name of the script for the $locale in the format appropriate for $in_locale.
EXAMPLES
Example #1
locale_get_display_script(3) example
<?php
echo locale_get_display_script('sl-Latn-IT-nedis', 'en');
echo ";
";
echo locale_get_display_script('sl-Latn-IT-nedis', 'fr');
echo ";
";
echo locale_get_display_script('sl-Latn-IT-nedis', 'de');
?>
Example #2
OO example
<?php
echo Locale::getDisplayScript('sl-Latn-IT-nedis', 'en');
echo ";
";
echo Locale::getDisplayScript('sl-Latn-IT-nedis', 'fr');
echo ";
";
echo Locale::getDisplayScript('sl-Latn-IT-nedis', 'de');
?>
The above example will output:
Latin;
latin;
Lateinisch
SEE ALSO locale_get_display_name(3), locale_get_display_language(3), locale_get_display_region(3), locale_get_display_variant(3).
PHP Documentation Group LOCALE_GET_DISPLAY_SCRIPT(3)
08-23-2017
