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.

URGENT - timestamp datatype

5 posts in General Discussion (old) Last posting was on 2000-03-10 17:14:15.0Z
Sem Kazazic Posted on 2000-03-10 14:22:50.0Z
Newsgroups: sybase.public.easerver
From: "Sem Kazazic" <semk@vytalnet.com>
Subject: URGENT - timestamp datatype
Date: Fri, 10 Mar 2000 09:22:50 -0500
Lines: 108
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_001C_01BF8A72.34C3B850"
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: 209.121.88.73
Message-ID: <347_OA0PFzpi$GA.74@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26693
Article PK: 157686

Hi,
 
I know that sqlserver group is more appropriate for this kind of question, but I posted similar questions there and got no answer.
The questions are very simple and I am sure many people here can answer it.
 
I installed ASE 11.9.2 /NT and created new database using sybase central.
Tried to add timestamp column , but when I add new column I cannot see user-defined datatype in a dropdown list.
According to the help, " ASE supplies several system datatype, and two user-defined datatypes, timestamp and sysname".
I have the experience with ASA, but it does not help too much with ASE.
Because of that, I decided to use powerdesigner to create database and according to ASE related def file, timestamp is valid datatype.
But when I tried to generate db from the model again I got an error message like timestamp is not valid user-defined datatype.
I would like to ask:
1. Is timestamp valid column datatype for ASE 11.9.2, if yes should I have timestamp in a list of column datatype in sybase central ?
2. Did I miss something during ASE install? Or should I do some additional setup to have timestamp as a valid datatype ?
 
We have to solve this ASAP and I apologize for posting this here.
 
Thanks.
Regards,
Sem.
 


Lance Andersen Posted on 2000-03-10 15:24:08.0Z
Newsgroups: sybase.public.easerver
Date: Fri, 10 Mar 2000 10:24:08 -0500
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 4.7 [en] (X11; I; SunOS 5.7 sun4u)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: URGENT - timestamp datatype
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 48
NNTP-Posting-Host: alder.sybase.com 157.133.125.15
Message-ID: <347_38C91398.F67B27C@sybase.com>
References: <347_OA0PFzpi$GA.74@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26685
Article PK: 154421


> Sem Kazazic wrote:
>
> Hi,
>
> I know that sqlserver group is more appropriate for this kind of
> question, but I posted similar questions there and got no answer.
> The questions are very simple and I am sure many people here can
> answer it.
>
> I installed ASE 11.9.2 /NT and created new database using sybase
> central.
> Tried to add timestamp column , but when I add new column I cannot see
> user-defined datatype in a dropdown list.
> According to the help, " ASE supplies several system datatype, and two
> user-defined datatypes, timestamp and sysname".
> I have the experience with ASA, but it does not help too much with
> ASE.
> Because of that, I decided to use powerdesigner to create database and
> according to ASE related def file, timestamp is valid datatype.
> But when I tried to generate db from the model again I got an error
> message like timestamp is not valid user-defined datatype.
> I would like to ask:
> 1. Is timestamp valid column datatype for ASE 11.9.2, if yes should I
> have timestamp in a list of column datatype in sybase central ?
> 2. Did I miss something during ASE install? Or should I do some
> additional setup to have timestamp as a valid datatype ?
>
> We have to solve this ASAP and I apologize for posting this here.
>
> Thanks.
> Regards,
> Sem.
>

Timestamp in ase is a varbinary user defined time. You should use the
datetime datatype which is equivalent to what other RDBMS use.

--
===============================================================================
Lance J. Andersen Email: lancea@sybase.com
Sybase Product Support Engineering Phone:(781) 564-6336
77 South Bedford Street Fax: (781) 564-7001
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================


Sem Kazazic Posted on 2000-03-10 15:39:17.0Z
Newsgroups: sybase.public.easerver
From: "Sem Kazazic" <semk@vytalnet.com>
Subject: Re: URGENT - timestamp datatype
Date: Fri, 10 Mar 2000 10:39:17 -0500
Lines: 58
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: 209.121.88.73
Message-ID: <347_Ye#Tzdqi$GA.302@forums.sybase.com>
References: <347_OA0PFzpi$GA.74@forums.sybase.com> <347_38C91398.F67B27C@sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26683
Article PK: 157680

Thanks Lance.
I know how to use timestamp (and difference between asa and ase timestamp)
but simply I am not able to create the column as timestamp.
When you say varbinary, are you telling me that I have to use varbinary as
column datatype then timestamp as a default or something else is my problem?
Regards,
Sem.

