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
52505250 terminal emulation 
PowerTermPowerTerm session 
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
Menubar SMALLINT(6)       Show menu bar (supported by emulation type PowerTerm only)0|1
Toolbar SMALLINT(6)       Show toolbar (supported by emulation type PowerTerm only)
0|1
File1 NVARCHAR(max)      
<connection file content> Emulation types 9750, 3270, 5250
<pts file content> Emulation type PowerTerm
File2 NVARCHAR(max)      
<configuration file content> Emulation types 9750, 3270, 5250
<ptc file content> Emulation type PowerTerm
File3 NVARCHAR(max)      
<ptk file content> Emulation type PowerTerm
File4 NVARCHAR(max)      
<ptp file content> Emulation type PowerTerm
File5 NVARCHAR(max)       Unused
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))