Scout Database Model (CR)
Table: Emulation
Each entry describes an application of the type APPLTYPE_EMULATION.1 Currently, only the emulation type 5250 is supported.
| ColumnName | DataType | Key | Not Null | DefaultValue | Comment |
|---|---|---|---|---|---|
| ApplicationID | INTEGER | PK, FK | NN | Unique application ID (/en-us/unicon-elux-scout/white_papers/dbmodel/application/table_application.html) | |
| Type | NVARCHAR(255) | Emulation type | |||
| BrowserType | INTEGER | 5250 - 5250 terminal emulation | |||
| Configuration | NVARCHAR(255) |
**<configuration file>** - Emulation types 9750, 3270, 5250 |
|||
| 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) |
**<password>** - Emulation type VNC |
|||
| 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))
Table: Emulation
In this article
Copied!
Failed!