[Info-Ingres] DATE_TYPE_ALIAS is not found

[izena at mixmail.com]

Hi Jean-Pierre,

 I am still stuck with the same problem. I have tried beta2 (Community
Ed, lnx 32bits) and got the same. I am waiting to GA release and hope
it will fix it. As you, I have checked the param and it is ok, but
still I get  the param not found error.

I was trying to load data from 2.6 server and I think to remember that
curiously the reload process went 'ok' if the unload was done with
2006/104, and then reloaded with R2. But I never got to work ok the
unload process directly from 2006-R2 despite the param (through edit
config.dat nor with cbf)

Carlos


On 23 mar, 17:53, "Jean-Pierre Zuate" <jpzu... at gmail.com> wrote:
> Hello,
>
> Strange case here in the same area ...
>
> I'am running unloaddb from Ingres2006 R2 Beta [II 9.1.0 (su9.us5/119)]
> against Ingres 2.0 [II 2.0/0001 (su4.us5/00)] :
> 1/ both unloadb & copydb complain about E_US10E0 Configuration parameter
> DATE_TYPE_ALIAS is not found.
> 2/ in copy.in columns with date are simply skipped in the create table !!!
> (desapear)
>
> And when I check config.dat I have the correct ressource :
> ii.machine.dbms.*.date_type_alias:         ingresdate
>
> Can someone help please ?
> Thx
>
> 2007/1/16, Paul Mason <latep... at gmail.com>:
>
>
>
>
>
> > On 16 Jan 2007 09:31:32 -0800, i... at mixmail.com <i... at mixmail.com>
> > wrote:
>
> > > While doing unloaddb in Ingres2006 (9.0.1-116 ComEd) to get data from
> > > Ingres 2.6sp2 I get:
>
> > > E_US10E0 Configuration parameter DATE_TYPE_ALIAS is not found. Date
> > > cannot be used as a valid data type name in this installation. Please
> > > set the parameter in the config file or specify ingresdate or ansidate
> > > as data type names.
>
> > > I have beeing looking (quick) for such parameter at 2006 docs but I did
> > > not find any reference. Does anyone know what it means and where can it
> > > be configured?
>
> > > Thanks in advance
>
> > > Carlos
>
> > Hi Carlos,
>
> > I suspect that you mean 9.1.0/116 - which is Ingres 2006 release 2 -
> > which is currently in beta testing.
>
> > The error you're getting is because of the new ansidate datatype. The
> > current ingres date datatype can be used by using ingresdate. "Date"
> > as a datatype is ambiguous and so this parameter exists so that date
> > becomes a synonym for ingresdate or ansidate as appropriate.
>
> > In order to set it you'll need to manually edit config.dat or run
>
> > iisetres ii.<hostname>.dbms.*.date_type_alias ingresdate
>
> > then you'll be able to edit it in CBF.
>
> > As for documentation - well it is beta but it's mention in the SQL
> > guide (the chapter on data types) and the issue of ANSI/Ingres dates
> > is mentioned in the release notes. Neither tell you how to set the
> > parameter but that's something that should be fixed before it goes GA.
>
> > Did you intend to run the R2 beta or did you intend to install the GA
> > 2006 (9.0.4)?
>
> > HTH
>
> > --
> > Paul Mason
> > _______________________________________________
> > Info-Ingres mailing list
> > Info-Ing... at kettleriverconsulting.com
> >http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
>
> --
> Jean-Pierre Zuate
> La Fage Conseil
> +33(0)6 11 40 11 09
> jpzu... at gmail.comhttp://www.ingres-ua.fr/sponsors/la-fage-conseil/