Where do we write stored procedures in Pega.. is it only connect-SQL rule ??
Stored procedures in Pega
We shouldn't write Stored procedure (SP) in Connect-SQL, rather we just invoke SP from Connect-SQL. It's recommended to have the procedure written at DB end since any application connecting to the database can invoke it.