Lance Andersen wrote in message <38C91398.F67B27C@sybase.com>...
>> Sem Kazazic wrote:
>>
>> Hi,
>>
>> I know that sqlserver group is more appropriate for this kind of
>> question, but I posted similar questions there and got no answer.
>> The questions are very simple and I am sure many people here can
>> answer it.
>>
>> I installed ASE 11.9.2 /NT and created new database using sybase
>> central.
>> Tried to add timestamp column , but when I add new column I cannot see
>> user-defined datatype in a dropdown list.
>> According to the help, " ASE supplies several system datatype, and two
>> user-defined datatypes, timestamp and sysname".
>> I have the experience with ASA, but it does not help too much with
>> ASE.
>> Because of that, I decided to use powerdesigner to create database and
>> according to ASE related def file, timestamp is valid datatype.
>> But when I tried to generate db from the model again I got an error
>> message like timestamp is not valid user-defined datatype.
>> I would like to ask:
>> 1. Is timestamp valid column datatype for ASE 11.9.2, if yes should I
>> have timestamp in a list of column datatype in sybase central ?
>> 2. Did I miss something during ASE install? Or should I do some
>> additional setup to have timestamp as a valid datatype ?
>>
>> We have to solve this ASAP and I apologize for posting this here.
>>
>> Thanks.
>> Regards,
>> Sem.
>>
>Timestamp in ase is a varbinary user defined time. You should use the
>datetime datatype which is equivalent to what other RDBMS use.
>
>--
>===========================================================================
====
>Lance J. Andersen Email: lancea@sybase.com
>Sybase Product Support Engineering Phone:(781) 564-6336
>77 South Bedford Street Fax: (781) 564-7001
>Burlington, MA 01803
>
>The Dark Knight Returns!!! Let's Go Penguins!!!
>===========================================================================

====


Lance Andersen Posted on 2000-03-10 17:00:36.0Z
Newsgroups: sybase.public.easerver
Date: Fri, 10 Mar 2000 12:00:36 -0500
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 4.7 [en] (X11; I; SunOS 5.7 sun4u)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: URGENT - timestamp datatype
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 76
NNTP-Posting-Host: alder.sybase.com 157.133.125.15
Message-ID: <347_38C92A34.FAF19722@sybase.com>
References: <347_OA0PFzpi$GA.74@forums.sybase.com> <347_38C91398.F67B27C@sybase.com> <347_Ye#Tzdqi$GA.302@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26661
Article PK: 157663

I am not aware of any issues using Sybase Central
to create a table with a timestamp column.

Worst case you could always use isql to create it.

Lance

Sem Kazazic wrote:
>
> Thanks Lance.
> I know how to use timestamp (and difference between asa and ase timestamp)
> but simply I am not able to create the column as timestamp.
> When you say varbinary, are you telling me that I have to use varbinary as
> column datatype then timestamp as a default or something else is my problem?
> Regards,
> Sem.
>
> Lance Andersen wrote in message <38C91398.F67B27C@sybase.com>...
> >> Sem Kazazic wrote:
> >>
> >> Hi,
> >>
> >> I know that sqlserver group is more appropriate for this kind of
> >> question, but I posted similar questions there and got no answer.
> >> The questions are very simple and I am sure many people here can
> >> answer it.
> >>
> >> I installed ASE 11.9.2 /NT and created new database using sybase
> >> central.
> >> Tried to add timestamp column , but when I add new column I cannot see
> >> user-defined datatype in a dropdown list.
> >> According to the help, " ASE supplies several system datatype, and two
> >> user-defined datatypes, timestamp and sysname".
> >> I have the experience with ASA, but it does not help too much with
> >> ASE.
> >> Because of that, I decided to use powerdesigner to create database and
> >> according to ASE related def file, timestamp is valid datatype.
> >> But when I tried to generate db from the model again I got an error
> >> message like timestamp is not valid user-defined datatype.
> >> I would like to ask:
> >> 1. Is timestamp valid column datatype for ASE 11.9.2, if yes should I
> >> have timestamp in a list of column datatype in sybase central ?
> >> 2. Did I miss something during ASE install? Or should I do some
> >> additional setup to have timestamp as a valid datatype ?
> >>
> >> We have to solve this ASAP and I apologize for posting this here.
> >>
> >> Thanks.
> >> Regards,
> >> Sem.
> >>
> >Timestamp in ase is a varbinary user defined time. You should use the
> >datetime datatype which is equivalent to what other RDBMS use.
> >
> >--
> >===========================================================================
> ====
> >Lance J. Andersen Email: lancea@sybase.com
> >Sybase Product Support Engineering Phone:(781) 564-6336
> >77 South Bedford Street Fax: (781) 564-7001
> >Burlington, MA 01803
> >
> >The Dark Knight Returns!!! Let's Go Penguins!!!
> >===========================================================================
> ====

