Some menus do not display the underlying parameter value. Some of these values require you to set the Evaluate option to assign them via a parameter set.
Use this table to identify which value (Value) corresponds to the shown one (Prompt) and whether you must enable Evaluate.
Component |
Property |
Prompt |
Value |
Evaluate |
|---|---|---|---|---|
| Database connections | Interface | ODBC | dbodbc | |
Sybase |
dbsybase |
|||
Oracle |
dboracle |
|||
IBM DB/2 |
dbdb2 |
|||
OLE DB |
dbole |
|||
SQLite Persistent |
dbpersistent |
|||
INSERT LOCATION |
dbinsertlocation |
|||
Text formats |
Row Delimiter |
Position |
||
LF |
[uChr(10)] |
x |
||
CR |
[uChr(13)] |
x |
||
CRLF |
[uConcat(uChr(13),uChr(10))] |
x |
||
Column Delimiter |
Position |
|||
Tab |
[uChr(9)] |
x |
||
Comma |
, |
|||
Semicolon |
; |
|||
| Pipe | | | |||
Column Quote |
None |
|||
Single Quote |
' |
|||
Double Quote |
" |
|||
| EL Source | Source Type (Source Type + File Format) | Database | 1 | |
Files: Delimited |
2 | |||
Files: Fixed Length |
3 | |||
Files: IQ Binary |
4 | |||
Files: Large Object |
6 | |||
| Source Byte Order | Destination | 1 | ||
| Low (Little Endian) | 2 | |||
| High (Big Endian) | 3 | |||
| EL Advanced | Stage File Format | Delimited Text | delimited | |
| IQ Binary Data | binary | |||
| Transaction Type | Single Transaction | 1 | ||
| Auto Commit | 2 | |||
| Periodic Commit | 3 | |||
| Restartable | 4 |