Pro*C Experience | Dataford Interview Questions

Tell me about your experience with Pro*C.

For this hands-on SQL exercise, demonstrate the data-reporting aspect by writing a PostgreSQL query over the supplied Pro*C batch and error-log tables. Include eligible batches even when they have no matching errors.

Output

One row per eligible batch, excluding batches before 2025-01-01, cancelled batches, and batches with a null status.
Columns: batch_id, run_date, program_name, status, error_count, critical_error_count, rejected_rows.
Order by run_date ascending, then batch_id ascending.

Schema

proc_batches

Column	Type	Description
batch_idPK	INT	Identifier for the Pro*C batch execution
run_date	DATE	Date on which the batch ran
program_name	VARCHAR(100)	Name of the Pro*C executable
status	VARCHAR(20)	Execution status

proc_errors

Column	Type	Description
error_idPK	INT	Identifier for the logged error
batch_id	INT	Batch associated with the error
severity	VARCHAR(20)	Error severity
error_code	VARCHAR(30)	Application or database error code
rejected_rows	INT	Number of rows rejected by the error

Your question is Pro*C Experience. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem