Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

PB8 Crash... Pls help

34 views
Skip to first unread message

Hendrick

unread,
Oct 28, 2003, 8:09:04 AM10/28/03
to
I develop with MySQL 4.x DB with MyODBC 3.5x.

I create a new datawindow , choose the table. I get an error :

SQLSTATE = S0002 [MySQL].. dbo.pbcattble does't exist.

It allow me to go on to select the required columns. However, when I
click on the selected column to set the propertis, PB8 crashes ..

What should I do to clear the SQLSTATE error ? Does turning off the
Catlog table help ? If yes, How Can I do it in PB8.

Greatly Appreciate any information that may help.

PB8 8.02 Build 9506
Win XP and WinNT SP6

melbourne

unread,
Oct 28, 2003, 8:31:04 PM10/28/03
to
It looks like you are missing the PB system tables or do not have
access to those tables. They are usually created when you first login
into the DB in PB... might be an access issue.

One possible solution is to create the PB tables with the right
permission and right owner. When they are created you will be able to
open ur DW without PB crashing out.
The scripts you will need

//
// This is the script to create the Powerbuilder system tables.
//
// Be sure to:
// - change all occurrences of 'PBOwner' to the name that will own
// the Powerbuilder system tables
// - change all occurrences of 'database.tablespace' to the
// appropriate value
// - put in appropriate statement delimiters for the tool you use
// to execute the sql (i.e. GO statement for ISQL)
// - strip comments and blank lines if necessary

CREATE TABLE PBOwner.PBCATTBL
( PBT_TNAM CHAR(30),
PBT_TID INTEGER,
PBT_OWNR CHAR(30),
PBD_FHGT SMALLINT,
PBD_FWGT SMALLINT,
PBD_FITL CHAR(1),
PBD_FUNL CHAR(1),
PBD_FCHR SMALLINT,
PBD_FPTC SMALLINT,
PBD_FFCE CHAR(18),
PBH_FHGT SMALLINT,
PBH_FWGT SMALLINT,
PBH_FITL CHAR(1),
PBH_FUNL CHAR(1),
PBH_FCHR SMALLINT,
PBH_FPTC SMALLINT,
PBH_FFCE CHAR(18),
PBL_FHGT SMALLINT,
PBL_FWGT SMALLINT,
PBL_FITL CHAR(1),
PBL_FUNL CHAR(1),
PBL_FCHR SMALLINT,
PBL_FPTC SMALLINT,
PBL_FFCE CHAR(18),
PBT_CMNT CHAR(254))
IN database.tablespace


CREATE UNIQUE INDEX PBCATTBL_IDX
ON PBOwner.PBCATTBL
(PBT_TNAM,
PBT_OWNR)


GRANT SELECT, UPDATE, INSERT, DELETE ON
PBOwner.PBCATTBL TO PUBLIC


CREATE TABLE PBOwner.PBCATCOL
( PBC_TNAM CHAR(30),
PBC_TID INTEGER,
PBC_OWNR CHAR(30),
PBC_CNAM CHAR(30),
PBC_CID SMALLINT,
PBC_LABL CHAR(254),
PBC_LPOS SMALLINT,
PBC_HDR CHAR(254),
PBC_HPOS SMALLINT,
PBC_JTFY SMALLINT,
PBC_MASK CHAR(31),
PBC_CASE SMALLINT,
PBC_HGHT SMALLINT,
PBC_WDTH SMALLINT,
PBC_PTRN CHAR(31),
PBC_BMAP CHAR(1),
PBC_INIT CHAR(254),
PBC_CMNT CHAR(254),
PBC_EDIT CHAR(31),
PBC_TAG CHAR(254))
IN database.tablespace

CREATE UNIQUE INDEX PBCATCOL_IDX
ON PBOwner.PBCATCOL
(PBC_TNAM,
PBC_OWNR,
PBC_CNAM)


GRANT SELECT, UPDATE, INSERT, DELETE ON
PBOwner.PBCATCOL TO PUBLIC


CREATE TABLE PBOwner.PBCATFMT
( PBF_NAME CHAR(30) NOT NULL,
PBF_FRMT CHAR(254) NOT NULL,
PBF_TYPE SMALLINT NOT NULL,
PBF_CNTR INTEGER)
IN database.tablespace

CREATE UNIQUE INDEX PBCATFMT_IDX
ON PBOwner.PBCATFMT
(PBF_NAME)

GRANT SELECT, UPDATE, INSERT, DELETE ON
PBOwner.PBCATFMT TO PUBLIC


CREATE TABLE PBOwner.PBCATVLD
( PBV_NAME CHAR(30) NOT NULL,
PBV_VALD CHAR(254) NOT NULL,
PBV_TYPE SMALLINT,
PBV_CNTR INTEGER,
PBV_MSG CHAR(254))
IN database.tablespace

CREATE UNIQUE INDEX PBCATVLD_IDX
ON PBOwner.PBCATVLD
(PBV_NAME)

GRANT SELECT, UPDATE, INSERT, DELETE ON
PBOwner.PBCATVLD TO PUBLIC

CREATE TABLE PBOwner.PBCATEDT
(PBE_NAME CHAR(30) NOT NULL,
PBE_EDIT VARCHAR(254),
PBE_TYPE SMALLINT,
PBE_CNTR INTEGER,
PBE_SEQN SMALLINT,
PBE_FLAG INTEGER,
PBE_WORK CHAR(32))
IN database.tablespace

CREATE UNIQUE INDEX PBCATEDT_IDX
ON PBOwner.PBCATEDT
(PBE_NAME,
PBE_SEQN)

GRANT SELECT, UPDATE, INSERT, DELETE ON
PBOwner.PBCATEDT TO PUBLIC


//
// The following fills the Powerbuilder Format table with
// the default values.
//


INSERT INTO PBOwner.PBCATFMT VALUES (
'[General]',
'[General]',
81,
0)
INSERT INTO PBOwner.PBCATFMT VALUES (
'0',
'0',
81,
0)
INSERT INTO PBOwner.PBCATFMT VALUES (
'0.00',
'0.00',
81,
0)
INSERT INTO PBOwner.PBCATFMT VALUES (
'#,##0',
'#,##0',
81,
0)
INSERT INTO PBOwner.PBCATFMT VALUES (
'#,##0.00',
'#,##0.00',
81,
0)
INSERT INTO PBOwner.PBCATFMT VALUES (
'$#,##0;($#,##0)',
'$#,##0;($#,##0)',
81,
0)
INSERT INTO PBOwner.PBCATFMT VALUES (
'$#,##0;[RED]($#,##0)',
'$#,##0;[RED]($#,##0)',
81,
0)
INSERT INTO PBOwner.PBCATFMT VALUES (
'$#,##0.00;($#,##0.00)',
'$#,##0.00;($#,##0.00)',
81,
0)
INSERT INTO PBOwner.PBCATFMT VALUES (
'$#,##0.00;[RED]($#,##0.00)',
'$#,##0.00;[RED]($#,##0.00)',
81,
0)
INSERT INTO PBOwner.PBCATFMT VALUES (
'0%',
'0%',
81,
0)
INSERT INTO PBOwner.PBCATFMT VALUES (
'0.00%',
'0.00%',
81,
0)
INSERT INTO PBOwner.PBCATFMT VALUES (
'0.00E+00',
'0.00E+00',
81,
0)
INSERT INTO PBOwner.PBCATFMT VALUES (
'm/d/yy',
'm/d/yy',
84,
0)
INSERT INTO PBOwner.PBCATFMT VALUES (
'd-mmm-yy',
'd-mmm-yy',
84,
0)
INSERT INTO PBOwner.PBCATFMT VALUES (
'd-mmm',
'd-mmm',
84,
0)
INSERT INTO PBOwner.PBCATFMT VALUES (
'mmm-yy',
'mmm-yy',
84,
0)
INSERT INTO PBOwner.PBCATFMT VALUES (
'h:mm AM/PM',
'h:mm AM/PM',
84,
0)
INSERT INTO PBOwner.PBCATFMT VALUES (
'h:mm:ss AM/PM',
'h:mm:ss AM/PM',
84,
0)
INSERT INTO PBOwner.PBCATFMT VALUES (
'h:mm:ss',
'h:mm:ss',
84,
0)
INSERT INTO PBOwner.PBCATFMT VALUES (
'm/d/yy h:mm',
'm/d/yy h:mm',
84,
0)

