Friday, February 22, 2013

SQL CODE:-010 SQLSTATE:42603



Definition: THE STRING CONSTANT BEGINNING string IS NOT TERMINATED

Description: The statement contains a string constant, beginning with 'string', that is not terminated properly. There must be some problem with quotations used for strings.

System Says: The statement cannot be processed

Remedy: Check the statement for any strings with proper quotes. It should be like ‘STRING’.

3 comments:

  1. ALTER table NEWSDATA.PR_HZ_CLAIMS_NAV_DATA_DirectorSkill ADD DIRECTORID DATA TYPE Integer

    ReplyDelete
  2. While executing getting error SQLSTATE=42601

    ReplyDelete
  3. this is correct one, - ALTER table NEWSDATA.PR_HZ_CLAIMS_NAV_DATA_DirectorSkill ADD DIRECTORID Integer

    ReplyDelete