Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

zeroes into, output

2 posts in General Discussion Last posting was on 2009-12-10 14:33:30.0Z
straygod Posted on 2009-12-10 13:06:22.0Z
From: "straygod" <plain@mail.com>
Newsgroups: sybase.public.ase.general
Subject: zeroes into, output
Date: Thu, 10 Dec 2009 10:06:22 -0300
Organization: Aioe.org NNTP Server
Lines: 12
Message-ID: <hfqrn6$36c$1@aioe.org>
NNTP-Posting-Host: pghU/bf4soe3hFRMqHw9gw.user.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Complaints-To: abuse@aioe.org
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18049
X-Notice: Filtered by postfilter v. 0.8.0
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
Cancel-Lock: sha1:YPVd6mh+B1P5ZDA85zaf8a/dDsI=
X-Priority: 3
X-MSMail-Priority: Normal
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!newsfeed.news2me.com!newsfeed2.telusplanet.net!newsfeed.telus.net!feeder.erje.net!feeder.visyn.net!visyn.net!aioe.org!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28749
Article PK: 77992

aloha all !
is there such a way that if :

SELECT 00000.00000 field1 INTO #temp

is run, decimal(10,5) field1 is get, or displayed ? been playing with SET
options without further advances. Noticed numeric_truncation (8) can't be
disabled as option.
I'm testing with isql, default collate.

thanks, regards, merry posts :)


"Mark A. Parsons" <iron_horse Posted on 2009-12-10 14:33:30.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: zeroes into, output
References: <hfqrn6$36c$1@aioe.org>
In-Reply-To: <hfqrn6$36c$1@aioe.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 091201-0, 12/01/2009), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b2106ba$1@forums-1-dub>
Date: 10 Dec 2009 06:33:30 -0800
X-Trace: forums-1-dub 1260455610 10.22.241.152 (10 Dec 2009 06:33:30 -0800)
X-Original-Trace: 10 Dec 2009 06:33:30 -0800, vip152.sybase.com
Lines: 16
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28750
Article PK: 77991

SELECT convert(numeric(10,5) ,00000.00000) field1 INTO #temp
SELECT convert(numeric(10,5) null ,00000.00000) field1 INTO #temp
SELECT convert(numeric(10,5) not null ,00000.00000) field1 INTO #temp

straygod wrote:
> aloha all !
> is there such a way that if :
>
> SELECT 00000.00000 field1 INTO #temp
>
> is run, decimal(10,5) field1 is get, or displayed ? been playing with
> SET options without further advances. Noticed numeric_truncation (8)
> can't be disabled as option.
> I'm testing with isql, default collate.
>
> thanks, regards, merry posts :)