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: [email protected]

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: [email protected] <[email protected]> On Behalf Of The Game Crusher Sent: 10 March 2021 16:24
To: [email protected]
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
[email protected] 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: [email protected]

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 <[email protected]>
Sent: 11 March 2021 09:25
To: 'The Game Crusher' <[email protected]>;
'[email protected]' <[email protected]> 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: [email protected] <[email protected]> On Behalf Of The Game Crusher Sent: 11 March 2021 09:14
To: [email protected]
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
[email protected] 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: [email protected]

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: [email protected] <[email protected]> On Behalf Of The Game Crusher Sent: 11 March 2021 09:14
To: [email protected]
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
[email protected] 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: [email protected]

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 <[email protected]>
Sent: 11 March 2021 09:32
To: 'The Game Crusher' <[email protected]>;
'[email protected]' <[email protected]> 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 <[email protected]>
Sent: 11 March 2021 09:25
To: 'The Game Crusher' <[email protected]>;
'[email protected]' <[email protected]> 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: [email protected] <[email protected]> On Behalf Of The Game Crusher Sent: 11 March 2021 09:14
To: [email protected]
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
[email protected] https://lists.planetingres.org/mailman/listinfo/info-ingres

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

Who's Online
Recent Visitors
- Centurion
  Tue Jun 9 21:54:05 2026
  from Berea, Ohio via Telnet
- Bob Worm
  Tue Jun 9 21:16:34 2026
  from Wales, Uk via SSH
- Yokzimo
  Tue Jun 9 17:10:05 2026
  from Sw via Telnet
- Regen
  Tue Jun 9 16:45:02 2026
  from Brooklyn, Ny via Telnet
- Bob Worm
  Tue Jun 9 14:47:58 2026
  from Wales, Uk via Telnet
- Krenn
  Tue Jun 9 11:18:15 2026
  from Sydney, Nsw via Telnet
- Bob Worm
  Tue Jun 9 10:31:07 2026
  from Wales, Uk via Telnet
- Centurion
  Mon Jun 8 23:30:43 2026
  from Berea, Ohio via Telnet

System Info

Sysop:	Keyop
Location:	Huddersfield, West Yorkshire, UK
Users:	716
Nodes:	16 (2 / 14)
Uptime:	55:03:43
Calls:	12,117
Calls today:	8
Files:	15,010
Messages:	6,518,640
Posted today:	2

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

Who's Online

Recent Visitors

System Info