RE: [U2] Index problem

2004-11-05 Thread Doyen Klein
Hey thanks Charles! 
That did look like my old cheat-sheet, now ...

I found the manual for uv on IBM site
(http://publibfi.boulder.ibm.com/epubs/pdf/25119270.pdf)

It doesn't offer any more info that what you posted (and took a lot longer
to download :-) . 

Any where I can find ...

1. a more detailed internals description of processor mode and dispatch
type?

2. if this information is different for Unidata? (the unidata doc didn't
seem to refer to more than two lines of the VOC entry for Verbs.

3. Does the flavor (information vs pick) override the dispatch/mode, the
dispatch/mode override the flavor or something entirely different?

Thanks again for the listing. I

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:owner-u2-
 [EMAIL PROTECTED] On Behalf Of Stevenson, Charles
 Sent: Thursday, November 04, 2004 4:17 PM
 To: [EMAIL PROTECTED]
 Subject: RE: [U2] Index problem
 
 Oops, the chart spilled over to pg 3-16, so I fixed it below.
 cds
 
 -Original Message-
 From: Stevenson, Charles
 Sent: Thursday, November 04, 2004 3:10 PM
 To: '[EMAIL PROTECTED]'
 Subject: RE: [U2] Index problem
 
 From:  Doyen Klein
 
 Can someone post or point to the doc which describes all the convoluted
 and obscure things one can do when one changes these letters?
 
 Doyen,
 
 Here's a raw cutpaste from adobe reader from sysdesc.pdf, System
 Description, UV10, pg 3-15,16 :
 
 processor mode is used by the command processor to perform the required
 setup before executing the verb. It can be one or more of the following
 codes:
 
 Code Processor Mode
 A Alternate query syntax
 B not used
 C External program COMO
 D Pass DATA to subprocess
 E Use Win32 expansion routine (Windows NT only)
 F Pass format via environment variable
 G Allowed in an SQL CALL statement
 H EXECUTE and PERFORM can use in a transaction
 I Interrupt control
 K Keep select list
 M Maps EXECUTE output to internal character set
 (NLS only)
 N Does not set @SYSTEM.RETURN.CODE
 P Parenthetical options are available
 Q SQL mode
 R Backslashes ( \ ) can be used to quote strings
 S Use select list
 T Terminal mode change
 U Add pathname of the UV account directory before
 processor name
 V Function specified by field 5
 X Read DATA if a select list is active
 
 The rest of the attributes for V-items are described in the same
 section, as are other VOC types beside V-items.
 ---
 u2-users mailing list
 [EMAIL PROTECTED]
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Index problem

2004-11-04 Thread Doyen Klein
I recently suspected that these mystery letters might help solve my mlist
not found problem, but I misplaced my cheat-sheet (It was universe anyway)

Can someone post or point to the doc which describes all the convoluted and
obscure things one can do when one changes these letters?


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:owner-u2-
 [EMAIL PROTECTED] On Behalf Of Stevenson, Charles
 Sent: Thursday, November 04, 2004 1:44 PM
 To: [EMAIL PROTECTED]
 Subject: RE: [U2] Index problem

 In Universe the VOC V-item for XSELECT points to a catalogued basic
 program and has a K in 4, meaning keep select list active when done
 executing.  I don't know how UD handles this.
 
 
 u2-users mailing list
 [EMAIL PROTECTED]
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Cannot access list ML_3516_1 Unidata phantom (MERGE.LIST)

2004-11-03 Thread Doyen Klein
Update: The program only failed when it included an open along with the
MERGE.LIST command. The work-around, is to create a separate process which
is phantom'd by the first phantom, this second process does the SAVE.LIST
which the first process can read.

No one has ever explained where the MERGE.LIST and OPEN are colliding in the
phantom session when they aren't in the TCL session. 

 -Original Message-
 Question: what is the setup for the phantom environment to make the
 program
 work the same way it does from tcl? I've looked a several UDT.OPTIONS but
 can't seem to uncover the secret key.
 
 WinNT, Unidata a Paragraph (PH) works fine from tcl, but when executed by
 a
 phantom'd basic program the merge.list command within the paragraph seems
 to
 fail with the message 'Can not access list ML3516_1.'
 
 The output from the _ph_ file when it fails.
 
 169 key(s) saved to 1 record(s)
 163 records retrieved to list 1
 169 records retrieved to list 2
 Can not access list ML3516_1.
 The environment is 'p', but the program uses UDTEXECUTE PARTSLISTS and
 UDTEXECUTE GET.LIST DIFFLIST
 
 The second pass, all the selects seem to fail and come up with 0 records
 selected.
 
 Notes: WinNT, Unidata, P environment
 
 The program works fine when run from tcl, but not when phantomed.
 The login checks the @USER.TYPE and bypasses any login setup info.
 The program has $BASICTYPE u, and does a UDTEXECUTE 'ECLTYPE U' as
 well
 The paragraph contains ECLTYPE U as the first line.
 
 The paragraph which works fine from tcl or udtexecute a program run from
 tcl.
 
 001: PA
 002: ECLTYPE U
 003: BASICTYPE U
 004: SSELECT ITMMST
 005: SAVE.LIST NEWPARTS
 006: GET.LIST OLDPARTS TO 1
 007: GET.LIST NEWPARTS TO 2
 008: MERGE.LIST 2 DIFF 1
 009: SAVE.LIST DIFFPARTS
 010: GET.LIST NEWPARTS
 011: SAVE.LIST OLDPARTS
 
 
 
 Clue: I have also been getting a strange
 stat ITMMST message and open fails when I try to open a file the second
 time, even though I closed it. Currently doings an OPEN ,ITMMST
 READONLY
 TO PFILE
 ---
 u2-users mailing list
 [EMAIL PROTECTED]
 To unsubscribe please visit http://listserver.u2ug.org/
 
 [demime 1.01d removed an attachment of type image/gif which had a name of
 graycol.gif]
 
 [demime 1.01d removed an attachment of type image/gif which had a name of
 pic07704.gif]
 
 [demime 1.01d removed an attachment of type image/gif which had a name of
 ecblank.gif]
 ---
 u2-users mailing list
 [EMAIL PROTECTED]
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Cannot access list ML_3516_1 Unidata phantom (MERGE.LIST)

2004-11-01 Thread Doyen Klein
Not user what you're getting at here, but the phantom user name is the same
as the terminal user name. and it stays the same throughout the process.

Don't know what you would think would change about permissions, but they are
4 and I am opening the file with the READONLY mode, just for kicks. No need
to write out records, just reading.

I did setup a different voc pointer for the select, no difference there.

The idea of coping the parts file every few minutes is not a pretty thought,
and if you can't do a mergelist, what make you think you can clear a file
and copy records? The real solution is to find out what is wrong with
mergelist or re-write the mergelist functionality, it holding the list of
record id's in memory from pass to pass.

(and I thought Nov in Los Angeles was cold)

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:owner-u2-
 [EMAIL PROTECTED] On Behalf Of Alfke, Colin
 Sent: Monday, November 01, 2004 9:21 AM
 To: [EMAIL PROTECTED]
 Subject: RE: [U2] Cannot access list ML_3516_1 Unidata phantom
 (MERGE.LIST)
 
 You can use @LOGNAME to get the NT user that the phantom is logged in as.
 
 Do you really need to open the same file as the select? You can use
 fileinfo after you open it to show your permissions on it.
 
 What if you tried setting up a different VOC entry for that file? Maybe
 (but I doubt it) you could fool it. What about copying the items into a
 temp file and doing the open there?
 
 hth
 
 Colin Alfke
 back in chilly Calgary
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Cannot access list ML_3516_1 Unidata phantom (MERGE.LIST)

2004-11-01 Thread Doyen Klein
Thanks Wally, that was the original report, this system is 6+ but I have a
feeling that because it's pick flavor the issue may still be alive.

The IBM tech support is aware but I haven't gotten any tech specifics about
the original problem.

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:owner-u2-
 [EMAIL PROTECTED] On Behalf Of Wally Terhune
 Sent: Monday, November 01, 2004 10:29 AM
 To: [EMAIL PROTECTED]
 Subject: Re: [U2] Cannot access list ML_3516_1 Unidata phantom
 (MERGE.LIST)
 
 UniData version and specific Windows platform?
 There was a Windows-specific problem with MERGE.LIST fixed in 5.2.35.
 Can't
 tell if it applies or not.
 
 Wally Terhune
 Manager - U2 Advanced Technical Services
 IBM DB2 Information Management Software
 Tel: 303.294.4866 Fax: 303.294.4832
 [EMAIL PROTECTED]
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Cannot access list ML_3516_1 Unidata phantom (MERGE.LIST)

2004-10-29 Thread Doyen Klein
Well suggested Charles and Colin .

I had tried all lowercase knowing of the Pick flavor issue, but went with
Colin's gET.LIST just for fun, Doesn't' work on the paragraph name
(pARTLISTS is 'not found' but gET.LIST works just a well (or as poorly) as
GET.LIST did.

Charles, excellent idea, you can see from the _PH_ I am now getting
DELETE.LIST failed. I'm convinced it's some sort of system common issue from
the mysterious 'stat ITMST failed.' message. 

224: Executing PARTSLISTS   
225: DELETE.LIST 2956 failed.   
226: stat ITMMST failed.
227: Open file error.   
228: No active select list, creating empty saved list.  
229: No record retrieved.   
230: 0 records retrieved to list 1. 
231: No record retrieved.   
232: 0 records retrieved to list 2. 
233: 0 record(s) selected.  
234: No active select list, creating empty saved list.  
235: No record retrieved.   
236: 0 records retrieved to list 0. 
237: No active select list, creating empty saved list.  
238: Executing GET.LIST DIFFPARTS   
239: No record retrieved.   
240: 0 records retrieved to list 0. 
241: 0 items on select list 
242: Executing PARTSLISTS   
243: DELETE.LIST 2956 failed.   
244: stat ITMMST failed.
245: Open file error.   
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Cannot access list ML_3516_1 Unidata phantom (MERGE.LIST)

2004-10-29 Thread Doyen Klein
I've wondered about that. As an update, a simple program that just
udtexecutes the selects seems to work. If the program opens the same file as
the select, the second select doesn't work. If the program opens and then
closes the file, the time it tries to open, it fails.

All of these examples work ok from tcl so it's not an simple programming
bug. The user shows that same name as the login id, so I wouldn't think (but
could be wrong) that the 'phantom' process has different rights than the
terminal process (Don't know how this is implemented in Windows, in *nx I
could do some testing)

I think it's how the open files are kept in a 'system' common area.

Btw: I even tried the OPEN READONLY in hopes that it would work. No dice.

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:owner-u2-
 [EMAIL PROTECTED] On Behalf Of Alfke, Colin
 Sent: Friday, October 29, 2004 1:11 PM
 To: [EMAIL PROTECTED]
 Subject: RE: [U2] Cannot access list ML_3516_1 Unidata phantom
 (MERGE.LIST)
 
 Perhaps it's the user you're running the phantom as. Maybe there is a
 permission issue in the list directory.
 
 Hth
 Colin
 
 -Original Message-
 From: Doyen Klein [mailto:[EMAIL PROTECTED]
 
 Well suggested Charles and Colin .
 
 I had tried all lowercase knowing of the Pick flavor issue, but went
 with Colin's gET.LIST just for fun, Doesn't' work on the paragraph name
 (pARTLISTS is 'not found' but gET.LIST works just a well (or as poorly)
 as GET.LIST did.
 
 Charles, excellent idea, you can see from the _PH_ I am now getting
 DELETE.LIST failed. I'm convinced it's some sort of system common issue
 from the mysterious 'stat ITMST failed.' message.
 
 224: Executing PARTSLISTS
 225: DELETE.LIST 2956 failed.
 226: stat ITMMST failed.
 227: Open file error.
 ---
 u2-users mailing list
 [EMAIL PROTECTED]
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Cannot access list ML_3516_1 Unidata phantom (MERGE.LIST)

2004-10-28 Thread Doyen Klein
I did, in fact, originally each select was an individual UDTEXECUTE line. It
makes no difference, the first time through the loop, it works, after than
from within a phantom, no selects or mergelist work. The identical program
run from TCL works just fine. There is no difference in the out from
executing each select line from within the program or executing them all as
a paragraph, you still see everything in the _ph_ file.

I'm wondering if a PQ proc might behave differently?

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:owner-u2-
 [EMAIL PROTECTED] On Behalf Of Kathleeni M Bodine
 Sent: Wednesday, October 27, 2004 3:26 PM
 To: [EMAIL PROTECTED]
 Subject: RE: [U2] Cannot access list ML_3516_1 Unidata phantom
 (MERGE.LIST)
 
 Why dont you do a basic program with the UDTEXECUTE capturing all output
 and display the output to the screen. Then read the record in the phantom
 (_PH_) file and see what the problem is.
 
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Doyen Klein
 Sent: Tuesday, October 26, 2004 8:14 AM
 To: [EMAIL PROTECTED]
 Subject: [U2] Cannot access list ML_3516_1 Unidata phantom (MERGE.LIST)
 
 Question: what is the setup for the phantom environment to make the
 program
 work the same way it does from tcl? I've looked a several UDT.OPTIONS but
 can't seem to uncover the secret key.
 
 WinNT, Unidata a Paragraph (PH) works fine from tcl, but when executed by
 a
 phantom'd basic program the merge.list command within the paragraph seems
 to
 fail with the message 'Can not access list ML3516_1.'
 
 The output from the _ph_ file when it fails.
 
 169 key(s) saved to 1 record(s)
 163 records retrieved to list 1
 169 records retrieved to list 2
 Can not access list ML3516_1.
 The environment is 'p', but the program uses UDTEXECUTE PARTSLISTS and
 UDTEXECUTE GET.LIST DIFFLIST
 
 The second pass, all the selects seem to fail and come up with 0 records
 selected.
 
 Notes: WinNT, Unidata, P environment
 
 The program works fine when run from tcl, but not when phantomed.
 The login checks the @USER.TYPE and bypasses any login setup info.
 The program has $BASICTYPE u, and does a UDTEXECUTE 'ECLTYPE U' as
 well
 The paragraph contains ECLTYPE U as the first line.
 
 The paragraph which works fine from tcl or udtexecute a program run from
 tcl.
 
 001: PA
 002: ECLTYPE U
 003: BASICTYPE U
 004: SSELECT ITMMST
 005: SAVE.LIST NEWPARTS
 006: GET.LIST OLDPARTS TO 1
 007: GET.LIST NEWPARTS TO 2
 008: MERGE.LIST 2 DIFF 1
 009: SAVE.LIST DIFFPARTS
 010: GET.LIST NEWPARTS
 011: SAVE.LIST OLDPARTS
 
 
 
 Clue: I have also been getting a strange
 stat ITMMST message and open fails when I try to open a file the second
 time, even though I closed it. Currently doings an OPEN ,ITMMST
 READONLY
 TO PFILE
 ---
 u2-users mailing list
 [EMAIL PROTECTED]
 To unsubscribe please visit http://listserver.u2ug.org/
 ---
 u2-users mailing list
 [EMAIL PROTECTED]
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Cannot access list ML_3516_1 Unidata phantom (MERGE.LIST)

2004-10-26 Thread Doyen Klein
Question: what is the setup for the phantom environment to make the program
work the same way it does from tcl? I've looked a several UDT.OPTIONS but
can't seem to uncover the secret key.

WinNT, Unidata a Paragraph (PH) works fine from tcl, but when executed by a
phantom'd basic program the merge.list command within the paragraph seems to
fail with the message 'Can not access list ML3516_1.'

The output from the _ph_ file when it fails.

169 key(s) saved to 1 record(s)
163 records retrieved to list 1
169 records retrieved to list 2
Can not access list ML3516_1.   
The environment is 'p', but the program uses UDTEXECUTE PARTSLISTS and
UDTEXECUTE GET.LIST DIFFLIST

The second pass, all the selects seem to fail and come up with 0 records
selected.

Notes: WinNT, Unidata, P environment

The program works fine when run from tcl, but not when phantomed.
The login checks the @USER.TYPE and bypasses any login setup info.
The program has $BASICTYPE u, and does a UDTEXECUTE 'ECLTYPE U' as well
The paragraph contains ECLTYPE U as the first line.
  
The paragraph which works fine from tcl or udtexecute a program run from
tcl.

001: PA
002: ECLTYPE U   
003: BASICTYPE U 
004: SSELECT ITMMST
005: SAVE.LIST NEWPARTS
006: GET.LIST OLDPARTS TO 1
007: GET.LIST NEWPARTS TO 2
008: MERGE.LIST 2 DIFF 1   
009: SAVE.LIST DIFFPARTS   
010: GET.LIST NEWPARTS 
011: SAVE.LIST OLDPARTS



Clue: I have also been getting a strange 
stat ITMMST message and open fails when I try to open a file the second
time, even though I closed it. Currently doings an OPEN ,ITMMST READONLY
TO PFILE
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] RedBack # of responders configuration

2004-09-24 Thread Doyen Klein
It would depend on the number of people hitting your site  how big your RB
objects were (ie sending many properties to the backend). Usually a few
responders can handle many many hits. 

Unless you are developing, make sure backend=1.

On the otherhand, why lower the responders? If they are active it shouldn't
be effecting you're performance. If you are worried about performance, check
WWSTATE file.


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:owner-u2-
 [EMAIL PROTECTED] On Behalf Of Andy Pflueger
 Sent: Friday, September 24, 2004 4:15 AM
 To: U2 User Group Mailing List
 Subject: [U2] RedBack # of responders configuration
 
 Hello there,
 
 I know this is the U2 mailing list and sorry for sending a RedBack
 related message but figured someone out there may have the answers.
 
 Recently, I've tweaked our production environment's rgwresp.ini to
 lower the # of responders (er UDT processes) eaten up by rgwsched. Is
 there any sort of rhyme or general rule behind defining a set number
 of responders and if so, what is it?
 
 TIA,
 Andy Pflueger
 Webmaster
 Ivy Hill Corp.
 Louisville, KY
 --
 Sent using http://gmail.google.com/ :-P
 ---
 u2-users mailing list
 [EMAIL PROTECTED]
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] hello ?

2004-09-23 Thread Doyen Klein
Careful with that axe, Eugene!

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:owner-u2-
 [EMAIL PROTECTED] On Behalf Of Stuart Boydell
 Sent: Wednesday, September 22, 2004 9:11 PM
 To: [EMAIL PROTECTED]
 Subject: RE: [U2] hello ?
 
  Yes us pagans are dancing in the moonlight and had to address the
  4 element
  forces at noon... ;-) call to the East, South, North  West..
 
 Ah, NOW I understand how this thread is related to MV... you were gathered
 in a cave and grooving with a Pict.*
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Job Ad --- Programming position available --- Kansas City Missouri

