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.

column alias not displaying with ASE, but does with IQ??

5 posts in General Discussion Last posting was on 2007-06-13 14:25:59.0Z
JR Posted on 2007-06-12 17:04:18.0Z
Sender: 77d2.4668706c.1804289383@sybase.com
From: JR
Newsgroups: sybase.public.workspace.general
Subject: column alias not displaying with ASE, but does with IQ??
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <466ed212.5c79.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 12 Jun 2007 10:04:18 -0700
X-Trace: forums-1-dub 1181667858 10.22.241.41 (12 Jun 2007 10:04:18 -0700)
X-Original-Trace: 12 Jun 2007 10:04:18 -0700, 10.22.241.41
Lines: 25
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:423
Article PK: 1088112

I have a simple query below. When it runs against an IQ db
it displays with the column heading alias 'center id'. When
I run against ASE the column heading alias does not display,
only the column name does. tried both text and grid mode.
tried several alias methods with no luck (i.e ctr_id center
id, ctr_id 'center id', ctr_id as 'center id', etc...)

query: select ctr_id 'center id' from center

IQ:
center id
1

ASE:
ctr_id
1


Sybase WorkSpace
Version: 1.7.0
Build id: 2007022211

Adaptive Server Enterprise/12.5.3/EBF 13057
ESD#5/P/RS6000/AIX 5.1/ase1253/1939/64-bit/FBO/Tue Dec 6
03:37:19 2005


Samir Nigam Posted on 2007-06-12 18:51:14.0Z
From: "Samir Nigam" <samir_dot_nigam@sybase.com>
Newsgroups: sybase.public.workspace.general
References: <466ed212.5c79.1681692777@sybase.com>
Subject: Re: column alias not displaying with ASE, but does with IQ??
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: snigamxp.sybase.com
X-Original-NNTP-Posting-Host: snigamxp.sybase.com
Message-ID: <466eeb22$1@forums-1-dub>
Date: 12 Jun 2007 11:51:14 -0700
X-Trace: forums-1-dub 1181674274 10.22.85.206 (12 Jun 2007 11:51:14 -0700)
X-Original-Trace: 12 Jun 2007 11:51:14 -0700, snigamxp.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:425
Article PK: 1088115

This looks like a bug. We will create a CR.

Thanks,
Samir

<JR> wrote in message news:466ed212.5c79.1681692777@sybase.com...
>I have a simple query below. When it runs against an IQ db
> it displays with the column heading alias 'center id'. When
> I run against ASE the column heading alias does not display,
> only the column name does. tried both text and grid mode.
> tried several alias methods with no luck (i.e ctr_id center
> id, ctr_id 'center id', ctr_id as 'center id', etc...)
>
> query: select ctr_id 'center id' from center
>
> IQ:
> center id
> 1
>
> ASE:
> ctr_id
> 1
>
>
> Sybase WorkSpace
> Version: 1.7.0
> Build id: 2007022211
>
> Adaptive Server Enterprise/12.5.3/EBF 13057
> ESD#5/P/RS6000/AIX 5.1/ase1253/1939/64-bit/FBO/Tue Dec 6
> 03:37:19 2005


Mike Crocker Posted on 2007-06-12 19:27:45.0Z
From: "Mike Crocker" <crocker@sybase.com>
Newsgroups: sybase.public.workspace.general
References: <466ed212.5c79.1681692777@sybase.com>
Subject: Re: column alias not displaying with ASE, but does with IQ??
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vpn-concord-058.sybase.com
X-Original-NNTP-Posting-Host: vpn-concord-058.sybase.com
Message-ID: <466ef3b1$1@forums-1-dub>
Date: 12 Jun 2007 12:27:45 -0700
X-Trace: forums-1-dub 1181676465 158.159.8.58 (12 Jun 2007 12:27:45 -0700)
X-Original-Trace: 12 Jun 2007 12:27:45 -0700, vpn-concord-058.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:426
Article PK: 1088116

Engineering has dupulicated this issue and openned CR 471470

I'll update this posting once I get more feedback.

mike

<JR> wrote in message news:466ed212.5c79.1681692777@sybase.com...
>I have a simple query below. When it runs against an IQ db
> it displays with the column heading alias 'center id'. When
> I run against ASE the column heading alias does not display,
> only the column name does. tried both text and grid mode.
> tried several alias methods with no luck (i.e ctr_id center
> id, ctr_id 'center id', ctr_id as 'center id', etc...)
>
> query: select ctr_id 'center id' from center
>
> IQ:
> center id
> 1
>
> ASE:
> ctr_id
> 1
>
>
> Sybase WorkSpace
> Version: 1.7.0
> Build id: 2007022211
>
> Adaptive Server Enterprise/12.5.3/EBF 13057
> ESD#5/P/RS6000/AIX 5.1/ase1253/1939/64-bit/FBO/Tue Dec 6
> 03:37:19 2005


