From mrustom@lehman.com Mon Dec 24 12:08:33 2007
#Hello, Mark. Here is the sql example we did in class. I'm not sure what vendor
#you will be using (Sybase,Oracle,DB2,etc). This example works for Sybase. You
#won't have a problem with the sql queries, but the stored procedures (starting
#with "sp") could be different on a different machine. Hope this helps.
#
#Mohammad Rustom

#!/bin/ksh
#Log onto a nsql server.

S=RESTORDEV
P=`/home/dba/bin/getsap ${S}`

ISQL="$SYBASE/bin/isql -Usa -S${S} \
-w000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000500 \
-P${P}"

${ISQL} << END
sp__helpdb
go
create database SCPS
go
use SCPS
go
create table names(name char(20))
go
sp_help
go
insert into names values("Mark Meretzky")
go
select * from names
go
END

exit 0