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.

sp_columns default is always 'null'

5 posts in General Discussion Last posting was on 2012-02-08 18:40:20.0Z
Jason L. Froebe [TeamSybase] Posted on 2012-02-07 19:34:06.0Z
From: "Jason L. Froebe [TeamSybase]" <jason.froebe@gmail.com>
Organization: TeamSybase
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:9.0) Gecko/20111229 Thunderbird/9.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: sp_columns default is always 'null'
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f317cae$1@forums-1-dub>
Date: 7 Feb 2012 11:34:06 -0800
X-Trace: forums-1-dub 1328643246 10.22.241.152 (7 Feb 2012 11:34:06 -0800)
X-Original-Trace: 7 Feb 2012 11:34:06 -0800, vip152.sybase.com
Lines: 6
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30892
Article PK: 73778

Anyone know why sp_columns always returns null for the default value?

I ask because I'm working on the sybase ase parser component for
SQL::Translator.

jason


Jason L. Froebe [TeamSybase] Posted on 2012-02-07 19:41:57.0Z
From: "Jason L. Froebe [TeamSybase]" <jason.froebe@gmail.com>
Organization: TeamSybase
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:9.0) Gecko/20111229 Thunderbird/9.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: sp_columns default is always 'null'
References: <4f317cae$1@forums-1-dub>
In-Reply-To: <4f317cae$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f317e85$1@forums-1-dub>
Date: 7 Feb 2012 11:41:57 -0800
X-Trace: forums-1-dub 1328643717 10.22.241.152 (7 Feb 2012 11:41:57 -0800)
X-Original-Trace: 7 Feb 2012 11:41:57 -0800, vip152.sybase.com
Lines: 15
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30893
Article PK: 73786


On 02/07/2012 01:34 PM, Jason L. Froebe [TeamSybase] wrote:
> Anyone know why sp_columns always returns null for the default value?
>
> I ask because I'm working on the sybase ase parser component for
> SQL::Translator.
>
> jason

Let me rephrase, it is hard coded in the stored proc. I guess my
question is why did Sybase do the bare minimum to meet the ODBC spec.
Just makes more work for us.. head*desk

grrr

jason


J Posted on 2012-02-08 18:17:55.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: sp_columns default is always 'null'
Reply-To: J@bogusemailAddress.com
Message-ID: <4f32bb0f.757651375@forums.sybase.com>
References: <4f317cae$1@forums-1-dub> <4f317e85$1@forums-1-dub>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 8 Feb 2012 10:17:55 -0800
X-Trace: forums-1-dub 1328725075 10.22.241.152 (8 Feb 2012 10:17:55 -0800)
X-Original-Trace: 8 Feb 2012 10:17:55 -0800, vip152.sybase.com
Lines: 29
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30901
Article PK: 73791

On 7 Feb 2012 11:41:57 -0800, "Jason L. Froebe [TeamSybase]"
<jason.froebe@gmail.com> wrote:

Jason - I looked into it. I don't have all the answers but I think
the original problem was related to CIS use of the procedures with
some Direct Connects (don't quote me). I think ASE was ok but proxy
tables could be broken.

Look at sp_odbc_columns to get code or possibly use. I did not find a
relevant CR.

Jay Anderson

>On 02/07/2012 01:34 PM, Jason L. Froebe [TeamSybase] wrote:
>> Anyone know why sp_columns always returns null for the default value?
>>
>> I ask because I'm working on the sybase ase parser component for
>> SQL::Translator.
>>
>> jason
>
>Let me rephrase, it is hard coded in the stored proc. I guess my
>question is why did Sybase do the bare minimum to meet the ODBC spec.
>Just makes more work for us.. head*desk
>
>grrr
>
>jason


Jason L. Froebe [TeamSybase] Posted on 2012-02-08 18:38:59.0Z
From: "Jason L. Froebe [TeamSybase]" <jason.froebe@gmail.com>
Organization: TeamSybase
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:9.0) Gecko/20111229 Thunderbird/9.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: sp_columns default is always 'null'
References: <4f317cae$1@forums-1-dub> <4f317e85$1@forums-1-dub> <4f32bb0f.757651375@forums.sybase.com>
In-Reply-To: <4f32bb0f.757651375@forums.sybase.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f32c143@forums-1-dub>
Date: 8 Feb 2012 10:38:59 -0800
X-Trace: forums-1-dub 1328726339 10.22.241.152 (8 Feb 2012 10:38:59 -0800)
X-Original-Trace: 8 Feb 2012 10:38:59 -0800, vip152.sybase.com
Lines: 24
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30902
Article PK: 73793


On 02/08/2012 12:17 PM, J wrote:
> On 7 Feb 2012 11:41:57 -0800, "Jason L. Froebe [TeamSybase]"
> <jason.froebe@gmail.com> wrote:
>
> Jason - I looked into it. I don't have all the answers but I think
> the original problem was related to CIS use of the procedures with
> some Direct Connects (don't quote me). I think ASE was ok but proxy
> tables could be broken.
>
> Look at sp_odbc_columns to get code or possibly use. I did not find a
> relevant CR.
>
> Jay Anderson

Thanks Jay!

I took the example from the SQL Loader
(DBIx::Class::Schema::Loader::DBI::Sybase) and will be accessing the
system tables instead of going through the stored procedures.

http://search.cpan.org/~rkitover/DBIx-Class-Schema-Loader/lib/DBIx/Class/Schema/Loader/DBI/Sybase.pm

jason


Jason L. Froebe [TeamSybase] Posted on 2012-02-08 18:40:20.0Z
From: "Jason L. Froebe [TeamSybase]" <jason.froebe@gmail.com>
Organization: TeamSybase
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:9.0) Gecko/20111229 Thunderbird/9.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: sp_columns default is always 'null'
References: <4f317cae$1@forums-1-dub> <4f317e85$1@forums-1-dub> <4f32bb0f.757651375@forums.sybase.com> <4f32c143@forums-1-dub>
In-Reply-To: <4f32c143@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f32c194$1@forums-1-dub>
Date: 8 Feb 2012 10:40:20 -0800
X-Trace: forums-1-dub 1328726420 10.22.241.152 (8 Feb 2012 10:40:20 -0800)
X-Original-Trace: 8 Feb 2012 10:40:20 -0800, vip152.sybase.com
Lines: 30
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30903
Article PK: 73792


On 02/08/2012 12:38 PM, Jason L. Froebe [TeamSybase] wrote:
> On 02/08/2012 12:17 PM, J wrote:
>> On 7 Feb 2012 11:41:57 -0800, "Jason L. Froebe [TeamSybase]"
>> <jason.froebe@gmail.com> wrote:
>>
>> Jason - I looked into it. I don't have all the answers but I think
>> the original problem was related to CIS use of the procedures with
>> some Direct Connects (don't quote me). I think ASE was ok but proxy
>> tables could be broken.
>>
>> Look at sp_odbc_columns to get code or possibly use. I did not find a
>> relevant CR.
>>
>> Jay Anderson
>
> Thanks Jay!
>
> I took the example from the SQL Loader
> (DBIx::Class::Schema::Loader::DBI::Sybase) and will be accessing the
> system tables instead of going through the stored procedures.
>
> http://search.cpan.org/~rkitover/DBIx-Class-Schema-Loader/lib/DBIx/Class/Schema/Loader/DBI/Sybase.pm
>
> jason
>

I hit send too soon. I'm writing up a patch for Michael Peppler's
DBD::Sybase Perl Module to access the system tables

jason