Todd, This problem occurs because SQLDISPLAYMODE is a parameter set only for the current session. Each time you issue dsmadmc comands you are invoking a new session and SQLDISPLAYMODE is reset to NARROW. You can check this issuing Q SQLSESSION after setting SQLDISPLAYMODE.
I would create a "Server Command Script" inside TSM which would have the SQLDISPLAYMODE and the SELECT clauses into it. Once this script is created, you just have to run it from your cron as you do it today (dsmadmc -id=xxx -pa=yyy "run my_script_name") Good luck ! ________________________________________________ Alexandre Bicas Caldeira - [EMAIL PROTECTED] Tivoli Certified Specialist - Tivoli Storage Manager Service IT Solutions - http://www.service.com.br Sao Paulo: (11) 3054-1400 Rua Vicente Pinzon, 144, cj 112 CEP 04547-130 - Sco Paulo - SP Porto Alegre: (51) 212-3666 Curitiba: (41) 363-5586 -----Mensagem original----- De: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]Em nome de Pucky, Todd M. Enviada em: segunda-feira, 3 de dezembro de 2001 09:44 Para: [EMAIL PROTECTED] Assunto: SQL Formatting on AIX scripts - SQLDISPLAYMODE 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 **********************************************************************
