How to create " Functions" & "Procedures" section in custom Database

If you want to build database functions and stored procedures, that is completely external to Appian.  Find some tutorials online and places like stackexchange are a great resource for specific questions.  But I don't see how you need to jump directly heavy database programming so soon after just creating your custom DB.

Or are you referring to the "business data source", configuring it to hold your data and working within Appian?

You mention "created a DB for our app", do you mean DB tables?  As you certainly do not need an entire database for each application..

We will need some more details here on what you are doing to assist further.

If you want to build database functions and stored procedures, that is completely external to Appian.  Find some tutorials online and places like stackexchange are a great resource for specific questions.  But I don't see how you need to jump directly heavy database programming so soon after just creating your custom DB.

Or are you referring to the "business data source", configuring it to hold your data and working within Appian?

You mention "created a DB for our app", do you mean DB tables?  As you certainly do not need an entire database for each application..

We will need some more details here on what you are doing to assist further.

Hi Chris,

We have created something like this 

https://docs.appian.com/suite/help/22.3/appian-cloud-database-administration.html#appianprocessviewroutinedefinition

So my ques was how to create " Functions" & "Procedures" section in custom Database or I mean to say under custom schema like "Inventory App"

Click on your Custom Database, on right side you would be seeing SQL tab, click on it and run your Functions