What is the law_dba_strings table?

The law_dba_strings table is used to create table partitions when tables are created. This table is used for adding SQL strings to SQL creation commands that are used by Lawson.

Note: You must have sufficient understanding of DDL syntax when using the LAW_DBA_STRINGS table.

The following example shows the syntax of the law_dba_strings table:

create table law_dba_strings (
object_name varchar (128) not null,
object_type varchar(128) not null,
string_type varchar(128) not null,
position int not null,
string_col varchr(2000)) not null);
 
create unique index law_dba_strset1 
on law_dba_strings (object_name, 
object_type, string_type, position);

The following table provides descriptions of the options in the law_dba_strings table:

Column Description
object_name

This column must contain the name of a user table, index, or tablespace in all uppercase letters with no qualifications.

Examples:

GLMSET1(valid)

glmset1 (invalid)

LAWPROD.GLMSET1(invalid)
object_type This column must contain the object type of the data in the object_name column. This column can have a value of either TABLE or INDEX in all uppercase letters.
string_type

This column must contain the name of the type of string to be added to the object . The following are the valid values for this column. These values must be typed in uppercase letters:

OPTIONS - Data in the string_col column is added to the end of the DDL for the object_name or object_type. This value is valid for TABLE or INDEX object types.
position Use this column if the data in the string_col is too long to fit in one record. When multiple identical records are created with different position values, the string_col values are concatenated and used.
string_col If the string_type value is OPTIONS, this column contains the DDL string to be added to the end of the create DDL for the object_name/object_type.

Example: Adding data to the law_dba_strings table 

insert into law_dba_strings
values ('GLMASTER', 'TABLE',
'OPTIONS', 1, 'compress yes')