Ingress 9.2 to 10.1 Migration

[Jayakumar Soyi]

Hi All

Hope things are going good!!!

We are in the process of understanding the steps involved in Ingress 9.2 to Ingress 10.1 migration and need your guidance.

Source System: Ingress 9.2 in AIX

Destination System: Ingress 10.1 in Linux

Programming Language used: Ingress C

We are following the guidelines outlined in the link docs.actian.com

http://docs.actian.com/#b26320t25559n/s-1/s3970/s3994/s3994b177863

(following all the sub steps under the heading Creating a New Ingres Development Environment)

Questions related to Database migration:

1) other than the above link any other references need to be followed?

2) other helpful details?

Questions related to application migration/ Ingress C: 

1) any code change will be required due to this migration? (eg: ifdef Unix - does this needs to be changed to ifdef - Linux?)

2) tutorial references for Ingress C?

Your guidance will be much helpful to us...

Thanks in advance,

Regards

Jay. 

[Bodo Bergmann]

It’s Ingres rather than “Ingress” - only one “s”.

 

As this question is obviously not OpenROAD-related,

I would recommend to open a thread in one of the Ingres-related forums,

e.g. http://community.actian.com/forum/database-migration/

or the comp.datatbases.ingres usenet group.

 

Regards,

Bodo.

--
You received this message because you are subscribed to the Google Groups "OpenROAD Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openroad-user...@googlegroups.com.
To post to this group, send email to openroa...@googlegroups.com.
Visit this group at http://groups.google.com/group/openroad-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/CABb2waXMLeqsCenJPfkhZ01BhGfUX5gfZRRHEh7RsBZBnotS0g%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[Jayakumar Soyi]

Thanks Bodo!!!

Sorry for the inconvenience caused if any.

Regards
Jay.

To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/b5313901fce144a98eb4f92141928e7e%40CO1PR06MB314.namprd06.prod.outlook.com.

[Paul White]

Hi there Jay

 

There’s just one S in Ingres J

 

I can report just one problem migrating to 10.1

This incorrect statement ran ok in 9.x but produced error in 10.x

 

select distinct (varchar(effective_date)), cust_code

from customer_pricelist where cust_code = 'C00029'

order by effective_date desc

 

E_US0888 Sort column or expression not found in select list of distinct or grouped query.

 

The fix was

 

select distinct (varchar(effective_date)), cust_code

from customer_pricelist where cust_code = 'C00029'

order by varchar(effective_date) desc

 

 

You’ll get good response from Ingres forums. eg

 

https://groups.google.com/forum/#!forum/comp.databases.ingres

 

mailto:info-...@lists.planetingres.org

 

http://community.actian.com/forum/ingres-forums/

 

 

Paul White

 

&
Shift Seven Solutions
www.shift7solutions.com.au

 

 

 

From: openroa...@googlegroups.com [mailto:openroa...@googlegroups.com] On Behalf Of Jayakumar Soyi
Sent: Friday, 8 August 2014 7:51 PM
To: openroa...@googlegroups.com
Subject: [openroad-users] Ingress 9.2 to 10.1 Migration

 

Hi All

--

[Karl Schendel]

On Aug 8, 2014, at 5:50 AM, Jayakumar Soyi <jayakum...@gmail.com> wrote:

> Source System: Ingress 9.2 in AIX
> Destination System: Ingress 10.1 in Linux
>

> Questions related to Database migration:
> 1) other than the above link any other references need to be followed?

The Migration Guide should suffice. (Of course, I'm biased!)

> 2) other helpful details?

SInce you are moving to a new platform along with everything else, you don't need
to worry about upgradedb, just unload and reload.

>
> Questions related to application migration/ Ingress C:
> 1) any code change will be required due to this migration? (eg: ifdef Unix - does this needs to be changed to ifdef - Linux?)

ifdef unix should still work. You'll need to recompile for 10.1 vs 9.2 but there shouldn't be
any code changes that I can think of. If you run into code that is Linux specific as opposed
to just unix specific, you might have to add #ifdef LNX or something, but that depends on
how portable your code has to be.

If your code uses specific AIX features you'll have to change them for linux, but I can't
predict what that might be. It wouldn't be Ingres related though, as far as Ingres is
concerned it's all just Ingres calls.

> 2) tutorial references for Ingress C?

There is some sort of embedded sql guide for C in the documentation set,
and reference material in the SQL Reference.

Karl

[Jayakumar Soyi]

Karl

Thanks for you time and it really helps.

Regards

Jay.

--
You received this message because you are subscribed to the Google Groups "OpenROAD Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openroad-user...@googlegroups.com.
To post to this group, send email to openroa...@googlegroups.com.
Visit this group at http://groups.google.com/group/openroad-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/A60A1308-E420-4005-A981-5EC620F264F9%40kbcomputer.com.