The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

SQL Anywhere Version 12.0.1.3994

I’m interested in using the dbo.sa_post_login_procedure in a client application using an ODBC connection. What process would I use to select the message_text and message_action? Of course I could select * from dbo.sa_post_login_procedure after a connection but that wouldn’t work if the procedure was modified with the SET OPTION PUBLIC.post_login_procedure command. I’m interested in this being portable across databases. If the answer is I have to first SELECT CONNECTION_PROPERTY ( XYZ ), I think that's to much work.

On another note I was reviewing the dbo.sa_post_login_procedure in this version and can’t see how it works with the clause where login_policy_name = 'default' since the default login_policy_name is ‘root’.

Finally, whats with this not being able to type in plain text

asked 05 Feb '15, 21:40

J%20Diaz's gravatar image

J Diaz
830243044
accept rate: 14%

by the way thanks in advance

(05 Feb '15, 21:41) J Diaz

Okay ... You can enquire the database option for that using the function db_property( 'post_login_procedure' ) and form the string 'call ' or 'select * from ' to pass to execute immediate.

The following works well enough in my QnD test in dbisql:

execute immediate with result set on string( 'select * from ', connection_property( 'post_login_procedure' ), '()' );

execute immediate with result set on string( 'call ', connection_property( 'post_login_procedure' ), '()' );

HTH

permanent link

answered 06 Feb '15, 11:33

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
6.2k2890
accept rate: 30%

Nick, thanks that will work.

Jim

(06 Feb '15, 14:15) J Diaz
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×12

question asked: 05 Feb '15, 21:40

question was seen: 675 times

last updated: 06 Feb '15, 14:15