.logoff .quit EOF The error I am getting *** Warning: No IMPORT mode was given, assuming field mode. *** Growing buffer to 65473 *** Failure 2673 The source parcel length does not match data that was defined. Statement# 1, Info =6
Re: Failure 2673 The source parcel length does not match data that was defined.
While using BTEQ IMPORT I am getting the following error. I know that this is due to a data item not matching the definition, i.e. definition set to VARCHAR(5) and data item being 6 charaters.
What I would like to know is how to halt the code and exit with an error code. The objective being to stop the code from processing any more records as soon as an error code occurs. At the momment it carries on to process all the records: -
.SET ERROROUT STDOUT .SET QUIET ON
DROP TABLE BUSINESS_SECTOR_TEAMS;
CREATE TABLE BUSINESS_SECTOR_TEAMS ( REGION INTEGER COMPRESS ,TEAM VARCHAR(60) ,TEAM_ABR VARCHAR(6) ,TEAM_ID INTEGER NOT NULL ,GROUP_ID INTEGER COMPRESS ,GROUP_NAME VARCHAR(50) ) UNIQUE PRIMARY INDEX (TEAM_ID);