Hi ,

I am a newbie on sybsase , but I have worked a lot in oracle.
I am finding it diffcult to setup pubs2 database.

I have installed Interactive SQL 11.0.1 and logging it with sa/blank login.
I dont even know if pubs2 is already there in my installation ,

From intenet I found a script for pubs2 with all tables and inserts, but its failing when I try to run it in Interactive sql.


Your help is really appriciated.

Thanks a TON.

Regards
S

I do not know what your PUBS2 database might contain, as it is not a standard Sybase database.

to see all your databases, use this query:
SELECT name FROM master.dbo.sysdatabases

to run a script file, use this statement from command prompt:
isql -Ulogin_name -Plogin_password -Sserver_name -iscript_path/script_file

PUBS database is not available in sybase.

Hello,
IU am looking for the job in Sybase field and always fail because cannot solve the problems on the interview. Could you please tell me where can i find problems to have training with solving them?

Thanks,
Oleg
digioleg@yahoo.com

FALSE.

Installing the pubs2 and pubs3 sample databases is optional, see the installation guide for your platform.

SyBooks Online

$ ls ASE-15_0/scripts/*pubs*
ASE-15_0/scripts/installpubs2 ASE-15_0/scripts/installpubs3

Wow. I really didn't know that.
From time to time, I should look in the mirror and shout: RTFM!