- Submit your file electronically using the departmental submit utility: submit c670aa lab3 lab3I.sql (lab3II.sql).
- Your file should be well formatted and commented.
- isql can be invoked in batch mode with commands of the form
isql -X -i file.sql
or of the form
isql -P password < file.sql
- Complex files may be compilable only in batch mode, and not be receptive to import through the ‘:r’ command in
interactive mode.
- The go directives are required also in files processed in batch mode. For instance,
/* comment */
create ...
go
select ...
from ...
where ...
go
insert to ...
go
delete from ...
go
...
- If you don’t have a, or don’t remember your cis account, please go with an id to the SOC lab (8th floor of DL) and
get an account.
If you don’t have a, or don’t remember your, sybase account, please contact help@cis.ohio-state.edu Put the word
PRIVATE in the subject header when sending a request that contains sensitive information, such as social security
numbers. (If you fail to do this, any information included in the request will be viewable to anyone, anywhere on the
web.)