table1 jdbc table "SQL"."MyTable"
• Specify a source names “query1” to access an SQL join query:
query1 jdbc sql
"select * from sch.dept
where number_of_employees > 10"
sourcename jms jmsname [options source-options]
This specifies a Java Messaging Service (JMS) source. jmsname is a JMS name.
source-options
one or more occurrences of source-options, separated by a comma (,). The last
source-options should not use the comma separator.
These options can be specified at the source level or provided for all sources as global options:
Options for file sources:
• “encoding” (page 51)
• “forcestaging” (page 54)
• “multipart” (page 55)
• “sorted” (page 58)
Options for pipe sources:
• “encoding” (page 51)
• “endseq” (page 53)
• “forcestaging” (page 54)
• “multipart” (page 55)
• “retries” (page 58)
• “sorted” (page 58)
• “startseq” (page 58)
• “tenacity” (page 59)
• “timeout” (page 59)
Options for jdbc sources:
• “datasource” (page 50)
• “noaudit” (page 56)
• “parallelstreams” (page 57)
• “password” (page 57)
• “retries” (page 58)
• “system” (page 59)
• “teamsize” (page 59)
• “tenacity” (page 59)
• “url” (page 60)
• “user” (page 60)
Options for jms sources:
• “password” (page 57)
• “retries” (page 58)
• “tenacity” (page 59)
• “timeout” (page 59)
• “url” (page 60)
• “user” (page 60)
Control File Organization and Syntax 45
Comentarios a estos manuales