Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved PowerBuilder sending DROP/CREATE command for the SP

  1. Misc
0
Votes
Undo
  1. Kamendra Singh
    Kamendra Singh
  2. PowerBuilder
  3. Monday, 11 March 2024 12:57 PM UTC

We are facing a weird issue. We have a stored procedure in SQL server that we use in multiple datawindows to retrieve the data based on different arguments. DBA found an issue through tracing that PowerBuilder was sending a DROP/CREATE command for that stored procedure. We haven't written any such code to create that stored proc on the fly, it is already there in the database. DBA got to know this because it was blocking some other process.

Resized window back to original size randomly
native pdf generating 100 blank pages instead of o...
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 11 March 2024 15:34 PM UTC
  2. PowerBuilder
  3. # 1

Hi Kamendra ;

  The PB runtime (PBVM) would never issue a Drop / Create DML command to any DBMS.

   I suspect that it's your PB App - maybe doing a Execute Immediate (var) command somewhere in the App's code.

   I would also recommend that you run an SQL trace on your PB App via the "SQLCA.DBMS = "TRACE XXX" setting.

HTH

Regards .. Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.