interview questions

prathima · New User Joined: 31 Jul 2005 Posts: 6 Location: mumbai

)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

vijayamadhuri · Active User Joined: 06 Apr 2005 Posts: 180

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

vijayamadhuri · Active User Joined: 06 Apr 2005 Posts: 180

for the last question check out these links

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

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

Rupesh.Kothari · Member of the Month Joined: 27 Apr 2005 Posts: 463

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

vijayamadhuri · Active User Joined: 06 Apr 2005 Posts: 180

try option 3.4

Rupesh.Kothari · Member of the Month Joined: 27 Apr 2005 Posts: 463

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

chandu_b007 · New User Joined: 25 Apr 2005 Posts: 6

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