RE: uvsql
a. yes b. no c. yes and no d. yes 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 _ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Sunday, February 08, 2004 8:53 AM To: 'U2 Users Discussion List' Subject: RE: uvsql Barry, Just to eliminate the obvious: A) is your file pointer correct in the uvsql account? B) are there any indexes on the file that may be looking at the wrong location? C) are the DATA.30 and OVER.30 files set up with the same permissions? Is there any chance you might not be seeing the OVER.30? D) your UNIX cp included the .Type30 file. Brian Leach - Original Message - From: "Barry Rogen" <[EMAIL PROTECTED]> Date: Fri, 6 Feb 2004 07:59:32 -0500 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 email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users 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
RE: uvsql
I was trying to avoid the UniVerse level of copy - since the file in question has over a million records. I was trying in Unix (cp) to take advantage of the speed I would realize. The ULIMIT is set to 128000 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 _ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Saturday, February 07, 2004 5:26 PM To: U2 Users Discussion List Subject: Re: uvsql What kind of UNIX, and what cp options are you using? Clearly if you're getting some of the file there permissions aren't an issue, but is the file system where your uvsql is filling or is there a quota or are you reaching your ulimit setting (maximum size of a UNIX file that you can create)? The uv command - among other things - raises ulimit; if you're not working within the UniVerse environment maybe your ulimit setting is too low. Use the ulimit command to find out. What happens if you create the UniVerse file in your uvsql account, and use a UniVerse COPY command? - Original Message - From: "Barry Rogen" <[EMAIL PROTECTED]> Date: Fri, 6 Feb 2004 07:59:32 -0500 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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: uvsql
Copying/manipulating UV dynamic files using operating system commands is asking for trouble. Unless you're very careful... A) Check the original dynamic file isn't being updated or isn't open - whilst you were doing the copy. B) Check the target pathname, that the file doesn't exist and isn't open or being updated. I have seen your problem happen, where the destination dynamic files already existed. This causes a mess, as the T30FILE table, still has header file details for the original file and not the one you just overwrote. Hence, UV is very confused at the location or status of the file. You can view open dynamic files, via the UV supplied command "smat -d". Where ever possible, I prefer to have UV shutdown, before manipulating dynamic files with OS commands. Otherwise, do so at your own risk! Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Barry Rogen Sent: Saturday, February 07, 2004 12: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, -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: uvsql
Barry, Just to eliminate the obvious: A) is your file pointer correct in the uvsql account? B) are there any indexes on the file that may be looking at the wrong location? C) are the DATA.30 and OVER.30 files set up with the same permissions? Is there any chance you might not be seeing the OVER.30? D) your UNIX cp included the .Type30 file. Brian Leach - Original Message - From: "Barry Rogen" <[EMAIL PROTECTED]> Date: Fri, 6 Feb 2004 07:59:32 -0500 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 email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: uvsql
What kind of UNIX, and what cp options are you using? Clearly if you're getting some of the file there permissions aren't an issue, but is the file system where your uvsql is filling or is there a quota or are you reaching your ulimit setting (maximum size of a UNIX file that you can create)? The uv command - among other things - raises ulimit; if you're not working within the UniVerse environment maybe your ulimit setting is too low. Use the ulimit command to find out. What happens if you create the UniVerse file in your uvsql account, and use a UniVerse COPY command? - Original Message - From: "Barry Rogen" <[EMAIL PROTECTED]> Date: Fri, 6 Feb 2004 07:59:32 -0500 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
RE: uvsql
Only thing I could think of is ulimit Any ideas why this occurs and how I can get this file into the uvsql directory/account intact ? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: uvsql
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
Re: uvsql and Dynamic files
What's the definition for @ID? Horacio --- Barry Rogen <[EMAIL PROTECTED]> escribió: > >We have an ORDER file in our uvsql account. > This file is > a dynamic file. The select statement below works > fine. > however --- >If I run that same select statement, but use > a q-pointer > to the ORDER file in my production UV account, it > chokes on the > 'LIKE' statement. > > SELECT @ID, F1, F2, F31, F32, F35, F36, F150, > F24 FROM ORDER > > WHERE @ID LIKE '1234567'; > > >The error message is... > > The LIKE operator may only be used with character > data > > > Any ideas will be mucho 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 > _ > > ___ > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users Los mejores usados y las más tentadoras ofertas de 0km están en Yahoo! Autos. Comprá o vendé tu auto en http://autos.yahoo.com.ar ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users