InfoSphere Optim

Hello,

Which Optim stored procedures do you use for a PostgreSQL dbalias?  Does PostgreSQL have its own set of procedures or do you use a set from another DBMS?

Thank you!

------------------------------
Trong Bo
Senior Environment Administrator
HealthNow New York
------------------------------

#InfoSphereOptim
#Optim

Can anyone help with this?

------------------------------
Trong Bo
Senior Environment Administrator
HealthNow New York
------------------------------

Original Message:
Sent: Tue May 28, 2019 04:13 PM
From: Trong Bo
Subject: PostgreSQL Optim Stored Procedures

Hello,

Which Optim stored procedures do you use for a PostgreSQL dbalias?  Does PostgreSQL have its own set of procedures or do you use a set from another DBMS?

Thank you!

------------------------------
Trong Bo
Senior Environment Administrator
HealthNow New York
------------------------------

#InfoSphereOptim
#Optim

Original Message------

Can anyone help with this?

------------------------------
Trong Bo
Senior Environment Administrator
HealthNow New York
------------------------------

#InfoSphereOptim
#Optim

Finally got this solved!

I changed a few things (all dealing with the ODBC driver):

1. Make sure you are using a driver that is the same version as your PostgreSQL database for "Optim"-um performance and compatibility.
2. When configuring the ODBC driver, in the "Options" subgroup, click on Datasource, then check "Use Declare/Fetch" and in the "Unknown sizes" subgroup, select "Longest".

After doing this, I was able to extract rows without error.

Thanks for your help, Paul!


------------------------------
Trong Bo
Senior Environment Administrator
HealthNow New York
------------------------------

Original Message:
Sent: Thu June 13, 2019 10:19 PM
From: Trong Bo
Subject: PostgreSQL Optim Stored Procedures

Thank you, Paul!

So I set up the connection and created an extract request to extract 1 row of data from 1 table, but the request ends with the error message:

"HY000 out of memory for query result"

No rows are extracted and I've tried setting the DBAlias to use ANSI and then Unicode.  Both end with the same error.

Any suggestions?

Thank you,

Trong

Original Message------

Can anyone help with this?

------------------------------
Trong Bo
Senior Environment Administrator
HealthNow New York
------------------------------

#InfoSphereOptim
#Optim

Original Message------

Finally got this solved!

I changed a few things (all dealing with the ODBC driver):

1. Make sure you are using a driver that is the same version as your PostgreSQL database for "Optim"-um performance and compatibility.
2. When configuring the ODBC driver, in the "Options" subgroup, click on Datasource, then check "Use Declare/Fetch" and in the "Unknown sizes" subgroup, select "Longest".

After doing this, I was able to extract rows without error.

Thanks for your help, Paul!


------------------------------
Trong Bo
Senior Environment Administrator
HealthNow New York
------------------------------

#InfoSphereOptim
#Optim