2004-08-26 Thread Doyen Klein
The mid-level positions must know C++, SQL, Oracle and Cisco.

 -Original Message-
.  The ideal candidate
 will
 have Universe (multivalue) experience, with Windows server knowledge and
 moderate to strong skills in state-of-the art sockets programming, html
 coding and web based scripting technologies.  Good communication skills
 are
 required and strong business, accounting and/or transportation knowledge
 would be a plus.
 
   This is an entry / lower level position
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Unidata - emulate enter key

2004-08-26 Thread Doyen Klein
Try doubling the 's like
Please enter Y or N

If you want to get fancy, you can include pattern matching and other fancy
stuff.

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:owner-u2-
 [EMAIL PROTECTED] On Behalf Of Chauhan, Savita
 Sent: Thursday, August 26, 2004 1:24 PM
 To: [EMAIL PROTECTED]
 Subject: [U2] Unidata - emulate enter key
 
 Hi,
 I am working on UniData and want to emulate the user pressing the
 'Enter' key.
 
 I want to do something similar to this:
 
 1:PA
 2:SELECT file WITH @ID  1
 3:IF @SELECTED = 0 THEN GO SKIP
 4:DELETE file
 5:DATA Y
 6:SKIP:
 
 But, instead of:
 DATA Y
 I want to replace it with:
 DATA enter key
 
 I tried:
 (i)  DATA ^12^13
 (ii) DATA ^13
 
 But neither worked.
 
 Can someone pls tell me how do I emulate enter key in the paragraph?
 
 Thank you.
 ---
 u2-users mailing list
 [EMAIL PROTECTED]
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [ud] UniObjects Dynamic Array Type Mismatch only in .exe

