Search code examples
sqlteradata

I want to insert values for 3 columns in a teradata view .But it gives errors Syntax looks correct but error is not related to syntax

INSERT INTO
sample_db.sample_table(CONFRM_CD_VAL_TXT,CONFRM_CDSET_NM,SRC_CD_VAL_TXT,CHNL_SRC_CD)
values ("CAD","CLM_MEDIA_TY_CD","CAD","ESI" );

Here I get a error as

Column CAD not found in sample_db.sample_table. Elapsed time = 00:00:00.032

Solution

  • Replace double quotes "" (refers to columns) with single quotes '' (refers to strings).

    INSERT INTO
sample_db.sample_table(CONFRM_CD_VAL_TXT,CONFRM_CDSET_NM,SRC_CD_VAL_TXT,CHNL_SRC_CD)
values ('CAD','CLM_MEDIA_TY_CD','CAD','ESI');