VI_ExportJobDefinitionWrk VI Export Job Definition Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: Y SysDB: N "MAS_SYSTEM\VI_ExportJobDefinitionWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . .
2 JobName . . . . . . . . . . . 15 SYY Job Name. . . . . . . . . . . .
3 ReportPrintSequence . . . . . 1 SNY Report Print Sequence . . . . .
4 SequenceNo. . . . . . . . . . 4 SNN Sequence Number . . . . . . . .
5 JobType . . . . . . . . . . . 1 SYY Job Type. . . . . . . . . . . .
Valid:X,I Notes: X=eXport,
I=Import
6 CompiledName. . . . . . . . . 30 SNY Compiled Name . . . . . . . . .
7 TableName . . . . . . . . . . 30 SNY Table Name. . . . . . . . . . .
Notes: Validated against
Providex.ddf
8 MenuName. . . . . . . . . . . 40 SNN Launcher Menu Name. . . . . . .
9 JobLongDescription. . . . . . 240 SNN Job Long Description. . . . . .
10 FieldDelimiter. . . . . . . . 1 SNN Field Delimiter . . . . . . . .
Notes: If delimited import
file
11 DelimiterAsciiValue . . . . . 3 SNN Delimiter Ascii Value . . . . .
12 ImportFileName. . . . . . . . 120 SNN Import/Export File Name . . . .
Notes: Include full or
relative path
13 ImportFileType. . . . . . . . 1 SNY Import/Export File Type . . . .
DfltVal:D Valid:3,4,A,D,O,F,
L,X Notes: 3=dbase 3+,
4=lotus wk4, A=Ascii,
D=Delimited, O=ODBC, F=dif,
L=Lotus WK3, X=eXcel 5.0
14 ImportFileOnHost. . . . . . . 1 SYY Import File On Host . . . . . .YESNO
DfltVal:N Valid:Y,N
15 NextJobChain. . . . . . . . . 15 SNN Next Job Chain. . . . . . . . .
16 WaitHours . . . . . . . . . . 2.0 NNN Wait Hours. . . . . . . . . . .
17 WaitMinutes . . . . . . . . . 2.0 NNN Wait Minutes. . . . . . . . . .
18 ExecutionLoops. . . . . . . . 2.0 NNN Execution Loops . . . . . . . .
19 ODBCDataSourceName. . . . . . 60 SNN ODBC Data Source Name . . . . .
20 DataSourceOnHost. . . . . . . 1 SYN Data Source On Host . . . . . .YESNO
DfltVal:N Valid:Y,N
21 InsertAllFields . . . . . . . 1 SYY Insert All Fields at Setup. . .YESNO
DfltVal:N Valid:Y,N
22 SkipOverExistingRecords . . . 1 SYN Skip Over Existing Records. . .YESNO
DfltVal:N Valid:Y,N
23 SeparateHeaderRecord. . . . . 1 SYN Separate Header Record. . . . .YESNO
DfltVal:N Valid:Y,N
24 ConvertDelimToSpace . . . . . 1 SYN Convert Delimiter to Space. . .YESNO
DfltVal:N Valid:Y,N
25 PadFieldsWithSpaces . . . . . 1 SYN Pad Fields With Spaces. . . . .YESNO
DfltVal:N Valid:Y,N
26 LinkTableName . . . . . . . . 30 SNN Link Table Name . . . . . . . .
27 ColumnName. . . . . . . . . . 30 SNN Column Name . . . . . . . . . .
28 FileType. . . . . . . . . . . 1 SYN File Type . . . . . . . . . . .
29 DataType. . . . . . . . . . . 1 SYN Data Type . . . . . . . . . . .
30 FieldType . . . . . . . . . . 1 SYN Field Type. . . . . . . . . . .
31 OperationCode . . . . . . . . 1 SYN Operation Code. . . . . . . . .
32 NSDMask . . . . . . . . . . . 50 SNN Mask Format . . . . . . . . . .
33 SourceOrigLength. . . . . . . 5.0 NNN Source Original Length. . . . .
34 SourceSubstring . . . . . . . 1 SYN Source Substring. . . . . . . .YESNO
DfltVal:N Valid:Y,N
35 SourceStartPos. . . . . . . . 5.0 NNN Source Start Position . . . . .
DfltVal:1 Notes: Relative to
the string field start
position. Default=1
36 SourceLength. . . . . . . . . 5.0 NNN Source Length . . . . . . . . .
Notes: Not to exceed
dictionary length. Default =
dictionary length
37 ExportColPos. . . . . . . . . 5.0 NNN Export Column Number or Start P
Notes: Start Position for
ASCII, Column Number for
everything else.
38 ExportFieldLength . . . . . . 5.0 NNN Export Field Length . . . . . .
Notes: Not limited. Default
= dictionary length
39 ExportSubstring . . . . . . . 1 SYN Export Substring. . . . . . . .YESNO
DfltVal:N Valid:Y,N
40 ExportLength. . . . . . . . . 5.0 NNN Export Length . . . . . . . . .
Notes: Limited to Export
Field Length
41 PadWithSpaces . . . . . . . . 1 SYN Pad With Spaces . . . . . . . .YESNO
DfltVal:N Valid:Y,N
42 DefaultValue. . . . . . . . . 60 SNN Default Value . . . . . . . . .
43 CalcExpression. . . . . . . . 512 SNN Calc Expression . . . . . . . .
44 ConditionalExpression . . . . 512 SNN Conditional Expression. . . . .
45 CalculationOnly . . . . . . . 1 SYN Calculation Only. . . . . . . .YESNO
DfltVal:N Valid:Y,N
46 ResetTempVar. . . . . . . . . 1 SYN Reset Temp Variable . . . . . .YESNO
DfltVal:N Valid:Y,N
47 PartOfODBCIndex . . . . . . . 1 SYN Part of ODBC Index. . . . . . .YESNO
DfltVal:N Valid:Y,N
48 Condition . . . . . . . . . . 1 SNN Condition . . . . . . . . . . .
49 Relation. . . . . . . . . . . 1 SNN Relation. . . . . . . . . . . .
50 CaseSensitive . . . . . . . . 1 SYN Case Sensitive. . . . . . . . .YESNO
DfltVal:N Valid:Y,N
51 CharacterMatch. . . . . . . . 1 SYN Character Match . . . . . . . .YESNO
DfltVal:N Valid:Y,N
52 SelectBegin . . . . . . . . . 60 SNN Select Begin. . . . . . . . . .
53 SelectEnd . . . . . . . . . . 60 SNN Select End. . . . . . . . . . .
54 OriginalStartPos. . . . . . . 5.0 NNN Original Start Position . . . .
55 OriginalLength. . . . . . . . 5.0 NNN Original Length . . . . . . . .
56 Substring . . . . . . . . . . 1 SYN Substring . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
57 UserInput . . . . . . . . . . 1 SYN User Input. . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
58 RunTimePrompt . . . . . . . . 30 SNN Run Time Prompt . . . . . . . .
59 PerformType . . . . . . . . . 2 SNN Perform Type. . . . . . . . . .
60 PerformPath . . . . . . . . . 120 SNN Perform Path. . . . . . . . . .
61 RangeStart. . . . . . . . . . 40 SNN Range Start . . . . . . . . . .
62 RangeEnd. . . . . . . . . . . 40 SNN Range End . . . . . . . . . . .
63 SelectionValue. . . . . . . . 40 SNN Selection Value . . . . . . . .
64 SelectionMask . . . . . . . . 40 SNN Selection Mask. . . . . . . . .
65 SelectionList . . . . . . . . 512 SNN Selection List. . . . . . . . .
66 SelectionSeq. . . . . . . . . 300 SNN Selection Sequence. . . . . . .
67 SortOrder . . . . . . . . . . 1 SYN Sort Order. . . . . . . . . . .
DfltVal:A Valid:A,D
68 StartPosition . . . . . . . . 5.0 NNN Start Position. . . . . . . . .
69 Length. . . . . . . . . . . . 5.0 NNN Length. . . . . . . . . . . . .
70 SqlStatement. . . . . . . . . 2048 SNN SQL Statement . . . . . . . . .
71 Class . . . . . . . . . . . . 30 SNN Class . . . . . . . . . . . . .
72 Mask. . . . . . . . . . . . . 30 SNN Mask. . . . . . . . . . . . . .