Can we capture AUDIT variables in BODS into Global variables?(Without querying on Repository tables as i dont have acccess to that) or somehow capture them and write in into a Table? I am using BODS 4.2 Version.
I tried sql function in the Rule section to insert into a table as shown below
sql('TGT_AUDIT', 'INSERT INTO Table_Name VALUES (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,[$Count_FF_MFG_STG_CDD52_CONSTRUCT_MAIN],[$Count_MFG_STG_CDD52_CONSTRUCT_MAIN])') IS NULL
Got the below error when validated:
Invalid audit rule: <
>. Additional information: <Syntax error at line <2>: <>: found <[end of text]> expecting <CREATE>.
1 error(s), 0 warning(s).
Check and fix the syntax and retry the operation. (BODI-1112394)>. (BODI-1112508)
Please help me.