Forum: >>> Magnum BBS <<<

[Info-ingres] export the rules or procedures only?

From Adrian Williamson@21:1/5 to The Game Crusher on Wed Mar 10 16:40:17 2021

To: info-ingres@lists.planetingres.org

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

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

From The Game Crusher@21:1/5 to All on Thu Mar 11 01:13:54 2021

thanks,that's what I needed.
Do you know if it is possible to export a table as JSON?

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

From Adrian Williamson@21:1/5 to The Game Crusher on Thu Mar 11 09:31:37 2021

To: info-ingres@lists.planetingres.org

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

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

From Adrian Williamson@21:1/5 to The Game Crusher on Thu Mar 11 09:24:42 2021

To: info-ingres@lists.planetingres.org

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

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

From Roy Hann@21:1/5 to Adrian Williamson on Thu Mar 11 10:01:09 2021

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

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

From Adrian Williamson@21:1/5 to The Game Crusher on Thu Mar 11 09:35:41 2021

To: info-ingres@lists.planetingres.org

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

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

Who's Online
Recent Visitors
- Plume
  Sun Sep 14 09:34:52 2025
  from Uk via Raw
- Gretchiie
  Sun Sep 14 06:07:30 2025
  from Derry, Nh via Telnet
- Thlc
  Sat Sep 13 17:11:34 2025
  from Rognac, France via Telnet
- Thlc
  Sat Sep 13 17:04:03 2025
  from Rognac, France via Telnet
- Thlc
  Sat Sep 13 16:32:19 2025
  from Rognac, France via SSH
- Thlc
  Sat Sep 13 15:41:11 2025
  from Rognac, France via SSH
- Thlc
  Sat Sep 13 07:56:03 2025
  from Rognac, France via SSH
- Gretchiie
  Sat Sep 13 07:22:10 2025
  from Derry, Nh via Telnet

System Info

Sysop:	Keyop
Location:	Huddersfield, West Yorkshire, UK
Users:	546
Nodes:	16 (1 / 15)
Uptime:	159:39:04
Calls:	10,385
Calls today:	2
Files:	14,056
Messages:	6,416,491

[Info-ingres] export the rules or procedures only?

Who's Online

Recent Visitors

System Info