BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

invalid SQL in data viewer


 
Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
wil992
Forum Member
Forum Member



Joined: 22 Jun 2011

Posts: 26



PostPosted: Wed Jul 17, 2019 4:46 am 
Post subject: invalid SQL in data viewer

hi,

I have a datastore pointing at a hana 2.x database.

in it, I have template tables.

I can view the data in those tables using data viewer in designer, and jobs are all running without a problem.

However, if I add a filter to the data when viewing it, I get an error, "...syntax error, incorrect syntax near 'where': line1..."

when I look at the sql that has been generated it looks like this:

Select where column 1 ='x'
column 1,
column 2
from mytable
where column 1 = 'x'.

Why is the first "where" appearing? Anyone else seen this?

Thanks.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0263 seconds using 18 queries. (SQL 0.0028 Parse 0.0008 Other 0.0226)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo