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.

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
accept rate: 20%

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
accept rate: 43%

You folks need a Marketing Department, you really do!

Congratulations to Anil!

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

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

...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



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: 25 Jun '12, 05:35

question was seen: 2,052 times

last updated: 25 Jun '12, 11:33

Related questions