on 2010 Dec 21 5:48 PM
Hi guys!
I´m novice with Data Services. I have one question very simple.
I have a Query mapping with a SAP table and a flat file with information to do a WHERE clausule with the table. If my query does´t has any results, how can i do an error in log to abort the JOB?
For example:
Error 1001: The Query doesn´t find the variable BURKS.
Thanks!!
Edited by: Albertoe on Dec 21, 2010 6:48 PM
The raise_exception() function should do what you want. See details in theTechnical Manuals, DS Reference Guide, Functions and Procedures.
Paul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This example checks the BUKRS field. If the field is not empty then value is carried forward and the job continues to run. If the field is empty then an exception is raised and the job is terminated.
ifthenelse(length(BUKRS) > 0,
BUKRS,
raise_exception('The BUKRS field is empty.',
)
The message defined in the function will be written to the log file.
Paul
User | Count |
---|---|
75 | |
10 | |
9 | |
7 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.