--
===============================================================================
Lance J. Andersen Email: lancea@sybase.com
Sybase Product Support Engineering Phone:(781) 564-6336
77 South Bedford Street Fax: (781) 564-7001
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================


Sem Kazazic Posted on 2000-03-10 17:14:15.0Z
Newsgroups: sybase.public.easerver
From: "Sem Kazazic" <semk@vytalnet.com>
Subject: Re: URGENT - timestamp datatype
Date: Fri, 10 Mar 2000 12:14:15 -0500
Lines: 93
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: 209.121.88.73
Message-ID: <347_zSbl3Sri$GA.71@forums.sybase.com>
References: <347_OA0PFzpi$GA.74@forums.sybase.com> <347_38C91398.F67B27C@sybase.com> <347_Ye#Tzdqi$GA.302@forums.sybase.com> <347_38C92A34.FAF19722@sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26656
Article PK: 157653

I do not think that isql is the solution (or work around).
When I look in any db under sybase central (master, model) and click
user-defined datatype there is no timestamp at all.
Something is missing in ase installation, but I have no idea what?
It seems uninstall/install ase is only solution(not desired but ) .

Regards,
Sem.

Lance Andersen wrote in message <38C92A34.FAF19722@sybase.com>...
>I am not aware of any issues using Sybase Central
>to create a table with a timestamp column.
>
>Worst case you could always use isql to create it.
>
>Lance
>Sem Kazazic wrote:
>>
>> Thanks Lance.
>> I know how to use timestamp (and difference between asa and ase
timestamp)
>> but simply I am not able to create the column as timestamp.
>> When you say varbinary, are you telling me that I have to use varbinary
as
>> column datatype then timestamp as a default or something else is my
problem?
>> Regards,
>> Sem.
>>
>> Lance Andersen wrote in message <38C91398.F67B27C@sybase.com>...
>> >> Sem Kazazic wrote:
>> >>
>> >> Hi,
>> >>
>> >> I know that sqlserver group is more appropriate for this kind of
>> >> question, but I posted similar questions there and got no answer.
>> >> The questions are very simple and I am sure many people here can
>> >> answer it.
>> >>
>> >> I installed ASE 11.9.2 /NT and created new database using sybase
>> >> central.
>> >> Tried to add timestamp column , but when I add new column I cannot see
>> >> user-defined datatype in a dropdown list.
>> >> According to the help, " ASE supplies several system datatype, and two
>> >> user-defined datatypes, timestamp and sysname".
>> >> I have the experience with ASA, but it does not help too much with
>> >> ASE.
>> >> Because of that, I decided to use powerdesigner to create database and
>> >> according to ASE related def file, timestamp is valid datatype.
>> >> But when I tried to generate db from the model again I got an error
>> >> message like timestamp is not valid user-defined datatype.
>> >> I would like to ask:
>> >> 1. Is timestamp valid column datatype for ASE 11.9.2, if yes should I
>> >> have timestamp in a list of column datatype in sybase central ?
>> >> 2. Did I miss something during ASE install? Or should I do some
>> >> additional setup to have timestamp as a valid datatype ?
>> >>
>> >> We have to solve this ASAP and I apologize for posting this here.
>> >>
>> >> Thanks.
>> >> Regards,
>> >> Sem.
>> >>
>> >Timestamp in ase is a varbinary user defined time. You should use the
>> >datetime datatype which is equivalent to what other RDBMS use.
>> >
>> >--
>>
>===========================================================================
>> ====
>> >Lance J. Andersen Email: lancea@sybase.com
>> >Sybase Product Support Engineering Phone:(781) 564-6336
>> >77 South Bedford Street Fax: (781) 564-7001
>> >Burlington, MA 01803
>> >
>> >The Dark Knight Returns!!! Let's Go Penguins!!!
>>
>===========================================================================
>> ====
>
>--
>===========================================================================
====
>Lance J. Andersen Email: lancea@sybase.com
>Sybase Product Support Engineering Phone:(781) 564-6336
>77 South Bedford Street Fax: (781) 564-7001
>Burlington, MA 01803
>
>The Dark Knight Returns!!! Let's Go Penguins!!!
>===========================================================================

====