Answer / Purushottam

In DB2, a bind card specifies the SQL statements and their associated parameters for compiling an executable module. To generate a plan for accessing data from two databases, you would need separate bind cards for each database connection. The bind card includes information such as the library (owner), qualifier (schema), and database name for the specific database being accessed. Here's an example of a bind card:nn```clnBIND DB2HYPERTEXT EXEC SQL BEGIN DECLARE SECTION ;n db1_user CHAR(30) VALUE 'username';n db1_password CHAR(30) VALUE 'password';n db1_host CHAR(30) VALUE 'host';n db1_port INTEGER VALUE 50000;n db2_user CHAR(30) VALUE 'username';n db2_password CHAR(30) VALUE 'password';n db2_host CHAR(30) VALUE 'host';n db2_port INTEGER VALUE 50001;nBIND DB2HYPERTEXT EXEC SQL END DECLARE SECTION ;```nIn the example above, `db1_user`, `db1_password`, and other variables are used to specify the credentials and connection details for the first database. Similarly, you would define separate variables and values for the second database.

Explain the rollup operator?

1 Answers  

---

How would you design a database for an online site, which would average a million hits a day?

1 Answers  

---

What is bit datatype and what's the information that can be stored inside a bit column?

2 Answers  

---

Where is dbms used?

1 Answers  

---

Explain about relational operator join?

1 Answers  

---

Can you have a nested transaction?

1 Answers  

---

What are the three types of database design?

1 Answers  

---

What is the database development process?

1 Answers  

---

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

1 Answers  

---

Explain about the storage and physical database design?

1 Answers  

---

Explain the family trees and connection by clause.

1 Answers  

---

hi in which phase of mload can i use .FILLER

1 Answers   IBM,

---