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

Senior Member


Joined: 15 Aug 2015
Posts: 1255
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: 3053
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 Using the Jobname parameter in a Qual... ABENDS & Debugging 1
No new posts Demand with DEADLINE TIME parameter CA Products 4
No new posts Option DYNALLOC second parameter. DFSORT/ICETOOL 11
No new posts Writing the output file name from a p... JCL & VSAM 7
No new posts Reference for COND parameter. JCL & VSAM 1
Search our Forums:

Back to Top