RE: [U2] [UD] Possible causes of corrupt data on a UniData static file

2007-11-02 Thread Burwell, Ed
Kathleene, I wish it were that easy. READNEXT and READ can't get it's hands on these records. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kathleeni M Hunter Sent: Thursday, November 01, 2007 6:34 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2]

RE: [U2] [UD] Possible causes of corrupt data on a UniData static file

2007-11-02 Thread Burwell, Ed
UD 7.1 They are not SELECT statements. They are things like: sort FILENAME THIS THAT TOXML -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Davis Sent: Thursday, November 01, 2007 3:06 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD]

RE: [U2] [UD] Possible causes of corrupt data on a UniData static file

2007-11-02 Thread Burwell, Ed
more issues: guide -U0 filename is now giving me this: GUIDE_ERRORS.LIS: WORK.ORDER File Integrity: Group 11338, block 11339, record number 12 = 970941 is in wrong group, key length 6, hash value 2413 Group 11340, block 11341, record number 12 = 970943 is in wrong

[U2] Haydon Bishop is out of the office.

2007-11-02 Thread haydon . bishop
I will be out of the office starting 02/11/2007 and will not return until 05/11/2007. I will respond to your message when I return. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UD] Possible causes of corrupt data on a UniData static file

2007-11-02 Thread Jeffrey Butera
quote who='Burwell, Ed' date='Friday 02 November 2007' Are there any known issues with UPDATE triggers that write to records that have UPDATE triggers? As long as you don't get into a cycle where trigger A invokes B, B invokes C and then C invokes A. That turns into a nasty infinite loop

RE: [U2] [UD] Possible causes of corrupt data on a UniData static file

2007-11-02 Thread Richard Sammartino
Ed, I have dealt with UniData file corruption in the past and it can be quite difficult to get a handle on it. I have seen files get corrupted by memory failures, processor failures, and disk failures. If this is not due to a hardware issue a file can be corrupted,(or at least used to be corrupted

RE: [U2] [UD] Possible causes of corrupt data on a UniData static file

2007-11-02 Thread Kryka, Richard
[demime could not interpret encoding quoted-printable - treating as plain text] My guess is that you have real records with real Ids that you can access. Then you have other records that appear to have the same Ids but really don't. It sounds like these other records are hashed into the wrong

RE: [U2] Need help connecting to Universe and querying via SQL Server 2005 Management Studio

2007-11-02 Thread Christensen, Steve
You can connect to most any database with adhoc views or a linked server. You'll need the odbc drivers installed but once you have those use openrowset or openquery to create views into the database. Simple Examples: CREATE VIEW [view name here] SELECT Rowset_1.* FROM OPENROWSET('MSDASQL',

RE: [U2] [UD] Possible causes of corrupt data on a UniData static file

2007-11-02 Thread Kathleené M Hunter
Ed, Copy the file and then resize it. That way you can confirm that you have the same information. I had this problem a long time ago and was able to read the records. Kathleeni -Original Message- From: Burwell, Ed [mailto:[EMAIL PROTECTED] Sent: Friday, November 02, 2007 8:11

RE: [U2] [UD] Possible causes of corrupt data on a UniData static file

2007-11-02 Thread Burwell, Ed
Can UniData TRIGGERS be problematic? In the past, I wrote a trigger that would launch a UniData function that would (eventually) generate XML with a UniQuery statement, then POST the XML using submitRequest to a secure site, take the XML that was returned in the RESPONSE.DATA parameter and

RE: [U2] [UD] Possible causes of corrupt data on a UniData static file

2007-11-02 Thread LeRoy Dreyfuss
UV doesn't have guide, but it has uvfixfile and fixtool. Regards, LeRoy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Arnold Bosch Sent: Friday, November 02, 2007 3:53 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UD] Possible causes of

[U2] Periodic Reminder

2007-11-02 Thread Moderator
All, If you are reading this list through Nabble, Indexfocus, GMane, or any other third party, and want to get a direct feed, you can subscribe using the information found here: http://listserver.u2ug.org/. If you are already subscribed, thank you for your support. If you are