MOVE(7) SQL Commands MOVE(7)NAME
MOVE - position a cursor
SYNOPSIS
MOVE [ direction { FROM | IN } ] cursorname
DESCRIPTION
MOVE repositions a cursor without retrieving any data. MOVE works exactly like the FETCH command, except it only positions the cursor and
does not return rows.
The parameters for the MOVE command are identical to those of the FETCH command; refer to FETCH [fetch(7)] for details on syntax and usage.
OUTPUTS
On successful completion, a MOVE command returns a command tag of the form
MOVE count
The count is the number of rows that a FETCH command with the same parameters would have returned (possibly zero).
EXAMPLES
BEGIN WORK;
DECLARE liahona CURSOR FOR SELECT * FROM films;
-- Skip the first 5 rows:
MOVE FORWARD 5 IN liahona;
MOVE 5
-- Fetch the 6th row from the cursor liahona:
FETCH 1 FROM liahona;
code | title | did | date_prod | kind | len
-------+--------+-----+------------+--------+-------
P_303 | 48 Hrs | 103 | 1982-10-22 | Action | 01:37
(1 row)
-- Close the cursor liahona and end the transaction:
CLOSE liahona;
COMMIT WORK;
COMPATIBILITY
There is no MOVE statement in the SQL standard.
SEE ALSO
CLOSE [close(7)], DECLARE [declare(7)], FETCH [fetch(7)]
SQL - Language Statements 2010-05-14 MOVE(7)
Check Out this Related Man Page
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)
Hi All,
I have a sequential file, with that I want to know row count within.
As know we can use, wc -l filename, to find out a row count.
But, I found this command works well , if a file is small. It fails to give me rowcount, if File is pretty big. It keeps on processing after we give the... (3 Replies)
:)
hi all !
Please help me
When I select data from oracle with proc * C prog.
I count the number of rows
For example the total rows is 1000000
but the number of result return is a limit number 5000 for ex
So How can I know this limit (5 Replies)
Hi gurus,
Being a newbie not sure whether iam asking the right question?
can we use oracle commands in unix for ex: to read a count on a table.
if so, what needs to be configured and etc..
any kind of help is appreciated.
Thanks
sish (6 Replies)
Hi all,
I am new to SQLPLUS, can anyone tell me what is the following codes doing?
DECLARE
cursor c1 is select bts_int_id,
max(ave_busy_tch/res_av_denom14) maxBusyTch
from p_nbsc_res_avail
where to_char(period_start_time,'yyyymmdd')=to_char((sysdate-1),'yyyymmdd')
group by... (4 Replies)
Hi All
I have a Small Requiement
I wanted to replace all the Follwing lines as follows
Input:: file1
EVALUATE WS-TEMP-ATTR(15:1)
WHEN 'D'
MOVE DFHDARK TO WS-ATTR-COLOR
WHEN OTHER
MOVE DFHDFT ... (9 Replies)
Hi Guys,,
I am having a unix script which is running the DB2 Insert command.
For the insert command, there were no records to be updated.
SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a
query is an empty table. SQLSTATE=02000
+ + echo 1
STAGE_RC=1
+ ]
... (6 Replies)
Hi All,
I am having hard time in getting two almost identical rows into one, I know how to do if starting word is unique, anyhow this is my problem
Input File:
issue1 5167
dum 1 1 kkk 7888
dum 2 1 ffff 7888
dum 2 2 llll 7888
dum 3 1 eee 7888
issue2 7667
dum 2 1 jjjj 8999
dum 2 2 jjjj... (3 Replies)
Hi,
I would like to run a job based on the output from the SQL output.
Eg: Select count(*) from A ...if count(*) = 1 then execute the next step or else exit.
Please advise.
Thanks
S (2 Replies)
Greetings.
So the question is basically the same as it's in the title.
I'd like to write a program that changes a file by rows. So to clarify it.
(i know i shouldn't use code,/code here but i would like to separate it)
So for example a text file looks like something like this:
Happy... (5 Replies)
hi team,
i have a file txt1 , in that file there r 10 lines . my aim is to cut 2nd and 6th line of the file .
what command we can use for this scenario. (8 Replies)
Hello friends,
I need an idea or a ready solution for a problem
i have the following lines in text file:
1 20100920140122 object4 MOVE IN
2 20100920150012 object4 MOVE OUT
-- cut --
the second column is the date and time:
20100920140122 = 2010 09 20 14:01.22
what I need to do is to add 40... (8 Replies)
I want to fetch value from a particular location from a file but in each line in the file it appears at a different position so i tried using variable with cut command but it is not working properly. The code i have written is
#!/bin/sh
cat Sri1.log |
while read d2
do
grep -w... (9 Replies)
this is the i/p file i have :
$cat test2
DISPLAY
TWO
THREE
DISPLAY
MEEN
MOVE
DISPLAY
script used :
#!/bin/sh
file='sj/test2'
while read LINE
do
echo $LINE |grep -q "DISPLAY"
if ;then
sed /$LINE/d $file (6 Replies)
Hi,
I have been frantically googling and checking some sqlplus forums, but can't find the correct syntax.
Basically within sqlplus I want to do a count on a table and if the count is 0 it displays 0 instead of "no rows found".
For eample:
select count(*) from tableA where... (3 Replies)