bods 4.2 sql syntax error

[Former Member]

hello. i am busy with clearing tables in DS 4.2. I used the TRANCATE TABLE/trancate_table. but whenever i run the job i get a syntax error. Please assist

[former_member220897 · Accepted solution]

You don't need a data flow for that, use a Script

[abdel_dadouche]

Hi,

I think you should change your primary tag to SAP BusinessObjects Business Intelligence platform instead of SAP CodeJam. This will make your question visible to the right audience.

SAP CodeJam is a 5 to 6 hour hands-on coding and networking event where attendees share their knowledge and collaboratively develop with SAP technologies, platforms, and tools in a fun and casual environment.

Thanks

@bdel

[denis_konovalov]

Hello Abdel - actually the tag should be SAP BusinessObjects Data Services or maybe even EPM.