Answer / Ashish Kumar Misra

To connect DB2 database to DataStage, you can use the ODBC driver or the native DB2 driver. Here's an example using ODBC:n```nCreate a system environment variable named 'DB2DSN' with the name of your DB2 database as the value.nIn DataStage, create a new physical file and select ODBC as the data source.nSpecify the DSN you created earlier in the ODBC connection settings.n```

Mention the location where the output received from explain statement is stored.

1 Answers  

---

Explain about rct.

1 Answers  

---

What is blu acceleration in db2?

1 Answers  

---

When would you prefer to use VARCHAR?

3 Answers  

---

How to restart a DB2 program?

1 Answers   Cognizant,

---

Explain about cursor stability?

1 Answers  

---

Bind concepts in DB2 cobol

10 Answers   IBM, TCS, TRD, Virtusa,

---

How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,

---

what is the soft code for deadlock ?

2 Answers   Logica CMG,

---

What is difference between alias and synonym in db2?

1 Answers  

---

What are the 2 sqlcodes that are returned?

1 Answers  

---

What is the SQL Communications Area and what are some of its key fields?

1 Answers  

---