2004-08-23 Thread Doyen Klein
Dynamic assignment of array variables may be the issue. 
Try adding a line so it reads like this.

10:   dArray.Value(1,1) = Some String
40:   dArray.Value(2,1) = 50

68: temp = dArray.Value(2,1)
70: dArray.Value(2,1) = temp + 25

* 70:   dArray.Value(2,1) = dArray.Value(2,1) + 25

90:   iNumber = dArray.Value(2,1)
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] How do we get unique records from Universe file(Table)

2004-08-12 Thread Doyen Klein
That's how to do a unique field, if it's a record which has to be unique,
you can fake it by creating an I-Desc using @RECORD, the do the SELECT
SAVING UNIQUE as mentioned.

Beware, if the records are anything but very small, this is a very bad idea
and you should solve it programmatically.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Pingilley, Ron
Sent: Thursday, August 12, 2004 10:46 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [U2] How do we get unique records from Universe file(Table)

tax in advance -- sounds like the US Government! :)

If you're doing a SELECT at tcl, try adding SAVING UNIQUE to your statement.
Here's an example:

 SELECT ORDERS WITH ORDER.DATE  8/1 PART.NUMBER

...10456 items selected

 SELECT INVENTORY SAVING UNIQUE @ID

...395 items selected

 SAVE.LIST AUG.PARTS

