Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS: Fisql utility command fails to give (return status=0) for SQL Store proc with multiple output Tabs (Results+Messages)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: <vasanth.sengunthar AT accenture.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS: Fisql utility command fails to give (return status=0) for SQL Store proc with multiple output Tabs (Results+Messages)
  • Date: Mon, 22 Aug 2016 09:39:06 +0000

Hi,

Please check below sample SP.

Database : Microsoft SQL Server 2012
Protocol Version : tds_version = 7.0

[SP]
---------
USE [TEST01]
GO
/****** Object: StoredProcedure [dbo].[tst_test_result_msg] Script Date:
8/22/2016 5:31:16 AM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[tst_test_result_msg]
@tst_flag varchar(1),
@tst_desc varchar(40)
AS
BEGIN
DECLARE
@tst_activ_type varchar(5)

SELECT cust_no, cust_name
FROM dbo.customer

IF @tst_flag = 'A'
SELECT @tst_desc = 'Print A'
ELSE
IF @tst_flag = 'B'
SELECT @tst_desc = 'Print B'
ELSE
IF @tst_flag = 'C'
SELECT @tst_desc = 'Print C'
ELSE
IF @tst_flag = 'D'
SELECT @tst_desc = 'Print D'

PRINT @tst_desc
END


Regards,
Vasanth


-----Original Message-----
From: FreeTDS [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Igor
Korot
Sent: Sunday, August 21, 2016 7:03 AM
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] FreeTDS: Fisql utility command fails to give (return
status=0) for SQL Store proc with multiple output Tabs (Results+Messages)

Hi.
Do you have an example of one such SP?
What is you DB (MS, Sybase) and what version?
Which protocol version do you use?

All in all - we need more info.

Thank you.

On Aug 20, 2016 11:01 AM, <vasanth.sengunthar AT accenture.com> wrote:


Hi,



Thank you all in advance, please help me with below issue.



I have been working with fisql command lot lately and recently I came across
this issue, where the fisql command does not give (return status=0) for some
SQL execution.



The Issues is not generic but specific to any such SQL store procedure which
gives output in (results + message) format.



And the approach I like to present to out client includes such scenario where
they have multiple store procedure like above.



Looking forward to your earliest response,

Regards,
Vasanth Sengunthar

________________________________

This message is for the designated recipient only and may contain privileged,
proprietary, or otherwise confidential information. If you have received it
in error, please notify the sender immediately and delete the original. Any
other use of the e-mail by you is prohibited. Where allowed by local law,
electronic communications with Accenture and its affiliates, including e-mail
and instant messaging (including content), may be scanned by our systems for
the purposes of information security and assessment of internal compliance
with Accenture policy.
____________________________________________________________
__________________________

www.accenture.com
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.ibiblio.org_mailman_listinfo_freetds&d=DQICAg&c=eIGjsITfXP_y-DLLX0uEHXJvU8nOHrUK8IrwNKOtkVU&r=vQqnb-FGv_1Cq8lIuKD95mRfUO0gBovRe0eqdms7a5s&m=IodVUj5zMfeQKJDmDX80aFnfyn9y4W4EpZ5OBAzYolQ&s=aGO9gO5yFlXxuEHx6iLcCyFGQDh_XC5h1qsrfVFYXsM&e=
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.ibiblio.org_mailman_listinfo_freetds&d=DQICAg&c=eIGjsITfXP_y-DLLX0uEHXJvU8nOHrUK8IrwNKOtkVU&r=vQqnb-FGv_1Cq8lIuKD95mRfUO0gBovRe0eqdms7a5s&m=IodVUj5zMfeQKJDmDX80aFnfyn9y4W4EpZ5OBAzYolQ&s=aGO9gO5yFlXxuEHx6iLcCyFGQDh_XC5h1qsrfVFYXsM&e=





Archive powered by MHonArc 2.6.24.

Top of Page