Using SQL Statements to Load ReportCaster User IDs and Groups

How to:

When writing SQL statements to update the ReportCaster Repository with user information from an external source, you must assign valid values to the correct columns in the appropriate tables. Invalid values in the ReportCaster Repository will cause errors in ReportCaster processing. Furthermore, the structure of tables in the ReportCaster Repository may change in future releases. Therefore, SQL statements written for the current ReportCaster Repository may not be able to be migrated to new releases.

Note: A user should be a member of at least one group so that you can assign the user to a Library Access List.


Top of page

x
Syntax: How to Update the BOTUPROF Table Using a SQL Statement

Update the BOTUPROF table with an INSERT statement as follows:

INSERT
INTO BOTUPROF (CASTER_USER, ROLE, DESCRIPTION, LIBRARY_EMAIL,ACTIVE, 
CAPABILITY)
VALUES 
('admin01','A','Default 
Administrator','chuck_hill@ibi.com','Y','110000000000000000');

where:

CASTER_USER

Is the column for the ReportCaster user ID (for example, admin01). The value for this column may contain a maximum of 48 characters.

ROLE

Is the column for the user privilege. Possible values are A for ReportCaster administrator or N for Managed Reporting user who is not a ReportCaster administrator.

DESCRIPTION

Is the column for the user ID description (for example, Default Administrator). The value for this column may contain a maximum of 90 characters.

LIBRARY_EMAIL

Is the column for a valid e-mail address (for example, chuck_hill@ibi.com), which is required for the Report Library product. The value for this column may contain a maximum of 75 characters.

ACTIVE

Is the column used to denote whether a user is active (Y) or inactive (N).

CAPABILITY

Is the column that consists of a series of 18 digits, where:

Digit 1

Is 1 if the user has scheduling capability, and 0 if user does not have scheduling capability.

Digit 2

Is 1 if the user has Report Library privileges, and 0 if the user does not have Report Library privileges.

Digits 3-18

Is 0 (for internal use only).


Top of page

x
Syntax: How to Update the BOTGUSER Table Using a SQL Statement

Update the BOTGUSER table with an INSERT statement as follows:

INSERT INTO BOTGUSER (CASTER_GROUP, CASTER_USER)
VALUES ('Accounting','admin01');

where:

CASTER_GROUP

Is the column for the ReportCaster group (for example, Accounting). The value for this column may contain a maximum of 48 characters.

CASTER_USER

Is the column for the ReportCaster user ID (for example, admin01). The value for this column may contain a maximum of 48 characters.


Top of page

x
Syntax: How to Update the BOTGRP Table Using a SQL Statement

Update the BOTGRP table with an INSERT statement as follows:

INSERT INTO BOTGRP (CASTER_GROUP, GROUP_DESCRIPTION)
VALUES ('Accounting','Payables and Receivables');

where:

CASTER_GROUP

Is the column for the ReportCaster group (for example, Accounting). The value for this column may contain a maximum of 48 characters.

GROUP_DESCRIPTION

Is the column for the ReportCaster group description (for example, Payables and Receivables). The value for this column may contain a maximum of 90 characters.


WebFOCUS