View previous topic :: View next topic
|
Author |
Message |
induajayrose Warnings : 2 New User
Joined: 25 Jul 2005 Posts: 28 Location: Thrissur
|
|
|
|
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 |
|
|
Rupesh.Kothari
Member of the Month
Joined: 27 Apr 2005 Posts: 463
|
|
|
|
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 |
|
|
|