while generating SQL queries in pega database it asks database user id and database password what does it mean is this operator id and password if yes after clicking generate SQL queries it shows no properties are selected
can anyone explain how to generate SQL queries in pega platform?
User Name and Password not required for Generate the SQL Code.
But you have to select the What are properties SQL Code required for you, those you have to enable the Check Box As given below, then chick Click On the Generate SQL Code.
and Also You can use Tracer, if you want. Just Enable the DB Query Check in Tracer.
Tracer–>Settings–> EVENT TYPES TO TRACE Then Enable the DB Query Check Box