Filters

Search Results ()

Search Results ()

    All Plugins (147)

    Quick Info

    Product
    HCL Launch
    Type
    plugin
    Compatibility
    HCL Launch version 7.0 or later
    Created by
    HCL Software
    Website
    Published Date
    March 23rd, 2021
    Last Updated
    April 14th, 2022

    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
    Published Date
    March 23rd, 2021
    Last Updated
    April 14th, 2022

    launch-sybase-6.1100960.zip

    Uploaded: 17-Mar-2021 13:26

    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