Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 QUESTION: RETURN CHANNEL pahiker CA Products 21 Thu Apr 20, 2017 12:31 am
No new posts The Last Two Question For You To Ask ... CaptBill Mainframe Interview Questions 0 Fri Apr 14, 2017 5:42 am
No new posts Asynchronous CICS Processing Question moezbud CICS 1 Mon Mar 06, 2017 6:13 pm
No new posts CICS Question RE: Browse, Readnext an... moezbud CICS 7 Sun Mar 05, 2017 5:45 am
No new posts Mainframe Interview Questions CICS,CO... akshathan Mainframe Interview Questions 6 Thu Feb 09, 2017 6:38 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us