topic Re: EXEC SQL and ENDEXEC issues in Application Development and Automation Discussions

EXEC SQL and ENDEXEC issues

Former Member — Mon, 15 Mar 2010 11:20:38 GMT

Hi ALL,

I want ot delete an internal table entries within EXEC SQL and ENDEXEC.

We are tryinign to delete Open Hub Table data records from OH table.

Can you please suggest me the command.

Right now I am using

EXEC SQL.

loop at it_ohtab into wa_ohtab.

Truncate table wa_ohtab-onj_name

endloop.

ENDEXEC.

The above statement is throwing dump saying "The error 102 occurred in the current database connection "DEFAULT"".

Regards,

SD.

Re: EXEC SQL and ENDEXEC issues

Former Member — Mon, 15 Mar 2010 11:35:54 GMT

Hi,

I think you have to bring the loop and end loop outside of EXEC and END EXEC.

Hope it helps.

Thanks

Mani

Re: EXEC SQL and ENDEXEC issues

Former Member — Mon, 15 Mar 2010 11:38:36 GMT

I want ot delete an internal table entries within EXEC SQL and ENDEXEC.

Why? Internal tables are not controlled with SQL, but with Open SQL statements, like loop...endloop. case or if..then...else and Delete...

Re: EXEC SQL and ENDEXEC issues

Former Member — Mon, 15 Mar 2010 11:42:51 GMT

Hi,

I think what SD wants to conver here is that the table names are in the entries of the internal table and wants to delete the tables not the internal table perse.

Thanks

Mani

Re: EXEC SQL and ENDEXEC issues

AlexanderOv — Mon, 15 Mar 2010 11:47:07 GMT

Hi,

try this code

 
DATA: F1 TYPE TABNAME16.

loop at it_ohtab into wa_ohtab.
  F1 = wa_ohtab-onj_name.

  EXEC SQL.
  TRUNCATE TABLE :F1
  ENDEXEC.

endloop.

Re: EXEC SQL and ENDEXEC issues

Former Member — Mon, 15 Mar 2010 11:49:11 GMT

Hi Mani,

i have tried using the loop-endloop before EXEC-ENDEXEC. but it still throwing a dump.

The SQL command TRAUNCATE/DELETE can work on internal table or work area defined by us.

Also, You were right I am collecteing all the table names in Intertable and Deleting table entries of those tables present in Internal table.

Re: EXEC SQL and ENDEXEC issues

AlexanderOv — Mon, 15 Mar 2010 11:57:24 GMT

Also, you might clear contents of the tables with this Open SQL code:

 
loop at it_ohtab into wa_ohtab.

  DELETE FROM (wa_ohtab-onj_name).

endloop.

Edited by: Alexander Ovcharenko on Mar 15, 2010 12:57 PM

Re: EXEC SQL and ENDEXEC issues

Former Member — Mon, 15 Mar 2010 11:57:44 GMT

ITS still throwing the same dump. after using your piece of code

Re: EXEC SQL and ENDEXEC issues

AlexanderOv — Mon, 15 Mar 2010 12:06:56 GMT

Can you post here the error from "Database error text" field of dump?

Re: EXEC SQL and ENDEXEC issues

Former Member — Mon, 15 Mar 2010 12:27:24 GMT

The error 102 occurred in the current database connection "DEFAULT"".

Re: EXEC SQL and ENDEXEC issues

AlexanderOv — Mon, 15 Mar 2010 12:37:02 GMT

It's not a "Database error text" field of dump. You can see this error text in ST22 - Select your dump - Press <F9> - Scroll down - Post here lines which begins from "DB = ". These lines are in the end of list.

Re: EXEC SQL and ENDEXEC issues

ThomasZloch — Mon, 15 Mar 2010 12:43:52 GMT

why use native SQL, (carefully) try the function modules in group SDB2, e.g. DB_TRUNCATE_TABLE.

And please do not cross-post, I asked for deletion of the duplicate in "BI General".

Thomas

Re: EXEC SQL and ENDEXEC issues

Former Member — Fri, 30 Nov 2012 06:45:00 GMT

I have the same question today, and I solved it by myself afer I read the page.I used sm21 and I found the error message:Incorrect syntax near '.'. So I know that I write a comma at the end of the sql. I deleted it, it is ok now. Maybe help you!