# Linhas começando com # são consideradadas como comentários e não são processadas
# Linhas que não possum um pipe ão consideradas como linhas em branco e não são processadas.
# As trocas funcionam no formato "Search and Replace", com os dados delimitados por pipes. Ex: |Search|Replace|
# Havendo a necessidade de usar pipes internos no Search ou no Replace, deve-se utilizar |' para iniciar e '| para finalizar tanto o Search como o Replace. Ex: |'|SearchComPipe|'|'|ReplaceComPipe|'|
# Ao usar "Search and Replace" com pipes internos é obrigatório usar os delimitadores |' e '| em ambos os lados. No Search e no Replace. Ex: |'|"DM_VC00050"|'|'"DM_VC00050"'|

# Textos diversos para serem trocados
| CORR | "CORR" |
|/* Trigger body */||
| CHARACTER SET NONE;| ;|
| SUBSTR(A.NRCONTRATO, 1, POSITION('/', A.NRCONTRATO) -1) NUMERO_ORDEM| SUBSTRING(A.NRCONTRATO FROM 1 FOR POSITION('/', A.NRCONTRATO) -1) NUMERO_ORDEM|

# Domain fora do padrao
| "D_DECIMAL14,6"| "DM_DEC14_6"|

#  Trocar tipos por domains
| BIGINT;| DM_BIGINT;|
| BLOB SUB_TYPE 0 SEGMENT SIZE 80| DM_BLOB_BIN00080|
| BLOB SUB_TYPE 1 SEGMENT SIZE 80| DM_BLOB_TXT00080|
| CHAR(1)| DM_CH00001|
| CHAR(10)| DM_CH00010|
| CHAR(11)| DM_CH00011|
| CHAR(12)| DM_CH00012|
| CHAR(13)| DM_CH00013|
| CHAR(14)| DM_CH00014|
| CHAR(150)| DM_CH00150|
| CHAR(17)| DM_CH00017|
| CHAR(2)| DM_CH00002|
| CHAR(20)| DM_CH00020|
| CHAR(200)| DM_CH00200|
| CHAR(25)| DM_CH00025|
| CHAR(3)| DM_CH00003|
| CHAR(30)| DM_CH00030|
| CHAR(31)| DM_CH00031|
| CHAR(4)| DM_CH00004|
| CHAR(40)| DM_CH00040|
| CHAR(400)| DM_CH00400|
| CHAR(5)| DM_CH00005|
| CHAR(6)| DM_CH00006|
| CHAR(60)| DM_CH00060|
| CHAR(7)| DM_CH00007|
| DATE;| DM_DATE;|
| DOUBLE PRECISION| DM_DOUBLEPRECISION|
| INTEGER;| DM_INTEGER;|
| NUMERIC(12,2)| DM_NUM12_2|
| NUMERIC(12,3)| DM_NUM12_3|
| NUMERIC(12,4)| DM_NUM12_4|
| NUMERIC(12,5)| DM_NUM12_5|
| NUMERIC(12,6)| DM_NUM12_6|
| NUMERIC(14,1)| DM_NUM14_1|
| NUMERIC(14,2)| DM_NUM14_2|
| NUMERIC(14,4)| DM_NUM14_4|
| NUMERIC(15,2)| DM_NUM15_2|
| NUMERIC(15,3)| DM_NUM15_3|
| NUMERIC(15,4)| DM_NUM15_4|
| NUMERIC(18,2)| DM_NUM18_2|
| NUMERIC(18,3)| DM_NUM18_3|
| NUMERIC(18,4)| DM_NUM18_4|
| NUMERIC(18,6)| DM_NUM18_6|
| NUMERIC(18,8)| DM_NUM18_8|
| TIME;| DM_TIME;|
| TIMESTAMP;| DM_TIMESTAMP;|
| VARCHAR(1)| DM_VC00001|
| VARCHAR(10)| DM_VC00010|
| VARCHAR(100)| DM_VC00100|
| VARCHAR(1000)| DM_VC01000|
| VARCHAR(1024)| DM_VC01024|
| VARCHAR(11)| DM_VC00011|
| VARCHAR(113)| DM_VC00113|
| VARCHAR(12)| DM_VC00012|
| VARCHAR(120)| DM_VC00120|
| VARCHAR(13)| DM_VC00013|
| VARCHAR(14)| DM_VC00014|
| VARCHAR(15)| DM_VC00015|
| VARCHAR(150)| DM_VC00150|
| VARCHAR(1500)| DM_VC01500|
| VARCHAR(152)| DM_VC00152|
| VARCHAR(16)| DM_VC00016|
| VARCHAR(170)| DM_VC00170|
| VARCHAR(2)| DM_VC00002|
| VARCHAR(20)| DM_VC00020|
| VARCHAR(200)| DM_VC00200|
| VARCHAR(2000)| DM_VC02000|
| VARCHAR(202)| DM_VC00202|
| VARCHAR(23)| DM_VC00023|
| VARCHAR(25)| DM_VC00025|
| VARCHAR(250)| DM_VC00250|
| VARCHAR(255)| DM_VC00255|
| VARCHAR(256)| DM_VC00256|
| VARCHAR(257)| DM_VC00257|
| VARCHAR(260)| DM_VC00260|
| VARCHAR(3)| DM_VC00003|
| VARCHAR(30)| DM_VC00030|
| VARCHAR(300)| DM_VC00300|
| VARCHAR(3000)| DM_VC03000|
| VARCHAR(31)| DM_VC00031|
| VARCHAR(32)| DM_VC00032|
| VARCHAR(35)| DM_VC00035|
| VARCHAR(4)| DM_VC00004|
| VARCHAR(40)| DM_VC00040|
| VARCHAR(400)| DM_VC00400|
| VARCHAR(42)| DM_VC00042|
| VARCHAR(44)| DM_VC00044|
| VARCHAR(49)| DM_VC00049|
| VARCHAR(5)| DM_VC00005|
| VARCHAR(50)| DM_VC00050|
| VARCHAR(500)| DM_VC00500|
| VARCHAR(5000)| DM_VC05000|
| VARCHAR(52)| DM_VC00052|
| VARCHAR(53)| DM_VC00053|
| VARCHAR(6)| DM_VC00006|
| VARCHAR(60)| DM_VC00060|
| VARCHAR(600)| DM_VC00600|
| VARCHAR(6000)| DM_VC06000|
| VARCHAR(65)| DM_VC00065|
| VARCHAR(7)| DM_VC00007|
| VARCHAR(70)| DM_VC00070|
| VARCHAR(700)| DM_VC00700|
| VARCHAR(8)| DM_VC00008|
| VARCHAR(80)| DM_VC00080|
| VARCHAR(800)| DM_VC00800|
| VARCHAR(9)| DM_VC00009|
| VARCHAR(900)| DM_VC00900|
| VARCHAR(9000)| DM_VC09000|
| VARCHAR(10000)| DM_VC10000|
| VARCHAR(19999)| DM_VC25000|
| VARCHAR(30000)| DM_VC30000|

