Test Data Manager

Tech Tip: Datamaker: How to use keywords such as PUBLIC

  • 1.  Tech Tip: Datamaker: How to use keywords such as PUBLIC

    Posted 02-21-2018 07:02 PM

    There have been a couple of cases opened in Support recently requesting the method on how to use keywords that are in the column headings. 

     

    The first answer is to change the column headings to a non-keyword.  However, this may not be possible due to the table residing in a common area that is not controlled by the person who has to mask the data.

     

    The second answer is to notice Datamaker that there is an exception to be used when dealing with this generally understood reserved or keyword.  The method to accomplish this is as follows:


    INSERT INTO [dbo].[gtrep_reserved_names] 
    ([rn_word]) 
    VALUES 
    ('Public') 

     


    You now can do the sampling and publishing even with a column called "public".  Once this is done, try this in Portal. 

     

    Same applies to other keywords: 

     

    Class 

     

    key 

     

    rule 

     

    primary 

     

    view 

     

    plan 

     

    Cheers!

    Les