Gloss World Cup of Java UNIX Tools Food I Like Know me more Gallery Search Engine
In course of working with Unix , everyone formulates their own wrapper scripts to ease their work. I've also made a few scripts which might be of use to you. Mind you, you will have to make changes to the scripts as and where necessary. I work in Korn shell , so all my scripts do use ksh . If you like them , then copy paste in a Unix file,change mode to 'x' , make necessary adjustments , and run them.
sip
Gets the Sybase server Ip address from the interfaces file. Very useful while getting the IP details from Unix
and populating the sql.ini file.Usage: sip [SERVER]
sybgrep
This utility has multi usage . It greps for the tablename or column name or stored proc name or trigger name in the database.Usage: sybgrep -o[objName] | -c[colName] | -t[type{U/P/TR/V/S}]
vj
This is for Gloss users.You no more have to trouble yourself in running rt from Exceed.Just change the
ip address of your machine in the script and run it.Usage: vj
locks
Table locks in a database.Usage: locks
autoscript.pl
Perl script for Gloss Users.You don't have to bother anymore to write boring dat scripts.Select from database the data you want to create a script for (tab delimited) , paste that into a file and then run this script against it.Usage: autoscript (dbname) (tablename) (infile)
tree
Tree view of directory structure.Usage: tree
defncp.pl
Sybase Defn-copy of SQL object.Usage: defncp
That's it for now, I might have some more in course of my experience . The rest of the scripts that I have are really crap ones not to be published on web. If you have any queries on Unix , then ask the Master O'Reilly & Associates, Inc.