FreeTDS Development Group

["Yeung, Alinga" <Alinga.Yeung AT nrc-cnrc.gc.ca>]

Hi,

We have not received any response to our request below. We are wondering if 
our request has been accepted or rejected. A response would be much 
appreciated.

In short, we are requesting that line 1469 in src/tds/mem.c (in freetds-0.91) 
be changed
from:
===
1469                         SQLS_ENTRY(3604,"23000");
===
to:
===
1469                         SQLS_ENTRY(3604,"01000");
===

Thank you in advance for your help.

Alinga
________________________________________
From: Yeung, Alinga
Sent: Wednesday, September 10, 2014 10:16 AM
To: freetds AT lists.ibiblio.org
Subject: Request to map Sybase status code '3604' to SQLSTATE '01000'

Hi,

We use Sybase. We are porting our software to use Freetds. We come across a 
status code mapping from Sybase to Freetds that results in a behavioural 
discrepancy in our software.

In src/tds/mem.c, the Sybase status code '3604' is mapped to SQLSTATUS 
'23000'. This is causing our software to fail.

Sybase status code '3604' does not require any action to be taken. Our 
software treats the status code as informational/warning and does not take 
any action.

SQLSTATE '23000' indicates an error instead.

Locally we have changed mem.c to map the Sybase status code '3604' to '01000' 
which is a general warning, and our software works fine.

We would like to request that Sybase status code '3604' be mapped to an 
informational SQLSTATUS, e.g. '01000'.

Thank you.

Alinga