 |
 |
Archives of the TeradataForum
Message Posted: Mon, 02 Jul 2012 @ 12:19:40 GMT
| Subj: | | Re: Script stops after OREPLACE function |
| |
| From: | | GRAHAM, Paul |
Hi Asif
The UDF is the OREPLACE function, in this instance used to remove spaces from a field. The issue happens every time I run the code. I'm not
sure how to check if there is a blocker. The version of Teradata assistant I'm on is 12, here's the table structure
CREATE SET TABLE DATABASE1.TABLE1 ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
DEFAULT MERGEBLOCKRATIO
(
LEAD_ID VARCHAR(12) CHARACTER SET LATIN NOT CASESPECIFIC,
SALES_JOURNEY VARCHAR(12) CHARACTER SET LATIN NOT CASESPECIFIC,
ORIG_SALES_JOURNEY VARCHAR(9) CHARACTER SET LATIN NOT CASESPECIFIC,
MARKETING_CHANNEL VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,
CORE_CAMPAIGN_CODE VARCHAR(12) CHARACTER SET LATIN NOT CASESPECIFIC,
CAMPAIGN_TITLE VARCHAR(70) CHARACTER SET LATIN NOT CASESPECIFIC,
CAMPAIGN_DESCR VARCHAR(254) CHARACTER SET LATIN NOT CASESPECIFIC,
LEAD_DATE DATE FORMAT 'YY/MM/DD',
LEAD_TIMESTAMP TIMESTAMP(0),
LEAD_STATUS VARCHAR(2000) CHARACTER SET LATIN NOT CASESPECIFIC,
UNCONVERTED_REASON VARCHAR(2000) CHARACTER SET LATIN NOT CASESPECIFIC,
CONTACT_ID VARCHAR(12) CHARACTER SET LATIN NOT CASESPECIFIC,
ACCOUNT_TYPE VARCHAR(2000) CHARACTER SET LATIN NOT CASESPECIFIC,
ACCOUNT_NAME VARCHAR(70) CHARACTER SET LATIN NOT CASESPECIFIC,
CONTACT_TITLE VARCHAR(2000) CHARACTER SET LATIN NOT CASESPECIFIC,
CONTACT_FIRST_NAME VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
CONTACT_SURNAME VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
CONTACT_DOB DATE FORMAT 'YY/MM/DD',
CONTACT_TEL_NO VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
CONTACT_EVE_TEL_NO VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
CONTACT_MOBILE_NO VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
CONTACT_EMAIL VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,
CONTACT_FAX_NO VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
CONTACT_STATUS VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
CONTACT_ADDRESS_1 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,
CONTACT_ADDRESS_2 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,
CONTACT_ADDRESS_3 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,
CONTACT_ADDRESS_4 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,
CONTACT_POSTCODE VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC,
OCCUPATION VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,
DECISION_DATE DATE FORMAT 'YY/MM/DD',
NO_OF_COMM_REGS INTEGER,
NET_COMM_SUBS FLOAT,
LAST_UPDATED DATE FORMAT 'YY/MM/DD',
LEAD_DATE_MTH_YR_NAME VARCHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC,
LEAD_DATE_MTH_YR_NUM INTEGER,
LEAD_DATE_WEEK_NUM INTEGER,
LEAD_DATE_MONTH_NUM INTEGER,
LEAD_DATE_MONTH_NAME VARCHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC,
LEAD_DATE_YEAR_NUM INTEGER,
DEC_DATE_MTH_YR_NAME VARCHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC,
DEC_DATE_MTH_YR_NUM INTEGER,
DEC_DATE_WEEK_NUM INTEGER,
DEC_DATE_MONTH_NUM INTEGER,
DEC_DATE_MONTH_NAME VARCHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC,
DEC_DATE_YEAR_NUM INTEGER,
POINT_CAMP_ID VARCHAR(12) CHARACTER SET LATIN NOT CASESPECIFIC,
SWIFT_CAMP_ID DECIMAL(10,0),
CAMPAIGN_SOURCE VARCHAR(2000) CHARACTER SET LATIN NOT CASESPECIFIC,
CAMPAIGN_MKTG_CHANNEL VARCHAR(80) CHARACTER SET LATIN NOT CASESPECIFIC,
CAMPAIGN_SUB_MKTG_CHANNEL VARCHAR(80) CHARACTER SET LATIN NOT CASESPECIFIC,
CAMP_START_DATE DATE FORMAT 'YY/MM/DD',
CAMP_END_DATE DATE FORMAT 'YY/MM/DD',
AFFINITY_CONTACT VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
CAMP_START_MTH_YR_NAME VARCHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC,
CAMP_START_MTH_YR_NUM INTEGER,
CAMP_START_WEEK_NUM INTEGER,
CAMP_START_MONTH_NUM INTEGER,
CAMP_START_MONTH_NAME VARCHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC,
CAMP_START_YEAR_NUM INTEGER,
MKT_REP_PAID_CAT VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,
MKT_REP_SECTOR VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,
MKT_REP_CHANNEL VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,
MKT_REP_CATEGORY VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC,
GROUP_CREATED_BY VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
LEAD_TYPE VARCHAR(2000) CHARACTER SET LATIN NOT CASESPECIFIC,
LEAD_SOURCE VARCHAR(2000) CHARACTER SET LATIN NOT CASESPECIFIC,
LEAD_PRODUCT VARCHAR(2000) CHARACTER SET LATIN NOT CASESPECIFIC,
SOURCE_MEDIUM VARCHAR(2000) CHARACTER SET LATIN NOT CASESPECIFIC,
CREATED_BY VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
ADVISORS_MANAGER VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
CREATING_SCRIPT_DESCRIPTION VARCHAR(2000) CHARACTER SET LATIN NOT CASESPECIFIC,
CURRENT_LEAD_OFFICE VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
CLO_GROUP VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
LEAD_IND VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
PERSON_LEAD_NO INTEGER,
LINKED_LEAD_NO INTEGER,
QUOTE_DATE DATE FORMAT 'YY/MM/DD',
BROKERED_FLAG VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
TPS_CONTACT_TEL_NO VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
TPS_CONTACT_MOBILE_NO VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
TPS_CONTACT_EVE_TEL_NO VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
Primary_Tel VARCHAR(15) CHARACTER SET LATIN NOT CASESPECIFIC,
PERSON_PARTY_ID INTEGER,
FEILD1 VARCHAR(200) CHARACTER SET LATIN NOT CASESPECIFIC,
MATCHKEY_3A VARCHAR(200) CHARACTER SET LATIN NOT CASESPECIFIC,
DECEASED_FLAG VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
DO_NOT_CONTACT_FLAG VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
LINKED_CONVERTED_LEAD VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
CONVERSATION_ID DECIMAL(9,0),
MKT_SPEND_CATEGORY VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC)
PRIMARY INDEX ( LEAD_ID );
| |
