IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SCHENV parameter


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ankit917350

New User


Joined: 22 Aug 2021
Posts: 1
Location: United States

PostPosted: Sun Aug 22, 2021 4:37 pm
Reply with quote

I want to connect to teradata table for Select query as well as Google bigquery environment in same job.
There is a parameter in Job-card SCHENV which is TESWC for teradata and GCXS for bigquery.
Is there a way I can connect to different environment in same job based on some condition
Back to top
View user's profile Send private message
Joerg.Findeisen

Active Member


Joined: 15 Aug 2015
Posts: 623
Location: Bamberg, Germany

PostPosted: Sun Aug 22, 2021 4:46 pm
Reply with quote

Purpose

For JES2 jobs only, use the SCHENV parameter to specify the name of the WLM scheduling environment that is to be associated with this job. A scheduling environment is a list of required resource state settings. By associating a scheduling environment name with a job, you ensure that the job will be scheduled only on a system that satisfies those resource state settings. Note, however, that the job will go through JCL conversion prior to being held. If the JCL of the job refers to a subsystem (DD SUBSYS=), then TYPRUN=JCLHOLD is the only way to ensure that the required subsystem is actually up and functioning at JCL conversion-time.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2792
Location: NYC,USA

PostPosted: Sun Aug 22, 2021 7:06 pm
Reply with quote

ankit917350 wrote:
I want to connect to teradata table for Select query as well as Google bigquery environment in same job.
There is a parameter in Job-card SCHENV which is TESWC for teradata and GCXS for bigquery.
Is there a way I can connect to different environment in same job based on some condition

Welcome!
You will need to send this question to right support group at your site. Usually it depends how your environments are configured , i have some like this for some of the environments but we have different jobs set up accordingly. So that’s why forum can’t answer these type of questions except to give an idea about what is what.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts DECIMAL HOST VARIABLE OR PARAMETER 14... DB2 7
No new posts Parameter description for Beta92 prog... Compuware & Other Tools 1
No new posts SMF Specify in the INCLUDE parameter ... DFSORT/ICETOOL 7
No new posts New Parameter should be added to the ... CLIST & REXX 30
No new posts Can we pass the value of Symbolic par... JCL & VSAM 5
Search our Forums:

Back to Top