CTAN Comprehensive TeX Archive Network

Directory support/SQLTeX

README.md

SQL v2.1

SQL is a preprocessor to enable the use of SQL statements in . It is a perl script that reads an input file containing the SQL commands, and writes a file that can be processed with your package.

The SQL commands will be replaced by their values. It's possible to select a single field for substitution substitution in your document, or to be used as input in another SQL command.

When an SQL command returns multiple fields and or rows, the values can only be used for substitution in the document.

Installing SQL

Linux

On a linux system, download the archive and unpack:

$ tar vxzf sqltex-2.1.tar.gz
$ cd sqltex-2.1

Next, install SQL with the following commands:

$ ./configure [options]
$ make
$ sudo make install

The options in configure are optional. For an overview of available options type:

$ ./configure --help

Other operating systems

Windows

This distribution contains an .EXE file that was generated using PAR::Packer with Strawberry Perl.

The files sqltex-2.1\SQLTeX.EXE, sqltex-2.1\src\SQLTeX.cfg and sqltex-2.1\src\SQLTeX_r.dat must be placed manually in the directory of your choice, all in the same direcrtory.

OpenVMS

For other operating systems, there is no install script, you will have to install it manually.

On OpenVMS it would be something like:

$ COPY [.SQLTEX-2_1.SRC]SQLTEX.PL SYS$SYSTEM:
$ COPY [.SQLTEX-2_1.SRC]SQLTEX.CFG SYS$SYSTEM:
$ COPY [.SQLTEX-2_1.SRC]SQLTEX_R.DAT SYS$SYSTEM:
$ SET FILE/PROTECTION=(W:R) SYS$SYSTEM:SQLTEX*.*

However, on OpenVMS you also need to define the command SQLTEX by setting a symbol, either in the LOGIN.COM for all users who need to execute this script, or in some group– or system wide login procedure, with the command:

$ SQLTEX :== "PERL SYS$SYSTEM:SQLTEX.PL"

Documentation

Full documentation is in doc/SQLTeX.pdf.

On linux, this file will be placed in /usr/share/doc/sqltex by make install. This location can be changed with the options in the ./configure step.

Requirements

Note for MAC users

If DBI and the database driver are not yet installed, Xtools needs to be installed in advance, since gcc is not available in a standard install of Mac OS X.

Credits

  • Ingo Reich for the comment on Mac OS
  • Johan W. Klüwer for verifying the SyBase support
  • Paolo Cavallini for adding PostgreSQL support

The SQL project is available from GitHub.

For bugs, questions and comments, please use the issue tracker

This software is subject to the terms of the Project Public License; see http://www.ctan.org/tex-archive/help/Catalogue/licenses.lppl.html

Copyright (c) 2001-2022 - Oscar van Eijk, Oveas Functionality Provider

Download the contents of this package in one zip archive (7.6M).

SQL – An SQL Preprocessor for

SQL is a preprocessor that enables the use of SQL statements in . The SQL perl script reads an input file containing the source with SQL commands, and writes a file in which the SQL commands have been replaced by the values from their execution. It is possible to select a field for substitution in your document, or to be used as input in another SQL command. (When an SQL command returns multiple fields and/or rows, the values can only be used within the document.)

The default is to use MySQL databases, but Pg, Sybase, Oracle, Ingres, mSQL and PostgreSQL are also supported.

PackageSQLTeX
Repositoryhttps://github.com/oveas/sqltex
Version2.1 2022-01-21
LicensesThe Project Public License
Copyright2001–2022 Oscar van Eijk
MaintainerOscar van Eijk
TopicsDB access
...
Guest Book Sitemap Contact Contact Author