1st step selected the PART.NUMBER field from the ORDERS file, with lots of
duplicate part numbers showing up.  The 2nd step pared that list down to
just unique part numbers.

--Ron P.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 12, 2004 9:05 AM
To: [EMAIL PROTECTED]
Subject: [U2] How do we get unique records from Universe file(Table)


Hi,

Can anybody help me in retriving the unique(distinct) records from 
Universe file

tax in advance

regards
Reddy
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Paragraphs in Files Other Than VOC

2004-08-09 Thread Doyen Klein
You can create a remote pointer in the voc but you'll still have to have a
minimal voc entry. It does cut down on the number of lines in the voc.

The format is

001: R
002: PP 
003: PA.ID 

Line 1, the letter R, means a remote pointer
Line 2 is your other filename, PP was a default file used for such things in
years past)
Line 3 is the record id of your paragraph

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Perry Taylor
Sent: Monday, August 09, 2004 11:04 AM
To: U2-Users List
Subject: [U2] Paragraphs in Files Other Than VOC

Is it possible to store paragraphs in files other than the VOC?  I'm
looking for a way to not clutter up the VOC with paragraphs... something
like can be done with PROCs.

Thanks.

Perry Taylor
Zirmed, Inc.




CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, 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. ZirMed, Inc. has strict policies regarding the
content of e-mail communications, specifically Protected Health Information,
any communications containing such material will be returned to the
originating party with such advisement noted. 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]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [OT] Sarbanes-Oxley

