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

Satishbabu Gunukula, Oracle ACE


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


  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

  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

  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

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

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

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