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

Interview Questions in db2


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

New User


Joined: 25 Jul 2005
Posts: 28
Location: Thrissur

PostPosted: Wed Sep 28, 2005 11:37 am
Reply with quote

Hai all,
Do any one know the answer of these questions.
1.In Db2 can we giv a foriegn key as null?
2.Can we insert records to sequential,relative & indexed sequential files.
3Can u explain the structure of linkage section.
4.how can we remove the sql error -811
When we insert to a sequential file where it wil get added
regards indu
Back to top
View user's profile Send private message
Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 463

PostPosted: Wed Sep 28, 2005 12:24 pm
Reply with quote

Hi,


Quote:
1.In Db2 can we giv a foriegn key as null?


Yes, Foreign key can store a null value.

Quote:
2.Can we insert records to sequential,relative & indexed sequential files.


You can not insert a record in between but yes you can append a record.


Quote:
4.how can we remove the sql error -811


Examine the syntax of the statement to ensure that it contains the proper condition specifications. If it does, there may be a problem with the data that is causing more than one row or value to be returned when you do not expect it.


Hope this helps

Regards

Rupesh
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 Viewing executing process in NDM .. q... IBM Tools 0
Search our Forums:

Back to Top