RSgvs_GenVal2Str

Alex wrote:

>
> Does anyone know what the purpose of this Ingres function was? It no
> longer exists in the current main codeline but it was used in the
> past. Thanks

RS sounds like Replication Server. I am away from the code this
weekend, but I'd guess it was some sort of replication server
generic value printer.

What are you doing that needs RSgvs_GenVal2Str?

Karl
 >> Stay informed about: RSgvs_GenVal2Str 

On Nov 29, 6:51 pm, kbcom... RemoveThis @kbcomputer.com wrote:
> Alex wrote:
>
> > Does anyone know what the purpose of this Ingres function was? It no
> > longer exists in the current main codeline but it was used in the
> > past. Thanks
>
> RS sounds like Replication Server.  I am away from the code this
> weekend, but I'd guess it was some sort of replication server
> generic value printer.
>
> What are you doing that needs RSgvs_GenVal2Str?
>
> Karl

I'm looking at a file that was deleted in 1998 that uses this
function. I'm trying to decipher what it actually does... Here's the
context:

if (RSgvs_GenVal2Str(col, dk, where_list + STlength(where_list)) !=
OK)
return (RS_INTERNAL_ERR);

This is a file that uses ESQL, and I'm looking at it to get a better
idea how to use parameterized queries in updates. Also wondering if
it's possible to use parameters in a delete query.
Thanks

Alex
 >> Stay informed about: RSgvs_GenVal2Str 

On Dec 1, 2008, at 7:31 AM, Alex wrote:

> On Nov 29, 6:51 pm, kbcom....DeleteThis@kbcomputer.com wrote:
>> Alex wrote:
>>
>>> Does anyone know what the purpose of this Ingres function was? It no
>>> longer exists in the current main codeline but it was used in the
>>> past. Thanks
>>
>> RS sounds like Replication Server. I am away from the code this
>> weekend, but I'd guess it was some sort of replication server
>> generic value printer.
>>
>> What are you doing that needs RSgvs_GenVal2Str?
>>
>> Karl
>
> I'm looking at a file that was deleted in 1998 that uses this
> function. I'm trying to decipher what it actually does... Here's the
> context:
>
> if (RSgvs_GenVal2Str(col, dk, where_list + STlength(where_list)) !=
> OK)
> return (RS_INTERNAL_ERR);
>

That is indeed part of an old variant of the Replication Server.
(STlength is an Ingres internal equivalent of strlen(), and it's a
dead giveaway along with the RS_INTERNAL_ERR symbol.) You can assume
that RSgvs_GenVal2Str takes some kind of generic value and makes a
string out of it. Apparently the code is building a WHERE clause.

Delete and update queries both allow parameters in the WHERE clause.
Neither allow them in the FROM clause, as far as I know.
I'm pretty sure that UPDATE allows them in the SET clauses but I'm
not 100% positive about that one.
Are you using parameters in the :host-variable sense, or ?-markers
in a PREPARE statement?

Karl
 >> Stay informed about: RSgvs_GenVal2Str