Collection Scripts

import groovy.sql.Sql
//@Grab('org.hsqldb:hsqldb:2.7.1:jdk8')
//@GrabConfig(systemClassLoader=true)
//@Grab("com.sybase.jdbc4.jdbc.SybDriver")
Class.forName("com.sybase.jdbc4.jdbc.SybDriver")

// Get basic info to connect
def hostname = hostProps.get("system.hostname")
def user = hostProps.get("sybase.user")
def pass = hostProps.get("sybase.pass")
def port = 21000

// Construct an SQL instance with a url and a driver
def url = "jdbc:sybase:Tds:##hostname##:21000", username=user, password=pass
//def url = "jdbc:sybase:Tds:hostname:port", "user", "pass"

// sybase SQL Driver
def driver = "com.sybase.jdbc4.jdbc.SybDriver"

// Create a connection to the SQL server
sql = Sql.newInstance(url,user,pass,driver)
sql.withTransaction {

// Iterate over query results and list the databases
sql.eachRow("select spid,cmd from sysprocesses")
        { 
            it1=it.toString().split(',')[0]
            it2=it.toString().split(',')[1]
            name= it1.toString().split(":")[1].replace("]","")
            name1= it2.toString()
            // Create an instance for each spid
            println "spid"+name+"##"+"spid"+name+"######"+"cmd="+name1+"of"+ "spid"+name
        }
 
   }
sql.close()        
return 0