02-04-2007
Quote:
Originally Posted by sb008
From a syntax/symantic point of view it doesn't matter.
However it improves the readability of your script enormously.
yes, but reading a script you will be able to know the difference from a command and a variable.
*shrug* if its a large script I can see why, but sometimes, when you are doing something simple, you are just doing something simple.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I logged in to a Sun unix box. I would like to know where my unix id is stored. So I did a "more /etc/passwd | grep <my unix id> but it did not show up. Where can I find my unix id and what is the command to see it?
Thanks in advanced,
XZOR (4 Replies)
Discussion started by: XZOR
4 Replies
2. Solaris
All,
We are contemplating a port of an existing software product and would like to expend as little effort as possible. Our new database would be MS-SQL, and we would write stored procedures to perform common db operations. We'd like to call these stored procedures from C or C++ code running... (3 Replies)
Discussion started by: mparks
3 Replies
3. UNIX for Advanced & Expert Users
Hi All,
I want to run/execute a stored procedure (sybase) from unix command prompt not by login in isql utility which is provided my Sybase guys.
Is there way ..?
Thanks in advance for your help !!!
Regards,
Arvind S. (0 Replies)
Discussion started by: arvindcgi
0 Replies
4. Shell Programming and Scripting
Hi Guys,
I have a stored procedure which has 5 out parameters. I need to call the stored procedure from the script.
When i use the following in my script,
db2 "CALL FCFM.PART_MASTER_TMP($Return_code,$Message,$Message1,$SQL,$Load_count)" >> $LOG_FILE
I am getting an error..
Please... (1 Reply)
Discussion started by: mac4rfree
1 Replies
5. Shell Programming and Scripting
I want to store the sql query output into a variable
#!/bin/ksh
ORACLE_SID=DB01;
export ORACLE_SID;
export FILE_PATH=/home/asg/Tmp
# Order Checking
echo " removing old files "
rm $FILE_PATH/Malformed_Order.txt
echo " Enter the Malformed Order ....!"
read orders
echo "Regrade... (5 Replies)
Discussion started by: Nareshp
5 Replies
6. UNIX for Dummies Questions & Answers
Hi,
My stored procedure returns a value.
How to retrieve the value and display in unix.
Stored procedure
CREATE OR REPLACE
PROCEDURE gohan(num INT) IS
BEGIN
DBMS_OUTPUT.PUT_LINE('My lucky number is ' || num);
END;
Unix Scripting i used
sqlplus -s... (7 Replies)
Discussion started by: gohan3376
7 Replies
7. Shell Programming and Scripting
Hi Dudes :)
I want a unix shell script to pass value to SQL stored procedure.
Below is the procedure
declare
res varchar2(10);
begin
odm_load_check('PRE_SANITY',res);
dbms_output.put_line(res);
end;
select * from error_log;
truncate table error_log;
select * from test; (1 Reply)
Discussion started by: shirdi
1 Replies
8. Shell Programming and Scripting
The db2 table stores the unix path as below
PARM VALUE
RootPath $SRootDir
Target $SRootDir/target
$SRootDir is set in the env variable as /home/test/root
In the shell script i read the table value and store it in a variable
pth=db2 -x "select VALUE from... (2 Replies)
Discussion started by: 2jnags
2 Replies
9. Shell Programming and Scripting
Hi,
I am using sql server 2008 version and invoking the stored procedure using unix script. I want to know the procedure of killing the stored procedure in sql server.
If I kill -9 the unix script will it also terminate the process at the SQL server. When I executed the kill -9 PID in unix... (2 Replies)
Discussion started by: Rahul Raj
2 Replies
10. Post Here to Contact Site Administrators and Moderators
Hi, I am new to shell scripting and Sybase database i need a help that i try to execute a SYBASE stored procedure from a Unix shell script and wanna write the output of the SP into a Text File, somehow i tried to find a solution but when i try to run the script i am not getting the output file with... (1 Reply)
Discussion started by: Arun619
1 Replies
LEARN ABOUT OPENDARWIN
catch
catch(n) Tcl Built-In Commands catch(n)
__________________________________________________________________________________________________________________________________________________
NAME
catch - Evaluate script and trap exceptional returns
SYNOPSIS
catch script ?varName?
_________________________________________________________________
DESCRIPTION
The catch command may be used to prevent errors from aborting command interpretation. Catch calls the Tcl interpreter recursively to exe-
cute script, and always returns without raising an error, regardless of any errors that might occur while executing script.
If script raises an error, catch will return a non-zero integer value corresponding to one of the exceptional return codes (see tcl.h for
the definitions of code values). If the varName argument is given, then the variable it names is set to the error message from interpret-
ing script.
If script does not raise an error, catch will return 0 (TCL_OK) and set the variable to the value returned from script.
Note that catch catches all exceptions, including those generated by break and continue as well as errors. The only errors that are not
caught are syntax errors found when the script is compiled. This is because the catch command only catches errors during runtime. When
the catch statement is compiled, the script is compiled as well and any syntax errors will generate a Tcl error.
EXAMPLES
The catch command may be used in an if to branch based on the success of a script.
if { [catch {open $someFile w} fid] } {
puts stderr "Could not open $someFile for writing
$fid"
exit 1
}
The catch command will not catch compiled syntax errors. The first time proc foo is called, the body will be compiled and a Tcl error will
be generated.
proc foo {} {
catch {expr {1 +- }}
}
SEE ALSO
error(n), break(n), continue(n)
KEYWORDS
catch, error
Tcl 8.0 catch(n)