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

7 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