Try this, works for me:

select cast(process as char(30)) as "XXXXXXXXXXXXXXXXXXXXXXXXXXX" from
processes

XXXXXXXXXXXXXXXXXXXXXXXXXXX
---------------------------
Backup Storage Pool

Backup Storage Pool

Backup Storage Pool

Move Data

Backup Storage Pool

Backup Storage Pool

Backup Storage Pool

Backup Storage Pool

Backup Storage Pool

Backup Storage Pool

Move Data

Move Data

Backup Storage Pool

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-----Original Message-----
From: David Stabler [mailto:dstabler AT MORRISONHOMES DOT COM]
Sent: Wednesday, September 11, 2002 4:05 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: non-tivoli script calls, problems with narrow select....


I've been looking at old messages in adsm.org, but haven't seen a
satisfactory answer to my problem...

I'm writing a shell script to look at the processes running on the system.
When I select process from processes, the width is set at 18 characters.  If
I cast it larger, nothing seems to happen.  If I select as "XXXXXXXXXX"
where "X" is repeated 18+N (N>0) times, I get an error stating it can't be
larger than 18 characters wide....

Is there a satisfactory way (no, creating individual scripts to "run" for
each command with wide output isn't acceptable, I'm afraid) to make this
happen?  I can't make the sqldisplaymode stick, as it is session bound, but
that's the functionality I need to duplicate.

Thanks!

-drs-

David Stabler, CATE/AIX, CNCE
Senior Systems Analyst