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
- Amstrad Ppc
  Fri Oct 30 19:12:25 2026
  from Wiltshire via SSH
- Amstrad Ppc
  Fri Oct 30 18:31:19 2026
  from Wiltshire via SSH
- Amstrad Ppc
  Fri Oct 30 18:10:34 2026
  from Wiltshire via SSH
- Amstrad Ppc
  Fri Oct 30 17:50:40 2026
  from Wiltshire via Telnet
- Amstrad Ppc
  Fri Oct 30 17:14:40 2026
  from Wiltshire via SSH
- Amstrad Ppc
  Fri Oct 30 16:50:50 2026
  from Wiltshire via SSH
- Schuebue
  Fri Oct 30 15:46:00 2026
  from Berlin via Raw
- Amstrad Ppc
  Fri Oct 30 13:47:24 2026
  from Wiltshire via SSH

System Info

Sysop:	Keyop
Location:	Huddersfield, West Yorkshire, UK
Users:	793
Nodes:	16 (3 / 13)
Uptime:	128:01:42
Calls:	13,174
Calls today:	12
Files:	15,481
Messages:	6,578,791

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

Who's Online

Recent Visitors

System Info