Plug-in Documentation

Sybase

The Sybase plugin provides steps to integrate with a Sybase Adaptive Server Enterprise relational database server.

This plug-in includes one step:

This plug-in requires IBM UrbanCode Deploy version 6.0 or later.

This plug-in runs on all operating systems that UrbanCode Deploy supports.

No special steps are required for installation. See Installing plug-ins in UrbanCode products.

Added failure property to determine what action to take on SQL errors.

Initial release of the Sybase Plugin.

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. The default Fail On Error will fail the process immediately, Warn On Error will only warn that an error occured, and Fail After Errors will execute all SQL scripts and fail afterwards if any errors occurred.	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 will be treated as a control file.	Yes
Server Name	String	The name of the Adaptive Server in which to connect. If nothing is specified, the default SYBASE server name will be used.	No
Username	String	The case-sensitive username to authenticate with Sybase.	Yes