10-09-2007
fi
Quote:
Originally Posted by
b.hamilton
#<snip>....
if [ "$TBL_CHECK" = "bh_sig_10" ]
then
echo "Comparison table exists"
else
echo "Comparison table does not exist - Script will create table"
sql $HBDB <<_END_ > $MAINFOLDER/Create_comparison_table.txt
set autocommit on;
\p\g
set lockmode session where readlock = nolock;
\p\g
create table bh_sig_10 (
claim_id i4,
title varchar 4,
forename varchar 32,
surname varchar 32,
birth_date date
)
with nojournaling,
noduplicates;
\p\g
_END_
fi
...
I get the else unmatched on that else in bold....any clues?
if/then/else/fi now in bold.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi ,
I have two files want to compare and list of column values and postion which are not matched between two files,I can use diff but it will return rows from two files which are matched and unmatched columns.I wrote the below script but not working.
f1=$1
f2=$2
for i in 1
do
file1=`cat... (3 Replies)
Discussion started by: mohan705
3 Replies
2. Shell Programming and Scripting
Hello guys,
I am trying to run an installer through my script. Whatever yes/no or values required during the installation is provided by an answer file (answ.txt)
./install < /var/answ.txt
Now, during the installation, it asks for:
1) press return to continue
2) press 3 and hit enter
3)... (1 Reply)
Discussion started by: solaix14
1 Replies
3. Shell Programming and Scripting
Good morning,
I have been teaching myself shell scripting and seem to be stuck here. I am sure I am just blind and not seeing it so I thought maybe some fresh eyes would help. With the script below I keep getting....
"syntax error at line 248 : `done' unexpected"
I am not seeing why this... (6 Replies)
Discussion started by: LRoberts
6 Replies
4. Shell Programming and Scripting
:b:Hi guys,
I am getting this error in this piece of code, Any help will be appreciate
rypidoc.shl: syntax error at line 79 : `for' unmatched
##Determine if there is a file to process
ls 3526*.dat > /dev/null 2>&1
if
then
exit
fi
for i in 3526*.dat
do
# Capture just the file... (2 Replies)
Discussion started by: rechever
2 Replies
5. Shell Programming and Scripting
Below is my requirement :
unmatched values should get deleted from file1
file1
A-1
B-1
C-1
D-2
E-3
F-4
file2
D
C
F
output
C-1
D-2
F-4 (2 Replies)
Discussion started by: lavnayas
2 Replies
6. Shell Programming and Scripting
Hi Guys,
I get the error while running below commands. Earlier the command used to execute, but after enclosing them in a function, the error is occuring
backupPath=`echo $folderName | sed -e 's,/vobs/dte/itgClient/client/RegressionTestLibPostOHS/,,'`
check_event=`cat... (7 Replies)
Discussion started by: ajincoep
7 Replies
7. Shell Programming and Scripting
i have two lists,
list1 => abc jones oracle smith ssm tty
list2 => abc jones lmn smith ssm xyz
now i want to print only those names which are present in list2 and want to remove names from list2 which presents in list1.
so i want OUTPUT => lmn xyz
because "abc jones smith ssm" from list2... (5 Replies)
Discussion started by: Killer420
5 Replies
8. Shell Programming and Scripting
Hi,
I am running sinple ksh script .
From some reason it failed on the following error:
./ogg_status.sh: syntax error at line 16 : `<<' unmatched
Please advise.
#!/usr/bin/ksh
export ORACLE_HOME=/software/oracle/DB10gR2
export LD_LIBRARY_PATH=/software/oracle/DB10gR2/lib:/usr/lib... (4 Replies)
Discussion started by: yoavbe
4 Replies
9. Shell Programming and Scripting
Hi Gurus,
I'm facing some issues with multiple conditions in my if statement.
if (!($InputLine=~/^Date/)) && (!($fields eq "VEN")) {
Above is the line troughing some syntax errors.
I am trying to avoid the below creteria lines to process in my logic.
Records starting with... (4 Replies)
Discussion started by: hi.villinda
4 Replies
10. Shell Programming and Scripting
Hi all,
I want to call a plsql package that does not return any value.
I am using the following script to do so:
sqlplus $UserNamePwd <<EOF
set head off
begin
test_pkg.procedure('$DebugFlag');
end;
exit
EOF
if
then
log_message "procedure failed."
exit 1
fi
exit $?
I... (2 Replies)
Discussion started by: reshma15193
2 Replies
LEARN ABOUT PHP
oci_field_size
OCI_FIELD_SIZE(3) OCI_FIELD_SIZE(3)
oci_field_size - Returns field's size
SYNOPSIS
int oci_field_size (resource $statement, mixed $field)
DESCRIPTION
Returns the size of a $field.
PARAMETERS
o $statement
- A valid OCI statement identifier.
o $field
- Can be the field's index (1-based) or name.
RETURN VALUES
Returns the size of a $field in bytes, or FALSE on errors.
EXAMPLES
Example #1
oci_field_size(3) example
<?php
// Create the table with:
// CREATE TABLE mytab (number_col NUMBER, varchar2_col varchar2(1),
// clob_col CLOB, date_col DATE);
$conn = oci_connect("hr", "hrpwd", "localhost/XE");
if (!$conn) {
$m = oci_error();
trigger_error(htmlentities($m['message']), E_USER_ERROR);
}
$stid = oci_parse($conn, "SELECT * FROM mytab");
oci_execute($stid, OCI_DESCRIBE_ONLY); // Use OCI_DESCRIBE_ONLY if not fetching rows
echo "<table border="1">
";
echo "<tr>";
echo "<th>Name</th>";
echo "<th>Type</th>";
echo "<th>Length</th>";
echo "</tr>
";
$ncols = oci_num_fields($stid);
for ($i = 1; $i <= $ncols; $i++) {
$column_name = oci_field_name($stid, $i);
$column_type = oci_field_type($stid, $i);
$column_size = oci_field_size($stid, $i);
echo "<tr>";
echo "<td>$column_name</td>";
echo "<td>$column_type</td>";
echo "<td>$column_size</td>";
echo "</tr>
";
}
echo "</table>
";
// Outputs:
// Name Type Length
// NUMBER_COL NUMBER 22
// VARCHAR2_COL VARCHAR2 1
// CLOB_COL CLOB 4000
// DATE_COL DATE 7
oci_free_statement($stid);
oci_close($conn);
?>
NOTES
Note
In PHP versions before 5.0.0 you must use ocicolumnsize(3) instead. This name still can be used, it was left as alias of
oci_field_size(3) for downwards compatability. This, however, is deprecated and not recommended.
SEE ALSO
oci_num_fields(3), oci_field_name(3).
PHP Documentation Group OCI_FIELD_SIZE(3)