Shulou(Shulou.com)05/31 Report--

What are the commonly used functions in goldengate? I believe many inexperienced people are at a loss about this. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

1. Where

Mainly used for filtering, such as the following usage:

1 、 MAP gdxlcs.mugua, TARGET gdxlcs.mugua

WHERE (object_name= "MYTEST") TABLE gdxlcs.mugua, FILTER (ON UPDATE, ON)

DELETE, OBJECT_ID > 50)

2. @ STRFIND

FILTER (@ STRFIND)

(OBJECT_NAME, "MYOBJECT") > 0)

To find out if it exists, you can use it in the replication process.

@ STRLEN (ename) > 40

Judge length

4. @ STRNUM

Convert numbers to characters

5. @ STRCAT

Merge character

COLMAP (USEDEFAULTS

Object_script= @ STRCAT (object_name,object_type)

6. @ compute

COLMAP

(usedefaults, object_id_bak= @ compute (object_id+100000))

7. Date function

@ DATE and @ DATENOW

FILTER (created > @ DATENOW)

Conditional judgment function

IF, CASE, EVAL, VALONEOF

FILTER (@ IF (object_id > 60000, object_id, 0) > 100)

9. @ TOKEN

Process monitoring function

After reading the above, have you mastered the methods of functions commonly used in goldengate? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.