DescriptionThis plugin integrates with SAP ASE, originally known as Sybase SQL Server, which is a relational database server. The plugin uses the Interactive SQL parser (isql) utility to integrate with Sybase and execute SQL commands.
The Sybase plugin provides steps to integrate with a Sybase Adaptive Server Enterprise relational database server.
This plugin includes one or more steps, click Steps for step details and properties.
This plugin requires HCL Launch version 7.0 or later.
This plugin runs on all operating systems that HCL Launch supports.
See Installing plugins in HCL Launch for installing and removing plugins.
The following table describes the changes made in each plugin version.
|6||Added support for Sybase source profile path with spaces in Linux.|
The following process steps are available in the Sybase plugin.
Execute one or more SQL scripts on the server.
|Additional Arguments||String||Specify any additional arguments to append to the isql utility. Separate each argument by a new line.||No|
|Database||String||The name of the database in which the Isql session begins.||Yes|
||Select the action to take when a SQL file returns an error. Valid values are: Fail, Warn, and FailAfter. The default value is Fail On Error which fails the process immediately. Warn On Error only warns that an error occured. Fail After Errors executes all SQL scripts and fail afterwards if any errors occurr.||No|
|ISQL Path||String||The path to the isql command executable.||Yes|
|Password||Password||The case-sensitive password to authenticate with Sybase.||Yes|
|SQL Files||String||Specify either a list of SQL files separated by newlines, or a control file containing files listed in the same format. Note that any file without a .sql extension is treated as a control file.||Yes|
|SYBASE.sh Path||String||The path to your SYBASE profile which is the SYBASE.sh file. If specified, this file will be sourced before executing SQL scripts. This is not necessary if you source the file in your agent startup profile. For example: /opt/sybase/SYBASE.sh.||No|
|Server Name||String||The name of the Adaptive Server in which to connect. If nothing is specified, the default SYBASE server name is used.||No|
|Username||String||The case-sensitive username to authenticate with Sybase.||Yes|