I don't have a complete answer, but consider using the POSSTR function -
use a CHAR() function of CountryFile.Country, if it's numeric.
Hope that leads you further.
On 12/16/2015 5:14 AM, Wilson, Jonathan wrote:
On Tue, 2015-12-15 at 10:04 -0500, Charles Wilt wrote:
Well that was far easier than I had assumed... but leads me on to one
select * from qtemp.cntry
where :newcode like (CountryCode concat '%')
or CountryCode like (:newcode concat '%')
Given the 10 digit ISBN holds a country code within it, and there is no
indication of how many digits make up the country code... how would I do
something along the lines of:
select SomeFields from BiblFile join with Countryfile where
BiblFile.ISBN contains partial match with CountryFile.Country.
80 Czech Republic
011700001X TitleA 0 English
810115400X TitleB 1 India
922941011X TitleD 9229 Guatemala
Using your assumption of varying length fields, no trailing spaces.
I get the feeling that its something to do with joining the country file
to the bibliographic file, but in reverse - kind of.
Select SomeFields from BiblFile and CountryFile where rightjoin
(CountryFile.Country *cat '%') like Biblfile.ISBN
On Tue, Dec 15, 2015 at 9:47 AM, Wilson, Jonathan <piercing_male@xxxxxxxxxxx
This question is based in part on an ISBN structure, but is not strictly
following the rules.
Both short and long answers are appreciated, even ones that say "look at
the ... statement in the ... manual" or "this link does something
similar, you'll have to adapt it to DB2/i" as I'm working with very very
little experience of SQL (basic selects/inserts/updates is my current
level of experience).
An ISBN is made up of 3 parts (Excluding the new prefix, and checksum).
Country (Also language, as "English" is denoted by 0 and 1)
All the parts are variable in length, so if a country produces few books
its country code is longer than a country producing a lot of titles.
This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact