Re: AW: SQL on OS390
2001-07-13 10:02:46
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
|
|
|