# Trocar domains antigos que estão espalhados pelo corpo das procedures
| D_0800| DM_0800|
| D_ABREVIACAO| DM_ABREVIACAO|
| D_BLOB| DM_BLOB|
| D_BLOB_IMAGEM| DM_BLOB_IMAGEM|
| D_BLOB_TEXTO| DM_BLOB_TEXTO|
| D_CART_IDENT| DM_CART_IDENT|
| D_CEP| DM_CEP|
| D_CHAR_01| DM_CH00001|
| D_CHAR_02| DM_CH00002|
| D_CHAR_03| DM_CH00003|
| D_CHAR_04| DM_CH00004|
| D_CHAR_05| DM_CH00005|
| D_CHAR_06| DM_CH00006|
| D_CHAR_07| DM_CH00007|
| D_CHAR_08| DM_CH00008|
| D_CHAR_09| DM_CH00009|
| D_CHAR_10| DM_CH00010|
| D_CHAR_11| DM_CH00011|
| D_CHAR_12| DM_CH00012|
| D_CHAR_13| DM_CH00013|
| D_CHAR_14| DM_CH00014|
| D_CNPJ| DM_CNPJ|
| D_CPF| DM_CPF|
| D_DATA| DM_DATA|
| D_DATA_HORA| DM_DATA_HORA|
| D_DESCRICAO| DM_DESCRICAO|
| D_DOUBLEPRECISION| DM_DOUBLEPRECISION|
| D_EMAIL| DM_EMAIL|
| D_FLOAT| DM_FLOAT|
| D_INSCR_ESTADUAL| DM_INSCR_ESTADUAL|
| D_INTEIRO| DM_INTEIRO|
| D_NOME| DM_NOME|
| D_NUMERIC| DM_NUM15_4|
| D_NUMERIC_3| DM_NUM03_2|
| D_NUMERIC_5| DM_NUM05_2|
| D_NUMERIC_8| DM_NUM08_2|
| D_SEXO| DM_SEXO|
| D_TELEFONE| DM_TELEFONE|
| D_TIME| DM_TIME|
| D_TITULO_ELEITOR| DM_TITULO_ELEITOR|
| D_UF| DM_UF|
| D_VARCHAR_01| DM_VC00001|
| D_VARCHAR_02| DM_VC00002|
| D_VARCHAR_03| DM_VC00003|
| D_VARCHAR_04| DM_VC00004|
| D_VARCHAR_05| DM_VC00005|
| D_VARCHAR_06| DM_VC00006|
| D_VARCHAR_07| DM_VC00007|
| D_VARCHAR_08| DM_VC00008|
| D_VARCHAR_09| DM_VC00009|
| D_VARCHAR_10| DM_VC00010|
| D_VARCHAR_100| DM_VC00100|
| D_VARCHAR_11| DM_VC00011|
| D_VARCHAR_12| DM_VC00012|
| D_VARCHAR_120| DM_VC00120|
| D_VARCHAR_13| DM_VC00013|
| D_VARCHAR_14| DM_VC00014|
| D_VARCHAR_15| DM_VC00015|
| D_VARCHAR_150| DM_VC00150|
| D_VARCHAR_16| DM_VC00016|
| D_VARCHAR_17| DM_VC00017|
| D_VARCHAR_18| DM_VC00018|
| D_VARCHAR_19| DM_VC00019|
| D_VARCHAR_20| DM_VC00020|
| D_VARCHAR_200| DM_VC00200|
| D_VARCHAR_2000| DM_VC02000|
| D_VARCHAR_205| DM_VC00205|
| D_VARCHAR_25| DM_VC00025|
| D_VARCHAR_250| DM_VC00250|
| D_VARCHAR_255| DM_VC00255|
| D_VARCHAR_256| DM_VC00256|
| D_VARCHAR_30| DM_VC00030|
| D_VARCHAR_300| DM_VC00300|
| D_VARCHAR_35| DM_VC00035|
| D_VARCHAR_40| DM_VC00040|
| D_VARCHAR_45| DM_VC00045|
| D_VARCHAR_50| DM_VC00050|
| D_VARCHAR_500| DM_VC00500|
| D_VARCHAR_55| DM_VC00055|
| D_VARCHAR_60| DM_VC00060|
| D_VARCHAR_600| DM_VC00600|
| D_VARCHAR_65| DM_VC00065|
| D_VARCHAR_70| DM_VC00070|
| D_VARCHAR_75| DM_VC00075|
| D_VARCHAR_80| DM_VC00080|
| D_VARCHAR_85| DM_VC00085|
| D_VARCHAR_90| DM_VC00090|
| D_VARCHAR_95| DM_VC00095|
| D_VARCHAR_1000| DM_VC01000|
| D_VARCHAR_1500| DM_VC01500|
| D_VARCHAR_23| DM_VC00023|
| D_VARCHAR_3000| DM_VC03000|

