IBM Optim

IBM Optim

Enable Data Operations with Optim for AI and Cloud - accelerating innovation, reducing costs, ensuring data sovereignty

 View Only

  • 1.  optim column map CurDat function

    Posted Thu April 11, 2024 02:56 PM

    Hello All, 

    We are trying populate yesterday date into one of the column in oracle. using column map in optim 11.7

    We could see that there is an option to load CURDATE which loads todays date, but couldn't find a way to  subtract a day from current date. 

    is there a way, we can get the yesterday date or subtract a day from CURDATE and load into oracle target database. 



    ------------------------------
    R G
    ------------------------------


  • 2.  RE: optim column map CurDat function

    Posted Thu April 11, 2024 03:36 PM
    RG,

    You might try something like CURDATE()-1.

    That should do the trick for you.

    --

    Jimmy Wilson


    1999 S. Bascom Ste 700

    Campbell, CA 95008

    Phone +1(972) 567-5558

    jwilson@abmartin.com

     

    Confidentiality: This transmission, including any attachments, is solely for the use of the intended recipient(s). This transmission may contain information that is confidential or otherwise protected from disclosure. The use or disclosure of the information contained in this transmission, including any attachments, for any purpose other than that intended by its transmittal is strictly prohibited. Unauthorized interception of this email is a violation of federal criminal law. If you are not an intended recipient of this transmission, please immediately destroy all copies received and notify the sender.

    Unstructured Data Masking

    Data Privacy/Test data Management - fabrication, optimization, obfuscation






  • 3.  RE: optim column map CurDat function

    Posted Thu April 11, 2024 04:29 PM

    Hey Jimmy, Thanks for quick response. i have tried the option, it didnt throw any validation error. 

    but surprisingly once I save and run the job , "-1" disappears from column map. 



    ------------------------------
    R G
    ------------------------------

    Original Message


  • 4.  RE: optim column map CurDat function

    Posted Thu April 11, 2024 05:33 PM
    RG,

    You are correct and I am surprised.  When you save the syntax and simply reopen it, the -1 part of the entry is gone.

    I guess you would have to resort to a small Lua script to do this aging.

    Or you might open a trouble ticket to see if that is the correct behavior.

    --

    Jimmy Wilson


    1999 S. Bascom Ste 700

    Campbell, CA 95008

    Phone +1(972) 567-5558

    jwilson@abmartin.com

     

    Confidentiality: This transmission, including any attachments, is solely for the use of the intended recipient(s). This transmission may contain information that is confidential or otherwise protected from disclosure. The use or disclosure of the information contained in this transmission, including any attachments, for any purpose other than that intended by its transmittal is strictly prohibited. Unauthorized interception of this email is a violation of federal criminal law. If you are not an intended recipient of this transmission, please immediately destroy all copies received and notify the sender.

    Unstructured Data Masking

    Data Privacy/Test data Management - fabrication, optimization, obfuscation




    Original Message


  • 5.  RE: optim column map CurDat function

    Posted Thu April 11, 2024 05:40 PM

    Thats fine. i have generated a text file with yesterday's date and loaded the date using lua script. 

    that has done the job for me. 



    ------------------------------
    R G
    ------------------------------

    Original Message


Related Content