Page 1 of 1
database access using Routines
Posted: Fri Aug 30, 2002 3:00 am
by nilotpalr
I need to do database access using BASIC routines. Can any one help
Thanks..
Nilotpal.
Posted: Fri Aug 30, 2002 8:25 am
by kww
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
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
Posted: Sun Sep 01, 2002 3:55 pm
by ray.wurlod
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