Re: Bind Parameter is Too Big

On 9/1/22 1:34 PM, Kluzak, Matthew C. wrote:
> I support a system where staff use a PowerBuilder 2019R3 app that enters
> data into a Postgres 12 database, generates SQL statements for the data
> and saves them as text files. Staff uses another PB2019R3 app to
> populate a Sybase ASE 15.7 database with the generated SQL statement
> files. Other staff then uses a PB2019R3 app to pipe the data to a master
> Sybase ASE 15.7 database. At the beginning of each week that data is
> piped via PB2019R3 app to another Sybase ASE 15.7 database. The
> inspectors then update their Postgres database with all inspectors' data
> via another PB2019R3 app that pipes the data from Sybase to Postgres.
>
> * Yes, I understand how absurd the system is. I just inherited it and
> am supporting it until we can replace it.

The .gov domain was explanation enough.

> However, when trying to pipe the data from Sybase to Postgres
> I get the error "Bind Parameter for value :9 is Too Big (2000)." The
> comment column is the 9th column.
>
> I checked the data and verified it isn't over the 1000 character limit.
> I tried deleting out 13 of the 1000 characters, and the error this time
> was "Bind Parameter for value :9 is Too Big (1976)."

What is the actual code that pipes the data?

What is the encoding/character set in Sybase vs Postgres?

>
> Via Appeon’s support forums I worked out getting the pipe to work in the
> PowerBuilder IDE by enabling staticbind and disablebind. In this view, I
> can get a connection string to use in the app’s configuration file.
> However, using this connection string in the app’s configuration file
> still doesn’t work when running the pipe in the app.
>
> Connection string is:
> DBParm=ConnectString='DSN=WM_LT_User;UID=user;PWD=password',PBCatalogOwner='user',DelimitIdentifier='Yes',DisableBind=1
>
> Appeon is claiming it is a Postgres issue and so I am inquiring here. I
> am hoping someone can help steer me in the right direction to get this
> pipe working.
>
> Thanks
>
> Matt Kluzak
>
> Technology Director
>
> North Dakota Public Service Commission
>
> 600 E Boulevard Ave
>
> Dept 408 13^th Floor
>
> Bismarck, ND  58505-0480
>
> Phone: 701-328-4075
>
>
> ------------------------------------------------------------------------
> This transmission, email and any files transmitted with it, may be: (1)
> subject to the Attorney-Client Privilege, (2) an attorney work product,
> or (3) strictly confidential under federal or state law. If you are not
> the intended recipient of this message, you may not use, disclose,
> print, copy or disseminate this information. If you have received this
> transmission in error, notify the sender (only) and delete the message.
> This message may also be subject to disclosure under the North Dakota
> Open Records Laws.
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com