Stupid User Tricks!!!! When passing the doublequote to a process, like select, make sure you send it quoted (usually with the backslash).
Thus dsmadmc .... 'select cast(process as char(30)) as "X..." ' works, but dsmadmc ... "select cast(process as char(30)) as "X...." " doesn't. The "XXX" turns into XXX when the whole thing is just doublequoted, instead of single. And, since XXX is not an SQL token, I get the strange 18column error.....stupid me. Thanks for all your help! I hope this helps someone else in the future. For the record, the command I'm running is ${CMD} \ 'select cast(process_num as decimal(8,0)) as "procid", substr(cast(START_TIME as varchar(26)),6,14) as "Start", substr(cast(current_timestamp - start_time as varchar(17)),3,8) as "Elapsed", cast(process as char(40)) as "Process_XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX" from processes ' | \ tail +13 | \ egrep -v -e "^ANS|^[ ]*$" which gives me just want I need. (As you may guess, CMD is set to the dsmadmc command with userid and password). -drs- David Stabler, CATE/AIX, CNCE Senior Systems Analyst >>> [EMAIL PROTECTED] 09/12/02 02:50AM >>> 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:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 4:05 PM To: [EMAIL PROTECTED] 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