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. . . . . . . . . . . . . .