• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Create a datawindow with a bigserial field using Informix 64bit

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved Create a datawindow with a bigserial field using Informix 64bit

  1. How-to
0
Votes
Undo
  1. Guillermo Pereira
    Guillermo Pereira
  2. PowerBuilder
  3. Friday, 21 December 2018 15:20 PM UTC

Hi,

I’m planing to migrate and testing the new version of PowerBuilder, 2017-R3.

Currently we have version 8.0 installed and we want to migrate our application to the latest version. We work with Informix Database.

The reason for this change is we are in need to change a datatype field in a table from SERIAL to BIGSERIAL.

To do this, we had to change the SDK from 32-bit to 64-bit. So, initially we were working with Informix SDK 2.90 32-bit and we had to install SDK 4.10 64-bit so our Query tool is able to see the new field, Otherwise we have the following message: "The data type (bigserial) is not supported for current client/server configuration."

Once we upgrade the driver, we are able to run any query.

Having updated you with our main issue, let’s get back to PowerBuilder matter:

I created an ODBC connection using Informix 4.10 64-bit and I called Grace64 and I’m able to use it for queries with no issues

So, when I’m trying to create a new ODBC connection in PowerBuilder, I’m not able to see this Data Source in the dropdown list, so there is no way to create a profile, I tried other options for Informix which are I10 Informix v10.x|v12x and IN9 Informix v9.x.

I was able to create these connections using these PB Drivers, but I’m not able to create a Datawindow properly for this table, once it’s created. ignores the BIGSERIAL fields.

When I try to update the Datawindow’s SQL manually, I got this Powerbuilder error:

"The data type (bigserial) is not supported for current client/server configuration. Do you want to correct errors?"

How can I make it works.

Best Regards

 

How to change the dropdown list when the user clic...
Using sp_send_dbmail through PB
Responses (3)
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Friday, 21 December 2018 17:11 PM UTC
  2. PowerBuilder
  3. # 1

You might need to update the pbodb170.ini file. The section INFORMIX_SPECIALDATATYPES is the likely spot. You'll then need to include the file with the exe.

Comment
There are no comments made yet.
Guillermo Pereira
Guillermo Pereira Accepted Answer Pending Moderation
  1. Friday, 21 December 2018 16:33 PM UTC
  2. PowerBuilder
  3. # 2

Thanks Chris for your prompt answer.

The thing is while I'm using IDE with 32-bit, I cant' see the bigserial field in the datawindow painter, so I'm not able to add it to the datawindow. Also I have installed SDK 64-bit and can't see the 64-bit data source.
This is the table structure:

CREATE TABLE MYtest (
mybigserial       bigserial(2147483647)   NOT NULL,
description       CHAR(20)
) ;
;
insert into MYtest VALUES (0,"1111111");
insert into MYtest VALUES (0,"2222222");
insert into MYtest VALUES (0,"3333333");
insert into MYtest VALUES (0,"4444444");
insert into MYtest VALUES (0,"5555555");
insert into MYtest VALUES (0,"6666666");
insert into MYtest VALUES (0,"7777777");
insert into MYtest VALUES (0,"8888888")
;

This is very important since we have a huge application and that field must be upgraded soon.

Thanks a lot for your help.

 

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 21 December 2018 17:14 PM UTC
The PB IDE should handle this DB data type as a LongLong data type (-9223372036854775808 to 9223372036854775807) in the DWO. The IBM 32bit driver should handle this as well. I wonder if its an issue with either the PB IDE's DB "interface" driver and/or DW Painter? The Data Pane in the DB Painter BTW is a DW object - so that's an interesting observation about the problem area. Sounds like this issue might be worthwhile opening a Support Ticket for.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 21 December 2018 16:12 PM UTC
  2. PowerBuilder
  3. # 3

Hi Guillermo;

   The reason is that the PB2017Rx IDE (and even PB2019 for that matter) is 32bit in nature. So you will need both the 32 & 64 bit DB client drivers installed in your development environment. The 64bit DB driver for testing your 64Bit PB App generated EXE's and the 32bit driver for the PB IDE itself.

HTH

Regards ... Chris

Comment
Guillermo Pereira
  1. Guillermo Pereira
  2. Thursday, 27 December 2018 16:14 PM UTC
Thanks Chris,

As I mentioned before, IDE 32-bit removes Bigserial fields from the DW, there is not way to add this field, If I edit the SQL (Convert to Syntax) it says: "Unspecified System" "Error = -9272 sqlerrm(bigserial)" and do not let me save it, and If force it using "edit source", the bigserial column does not come up, and I can't add it too.

It's kind of frustrating.

  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.