Friday, November 6, 2015

syntax error: unterminated quoted string literal


I have encountered below “sql syntax error” during data import into HANA Dynamic Tiering

* 257: sql syntax error: unterminated quoted string literal: line 1 col 13 (at pos 13) SQLSTATE: HY000
Here are the possible reasons for this error

1. You will see this error when data file name is wrong in the control file

2. The “quote” is not closed properly in the IMPORT command.

For ex:-
HANA=>IMPORT FROM '/hana/shared/DT/HDB00/work/employee.txt.ctl
As you see quote is not ended properly in above command

3. when data file is empty

Regards,
Satishbabu Gunukula, Oracle ACE

3 comments:

  1. this articel is very nice,it is very useful to me and our company, ithubonlinetraining

    ReplyDelete
  2. Punjab School Education Board (PSEB) is Going to Conduct 10th Class Final Exam Start Tuesday, 17 March 2023 End of Exam Wednesday, 8 April 2023, PSEB is a School Board Based in Chandigarh, India. PSEB 10th Model Test Paper 2023 Under a Legislative act of the Government of Punjab to Administer the Curriculum Taught in Public Schools in the Punjab state and conduct Standardized Examinations in Addition to Conducting Administration of Scholarships, and Publishing of Textbook 2023s. PSEB is a Board of Education for Public and Private Schools under the State Government of Punjab, PSEB Board Matriculation Annual Examination Starting Month of March 2023 , Punjab 10th Model Question Paper 2023 is likely to be announced in Every Year official Website.

    ReplyDelete