Hi All,



I've been trawling back!dmh!hdr!dm0c.h to try and find where all the
unicode fields are stored in the configuration file.

Other than the default unicode collation field I have been unable to
determine where I would find the flags indicating if the database is
unicode enabled and what the normalizattion scheme is.



Would they be buried in the dbservice field?



Martin Bowes

Martin Bowes wrote:

I would use dbmsinfo('unicode_level') and
dbmsinfo('unicode_normalization'). But perhaps you have your reasons.

--
Roy

UK Ingres User Association Conference 2010 will be on Tuesday June 8 2010
Go to http://www.iua.org.uk/join to get on the mailing list.

Yes sure do.

I need something to automate the creation of databases on a recovery
host when the source host is totally hosed. My DRP is scripted to
snaffle vast swathes of information and salt it away on the recovery
host...but when I explain where to find it all, my audience glazes over
and starts drooling. How to put it all back togethor and do a recovery
was not something they were comfortable with...terrified was a better
expression.

I thought the easiest option was to create a simple script which could
pull all the pieces togethor so that in my absence any poor fool here
could simply execute the thing to get a database recovery going on the
recovery host.

It occurred that a perl script to dismember the configuration file was
an easier option than mining all the other details I save away.

And it also occurred that what can be read can be written so the module
could then be extended to simple writes to a configuration file...alter
the database id, extent paths that sort of thing.

Is that cool or what?

Marty

-----Original Message-----
From: Roy Hann [mailto:specially (AT) processed (DOT) almost.meat]
Sent: 10 February 2010 14:11
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: Re: [Info-Ingres] Where are the unicode fields in
theconfiguration file.

Martin Bowes wrote:

I would use dbmsinfo('unicode_level') and
dbmsinfo('unicode_normalization'). But perhaps you have your reasons.

--
Roy

UK Ingres User Association Conference 2010 will be on Tuesday June 8
2010
Go to http://www.iua.org.uk/join to get on the mailing list.


_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

On Feb 10, 2010, at 8:13 AM, Martin Bowes wrote:

Yes, and because the cnf dbservice is the same as the iidatabase
dbservice, the definitions are in common/hdr/hdr/dudbms.qsh.

Karl

Martin Bowes wrote:

That is cool, to be sure. Years ago Karl wrote a little tool that did
some of that; you might ask him about it, though I vaguely recall him
giving all kinds of timid-sounding caveats about it being for Unix only
and not thoroughly tested and "you'd be on your own" etc.

--
Roy

UK Ingres User Association Conference 2010 will be on Tuesday June 8 2010
Go to http://www.iua.org.uk/join to get on the mailing list.

On Feb 10, 2010, at 11:42 AM, Roy Hann wrote:

If we're thinking of the same thing, the tool Roy is referring to
was written pre-open-source, and indeed before I had any source
access; using hex dumps of the config file to reverse engineer
the relevant bits. Obviously, these days one would base the thing
on the real dm0c.h, and no timid disclaimers would be needed.

Karl

(well, it would still be Unix only, if I were writing it...)

Basing it on dm0c.h etc is obviously the Opensource thing to do!

But at the moment I'm hacking a perl module togethor ... as proof of
concept if nothing else. Although other than database id and extents I
can't really see much point in a powerful config file editor. It'd be a
wrecking ball rather than a utility.

Marty

-----Original Message-----
From: Karl Schendel [mailto:schendel (AT) kbcomputer (DOT) com]
Sent: 10 February 2010 17:14
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Where are the unicode fieldsin
theconfiguration file.


On Feb 10, 2010, at 11:42 AM, Roy Hann wrote:

If we're thinking of the same thing, the tool Roy is referring to
was written pre-open-source, and indeed before I had any source
access; using hex dumps of the config file to reverse engineer
the relevant bits. Obviously, these days one would base the thing
on the real dm0c.h, and no timid disclaimers would be needed.

Karl

(well, it would still be Unix only, if I were writing it...)


_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres