DSXchange

Hi,
Am getting below error when i mark Yes to Enable Partition Property to Yes and give Modulus Parition and provide a column name on which query should run

IS-CONN-ODBC-000004] ODBC function "SQLConnect" reported: SQLSTATE = IM002: Native Error Code = 0: Msg = [DataDirect][ODBC lib] System information file not found. Please check the ODBCINI environment variable. (CC_OdbcConnection::connect, file CC_OdbcConnection.cpp, line 438)
[IIS-CONN-ODBC-000004] ODBC function "SQLEndTran(SQL_ROLLBACK)" reported: SQLSTATE = 54: Native Error Code = 0: Msg = 523 52 (CC_OdbcConnection::rollback, file CC_OdbcConnection.cpp, line 953)

Job Design
ODBC Stage --> Copy--> Dataset

Same job completes successfully when i remove this partition property
Can you let me know what exact the error is how do I resolve

Welcome aboard.

DataStage is unable to find the $DSHOME/.odbcini file (whose pathname may also be stored in the ODBCINI environment variable). Seems to me you need to make sure that the .odbc.ini file exists and contains all needed DSNs. Also make sure that there exists a file called uvodbc.config (in $DSHOME as well as in the project) to make DSNs visible.

Hey Ray..
Then the job should not work even when i remove this Partition proprty right.
My job runs successfully when i set the Enable partition Proprty to No.Fails when i set to Yes.
The run time query which gets generated when i used modulus partition works fine in Toad. Not sure why it fails when i enable this property