Re: VMS x86-64 database server

Liste des GroupesRevenir à co vms 
Sujet : Re: VMS x86-64 database server
De : ldo (at) *nospam* nz.invalid (Lawrence D'Oliveiro)
Groupes : comp.os.vms
Date : 09. Jul 2025, 08:22:19
Autres entêtes
Organisation : A noiseless patient Spider
Message-ID : <104l5bb$4bv9$1@dont-email.me>
References : 1 2 3 4 5 6 7 8 9 10 11 12 13
User-Agent : Pan/0.162 (Pokrosvk)
On Tue, 8 Jul 2025 20:31:37 -0400, Arne Vajhøj wrote:

On 7/8/2025 7:37 PM, Lawrence D'Oliveiro wrote:
>
On Tue, 8 Jul 2025 18:20:50 -0400, Arne Vajhøj wrote:
>
Standards evolve. They add lots of new stuff. And sometimes they
remove stuff that is not needed anymore.
>
But those standards in particular have not evolved.
>
SQL standard has evolved. Lot of stuff has been added.

But nothing new in EXEC SQL. For example, did they offer any
equivalent to the following utility functions?

    def sql_string_list(the_list) :
        "returns a list containing the quoted items of the_list, suitable" \
        " for use in an “in” clause."
        return \
            "(" + ", ".join([sql_string(s) for s in the_list]) + ")"
    #end sql_string_list

    def escape_sql_wild(s, escch) :
        "escapes SQL pattern wildcards in s with escch. The same escch needs" \
        " to be passed to the ESCAPE clause for the LIKE operator."
        if not isinstance(s, str) :
            raise TypeError("expecting s to be a string")
        #end if
        if not isinstance(escch, str) or len(escch) != 1 :
            raise TypeError("expecting escch to be a single-character string")
        #end if
        result = []
        for ch in s :
            if ch == escch or ch == "%" or ch == "_" :
                result.append(escch)
            #end if
            result.append(ch)
        #end for
        return "".join(result)
    #end escape_sql_wild

    def escape_sql_name(n, escch = "\"") :
        "converts n to escaped form to avoid potential conflicts with SQL keywords" \
        " and other syntax errors (e.g. from embedded spaces). escch should be “\"”" \
        " as per the SQL standard."
        assert len(escch) == 1
        out = []
        for i, split1 in enumerate(n.split(escch)) :
            if i != 0 :
                out.append(escch * 2)
            #end if
            out.append(split1)
        #end for
        return escch + "".join(out) + escch
    #end escape_sql_name

Date Sujet#  Auteur
6 Jul20:45 * VMS x86-64 database server78Arne Vajhøj
6 Jul22:39 +- Re: VMS x86-64 database server1Lawrence D'Oliveiro
6 Jul23:07 +* Re: VMS x86-64 database server48Arne Vajhøj
7 Jul00:19 i+* Re: VMS x86-64 database server46Lawrence D'Oliveiro
7 Jul00:58 ii`* Re: VMS x86-64 database server45Arne Vajhøj
7 Jul03:42 ii `* Re: VMS x86-64 database server44Lawrence D'Oliveiro
7 Jul19:07 ii  `* Re: VMS x86-64 database server43Arne Vajhøj
7 Jul19:16 ii   +* Re: VMS x86-64 database server2Arne Vajhøj
7 Jul19:21 ii   i`- Re: VMS x86-64 database server1Arne Vajhøj
7 Jul23:07 ii   `* Re: VMS x86-64 database server40Lawrence D'Oliveiro
8 Jul00:28 ii    +* Re: VMS x86-64 database server23Arne Vajhøj
8 Jul01:26 ii    i`* Re: VMS x86-64 database server22Lawrence D'Oliveiro
8 Jul13:45 ii    i `* Re: VMS x86-64 database server21Arne Vajhøj
8 Jul22:57 ii    i  `* Re: VMS x86-64 database server20Lawrence D'Oliveiro
8 Jul23:40 ii    i   `* Re: VMS x86-64 database server19Arne Vajhøj
9 Jul00:38 ii    i    `* Re: VMS x86-64 database server18Lawrence D'Oliveiro
9 Jul02:54 ii    i     `* Re: VMS x86-64 database server17Arne Vajhøj
9 Jul08:25 ii    i      `* Re: VMS x86-64 database server16Lawrence D'Oliveiro
9 Jul20:33 ii    i       `* Re: VMS x86-64 database server15Arne Vajhøj
10 Jul00:07 ii    i        `* Re: VMS x86-64 database server14Lawrence D'Oliveiro
10 Jul00:51 ii    i         `* Re: VMS x86-64 database server13Arne Vajhøj
10 Jul02:21 ii    i          `* Re: VMS x86-64 database server12Lawrence D'Oliveiro
10 Jul03:24 ii    i           `* Re: VMS x86-64 database server11Arne Vajhøj
10 Jul05:28 ii    i            +* Re: VMS x86-64 database server8Lawrence D'Oliveiro
11 Jul00:05 ii    i            i`* Re: VMS x86-64 database server7Arne Vajhøj
11 Jul00:58 ii    i            i `* Re: VMS x86-64 database server6Lawrence D'Oliveiro
11 Jul01:11 ii    i            i  `* Re: VMS x86-64 database server5Arne Vajhøj
11 Jul01:19 ii    i            i   `* Re: VMS x86-64 database server4Lawrence D'Oliveiro
11 Jul01:23 ii    i            i    `* Re: VMS x86-64 database server3Arne Vajhøj
11 Jul01:29 ii    i            i     `* Re: VMS x86-64 database server2Lawrence D'Oliveiro
11 Jul01:38 ii    i            i      `- Re: VMS x86-64 database server1Arne Vajhøj
11 Jul00:57 ii    i            `* Re: VMS x86-64 database server2Arne Vajhøj
11 Jul01:24 ii    i             `- Re: VMS x86-64 database server1Lawrence D'Oliveiro
8 Jul14:35 ii    `* Re: VMS x86-64 database server16Arne Vajhøj
8 Jul22:56 ii     `* Re: VMS x86-64 database server15Lawrence D'Oliveiro
8 Jul23:20 ii      `* Re: VMS x86-64 database server14Arne Vajhøj
9 Jul00:37 ii       `* Re: VMS x86-64 database server13Lawrence D'Oliveiro
9 Jul01:31 ii        `* Re: VMS x86-64 database server12Arne Vajhøj
9 Jul08:22 ii         `* Re: VMS x86-64 database server11Lawrence D'Oliveiro
10 Jul01:04 ii          `* Re: VMS x86-64 database server10Arne Vajhøj
10 Jul01:25 ii           +* Re: VMS x86-64 database server7Arne Vajhøj
10 Jul02:35 ii           i`* Re: VMS x86-64 database server6Lawrence D'Oliveiro
10 Jul03:26 ii           i `* Re: VMS x86-64 database server5Arne Vajhøj
10 Jul06:48 ii           i  `* Re: VMS x86-64 database server4Lawrence D'Oliveiro
11 Jul00:14 ii           i   `* Re: VMS x86-64 database server3Arne Vajhøj
11 Jul00:54 ii           i    `* Re: VMS x86-64 database server2Lawrence D'Oliveiro
11 Jul01:29 ii           i     `- Re: VMS x86-64 database server1Arne Vajhøj
10 Jul02:33 ii           `* Re: VMS x86-64 database server2Lawrence D'Oliveiro
11 Jul01:33 ii            `- Re: VMS x86-64 database server1Lawrence D'Oliveiro
11 Jul00:50 i`- Re: VMS x86-64 database server1Arne Vajhøj
6 Jul23:11 +- Re: VMS x86-64 database server1Arne Vajhøj
6 Jul23:39 `* Re: VMS x86-64 database server27Craig A. Berry
7 Jul00:57  `* Re: VMS x86-64 database server26Arne Vajhøj
7 Jul15:50   `* Re: VMS x86-64 database server25Mark Berryman
7 Jul19:01    `* Re: VMS x86-64 database server24Arne Vajhøj
7 Jul22:06     `* Re: VMS x86-64 database server23Mark Berryman
7 Jul22:36      +* Re: VMS x86-64 database server2Arne Vajhøj
7 Jul22:37      i`- Re: VMS x86-64 database server1Arne Vajhøj
7 Jul23:08      `* Re: VMS x86-64 database server20Lawrence D'Oliveiro
8 Jul00:21       `* Re: VMS x86-64 database server19Arne Vajhøj
8 Jul01:27        `* Re: VMS x86-64 database server18Lawrence D'Oliveiro
8 Jul12:14         `* Re: VMS x86-64 database server17Arne Vajhøj
8 Jul22:58          `* Re: VMS x86-64 database server16Lawrence D'Oliveiro
8 Jul23:14           +* Re: VMS x86-64 database server12Arne Vajhøj
9 Jul00:40           i`* Re: VMS x86-64 database server11Lawrence D'Oliveiro
9 Jul03:18           i `* Re: VMS x86-64 database server10Arne Vajhøj
9 Jul08:27           i  +- Re: VMS x86-64 database server1Lawrence D'Oliveiro
9 Jul11:16           i  `* Re: VMS x86-64 database server8hb0815
9 Jul15:13           i   `* Re: VMS x86-64 database server7Arne Vajhøj
9 Jul17:51           i    `* Re: VMS x86-64 database server6hb0815
9 Jul18:39           i     `* Re: VMS x86-64 database server5Arne Vajhøj
9 Jul18:56           i      +- Re: VMS x86-64 database server1Chris Townley
9 Jul20:55           i      `* Re: VMS x86-64 database server3hb0815
10 Jul20:50           i       `* Re: VMS x86-64 database server2Arne Vajhøj
10 Jul20:52           i        `- Re: VMS x86-64 database server1Arne Vajhøj
10 Jul01:12           `* Re: VMS x86-64 database server3bill
10 Jul13:00            `* Re: VMS x86-64 database server2Dan Cross
11 Jul00:23             `- Re: VMS x86-64 database server1Arne Vajhøj

Haut de la page

Les messages affichés proviennent d'usenet.

NewsPortal