2004-08-06 Thread Doyen Klein
This sounds like the kind of thing that would drive one to purchase PRC.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rosenberg Ben
Sent: Friday, August 06, 2004 7:03 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [U2] [OT] Sarbanes-Oxley

The I.T. audits aren't much like financial audits.

Instead, they are much like ISO-9000 audits, and require
excruciatingly detailed documentation of I.T. quality
assurance (or at least QA-ish) policies and procedures.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Univere Login Security

2004-08-04 Thread Doyen Klein
I recently had a sys admin try to get me to use webex instead of netmeeting.
He said it works much better because it's browser based.

www.webex.com says they are cross platform (HPUX, Linux etc). It's a full
blown video-tel-white board conferencing application but from what I
understand you could just use it as a telnet session.

It's a web based version of Net Meeting which I've used as a virtual
console.

They offer a free-trial for 15 days, so if you are willing to be our guinea
pig you can let us know if it works.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, August 04, 2004 12:45 PM
To: u2-Users
Subject: [U2] Univere Login Security

Hi all,
A buddy of mine wants me to be able to login to his computer on a routine
basis to give him a hand with some development.  Currently, he has a process
that matches the ip address to the username and if it does not match, the
user gets booted.  The problem that I have is that my ip address is dynamic.
Given the fact that this is a unix machine that I will be logging into, I
assume that I cannot use a mac address or anything like that,  Can someone
out there give me a simple and effective solution for this?


Thanks,

Scott
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] [OT] File corruption error, but ON ERROR branch not taken

2004-07-26 Thread Doyen Klein
I can see where this is going

READ rec FROM filevar 
ON ERROR
...
ELSE ON-REALLY-BAD-ERROR

ELSE LOCKED-BY-SOMEONE

ELSE LOCKED-BY-ROGUE-SYSTEM-PROCESS

ELSE NOT-FOUND

ELSE -SYSTEM-AFU

THEN
 Do what I programmed
OR-THEN
 Do what I meant to program
END (mercifully)


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver
Sent: Monday, July 26, 2004 11:05 AM
To: [EMAIL PROTECTED]
Subject: Re: [U2] [UV] File corruption error, but ON ERROR branch not taken

How does the application program determine it is in the ELSE clause due 
to an error rather than due to record not found?

-- 

Regards,

Clif


On Jul 25, 2004, at 23:13, Leroy Dreyfuss wrote:

 Since the ELSE clause is taken anyway (whether or not is moot for your
 purposes), you can still do your rollbacks and so forth through your 
 code.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] merge sort

2004-07-23 Thread Doyen Klein
Chuck, if what you wanted was to look at the code to see how it's done this
won't help but.

AD for MERGE.LIST

I've used MERGE.LIST which is very effective. I've written programs which
sort and merge many subsets just by executing this utilities and then doing
the good ol' READLIST.

SELECT PARTS BY REV.NO SAVING REV.NO TO 1
SELECT VENDOR.PARTS BY VEN.REV SAVING VEN.REV TO 2
MERGE.LIST 1 UNION 2
Or 
MERGE.LIST 1 DIFFERENCE 2

You can go on forever . (or at least I've gone up to 9 lists.)
SSELECT is best if you can use file ID's.

Even if you don't have a file structure already built, you can create a temp
file, write your data elements to be sorted out as ID's then use SSELECT.

Amazing what some programmers will do to avoid writing code :-)


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Chuck Mongiovi
Sent: Friday, July 23, 2004 2:46 PM
To: [EMAIL PROTECTED]
Subject: [U2] merge sort

Does anyone know where I can get code for a generic BASIC Merge SORT
routine?
-Chuck
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/