Search found 4 matches

by Abdul Lateef
Thu Feb 23, 2012 6:24 pm
Forum: JCL
Topic: JCL to pass string greater than 80
Replies: 7
Views: 10348

the problem is with e-mail address, if the length is greater than 80 then how can i pass it in JCL.
by Abdul Lateef
Thu Feb 23, 2012 5:39 pm
Forum: JCL
Topic: JCL to pass string greater than 80
Replies: 7
Views: 10348

JCL to pass string greater than 80

Hi Team, I have a job which uses IEBGENER utility to send email to the recipient. This job work fine if the email id is lessthan 80 characters. My question is it possible to send email which is having length greater than 80 characters in jcl. If so then what would be the syntax for it. Thanks in adv...
by Abdul Lateef
Thu Nov 24, 2011 10:08 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Need DB2 query based on range selection
Replies: 3
Views: 4529

Hi, I got my query. SELECT * FROM TABLE WHERE ((:WS-START-RANGE >=START_RANGE AND :WS-START-RANGE <= END_RANGE) OR (:WS-END-RANGE >= START_RANGE AND :WS-END-RANGE <= END_RANGE) OR (:WS-START-RANGE < (SELECT START_RANGE FROM TABLE ORDER BY START_RANGE ASC FETCH FIRST 1 ROWS ONLY))); Thanks for your r...
by Abdul Lateef
Wed Nov 23, 2011 2:02 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Need DB2 query based on range selection
Replies: 3
Views: 4529

Need DB2 query based on range selection

Hi, I have a table as below start-range end-range 20 30 40 50 60 80 I need to check the availability of range. For example 1) if i select range 20(start-range) to 30(end-range) then it should give me sqlcode as zero. 2) if i select 25 to 35 also it should give me sqlcode as zero. 3) when i request f...