select varbinary('asdf') from sysibm.sysdummy1;
x
SELECT
LOCATE('0142', '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 '),
position( 'xy' || ibmreqd, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 xy' || ibmReqD
, octets)
from sysibm.sysDummy1
with ur
;
x
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;
SELECT '>>>', COUNT(distinct V833.PARTNER_KEY ), current timestamp
FROM OA1P.VKS833A1V V833
, OA1P.VKS835A1V V835
WHERE V833.CONTRACT_COLL = '07475074735929-L'
AND V833.PARTNER_TYPE = 3
AND CURRENT DATE BETWEEN V833.VALID_FROM_DATE
AND V833.VALID_TO_DATE
AND V833.CONTRACT_KEY = V835.CONTRACT_KEY
AND V833.PARTNER_KEY = V835.PARTNER_KEY
AND CURRENT DATE BETWEEN V835.VALID_FROM_DATE
AND V835.VALID_TO_DATE
AND LOCATE(V835.PRODUCT_ID, '0052
0053
0054
0055 ,
0056 ,
0057 ,
0058 ,
0142 ,
0152 ,
0153 ,
0167 ,
0168 ,
0169 ,
0179 ') > 0
with ur
;