Table: Emulation
Each entry describes an application of the type APPLTYPE_EMULATION.1
ColumnName | DataType | Key | Not Null | DefaultValue | Comment | |||
---|---|---|---|---|---|---|---|---|
ApplicationID | INTEGER | PK, FK | NN | Unique application ID (foreign key refers to table Application) | ||||
Type | NVARCHAR(255) | Emulation
type
|
||||||
Configuration | NVARCHAR(255) |
|
||||||
ConFile | NVARCHAR(255) | Connection
file. Supported by emulation types 9750, 3270, 5250 |
||||||
ColorFile | NVARCHAR(255) | Color
definition file. Supported by emulation types 9750, 3270, 5250 |
||||||
KeyboardFile | NVARCHAR(255) | Keyboard
definition file. Supported by emulation types 9750, 3270, 5250 |
||||||
PTFile | NVARCHAR(255) | P-Key
definition file. Supported by emulation types 9750, 3270, 5250 |
||||||
BTFile | NVARCHAR(255) | B-Key
definition file. Supported by emulation types 9750, 3270, 5250 |
||||||
Server | NVARCHAR(255) | Host name of server to connect to (see HostIP attribute) | ||||||
Application | NVARCHAR(255) |
|
||||||
Backingstore | NVARCHAR(255) | default|on|off | ||||||
DeadKeys | NVARCHAR(255) | default|on|off | ||||||
ReservedString1 | NVARCHAR(255) | |||||||
ReservedString2 | NVARCHAR(255) | |||||||
ReservedInt1 | INTEGER | |||||||
ReservedInt2 | INTEGER |
IndexName | IndexType | Columns |
---|---|---|
PRIMARY | PRIMARY | ApplicationID |
How to create
CREATE TABLE Emulation(
ApplicationID INTEGER NOT NULL,
Type NVARCHAR(255),
Configuration NVARCHAR(255),
ConFile NVARCHAR(255),
ColorFile NVARCHAR(255),
KeyboardFile NVARCHAR(255),
PTFile NVARCHAR(255),
BTFile NVARCHAR(255),
Server NVARCHAR(255),
Application NVARCHAR(255),
Backingstore NVARCHAR (255),
DeadKeys NVARCHAR (255),
Menubar SMALLINT,
Toolbar SMALLINT,
File1 NVARCHAR(max),
File2 NVARCHAR(max),
File3 NVARCHAR(max),
File4 NVARCHAR(max),
File5 NVARCHAR(max),
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
CONSTRAINT FK_Emulation_ApplicationID_Application_ApplicationID FOREIGN KEY (ApplicationID) REFERENCES Application (ApplicationID),
PRIMARY KEY (ApplicationID))