topic Re: SBAL_DELETE program in Application Development and Automation Discussions

SBAL_DELETE program

Former Member — Tue, 29 Mar 2011 09:22:39 GMT

Hi experts,

Does the std pgm SBAL_DELETE delete logs from both BALHDR & BALDAT? Anyhow in the code i find only BALHDR.

Can someone give me some more idea on this pls?

I need to purge data from BALDAT too. In case SBAL_DELETE does not do this, then how can we go about this?

Thanks in advance.

Diana

Re: SBAL_DELETE program

AlexanderOv — Tue, 29 Mar 2011 09:40:40 GMT

See

Re: SBAL_DELETE program

Former Member — Tue, 29 Mar 2011 09:47:15 GMT

Hi Alexander,

I went through this already. But it didnt help.

Rgds,

Diana

Re: SBAL_DELETE program

AlexanderOv — Tue, 29 Mar 2011 10:43:06 GMT

Did you delete data from all clients?

Re: SBAL_DELETE program

Former Member — Tue, 29 Mar 2011 10:48:40 GMT

Hi Alexander,

I dont think so. This is currently running in Production. And only Production logs should have been deleted.

Rgds,

Diana

Re: SBAL_DELETE program

AlexanderOv — Tue, 29 Mar 2011 10:51:39 GMT

Anyhow in the code i find only BALHDR.

You can run this report in debug mode. There is form "delete_logs" which calls function "BAL_DB_DELETE". This function then calls "BAL_DB_INTERNAL_NO_UPDATE_TASK" where deleting is performed.

DELETE baldat CLIENT SPECIFIED FROM TABLE c_s_db_tables-baldat_d.

Re: SBAL_DELETE program

Former Member — Tue, 29 Mar 2011 11:03:11 GMT

Hi Alexander,

I will check this in debug. Thank you for your help.

Rgds,

Diana

Re: SBAL_DELETE program

former_member862163 — Fri, 12 Sep 2014 18:49:14 GMT

Hi Diana

Did you get the solution on deleting the entries from BALDAT?

Thanks