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)

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)

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)

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)

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)

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)