Someone suggest this to me, so I'll pass it along. Put your SQL in a command script
through the admin interface. Then just run your command script from you batch job.
That way you dont have to worry about it. You can also run the script from you web
browser.
>>> Zoltan Forray/AC/VCU <[EM
e [mailto:[EMAIL PROTECTED]]
Sent: 13 July 2001 14:50
To: [EMAIL PROTECTED]
Subject: AW: AW: SQL on OS390
I haven't found out yet how to turn off the prompt. I don't know
when this message appears and when it doesn't (one time the same query
runs without getting this message, the oth
--Ursprüngliche Nachricht-
Von: Zoltan Forray/AC/VCU [mailto:[EMAIL PROTECTED]]
Gesendet am: Freitag, 13. Juli 2001 15:19
An: [EMAIL PROTECTED]
Betreff: Re: AW: SQL on OS390
Well, this is a lot closer to what I am looking for.
It almost worked.
Now it gets stuck in a prompt loop:
ANR2963W T
a way to turn off the prompts ?
Bruno Calce <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
07/13/2001 08:39 AM
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject:AW: S
TSM allows as a command.
>
>
>
>
>
> Luuk Kleibrink <[EMAIL PROTECTED]>
> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
> 07/13/2001 02:46 AM
> Please respond to "ADSM: Dist Stor Manager"
>
>
> To: [EMAIL PROTECTED]
&
Zoltan.
<< Thanks for the many answers about using "+". However, it doesn't work. >>
<< I guess I didn't make my self clear. I am running ADSM in batch, not >>
<< "TSO in BATCH" >>
Why do you not want to run your batch sql using the ikjeft01 batch program and
calling a macro ?
That way you
=*
Hope it helps,
Matt
-Original Message-
From: Bill Colwell [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 12, 2001 4:07 PM
To: [EMAIL PROTECTED]
Subject: Re: SQL on OS390
Zoltan,
I use a plus sign, but I don't try to put long selects into the call
command,
instead I use a macro.
regards
bruno
-Ursprüngliche Nachricht-
Von: Zoltan Forray/AC/VCU [mailto:[EMAIL PROTECTED]]
Gesendet am: Freitag, 13. Juli 2001 14:19
An: [EMAIL PROTECTED]
Betreff: Re: SQL on OS390
Thanks for the many answers about using "+". However, it doesn't work.
I gues
ws as a command.
Luuk Kleibrink <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
07/13/2001 02:46 AM
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject:Re: SQL on OS390
Zolta
> speaking of SQL, does anyone know where the SQL reference is for ADSM because
>it doesn't appear to be the same standard that we have on ORacle.
TSM SQL capabilities are subset, as described in the Admin Guide and Admin
Reference manuals. See also the ADSMv3 Technical Guide redbook.
There is a
speaking of SQL, does anyone know where the SQL reference is for
ADSM because it doesn't appear to be
the same standard that we have on ORacle.
thanks
steve
**
Bunnings Legal Disclaimer:
1)
Zoltan,
This works (NOTE: don't put spaces around the comma's, this might be your
problem):
//TSO1 EXEC PGM=IKJEFT01
//SYSPRINT DD SYSOUT=X
//SYSTSPRT DD SYSOUT=X
//SYSTERM DD SYSOUT=X
//SYSOUT DD SYSOUT=X
//SYSTCPD DD DSN=SYS1.TCPPARMS(TCPDATA),DISP=SHR
//DSCOPT DD DSN=SYP.TSM.TSOADMI
Zoltan,
I use a plus sign, but I don't try to put long selects into the call command,
instead I use a macro. Here is some jcl and a macro -
//QUERYVOL EXEC PGM=IKJEFT01,DYNAMNBR=100
/SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
FREE F(DSCLANG DSCOPT)
DEL 'mytsoid.SELVOLS.OUTP
I see lots of SQL floating around here.
Since my server is OS390, I tried a "query" in batch. However, the
command was too long for a 72-column "card".
What character is used to continue SQL commands onto subsequent lines ? I
tried the standard "-" which works for almost *ALL* other OS390 util
14 matches
Mail list logo
