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
1.2k384667
accept rate: 10%

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...
7.3k35107
accept rate: 32%

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:

×15

question asked: 05 Feb '15, 21:40

question was seen: 2,326 times

last updated: 06 Feb '15, 14:15