Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Where did "OpenString" come from?

1

Lo these many years, based on nothing more than the prefix "Open", I have assumed that the OpenString function clause was based on some pre-existing feature in common use by some (unknown to me) portion of the computing community.

However, two possibilities now come to mind: first, that the "Open" in OpenString has nothing to do with any utopian philosophy but that it might as well have been called "UnloadString"; and second, that OpenString might be an invention of Watcom, er, iAnywhere Solutions, er, Sybase, er, SAP.

Is it possible?

asked 25 Jun '12, 05:35

Breck%20Carter's gravatar image

Breck Carter
32.5k●541●726●1050
accept rate: 20%

One Answer:
active answersoldest answersnewest answerspopular answers
2

As far as I know that is true - OPENSTRING is Anil's invention, I haven't seen anything like it with any other product.

permanent link

answered 25 Jun '12, 07:03

Glenn%20Paulley's gravatar image

Glenn Paulley
10.8k●5●77●106
accept rate: 43%

You folks need a Marketing Department, you really do!

Congratulations to Anil!

(25 Jun '12, 09:01) Breck Carter
Replies hidden
2

It was an excellent evolution of LOAD TABLE and, not surprisingly, they both share the same code. Many people needed the ability to massage the data coming from a LOAD TABLE so they would insert the data into a temporary table then massage the data in the temp table. That was wasteful and cumbersome. OpenString allowed it to happen in one step. The rewrite of the execution engine (many versions ago) made it much more feasible to do. LOAD TABLE is now very little other than an INSERT (with special properties and special logging) from OpenString.

(25 Jun '12, 09:27) John Smirnios
2

...and y'all got recognized, right? alt text

(25 Jun '12, 11:33) Breck Carter
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

learn more about Markdown

Question tags:

×1

question asked: 25 Jun '12, 05:35

question was seen: 2,020 times

last updated: 25 Jun '12, 11:33

Related questions