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

11 comments:

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

    ReplyDelete


  2. If you want a babe from the house of Russian Escorts in Mahipalpurthere are a few things you should know well before making a booking. Firstly our agency here at your city. In simple words is a cut above the rest because of the highly professional services we provide to our clients. Check our other Services...
    Call Girls in Mahipalpur
    Call Girls in Aerocity
    Escorts Service in Aerocity
    Escorts in Mahipalpur
    Escorts in Aerocity
    Escorts Service in Mahipalpur

    ReplyDelete
  3. We Provide Local Packers And Movers Pune List for Get Best Price Quotes, Compare Charges, Save Money And Time, Top Household Shifting Services @ Packers And Movers Pune

    ReplyDelete
  4. Packers and Movers Bangalore - Reliable and Verified Household Shifting Service Providers Give Reasonable ###Packers and Movers Charges. Cheap and Best Office Relocation Compare Quotation for Assurance for Local and Domestic House Shifting and Get estimates today to save upto 20%, ***Read Customer Reviews - @ Packers And Movers Bangalore

    ReplyDelete
  5. Very Good way of attracting your reader's attention is to write blog like you. Please do contact me on guwahaticallgirl@gmail.com for
    Guwahati Call Girls
    Guwahati Call Girls
    Guwahati Call Girls
    Guwahati Call Girls

    ReplyDelete
  6. افضل واقوى الخدمات الخاصة بأعمال نقل العفش والاثاث بجدة يقدمها موقع خدماتي تحت مسمى افضل الشركات المتخصصة بتنفيذ اعمال نقل العفش بجدة المتميزة والمضمونة وتقدم خدماتها باحترافية عالية وتعتبر شركتنا من افضل واقوى وارخص شركات نقل عفش جده على قدر كبير من التميز والاحترافية وتعتمد على عمالة احترافية

    ReplyDelete
  7. What an interesting story! I'm glad I finally found what I was looking for 메리트카지노.

    ReplyDelete
  8. 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