Catching Errors Early: SQL Query

Applies to BODS 3.2, 4+

As BODS users know, the validation features (toolbar) built into to BODS do not catch the errors caused by a missing database or table or an access rights fail in the script of an SQL query.

For this reason, when dealing with a job which takes multiple hours, and which contains a SQL query well into the flow of the job, the user would be wise to place SQL logic which mirrors the later logic by placing dummy code containing  a 'select top 10 * from {database}.{table}'.

The benefit of this is that the error will be detected early on in the job run.