Description

This 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.

Quick Info

Product
HCL Launch
Type
plugin
Compatibility
HCL Launch version 7.0 or later
Created by
HCL Software
Website
Version Name Action

6.1100960

launch-sybase-6.1100960.zip

launch-sybase-6.1100960.zip

6.1100960


Summary

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.

Compatibility

This plugin requires HCL Launch version 7.0 or later.

This plugin runs on all operating systems that HCL Launch supports.

Installation

See Installing plugins in HCL Launch for installing and removing plugins.

History

The following table describes the changes made in each plugin version.

Plugin history details
Version Description
6 Added support for Sybase source profile path with spaces in Linux.

Steps

The following process steps are available in the Sybase plugin.

Run SQL Scripts

Execute one or more SQL scripts on the server.

Input properties for the Run SQL Scripts step
Name Type Description Required
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
Error Notification Enumeration:

  • fail
  • warn
  • failAfter
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