Book a Demo

Author Topic: Stored Procedures  (Read 5475 times)

JimHinson

  • EA Novice
  • *
  • Posts: 11
  • Karma: +0/-0
    • View Profile
Stored Procedures
« on: March 10, 2005, 07:07:45 am »
What is the best way to represent Stored Procedures in EA?  Does it provide any support for pseudo code or algorithms the stored procedure would implement?

Thanks!!

jdavid

  • EA User
  • **
  • Posts: 58
  • Karma: +0/-0
    • View Profile
Re: Stored Procedures
« Reply #1 on: March 11, 2005, 08:21:39 am »
We define our database's as an entity that is sterotyped as a database, then we add the stored procedures as operations with a return type = dataset.
This works well when you add the database to sequence diagrams since the sproces will show up as messages

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Stored Procedures
« Reply #2 on: March 14, 2005, 02:35:30 pm »
Stored Procedure support is on the way - either in the next major release 4.60 or shortly thereafter.

JimHinson

  • EA Novice
  • *
  • Posts: 11
  • Karma: +0/-0
    • View Profile
Re: Stored Procedures
« Reply #3 on: March 14, 2005, 04:57:44 pm »
Good to know.  I figured out how to create them currently (basically as attributes of a table), but that seems like a bit of a kludge since Stored Procs aren't related to a particular table.

Thanks!