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.

catalog table warning message

2 posts in PB Infomaker Report Writer Last posting was on 1999-04-22 14:36:54.0Z
Stephen Hamilton Posted on 1999-04-22 13:29:25.0Z
Newsgroups: sybase.public.infomaker.general
Date: Thu, 22 Apr 1999 09:29:25 -0400
From: Stephen Hamilton <SHamilton@delgroup.com>
X-Mailer: Mozilla 4.07 [en]C-delgroup (WinNT; U)
MIME-Version: 1.0
Subject: catalog table warning message
Content-Type: multipart/alternative; boundary="------------DDB28F8D67807E4800AE305B"
Lines: 69
Message-ID: <348_371F242D.DDF658EB@delgroup.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6409
Article PK: 241394

I along with several other users are trying to determine the souce of a recent warning message which appears when connecting to a db.  When InfoMaker is started, and the login is complete, a warning message appears stating:
 
"Catalog Tables Cannot Be Created And Are Not Available For Use"

I have contacted the DBA as well as several other users to see if they've encountered that problem before and they have not.  I was hoping to get an idea of what this means and what the possible solution might be.

One interesting note, although InfoMaker seems to run fine after you click OK on the warning message, when creating computed variables in a report, the data format tab is blank.  You have to physically type in the format for a field such as: mm/dd/yy for a date format or $0,000.00 for a financial format.

Any help???

Steve Hamilton
Delaware Investments


Terry Dykstra Posted on 1999-04-22 14:36:54.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: catalog table warning message
Date: Thu, 22 Apr 1999 08:36:54 -0600
Lines: 137
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0015_01BE8C9B.46851960"
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_vHpEa0Mj#GA.301@forums.sybase.com>
References: <348_371F242D.DDF658EB@delgroup.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6408
Article PK: 241393

When you login, IM determines whether the catalog tables (PBCATxxx) exist.  If they don't, it tries to create them.  If you don't have DBA authority, it will fail.  The PBCATxxx tables are used to store information about edit styles, validation rules etc.  They are not required to run IM or PB, but they make life a lot easier.
Ask your DBA to login with IM using a DBA account (for instance, in Oracle you would use SYSTEM).  Once that is done, all users should be fine.
Alternatively, to suppres the prompt, you can set in the im.ini file the following parameter:
[Database]
NoCatalog=1

--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.
Stephen Hamilton wrote in message <371F242D.DDF658EB@delgroup.com>...
I along with several other users are trying to determine the souce of a recent warning message which appears when connecting to a db.  When InfoMaker is started, and the login is complete, a warning message appears stating:
 
"Catalog Tables Cannot Be Created And Are Not Available For Use"

I have contacted the DBA as well as several other users to see if they've encountered that problem before and they have not.  I was hoping to get an idea of what this means and what the possible solution might be.

One interesting note, although InfoMaker seems to run fine after you click OK on the warning message, when creating computed variables in a report, the data format tab is blank.  You have to physically type in the format for a field such as: mm/dd/yy for a date format or $0,000.00 for a financial format.

Any help???

Steve Hamilton
Delaware Investments