ADSM-L

Re: AW: SQL on OS390

2001-07-13 10:02:46
Subject: Re: AW: SQL on OS390
From: "Toora, Kuli" <kulbinder.toora AT NPOWER DOT COM>
Date: Fri, 13 Jul 2001 15:03:51 +0100
i think there is a command -noprompt that may help here.

I have TSM on OS390 2.7 and the SQL syntax i use is :

//STEP01  EXEC PGM=IKJEFT1B,DYNAMNBR=100,REGION=4M,ACCT=000038
//STEPLIB  DD DSN=CEE.SCEERUN,DISP=SHR                        
//SYSTSPRT DD SYSOUT=*                                        
//SYSPRINT DD SYSOUT=*                                        
//SYSTCPD  DD DSN=TCP.SYSB.TCPPARMS(TCPDATA),DISP=SHR         
//DSCOPT   DD DSN='options file',DISP=SHR            
//DSCLANG  DD DSN=ADSM.V3R1M0.SANSMSG(ANSMENU),DISP=SHR       
//SYSTSIN  DD *                                               
ANSADM -ID=******** -PAS=******** -NOCONFIRM
//SYSIN    DD *                      
SET SQLDISPLAYMODE W                 
SELECT * -                           
FROM BACKUPS -                       
WHERE NODE_NAME ='**********' -        
> 'dataset name'         
QUIT                                 
/*                                   

this has been working fine without problems.

Thanks,

Kuli Toora
Npower
Enterprise Services
Kingswinford

01384 275346
Mobile : 07989 492903

mailto:Kulbinder.toora AT npower DOT com



<Prev in Thread] Current Thread [Next in Thread>