Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- %isql -U abc -P abc -S support
- 1> sp_configure 'number of open partitions'
- 2> go
- Parameter Name Default Memory Used Config Value Run Value Unit Type
- ------------------------------ ----------- ----------- ------------ ------------ -------------------- ----------
- number of open partitions 500 5201 5000 5000 number dynamic
- (1 row affected)
- (return status = 0)
- 1>
- def sql = Sql.newInstance("jdbc:abc:sybase://harley:6011;DatabaseName=support;",dbuname,dbpassword,Driver)
- sql.eachRow("sp_configure 'number of open partitions'"){ row ->
- println row.run_value
- }
- Exception in thread "main" java.sql.SQLSyntaxErrorException: [abc][Sybase JDBC Driver]Invalid column name: run_value
- sql.eachRow("sp_configure 'number of open partitions'"){ row ->
- println row
- }
- [Parameter Name:number of open partitions , Default: 500, Memory Used: 5201, Config Value: 5000, Run Value: 5000, Unit:number , Type:dynamic ]
- sql.eachRow("sp_configure 'number of open partitions'"){ row ->
- (1..row.getMetaData().columnCount).each {
- println "${row.metaData().getColumnName( it )} = ${row[ it ]}"
- }
- }
- row.'Run Value'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement