db2 luw - DB2 - Determine a future date based on two fields -

-

I need to calculate a date in DB2 for Unix.

I have a date field: CONTRACT_DT (example: 2/7/2006, 8/25/2006, 11/16/2007, 2/25/2008, 12/29/2005)

and one type of field head (example: C, I, E, Z, V, K)

I need to calculate the next date that the loan will be reviewed (REVIEW_DT ).

  • If Prime = Z is CONTRACT_DT < Five Years
  • If the Prime Minister = Faucet or any other letter, then Tap

    An example loan 01 has a CONTRACT_DT of 3/1/2004, and V PRIME. So I need to count 3/1 for three years / 2004, unless I have a date of more than MTHLY_CLOSE_DT. (Option 2007, 2010, 2013, 2016, 2019, 2022).
    The correct answer is 3/1/2016.

    I know that the structure is a matter statement, but I have no idea how to choose a date based on multiples of the year and there is one more than the MNTHEYCTTDTT.

    Even what I have so far: 

      created process "finance" "AL_LOOP_TEST" (out R. RVDT Date) BEGIN Nuclear Agreement v_tmgi DATE; DECLARE v_ctdt DATE; DECLARE v_rvdt DATE; SET v_tmgi = '2014-09-01'; --Good month SET v_ctdt = '2012-06-02'; - CONTRACT_DT SET v_rvdt = v_ctdt; - v_rvdt initial value for WHILE (v_rvdt & lt; v_tmgi) - While the review DT is less than the month of DO SET v_rvdt = (v_rvdt + 5 YEAR); - Add up to date of 5 years; SET r_rvdt = v_rvdt; END   
     Thanks!   
     
     
     Jimmy, thanks for your help, this is what I have created:  
      The process of making "X" "AL_LOOP_TEST" (outside "R_RVD" date) Language SQL fixed external procedure improvements SQL data Old Savings Pattern Start ATMs announcement v_tmgi DATE; DECLARE v_ctdt DATE; DECLARE v_rvdt DATE; SET v_tmgi = '2014-09-01'; --Good month SET v_ctdt = '2002-06-02'; - CONTRACT_DT SET v_rvdt = v_ctdt; - The initial value for v_rvdt WHILE (v_rvdt & lt; v_tmgi) - While the review DT is less than the month of DO SET v_rvdt = (v_rvdt + 5 YEAR); - Add up to date of 5 years; SET r_rvdt = v_rvdt; End;

    • Comments

    Post a Comment

    Popular posts from this blog

    php - PDO bindParam() fatal error -

    -
    I am trying to learn PDO, now I have written this small code, but it gives me a serious error: Fatal error: Call a member function at a non-object dot () ... $ con = new mysqli ("127.0.0.1", "root", "", "csvdangercheck"); $ Query = $ con- & gt; ("Id,` var1`, `var2`) values ​​(" id,: var1,: var2) ";); $ query- & gt; bypass pattern (': id', $ id); $ query- & gt; BindParam (': var1', $ VAL1); $ Query- & gt; bindParam (': var2', $ val2); $ Query-> Executed (); I Trying to use print_r ($ con-> errorInfo ()) but Fatal error: Undefined method mysqli :: errorInfo ( ) ... can someone tell me what am I missing? Flaffeh said, you have PDO Missing Mysqy, try it: $ con = new PDO ('mysql: host = 127.0.0.1; dbname = csvdangercheck', 'root', '');
    Read more

    php - How can I cram 6+31 numeric characters into 22 alphanumeric characters? -

    -
    I have a 6 digit number and a 31-digit number (such as "234536" and "201103231043330478311223582826") that I The API needs to be crawled in the same 22-character alphanumeric field that uses PHP. I tried to convert each one to 32 (using custom code could not handle the base_convert () large number) and to connect with a single-character delimiter, but It only gives me 26 characters This is a restore API, so the letters should be URI-protected. I would like to do a database table cross with two references without reference to another reference value, if possible, any suggestions? Instead use a radix of 62. This will give you 22 characters for the top, 3.35 for the pre and 17.3 for the next. & gt; & Gt; & Gt; Math.log (10 ** 6) /math.log (62) 3.3474826039165504 & gt; & Gt; & Gt; Math.log (10 ** 31) /math.log (62) 17.295326786902177
    Read more

    logging - How can I log both the Request.InputStream and Response.OutputStream traffic in my ASP.NET MVC3 Application for specific Actions? -

    -
    For a specific set of tasks, I need to log in to the incoming request inputstream as well as outgoing response. is. I am using an ActionFilterAttribute for this and overriding the OnActionExecuted and OnResultExecuted methods. So I'm starting with this idea ... Public category ActionLoggerAttribute: ActionFilterArrbit {Public Override Zero On-Offed Execution (ActionActioned Contact Filter Filter) {base.OnActionAxecuted (FilterContext); HttpRequestBase request = filterContext.HttpContext.Request; // TODO: Log the request. InputStream} Public Override Zero OnResultExecuted (ResultExecutedContext FilterContext) {base.OnResultExecuted (filterContext); HTTPRPSPointBase Response = FilterContacts Hpptex response; // TODO: Log on Response.OutputStream}} Ideally I'll hook it up with enterprise library logging because I'm already using it for error logging. Am I reaching the input and output stream at the right time? Can I easily use the Enterprise Library to log i...
    Read more