4GL/SQL question ?

Posted in 1999

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL

Bill — Wed, 07 Apr 1999 08:24:38 GMT — source: Informix-list mailing list archive (1991-1998)

Dear Sir. I have a question about "4GL", and hope you can help me. We have a database tale. Its record count =300000 The layout of table x is as following: ----------------- n integer, -- primary key f1 char(10), -- unique key f2 text fn .... -------------------- f1= Xnnnnnnnnn , X=>'A'..'Z' ,,n=1..0 when f1[2,9] repeats, such as "S123456789" or "L123456789", then "12345678" will be what I want. How should I write my SQL command? -- -- '̷R'p'' : <binary@ms1.hinet.net> --

↪ replying to Bill

Howard — Wed, 7 Apr 1999 10:08:23 +0100 — source: Informix-list mailing list archive (1991-1998)

Try : Select unique ( f1[2,10] ) from x regards Howard Soper Bill <binary@ms1.hinet.net> wrote in message news:370b0a50.21548064@168.95.195.16... > Dear Sir. > > I have a question about "4GL", and hope you can help me. > We have a database tale. Its record count =300000 > The layout of table x is as following: > ----------------- > n integer, -- primary key > f1 char(10), -- unique key > f2 text > fn .... > -------------------- > f1= Xnnnnnnnnn , X=>'A'..'Z' ,,n=1..0 > > when f1[2,9] repeats, such as "S123456789" or "L123456789", > then "12345678" will be what I want. > How should I write my SQL command? > > -- > -- '̷R'p'' : <binary@ms1.hinet.net> > --

Glossary

4GL (Informix-4GL)