Untitled Document

Powerbuilder tables for an Oracle database

spool load_powerbuilder.lst
/*
load_powerbuilder.sql
Version O97JUL01 - Powerbuilder Version 5.0
//
//
// This is the script to create the Powerbuilder system tables.
//
// Be sure to:
// - change all occurrences of 'pbcatown' 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
*/
drop table pbcattbl;
CREATE TABLE PBCATTBL
( PBT_TNAM CHAR(30),
PBT_TID INTEGER,
PBT_OWNR CHAR(30),
PBD_FHGT number,
PBD_FWGT number,
PBD_FITL CHAR(1),
PBD_FUNL CHAR(1),
PBD_FCHR number,
PBD_FPTC number,
PBD_FFCE CHAR(18),
PBH_FHGT number,
PBH_FWGT number,
PBH_FITL CHAR(1),
PBH_FUNL CHAR(1),
PBH_FCHR number,
PBH_FPTC number,
PBH_FFCE CHAR(18),
PBL_FHGT number,
PBL_FWGT number,
PBL_FITL CHAR(1),
PBL_FUNL CHAR(1),
PBL_FCHR number,
PBL_FPTC number,
PBL_FFCE CHAR(18),
PBT_CMNT CHAR(254));
rem IN database.tablespace

CREATE UNIQUE INDEX PBCATTBL_IDX
ON PBCATTBL
(PBT_TNAM,
PBT_OWNR);

GRANT SELECT, UPDATE, INSERT, DELETE ON
PBCATTBL TO PUBLIC;

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

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

GRANT SELECT, UPDATE, INSERT, DELETE ON
PBCATCOL TO PUBLIC;

drop table pbcatfmt;
CREATE TABLE PBCATFMT
( PBF_NAME CHAR(30) NOT NULL,
PBF_FRMT CHAR(254) NOT NULL,
PBF_TYPE number NOT NULL,
PBF_CNTR INTEGER);
rem IN database.tablespace

CREATE UNIQUE INDEX PBCATFMT_IDX
ON PBCATFMT
(PBF_NAME);

GRANT SELECT, UPDATE, INSERT, DELETE ON
PBCATFMT TO PUBLIC;

drop table pbcatvld;
CREATE TABLE PBCATVLD
( PBV_NAME CHAR(30) NOT NULL,
PBV_VALD CHAR(254) NOT NULL,
PBV_TYPE number,
PBV_CNTR INTEGER,
PBV_MSG CHAR(254));
rem IN database.tablespace

CREATE UNIQUE INDEX PBCATVLD_IDX
ON PBCATVLD
(PBV_NAME);

GRANT SELECT, UPDATE, INSERT, DELETE ON
PBCATVLD TO PUBLIC;

drop table pbcatedt;
CREATE TABLE PBCATEDT
(PBE_NAME CHAR(30) NOT NULL,
PBE_EDIT VARCHAR(254),
PBE_TYPE number,
PBE_CNTR INTEGER,
PBE_SEQN number,
PBE_FLAG INTEGER,
PBE_WORK CHAR(32));
rem IN database.tablespace

CREATE UNIQUE INDEX PBCATEDT_IDX
ON PBCATEDT
(PBE_NAME,
PBE_SEQN);

GRANT SELECT, UPDATE, INSERT, DELETE ON
PBCATEDT TO PUBLIC;

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

