PowerCenter
- PowerCenter 10.5.3
- All Products
$ ODBCHOME=/export/home/Informatica/10.0.0/ODBC7.1; export ODBCHOME
$ setenv ODBCHOME /export/home/Informatica/10.0.0/ODBC7.1
$ PATH=${PATH}:$ODBCHOME/bin; export PATH
$ setenv PATH ${PATH}:$ODBCHOME/bin
Operating System
| Variable
|
---|---|
Linux
| LD_LIBRARY_PATH
|
AIX
| LIBPATH
|
$ LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$HOME/server_dir:$ODBCHOME/lib; export LD_LIBRARY_PATH
$ setenv LD_LIBRARY_PATH $HOME/server_dir:$ODBCHOME:${LD_LIBRARY_PATH}
$ LIBPATH=${LIBPATH}:$HOME/server_dir:$ODBCHOME/lib; export LIBPATH
$ setenv LIBPATH ${LIBPATH}:$HOME/server_dir:$ODBCHOME/lib
$ cp $ODBCHOME/odbc.ini $HOME/.odbc.ini
MY_MSSQLSERVER_ODBC_SOURCE=<Driver name or data source description> [MY_SQLSERVER_ODBC_SOURCE] Driver=<path to ODBC drivers> Description=DataDirect 8.0 SQL Server Wire Protocol Database=<SQLServer_database_name> LogonID=<username> Password=<password> Address=<TCP/IP address>,<port number> QuoteId=No AnsiNPW=No ApplicationsUsingThreads=1
InstallDir=/export/home/Informatica/10.0.0/ODBC7.1
$ ODBCINI=/$HOME/.odbc.ini; export ODBCINI
$ setenv ODBCINI $HOME/.odbc.ini
$ source .profile
$ source .cshrc
Driver = /export/home/Informatica/10.0.0/ODBC7.1/lib/DWxxxxnn.so
ddtestlib /export/home/Informatica/10.0.0/ODBC7.1/lib/DWxxxxnn.so