-Schema
The -Schema command tag specifies the name of the user schema which should be used for a database action on a JDBC data source. Available only for JDBC data sources that support named schema ownership. The schema name passed here overrides the default schema set for the JDBC data source host in Lasso Administration.
The value specified for this command tag can be retrieved using the [Schema_Name] tag.
- Syntax
- Parameters
[Inline: -Schema='Schema_Name', ...]
Examples
To specify what schema to use in an inline action:
Use the -Schema command tag. The following example specifies a -Search action in [Inline] ... [/Inline] tags. The schema SchemaName is specified using a -Schema command tag within the parameters of the opening [Inline] tag.
[Inline: -Search,
-Schema='SchemaName',
-Database='Employees',
-Table='People',
'First_Name'='John']
[Records]
<br>[Field: 'First_Name'] [Field: 'Last_Name']
[/Records]
[/Inline]Result:
<br>John Doe
<br>John Surname
| Tag Link | -Schema | Category | Database |
|---|---|---|---|
| Type | Command | Data Source | |
| Support | Preferred | Version | 6.0.2 |
| Output Type | None | Security | None |
| Implementation | Internal | Sets | Lasso 6.0 |
Please note that periodically LassoSoft will go through the notes and may incorporate information from them into the documentation. Any submission here gives LassoSoft a non-exclusive license and will be made available in various formats to the Lasso community.
LassoSoft Inc. > Home
©LassoSoft Inc 2015 | Web Development by Treefrog Inc | Privacy | Legal terms and Shipping | Contact LassoSoft