Are your files open when you do this ? Are there any indexes on the file ? You must have the .Type30 file present in the other account. Try with the database closed down. I don't know why this wouldn't work. I do this on non-sql accounts and it works find. When I do the copy, Universe is usually up, but no one is on the account I am copying to. That account is usually a test account and the whole procedure isn't critical. Any ODBC connections active when you do this ? You could try to issue the 'file' command in unix to see who if anything is accessing the file. Is the account on the same machine ? Is NFS involved ? If its non of these things, then I guess its more of a mystery and maybe the file header is getting corrupt ? Anthony Dzikiewicz
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Rogen Sent: Friday, February 06, 2004 8:00 AM To: [EMAIL PROTECTED] Subject: uvsql Question... I have a file, my live ORDER (type 30) file. Via unix, I copy this file to my test account - copy is fine, all records there - no problem If I take that same file, and move it to my uvsql account, all I get is a fraction of the file. I have tried this twice and got same results. Any ideas why this occurs and how I can get this file into the uvsql directory/account intact ? All comments appreciated, Barry Rogen Senior Programmer PNY Technologies (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] _________________________________ The quality of a person's life is in direct proportion to their commitment to excellence regardless of their chosen field of endeavor vince lombardi _________________________________ This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
