Products
Solutions
Support & Services
Company
How To Buy
Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Register
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Communities
Enterprise Software
Mainframe Software
Symantec Enterprise
Blogs
All Blogs
Enterprise Software
Mainframe Software
Symantec Enterprise
Events
Enterprise Software
Mainframe Software
Symantec Enterprise
VMware
Water Cooler
Education
Groups
Enterprise Software
Mainframe Software
Symantec Enterprise
Automic Workload Automation
Private Community
Community Home
Threads
Library
Events
Members
Back to discussions
Expand all
|
Collapse all
Suche nach JOBS Objekten ohne LOGIN
1.
Suche nach JOBS Objekten ohne LOGIN
0
Recommend
Legacy User
Posted Dec 06, 2017 12:44 PM
Reply
Reply Privately
Options Dropdown
Frage:
Gibt es eine Möglichkeit nach JOBS Objekten zu suchen wo das Login Feld nicht befüllt ist.
Antwort:
Mit diesem Statement können Sie alle JOBS Objekte finden welche kein Login Objekt enthalten. - gefiltert nach dem Mandanten:
select oh.oh_name, oh.oh_client from JBA, OH
where jba_logindst is null
and oh.oh_idnr = jba.jba_oh_idnr
and oh.oh_client = '***'
order by oh.oh_client, oh.oh_name;
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Footer
Copyright 2023. All rights reserved.
Powered by Higher Logic