Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

I have an outdated version of SQL Anywhere that runs only on Windows XP. I would like to purchase a new version with a registration key that supports procedural static SQL views (in the schema). I have written several C apps that make use of SQL Anywhere's procedural views that I run now under Windows 7's XP virtual machine emulator. I would like to run them directly on Windows 7 and eventually on Windows 10.

asked 26 Nov '19, 16:31

malletKATman's gravatar image

accept rate: 0%

FWIW, you may check the free SQL Anywhere 17 Developer Edition first to see what might need to be changed in your application and/or database.

Here's a donwload link...

(27 Nov '19, 06:43) Volker Barth
Comment Text Removed

> I have an outdated version of SQL Anywhere that runs only on Windows XP.

What does SELECT @@VERSION display?

SELECT @@version

FWIW I regularly test with SQL Anywhere 6 through 17 on Windows 10.

...Version 5.5 is another story, but the V6 engine can run a 5.5 file on Windows 10. Here's what Foxhound says when you do that:

Software: 6.0.4 (3594) 
DB File:  5.5.5

My point is this, if you are having problems running V6 or higher software on Windows 10, maybe it isn't a SQL Anywhere problem... tell us what the exact symptom is.

(27 Nov '19, 09:57) Breck Carter

SELECT @@VERSION yields "5.5.04 Build #1880"

The exact problem is that DBENG50.EXE won't run on any operating system above Windows XP which is why I run it under the XP Virtual Machine on Windows 7 PRO. Your comment that V6 can run a 5.5-created DB under all Windows from 7-10 is encouraging, but I have to know that for V17 - what I can buy now. I also posted a question here about whether V17 still supports procedural Views defined in the schema and I uploaded an example of one of the, I use. I have not received an answer to that yet.

I need to know that because that is the reason to remain with SQL Anywhere. My C++ apps connect and manipulate databases through the ODBC interface so I could actually use almost any RDBMS engine, but then I would have to recode the procedural aspects of reading through my procedural views that I simply rely upon the SQL Anywhere SQL engine to to do for me now.

(27 Nov '19, 15:11) malletKATman
Replies hidden

Your comment that V6 can run a 5.5-created DB under all Windows from 7-10 is encouraging, but I have to know that for V17

The last SQL Anywhere version that can run a v5.5 database is v9. V10 introduced a new file format, so pre-v10 databases have to be rebuilt for v10 and above. In other words: v17 cannot run a 5.5 database, it has to be rebuilt first.

(27 Nov '19, 15:46) Volker Barth

What do you mean by "procedural views"?

(27 Nov '19, 15:49) Volker Barth

FWIW, even on the ancient v5.5 product line, build is a rather old one. IIRC, the last build on v5.5 was or the like...

(27 Nov '19, 15:53) Volker Barth

There are If, else, endif conditional executions in a Procedural View. I uploaded an example of a complex Procedural View in a PDF file which seems to have disappeared into a black hole. Here's a simple one.

CREATE VIEW "dba".accnts_payees_view ( account_code, payee_key, payee ) AS SELECT accnts_payees_join.account_code, payee_key, IF accnts_payees_join.payee_key=0 THEN accnts_payees_join.text ELSE bnk_payees.payee ENDIF FROM "dba".accnts_payees_join LEFT OUTER JOIN "dba".bnk_payees ON accnts_payees_join.payee_key=bnk_payees.primary_key go

The create view.pdf file I uploaded to somewhere has a much more complex example. I was logged in as malletKATman at the time I uploaded it in the process of creating this thread. So, can anyone instruct me how I can upload it again so it will show here?

BTW: what is this "Don't forget to vote" business all about that appears in every email I get when someone posts to this thread?

(27 Nov '19, 18:03) malletKATman

Ah, this is simply an IF expression within your query - yes, this is of course still valid syntax in all newer versions of SQL Anywhere, just like the similar CASE expression.

AFAIK, almost all v5.5 queries should run with v17, unless they make use of rare and now obsolete stuff like Transact-SQL star joins or some "sluggish" expressions that newer parsers reject.

But you will also get a wealth of new possibilities for your queries and views, for example

  • common table expressions (aka "local views")
  • window functions / OLAP
  • using result sets of procedures in the FROM clause, often used with CROSS/OUTER APPLY operators
  • using OpenString/OpenXML in the FROM clause to query data not stored in tables
  • regular expressions
  • pivot operators

and much more.

(28 Nov '19, 01:21) Volker Barth

FWIW, this forum supports different kind of postings: Questions, answers and (possibly nested) comments. I turned your last answers into comments as they were no actual answers but responses to other comments.

  • To add a comment to a question/answer, please use the "add new comment" button below the question/answer.
  • To add a (then nested) comment to a comment, use the "reply" button immediately below the comment...
(28 Nov '19, 04:38) Volker Barth

> The create view.pdf file I uploaded

As far as I know, this forum no longer supports uploads of any files at all, not even images. I say "as far as I know" because I gave up trying a long time ago. I think it has to do with security.

You can, however, post links to images and text files stored on other websites:

This is a link to a text file.

Here is the raw HTML that you can type into your postings here...

   <a href="">This is a link to a text file.</a>

If the SQL is shorter than a few thousand characters, you can just post it inside a pair of PRE tags, right inside your message.

(28 Nov '19, 08:31) Breck Carter

> what is this "Don't forget to vote" business

Sadly, this forum uses one of those "social credit points systems", sometimes called "reputation systems" or "gamification", based on the goofy theory called "the wisdom of crowds".

In other words, until you get some points, there are limits on what you can do... see the FAQ for the rules.

FYI, here's the code that was used to include that image:

<img src="" width="200">

(28 Nov '19, 08:43) Breck Carter
showing 3 of 11 show all flat view

You should be able to purpose on the SAP Store.

permanent link

answered 26 Nov '19, 21:51

Chris%20Keating's gravatar image

Chris Keating
accept rate: 32%

I cannot find the posting where I asked the procedural views question and uploaded an example file in this thread. I don't know why that is because it was there last night. I also cannot find any way re upload the example file again in this thread. How do I upload a PDF file now?

permanent link

answered 27 Nov '19, 15:22

malletKATman's gravatar image

accept rate: 0%

Comment Text Removed
Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 26 Nov '19, 16:31

question was seen: 2,247 times

last updated: 16 Dec '19, 02:48