ADSM-L

RES: SQL Formatting on AIX scripts - SQLDISPLAYMODE

2001-12-03 08:45:44
Subject: RES: SQL Formatting on AIX scripts - SQLDISPLAYMODE
From: Alexandre Bicas <abicas AT SERVICE.COM DOT BR>
Date: Mon, 3 Dec 2001 11:41:51 -0200
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 - abicas AT service.com DOT br
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