ODBC 설정하는 방법

1.  /DataStage설치폴더/.odbc.ini

데이터 스테이지 ODBC 구성 파일로서 내용은 다음과 같다.
(필요한 ODBC dsn을 구성, NEWDB_ASE 또는 NEWDB_IQ 를 참고)



[NEWDB_ORA]
QEWSD=37449
Driver=/DataStage설치폴더/branded_odbc/lib/VMor815.so
Description=Oracle9
ServerName=COWAYDB
LogonID=wjdw
Password=wjdw

[NEWDB_ASE]
QEWSD=37471
Driver=/DataStage설치폴더/branded_odbc/lib/VMsyb15.so
Description=Sybase ASE 12.5
Database=WJDW_ODS
ServerName=COWAYDW_ASE
WorkstationID=wjdw
LogonID=로그인ID
Password=로그인암호
OptimizePrepare=2
SelectMethod=1


[NEWDB_ASIQ]
Driver=/opt/sybase/asiq/asiq12/lib/dbodbc6_r.so
Database=COWAYDW_ASIQ
HostName=jupiter:2638
ServerName=COWAYDW_ASIQ
LogonID=로그인ID
Password=로그인암호



2.  /project/NEW프로젝트명/uvodbc.config

Universe ODBC환경 파일로서 내용은 다음과 같다.
(추가된 NEWDB_ASE와 NEWDB_IQ 참고)

#
# This is the configuration file for the BCI and the UCI.  For more
# information, see either the BASIC SQL Client Interface Guide or the
# UniVerse Call Interface Guide.
#
# This file is NOT part of UV/ODBC.  However, it can affect UV/ODBC,
# because UV/ODBC communicates with UniVerse using the UCI.  For more
# information, see the UV/ODBC Server Guide.
#
[ODBC DATA SOURCES]
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1

<NEWDB_ORA>
DBMSTYPE = ODBC

<NEWDB_ASE>
DBMSTYPE = ODBC

<NEWDB_ASIQ>
DBMSTYPE = ODBC