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
Getting error when i enable partition property
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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
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