| Author |
Message
|
| ReemRashwan |
 Posted: Sun Nov 14, 2021 4:07 am Post subject: Configure DB2 Driver to Ignore SQL State 01003 |
 |
|
Novice
Joined: 09 Mar 2021
Posts: 12
|
Good Morning,
I am trying to retreive the data as a pivot table from a database but the operation fails with the following error:
| Code: |
BIP2322E: Database error: SQL State ''01003''; Native Error Code '0'; Error Text ''[IBM][CLI Driver][DB2/LINUXX8664] SQLSTATE 01003: Null values were eliminated from the argument of a column function. ''. : /build/jenkins_swg/slot2/product-build/WMB/src/DataFlowEngine/MessageServices/ImbOdbc.cpp: 4069: ImbOdbcStatement::checkRcInner: :
|
I searched online I found a suggestion to ignore this error in the driver.
https://www.ibm.com/support/pages/query-receives-sqlstate-01003
So I searched for 'ODBCINI' envrionemnt variable with the following command:
| Code: |
| printenv | grep odbc |
I opened the file and inserted the following to lines under my specific driver instaza:
| Code: |
IGNOREWARNINGS=1
IGNOREWARNLIST = "'01003'"
|
odbc.ini now is as the following:
| Code: |
[placeHolder]
Driver=placeHolder/libdb2o.so
Description=IBM DB2 ODBC Database
Database=placeHolder
HostName=placeHolder
PortNumber=placeHolder
User=placeHolder
Password=placeHolder
IGNOREWARNINGS=1
IGNOREWARNLIST = "'01003'"
|
Note: placeHolder is just a mask
I restarted the broker, restarted the server and deleted and redeployed the application but nothing worked 
I tried to modify the "libdb2o.so" file listed in odbc.ini in driver property but it as a binary file.
Any suggestions for driver modification? Am I modifying the wrong file? |
|
| Back to top |
|
 |
| abhi_thri |
| Posted: Mon Nov 15, 2021 12:31 am Post subject: |
|
|
Knight
Joined: 17 Jul 2017
Posts: 516
Location: UK
|
|
| Back to top |
|
|
| ReemRashwan |
| Posted: Mon Nov 15, 2021 12:40 am Post subject: |
|
|
Novice
Joined: 09 Mar 2021
Posts: 12
|
| abhi_thri wrote: |
hi...that link is asking to add those entries at db2cli.ini file and not at odbc.ini
|
I will search for it and I will feed you back |
|
| Back to top |
|
|
| ReemRashwan |
| Posted: Mon Nov 15, 2021 1:56 am Post subject: |
|
|
Novice
Joined: 09 Mar 2021
Posts: 12
|
I can't find it anywhere in the system 
I used the following command to find db2 installation location:
assuming db2 is under /sqllib/bin/, I navigated to /sqllib/cfg/ and I only found db2cli.ini.sample but not db2cli.ini.
I searched for the db2cli.ini using:
but there is no such file in the system, only db2cli.ini.sample in different locations.
I found multiple db2cli (without .ini) but they don't seem to be text files.
Any suggestions? |
|
| Back to top |
|
|
| abhi_thri |
| Posted: Mon Nov 15, 2021 3:50 am Post subject: |
|
|
Knight
Joined: 17 Jul 2017
Posts: 516
Location: UK
|
| ReemRashwan wrote: |
assuming db2 is under /sqllib/bin/, I navigated to /sqllib/cfg/ and I only found db2cli.ini.sample but not db2cli.ini. |
hi...see below link,
https://www.ibm.com/docs/en/db2/9.7?topic=keywords-db2cliini-initialization-file
| Quote: |
| you can create a db2cli.ini file that is based on the db2cli.ini.sample file and place the db2cli.ini file in the same location as the db2cli.ini.sample file. The db2cli.ini.sample file location is the default location from which the db2cli.ini file is read |
|
|
| Back to top |
|
|
|
|
