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
 

 

Importent Interview Qtns

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
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    Post subject: Importent Interview Qtns
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    Post subject: Re: Importent Interview Qtns
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: 464

PostPosted: Wed Oct 12, 2005 7:23 pm    Post subject: Re: Importent Interview Qtns
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    Post subject:
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: 464

PostPosted: Thu Oct 13, 2005 1:47 pm    Post subject: Re: Importent Interview Qtns
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    Post subject:
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    Post subject:
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    Post subject: Re: Importent Interview Qtns
Reply with quote

Hi,
Regarding Cursor Stabiltiy please refer the following link,
http://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    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 Where can i find Interview questions ... Elixir Mainframe Interview Questions 4 Sat Feb 20, 2016 12:38 am
This topic is locked: you cannot edit posts or make replies. Mainframe interview on 10th Oct 2015 ... kotesh Mainframe Jobs 0 Thu Oct 08, 2015 5:21 pm
No new posts Sticky: Mainframe Developer Interview Questions Milin Mainframe Interview Questions 12 Wed Jan 07, 2015 8:58 pm
No new posts Few more CICS interview questions Milin Mainframe Interview Questions 3 Tue Dec 23, 2014 3:46 am
No new posts Sticky: CICS Interview Questions sandeep kumar302 Mainframe Interview Questions 5 Sun Oct 05, 2014 5:22 pm


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