IBM MAINFRAME HELP & SUPPORT FORUMS
Technical Forums for IBM Mainframe Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7&11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
 

what is the functionality of STRIP command in DB2 and SCHENV

THIS IS AN ARCHIVE FORUM: CLICK HERE TO GO TO THE ORIGINAL TOPIC

 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> DB2
View previous topic :: View next topic  
Author Message
bharathyyy



Joined: 13 Jun 2005
Posts: 6

Posted: Wed Jun 15, 2005 11:58 am    Post subject: what is the functionality of STRIP command in DB2 and SCHENV  

Can any one explain about

1. STRIP in DB2 "
2. SCHENV, what does it mean in JCL ?
Back to top  
ovreddy



Joined: 06 Dec 2004
Posts: 200
Location: Keane India Ltd., Hyderabad

Posted: Wed Jun 15, 2005 2:25 pm    Post subject:  

Hi Bharat,

1 Ans: The STRIP function removes blanks or another specified character from the end, the beginning, or both ends of a string expression.

Syntax: STRIP(String EXP,Leading/Trailing/Both,Strip Character);

Strip char is blank by default.

Eg:
01 A PIC X(10) VALUE "0000123456".

STRIP(:A, L,'0');
will remove leading zeros.

2 Ans:

SCHENV - Used to specify Scheduling Environment name of a JOb.
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.

Thanks,
Reddy
Back to top  
kulkarni_alok



Joined: 07 Jul 2005
Posts: 4

Posted: Fri Jul 08, 2005 12:25 am    Post subject:  

can you please provide the full usage of STRIP command and also the complete SQL using strip command
Back to top  
 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> DB2
Page 1 of 1
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM