Sorry 

 

The age maybe !!! I just needed to increase my Command window 

 

Regards Robert

 

 

Hi to all 

 

I wanted the output of this script in wide orientation (like table) but always 
no matter what I tried I got as a list !!!!

 

SET SQLDISPLAYMODE wide

select Distinct CHAR(p.source_name,20)as "Source Name" ,CHAR(r.drive_name,12)as 
"Drive",CHAR(p.device,20) as "Device",CHAR(r.online,12) as "Drive Online" 
,CHAR(p.online,12) as "Path Online",CHAR(r.allocated_to,15) as "Allocate TO" 
from drives r,paths p where r.library_name=p.library_name and  
r.drive_name=p.destination_name 

 

Always get:

 

Source Name: ADSM

      Drive: FILE2DRV4

     Device: file

rive Online: YES

Path Online: YES

Allocate TO:

 

Source Name: ADSM

      Drive: FILE2DRV5

     Device: file

rive Online: YES

Path Online: YES

Allocate TO:

 

Source Name: ADSM

      Drive: I2000DRV1

     Device: /dev/rmt0

rive Online: YES

Path Online: YES

Allocate TO: ADSM

 

Source Name: ADSM

      Drive: I2000DRV2

     Device: /dev/rmt1

rive Online: YES

Path Online: YES

Allocate TO: ADSM

 

I obvious miss something ???

 

Regards

Robert Ouzen