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 in db2

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

PostPosted: Wed Sep 28, 2005 12:24 pm    Post subject: Re: intrvw questions
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    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