Stored procedures in Pega - OSP Pega Forum

Technical Database
Stored procedures in Pega

SSrinivas_T
Nov '20
Post #1 Friday, November 20, 2020 3:44 AM

Where do we write stored procedures in Pega.. is it only connect-SQL rule ??

Karthick
Nov '20
Post #2 Sunday, November 22, 2020 5:15 AM

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.

Write a Reply...

Stored procedures in Pega

Srinivas_T

Where do we write stored procedures in Pega.. is it only connect-SQL rule ??

Karthick

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.

-An Initiative Of OneStopPega- Love our work? Support Us🖤