From Newsgroup: comp.databases.ingres

can copydb or otherwise export just the procedures or rules?
I don't want the tables because they are thousands
--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ingres

Hi,

https://docs.actian.com/ingres/11.0/index.html#page/CommandRef%2Fcopydb_Comm and--Copy_and_Restore_a_Database.htm%23

[-with_proc]
[-with_rules]

Is where you need to start looking...

Cheers
Adrian

-----Original Message-----
From: info-ingres-bounces@lists.planetingres.org <info-ingres-bounces@lists.planetingres.org> On Behalf Of The Game Crusher Sent: 10 March 2021 16:24
To: info-ingres@lists.planetingres.org
Subject: [Info-ingres] export the rules or procedures only?

can copydb or otherwise export just the procedures or rules?
I don't want the tables because they are thousands _______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres

--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ingres

thanks,that's what I needed.
Do you know if it is possible to export a table as JSON?
--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ingres

Hi,

Actian have been adding support for JSON in a number of product lines, for
the Ingres side I'd need to check the release notes on the later versions.

It is not something I have had to do.

What version if Ingres are you using?

Cheers

Adrian

-----Original Message-----
From: info-ingres-bounces@lists.planetingres.org <info-ingres-bounces@lists.planetingres.org> On Behalf Of The Game Crusher Sent: 11 March 2021 09:14
To: info-ingres@lists.planetingres.org
Subject: Re: [Info-ingres] export the rules or procedures only?

thanks,that's what I needed.
Do you know if it is possible to export a table as JSON? _______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres

--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ingres

Not getting a warm feeling about being able to specify JSON structure for
whole table exports - but I am notorious for not reading the instructions.

Actian X 11.1 (Ingres for the new generation) is where I'd push you to have
a look:

https://docs.actian.com/actianx/11.1/index.html#page/SQLRef%2F9._Working_wit h_JSON_Data.htm%23



-----Original Message-----
From: Adrian Williamson <adrian.williamson@rationalcommerce.com>
Sent: 11 March 2021 09:25
To: 'The Game Crusher' <vcxris@gmail.com>;
'info-ingres@lists.planetingres.org' <info-ingres@lists.planetingres.org> Subject: RE: [Info-ingres] export the rules or procedures only?

Hi,

Actian have been adding support for JSON in a number of product lines, for
the Ingres side I'd need to check the release notes on the later versions.

It is not something I have had to do.

What version if Ingres are you using?

Cheers

Adrian

-----Original Message-----
From: info-ingres-bounces@lists.planetingres.org <info-ingres-bounces@lists.planetingres.org> On Behalf Of The Game Crusher Sent: 11 March 2021 09:14
To: info-ingres@lists.planetingres.org
Subject: Re: [Info-ingres] export the rules or procedures only?

thanks,that's what I needed.
Do you know if it is possible to export a table as JSON? _______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres

--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ingres

In here:

https://docs.actian.com/actianx/11.1/index.html#page/DatabaseAdmin%2F10._Loa ding_and_Unloading_Databases.htm%23

I would have hoped to see a JSON section next to the section titled
"Generate XML and Import XML Operations"

I see that the unwashed masses have created quite a market for XML to JSON conversion.

Good luck.

-----Original Message-----
From: Adrian Williamson <adrian.williamson@rationalcommerce.com>
Sent: 11 March 2021 09:32
To: 'The Game Crusher' <vcxris@gmail.com>;
'info-ingres@lists.planetingres.org' <info-ingres@lists.planetingres.org> Subject: RE: [Info-ingres] export the rules or procedures only?

Not getting a warm feeling about being able to specify JSON structure for
whole table exports - but I am notorious for not reading the instructions.

Actian X 11.1 (Ingres for the new generation) is where I'd push you to have
a look:

https://docs.actian.com/actianx/11.1/index.html#page/SQLRef%2F9._Working_wit h_JSON_Data.htm%23



-----Original Message-----
From: Adrian Williamson <adrian.williamson@rationalcommerce.com>
Sent: 11 March 2021 09:25
To: 'The Game Crusher' <vcxris@gmail.com>;
'info-ingres@lists.planetingres.org' <info-ingres@lists.planetingres.org> Subject: RE: [Info-ingres] export the rules or procedures only?

Hi,

Actian have been adding support for JSON in a number of product lines, for
the Ingres side I'd need to check the release notes on the later versions.

It is not something I have had to do.

What version if Ingres are you using?

Cheers

Adrian

-----Original Message-----
From: info-ingres-bounces@lists.planetingres.org <info-ingres-bounces@lists.planetingres.org> On Behalf Of The Game Crusher Sent: 11 March 2021 09:14
To: info-ingres@lists.planetingres.org
Subject: Re: [Info-ingres] export the rules or procedures only?

thanks,that's what I needed.
Do you know if it is possible to export a table as JSON? _______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres

--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ingres

Adrian Williamson wrote:

In here:

https://docs.actian.com/actianx/11.1/index.html#page/DatabaseAdmin%2F10._Loading_and_Unloading_Databases.htm%23

I would have hoped to see a JSON section next to the section titled
"Generate XML and Import XML Operations"

I see that the unwashed masses have created quite a market for XML to JSON conversion.

I will never be reconciled to XML as an exchange format.

If one is desperate for JSON it might be easier to export the tables as
CSV files and convert those to JSON.

Roy

--- Synchronet 3.21b-Linux NewsLink 1.2