ASE Database forum - Problem Installing PUBS2 Sample DB

Author

Problem Installing PUBS2 Sample DB

Sagheer

2005-04-01, 8:04 pm

Hi,

I have installed ASE 12.5.2 on my XP and 2000 machines (the
dev. version). I am a db2 DBA. I am trying to install
PUBS2 or PUBS3 sample databases for practice but can't find
the correct sql file to run. The one I can see are for ASA
anywhere.....how do I install PUBS2 on ASE 12.5.2.....Please
HELP

Bret Halford

2005-04-01, 8:04 pm

When you installed ASE, a directory called ASE-12_5 was created. Under
that directory is a subdirectory called "scripts" which containst script

files. instpbs2 is the tsql script to create the pubs2 database.
instpix2 is the script to add the text and image values to that
database,
if they are desired.

Cheers,
-bret

Sagheer wrote:

> Hi,
>
> I have installed ASE 12.5.2 on my XP and 2000 machines (the
> dev. version). I am a db2 DBA. I am trying to install
> PUBS2 or PUBS3 sample databases for practice but can't find
> the correct sql file to run. The one I can see are for ASA
> anywhere.....how do I install PUBS2 on ASE 12.5.2.....Please
> HELP

Sponsored Links