Q&A Categories

DB2

Which statements are executable in cursor syntax?

Which statements are executable in cursor syntax? '

Answers No Answers In: DB2 By: neha [ Grey Star Level] Sep 5, 2010

Which of the following is not true about Bind ?

Which of the following is not true about Bind ? a.Programs bound to packages must still be designated in a plan.b.SQL statements are validated during Bind.c.Authorization is verified during bind.d.SQL...

Answers No Answers In: DB2 By: nitin [ Grey Star Level] Sep 5, 2010

Which of the environments cannot access DB2

Which of the environments cannot access DB2 a.TSOb.CICSc.IMSd.BATCHe.All the above can access DB2. All the above can access DB2.'

Answers No Answers In: DB2 By: @mahesh@ [1 Grey Star Level] Sep 4, 2010

Which DB2 components allows references to Oracle and DB2 databases in a single query?

Which DB2 components allows references to Oracle and DB2 databases in a single query? Which of the following DB2 components allows references to Oracle and DB2 databases in a single query? A. DB2 Query...

Answers No Answers In: DB2 By: jes [ Grey Star Level] Sep 4, 2010

Which can duplicate the structure and related objects of a DB2 database table?

Which can duplicate the structure and related objects of a DB2 database table? Which of the following can duplicate the structure and related objects of a database table? A. Copy table B. Alter table C. Export...

Answers No Answers In: DB2 By: rakesh [ Grey Star Level] Sep 4, 2010

When u will use cursor with hold option?

When u will use cursor with hold option? '

Answers No Answers In: DB2 By: nitin [ Grey Star Level] Sep 3, 2010

When can an insert of a new primary key value threaten referential integrity?

When can an insert of a new primary key value threaten referential integrity? Never. New primary key values are not a problem. However, the values of foreign key inserts must have corresponding primary...

Answers No Answers In: DB2 By: raju1587 [1 Grey Star Level] Sep 3, 2010

When do you open cursor before Fetching

When do you open cursor before Fetching i) Cursor should always be Opened before Fetching ii) Fetch Operation cursor retrieves Only ONE row for every execution. Of the Statement.Which are true?1 Both...

Answers No Answers In: DB2 By: ramesh [ Grey Star Level] Sep 3, 2010

When do you use subroutines?

When do you use subroutines? '

Answers No Answers In: DB2 By: bipin [ Grey Star Level] Sep 3, 2010

What will happened .if the file is open in extend mode and corresponding is equal to old in jcl?

What will happened .if the file is open in extend mode and corresponding is equal to old in jcl? '

Answers No Answers In: DB2 By: sam [ Grey Star Level] Sep 2, 2010

Didn't find what you were looking for?

Add your Question to the site.

You must be Logged In to Add a Question.

Not a member yet? Sign Up Now »

Star Points Scale

Earn points for Asking and Answering Questions!

Grey Sta Levelr [1 - 25 Grey Star Level]
Green Star Level [26 - 50 Green Star Level]
Blue Star Level [51 - 500 Blue Star Level]
Orange Star Level [501 - 5000 Orange Star Level]
Red Star Level [5001 - 25000 Red Star Level]
Black Star Level [25001+ Black Star Level]