Neoview Transporter User Guide (R2.5)

— [FIRST/LAST N] syntax
— SQL table-valued functions
— stream access to tables
Examples
• Specify a source named “table” to access SQL table sch.dept:
table1 jdbc table sch.dept
• Specify a source named “table2” to access an SQL table with a delimited schema
and table name:
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 55)
• “forcestaging” (page 59)
• “multipart” (page 60)
• “sorted” (page 63)
Options for pipe sources:
• “encoding” (page 55)
• “endseq” (page 57)
• “forcestaging” (page 59)
• “multipart” (page 60)
• “retries” (page 63)
• “sorted” (page 63)
• “startseq” (page 64)
• “tenacity” (page 65)
• “timeout” (page 65)
Options for jdbc sources:
• “datasource” (page 54)
• “endpart” (page 57)
• “exceptiontable” (page 58)
• “noaudit” (page 61)
• “parallelstreams” (page 62)
• “password” (page 63)
• “retries” (page 63)
• “startpart” (page 64)
• “system” (page 64)
• “teamsize” (page 65)
• “tenacity” (page 65)
Control File Organization and Syntax 47