//
// The following fills the Powerbuilder Edit Style table with
// the default values.
//

INSERT INTO PBOwner.PBCATEDT VALUES (
'###,###.00',
'###,###.00',
90,
1,
1,
32,
'10')
INSERT INTO PBOwner.PBCATEDT VALUES (
'#####',
'#####',
90,
1,
1,
32,
'10')
INSERT INTO PBOwner.PBCATEDT VALUES (
'###-##-####',
'###-##-####',
90,
1,
1,
32,
'00')
INSERT INTO PBOwner.PBCATEDT VALUES (
'MM/DD/YY',
'MM/DD/YY',
90,
1,
1,
32,
'20')
INSERT INTO PBOwner.PBCATEDT VALUES (
'DD/MM/YY',
'DD/MM/YY',
90,
1,
1,
32,
'20')
INSERT INTO PBOwner.PBCATEDT VALUES (
'MM/DD/YYYY',
'MM/DD/YYYY',
90,
1,
1,
32,
'20')
INSERT INTO PBOwner.PBCATEDT VALUES (
'DD/MM/YYYY',
'DD/MM/YYYY',
90,
1,
1,
32,
'20')
INSERT INTO PBOwner.PBCATEDT VALUES (
'DD/MMM/YY',
'DD/MMM/YY',
90,
1,
1,
32,
'20')
INSERT INTO PBOwner.PBCATEDT VALUES (
'DDD/YY',
'DDD/YY',
90,
1,
1,
32,
'20')
INSERT INTO PBOwner.PBCATEDT VALUES (
'DDD/YYYY',
'DDD/YYYY',
90,
1,
1,
32,
'20')
INSERT INTO PBOwner.PBCATEDT VALUES (
'HH:MM:SS',
'HH:MM:SS',
90,
1,
1,
32,
'30')
INSERT INTO PBOwner.PBCATEDT VALUES (
'HH:MM:SS:FFF',
'HH:MM:SS:FFF',
90,
1,
1,
32,
'30')
INSERT INTO PBOwner.PBCATEDT VALUES (
'HH:MM:SS:FFFFFF',
'HH:MM:SS:FFFFFF',
90,
1,
1,
32,
'30')
INSERT INTO PBOwner.PBCATEDT VALUES (
'MM/DD/YY HH:MM:SS',
'MM/DD/YY HH:MM:SS',
90,
1,
1,
32,
'40')
INSERT INTO PBOwner.PBCATEDT VALUES (
'DD/MM/YY HH:MM:SS',
'DD/MM/YY HH:MM:SS',
90,
1,
1,
32,
'40')
INSERT INTO PBOwner.PBCATEDT VALUES (
'MM/DD/YYYY HH:MM:SS',
'MM/DD/YYYY HH:MM:SS',
90,
1,
1,
32,
'40')
INSERT INTO PBOwner.PBCATEDT VALUES (
'DD/MM/YYYY HH:MM:SS',
'DD/MM/YYYY HH:MM:SS',
90,
1,
1,
32,
'40')
INSERT INTO PBOwner.PBCATEDT VALUES (
'DD/MMM/YY HH:MM:SS',
'DD/MMM/YY HH:MM:SS',
90,
1,
1,
32,
'40')
INSERT INTO PBOwner.PBCATEDT VALUES (
'DDD/YY HH:MM:SS',
'DDD/YY HH:MM:SS',
90,
1,
1,
32,
'40')
INSERT INTO PBOwner.PBCATEDT VALUES (
'DDD/YYYY HH:MM:SS',
'DDD/YYYY HH:MM:SS',
90,
1,
1,
32,
'40')
INSERT INTO PBOwner.PBCATEDT VALUES (
'DD/MM/YY HH:MM:SS:FFFFFF',
'DD/MM/YY HH:MM:SS:FFFFFF',
90,
1,
1,
32,
'40')

hofo...@singnet.com.sg (Hendrick) wrote in message news:<128f5a05.03102...@posting.google.com>...

0 new messages