InfoSphere Optim

InfoSphere Optim

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  If else statement on column Map

    Posted Wed June 29, 2022 03:24 PM
    Hi All,

    is there any way we can do simple if else on column map? without using column map procedure or Lua script? 

    i have tried using column map procedure but it throws bit compatibility error.  - "XFMNID_ERR_PSTBASIC_UNSUPPORTED(12067) ODPP NID: PST BASIC is not supported for
    WIN 64"

    ------------------------------
    rajesh guttikonda
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: If else statement on column Map

    Posted Wed June 29, 2022 03:26 PM
    Rajesh,

    Are you entering the column map procedure in Designer?  If not, that is probably the error.  The Classic version of Optim isn't set up to accept Lua.

    Let me know if that helps.

    --

    Jimmy Wilson

    1999 S. Bascom Ste 700

    Campbell, CA 95008

    Phone +1(972) 567-5558

    jwilson@abmartin.com

     

    Unstructured Data Masking

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




    Original Message


  • 3.  RE: If else statement on column Map

    Posted Thu June 30, 2022 02:06 PM
    Yes jimmy, i am aware that column map procedure can't be run in classic. 

    i am trying to find option to run if else conditions in column map using expand source column option. 

    Also, is there an option to trim extra spaces for the column values in Optim classic?

    ------------------------------
    rajesh guttikonda
    ------------------------------

    Original Message


  • 4.  RE: If else statement on column Map

    Posted Thu June 30, 2022 02:13 PM
    Rajesh,

    You can execute the column map procedure in Classic.  You just cannot design it in Classic.  The primary way is to create the Lua scripts in the Designer product.  Those can be assigned to the column maps in Classic or Designer.  They can then be executed in either UI or the command line.

    There is no trim function in Optim.  A column map Lua procedure could be used to perform the trim function.

    Hope that helps.

    --

    Jimmy Wilson

    1999 S. Bascom Ste 700

    Campbell, CA 95008

    Phone +1(972) 567-5558

    jwilson@abmartin.com

     

    Unstructured Data Masking

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




    Original Message


  • 5.  RE: If else statement on column Map

    Posted Fri July 01, 2022 10:07 AM
    Hi Rajesh,  

    Using PST Basic for a column map procedure no longer functions with Optim on 64 bit systems.  That is why you get the error.  If you want to write a column map procedure it will have to be in LUA and you can not write LUA using the Optim Classic column map procedure editor. As Jimmy pointed out, that needs to be done in Optim Designer.

    There are no column map functions you can use in the source column (expanded or otherwise) for a general if/else operation nor is there a straight up trim operation.  If you are looking to trim the data prior to transforming it, then you could use TRANS COL or pro=aff and set a space as one of the trim values, but that would trim all spaces and then perform a transformation of the data.

    Regards,

    Tammy

    ------------------------------
    Tammy Ziegler
    ------------------------------

    Original Message


Related Content