Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
JFA_OH_Idnr int NUMBER(38,0) int int false ID of the file transfer object.
JFA_StartType varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Start type of the file transfer.
JFA_IntAccount varchar (16) VARCHAR2 (16 CHAR) varchar(16) varchar (16) true Name of the internal account.
JFA_AttDialog smallint NUMBER(38,0) smallint smallint true Indicates, whether or not that the attribute dialog is opened when the object is started.
JFA_Message varchar (50) VARCHAR2 (50 CHAR) varchar(50) varchar (50) true currently unused.
JFA_HostDst varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the destination agent.
JFA_LoginDst varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the login object used on the destination host.
JFA_CodeNameDst varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the code table used on the destination host.
JFA_FileNameDst varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true File path on the destination host.
JFA_HostSrc varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the source agent.
JFA_LoginSrc varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the login object used on the source host.
JFA_CodeNameSrc varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the code table used on the source host.
JFA_FileNameSrc varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true File path on the source host.
JFA_TextType char (1) CHAR (1 CHAR) char(1) char (1) true Type of the data that is transferred. B = binary, T = text
JFA_Ov char (1) CHAR (1 CHAR) char(1) char (1) true Indicates, that existing files are overwritten on the destination host.
JFA_Erase smallint NUMBER(38,0) smallint smallint true Indicates, that transferred files are deleted on the source host.
JFA_ActAtRun smallint NUMBER(38,0) smallint smallint true Indicates that the object is generated at runtime or at activation time.
JFA_MaxParallel smallint NUMBER(38,0) smallint smallint true Maximum number of parallel running file transfers when using wildcard characters.
JFA_RepeatType char (1) CHAR (1 CHAR) char(1) char (1) true File transfer using wildcard characters: include subdirectories. R = yes, S = no
JFA_WildCard smallint NUMBER(38,0) smallint smallint true Indicates, that this file transfer uses wild cards. 0 = no, 1 = yes
JFA_Rest varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true Additional attributes
JFA_AutoDeact char (1) CHAR (1 CHAR) char(1) char (1) true Currently unused.
JFA_DeactDelay int NUMBER(38,0) int int true Currently unused.
JFA_DeactWhen varchar (30) VARCHAR2 (30 CHAR) varchar(30) varchar (30) true Currently unused.
JFA_Compress char (1) CHAR (1 CHAR) char(1) char (1) true Compress level. 0 = no compression, 1 = normal compression, 2 = strong compression
JFA_Resource int NUMBER(38,0) int int true Resources needed by this file transfer. 0 = value from UC_SYSTEM_SETTINGS
JFA_KeepAtt smallint NUMBER(38,0) smallint smallint true Keep file attributes on source host (only on the same operating system possible). 0 = no, 1 = yes
JFA_CancelOn1stErr smallint NUMBER(38,0) smallint smallint true Defines, if a file transfer shall be cancelled, when an error occurs during a wildcard file transfer. 0 = no, 1 = yes
JFA_SubDirStruct smallint NUMBER(38,0) smallint smallint true Indicates, that the complete sub-folder structure (incl. files) shall be transferred or not. 0 = no, 1 = yes

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_JFA JFA_OH_Idnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_JFA_OH JFA_OH_Idnr OH_Idnr

Return to the Index File