ADSM-L

SQL Formatting on AIX scripts - SQLDISPLAYMODE

2001-12-03 07:47:09
Subject: SQL Formatting on AIX scripts - SQLDISPLAYMODE
From: "Pucky, Todd M." <Puckyt AT TIMKEN DOT COM>
Date: Mon, 3 Dec 2001 07:44:03 -0500
TSM Server: AIX 4.3.3

I have seen this issue addressed in the adsm archives, but never a clear
answer on how to solve it.  I plan to use a script in a cron job on AIX, but
I need to have SQLDISPLAYMODE set to WIDE.  Here is the part of my script
where I attempt to set the SQLDISPLAYMODE to WIDE and issue the query.

dsmadmc -id=xxxxxx -pas=xxxxxx "set sqldisplaymode wide"
dsmadmc -id=xxxxxx -pas=xxxxxx "select events.node_name, events.s
tatus, nodes.contact from events, nodes where events.domain_name='SERVER'
and ev
ents.schedule_name='SERVER_0300_0500' and (events.status='Missed' or
events.stat
us='Failed') and events.node_name=nodes.node_name" > $eventtmp

 I have no problems when I issue these commands from the Admin Command Line,
but through the AIX script I always get SQL format of NARROW in the results
of my query.  Any suggestions on how to get the SQLDISPLAYMODE WIDE command
to work in the AIX script would be greatly appreciated.

Thanks

Todd M. Pucky
The Timken Company
Global Information Systems



**********************************************************************
This message and any attachments are intended for the
individual or entity named above. If you are not the intended
recipient, please do not read, copy, use or disclose this
communication to others; also please notify the sender by
replying to this message, and then delete it from your system.

The Timken Company
**********************************************************************