About reimer_pods

reimer_pods · Create procedure: bug or behavior change in 17.0.9.4793?

With the recently applied EBF Build 4793 we've encountered a problem when creating procedures in Watcom syntax, that use default values for parameters. Example create or replace procedure SetValues (in @arg1 integer, in @arg2 char(30) = null) begin ...

reimer_pods

Hi there, I know how to determine the number of licences (in this case "perseat" aka "Networked Seat (ST)"), that are registered for an installation, by using sa_eng_properties or property ('Licensecount'). But is there any kind of property where I ...

reimer_pods

During my first steps using OPENXML I've tried to figure out, how this version of the syntax (Syntax 2) could be used. OPENXML( { USING FILE | USING VALUE } xml-data , xpath [, flags [, namespaces ] ] ) WITH ( column-name column-type [ xpath ] [ , ....

reimer_pods

I'm having trouble signing in using an Open-ID from yahoo.com, which has worked for years. I'm getting Sorry, but your input is not a valid OpenId The following link on http://sqlanywhere-forum.sap.com/account/signin/ is broken: If you don't have an...

reimer_pods

The new Community interface seems pretty useless and counterintuitive to me. I don't see any benefit. And where has all the previous content gone?

reimer_pods

Your statement needs a proper FROM clause to be processed correctly: CREATE PROCEDURE sp_test( ) BEGIN UNLOAD SELECT * FROM employee TO 'C:\\test.txt'; END;

reimer_pods

SAP really doesn't make it easy to get information about SQL Anywhere. However, as stated here: SAP Store SQL Anywhere 17, High Availability is part of the Advanced Edition, but not included in the Edge Edition. AFAIK it's not possible to upgrade fr...

reimer_pods

For SQLA 17.0 Build 5923 (2019-09-26) there seems to be no readme file. Requesting the info on the download page only gives this message: SAP Note/KBA 2842083 is being created. The SAP Note/KBA you were trying to reach is currently being created and ...

reimer_pods

This has already been discussed here: How do I see dbisql Messages tab in SQL Anywhere 17?

reimer_pods

While you might view the source code using this SQL statement select proc_defn from sys.sysprocedure where proc_name = 'sa_table_page_usage' you won't get much information apart form the parameter declaration. System procedures call interal functi...

User Statistics

User Activity

Create procedure: bug or behavior change in 17.0.9.4793?

How can I get the number of seat licences that are in use (SA-16)

How to write OPENXML query with USING FILE

Why can't I login anymore with my Yahoo Open-ID

SAP SQL Anywhere Community

Re: How to export a select query result bulk data with out using out put to (or) unload commands?

Re: High Availability Option - SA17

Re: Readme short-cut page / Latest EBFs for v16 / v17

Re: Question about ISQL settings in SA 17.0.9

Re: source code for system procedures