Moving on to 5.0, killing off 3.1 (we hope!)

system · February 9, 2000, 9:36pm

This is the list of 3.1 repository tables:

BO_ALIAS
BO_VER
CLASSES
CONT_JOINS
CONTEXTS
JOINS
LIBRARY
OBJECTS
TABLE_OBJECT
TABLES
UNIVERSE
UNIVERSE_CONNECT
UNIVERSE_USERS
USERS

Barbara Rosen
Business Objects Administrator
Global Database Technology
Salomon Smith Barney
barbara.rosen@ssmb.com

Listserv Archives (BOB member since 2002-06-25)

system · February 9, 2000, 9:40pm

At 04:29 PM 2/9/2000 -0800, Amy Miller wrote:

However, we were hoping that someone out there who either has 3.x still, or who documented it better than we did, may have a list of the 3.x repository tables. Does anyone? Help?

Hi, Amy. According to some old notes of ours, the BusObj 3.1 repository tables/views are:

Tables:
BO_ALIAS
BO_VER
CLASSES
CONTEXTS
CONT_JOINS
JOINS
LIBRARY
OBJECTS
TABLES
TABLE_OBJECT
UNIVERSE
UNIVERSE_CONNECT
UNIVERSE_USERS
USERS

Views:
TABLES_VIEW1
TABLES_VIEW2

and, if you had Batch, I think you’d have had:
BATCH_QUERIES
BATSECNO
SQL_BATCH

Hope this helps,
Anita Craig
Stanford University

Listserv Archives (BOB member since 2002-06-25)

system · February 10, 2000, 12:29am

Hello listers!

We’re finally (we blush to admit it) going to kill off access to version 3.11, as we’re telling everyone to migrate (from 4.1.3) to 5.0. So, I was looking at the repository to tell our DBAs which were the 3.11 tables we’ll no longer need. Since BOADMIN is the owner of all repository tables, I looked there first. I checked against the list on the 4.1.x cd of repository tables, and am hoping that those not listed belong to 3.11 (since we haven’t installed 5.0 yet). However, we were hoping that someone out there who either has 3.x still, or who documented it better than we did, may have a list of the 3.x repository tables. Does anyone? Help?

Thanks!
Amy Miller

====================================
Amy A. Miller, Data Analyst
University of Pennsylvania ISC
Office of Data Administration
3401 Walnut, Suite 265C /6228
Philadelphia, PA 19104-6228
Phone: 215-898-2171 Fax:215-898-0386
Email: milleraa@isc.upenn.edu

Listserv Archives (BOB member since 2002-06-25)

system · February 10, 2000, 12:52am

In a message dated 00-02-09 16:24:55 EST, you write:

However, we were hoping that someone
out there who either has 3.x still, or who documented it better than we did, may have a list of the 3.x repository tables. Does anyone? Help?

Amy:

Below is a copy of the credico.sq7 file that shipped with BusObj 3.1.1. You will notice that the very beginning is a series of “drop table” statements. If you take out the “create table” statements your DBA should be able to determine that (a) the tables referenced in the script do exist, and (b) you can then use the drop table portion to remove your repository tables.

If you look on the “RDBMS Access for Oracle” disk that shipped with 3.1.1 (if you still have it! ) then you can find this and other administrative SQL files for BusObj 3.x.

Looking at the table structure for the old 3.1 repository sometimes makes me long for simpler days… okay, that’s over.

Regards,
Dave Rathbun
Integra Solutions
www.islink.com

DROP TABLE UNIVERSE;
DROP TABLE UNIVERSE_USERS;
DROP TABLE USERS;
DROP TABLE CLASSES;
DROP TABLE OBJECTS;
DROP TABLE TABLE_OBJECT;
DROP TABLE TABLES;
DROP TABLE CONTEXTS;
DROP TABLE CONT_JOINS;
DROP TABLE JOINS;
DROP TABLE LIBRARY;
DROP TABLE UNIVERSE_CONNECT;
DROP SYNONYM TABLES_SYN1;
DROP SYNONYM TABLES_SYN2;
DROP TABLE BO_VER;
DROP TABLE BO_ALIAS;

