Linux Manuals session 3

NAME dblink_exec – executes a command in a remote database SYNOPSIS dblink_exec(text connname, text sql[, bool fail_on_error]) returns text dblink_exec(text connstr, text sql[, bool fail_on_error]) returns text dblink_exec(text sql[, bool fail_on_error]) returns text DESCRIPTION dblink_exec executes a command (that is, any SQL statement that doesn’t return rows) in a remote database. When two text arguments…

NAME dblink_error_message – gets last error message on the named connection SYNOPSIS dblink_error_message(text connname) returns text DESCRIPTION dblink_error_message fetches the most recent remote error message for a given connection. ARGUMENTS connname Name of the connection to use. RETURN VALUE Returns last error message, or an empty string if there has been no error in this…

NAME dblink_disconnect – closes a persistent connection to a remote database SYNOPSIS dblink_disconnect() returns text dblink_disconnect(text connname) returns text DESCRIPTION dblink_disconnect() closes a connection previously opened by dblink_connect(). The form with no arguments closes an unnamed connection. ARGUMENTS connname The name of a named connection to be closed. RETURN VALUE Returns status, which is always…

NAME dblink_connect_u – opens a persistent connection to a remote database, insecurely SYNOPSIS dblink_connect_u(text connstr) returns text dblink_connect_u(text connname, text connstr) returns text DESCRIPTION dblink_connect_u() is identical to dblink_connect(), except that it will allow non-superusers to connect using any authentication method. If the remote server selects an authentication method that does not involve a password,…

NAME dblink_connect – opens a persistent connection to a remote database SYNOPSIS dblink_connect(text connstr) returns text dblink_connect(text connname, text connstr) returns text DESCRIPTION dblink_connect() establishes a connection to a remote PostgreSQL database. The server and database to be contacted are identified through a standard libpq connection string. Optionally, a name can be assigned to the…

NAME dblink_close – closes a cursor in a remote database SYNOPSIS dblink_close(text cursorname[, bool fail_on_error]) returns text dblink_close(text connname, text cursorname[, bool fail_on_error]) returns text DESCRIPTION dblink_close closes a cursor previously opened with dblink_open. ARGUMENTS connname Name of the connection to use; omit this parameter to use the unnamed connection. cursorname The name of the…

NAME dblink_cancel_query – cancels any active query on the named connection SYNOPSIS dblink_cancel_query(text connname) returns text DESCRIPTION dblink_cancel_query attempts to cancel any query that is in progress on the named connection. Note that this is not certain to succeed (since, for example, the remote query might already have finished). A cancel request simply improves the…

NAME dblink_build_sql_update – builds an UPDATE statement using a local tuple, replacing the primary key field values with alternative supplied values SYNOPSIS dblink_build_sql_update(text relname, int2vector primary_key_attnums, integer num_primary_key_atts, text[] src_pk_att_vals_array, text[] tgt_pk_att_vals_array) returns text DESCRIPTION dblink_build_sql_update can be useful in doing selective replication of a local table to a remote database. It selects a row…

NAME dblink_build_sql_insert – builds an INSERT statement using a local tuple, replacing the primary key field values with alternative supplied values SYNOPSIS dblink_build_sql_insert(text relname, int2vector primary_key_attnums, integer num_primary_key_atts, text[] src_pk_att_vals_array, text[] tgt_pk_att_vals_array) returns text DESCRIPTION dblink_build_sql_insert can be useful in doing selective replication of a local table to a remote database. It selects a row…

NAME dblink_build_sql_delete – builds a DELETE statement using supplied values for primary key field values SYNOPSIS dblink_build_sql_delete(text relname, int2vector primary_key_attnums, integer num_primary_key_atts, text[] tgt_pk_att_vals_array) returns text DESCRIPTION dblink_build_sql_delete can be useful in doing selective replication of a local table to a remote database. It builds a SQL DELETE command that will delete the row with…

NAME dblink – executes a query in a remote database SYNOPSIS dblink(text connname, text sql[, bool fail_on_error]) returns setof record dblink(text connstr, text sql[, bool fail_on_error]) returns setof record dblink(text sql[, bool fail_on_error]) returns setof record DESCRIPTION dblink executes a query (usually a SELECT, but it can be any SQL statement that returns rows) in…

