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.

systable columns

4 posts in General Discussion Last posting was on 2012-05-08 14:37:08.0Z
John Kirkwood Posted on 2012-03-28 13:22:30.0Z
Sender: 4762.4f730f6a.1804289383@sybase.com
From: John Kirkwood
Newsgroups: sybase.public.iq
Subject: systable columns
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f731096.47a3.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 28 Mar 2012 05:22:30 -0800
X-Trace: forums-1-dub 1332940950 172.20.134.41 (28 Mar 2012 05:22:30 -0800)
X-Original-Trace: 28 Mar 2012 05:22:30 -0800, 172.20.134.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4480
Article PK: 246620

I have a log tasble defined in the catalog (so that I can
have multiple writers)
After purging I see a high value in column ext_page_count of
systable
Can anyone tell me what this signifies and if it is a
problem?


John Kirkwood Posted on 2012-03-28 14:07:09.0Z
Sender: 4762.4f730f6a.1804289383@sybase.com
From: John Kirkwood
Newsgroups: sybase.public.iq
Subject: Re: systable columns
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f731b0d.49d7.1681692777@sybase.com>
References: <4f731096.47a3.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 28 Mar 2012 06:07:09 -0800
X-Trace: forums-1-dub 1332943629 172.20.134.41 (28 Mar 2012 06:07:09 -0800)
X-Original-Trace: 28 Mar 2012 06:07:09 -0800, 172.20.134.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4481
Article PK: 246621

sorry meant to add that there are no BLOB columns on the
table
char(1500) is used

> I have a log tasble defined in the catalog (so that I can
> have multiple writers)
> After purging I see a high value in column ext_page_count
> of systable
> Can anyone tell me what this signifies and if it is a
> problem?


John Kirkwood Posted on 2012-03-28 15:11:09.0Z
Sender: 4762.4f730f6a.1804289383@sybase.com
From: John Kirkwood
Newsgroups: sybase.public.iq
Subject: Re: systable columns
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f732a0d.4ccb.1681692777@sybase.com>
References: <4f731b0d.49d7.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 28 Mar 2012 07:11:09 -0800
X-Trace: forums-1-dub 1332947469 172.20.134.41 (28 Mar 2012 07:11:09 -0800)
X-Original-Trace: 28 Mar 2012 07:11:09 -0800, 172.20.134.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4482
Article PK: 246623

I see - it is the >255 char column space

> sorry meant to add that there are no BLOB columns on the
> table
> char(1500) is used
>
> > I have a log tasble defined in the catalog (so that I
> > can have multiple writers)
> > After purging I see a high value in column
> > ext_page_count of systable
> > Can anyone tell me what this signifies and if it is a
> > problem?


Balas Posted on 2012-05-08 14:37:08.0Z
Sender: 4ea1.4fa92a8f.1804289383@sybase.com
From: Balas
Newsgroups: sybase.public.iq
Subject: How to convert gregorian date to Hijri and Vice versa
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4fa92f94.4f9b.1681692777@sybase.com>
References: <4f731096.47a3.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 8 May 2012 07:37:08 -0700
X-Trace: forums-1-dub 1336487828 172.20.134.41 (8 May 2012 07:37:08 -0700)
X-Original-Trace: 8 May 2012 07:37:08 -0700, 172.20.134.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4501
Article PK: 246643

Hi Experts -

Can any one suggest the available method/Function to convert
gregorian date to Hijri and Vice versa?

Thanks In advance.

-Balas