Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
TCS Interview Question

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
nagalakshmi

New User


Joined: 23 Feb 2005
Posts: 7

PostPosted: Sat Feb 26, 2005 10:21 pm    Post subject: TCS Interview Question
Reply with quote

Hi,

1. Suppose two programmers coded Cobol-DB2 Pgms for the same request. How to identify which programs is more efficient than other?

2. An Embedded SQL Statement is erroneous in a Cobol-DB2 pgm and execution is unsuccessful. How to identify the corresponding SQL statment and the Field which caused this error and where to locate the value of this field.

Thanks
Lakshmi
Back to top
View user's profile Send private message

mainframenaidu

New User


Joined: 02 Mar 2005
Posts: 6

PostPosted: Thu Mar 03, 2005 3:21 pm    Post subject:
Reply with quote

Hi,
1. which pgm using the SQL query effectively, means like using the cursors. Let me know if anything else.

2. if u want to know the status of each command, put Display statement after each sql statement and dispaly the error message


thanks,
Naidu
Back to top
View user's profile Send private message
ovreddy

Active User


Joined: 06 Dec 2004
Posts: 211
Location: Keane Inc., Minneapolis USA.

PostPosted: Thu Mar 03, 2005 4:24 pm    Post subject:
Reply with quote

Hi Lakshmi,

1 Ans: COBOL+DB2 program effisiency depends on the number of DB2 calls and Query complexity. The best program should process every thing in COBOL and access DB2 very less number of times even using optimized SQL statements.

2 Ans: I think you know SQLCODE. Display SQLCODE after executing each SQL statement so that you will know where program will fail. Go to spool and find out the SQLCODE and proper message. I think it will work for you.


Bye,
Reddy.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts A couple of Interview Questions on Co... viplavmodi36 Mainframe Interview Questions 5 Fri Feb 23, 2018 6:21 pm
No new posts JES2 EXIT 6 QUESTION Randy Horowitz All Other Mainframe Topics 30 Tue Feb 06, 2018 5:47 pm
No new posts question about dfsms management clas... Hervey Martinez IBM Tools 0 Tue Oct 10, 2017 6:19 pm
No new posts Question related to Data dictionary f... rexx77 SYNCSORT 3 Thu Aug 31, 2017 7:23 am
No new posts QUESTION: RETURN CHANNEL pahiker CA Products 21 Thu Apr 20, 2017 12:31 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us