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
 

 

interview questions

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

New User


Joined: 31 Jul 2005
Posts: 6
Location: mumbai

PostPosted: Thu Aug 04, 2005 1:39 am    Post subject: interview questions
Reply with quote

)how to EDIT vsam dataset?plz let me know
2)what is the function of DB2
3)i have 1 to 100 records in vsam file.i wan to insert 46 record is it possible
4)how to retrive the data in sql. tell me the exact sequence.
5)give me the sql query, how to retrive than one row in a table.
do't say cursor


give me quick reply
Back to top
View user's profile Send private message

vijayamadhuri

Active User


Joined: 06 Apr 2005
Posts: 180

PostPosted: Thu Aug 04, 2005 2:40 am    Post subject: hi
Reply with quote

1)U can edit a vsam dataset just like any other datset.Copy and paste the datset name in the option 3.2 and edit it.

2)db2 is basically a database.The functions of any database are
data intergrity,i
ncreasing the data independence,
reducing data redundancy,
increasing data security

3) not sure

4)select * from table table_name will retreive all data from the desired table.
If u require only specific data mention the col name's of the data u require

READ THE SELECT CLAUSE it will help u

5) u can use the row id function
Back to top
View user's profile Send private message
vijayamadhuri

Active User


Joined: 06 Apr 2005
Posts: 180

PostPosted: Thu Aug 04, 2005 2:47 am    Post subject: Hi prathima
Reply with quote

for the last question check out these links

http://ibmmainframes.com/viewtopic.php?t=4701

http://ibmmainframes.com/viewtopic.php?t=4429
Back to top
View user's profile Send private message
Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 464

PostPosted: Tue Aug 09, 2005 11:22 am    Post subject: Re: interview questions
Reply with quote

HI vijayamadhuri,

I can not edit the VSAM using option 3.2. Can u please tell me how I can do it?


For Question 3
3)i have 1 to 100 records in vsam file.i wan to insert 46 record is it possible


Ans:- In VSAM you can not enter insert 46 records. I think

Please correct me if I m wrong

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

Active User


Joined: 06 Apr 2005
Posts: 180

PostPosted: Tue Aug 09, 2005 11:33 am    Post subject: Hi
Reply with quote

try option 3.4
Back to top
View user's profile Send private message
Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 464

PostPosted: Wed Aug 10, 2005 10:05 pm    Post subject: Re: interview questions
Reply with quote

HI vijayamadhuri,

Thanks for your reply but I could not edit VSAM file using option 3.4.

I m getting following Error.

VSAM processing unavail.


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

New User


Joined: 25 Apr 2005
Posts: 6

PostPosted: Wed Aug 10, 2005 11:42 pm    Post subject: Re: interview questions
Reply with quote

By using File-aid only we can edit the VSAM file.

in File-aid ,edit option will be there, by it u can edit the vsam dataset...

--------
Chandu
Rupesh.Kothari wrote:
HI vijayamadhuri,

Thanks for your reply but I could not edit VSAM file using option 3.4.

I m getting following Error.

VSAM processing unavail.


Thanks
Rupesh
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 The Last Two Question For You To Ask ... CaptBill Mainframe Interview Questions 0 Fri Apr 14, 2017 5:42 am
No new posts Mainframe Interview Questions CICS,CO... akshathan Mainframe Interview Questions 6 Thu Feb 09, 2017 6:38 pm
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
No new posts INCLUDE condition questions van bui DFSORT/ICETOOL 1 Thu Jun 30, 2016 9:52 am
No new posts SAS Programming - Basic Questions Techelm All Other Mainframe Topics 3 Fri Mar 18, 2016 10:53 pm


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