| 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...
|
| 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 |
|
| |
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM
|