dovle01

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

Discussion created by dovle01 Employee on Feb 22, 2018

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

Outcomes