Name Type MSSql Type Oracle Type DB2 Nullable Description
JFA_OH_Idnr int NUMBER(38,0) int false reference to the object header (OH)
JFA_StartType varchar (200) VARCHAR2 (200 CHAR) varchar(200) true start type
JFA_IntAccount varchar (16) VARCHAR2 (16 CHAR) varchar(16) true account
JFA_AttDialog smallint NUMBER(38,0) smallint true attibute dialog?
JFA_Message varchar (50) VARCHAR2 (50 CHAR) varchar(50) true ? message receiver
JFA_HostDst varchar (200) VARCHAR2 (200 CHAR) varchar(200) true host name
JFA_LoginDst varchar (200) VARCHAR2 (200 CHAR) varchar(200) true name of login object destination file
JFA_CodeNameDst varchar (200) VARCHAR2 (200 CHAR) varchar(200) true name of the code table
JFA_FileNameDst varchar (512) VARCHAR2 (512 CHAR) varchar(512) true file name
JFA_HostSrc varchar (200) VARCHAR2 (200 CHAR) varchar(200) true host name (sender)
JFA_LoginSrc varchar (200) VARCHAR2 (200 CHAR) varchar(200) true name of login object source file
JFA_CodeNameSrc varchar (200) VARCHAR2 (200 CHAR) varchar(200) true code table (sender)
JFA_FileNameSrc varchar (512) VARCHAR2 (512 CHAR) varchar(512) true file name (sender)
JFA_TextType char (1) CHAR (1 CHAR) char(1) true text, binary ...
JFA_Ov char (1) CHAR (1 CHAR) char(1) true overwrite
JFA_Erase smallint NUMBER(38,0) smallint true delete file after transfer
JFA_ActAtRun smallint NUMBER(38,0) smallint true activation at runtime?
JFA_MaxParallel smallint NUMBER(38,0) smallint true maximum number of parallel running file transfers when using wildcard characters
JFA_RepeatType char (1) CHAR (1 CHAR) char(1) true file transfer using wildcard characters: include subdirectories R=yes S=no
JFA_WildCard smallint NUMBER(38,0) smallint true is this a file transfer using wildcard characters 0=no, 1=yes
JFA_Rest varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) true . additional attributes
JFA_AutoDeact char (1) CHAR (1 CHAR) char(1) true deactivate autom. when finished: J/N/A/F J=during first error-free program run, A=always, N=no, F=when errorfree
JFA_DeactDelay int NUMBER(38,0) int true delay in minutes
JFA_DeactWhen varchar (30) VARCHAR2 (30 CHAR) varchar(30) true ok state for autom. deactivation
JFA_Compress char (1) CHAR (1 CHAR) char(1) true Compress level
JFA_Resource int NUMBER(38,0) int true Count of resources needed by this ft (0=value from UC_SYSTEM_SETTINGS)
JFA_KeepAtt smallint NUMBER(38,0) smallint true Keep file attributes (only on the same OS possible) (0=no, 1=yes)
JFA_CancelOn1stErr smallint NUMBER(38,0) smallint true Shall a FT be cancelled when an error occurs during a wildcard FT or not. (0 = no, 1 = yes)
JFA_SubDirStruct smallint NUMBER(38,0) smallint true Transfer complete subfolder structure

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