Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 82975

SQL Cursor : Database Object That Provisions Access to Records in a Database

1
vote
It was because of Commit while using Cursor. Adding WITH HOLD to the cursor definition resolved the Issue.
answered Feb 17 '16 by rrrohanb
1
vote
1answer
We need to move multiple tables using Load from cursor. But the number columns in the source and destination tables are not the same. Also the tables structures can change so we need the same to b …
asked Dec 24 '15 by rrrohanb
0
votes
Figured it out used ADMIN_CMD set v_sql ='LOAD FROM (SELECT '|| v_colquery || ' FROM ' || srctablename || ') OF CURSOR INSERT INTO ' || destablename || '_LOG ( ' || v_colquery || ')'; call admin_c …
answered Dec 24 '15 by rrrohanb
3
votes
1answer
scalar function reference is not open.. SQLCODE=-501, SQLSTATE=24501, DRIVER=4.18.60 All the cursors are implicit cursors(do correct me if i am wrong). Unclear as to which cursor is being referenced and what exactly the issue is. …
asked Dec 25 '15 by rrrohanb