INSERT INTO PBCATFMT VALUES (
'[General]',
'[General]',
81,
0);
INSERT INTO PBCATFMT VALUES (
'0',
'0',
81,
0);
INSERT INTO PBCATFMT VALUES (
'0.00',
'0.00',
81,
0);
INSERT INTO PBCATFMT VALUES (
'#,##0',
'#,##0',
81,
0);
INSERT INTO PBCATFMT VALUES (
'#,##0.00',
'#,##0.00',
81,
0);
INSERT INTO PBCATFMT VALUES (
'$#,##0;($#,##0)',
'$#,##0;($#,##0)',
81,
0);
INSERT INTO PBCATFMT VALUES (
'$#,##0;[RED]($#,##0)',
'$#,##0;[RED]($#,##0)',
81,
0);
INSERT INTO PBCATFMT VALUES (
'$#,##0.00;($#,##0.00)',
'$#,##0.00;($#,##0.00)',
81,
0);
INSERT INTO PBCATFMT VALUES (
'$#,##0.00;[RED]($#,##0.00)',
'$#,##0.00;[RED]($#,##0.00)',
81,
0);
INSERT INTO PBCATFMT VALUES (
'0%',
'0%',
81,
0);
INSERT INTO PBCATFMT VALUES (
'0.00%',
'0.00%',
81,
0)
INSERT INTO PBCATFMT VALUES (
'0.00E+00',
'0.00E+00',
81,
0);
INSERT INTO PBCATFMT VALUES (
'm/d/yy',
'm/d/yy',
84,
0);
INSERT INTO PBCATFMT VALUES (
'd-mmm-yy',
'd-mmm-yy',
84,
0);
INSERT INTO PBCATFMT VALUES (
'd-mmm',
'd-mmm',
84,
0);
INSERT INTO PBCATFMT VALUES (
'mmm-yy',
'mmm-yy',
84,
0);
INSERT INTO PBCATFMT VALUES (
'h:mm AM/PM',
'h:mm AM/PM',
84,
0);
INSERT INTO PBCATFMT VALUES (
'h:mm:ss AM/PM',
'h:mm:ss AM/PM',
84,
0);
INSERT INTO PBCATFMT VALUES (
'h:mm:ss',
'h:mm:ss',
84,
0);
INSERT INTO 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 PBCATEDT VALUES (
'###,###.00',
'###,###.00',
90,
1,
1,
32,
'10');
INSERT INTO PBCATEDT VALUES (
'#####',
'#####',
90,
1,
1,
32,
'10');
INSERT INTO PBCATEDT VALUES (
'###-##-####',
'###-##-####',
90,
1,
1,
32,
'00');
INSERT INTO PBCATEDT VALUES (
'MM/DD/YY',
'MM/DD/YY',
90,
1,
1,
32,
'20');
INSERT INTO PBCATEDT VALUES (
'DD/MM/YY',
'DD/MM/YY',
90,
1,
1,
32,
'20');
INSERT INTO PBCATEDT VALUES (
'MM/DD/YYYY',
'MM/DD/YYYY',
90,
1,
1,
32,
'20');
INSERT INTO PBCATEDT VALUES (
'DD/MM/YYYY',
'DD/MM/YYYY',
90,
1,
1,
32,
'20');
INSERT INTO PBCATEDT VALUES (
'DD/MMM/YY',
'DD/MMM/YY',
90,
1,
1,
32,
'20');
INSERT INTO PBCATEDT VALUES (
'DDD/YY',
'DDD/YY',
90,
1,
1,
32,
'20');
INSERT INTO PBCATEDT VALUES (
'DDD/YYYY',
'DDD/YYYY',
90,
1,
1,
32,
'20');
INSERT INTO PBCATEDT VALUES (
'HH:MM:SS',
'HH:MM:SS',
90,
1,
1,
32,
'30');
INSERT INTO PBCATEDT VALUES (
'HH:MM:SS:FFF',
'HH:MM:SS:FFF',
90,
1,
1,
32,
'30');
INSERT INTO PBCATEDT VALUES (
'HH:MM:SS:FFFFFF',
'HH:MM:SS:FFFFFF',
90,
1,
1,
32,
'30');
INSERT INTO PBCATEDT VALUES (
'MM/DD/YY HH:MM:SS',
'MM/DD/YY HH:MM:SS',
90,
1,
1,
32,
'40');
INSERT INTO PBCATEDT VALUES (
'DD/MM/YY HH:MM:SS',
'DD/MM/YY HH:MM:SS',
90,
1,
1,
32,
'40');
INSERT INTO PBCATEDT VALUES (
'MM/DD/YYYY HH:MM:SS',
'MM/DD/YYYY HH:MM:SS',
90,
1,
1,
32,
'40');
INSERT INTO PBCATEDT VALUES (
'DD/MM/YYYY HH:MM:SS',
'DD/MM/YYYY HH:MM:SS',
90,
1,
1,
32,
'40');
INSERT INTO PBCATEDT VALUES (
'DD/MMM/YY HH:MM:SS',
'DD/MMM/YY HH:MM:SS',
90,
1,
1,
32,
'40');
INSERT INTO PBCATEDT VALUES (
'DDD/YY HH:MM:SS',
'DDD/YY HH:MM:SS',
90,
1,
1,
32,
'40');
INSERT INTO PBCATEDT VALUES (
'DDD/YYYY HH:MM:SS',
'DDD/YYYY HH:MM:SS',
90,
1,
1,
32,
'40');
INSERT INTO PBCATEDT VALUES (
'DD/MM/YY HH:MM:SS:FFFFFF',
'DD/MM/YY HH:MM:SS:FFFFFF',
90,
1,
1,
32,
'40');
spool off