Hi Martin,

Thanks for the suggestion but unfortunate neither worked. Its the
strangest thing. Maybe its a Solaris and/or Ingres patch level problem.
Or some other setting.

Any other suggestion would be appreciated - from anyone else.

Thanks again,
David.


-----------------------------------------
David G. Brooks
Systems Consultant
Vision Systems Software
(P.O. Box 804, Bridgetown)
Omega Building - Suite 5
Dayrells Court Business Centre
Dayrells Road
Christ Church BB14030
BARBADOS

URL: http://www.VisionSystemsSoftware.com/

Tel: (246) 431-0193 - Work
(246) 266-8732 - Cel
(246) 436-1417 - Home

Fax: (246) 431-0192 - Work

info-ingres-bounces@kettleriverconsulting.com wrote on 2007-07-24 04:36:28
AM:

> Hi David,
>
> I've tried this on the following....
> II 2.6/0604 (int.lnx/00) + patch11814
> II 2.6/0604 (axp.osf/00) + patch11810
> II 3.0.3 (a64.lnx/211) + patch11577
> II 9.0.4 (a64.lnx/105)NPTL + patch12125
>
> The copy works correctly (ie, 6's and 1's in the qty field) in all
cases.
>
> So I have no idea why your getting the strange results you've seen.
>
> Could I suggest trying the following....
> 1. Alter the data file to use a different date format. For example use a

> text editor to translate 2007-05-02 to 2007.05.02. Then run your copy in

> script with II_DATE_FORMAT=US or MULTINATIONAL4 rather than
> SWEDEN (or YMD)
>
> 2. Try dropping the trailing comma and then loading the data with
> pick_date=c0nl.
>
> Best of luck,
>
> Martin Bowes
>
> _______________________________________________
> Info-Ingres mailing list
> Info-Ingres@kettleriverconsulting.com
> http://www.kettleriverconsulting.com...fo/info-ingres
>
>
>
> --
> This message has been scanned for viruses and dangerous content by
> Sunbeach, and is believed to be clean.
>
>

Information in this electronic e-mail is confidential and may be legally
privileged. It is intended solely for the addressee.
If you have received this e-mail message in error, please notify us
immediately and destroy or delete the message from
your computer.

If you are the intended recipient, any form of reproduction,
dissemination,
copying, disclosure, modification, distribution
and/or publication of this e-mail unless authorised is strictly prohibited
and may be unlawful.

Please rely on your own virus checker and procedures with regard to any
attachments to this message.