what is the functionality of STRIP command in DB2 and SCHENV

bharathyyy · New User Joined: 13 Jun 2005 Posts: 6

Can any one explain about

1. STRIP in DB2 "
2. SCHENV, what does it mean in JCL ?

ovreddy · Posted: Wed Jun 15, 2005 2:25 pm

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

kulkarni_alok · New User Joined: 07 Jul 2005 Posts: 4

can you please provide the full usage of STRIP command and also the complete SQL using strip command