LassoScript Utility
Basics Browse Detail

-Schema

Tag Link -Schema Category Database
Type Command Source Available No
Support Preferred Version 6.0.2
Change Unchanged Data Source JDBC
Output Type None Security None
Implementation LCAPI Sets Lasso 8.5, Lasso 8.0, Lasso 7.0, Lasso 6.0

Description

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

[Inline: -Schema='Schema_Name', ...]

Parameters

Required Parameters
Schema Name The name of the schema which should be used for a database action.

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]

<br>John Doe
<br>John Surname