Skip to content

Latest commit

 

History

History
26 lines (15 loc) · 621 Bytes

ms.jdbc.statement.md

File metadata and controls

26 lines (15 loc) · 621 Bytes

ms.jdbc.statement

Tags: source

Type: string

Default value: blank

Related:

Description

ms.jdbc.statement specifies the SQL statement for data retrieval. The value can be any validate statement on any JDBC source.

DIL doesn't explicitly restrict or support syntax of the statement. The source database decides whether to accept or fail the statement.

Examples

The following is a sample of MySQL SELECT statement.

  • ms.jdbc.statement=select * from ${source.entity} limit {{limit}} offset {{offset}}

back to summary