[Info-Ingres] Ingres Wikipedia entry

#21

c == compressed, but you'll have to check the manual if that means key
and data compression or not for the given structure.

Marty

-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Paul
White
Sent: 06 March 2009 12:27
To: Ingres and related product discussion forum
Subject: [Info-Ingres] Index storage structures

Before asking a potentially really dumb question and risk of a sounding
like a complete ingres newbie I performed this test..

* create index idx_customer_firstname on customer (first_name) with
structure = heap ;\g
Executing . . .

E_US14C1 CREATE INDEX: Bad storage structure 'heap'. The valid storage
structure names are [c]btree, [c]isam, [c]hash.

ummmm
What does the [c] mean?

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

#22

Whoa...

OK... Sorry... I thought for a second Paul said "clothes are optional"...

Anyway, the boss in the office has asked me to investigate converting
some of our report writer printouts into PDF.

Thing is, we use PCL coding in most of our reports and so I need to ask
for help.

Can anyone please give me some advice or examples on PCL to PDF
conversion on a linux server? Or should I change the rw code to maybe
generate html code and then convert that to pdf? Is it possible to
generate pdf files from rw code?

Any help would be greatly appreciated.

Regards,
Andrew.

Paul White wrote:

Quote:

Roy writes

But she thinks most of my clothes are for editing wikipedia. She can be

very hurtful.

I recently discovered working from home is kinda fun, I also discovered
working clothes are optional.

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

#23

Andrew wrote:

Quote:

Whoa...

OK... Sorry... I thought for a second Paul said "clothes are optional"...

Anyway, the boss in the office has asked me to investigate converting
some of our report writer printouts into PDF.

Thing is, we use PCL coding in most of our reports and so I need to ask
for help.

Can anyone please give me some advice or examples on PCL to PDF
conversion on a linux server? Or should I change the rw code to maybe
generate html code and then convert that to pdf? Is it possible to
generate pdf files from rw code?

Any help would be greatly appreciated.

Your simplest solution might be to look for a PDF pseudo-printer driver.
I'm sure such things exist for Linux, but the one I use extensively on
Windows is CutePDF. You print as usual, except instead of being sent to
a real printer the output gets sent to a PDF file. It is endlessly
useful.

--
Roy

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

#24

The new dynamic query cache only works with prepared statements. If
questions aren't prepared the dynamic query caching feature has no
effect.

Teresa

On Mar 6, 4:10*am, Betty & Karl Schendel <schen... (AT) kbcomputer (DOT) com>
wrote:

Quote:

On Mar 6, 2009, at 7:06 AM, Paul White wrote:

Happily that particular detour into La-La Land has been cancelled.

So does that mean that the REPEATED in front of every single SQL *
statement
in our OpenROAD programs is now having no effect? * Ooohh nooooooo!

no, no, it was optimizer hints that was cancelled. *Your REPEATEDs still
have all the unfortunate effects that they did before.

I will have to go back to manually optimizing instructions to fall *
on a 256
byte boundary to help simplify the rotational delay calculations to
interleave my magnetic drum core memory.

Even Jon Jensen isn't THAT old. *:-)

Karl

#25

We use some free software on solaris which should also be available for
linux.
enscript - convert text files to PostScript
ps2pdf - ps2pdf - Convert PostScript to PDF using ghostscript
ps2pdf12 - Convert PostScript to PDF 1.2 (Acrobat 3-and-
later compatible) using ghostscript
ps2pdf13 - Convert PostScript to PDF 1.3 (Acrobat 4-and-
later compatible) using ghostscript

enscript -v -B $land -M A4 --download-font=letgothl.pfb \
--margins=0:0:0:0 --font=LetterGothicLine$fsiz -o $pfile $ifile

ps2pdf $pfile $ofile

rm -f $pfile

--Robert

-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Andrew
Sent: Saturday, 7 March 2009 3:12 a.m.
To: Ingres and related product discussion forum
Subject: [Info-Ingres] Report Writer - PCL to PDF

Whoa...

OK... Sorry... I thought for a second Paul said "clothes are
optional"...

Anyway, the boss in the office has asked me to investigate converting
some of our report writer printouts into PDF.

Thing is, we use PCL coding in most of our reports and so I need to ask
for help.

Can anyone please give me some advice or examples on PCL to PDF
conversion on a linux server? Or should I change the rw code to maybe
generate html code and then convert that to pdf? Is it possible to
generate pdf files from rw code?

Any help would be greatly appreciated.

Regards,
Andrew.

Paul White wrote:

Quote:

Roy writes

But she thinks most of my clothes are for editing wikipedia. She can

be

very hurtful.

I recently discovered working from home is kinda fun, I also
discovered working clothes are optional.

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

_______________________________________________

Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://www.kettleriverconsulting.com...fo/info-ingres
Confidentiality/Privilege Notice:
This communication is confidential and may be legally privileged. If you are not the intended recipient please delete the message and notify the sender at Ports of Auckland Limited. Any use, disclosure, copying, distribution or retention of this communication is strictly prohibited.

#26

Teresa wrote:

Quote:

The new dynamic query cache only works with prepared statements. If
questions aren't prepared the dynamic query caching feature has no
effect.

That is a fairly significant nuance I had overlooked. :-(

--
Roy

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

#27

Hi All,

I've added some more changes to the wiki entry. Specifically tarted up
the Database Rules section and added headings for events and sequences.

Thanks to whoever added the bullet points to the 'Tables Section', looks
a lot neater.

Marty

#28

Ok, I'll come clean: I added the bullet points. I have now gone on to
populate the DBP section. Hope you don't mind.

jo

On Mon, Mar 9, 2009 at 12:45 PM, Martin Bowes <martin.bowes (AT) ctsu (DOT) ox.ac.uk>wrote:

Quote:

Hi All,

I've added some more changes to the wiki entry. Specifically tarted up
the Database Rules section and added headings for events and sequences.

Thanks to whoever added the bullet points to the 'Tables Section', looks
a lot neater.

Marty

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

--
Jeremy Peel

#29

Hi Jeremy,

I noticed the DBP stuff this morning, looks good too!

Well done. There are planty of other sections you might like to do. I've
scattered some topic headings in the area, but feel free to fill them in
or add more.

Marty

From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Jeremy peel
Sent: 10 March 2009 10:25
To: Ingres and related product discussion forum
Cc: Roy Hann (E-mail)
Subject: Re: [Info-Ingres] Ingres Wikipedia entry

Ok, I'll come clean: I added the bullet points. I have now gone on to
populate the DBP section. Hope you don't mind.

jo

On Mon, Mar 9, 2009 at 12:45 PM, Martin Bowes
<martin.bowes (AT) ctsu (DOT) ox.ac.uk> wrote:

Hi All,

I've added some more changes to the wiki entry. Specifically tarted up
the Database Rules section and added headings for events and sequences.

Thanks to whoever added the bullet points to the 'Tables Section', looks
a lot neater.

Marty

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

--
Jeremy Peel

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

[Info-Ingres] Ingres Wikipedia entry

comp.databases.ingres comp.databases.ingres

Re: [Info-Ingres] Index storage structures - 03-06-2009 , 06:47 AM

[Info-Ingres] Report Writer - PCL to PDF - 03-06-2009 , 08:12 AM

Re: [Info-Ingres] Report Writer - PCL to PDF - 03-06-2009 , 08:19 AM

Re: Ingres Wikipedia entry - 03-06-2009 , 09:23 AM

Re: [Info-Ingres] Report Writer - PCL to PDF - 03-08-2009 , 02:05 PM

Re: Ingres Wikipedia entry - 03-09-2009 , 03:21 AM

Re: [Info-Ingres] Ingres Wikipedia entry - 03-09-2009 , 05:45 AM

Re: [Info-Ingres] Ingres Wikipedia entry - 03-10-2009 , 04:25 AM

Re: [Info-Ingres] Ingres Wikipedia entry - 03-10-2009 , 05:44 AM