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
 

 

DB2 Interview Questions:

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

New User


Joined: 28 Jul 2005
Posts: 58

PostPosted: Fri Dec 16, 2005 11:43 am    Post subject: DB2 Interview Questions:
Reply with quote

Hi friends,

1. What all are the 2 ways to find out the Primary key Column in DB2?

2. While fetching the Records we are coding like

IF Sqlcode is not = +100

Exec sql Fecth C1 into :Rec End-exec.

Likewise While Inserting what is the Sqlcode will u check which is mandatory.

Thanks and Regards,
Suganthy.
Back to top
View user's profile Send private message

khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Fri Dec 16, 2005 12:00 pm    Post subject: Interview Question
Reply with quote

Hi suganthy,

Quote:
1. What all are the 2 ways to find out the Primary key Column in DB2?

Once the table is described then v can find out the primary key column,,
ie., viewing sysibm.systable like that...

Quote:

While Inserting what is the Sqlcode will u check which is mandatory


As v will b using more records to fetch using curson v r in need to use the sqlcode.. but i dont think such a statement is mandatory in inserting...
Back to top
View user's profile Send private message
sathish_rathinam

New User


Joined: 22 Aug 2005
Posts: 59
Location: india

PostPosted: Fri Dec 16, 2005 2:49 pm    Post subject: Re: DB2 Interview Questions:
Reply with quote

hi khamarutheen,

while inserting we should checkout for -803 sql error..which is called unique index violation....

regards,
sathish
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Fri Dec 16, 2005 3:15 pm    Post subject: db2
Reply with quote

Hi sathish,
Fine.. thank u for directing me... but many thing like -817,-803 occurs once the insert is done only b4 insert there is nothing to get checked.. i think so... any way thanks for ur solution
Back to top
View user's profile Send private message
suganthyprabha

New User


Joined: 28 Jul 2005
Posts: 58

PostPosted: Tue Dec 20, 2005 12:03 pm    Post subject: Re: DB2 Interview Questions:
Reply with quote

Hi friends,

Thanks for ur answers.

Thanks and Regards,
Suganthy.
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 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
No new posts Where can i find Interview questions ... Elixir Mainframe Interview Questions 4 Sat Feb 20, 2016 12:38 am


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