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
Subscribe to:
Post Comments (Atom)
Great and Useful Article.
ReplyDeleteJava Online Training
Java Course Online
Java EE course
Java Course in Chennai
Java Training in Chennai
Java Training Institutes in Chennai
Java Interview Questions
Java Interview Questions
this articel is very nice,it is very useful to me and our company, ithubonlinetraining
ReplyDeleteشركة نقل عفش بينبع
ReplyDeleteنقل العفش والتخزين
شركة نقل عفش بالمدينة المنورة
ReplyDeleteIf 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
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
ReplyDeletePackers 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
ReplyDeleteVery Good way of attracting your reader's attention is to write blog like you. Please do contact me on guwahaticallgirl@gmail.com for
ReplyDeleteGuwahati Call Girls
Guwahati Call Girls
Guwahati Call Girls
Guwahati Call Girls