Search found 4 matches
- Thu Feb 23, 2012 6:24 pm
- Forum: JCL
- Topic: JCL to pass string greater than 80
- Replies: 7
- Views: 10348
- 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...
- 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...
- 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...