When program ended, it automatically closes the cursor.
But in the case, where without closing the DB2 cursor, if you try to open the CURSOR again. OPen command will fail.
Search found 537 matches
- Wed Jun 16, 2010 10:06 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: what will happen id i didnt close the cursor in the program?
- Replies: 5
- Views: 9521
- Wed Jun 16, 2010 10:02 am
- Forum: COBOL
- Topic: IMS DB/DC Consultant needed
- Replies: 2
- Views: 4466
- Tue Jun 15, 2010 4:49 pm
- Forum: JCL
- Topic: Why we use GDG?
- Replies: 2
- Views: 4547
go thru below tutorial. if you have any questions, do let you know.
http://mainframetutorials.com/drona/pro ... pter9.html
http://mainframetutorials.com/drona/pro ... pter9.html
- Tue Jun 15, 2010 4:40 pm
- Forum: COBOL
- Topic: What is the difference between Copy and Include?
- Replies: 10
- Views: 25810
Look like .. it is a interview question. ok. here is the answer. function of COPY & INCLUDE is the same. But the difference is .. cobol compiler can able to understand COPY statement. INCLUDE statement normally uses in DB2 programs to include DCLGEN copy books. At that time, pre-compiler (we use thi...
- Thu Jun 03, 2010 8:46 pm
- Forum: OTHER SUBJECTS
- Topic: PLEAESE POST YOUR SUGESSIONS-MAINFRAME OPERATIONS
- Replies: 2
- Views: 6413
- Thu Jun 03, 2010 8:44 pm
- Forum: COBOL
- Topic: Query for PARM Length
- Replies: 3
- Views: 6726
- Fri Apr 23, 2010 10:32 am
- Forum: General Discussion
- Topic: Do certifications Help ???
- Replies: 5
- Views: 9715
- Mon Apr 19, 2010 7:20 pm
- Forum: COBOL
- Topic: COBOL Program performance tuning tips
- Replies: 22
- Views: 76966
- Mon Apr 19, 2010 1:53 pm
- Forum: COBOL
- Topic: mainframes fresher
- Replies: 4
- Views: 6272
Welcome to the mainframe discussion board. Compare than last year, opening in mainframe technology has increased a lot. I can see good oppertunities in mainframe area in comming few years. Learn mainframe course and try for a job. I am sure you will get it. Note : These discussions needs to be poste...
- Fri Apr 16, 2010 11:05 pm
- Forum: JCL INTERVIEW QUESTIONS
- Topic: concatenate datasets using multiple sortin
- Replies: 10
- Views: 22817
- Fri Apr 16, 2010 10:58 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: SQL QUERY
- Replies: 5
- Views: 9136
- Thu Apr 15, 2010 10:12 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: interview ques in db2
- Replies: 6
- Views: 10523
db2 commit check point logic
check point logic... before every commit... update the key of the table in a file/temporarily table. if program abends, ( as you specified in the first post ).. and restarted the program again.. it will take the data in that file/table.. . where program abended , ( ie, after which record program abe...
- Thu Apr 15, 2010 9:51 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Trigger
- Replies: 1
- Views: 3478
All indexes, primary keys, foreign keys, check constraints, materialized query tables, and staging tables referencing the table are dropped. All views and triggers that reference the table are made inoperative. (This includes both the table referenced in the ON clause of the CREATE TRIGGER statement...
- Mon Mar 29, 2010 10:59 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: how to fetch records from db2
- Replies: 1
- Views: 4219
Using DECLARE CURSOR, OPEN, FETCH, CLOSE statements of DB2 COBOL programming.
You may want to refer db2 tutorial available on this site.
http://www.mainframegurukul.com/tutoria ... s/db2.html
You may want to refer db2 tutorial available on this site.
http://www.mainframegurukul.com/tutoria ... s/db2.html
- Mon Mar 29, 2010 10:53 pm
- Forum: COBOL
- Topic: how to delete a record in a ksds file
- Replies: 2
- Views: 6692