10-10-2007
still not working
Hi, I checked for that but it's still not working.
I commented out that whole if/then/else/fi, as its not really required, and then saved a test version of the script and removed the comments (I know that on the database I'll be running this on, the table does exist), It works OK with that bit commented out, I can't fathom why it's doing this, but I always get;
"sig10-test.sh[63]: syntax error at line 66 : `else' unmatched"
<attachment removed>
Thanks for any help.
Last edited by b.hamilton; 10-10-2007 at 05:56 AM..
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 REDHAT
comment
COMMENT(7) SQL Commands COMMENT(7)
NAME
COMMENT - define or change the comment of an object
SYNOPSIS
COMMENT ON
[
TABLE object_name |
COLUMN table_name.column_name |
AGGREGATE agg_name (agg_type) |
CONSTRAINT constraint_name ON table_name |
DATABASE object_name |
DOMAIN object_name |
FUNCTION func_name (arg1_type, arg2_type, ...) |
INDEX object_name |
OPERATOR op (leftoperand_type, rightoperand_type) |
RULE rule_name ON table_name |
SCHEMA object_name |
SEQUENCE object_name |
TRIGGER trigger_name ON table_name |
TYPE object_name |
VIEW object_name
] IS 'text'
INPUTS
object_name,
The name of the object to be be commented. Names of tables, aggregates, domains, functions, indexes, operators, sequences, types,
and views may be schema-qualified.
text The comment to add.
OUTPUTS
COMMENT
Message returned if the table is successfully commented.
DESCRIPTION
COMMENT stores a comment about a database object. Comments can be easily retrieved with psql's dd, d+, or l+ commands. Other user
interfaces to retrieve comments can be built atop the same built-in functions that psql uses, namely obj_description() and col_descrip-
tion().
To modify a comment, issue a new COMMENT command for the same object. Only one comment string is stored for each object. To remove a com-
ment, write NULL in place of the text string. Comments are automatically dropped when the object is dropped.
Note: There is presently no security mechanism for comments: any user connected to a database can see all the comments for objects
in that database (although only superusers can change comments for objects that they don't own). Therefore, don't put security-crit-
ical information in comments.
USAGE
Attach a comment to the table mytable:
COMMENT ON TABLE mytable IS 'This is my table.';
Remove it again:
COMMENT ON TABLE mytable IS NULL;
Some more examples:
COMMENT ON AGGREGATE my_aggregate (double precision) IS 'Computes sample variance';
COMMENT ON COLUMN my_table.my_field IS 'Employee ID number';
COMMENT ON DATABASE my_database IS 'Development Database';
COMMENT ON DOMAIN my_domain IS 'Email Address Domain';
COMMENT ON FUNCTION my_function (timestamp) IS 'Returns Roman Numeral';
COMMENT ON INDEX my_index IS 'Enforces uniqueness on employee id';
COMMENT ON OPERATOR ^ (text, text) IS 'Performs intersection of two texts';
COMMENT ON OPERATOR ^ (NONE, text) IS 'This is a prefix operator on text';
COMMENT ON RULE my_rule ON my_table IS 'Logs UPDATES of employee records';
COMMENT ON SCHEMA my_schema IS 'Departmental data';
COMMENT ON SEQUENCE my_sequence IS 'Used to generate primary keys';
COMMENT ON TABLE my_schema.my_table IS 'Employee Information';
COMMENT ON TRIGGER my_trigger ON my_table IS 'Used for R.I.';
COMMENT ON TYPE complex IS 'Complex Number datatype';
COMMENT ON VIEW my_view IS 'View of departmental costs';
COMPATIBILITY
SQL92
There is no COMMENT in SQL92.
SQL - Language Statements 2002-11-22 COMMENT(7)