Re: [U2] U2 University New York [not-secure]
Yeah, I'll be at the NY U2U as well. I'm going 5 for 5. :) Sign me, Susan U2 Groupie Joslyn (sorry to nab your thing, Chuck.) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Good bye and good luck
REPOSTED FOR NON-MEMBER:Michael Logue [EMAIL PROTECTED]ext/plain After 22 years in the MV world, a new opportunity has come up within IBM that I will be pursuing. As such, I will be unsubscribing from this list. While I've not done a lot of posting to these forums (I leave that to Wally!), I have read almost every post going back almost 10 years, when Clif was hosting this list. I've learned a lot about what UniVerse and UniData can do from the folks here, and while my new role isn't technical in nature, there were lots of other lessons to be gleaned 'between the lines' of these posts. Good luck to everyone in their future MV endeavors! P. Michael Logue U2 Technical Support Engineer U2 Products Service Planner IBM Information Management Division, Software Group Phone: 303-773-7846 Tie Line: 656-7846 Email: [EMAIL PROTECTED] www.ibm.com/software/data/u2/support Open, Query, Update, Search - Online! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Good bye and good luck
Congrats Michael, all the best. Thanks for your labors and contributions. (Should we talk to Wally or Susie about applying for your job?) [It's just a joke!]{well, sorta} Seriously - hope it goes great in your new IBM unit. -Baker snip After 22 years in the MV world, a new opportunity has come up within IBM that I will be pursuing. As such, I will be unsubscribing from this list. While I've not done a lot of posting to these forums (I leave that to Wally!), I have read almost every post going back almost 10 years, when Clif was hosting this list. I've learned a lot about what UniVerse and UniData can do from the folks here, and while my new role isn't technical in nature, there were lots of other lessons to be gleaned 'between the lines' of these posts. Good luck to everyone in their future MV endeavors! P. Michael Logue U2 Technical Support Engineer /snip --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] Possible causes of corrupt data on a UniData static file
Hello, I have been getting corrupt data lately. Stuff like this: sort: warning: first character of the record is '\0' discard it! sort: warning: the record contain '\0' character, discard it! sort: warning: the record contain '\0' character, discard it! sort: warning: the record contain '\0' character, discard it! sort: warning: the record contain '\0' character, discard it! sort: warning: the record contain '\0' character, discard it! sort: warning: the record contain '\0' character, discard it! Are there any programming no-no's that could cause stuff like this, for instance: 1. Putting logic in an UPDATE trigger that calls a UniData function that run a UniQuery statement that creates XML, then writes that XML to a file (to be HTTP transmitted later by a separate background task). 2. Putting logic in an UPDATE trigger that compares the prior record to the one about to be written, then updates a log file if the records are different. 3. Four separate indexes on a file. I'm getting desperate. Any help would be GREATLY appreciated! Thanks. Ed __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- 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
What unidata version? What SELECT .. BY statement were you using. Are the BY fields actually stored in the file, or are they I-types that tran to another file? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Ed Sent: Thursday, November 01, 2007 2:36 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Possible causes of corrupt data on a UniData static file Hello, I have been getting corrupt data lately. Stuff like this: sort: warning: first character of the record is '\0' discard it! sort: warning: the record contain '\0' character, discard it! sort: warning: the record contain '\0' character, discard it! sort: warning: the record contain '\0' character, discard it! sort: warning: the record contain '\0' character, discard it! sort: warning: the record contain '\0' character, discard it! sort: warning: the record contain '\0' character, discard it! Are there any programming no-no's that could cause stuff like this, for instance: 1. Putting logic in an UPDATE trigger that calls a UniData function that run a UniQuery statement that creates XML, then writes that XML to a file (to be HTTP transmitted later by a separate background task). 2. Putting logic in an UPDATE trigger that compares the prior record to the one about to be written, then updates a log file if the records are different. 3. Four separate indexes on a file. I'm getting desperate. Any help would be GREATLY appreciated! Thanks. Ed __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- 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
UniBasic does not prevent you from writing out a record or ID with char(0) imbedded. It is a legal character. No guesses as to the cause of your particular issue. To assist in diagnosis, you can search your problem file for all occurances of char(0) in data records or keys using an option on 'guide'. For instance: guide -U0 PROBLEM.FILE.NAME option is -U followed by the ascii charcter number you want to search for. Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] Register today for the premier U2 technical event! Burwell, Ed [EMAIL PROTECTED] omTo Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] [UD] Possible causes of 11/01/2007 12:35 corrupt data on a UniData static PMfile Please respond to [EMAIL PROTECTED] er.u2ug.org Hello, I have been getting corrupt data lately. Stuff like this: sort: warning: first character of the record is '\0' discard it! sort: warning: the record contain '\0' character, discard it! sort: warning: the record contain '\0' character, discard it! sort: warning: the record contain '\0' character, discard it! sort: warning: the record contain '\0' character, discard it! sort: warning: the record contain '\0' character, discard it! sort: warning: the record contain '\0' character, discard it! Are there any programming no-no's that could cause stuff like this, for instance: 1. Putting logic in an UPDATE trigger that calls a UniData function that run a UniQuery statement that creates XML, then writes that XML to a file (to be HTTP transmitted later by a separate background task). 2. Putting logic in an UPDATE trigger that compares the prior record to the one about to be written, then updates a log file if the records are different. 3. Four separate indexes on a file. I'm getting desperate. Any help would be GREATLY appreciated! Thanks. Ed __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/jpeg which had a name of 25739582.jpg] [demime 1.01d removed an attachment of type image/jpeg which had a name of 25465054.jpg] [demime 1.01d removed an attachment of
Re: [U2] [UD] Possible causes of corrupt data on a UniData static file
I wrote previously: UniBasic does not prevent you from writing out a record or ID with char(0) imbedded. It is a legal character. No guesses as to the cause of your particular issue. To assist in diagnosis, you can search your problem file for all occurances of char(0) in data records or keys using an option on 'guide'. For instance: guide -U0 PROBLEM.FILE.NAME option is -U followed by the ascii charcter number you want to search for. I should add that the information about characters found is in GUIDE_ERRORS.LIS. For instance: guide -U65 VOC (looking for 'A') pg GUIDE_ERRORS.LIS VOC File Integrity: Group 0, block 1, record number 0 = COL.SPACES has char(65) in key. Group 0, block 1, record number 1 = LIST.LABEL has char(65) in key. Group 0, block 1, record number 7 = STATS has char(65) in key. Group 0, block 1, record number 0 = COL.SPACES record has char(65) in data. Group 0, block 1, record number 1 = LIST.LABEL record has char(65) in data. ... (many more entries) Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] Register today for the premier U2 technical event! [demime 1.01d removed an attachment of type image/jpeg which had a name of 08633156.jpg] [demime 1.01d removed an attachment of type image/jpeg which had a name of 08907059.jpg] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Need help connecting to Universe and querying via SQL Server 2005 Management Studio
I need to run ad-hoc queries against a Universe database from SQL Server 2005. I'm using Management Studio (formerly Query Analyzer). I can connect to Universe via MS Excel and obtain query results, but am struggling with how to query via SQL Server. Do I need to set up the universe database as a linked server? If anyone knows how to do that, I sure could use some help! Thanks, vcarson --- 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
Basic program read record, check id for char (o), if there get new id, write record with new id and delete old record. -Original Message- From: Wally Terhune [mailto:[EMAIL PROTECTED] Sent: Thursday, November 01, 2007 2:14 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UD] Possible causes of corrupt data on a UniData static file I wrote previously: UniBasic does not prevent you from writing out a record or ID with char(0) imbedded. It is a legal character. No guesses as to the cause of your particular issue. To assist in diagnosis, you can search your problem file for all occurances of char(0) in data records or keys using an option on 'guide'. For instance: guide -U0 PROBLEM.FILE.NAME option is -U followed by the ascii charcter number you want to search for. I should add that the information about characters found is in GUIDE_ERRORS.LIS. For instance: guide -U65 VOC (looking for 'A') pg GUIDE_ERRORS.LIS VOC File Integrity: Group 0, block 1, record number 0 = COL.SPACES has char(65) in key. Group 0, block 1, record number 1 = LIST.LABEL has char(65) in key. Group 0, block 1, record number 7 = STATS has char(65) in key. Group 0, block 1, record number 0 = COL.SPACES record has char(65) in data. Group 0, block 1, record number 1 = LIST.LABEL record has char(65) in data. ... (many more entries) Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] Register today for the premier U2 technical event! [demime 1.01d removed an attachment of type image/jpeg which had a name of 08633156.jpg] [demime 1.01d removed an attachment of type image/jpeg which had a name of 08907059.jpg] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Good bye and good luck
I imagine a lot of people on this list have sat in one of your classrooms. Congratulations on the new job! Thanks, David A. Green www.dagconsulting.com (480) 813-1725 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Moderator Sent: Thursday, November 01, 2007 9:35 AM To: u2-users@listserver.u2ug.org Subject: [U2] Good bye and good luck REPOSTED FOR NON-MEMBER:Michael Logue [EMAIL PROTECTED]ext/plain After 22 years in the MV world, a new opportunity has come up within IBM that I will be pursuing. As such, I will be unsubscribing from this list. While I've not done a lot of posting to these forums (I leave that to Wally!), I have read almost every post going back almost 10 years, when Clif was hosting this list. I've learned a lot about what UniVerse and UniData can do from the folks here, and while my new role isn't technical in nature, there were lots of other lessons to be gleaned 'between the lines' of these posts. Good luck to everyone in their future MV endeavors! P. Michael Logue U2 Technical Support Engineer U2 Products Service Planner IBM Information Management Division, Software Group Phone: 303-773-7846 Tie Line: 656-7846 Email: [EMAIL PROTECTED] www.ibm.com/software/data/u2/support Open, Query, Update, Search - Online! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- 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
Is guide only available on UD ? It does not work with UV (10.0). Is there a similar command available in UV? Thanks! Arnold Bosch IT Administrator Taeuber Corssen SWA (Pty) Ltd Tel +264 (0)61 293 2106 Cell +264 (0)81 124 8625 Fax +264 (0)61 293 2104 Email: [EMAIL PROTECTED] -- [EMAIL PROTECTED] wrote on 01/11/2007 23:14:16: I wrote previously: UniBasic does not prevent you from writing out a record or ID with char(0) imbedded. It is a legal character. No guesses as to the cause of your particular issue. To assist in diagnosis, you can search your problem file for all occurances of char(0) in data records or keys using an option on 'guide'. For instance: guide -U0 PROBLEM.FILE.NAME --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/