Compare two Oracle table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Thx to all of you - but i still have some problems:
i created two stage variables 'A' and 'B'
A =
CRC32(FromTRS00_i.ACC_YEAR:FromTRS00_i.FINANCIAL_YEAR:FromTRS00_i.TREATY:FromTRS00_i.TREATY_SECTION:FromTRS00_i.PERIOD_START_DATE:FromTRS00_i.PERIOD_END_DATE:FromTRS00_i.RESP_DEPARTMENT:FromTRS00_i.RESP_DIVISION:FromTRS00_i.RESP_RESSORT:FromTRS00_i.LINE_OF_BUSINESS:FromTRS00_i.LOB_HIERARCHY_1:FromTRS00_i.LOB_HIERARCHY_2:FromTRS00_i.CLASS_OF_BUSINESS:FromTRS00_i.LIFE_OR_NON_LIFE:FromTRS00_i.PLANNING_SEGMENT:FromTRS00_i.TREATY_CATEGORY:FromTRS00_i.NATURE_OF_TREATY:FromTRS00_i.GROUP_CATEGORY:FromTRS00_i.GROUP_CAT_VALUE:FromTRS00_i.BUSINESS_TYPE:FromTRS00_i.FAS_CLASSIFICATION:FromTRS00_i.RI_CHARACTER:FromTRS00_i.SYMBOLISATION:FromTRS00_i.CEDENT:
FromTRS00_i.CEDENT_GROUP:FromTRS00_i.CEDENT_COUNTRY:FromTRS00_i.COMPANY_CODE:FromTRS00_i.PARTNER_INVOLVED:FromTRS00_i.AREA:FromTRS00_i.LEGAL_PARTNER:FromTRS00_i.PL_SEG:FromTRS00_i.MGF_FLAG)
and B =
CRC32(FromTRS00.ACC_YEAR:FromTRS00.FINANCIAL_YEAR:FromTRS00.TREATY:FromTRS00.TREATY_SECTION:FromTRS00.PERIOD_START_DATE:FromTRS00.PERIOD_END_DATE:FromTRS00.RESP_DEPARTMENT:FromTRS00.RESP_DIVISION:FromTRS00.RESP_RESSORT:FromTRS00.LINE_OF_BUSINESS:FromTRS00.LOB_HIERARCHY_1:FromTRS00.LOB_HIERARCHY_2:FromTRS00.CLASS_OF_BUSINESS:FromTRS00.LIFE_OR_NON_LIFE:FromTRS00.PLANNING_SEGMENT:FromTRS00.TREATY_CATEGORY:FromTRS00.NATURE_OF_TREATY:FromTRS00.GROUP_CATEGORY:FromTRS00.GROUP_CAT_VALUE:FromTRS00.BUSINESS_TYPE:FromTRS00.FAS_CLASSIFICATION:FromTRS00.RI_CHARACTER:FromTRS00.SYMBOLISATION:FromTRS00.CEDENT:
FromTRS00.CEDENT_GROUP:FromTRS00.CEDENT_COUNTRY:FromTRS00.COMPANY_CODE:FromTRS00.PARTNER_INVOLVED:FromTRS00.AREA:FromTRS00.LEGAL_PARTNER:FromTRS00.PL_SEG:FromTRS00.MGF_FLAG)
...you see - there are two differnt ora-tables: FromTRS00 and FromTRS00_i
...when i write 'A' and 'B' to a flat file i only got the delimiter in the flat file ??
i created two stage variables 'A' and 'B'
A =
CRC32(FromTRS00_i.ACC_YEAR:FromTRS00_i.FINANCIAL_YEAR:FromTRS00_i.TREATY:FromTRS00_i.TREATY_SECTION:FromTRS00_i.PERIOD_START_DATE:FromTRS00_i.PERIOD_END_DATE:FromTRS00_i.RESP_DEPARTMENT:FromTRS00_i.RESP_DIVISION:FromTRS00_i.RESP_RESSORT:FromTRS00_i.LINE_OF_BUSINESS:FromTRS00_i.LOB_HIERARCHY_1:FromTRS00_i.LOB_HIERARCHY_2:FromTRS00_i.CLASS_OF_BUSINESS:FromTRS00_i.LIFE_OR_NON_LIFE:FromTRS00_i.PLANNING_SEGMENT:FromTRS00_i.TREATY_CATEGORY:FromTRS00_i.NATURE_OF_TREATY:FromTRS00_i.GROUP_CATEGORY:FromTRS00_i.GROUP_CAT_VALUE:FromTRS00_i.BUSINESS_TYPE:FromTRS00_i.FAS_CLASSIFICATION:FromTRS00_i.RI_CHARACTER:FromTRS00_i.SYMBOLISATION:FromTRS00_i.CEDENT:
FromTRS00_i.CEDENT_GROUP:FromTRS00_i.CEDENT_COUNTRY:FromTRS00_i.COMPANY_CODE:FromTRS00_i.PARTNER_INVOLVED:FromTRS00_i.AREA:FromTRS00_i.LEGAL_PARTNER:FromTRS00_i.PL_SEG:FromTRS00_i.MGF_FLAG)
and B =
CRC32(FromTRS00.ACC_YEAR:FromTRS00.FINANCIAL_YEAR:FromTRS00.TREATY:FromTRS00.TREATY_SECTION:FromTRS00.PERIOD_START_DATE:FromTRS00.PERIOD_END_DATE:FromTRS00.RESP_DEPARTMENT:FromTRS00.RESP_DIVISION:FromTRS00.RESP_RESSORT:FromTRS00.LINE_OF_BUSINESS:FromTRS00.LOB_HIERARCHY_1:FromTRS00.LOB_HIERARCHY_2:FromTRS00.CLASS_OF_BUSINESS:FromTRS00.LIFE_OR_NON_LIFE:FromTRS00.PLANNING_SEGMENT:FromTRS00.TREATY_CATEGORY:FromTRS00.NATURE_OF_TREATY:FromTRS00.GROUP_CATEGORY:FromTRS00.GROUP_CAT_VALUE:FromTRS00.BUSINESS_TYPE:FromTRS00.FAS_CLASSIFICATION:FromTRS00.RI_CHARACTER:FromTRS00.SYMBOLISATION:FromTRS00.CEDENT:
FromTRS00.CEDENT_GROUP:FromTRS00.CEDENT_COUNTRY:FromTRS00.COMPANY_CODE:FromTRS00.PARTNER_INVOLVED:FromTRS00.AREA:FromTRS00.LEGAL_PARTNER:FromTRS00.PL_SEG:FromTRS00.MGF_FLAG)
...you see - there are two differnt ora-tables: FromTRS00 and FromTRS00_i
...when i write 'A' and 'B' to a flat file i only got the delimiter in the flat file ??
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: