[U2] Jeremy Woods/WA/QBE/Insurance is out of the office.

2004-12-17 Thread Jeremy Woods
I will be out of the office starting 17/12/2004 and will not return until 20/12/2004. I will respond to your message when I return. IMPORTANT NOTICE : The information in this email is confidential and may also be

RE: [U2] PE downloads have been pulled from IBM's site

2004-12-17 Thread Wendy Smoak
From: [EMAIL PROTECTED] I'm not sure how different they are - they hadn't been changed in a while. The windows version is a simple setup.exe install. Here are some hints for installing on Linux: http://www.pickwiki.com/cgi-bin/wiki.pl?Redhat8UD6PEInstallInfo -- Wendy Smoak ---

Re: [U2] Data Corruption

2004-12-17 Thread Allen Egerton
From: Brutzman, Bill [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 17, 2004 10:56 AM Subject: [U2] Data Corruption There lives a new record in our OP table that shows up as INVISIBLE from a TCL prompt. snip Suggestions would be appreciated. If your OP table isn't too large,

Re: [U2] Data Corruption

2004-12-17 Thread Wally Terhune
UniData? UniVerse? Version? I can supply some hints if UniData. Wally Terhune Manager - U2 Advanced Technical Services IBM DB2 Information Management Software Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search -

RE: [U2] Data Corruption

2004-12-17 Thread Marilyn Hilb
Can you select it? If you can select it then you can do a tcl delete on it. I've had to get rid of null records this way. SELECT A.FILE = 1 ITEM SELECTED DELETE A.FILE Test this first make sure I have the commands right. I am always paranoid using the delete command. Thanks, Marilyn

RE: [U2] Data Corruption

2004-12-17 Thread Brutzman, Bill
The problem is on our UniVerse v8.3.3 HP-UX box. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wally Terhune Sent: Friday, December 17, 2004 11:24 AM To: [EMAIL PROTECTED] Subject: Re: [U2] Data Corruption UniData? UniVerse? Version? I can supply

RE: [U2] Data Corruption

2004-12-17 Thread Anthony Dzikiewicz
This might be the long way but something like; SELECT OP WITH @ID GT 'SOMEVALUE TO SELECT ALL BUT THE BAD REC' TO A SELECT OP TO B GET.LIST A TO 1 GET.LIST B TO 2 MERGE.LIST 2 DIFF 1 TO 0 SAVE.LIST C ;* should be just the bad record here GET.LIST C COPY FROM OP TO HOLD OVW DELETING Anthony

RE: [U2] Data Corruption

2004-12-17 Thread Alfke, Colin
We have a NULL save list that we do a get-list and then edit with (if the key is null). If it's not actually null and there aren't too many records you could just ED OP * and go through them all until you find it. Of course, this assumes that there is no actual corruption of the file. In UD

RE: [U2] Data Corruption

2004-12-17 Thread Les Hewkin
Edit the record and delete it. To be able to edit the record sselect the file first. this is how I do it Hope this help Les -Original Message- From: Brutzman, Bill [mailto:[EMAIL PROTECTED] Sent: 17 December 2004 15:56 To: '[EMAIL PROTECTED]' Subject: [U2] Data Corruption There lives

Re: [U2] Data Corruption

2004-12-17 Thread Robert Stearns
You might try SELECT OP WITH @ID=' ', followed by a DELETE. If that don't work then try SELECT OP WITH @ID'~', followed by a DELETE. That gets rid of all keys with a leading character outside the printable ASCII set, and may get rid of your mysterious record. Allen Egerton wrote: From:

RE: [U2] Data Corruption

2004-12-17 Thread Wendy Smoak
Brutzman, Bill There lives a new record in our OP table that shows up as INVISIBLE from a TCL prompt. Is it just a null key? Does: :SELECT FILE.NAME WITH NO @ID return anything? The only way I've been able to delete items with weird keys is to get them into a select list. Sometimes

RE: [U2] Data Corruption

2004-12-17 Thread Paul Trebbien
Every once in a while on the old PICK systems I would run into a record with a value mark in the ID. You couldn't just edit or delete it so what I'd do is to select the record and with it as the only item in the list I could then delete it. These days, my users sometimes end up with a null ID in

RE: [U2] Data Corruption

2004-12-17 Thread Tom Dodds
You might try doing a SSELECT OP and the ED OP to see if the bad one comes up or then do a SELECT OP BY-DSND @ID and an ED OP to see if it is at the other end of the spectrum. If all of that fails do a SSELECT OP with a SAVE.LIST JUNK then EDIT.LIST JUNK and so searching. hth Tom Dodds [EMAIL

RE: [U2] Data Corruption

2004-12-17 Thread Brutzman, Bill
Victory...Wendy's fix nailed it... SELECT OP WITH NO @ID DELETE OP Thanks to all those who responded. --Bill --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Data Corruption

2004-12-17 Thread Bob Woodward
As another option to try, write a program that uses the BASIC SELECT statement, not the TCL SELECT. This way the program will step through the group, grabbing each record ID one by one. After the READNEXT, test for a key length not equal zero. This will handle a null key condition. Next, do a

RE: [U2] Data Corruption

2004-12-17 Thread FFT2001
Bob Woodward [EMAIL PROTECTED] wrote: As another option to try, write a program that uses the BASIC SELECT statement, not the TCL SELECT. This way the program will step through the group, grabbing each record ID one by one. After the READNEXT, test for a key length not equal zero. This will

[U2] [UD]WRITESEQ quirkiness

2004-12-17 Thread Dana Baron
Here's a puzzler: what is it that causes the ELSE clause to be executed in a WRITESEQ block when the only apparent change is the content of the data to be written. I've included a section of code below followed by the output from two subsequent calls. In the first, the code executes the THEN

RE: [U2] [UD]WRITESEQ quirkiness

2004-12-17 Thread Kevin King
How big exactly is the block of data you're trying to write? There is no limit to each WRITESEQ (that I am aware of) but OS file size limitations do apply. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dana Baron Sent: Friday, December 17, 2004 11:11

RE: [U2] [UD]WRITESEQ quirkiness

2004-12-17 Thread Allen E. Elwood
Hi Dana, Well, you're setting OK_TO_CONTINUE but never checking it... Maybe something there. Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dana Baron Sent: Friday, December 17, 2004 10:11 To: U2-Users (E-mail) Subject: [U2] [UD]WRITESEQ

[U2] INCLUDE or $INCLUDE

2004-12-17 Thread Peter Gonzalez
Good day! We created a duplicate account of our live system. The new account has our programs and data files. We have a problem with the way programs are executed. Programs with $INCLUDE work fine. Programs with INCLUDE bomb out!We are clueless as to what's going on. My understanding

RE: [U2] [UD]WRITESEQ quirkiness

2004-12-17 Thread Dana Baron
Hi Kevin, Thanks for the reply. The data to be written is not very big. Its shown below. It is HEX data, don't know if that makes a difference. This has been working fine but suddenly its not, but only for one type of message, and I don't know what changed. These are the messages that I'm writing

RE: [U2] [UD]WRITESEQ quirkiness

2004-12-17 Thread Alfke, Colin
I've written some pretty big records/files with writeseq that I don't think you're coming anywhere close to. I use the else to notify me in case the system (writeseq append) isn't at the end of the file where I think it should be. Help says that: ELSE executes if the WRITESEQ is not

RE: [U2] INCLUDE or $INCLUDE

2004-12-17 Thread Larry Hiscock
Could this be something like the difference between $INCLUDE and $INSERT ? As I recall, $INCLUDE takes a pathname, whereas $INSERT takes a DIR name and a record ID $INCLUDE /u/source/somefile vs. $INSERT SOURCE somefile (Where SOURCE is a DIR pointer in the VOC file pointing to /u/source) If

RE: [U2] [UD]WRITESEQ quirkiness

2004-12-17 Thread Allen E. Elwood
As long as there is a valid file/id names. My point is that unless you are checking OK_TO_CONTINUE you'll never know if maybe the filename is in a write protected status or some other normally unforeseeable condition. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

[U2] Jeremy Woods/WA/QBE/Insurance is out of the office.

2004-12-17 Thread Jeremy Woods
I will be out of the office starting 17/12/2004 and will not return until 20/12/2004. I will respond to your message when I return. IMPORTANT NOTICE : The information in this email is confidential and may also be

[U2] James Ronan/IIG/Prudential is out of the office.

2004-12-17 Thread james . ronan
I will be out of the office starting 12/16/2004 and will not return until 01/03/2005. Please contact Tricia Shelly x 6531 in my absence. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] INCLUDE or $INCLUDE

2004-12-17 Thread Thomas Derwin
Is BASICTYPE set the same on both? UD supports 4 different parsers: U, P, R or M. From the ECL prompt, BASICTYPE by itself will tell you which flavor the account is set to. If that's OK, I'd compare the UDT.OPTIONS settings. From the ECL prompt, UDT.OPTIONS by itself will display them all for

RE: [U2] INCLUDE or $INCLUDE

2004-12-17 Thread Larry Hiscock
-Original Message- Yes. same VOC same login.All UDT.OPTIONS the same. Funny thing is that the new account has been working for weeks. Today, for no reason it decided that it need the $INCLUDE. -- Ah, but that's just it ... It wasn't for no reason. What's

RE: [U2] INCLUDE or $INCLUDE

2004-12-17 Thread Marilyn Hilb
I seem to remember on Unidata that you could also change the basictype 'on the fly' in the individual program. Could it be the changing of the basictype in the program(s) was added or removed? Thanks, Marilyn A. Hilb Value Part, Inc Direct: 847-918-6099 Fax: 847-367-1892 [EMAIL PROTECTED]

RE: [U2] [UD]WRITESEQ quirkiness

2004-12-17 Thread FFT2001
Right I agree with Allen that you should maybe check whether the OPEN was successful. If it was NOT when the file SHOULD exist then you have some problem. Perhaps the file is not getting released by some process and so is not in an available state to be re-opened ? It might be a timing