CREATE TABLE UNIVERSE_CONNECT
(
UNICNT_ID NUMBER,
UNICNT_SEQ NUMBER,
UNICNT_STR varchar2(240)
);

CREATE TABLE UNIVERSE (UNI_ID number(8),
UNI_NAME varchar2(30),
UNI_ORAU varchar2(20),
UNI_ORAP varchar2(20),
UNI_NET varchar2(80),
UNI_BONET varchar2(50),
UNI_MAXTIME number(8),
UNI_MAXLINE number(8),
UNI_MAJ varchar2(30),
UNI_AUDIT number(1),
UNI_VERSION varchar2(20));

CREATE TABLE UNIVERSE_USERS(USE_ID number(8),
UNI_ID number(8),
OFF_LINE varchar2(1));

CREATE TABLE USERS(USE_ID number(8),
USE_NAME varchar2(20),
USE_PASS varchar2(20),
USE_TYPE varchar2(5));

CREATE TABLE CLASSES(UNI_ID number(8),
CLA_ID number(8),
CLA_NAME varchar2(35));

CREATE TABLE OBJECTS(UNI_ID number(8),
CLA_ID number(8),
OBJ_ID number(8),
OBJ_NAME varchar2(35),
OBJ_PROP varchar2(5),
OBJ_SELECT1 varchar2(240),
OBJ_SELECT2 varchar2(240),
OBJ_COND1 varchar2(240),
OBJ_COND2 varchar2(240),
OBJ_COND3 varchar2(240),
OBJ_COND4 varchar2(240),
OBJ_COND5 varchar2(240),
OBJ_HELP1 varchar2(80),
OBJ_HELP2 varchar2(80),
OBJ_HELP3 varchar2(80),
OBJ_HELP4 varchar2(80),
OBJ_HELP5 varchar2(80),
OBJ_HELP6 varchar2(80),
OBJ_LVALUES varchar2(9));

CREATE TABLE TABLE_OBJECT(
UNI_ID number(8),
CLA_ID number(8),
OBJ_ID number(8),
TAB_ID number(8));

CREATE TABLE TABLES(
UNI_ID number(8),
TAB_ID number(8),
TAB_NAME varchar2(93),
TAB_SIZE number(8));

CREATE TABLE CONTEXTS(
UNI_ID number(8),
CON_ID number(8),
CON_NAME varchar2(30),
CON_HELP varchar2(240));

CREATE TABLE CONT_JOINS(
UNI_ID number(8),
CON_ID number(8),
JOI_ID number(8));

CREATE TABLE JOINS(
UNI_ID number(8),
JOI_ID number(8),
JOI_TAB_ID1 number(8),
JOI_TAB_ID2 number(8),
JOI_EXPR varchar2(240));

CREATE TABLE LIBRARY(
LIB_UNI_ID number(8),
LIB_NAME varchar2(30),
LIB_TYPE varchar2(8),
LIB_MAXSEQ number(4),
LIB_SEQNO number(4),
LIB_LENGTH number(5),
LIB_CONTENT long,
LIB_UNI_VERSION varchar2(20));

CREATE TABLE BO_ALIAS(
UNI_ID number(8),
TAB_ID number(8),
ALI_ID number(8));

CREATE TABLE BO_VER(
BOV_TYPE varchar2(10),
BOV_LABEL varchar2(20),
BOV_VERSION varchar2(10));

INSERT INTO BO_VER VALUES (‘DICO’,‘DICTIONARY’,‘3.1’);

CREATE SYNONYM TABLES_SYN1 FOR TABLES ;

CREATE SYNONYM TABLES_SYN2 FOR TABLES ;

COMMIT ;

Listserv Archives (BOB member since 2002-06-25)