Interested to Buy Any Domain ? << Click Here >> for more details...
How connect db2 database to datastage?
- 1 Answers
- 1298 Views
- I also Faced
- E-Mail Answers
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```
| Is This Answer Correct ? | 0 Yes | 0 No |
What are packages in db2?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
Is schema the same as database?
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
Where can you declare a cursor in a cobol-db2 program?
Why do we use cursor?
can all users have the privilage to use the sql statement select * (dml)?
What is a collection in db2?
What is the difference between oracle and db2?
Explain the use of the WHERE clause?
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
What can the SET option of the Repair Utility accomplish?
COBOL 
