- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Where clause in QvSAPDSOConnector
Hi:
I'm trying to read a DSO from SAP.
TABLE:
Load *;
SQL Select (NoKey) * from TABLE;
It works fine. When I try to slice it by date it shows error. Any suggestion? I need to slice these DSOs, they are huge.
TABLE:
Load *;
SQL Select (NoKey) * from TABLE
where OERDAT= '04/04/2013';
- Tags:
- connectors
- sap
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Possibly OERDAT data format is not similar to the one you are hard coding. Please check the format in the source and retry with similar format filter in WHERE clause.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you tresesco. I've just tried 04042013. They are telling me that the format is 20130404 in thi SAP place. I've just tried too. I get the same error.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Then try like :
where OERDAT= '20130404';
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That's what I just did. With and without quotes.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Christian,
You can try:
where OERDAT = '04/04/2013'; OR
where OERDAT = '20130404';
What different above is "give one space" after field "OERDAT"
Regards,
Sokkorn
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi. Thank you for your interest.
The right sintax for this kind of loading appears in the SAP Connector Manual 5.80 pages 41 and 42.
That manual comes with the connector itself.
Tahks again all of you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content