IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Importent Interview Qtns


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
speedcnu

New User


Joined: 27 Jan 2004
Posts: 6
Location: Hyderabad

PostPosted: Thu Oct 06, 2005 4:30 pm
Reply with quote

1) diffrence b/w os cobol2 and vs cobol2.
2)what is project architecture(hcl asked)
3) if we give copy instead of include what is the error
code we get?
4) how ur pgm or jcl knows that the file using is vsam
or non-vsam?
5) how u say that the static or dynamic by seeing the
pgm not jcl?
6) what is mti/mdi in cics?
7)what is exactly cs in db2?
8) can we apply sort utility for vsam files?
9) how to delete duplicate records from vsam -esds
file?
10) // is the endof jcl or end of step?
11) // step1
// step 30
//step 60
// step 100
i want execute from step30 to step 60 only? how u
code cond code?
12) gdg(1)
gdg(2)
gdg(+1)
gdg(+2)
iwant to create 2 gdgs and copied the data from
gdg(1) to gdg(+1),gdg(2) to gdg(+2)
and copy the newly created gdgs to another pds which
existed already ?
Back to top
View user's profile Send private message
Kevin

Active User


Joined: 25 Aug 2005
Posts: 234

PostPosted: Wed Oct 12, 2005 6:28 pm
Reply with quote

speedcnu wrote:

4) how ur pgm or jcl knows that the file using is vsam
or non-vsam?

A. It doesn't care.

speedcnu wrote:

8) can we apply sort utility for vsam files?

A. Yes. See plenty of examples in the DFSORT forum.

speedcnu wrote:

10) // is the endof jcl or end of step?

A. End of the JCL stream.
Back to top
View user's profile Send private message
Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 463

PostPosted: Wed Oct 12, 2005 7:23 pm
Reply with quote

Hi,

Quote:
9) how to delete duplicate records from vsam -esds
file?


Write a programe to delete duplicate from VSAM


Quote:
11) // step1
// step 30
//step 60
// step 100
i want execute from step30 to step 60 only? how u
code cond code?


Give Restart= STEP30 and after Step 60 add //

Hope this helps

Regards

Rupesh
Back to top
View user's profile Send private message
Sridevi_C

Active User


Joined: 22 Sep 2005
Posts: 104
Location: Concord, New Hampshire, USA.

PostPosted: Wed Oct 12, 2005 9:18 pm
Reply with quote

Hi,
Question 1 & 5 have been discussed already in the forum.So search.
Q.7 - Cursor Stability(CS).Refer manual for more info.
Q.9 - Duplicate records elimination - Code SUM FIELDS = NONE in JCL.
Q.12 - GDG generation numbers goes like this -2,-1,0,+1,+2 where 0 is the current generation. I don't get into your question of copying gdg(1) to gdg(+1).
Regards,
Sridevi.
Back to top
View user's profile Send private message
Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 463

PostPosted: Thu Oct 13, 2005 1:47 pm
Reply with quote

Hi Sridevi,

Quote:
Q.9 - Duplicate records elimination - Code SUM FIELDS = NONE in JCL.


Is it possible to sort and delete records from VSAm?

Regards

Rupesh
Back to top
View user's profile Send private message
Sridevi_C

Active User


Joined: 22 Sep 2005
Posts: 104
Location: Concord, New Hampshire, USA.

PostPosted: Thu Oct 13, 2005 5:48 pm
Reply with quote

Hi Rupesh,
Oops! I missed to notice VSAM-ESDS.Thanks for correcting me.
Regards,
Sridevi.
Back to top
View user's profile Send private message
Hames

New User


Joined: 03 Oct 2005
Posts: 49

PostPosted: Wed Oct 19, 2005 6:24 pm
Reply with quote

Quote:
6) what is mti/mdi in cics?


I think its MDT. Modified data tag. If MDT is 1 then the corresponding field value is modified and the data will be transmitted. If MDT is zero, data will not be transmitted.

Quote:
7)what is exactly cs in db2?


CS is cursor stability and the corresponding row(ex.row1) which the cursor is accessing now only be locked and once it moved to next row(ex.row2) the lock will be released from previous row(i.e.,row1) and lock will be acquired for this current row(i.e.,row2).
Back to top
View user's profile Send private message
cheli

New User


Joined: 21 Jul 2005
Posts: 11

PostPosted: Thu Oct 20, 2005 11:28 am
Reply with quote

Hi,
Regarding Cursor Stabiltiy please refer the following link,
publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/admin/c0004121.htm
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts Comp interview questions Mainframe Interview Questions 5
No new posts Interview Questions on Cobol DB2 program Mainframe Interview Questions 5
No new posts The Last Two Question For You To Ask ... Mainframe Interview Questions 0
No new posts Mainframe Interview Questions CICS,CO... Mainframe Interview Questions 6
No new posts Where can i find Interview questions ... Mainframe Interview Questions 4
Search our Forums:

Back to Top