09-08-2008
Thanks Icon! That worked. Do you have any idea why I couldn't use declare?
10 More Discussions You Might Find Interesting
1. Solaris
Hi ,
I am getting the following message when log into my unix account in sun solaris (version5.9)server.
-sh: ORACLE_HOME=/apps/oracle/product/10.2.0/client_1: is not an identifier
The ORACLE_HOME is set in .profile file.
Another thing is that SID is also set inside .profile like... (4 Replies)
Discussion started by: megh
4 Replies
2. Shell Programming and Scripting
Hi
I have already gone through this topic on this forum, but still i am getting same problem.
I am using solaris 10. my login shell is /usr/bash
i have got a script as below
/home/gyan> cat 3.cm
#!/usr/bin/ksh
export PROG_NAME=rpaa001
if i run this script as below , it works fine... (3 Replies)
Discussion started by: gyanibaba
3 Replies
3. Shell Programming and Scripting
Hi gurus,
I am trying to execute a shell script which connects to the oracle db and get the values from a table and then it exports the values on UNIX. For this, I am creating a temp file which stores the values returned from the select query and then executes this file. Below is the code which... (13 Replies)
Discussion started by: svajhala
13 Replies
4. Shell Programming and Scripting
Hi Guys...
I am using the following codes in my script:
SID_L=`cat /var/opt/oracle/oratab|grep -v "^#"|cut -f1 -d: -s`
SID_VAR=$SID_L
for SID_RUN in $SID_VAR
do
ORACLE_HOME=`grep ^$SID_RUN /var/opt/oracle/oratab | \
awk -F: '{print $2}'` ;export ORACLE_HOME
export... (2 Replies)
Discussion started by: Phuti
2 Replies
5. Shell Programming and Scripting
Hi,
We are in the process of migrating our servers from Solaris to AIX.
During our testing phase, while we are testing the scripts(reccnt.int), we are getting the following error during execution:
/reccnt.int: a:fname:b:dte:tme:eqind:norecs:cntr:c:d:e:f: is not an identifier
It is... (6 Replies)
Discussion started by: pyaranoid
6 Replies
6. Shell Programming and Scripting
Trying to run the following awk command :
export com.mics.ara.server.tools.sch_reports.Runner.num_threads=`awk -F= '!/^#/ && /com.mics.ara.server.tools.sch_reports.Runner.num_threads/{print $2}' $BKUPDIR/env.properties`
-bash: export:... (6 Replies)
Discussion started by: venhart
6 Replies
7. Solaris
Hi
I am trying to execute a script. I have solaris 10, After i login i will toggle to BASH.
The script tried to set a variable called CARBON_HOME. Even i tried to set it manually. But still it is saying the following error.:wall:
" CARBON_HOME=/usr/wso2/wso2esb-4.0.0: is not an... (5 Replies)
Discussion started by: gnanagurus
5 Replies
8. Shell Programming and Scripting
Dear guys I need help here with syntax, I am trying to start script command to capture all user activities every day, I want the log file of each user to be named with his login ID + date time to overcome the possibility of over writing the log file if he logoff and login again. Here is was I wrote... (5 Replies)
Discussion started by: q8devilish
5 Replies
9. Shell Programming and Scripting
Hello All,
Input:
long_and_mnemonic_identifier
anotherExample
i
bad_Style
Output:
longAndMnemonicIdentifier
another_example
i
Error!
Can someone help me in writing a script for the above ..Thanks and appreciated your help.. (1 Reply)
Discussion started by: bobby1015
1 Replies
10. Shell Programming and Scripting
Heya fellows
Yes, script-tools and TUI are both my 'children', so i cant go anywhere (else) and ask for help/bugfixes as i need to write them myself.
However i do need help to understand error messages at times (or get hints what else might cause them), so here we go:
Since my new computer... (4 Replies)
Discussion started by: sea
4 Replies
CLOSE(7) SQL Commands CLOSE(7)
NAME
CLOSE - close a cursor
SYNOPSIS
CLOSE { name | ALL }
DESCRIPTION
CLOSE frees the resources associated with an open cursor. After the cursor is closed, no subsequent operations are allowed on it. A cursor
should be closed when it is no longer needed.
Every non-holdable open cursor is implicitly closed when a transaction is terminated by COMMIT or ROLLBACK. A holdable cursor is implicitly
closed if the transaction that created it aborts via ROLLBACK. If the creating transaction successfully commits, the holdable cursor
remains open until an explicit CLOSE is executed, or the client disconnects.
PARAMETERS
name The name of an open cursor to close.
ALL Close all open cursors.
NOTES
PostgreSQL does not have an explicit OPEN cursor statement; a cursor is considered open when it is declared. Use the DECLARE [declare(7)]
statement to declare a cursor.
You can see all available cursors by querying the pg_cursors system view.
If a cursor is closed after a savepoint which is later rolled back, the CLOSE is not rolled back; that is, the cursor remains closed.
EXAMPLES
Close the cursor liahona:
CLOSE liahona;
COMPATIBILITY
CLOSE is fully conforming with the SQL standard. CLOSE ALL is a PostgreSQL extension.
SEE ALSO
DECLARE [declare(7)], FETCH [fetch(7)], MOVE [move(7)]
SQL - Language Statements 2010-05-14 CLOSE(7)