[Info-Ingres] DATE_TYPE_ALIAS is not found

[Jean-Pierre Zuate]

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 <latepaul at gmail.com>:
>
> On 16 Jan 2007 09:31:32 -0800, izena at mixmail.com <izena 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-Ingres at kettleriverconsulting.com
> http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
>



-- 
Jean-Pierre Zuate
La Fage Conseil
+33(0)6 11 40 11 09
jpzuate at gmail.com
http://www.ingres-ua.fr/sponsors/la-fage-conseil/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.kettleriverconsulting.com/mailman/private/info-ingres/attachments/20070323/bd4e7e57/attachment.html