Search found 537 matches

by Natarajan
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

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.
by Natarajan
Wed Jun 16, 2010 10:02 am
Forum: COBOL
Topic: IMS DB/DC Consultant needed
Replies: 2
Views: 4466

This post needs to be moved to "JOB VACANCIES" forum.
by Natarajan
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
by Natarajan
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...
by Natarajan
Thu Jun 03, 2010 8:46 pm
Forum: OTHER SUBJECTS
Topic: PLEAESE POST YOUR SUGESSIONS-MAINFRAME OPERATIONS
Replies: 2
Views: 6413

on which subject. You need books. On COBOL or JCL or DB2 or CICS?
by Natarajan
Thu Jun 03, 2010 8:44 pm
Forum: COBOL
Topic: Query for PARM Length
Replies: 3
Views: 6726

Rakesh,

field WS-EMP-LEN contain length of data being passed from jcl.
by Natarajan
Fri Apr 23, 2010 10:32 am
Forum: General Discussion
Topic: Do certifications Help ???
Replies: 5
Views: 9715

Taking a certification will add few stars to your resume.
It will enhance your knowledge.

my suggestion is to go for db2 certification without too much thinking.
by Natarajan
Mon Apr 19, 2010 7:20 pm
Forum: COBOL
Topic: COBOL Program performance tuning tips
Replies: 22
Views: 76966

Very good information shared. thanks Chuck.
by Natarajan
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...
by Natarajan
Fri Apr 16, 2010 11:05 pm
Forum: JCL INTERVIEW QUESTIONS
Topic: concatenate datasets using multiple sortin
Replies: 10
Views: 22817

Post this on "DFSORT , ICETOOL & Utilities" forum.
You may need to use ICETOOL for this.
by Natarajan
Fri Apr 16, 2010 10:58 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: SQL QUERY
Replies: 5
Views: 9136

interesting question...
you may need to use sysibm.systables in subquery...
by Natarajan
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...
by Natarajan
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...
by Natarajan
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
by Natarajan
Mon Mar 29, 2010 10:53 pm
Forum: COBOL
Topic: how to delete a record in a ksds file
Replies: 2
Views: 6692

delete <filename>