Skip site navigation (1) Skip section navigation (2)

Re: BUG #1862: ECPG Connect, host variable trailing blanks

From: Jim(dot)Gray(at)Bull(dot)com
To: Michael Meskes <meskes(at)postgresql(dot)org>
Cc: Ken(dot)Rosensteel(at)Bull(dot)com, Michael Fuhr <mike(at)fuhr(dot)org>,pgsql-bugs(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: BUG #1862: ECPG Connect, host variable trailing blanks
Date: 2005-09-12 18:55:51
Message-ID: OF00CEF13E.9CE06130-ON0725707A.00669652-0725707A.0067FDC0@us-phx1.az05.bull.com (view raw or flat)
Thread:
Lists: pgsql-bugs
We are working in a rather complex environment, where COBOL/SQL on a 
legacy 
mainframe has its SQL portions sent via a high speed link to a Unix box.

The SQL is translated to a C/SQL environment in the process and the 
Postgres 
ECPG preprocessor is used on the Unix side for interfacing with Postgres.

We are already doing a translation from trailing blank Cobol strings
to C null terminated strings in this process for the connection host 
variables.

The reasons for requesting a Postgres option to strip trailing blanks in 
this case are:
1) we are not the only project to run into the problem of Postgres being 
oriented towards C strings
2) other RDBMS systems use the expected trimming of Cobol trailing blanks
3) when porting Oracle Cobol applications to Postgres, this option would 
be helpful
4) it might be better to strip the trailing blanks in the application if 
only one such application were involved,
     but when there are several such applications, centralizing the 
behavior in a Postgres option is preferrable







Michael Meskes <meskes(at)postgresql(dot)org> 
09/12/2005 04:06 AM

To
Jim(dot)Gray(at)Bull(dot)com
cc
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Ken(dot)Rosensteel(at)Bull(dot)com, Michael Fuhr 
<mike(at)fuhr(dot)org>, pgsql-bugs(at)postgresql(dot)org
Subject
Re: [BUGS] BUG #1862: ECPG Connect, host variable trailing blanks






On Fri, Sep 09, 2005 at 11:02:31AM -0700, Jim(dot)Gray(at)Bull(dot)com wrote:
> This would allow current behavior to be supported by ECPG and the 
Postgres 
> server,
> but allow applications that need the behavior (like a Cobol/SQL 
> preprocessor for Postgres),
> to make use of it.

Which preprocessor are you using? I wonder if such a logic should better
be implemented in the Cobol-C transition instead.

Michael
-- 
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot 
(De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes(at)jabber(dot)org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

In response to

pgsql-bugs by date

Next:From: KLEBER SILVADate: 2005-09-12 20:01:40
Subject: could help me?
Previous:From: Michael MeskesDate: 2005-09-12 11:06:44
Subject: Re: BUG #1862: ECPG Connect, host variable trailing blanks

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group