| DM_DATA;| DM_DATE;|

| DM_CH0001 | DM_CH00001 |
| DM_CH0001;| DM_CH00001;|
| DM_CH0001,| DM_CH00001,|
| DM_CH0001)| DM_CH00001)|

| DM_VC0001 | DM_VC00001 |
| DM_VC0001;| DM_VC00001;|
| DM_VC0001,| DM_VC00001,|
| DM_VC0001)| DM_VC00001)|

| DM_VC0003 | DM_VC00003 |
| DM_VC0003;| DM_VC00003;|
| DM_VC0003,| DM_VC00003,|
| DM_VC0003)| DM_VC00003)|

| DM_VC0010 | DM_VC00010 |
| DM_VC0010;| DM_VC00010;|
| DM_VC0010,| DM_VC00010,|
| DM_VC0010)| DM_VC00010)|

| DM_VC0020 | DM_VC00020 |
| DM_VC0020;| DM_VC00020;|
| DM_VC0020,| DM_VC00020,|
| DM_VC0020)| DM_VC00020)|

| DM_VC0040 | DM_VC00040 |
| DM_VC0040;| DM_VC00040;|
| DM_VC0040,| DM_VC00040,|
| DM_VC0040)| DM_VC00040)|

| DM_VC0050 | DM_VC00050 |
| DM_VC0050;| DM_VC00050;|
| DM_VC0050,| DM_VC00050,|
| DM_VC0050)| DM_VC00050)|

| DM_VC0100 | DM_VC00100 |
| DM_VC0100;| DM_VC00100;|
| DM_VC0100,| DM_VC00100,|
| DM_VC0100)| DM_VC00100)|

| DM_VC0200 | DM_VC00200 |
| DM_VC0200;| DM_VC00200;|
| DM_VC0200,| DM_VC00200,|
| DM_VC0200)| DM_VC00200)|

| DM_VC0500 | DM_VC00500 |
| DM_VC0500;| DM_VC00500;|
| DM_VC0500,| DM_VC00500,|
| DM_VC0500)| DM_VC00500)|

| DM_VC1000 | DM_VC01000 |
| DM_VC1000;| DM_VC01000;|
| DM_VC1000,| DM_VC01000,|
| DM_VC1000)| DM_VC01000)|

| DM_VC1024 | DM_VC01200 |
| DM_VC1024;| DM_VC01200;|
| DM_VC1024,| DM_VC01200,|
| DM_VC1024)| DM_VC01200)|

| DM_VC2000 | DM_VC02000 |
| DM_VC2000;| DM_VC02000;|
| DM_VC2000,| DM_VC02000,|
| DM_VC2000)| DM_VC02000)|

| DM_VC3000 | DM_VC03000 |
| DM_VC3000;| DM_VC03000;|
| DM_VC3000,| DM_VC03000,|
| DM_VC3000)| DM_VC03000)|

| DM_VC4000 | DM_VC04000 |
| DM_VC4000;| DM_VC04000;|
| DM_VC4000,| DM_VC04000,|
| DM_VC4000)| DM_VC04000)|

| DM_VC5000 | DM_VC05000 |
| DM_VC5000;| DM_VC05000;|
| DM_VC5000,| DM_VC05000,|
| DM_VC5000)| DM_VC05000)|