dbdsqr.f – Synopsis Functions/Subroutines subroutine dbdsqr (UPLO, N, NCVT, NRU, NCC, D, E, VT, LDVT, U, LDU, C, LDC, WORK, INFO) DBDSQR Function/Subroutine Documentation subroutine dbdsqr (characterUPLO, integerN, integerNCVT, integerNRU, integerNCC, double precision, dimension( * )D, double precision, dimension( * )E, double precision, dimension( ldvt, * )VT, integerLDVT, double precision, dimension( ldu, * )U, integerLDU,…

dbdsdc.f – Synopsis Functions/Subroutines subroutine dbdsdc (UPLO, COMPQ, N, D, E, U, LDU, VT, LDVT, Q, IQ, WORK, IWORK, INFO) DBDSDC Function/Subroutine Documentation subroutine dbdsdc (characterUPLO, characterCOMPQ, integerN, double precision, dimension( * )D, double precision, dimension( * )E, double precision, dimension( ldu, * )U, integerLDU, double precision, dimension( ldvt, * )VT, integerLDVT, double precision, dimension(…

dbbcsd.f – Synopsis Functions/Subroutines subroutine dbbcsd (JOBU1, JOBU2, JOBV1T, JOBV2T, TRANS, M, P, Q, THETA, PHI, U1, LDU1, U2, LDU2, V1T, LDV1T, V2T, LDV2T, B11D, B11E, B12D, B12E, B21D, B21E, B22D, B22E, WORK, LWORK, INFO) DBBCSD Function/Subroutine Documentation subroutine dbbcsd (characterJOBU1, characterJOBU2, characterJOBV1T, characterJOBV2T, characterTRANS, integerM, integerP, integerQ, double precision, dimension( * )THETA, double precision,…

NAME dbopen – database access methods SYNOPSIS #include <db.h> #include <fcntl.h> #include <limits.h> #include <sys/types.h> DB *dbopen(const char *file, int flags, int mode, DBTYPE type, const void *openinfo); DESCRIPTION Note well: This page documents interfaces provided in glibc up until version 2.1. Since version 2.2, glibc no longer provides these interfaces. Probably, you are looking…

QuantLib::GJRGARCHProcess – Stochastic-volatility GJR-GARCH(1,1) process. Synopsis #include <ql/processes/gjrgarchprocess.hpp> Inherits QuantLib::StochasticProcess. Public Types enum Discretization { PartialTruncation, FullTruncation, Reflection } Public Member Functions GJRGARCHProcess (const Handle< YieldTermStructure > &riskFreeRate, const Handle< YieldTermStructure > &dividendYield, const Handle< Quote > &s0, Real v0, Real omega, Real alpha, Real beta, Real gamma, Real lambda, Real daysPerYear=252.0, Discretization d=FullTruncation) Size…

NAME QuantLib::Period – SYNOPSIS #include <ql/time/period.hpp> Public Member Functions Period (Integer n, TimeUnit units) Period (Frequency f) Integer length () const TimeUnit units () const Frequency frequency () const Period & operator+= (const Period &) Period & operator-= (const Period &) Period & operator/= (Integer) void normalize () Related Functions (Note that these are not…

NAME tzset, tzname, timezone, daylight – initialize time conversion information SYNOPSIS #include <time.h> void tzset(void); extern char *tzname[2]; extern long timezone; extern int daylight; Feature Test Macro Requirements for glibc (see feature_test_macros(7)): tzset(): _POSIX_C_SOURCE tzname: _POSIX_C_SOURCE timezone, daylight: _XOPEN_SOURCE     || /* Glibc since 2.19: */ _DEFAULT_SOURCE     || /* Glibc versions <= 2.19: */ _SVID_SOURCE DESCRIPTION The tzset() function initializes the tzname variable from the TZ…

NAME Day counters – Classes class Actual360 Actual/360 day count convention. class Actual365Fixed Actual/365 (Fixed) day count convention. class ActualActual Actual/Actual day count. class Business252 Business/252 day count convention. class OneDayCounter 1/1 day count convention class SimpleDayCounter Simple day counter for reproducing theoretical calculations. class Thirty360 30/360 day count convention Detailed Description The class QuantLib::DayCounter…

QuantLib::Date – Concrete date class. Synopsis #include <ql/time/date.hpp> Public Member Functions constructors Date () Default constructor returning a null date. Date (BigInteger serialNumber) Constructor taking a serial number as given by Applix or Excel. Date (Day d, Month m, Year y) More traditional constructor. inspectors Weekday weekday () const Day dayOfMonth () const Day dayOfYear…