No best answer available. Please pick the good answer available or submit your answer.
October 02, 2005 21:50:10
Saurabh
RE: What is the difference between a DB config and a C...
A .dbc file has the information required for Ab Initio to connect to the database to extract or load tables or views. While .CFG file is the table configuration file created by db_config while using components like Load DB Table.
RE: What is the difference between a DB config and a C...
Both DBC and CFG files are used for database connectivity basically both are of similar use. The only difference is cfg file is used for Informix Database whereas dbc are used for other database such as Oracle or Sqlserver
RE: What is the difference between a DB config and a C...
.dbc files are used to connect to database systems like Oracle/Teradata/DB2 etc. It has parameters like db_name db_nodes odbc_data_source_name.
Now .cfg files are entirely different. What if you want to connect to an external system not necessarily a database. Say you want to connect to a SAP system. For this you use a .cfg file. It needs parameters like DEST USERNAME PASSWD TYPE etc.
RE: What is the difference between a DB config and a C...
We connect to database thru idb components ie abinitio to database for that we need some info ie .dbc what and where we have to provide. where as .cfg is where co-op language which is going to translate itself and communicates to the database.
RE: What is the difference between a DB config and a C...
.dbc file basically helps abinitio coops to connect to database. It includes all the required database parameter and other default value respective to it. you can modify them. However .cfg is file is use set up some temporary environment for a particular job. for example while running job thru autosys u could have define .cfg file which will set env required for that job.
