Hi Alex,
I made a first draft of the Babel SQL documentation for Worg. See
http://orgmode.org/worg/org-contrib/babel/languages/ob-doc-sql.html
Please edit or augment as you see fit.
I believe you need FSF papers to contribute to ob-sql.el. If you have
those, then by all means, please add
Hi Tom,
Thanks for the Worg documentation. I don't have the FSF papers yet, but I
will sign and send them soon.
It looks like the Babel SQL support would benefit from more modular
approach so that adding new engine would not require modifying existing
functions. Perhaps, something like the Emacs
I found an answer to my question. It turned out this behavior is described
in the documentation for org-babel-expand-noweb-references:
Note that any text preceding the foo construct on a line will be
interposed between the lines of the replacement text. So for example if
foo is placed behind a
I have R code which submits SQL statements to a database server. Since the
SQL is rather complex, I want to put it into a separate code block in order
to have proper formatting, syntax highlighting, etc:
#+name: long-sql
#+begin_src sql
select *
from many, tables
where
Aloha Alex,
My work flow in this situation evaluates the SQL to create an Org-mode
table, which serves as input to the R source code block.
For me, seeing the SQL output in a table is a sanity check.
hth,
Tom
Alexander Vorobiev alexander.vorob...@gmail.com writes:
I have R code which submits
Hi Tom,
Unfortunately I can't have pure SQL output in my org files for two reasons:
1. The result set I am dealing with for this particular problem is about
2 records
2. My SQL server (Netezza, big data appliance) is not supported by
Babel-SQL. I configured sql-mode to work with Netezza but