Below shows the script written in Catch Block(CAPTCH_EXCEPTION), that used to captured and handled exception, by sending out mail notification to support team.
Below image showed that batch job in row 1, with status = Success, in case, exception...
Requirement:
Two or more data_flow need to be executed in parallel.
When ALL these data_flow are executed completely (either success or failed), then execute next data_flow.
Can it be done?
Below is illustration.
Requirement:
Extract data from source_table, then insert data into target_table if data not exist and update data in target_data if data exist.
Assume that source_table and target_table are in same datastore.
Solution 1: Using data_flow with...
How to get current date time in UTC+0, by simply any BODS function?
Found that there is BODS function "local_to_utc", but it is not used, as local time zone, or job server time zone is unknown in my scenario.
Date time should not be get from data...
Requirement:
If an order has 2 or more transactions, then return only row with last transaction date.
This can be done by using SQL as below. Table st1, and st2 are same table.
But how to achieve this via BODS Data_Flow design? SELECT *
FROM...
Additional statement as below, is added to script "HANDLE_EXCEPTION" inside block "CAPTCH_EXCEPTION", to rethrow original exception.#Rethrow exceptionraise_exception(error_message());
Below is further finding on how to use work_flow to acheive parallel + sequential process.A few work_flow may be required, depending on requirement.Scenario 1: Single work_flow is enough to achieve below requirementScenario 2: Nested work_flow are re...
For example, both Job_1 and Job_2 need to be executed in parallel. When both jobs are complete executed, then Job_3 can be executed. If either Job_1 or Job_2 is not yet complete executed, then Job_3 should not be executed.
Hi! Shazin..Thanks for detail explanation.Some of my requirement cannot be done via DS mapping. Example as below.https://answers.sap.com/questions/681893/bods-how-to-load-data-row-by-row-in-sequence-with.htmlBut, may be I am wrong. Do u have any idea...
