stop processing

[drfg2008]

How can the complete SPSS syntax be stopped if a data base query in the beginning of the program fails (no access to database. We have 7 db queries in one syntax and if one fails because one db is down, the whole program should stop).

[David Marso]

File > Stop Processor?
Ctrl + .
Pull plug (on laptop also yank battery)

drfg2008 wrote

How can the complete SPSS syntax be stopped if a data base query in the beginning of the program fails (no access to database. We have 7 db queries in one syntax and if one fails because one db is down, the whole program should stop).

[Rick Oliver-3]

Submit the syntax as an INSERT file with ERROR=STOP, as in:

INSERT FILE='file.sps' ERROR=STOP.

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]



From:        David Marso <[hidden email]>
To:        [hidden email],
Date:        10/15/2013 11:23 AM
Subject:        Re: stop processing
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

File > Stop Processor?
Ctrl + .
Pull plug (on laptop also yank battery)


drfg2008 wrote
> How can the complete SPSS syntax be stopped if a data base query in the
> beginning of the program fails (no access to database. We have 7 db
> queries in one syntax and if one fails because one db is down, the whole
> program should stop).





-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/stop-processing-tp5722557p5722559.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Andy W]

In addition to David's advice - if you run it from a production job will the "ERROR=STOP" option work if the program fails (whatever program fails means)?

[drfg2008]

INSERT FILE='file.sps' ERROR=STOP.


Thanks!