I need to do database access using BASIC routines. Can any one help
Thanks..
Nilotpal.
database access using Routines
Moderators: chulett, rschirm, roy
This paragraph should help you get started
MY_PARAGRAPH
0001 PA
0002 CONNECT ODBC_DSN
0003 DATA USER_NAME
0004 DATA PASSWORD
0005 DATA {CALL STORED_PROC_CALL('ARG_1', 'ARG_2')};
OR
0005 DATA MY_SQL_STATEMENT;
0006 DATA .Q
Edited by - kww on 08/30/2002 09:31:00
MY_PARAGRAPH
0001 PA
0002 CONNECT ODBC_DSN
0003 DATA USER_NAME
0004 DATA PASSWORD
0005 DATA {CALL STORED_PROC_CALL('ARG_1', 'ARG_2')};
OR
0005 DATA MY_SQL_STATEMENT;
0006 DATA .Q
I need to do database access using BASIC routines. Can any one help
Thanks..
Nilotpal.
Edited by - kww on 08/30/2002 09:31:00
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is a series of functions, collectively known as the BASIC SQL Client Interface (BCI). These mimic the functions of the ODBC API, for example, SQLConnect(), SQLPrepare(), SQLExecute(), SQLFetch() and so on.
To use these, you also require a properly-licensed ODBC driver, a DSN configured to connect to the database in question, and the DSN properly registered in the uvodbc.config file in your DataStage project directory on the server (hint: importing a table definition from the data source will update uvodbc.config).
There is a manual for the BCI functions, which you can find at http://www.informix.com/answers/english ... ci/BCI.pdf
To use these, you also require a properly-licensed ODBC driver, a DSN configured to connect to the database in question, and the DSN properly registered in the uvodbc.config file in your DataStage project directory on the server (hint: importing a table definition from the data source will update uvodbc.config).
There is a manual for the BCI functions, which you can find at http://www.informix.com/answers/english ... ci/BCI.pdf