Mike Crocker Posted on 2007-06-12 19:52:46.0Z
From: "Mike Crocker" <crocker@sybase.com>
Newsgroups: sybase.public.workspace.general
References: <466ed212.5c79.1681692777@sybase.com> <466ef3b1$1@forums-1-dub>
Subject: Re: column alias not displaying with ASE, but does with IQ?? -- Correct CR number
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vpn-concord-058.sybase.com
X-Original-NNTP-Posting-Host: vpn-concord-058.sybase.com
Message-ID: <466ef98e$1@forums-1-dub>
Date: 12 Jun 2007 12:52:46 -0700
X-Trace: forums-1-dub 1181677966 158.159.8.58 (12 Jun 2007 12:52:46 -0700)
X-Original-Trace: 12 Jun 2007 12:52:46 -0700, vpn-concord-058.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:427
Article PK: 1088117

The CR number is actually CR 471467.

mike

"Mike Crocker" <crocker@sybase.com> wrote in message
news:466ef3b1$1@forums-1-dub...
> Engineering has dupulicated this issue and openned CR 471470
>
> I'll update this posting once I get more feedback.
>
> mike
>
> <JR> wrote in message news:466ed212.5c79.1681692777@sybase.com...
>>I have a simple query below. When it runs against an IQ db
>> it displays with the column heading alias 'center id'. When
>> I run against ASE the column heading alias does not display,
>> only the column name does. tried both text and grid mode.
>> tried several alias methods with no luck (i.e ctr_id center
>> id, ctr_id 'center id', ctr_id as 'center id', etc...)
>>
>> query: select ctr_id 'center id' from center
>>
>> IQ:
>> center id
>> 1
>>
>> ASE:
>> ctr_id
>> 1
>>
>>
>> Sybase WorkSpace
>> Version: 1.7.0
>> Build id: 2007022211
>>
>> Adaptive Server Enterprise/12.5.3/EBF 13057
>> ESD#5/P/RS6000/AIX 5.1/ase1253/1939/64-bit/FBO/Tue Dec 6
>> 03:37:19 2005
>
>


JR Posted on 2007-06-13 14:25:59.0Z
Sender: 77d2.4668706c.1804289383@sybase.com
From: JR
Newsgroups: sybase.public.workspace.general
Subject: Re: column alias not displaying with ASE, but does with IQ?? -- Correct CR number
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <466ffe77.7d4c.1681692777@sybase.com>
References: <466ef98e$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 13 Jun 2007 07:25:59 -0700
X-Trace: forums-1-dub 1181744759 10.22.241.41 (13 Jun 2007 07:25:59 -0700)
X-Original-Trace: 13 Jun 2007 07:25:59 -0700, 10.22.241.41
Lines: 44
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:428
Article PK: 1088118

thanks guys!

> The CR number is actually CR 471467.
>
> mike
>
> "Mike Crocker" <crocker@sybase.com> wrote in message
> news:466ef3b1$1@forums-1-dub...
> > Engineering has dupulicated this issue and openned CR
> 471470 >
> > I'll update this posting once I get more feedback.
> >
> > mike
> >
> > <JR> wrote in message
> news:466ed212.5c79.1681692777@sybase.com... >>I have a
> simple query below. When it runs against an IQ db >> it
> displays with the column heading alias 'center id'. When
> >> I run against ASE the column heading alias does not
> display, >> only the column name does. tried both text
> and grid mode. >> tried several alias methods with no luck
> (i.e ctr_id center >> id, ctr_id 'center id', ctr_id as
> 'center id', etc...) >>
> >> query: select ctr_id 'center id' from center
> >>
> >> IQ:
> >> center id
> >> 1
> >>
> >> ASE:
> >> ctr_id
> >> 1
> >>
> >>
> >> Sybase WorkSpace
> >> Version: 1.7.0
> >> Build id: 2007022211
> >>
> >> Adaptive Server Enterprise/12.5.3/EBF 13057
> >> ESD#5/P/RS6000/AIX 5.1/ase1253/1939/64-bit/FBO/Tue Dec
> 6 >> 03:37:19 2005
> >
> >
>
>