Re: [U2] Head Hunter

2009-08-17 Thread Roger Glenfield

Good Luck.

Joe's contact info:
office 856.218.1000
cell856.422.4400
j...@bsgsg.com or j...@barkbridge.com



Barry Rogen wrote:

Joe Chelston - I think his company is BarkBridge.com

Barry  Rogen
PNY Technologies, Inc.
Senior  Programmer/Analyst
(973)  515 - 9700  ext 5327
bro...@pny.com

-
We are continually faced with great opportunities
brilliantly disguised as insoluble problems.
 John W
Gardner

P Before printing please think about your environmental responsibility


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Burwell, Ed
Sent: Monday, August 03, 2009 2:13 PM
To: U2 Users List
Subject: [U2] Head Hunter

Does anyone know a good headhunter for the NJ/NY area?  I have lot's of
Unidata and VB experience and would like to explore some possibilities.


Thanks.

Ed Burwell
Morristown, NJ
 
vtools@gmail.com


__
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
http://listserver.u2ug.org/mailman/listinfo/u2-users

4/8/2009NOT INTENDED AS A SUBSTITUTE FOR A WRITING 

NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT.  THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT.  NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER.  

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
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


  



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] UniVerse Index Files

2008-08-28 Thread Roger Glenfield
Of course those 7 writes only occur if every trigger needs to be updated 
each time?

Dict one = OPEN  attr 2 = if open then @id else null
Dict two = CLOSED attr 2  if Not(open) then null else @id

Roger



Dan Fitzgerald wrote:

Not sure of a limit, but you will see a decrease in performance at around 6 or
so (your mileage may vary, but probably not by much). Bear in mind that every
write to an index file is a write. If you have 6 indexes and everything else
is perfect (no splits or merges), that means that you have to do 7 writes
every time you update.  Subject: [U2] UniVerse Index Files Date: Tue, 26 Aug
2008 14:48:42 -0400 From: [EMAIL PROTECTED] To:
u2-users@listserver.u2ug.org  Does anyone know if there is a limit on the
number of index files you can build on a UniVerse Type 30 file?AIX
5.3  uv 10.2Andrea Charles
  Access Manager:
This email is intended only for the person or entity to which it is addressed
and may contain information that is privileged, confidential or otherwise
protected from disclosure. Dissemination, distribution or copying of this
e-mail or the information herein by anyone other than the intended recipient,
or an employee or agent responsible for delivering the message to the
intended recipient, is prohibited. If you have received this e-mail in error,
please immediately notify us by calling the Help Desk at (212) 999-9911 or
email us at [EMAIL PROTECTED] --- u2-users mailing list
u2-users@listserver.u2ug.org To unsubscribe please visit
http://listserver.u2ug.org/
_
See what people are saying about Windows Live.  Check out featured posts.
http://www.windowslive.com/connect?ocid=TXT_TAGLM_WL_connect2_082008
---
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] UniVerse Index Files

2008-08-28 Thread Roger Glenfield
Check your uvconfig file.There is a t30 limit.   Looks like default 
is 200.   Do the indexes get counted among the 200?  Or are they counted 
separately?


Roger
Ray Wurlod wrote:

The limit is 1000.  This results from the actual index files following the 
naming convention INDEX.nnn starting from 000.

Every index degrades update performance, so you should still be selective.
---
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] 2 gig files

2008-08-28 Thread Roger Glenfield
Sorry, I only use Universe.   But Universe uvconfig has a ulimit 
option.   And the system will default to either AIX ulimit or Universe, 
depending on which one is LARGER.

Roger

Symeon Breen wrote:

Hi  I know this is an oft spoken of matter  but this is a slightly
different question.



I have udt 7.1 32 bit running on a RHEL 64bit linux box. At linux I can
unzip a file and it creates the resulting 10 gig csv no problem, I can then
further manipulate this as I wish. If I issue the zip command from within
udt the unzip fails once the resulting csv file reaches 2 gig.



Anyone know of a way to execute such a command without udts limits imposed
on the resulting shell ?







Thanks

Symeon.
---
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] ouch

2008-07-10 Thread Roger Glenfield

a) Universe
b) whippersnapper (32 years still in black and white)
  my main concerns are the programmers that can't visualize impacts on 
the whole 'code'.   and are constantly recompiling after correcting 5-10 
lines of code.   Of course, back in the Early Dawn of Pick, compiling 
500 lines of code would take 20-30 minutes plus drag down the other 16 
programmers on the system.  There was a least one programmer 
're-educated' for abusing the system.  Of course, some of the 5,000 line 
programs that I've seen recently were because somebody didn't think.

Roger

Allen E. Elwood wrote:

You didn't say unidata or universe...

This guy has a unidata decompiler, not sure how fast they are

http://www.infocus50.com/products/xtrico.html

btw, at 52 I haven't been using paper for 25 years

:-)

hth,

Allen E. Elwood
www.tortillafc.com
Quality Code Since 1978

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] ouch

2008-07-10 Thread Roger Glenfield

Great answer to prevent future problems, such as
I didn't really want to do that.
thanks for reminding me about some really old options.  ;)
Roger
Louie Bergsagel wrote:

A former co-worker of mine had a nifty paragraph he wrote which would edit,
compile, catalog and run a program in one fell swoop.

Because I detest wasting time with repetitive tasks, I've written a similar
program which also copies the current version of a program to a backup file
in case I trash it, or want to revert to a previous version.

EDBP [program.name] does the following:
1. Copies [program.name] to a backup directory (e.g. LOUIEB.BP) with a name
of program.name:_:date():_:time():_.bak
2. Executes ED LOUIEB.BP program.name
3. Executes BASIC and CATALOG commands unless I say no to a prompt.
4. Executes the cataloged command unless I say no to a prompt.

This is the poor dude's version control program.

-- Louie In Seattle
---
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/


[U2] Universe scaling on AIX

2008-07-10 Thread Roger Glenfield

AIX 5.x  IBM p570.
How many machines out there with over 400-500 Universe users?   And 
they're connecting through 25+ locations.


thanks
Roger
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] by.exp when

2008-02-15 Thread Roger Glenfield

Two Dictionary lessons in one day.
Other problem solved when 'DICT' was removed from the dictionary.

Among the 400+ dictionary items in my file, one of them is 'WHEN', as in 
when the record was posted.   I copied the VOC WHEN to DWHEN and 
everything works as expected.


Thanks all
Roger

Brian Leach wrote:


Roger

For what it's worth, I've done an equivalent query in prime flavor using my
demo database and as you would expect, it works fine:


Brian

 


-Original Message-
From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of 
Roger Glenfield

Sent: 09 February 2008 15:48
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] by.exp when

Again.   This is PRIME FLAVOR.  I've tried these commands on both 9.5 
and 10.2


1) SORT FILE BY.EXP CHARGE.CODE EQ 01 CHARGE.CODE TOTAL 
REV.AMT 0 records selected.
2) SORT FILE BY.EXP CHARGE.CODE = 01 CHARGE.CODE TOTAL 
REV.AMT 0 records selected.
3) SORT FILE BY.EXP CHARGE.CODE WITH CHARGE.CODE EQ 01 
CHARGE.CODE TOTAL REV.AMT 0 records selected.
4) SORT FILE BY.EXP CHARGE.CODE WHEN CHARGE.CODE EQ 01 
CHARGE.CODE TOTAL REV.AMT 0 records selected.


5) SSELECT FILE BY.EXP CHARGE.CODE
x records selected
LIST FILE CHARGE.CODE TOTAL REV.AMT WHEN CHARGE.CODE EQ 01
0 records selected.
ditto for WITH CHARGE.CODE EQ 01

but
SORT FILE BY.EXP CHARGE.CODE CHARGE.CODE TOTAL REV.AMT FILE 
CHARGE.CODE  REV.AMT

1000110.01
10101  1.11
10201  2.23
10301  100.55
10002  1.00
10102  1.01

you get the idea.
I can remember the original version of Pr1me Information.   It was 
earlier then BY.EXP.   Like Pick pre-r80, it didn't really do 
MV very well.
The WHEN clause is documented in the current Release 10 
Retrieve manual about a page or two after BY.EXP.


By the way, 1,2,3,4 all work in Pick or Ideal flavor.

Any ideas?
thanks
Roger
   


---
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] by.exp when

2008-02-09 Thread Roger Glenfield
Again.   This is PRIME FLAVOR.  I've tried these commands on both 9.5 
and 10.2


1) SORT FILE BY.EXP CHARGE.CODE EQ 01 CHARGE.CODE TOTAL REV.AMT
0 records selected.
2) SORT FILE BY.EXP CHARGE.CODE = 01 CHARGE.CODE TOTAL REV.AMT
0 records selected.
3) SORT FILE BY.EXP CHARGE.CODE WITH CHARGE.CODE EQ 01 CHARGE.CODE 
TOTAL REV.AMT

0 records selected.
4) SORT FILE BY.EXP CHARGE.CODE WHEN CHARGE.CODE EQ 01 CHARGE.CODE 
TOTAL REV.AMT

0 records selected.

5) SSELECT FILE BY.EXP CHARGE.CODE
x records selected
LIST FILE CHARGE.CODE TOTAL REV.AMT WHEN CHARGE.CODE EQ 01
0 records selected.
ditto for WITH CHARGE.CODE EQ 01

but
SORT FILE BY.EXP CHARGE.CODE CHARGE.CODE TOTAL REV.AMT
FILE CHARGE.CODE  REV.AMT
1000110.01
10101  1.11
10201  2.23
10301  100.55
10002  1.00
10102  1.01

you get the idea.
I can remember the original version of Pr1me Information.   It was 
earlier then BY.EXP.   Like Pick pre-r80, it didn't really do MV very well.
The WHEN clause is documented in the current Release 10 Retrieve manual 
about a page or two after BY.EXP.


By the way, 1,2,3,4 all work in Pick or Ideal flavor.

Any ideas?
thanks
Roger

IT-Laure Hansen wrote:


Could you tell us what the result is? Are you getting a 0 records
selected type message, or any other output?
Are you sure you are including the '01' between quotes in your command?
Finally, and not being sure at all of the difference between flavors:
did you try using '=' instead of 'EQ'?

Thanks,

Laure Hansen,
City of Redwood City
Information Technology
1017 Middlefield Road
Redwood City, CA 94063
Tel 650-780-7087
Cell 650-207-3235
Fax 650-556-9204
[EMAIL PROTECTED]

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, January 30, 2008 6:48 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] by.exp when

Yes, sorry make that
001 D
002 1
003, 004 blank
005 10R
006 M

And it still doesn't work.

- Original Message -
From: DAWES, Ray 
Date: Wednesday, January 30, 2008 9:07 am

Subject: RE: [U2] by.exp when
To: u2-users@listserver.u2ug.org

 

Surely field 2 of the dictionary should have the location in the file 
- a number.



Ray Dawes

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Roger 
GlenfieldSent: 30 January 2008 12:29

To: u2
Subject: [U2] by.exp when

Universe version 9.5
Prime Flavor
Dictionary
CHARGE.CODE
001 D
002, 003, 004 blank
005 10R
006 M

SORT FILE BY.EXP CHARGE.CODE WHEN CHARGE.CODE EQ 01 finds zero 
recordsand there are lots of records where one of the multi-

values = 01

I've also tried the old Pick flavor
SORT FILE BY.EXP CHARGE.CODE EQ 01 without any luck.

Any other thoughts or does Prime flavor Retrieve just not deal with
by.exp like the Pick  Ideal versions?

Thanks all.
Roger
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

CONFIDENTIALITY NOTICE The information contained in this
e-mail is intended only for the confidential use of the above
named recipient. If you are not the intended recipient or person
responsible for delivering it to the intended recipient, you have
received this communication in error and must not distribute or 
copy it. Please accept the sender's apologies, notify the sender 
immediately by return e-mail and delete this communication.

Thank you.
---
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/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] by.exp when

2008-01-30 Thread Roger Glenfield

Universe version 9.5
Prime Flavor
Dictionary
CHARGE.CODE
001 D
002, 003, 004 blank
005 10R
006 M

SORT FILE BY.EXP CHARGE.CODE WHEN CHARGE.CODE EQ 01 finds zero records 
and there are lots of records where one of the multi-values = 01


I've also tried the old Pick flavor
SORT FILE BY.EXP CHARGE.CODE EQ 01 without any luck.

Any other thoughts or does Prime flavor Retrieve just not deal with 
by.exp like the Pick  Ideal versions?


Thanks all.
Roger
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Unidata and multi-core chips.

2006-06-19 Thread Roger Glenfield
Did Keith just reply to an email from last October?  Or is the u2 
list/server having problems?


Rog

Keith Johnson wrote:

Andy,
I am not entirely sure on your first part of your question.  But I would
say no to the second.  UNIDATA is per seat use not per CPU.  At least in
the UNIX side of things.
-Keith


Keith Johnson  IT
Lewis-Clark State College (LCSC)
208 792 2510
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andy Squires
Sent: Thursday, October 06, 2005 8:59 AM
To: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org
Subject: [U2] Unidata and multi-core chips.

We're about to move to Unidata 6.1.  Does anyone know if it can take
advantage of multi-core chips, and, if so, will the
licensing be different?



|   Andy Squires -- Systems Analyst
|
|   Office of Information Technology -- American University
|
|   (202) 885-2785
|
---
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/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] How can this be non-numeric?

2006-06-02 Thread Roger Glenfield

fei:
Aix 5.3.  Uv 10.1.12

ANS='0+'  or ANS='0++'

Both will match '0N'.   And ANS is  0.  And you'll get the non-numeric 
for the extraction.


But
IF NUM(ANS) will fail.

As to why anyone would type in 0+

rog

Tony Gravagno wrote:

Stevenson, Charles wrote:
  

Program TIP.LIST: Line 242, Nonnumeric data when numeric required.
Zero used.

It's got to be ANS that is nonnumeric,  but how?

Here's the code:

239: IF (ANS# AND ANS # B) THEN
240:   IF ANS MATCHES '0N' THEN
241:  IF ANS0 THEN
242: IF SCRATCHANS# THEN




I'd want to know what the value of ANS actually is.  Only thing I can think
of off-hand is that ANS = +, maybe -, though I'm not sure if UV or
various flavors consider those values greater than numeric zero.
---
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] OK...Is there a way....UV

2006-05-26 Thread Roger Glenfield
FIRST is a synonym for SAMPLE.  And that example won't return the first 
two of the sorted file.


The reccount item is a better way to go.

Rog.

Nick Cipollina wrote:

What about SSELECT FILE FIRST 2?

Thanks,
 
Nick Cipollina
 
-Original Message-

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, May 25, 2006 9:03 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] OK...Is there a wayUV

   ED DICT FILE REC.COUNT

   001 I

   002 @RECCOUNT

   003

   004 Cnt

   005 5R

   006 S

   SORT FILE WITH REC.COUNT  2

   N'es pas?

 
__


   From: [EMAIL PROTECTED]
   [mailto:[EMAIL PROTECTED]   On   Behalf  Of
George
   Gallen [EMAIL PROTECTED]
   Sent: Friday, 26 May 2006 05:16
   To: u2-users@listserver.u2ug.org
   Subject: [U2] OK...Is there a wayUV

   I want to sort a file by @ID and only take the first two items...
   SELECT FILE BY @ID SAMPLE 2
   doesn't work, it first takes the sample of 2, then sorts it.
   SELECT FILE BY @ID
   SELECT FILE SAMPLE 2
   works, but takes two lines
   How  can  I phrase my SELECT so it will sort first, then sample
later,
   instead
   of sample first, sort later?
   I'm running UV.
   George
   George Gallen
   Senior Programmer/Analyst
   Accounting/Data Division
   [EMAIL PROTECTED]
   ph:856.848.1000 Ext 220
   SLACK  Incorporated  -  Delivering the best in health care
information
   and
   education worldwide.
   http://www.slackinc.com
   ---
   u2-users mailing list
   u2-users@listserver.u2ug.org
   To unsubscribe please visit http://listserver.u2ug.org/
**
   This  email message and any files transmitted with it are
confidential and intended solely for the use of addressed recipient(s). If you
have received  this  email  in  error please notify the Spotless IS
Support Centre  (+61 3 9269 7555) immediately, who will advise further
action.
   This  footnote  also confirms that this email message has been
scanned for the presence of computer related viruses.
**
---
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] OK...Is there a way....UV

2006-05-26 Thread Roger Glenfield

Also the same bad results when I tried either old Pick style methods

NI.CNTR9998.CNTR
001   A A
002   0 9998
008   ANI+'0'
009   R R
010   8 8

Rog

George Gallen wrote:

HMM. No. Now it's not working, It returns all ID's.
I must have done something wrong. Seems it doesn't
like to be used in the selecting stage, but will be
happy to be used in the display stage.

SSELECT file WITH RCNT  3

RCNT is setup as below except I didn't call it REC.COUNT

  

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of George Gallen
Sent: Friday, May 26, 2006 10:18 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] OK...Is there a wayUV
hmm. there's a new one.
Yes, that did work.
Thanks
George

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, May 25, 2006 9:03 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] OK...Is there a wayUV


   ED DICT FILE REC.COUNT
   001 I
   002 @RECCOUNT
   003
   004 Cnt
   005 5R
   006 S
   SORT FILE WITH REC.COUNT  2

   N'es pas?
  

---
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] Problem with Canon ImageRunner 5000 Printer

2006-05-23 Thread Roger Glenfield

Have you tried to send your Unidata output to the HOLD file.

And then using the '^' edit command to check for any unknown command 
strings? 

If none, then bypass the spooler and send the hold file directly thru 
windoze?


Paperless future?  You did hear about the upcoming elections somewhere 
in the USA, where they have to keep their fancy new electronic voting 
machines in storage, because the new machines don't produce a paper 
audit trail and the local judges banned the new machines use.  Somewhere 
in California, I think.


Rog
Kevin King wrote:

On Behalf Of [EMAIL PROTECTED]
My first guess is that the bin you are 
selecting to print letter is actually 
for the 11x17.



I wish it were that simple.  But having verified with the manual, and
having tried all the different bin selection PCL - and having verified
that the PCL is accurate, it always wants 11 x 17.  It actually does
select the right bin, but then it errors out asking to load 11 x 17 in
that bin.  And yeah, I've tried setting the paper selection to letter
size both before and after selecting the bin, and still the printer
insists on 11 x 17.

  
Try changing it to capture to a file and 
print using a windows app and check the PCL 
codes for how it selects the bin, or simply 
try each PCL sequence until it prints 


from the correct bin.

Done, and here's the mystery:  If I send the EXACT codes from a
Unidata app, it still wants to print on 11 x 17.  Character for
character the exact same as the Windows app, and still it wants to
print on 11 x 17.

  
However, you said it errors out. Perhaps 
there is some code that is trying to set 
the page size that is invalid for the 400 
series and is ignored there but is causing 
the grief here. Or the default measurement
(decipoints/dots/etc) is different 
between the printers. 



I've verified the measurements (actually this was one of the codes
from the Win PCL) and as I mentioned I've sent the exact codes through
Unidata that went to the printer from a quick test message printed via
the Notepad app, and while the Notepad app prints perfectly, the
Unidata app demands 11 x 17 in any bin I select.

  
Good luck, don't know about you 
but I'm really wishing the paperless

office actually worked.



You have no idea, man... :-)

-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.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] UV LOGON question

2006-05-17 Thread Roger Glenfield
And you checked that the 'main' and/or current account doesn't have a 
proc stored in the MD called EOD.REPORT.25? 

Have you tried something like PHANTOM EOD.REPORT.25?  And any chance 
that the printer settings are also in the proc, so you don't have to 
worry about the @tty settings?


Or if the jobs names are similar, is that name/number being generated on 
the fly?


Roger

Tom Dodds wrote:

We are migrating a company from an UltPlus system to UniVerse.  We are
running UniVerse 10.1.11 on AIX 5.3.3.  The UniVerse is running Pick flavor.

The legacy application relays heavily on the use of LOGON port [command]
processes.  So if you say LOGON 92 EOD.REPORT.25, the system will start the
EOD.REPORT.25 running on port 92.  It functions kind of like a PHANTOM
process in that it really starts another session from the same account that
the PHANTOM/LOGON was executed.  It runs the login paragraph of that
account.

One of the problems is that the LOGON does not populate the @tty variable
with PHANTOM or LOGON or anything else that we can find.


The second problem is that we can not find where the system is storing the
[command] that is passed into the new session.  We have displayed all of the
@ variables that we can find in the basic manual and none of them contain
the proper data.

I know the port number is strange, but we have figured a way to deal with
that, we just can't skip the logon paragraph or find what process we are
supposed to be running.

Thanks for the help in advance.



Tom Dodds
 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
513-563-2800 Cincinnati Office
708-234-9608 Chicago Office
630-235-2975 Anywhere Cell
---
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] xls to text- OT

2006-05-12 Thread Roger Glenfield

Just because I'm paranoid doesn't mean that somebody isn't out to get me.

The address I'm using is only used for this list.  And fortunately, I 
get practically no Spam.  But at my main addy it's more like 10-20 a 
day.  Sometimes allegedly from an old addy that was deactivated about 3 
years ago.


A friend who general manages a publishing company has to change his biz 
addy every 6-12 months to get away from Spam.


Rog

[EMAIL PROTECTED] wrote:
I don't think it is overly paranoid.  Nor do I think it is overly 
cautious. 
This is my work address and  I never use it except for business and this 
list.  I get a lot of spam at this address.   Are the two facts related? 
Beats me, maybe one of our client sells email addresses on the side.


Bruce M Neylon
Health Care Management Group 

  
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] OPEN Statement DICT Default

2006-05-08 Thread Roger Glenfield

The same programmer that doesn't read the manual does an

EXECUTE instead of a SELECTINDEX, and yes, the index already existed

or
A=STR('0',20-LEN(B)):B
instead of
A=FMT(B,'L%20')   or for the Universe Pick/Ideal flavor people in the 
crowd  A= B'L%20'


or
TODAY=OCONV(DATE(),'D2/')
CONVERT '/' TO @VM IN TODAY
MONTH=TODAY1,2
instead of
MONTH=OCONV(DATE(),'DM')


And yes, I have observed all of the above recently.

;)  Just 15 minutes a week to look through the current manuals to find 
out about a new option that you might not know existed?


Roger

Louie Bergsagel wrote:

I've never used the null dict indicator. Who ever reads the syntax book
unless a command doesn't work?

*:)*
-- Louie Bergsagel


On 5/5/06, Mark Johnson [EMAIL PROTECTED] wrote:
  

To All:

Was there ever a real requirement on any prior flavor to have the
typically
non-used DICT portion of the OPEN statement be the set of quotes and a
comma.

I accidentally forgot it in 1978 on a Microdata and it still compiled. To
this
day I have not seen a reason for the OPEN ,FILE null dict indicator
and
have not used it since unless I actually want the DICT level.

Just wondering.

Thanks
Mark Johnson
---
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] OPEN Statement DICT Default

2006-05-08 Thread Roger Glenfield

You did mean
OCONV(DATE(),D2/)[1,2] for month, at least in the Western Hemisphere 
and [4,2] for the Eastern, right? ;-)



Roger
Mark Johnson wrote:


I specifically remember being taught
X=STR(0,5-LEN(X)):X
for the 1 concept.
Before the % was allowed, a shorter form was
X=(0:X)R#5
which I recall using until % came about.

On that note, I stole R-10 and C#10 from UD and offered it to D3
hopefully for their next release.

Thanks
Mark Johnson

P.S. Many use OCONV(DATE(),D2/)[7,2] for the month. I think DATE()DM is
the shortest way.
Puzzle: Illustrate the simplest way to generate Jan thru Dec.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Runtime errors

2006-05-05 Thread Roger Glenfield

Dave

RUN BP PROGRAM -TRAP.  At least with Universe. 
The program will go into the Basic debugger and  wait for the user to 
'do something'.  Which could be very dangerous.


But, if the program was compiled with the -I option, such as BASIC BP 
PROGRAM -I, then the program won't stop.   Which will do you no good.


If you're running batch updates, then you could consider doing COMO ON 
name and then COMO OFF, and then remember to scan through those records.


And while we're wishing for things, I wish I could still modify the 
ERRMSG file so I could add date  time displays to various commands, 
such as SSELECT or ED..


Good Luck.
Roger

Dave Walker wrote:

I'm not familiar with TRAP, and could not find it in (an admittedly quick
perusal of) the manuals. Is it a startup option, i.e. udt -TRAP, or a basic
option?

I've been in places in the Unidata manual I've never seen before while
researching this subject. And while the search for trapping runtime errors
has thus far been fruitless, I DID run across the system command,
udtbreakon, which seems to remove the only excuse we programmers had for
continuing to enable the break in production; what if there's a deadly
embrace and we need to break one machine to allow the other to continue?

Still sifting thru the manuals here. I appreciate the response!

Thanks,
--
Dave Walker 


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of john reid
Sent: Friday, May 05, 2006 9:59 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Runtime errors


Failing a proper log file, is there the equivalent of the -TRAP run
time break to debug when an error occurs? It might not be do-able in
production environment but maybe for selected users.


On 5/2/06, Dave Walker [EMAIL PROTECTED] wrote:
  

I'm sure we've all seen the user that ignores umpteen WARNING:
UNINITIALIZED VARIABLE USED! Zero Assumed! errors scrolling up their
screen.

Is there a way to log non-fatal runtime errors so that they may be


reviewed
  

later? Are they already logged someplace that I'm not aware of? I've


checked
  

the various logs in /usr/ud/bin/saved_logs without finding what I'm


looking
  

for.

TIA,
--
Dave Walker
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/





--
john
---
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/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Unidata Caching

2006-05-03 Thread Roger Glenfield

The version of DB and O/S might help?

Remember to do your testing in a live like environment.  Running a test 
at night with no one else on the system won't point out any short 
comings that will become obvious when 30+ users start whacking at it.


Always assume the worse.  And then add another 50% to your estimates.

Jeffrey Butera wrote:

Can anyone shed insight on how/what Unidata does for caching?

In short, I notice that when I perform some SELECTs or programs which read a 
handful of records, they often run faster after first execution - I'm 
assuming Unidata is caching.


I was working on adding some caching to an application I'm working on but if 
Unidata is already doing a reasonable job I may not see any sizable 
performance difference (and don't want to spend many hours working on this to 
find it's in vain...)


Any insight appreciated.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Forum General Question

2006-05-02 Thread Roger Glenfield
Somebody's auto-email-responder zoomed out 50+ I'll be back in the 
office on blah, blah, blah in a single day.  At one point even 
responding to it's own 'responses'.


Mark Johnson wrote:

So why was it changed in the first place. I wonder how many liked it that
way.
Mark Johnson

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Is this thing turned on?

2006-05-01 Thread Roger Glenfield

Too many people celebrating Cinco De Mayo early?


Rog


Allen E. Elwood wrote:


FiestaHello.?  Taps Microphonecan you hear me now?

Just testing to see if the list is working or not, awfully quiet even for a
Monday

Allen E. Elwood
www.tortillafc.com

Quality Code Since 1978

[demime 1.01d removed an attachment of type image/bmp which had a name of 
TFCBlend.bmp]

[demime 1.01d removed an attachment of type image/jpeg which had a name of 
Fiesta Bkgrd.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] Escaping the '' in Windows XP from Universe

2006-04-28 Thread Roger Glenfield

How about

EXECUTE DOS /C DIR UVUSR\LFC\HOLD\INSRECAP\SutherlandIssues200604.csv

So that it's all one command?

And your fall back could always be to move the HOLD record into 
another file without the s and Execute against it.


Rog

Eric Armstrong wrote:

Does anyone know how to escape the  in the following Basic EXECUTE
statement?

EXECUTE DOS /C DIR UVUSR\LFC\HOLD\INSRECAP\SutherlandIssues200604.csv
CAPTURING msg RETURNING err

Windows is choking on the . It thinks HOLD is a file in the LFC
directory.

I tried the following-

EXECUTE DOS /C DIR UVUSR\LFC\HOLD\INSRECAP\SutherlandIssues200604.csv
EXECUTE DOS /C DIR 'UVUSR\LFC\HOLD\INSRECAP\SutherlandIssues200604.csv'
EXECUTE DOS /C DIR UVUSR\LFC\HOLD\INSRECAP\SutherlandIssues200604.csv

and a few other things, but no go.

We are on
Universe 10.1.10
Windows XP 2002

Thanks in advance.

Eric Armstrong
Programmer/Analyst
Lobel Financial
714.816.1207
714.995.7012 fax
---
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] [UV] File sizing

2006-04-26 Thread Roger Glenfield
Since Type 30 groups are subject to 'change', would a group lock still 
be 'very' temporary?


Charles Barouch wrote:

Not exactly...
 The system locks the group so
that the item it wants won't move during the read. Once the item is locked
(record lock), the group lock is released. In theory, Group locks are
*very* temporary.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] U2/OT Scanner Question

2006-04-19 Thread Roger Glenfield
Check with www.systemid.com.   Long time dealers in most things 
barcode.  Including interfaces between dumb terminals and barcode scanners.


Roger
Caminiti, Marc wrote:

This is kind of an off topic question.  We currently use handheld
scanners to scan in a barcode on our packages to ship out an order.  The
scanner is connected up via a PC to a Digi PortServer.  


We have had problems in the past with this configuration in that we were
losing a character from our barcode and old orders were getting shipped.
So to fix this problem, we slowed down the transmittal from the scanner
to the PC.  Well, apparently this isn't fast enough for our Warehouse
Manager, but good for everyone else that uses it.  Prior to this
configuration, we had a scanner hooked up to an ADDS terminal and that
was working good.  But the scanner that we were using slowly broke.  So
we switched over to this other configuration.  Another reason for that
is that we had a hard time finding the keyboard connection cable from
the scanner to the ADDS RJ-11 type connection.

Does anyone out there have a similar configuration.  Or any ideas that
may be helpful?

Thanks
Marc

Marc Caminiti   Nashbar Direct, Inc
IS Manager  Bike Nashbar
330.533.1989, ext 336   6103 State Route 446
330.702.9733, fax   Canfield, OH 44406
[EMAIL PROTECTED]  http://www.nashbar.com

In just two days, tomorrow will be yesterday
---
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] dataflo

2006-04-13 Thread Roger Glenfield
I remember trying to convert Escom's Distribution package from Pick to 
Pr1me Information over a very long weekend, back in 1979.  One glitch 
being them using a user exit in place of regular input statement.


Didn't Escom have a 'sister' company called Devcom?But then again, 
Devcom never produced anything of consequence.  ;-)


Rog

Jerry Banker wrote:

One of the companies acquired by Epicor was Escom, anybody remember who
Escom was?

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Steve Moore
Sent: Thursday, April 13, 2006 9:06 AM
To: will; u2-users@listserver.u2ug.org
Subject: RE: [U2] dataflo

We are a manufacturing company and have used Dataflo since 1999.
Our current version is 5.8.5b.

What is your question?

Steve


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of will
Sent: Wednesday, April 12, 2006 10:39 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] dataflo

   Anyone have experience with Epicor's Dataflo?

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] List dead ?

2006-04-11 Thread Roger Glenfield

There were about 10 postings for Monday, April 10.

Between Passover this week and Good Friday/Easter this weekend.  
Plus what looks like spring finally arriving in the US Northeast.



Roger

gerry-u2ug wrote:

Hi ,
Its been 3 or 4 days since I've received anything from the list.
Is it dead ?
Or have I been magically unsubscribed again ?
Gerry
---
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] UV RetrieVe Press any key to continue... ignores AUTOLOGOUT

2006-04-07 Thread Roger Glenfield

AIX 5.2
Universe 10.1.12 Information flavor

Autologout causes my LIST generated 'press any key to continue' to 
continue to the next command, just as if the key was pressed.  And then 
after the same amount of time, the process drops out of Universe into a 
$ or # prompt.  Releasing a seat.


Autologout causes my BASIC program with a Heading statement to drop 
completely out of Universe into the $ prompt.  Releasing a seat.  It 
just happens sooner.


Stevenson, Charles wrote:

I do not recall that the AUTOLOGOUT is ignored for the paging prompt for
LIST.
Has it always been that way?

The UV User Ref simply says:

Use AUTOLOGOUT to enable or disable automatic logout. With AUTOLOGOUT
enabled, UniVerse logs you out automatically if you have not pressed a
key within a specified time.

Recently I have been hit with a rash of telnet sessions that are sitting
at that prompt and not timing out.

HPUX, UV10.0.16, Pick flavour.
LOGIN paragraph specifies AUTOLOGOUT 30.
After 30 minutes of inactivity, i.e., sitting at a prompt, the user is
typically logged out as a means of controlling license use. Generally
that's been working well since long before I started here.

A little testing shows that AUTOLOGOUT is honoured when paging from
inside a basic program:
(e.g.: FOR I=1 TO 1000; CRT I; NEXT I )
but not from LIST:
( e.g., LIST VOC ).

I don't remember ever giving this much thought and I don't find any
clear documentation on it. I also don't recall any grief from it until
this past week or two. The obvious question is What's changed?: I
don't *think* anything changed in UV config, admin/setup, user
initialization. I *think* a changing business demand may be stressing
certain suspect screen listings more than before.

I would like to have AUTOLOGOUT honoured by RetrieVe's paging prompt.
don't know how or if possible.


Thanks,
Chuck Stevenson
Getronics
---
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] Executing save-list

2006-03-30 Thread Roger Glenfield

Don't know about others but my system
AIX 5.2
Universe Pr1me flavor 10.1.12.

Nothing in VOC for SAVE-LIST.  But if I enter SAVE-LIST JUSTATEST.  It 
saves my 'selections'.  So I guess the 'current' interpreter 
automatically converts.


Of course, that hasn't stopped me from creating GL, EL  SL for speed 
typing purposes.


Jerry Banker wrote:
Have you also set up SAVE.LIST the same as SAVE-LIST? When you type in 
SAVE-LIST I believe the interpreter changes the command to SAVE.LIST 
before executing it.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] User IDs

2006-02-15 Thread Roger Glenfield

John, did the surgeons manage to reattach your leg yet?

Hey, at least Bill didn't mention the sub-directories in bin called 
laden or osama.




-roger
John Hester wrote:

Brutzman, Bill wrote:

I want to beef up security on our old HP-Ux v10.01 running UV v8.3.3.

I am inclined to delete the following user.ids as they may be 
infidels...


  adm   bin   daemon   lp   nuucpsys   uucp

Suggestions would be appreciated.


Those are the standard SYSV unix pseudo users.  You'll find an 
explanation under the Psuedo Users heading at this link:


http://docs.rinet.ru:8080/UNIXs/ch17.htm

DO NOT modify those entries if you want your system to continue to 
function normally.


-John

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UD] how to find records with a in the data

2005-10-26 Thread Roger Glenfield

If you want to check every field.

SEARCH FILENAME
prompts STRING: and you enter 

Which will return a select list for any record containing a .   And 
then you can pass that list to the editor to clean it up.


Roger

Kathy Tymoczko wrote:

We have a number of records with double-quote () characters in one of 
the data fields.  We'd like to be able to select those records so we 
can fix up the data.  Is there any way to find these records with a 
SELECT statement?  I've tried:


SELECT filename WITH fieldname LIKE '..'  which gives a missing 
quote error


and

SELECT filename WITH fieldname LIKE .. which returns all the 
records in the file


ESEARCH does work, but we thought we should be able to do this somehow 
with SELECT.




Kathy Tymoczko
Information Technology Services
Wabash College, Crawfordsville, Indiana 47933
[EMAIL PROTECTED] 765-361-6440 ---
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 Programming Practice Question.........

2005-09-30 Thread Roger Glenfield

Exception to no multi-command lines.
TOT(1,1)=0; TOT(1,2)=0; TOT(1,3)=0; TOT(1,4)=0; * Resets array for this loop

And as far as no MATREADS/WRITES.  You can always INCLUDE the DIM 
statements.  Which can also include the equates for standardized 
variable names for each attribute.  And yeah, you'd have to recompile 
every program when new attributes are added.  But as others will point 
out, if you're updating a lot of attributes, there are performance 
advantages.


Roger

Richard Taylor wrote:


I would add a few:

1) no multi-command lines (i.e.  command ; command; command

2) Use Continue and Exit inside loops to handle error conditions.

3) I then to prefer the following for working with select lists
LOOP WHILE READNEXT ITEM.ID DO
Some commands
REPEAT

4) No MATREAD  MATWRITE.  Some will probably disagree, but to me this
takes a wonderfully dynamic system and hamstrings it.  I have also seen
data corruption happen when you have a large file dictionary than the
array dimension.  This is definitely platform dependant though.  Unidata
just puts all remaining fields into the last array position.  If you then
change that position expecting it to be just the one field you want to
work with, the remainder of the data is lost.  Universe behaves
differently, but I still don't think using these commands is a good idea.


Ok, let the flame war begin.

5) Proper variable names; no single character variables, variable names
should indicate there purpose.

6)INDENT YOUR CODE.  This may be obvious to most here, but I have worked
with programmers that seem to have a phobia about this.

Generally, I have always had three general rules that I apply up front.
All the specific standards created work to support those three rules.

1) A program must work.  By that I mean that it solves the client's
problem and gives them what they need.  It is NOT simply that the program
was syntactically or even logically correct.

2) The code must be readable by any one.  Indentation, comments, variable
names are things that support this.

3)  The code must be maintainable.  Proper structure, NO use of the
'command-that-must-not-be-named'

One other thought, since you are talking about new programmers.  You will
likely need to train them on proper testing/debugging technique.  The
basic mistake I see many programmers make in testing is that they test to
see that it works.  What you should be doing is trying to break it!  Lord
knows the users will.

That is my $0.02 such as it is.

Rich Taylor | Senior Programmer/Analyst| VERTIS
250 W. Pratt Street | Baltimore, MD 21201
P 410.361.8688 | F 410.528.0319 
[EMAIL PROTECTED] | http://www.vertisinc.com


Vertis is the premier provider of targeted advertising, media, and
marketing services that drive consumers to marketers more effectively.

The more they complicate the plumbing
 the easier it is to stop up the drain

- Montgomery Scott NCC-1701
---
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] Tracking down how fields are filled

2005-09-09 Thread Roger Glenfield
Too many different files with attributes 139 and 140 to do a search 
through your basic programs?


Bruce Ordway wrote:


Hi,


In my INV Dictionary I found a custom item called Z_AVEUSE
with the following conversion:

SUBR(-OCONVS,(SUBR(-OCONVS,F0,TPARTS;X;;139)/SUBR(-OCONVS,F0,TPARTS
;X;;140)*365)+.049,MD0)

It seems to give good numbers back for part usage during a 12 month period.
I could easily make a report or Query Builder using this value if I could
trust it.
I wanted to see where it was getting it's values to make sure it's OK to
use.

When I go to my PARTS dictionary F139 and F140 tuened out to be custom with
no documentation.
How could I find out when and with what these fields are getting written to?

Thanks,

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] SELECT without

2005-08-10 Thread Roger Glenfield

10.1 pe  windows 2000
PA
TIME
SELECT FILE COUNT.SUP
RUN BP NO.PROCESS
TIME

results
23:17:01 10 AUG 2005
23:17:01 10 AUG 2005
---NO.PROCESS Does nothing and just stops.  And nothing actually displays.


without COUNT.SUP
23:18:10 10 AUG 2005
10127 record(s) select to SELECT list #0.
23:18:10 10 AUG 2005


Bruce Nichol wrote:


Goo'day,

At 10:43 11/08/05 +1000, you wrote:


I think its COUNT.SUP



Still doesn't work Check HELP SELECT

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Internal date conversion

2005-07-14 Thread Roger Glenfield

About the same time as D2E  started iconverting DAY/MON/YEAR?

I think I preferred the Ultimate method of setting a system wide flag 
and letting D2/ be D2/ for the locals.


Or even better, MMDDYY instead of slashing/dashing.  Of course, some 
preferred not having to enter years, entering  7/13 and defaulting to 
current year.


Gordon J Glorfield wrote:

FYI This does work in UV.  Which is odd to me.  I had always thought that 
in an ICONV anything following the D was ignored.  I wonder when this 
changed?


I've learned something new so it's not a completely wasted day.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] 7.1

2005-07-13 Thread Roger Glenfield

Any word on the status of Unidata 7.1?  Any real life experiences?


No, lets not ask when the PE edition is coming out.

Roger
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Barcode Label print software

2005-06-22 Thread Roger Glenfield

Haven't done rfid yet.

But if you're looking for the vendor compliant formats, for most of the 
retailers, then you might want to check out Paxar/Monarch.


They did have/may still support most of the major retailer formats.  
Unfortunately, you also will need one of their printers, ribbons  paper 
stock.  But their base software was from Loftware. You can use the 
software to drive another brand of printer, but you will have to make 
adjustments to the forms.


Loftware does require a dongle.  But does sell a server $$$ based 
package.  And the retailer formats came from Paxar.  Unfortunately, some 
of the formats had been created for another model printer and had to be 
adjusted for our newer model.


Used it 3-4 years ago to support retail labels/tags for  Nordstrom.  
Federated,  Kohls.  Sears Canada.   Created sample barcode file on PC.  
Then created data on Universe, transferred csv data back to PC and the 
PC run/controlled all of the printer functions.


Make sure that your printer supports 2d and maxicode.  Or the software 
won't do you any good.


Burwell, Edward wrote:


Hello,

We are doing some research on label print software.  I would love to hear
some real-life testimonies from real users.  I've seen TL Ashford's product,
but it has to live on an as/400.  I'm looking for something that will live
either on our rs/6000 or a windows server.  I am envisioning a
print-engine that will live out on our network (or on our Unix box), that
we can send a message to (CSV, XML, whatever), and it will take our message,
map out the fields to the appropriate label format and print the label or
labels to the appropriate printer (DATAMAX, Zebra, Printronix, etc).  


Some Requirements:

1. Generates an RFID encoded tag
2. Provides Vendor-Compliant label formats for major customers (Wal-Mart,
Target, etc)
3. WYSIWYG label design
4. Supports UPS Maxicode

Nice to have:

1. Web interface

Would love to hear your experiences.  Thanks.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] OCONV of no affect.

2005-06-18 Thread Roger Glenfield

If it's because you have a lot of possibilities
Setup index of possible conversions and then test?
Such as

MIXED.CONV=''
MIXED.CONV1='N':@VM:'Y':@VM:'E'
MIXED.CONV2='MD2':@VM::@VM:'MD3'
LOCATE(REC5,MIXED.CONV,1;MIXED.VM) THEN
CONV=MIXED.CONV2,MIXED.VM
END ELSE
CONV=''
END
IF CONV='' THEN
PRINT REC6
END ELSE
PRINT OCONV(REC6,CONV)
END


Mark Johnson wrote:


I'm not looking for a programming alternate or suggestions. Just a null
conversion.

I didn't invent this situation. It's just one of the zillions of examples
that I inherit with my client's systems.

Under certain circumstances, a single data field contains multiple types of
data. This may be dependent on another field.

Thus, code like this exists:

IF REC5=N THEN
   PRINT OCONV(REC6,MD2)
END ELSE
   PRINT REC6
END

Sometimes both have a conversion and I do this to save typing lines:
IF REC5=N THEN CONV=MD2 ELSE CONV=D2/
PRINT OCONV(REC6,CONV)

So I was wondering if this 2 line example could apply to the first example.

Thanks in advance.
(P.S. I wonder how off-topic or deviated this thread will go. I'm just
looking for a null conversion)

 


OK, I'll bite.
How does one find a situation where one wants this?
From: Mark Johnson
   


Is there an OCONV method that does nothing, ie IF
X=OCONV(X,CONV) THEN TRUE.

I've had a situation where I could use this before and one
crept up today.
 


How does one find MORE THAN ONE situation where one wants this?
How about if YOUR CONV variable is an empty string?
I *think* that for all X,  ( X EQ OCONV( X, '' ) ) will evaluate to
true.
If that isn't the case, you could write your own user exit:
  SUB DONOTHING( STR.OUT, STATUS.OUT, STR.IN, I.OR.O.IGNORE )
  STATUS.OUT = 0
  STR.OUT = STR.IN
  RETURN
CATALOG BP $DONOTHING  (ideal-flavor cataloguing, not pick-flavor)
( X EQ OCONV( X, 'UDONOTHING' ) )  will always be true.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UD] ADP WDS (Wholesale Distribution Services) Info

2005-05-24 Thread Roger Glenfield

Was this part of the deal with Prophet 21?

Try
www.p21.com

Roger

Ross Morrissey wrote:


The ADP WDS website (http://www.adpwds.com) has gone dark - would anyone on
the list have some insight?

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Dymanic vs Dimensioned

2005-05-18 Thread Roger Glenfield
Nah.  My first Microdata only had 10 mb.  The 50s came out 1-2 years later.
Roger
Schalk van Zyl wrote:
Wow, Noah! - you MUST be old!
On Wed, 2005-05-18 at 06:25 -0400, [EMAIL PROTECTED] wrote:
 

Gyle,
64KB?  ROTFLMAO! The first Microdata machine I worked on had 16KB, and  ran a 
medical billing service bureau. It had 1 50MB disk drive and ran as slow  as 
molasses. I ran into the same machine many years later in a tech college  
museum. I verified the serial number to be sure. Ouch, the bones are feeling old  
today.  ;^)

Regards,
Charlie Noah
   



---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Unidata SELECT

2005-05-17 Thread Roger Glenfield
Fawaz Ashraff wrote:
Hi All,
We have a program that used to work but is now not
functioning.  The problems is if you have an active
select list and you try to run the following
statements
GET.LIST CL.BCS.MAYBE  this has 139 records
SELECT STUDENTS WITH X.STU.BCS.REG.FLAG LIKE 'N...'
This statement will return either No results or only 1
result
But if you change the SELECT to a LIST then 3 lines
will be returned.
Also if you change the SELECT to an SSELECT then 3
lines will be returned.
What it looks like is happening is another select
statement is clearing out the orginal select statement
and only returning the results of the last record in
the orginal 139 records.
X.STU.BCS.REG.FLAG is a I desriptor in STUDENTS that
calls the following subroutine 

XS.CALC.ACTIVE.BCS.TO.REG and this subroutine calls
another SUBROUTINE XS.CALC.REG.TERM. 

Anybody have any ideas? Any UDT.OPTIONS I should work
with? 


Have you checked that those 3 listed records are in the save.list?
1) get.list the list
2) select the file.  With no With or By options.  just confirm that the 
items on the list are in the file.

And you've confirmed that the file isn't corrupted, right?
And are any of the dictionaries indexed?
Roger
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] I'm in an Array quandry, any suggestions...

2005-05-13 Thread Roger Glenfield
Timothy Snyder wrote:
Richard Taylor [EMAIL PROTECTED] wrote on 05/13/2005 02:05:51 PM:
 

... Why take a flexible, dynamic database system and force it to
be fixed length.  This is what you are doing using dimensioned arrays 
   

and
 

MATREADs.  The most common justification I have heard is performance and
this simply doe not hold water. 
   

Have you ever compared performance between dynamic and dimensioned arrays, 
or are you just saying that you've never notice problems but have never 
tried dimensioned arrays?  I've seen it make a HUGE difference in Pick, 
UniVerse, and UniData.  If you reference many elements of a dynamic array 
many times, you'll burn a lot of CPU cycles just to locate the data.  When 
you reference an element of a dimensioned array, it's stored in separate 
address space, and is immediately referenced.

I have a standard way to avoid problems with the last attribute folding 
into the highest array element.  Just dimension the array one element 
larger than the highest attribute you reference in the program.  So if the 
highest attribute you reference is number 72, dimension the array at 73 or 
higher.  Where I used to work, we had an automated process that created 
file definitions, including standard equates and the code to dimension 
arrays.  We always created the arrays at one more than the highest 
attribute, and never had problems.  This won't be necessary in 
environments where the extra attributes are placed on element zero, but it 
won't hurt anything, either.  That way your code will be portable.

 

Payback during 2nd generation Pick was 10-20 attributes.  Back then, the 
problem was to not oversize because it slowed down the read/writing of 
the blank attributes.

Didn't we hear/read recently that the new compiler and/or run time 
machine  is keeping track of  individual attribute marks in dynamic 
arrays, so that a full string search is not necessary every time?

Roger
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UD] Increasing TCL Stack

2005-05-12 Thread Roger Glenfield
Don't know about increasing the number, but you can use 'SAVE.STACK' to 
save the current 99.

And then you can 'record' the 99 to a logging file, if you're trying to 
keep track of what they're doing.

Roger
Hruby, Paul wrote:
Greetings,
Is there anyway to increase the user stack from 49 lines when a user exits
the system?  I think I remember UniVerse was 99.  I'd like to increase this
to whatever I can if possible since there are only a few users at the TCL
level.
thanks in advance,
Paul
Paul Hruby
Police Database Coordinator
Scottsdale Police Department
*** Information sent from  received by this email address may be considered
public information ***
---
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] VOC Out-Of-Date Error Message

2005-05-04 Thread Roger Glenfield
Okay, the number of data * doesn't match the the number removed.
Is anything else wrong?
Roger
Brutzman, Bill wrote:
Using HP-Ux 11i with UniVerser 10.1, I get the following error message.
How can this problem be fixed?
--Bill
Your VOC is out of date. Update to current release (Y/N)?y
Your VOC is configured for Prime Information compatibility
Updating your VOC file.  (Each * = 10 records)

194 item(s) were removed from your VOC file and placed in
file TEMP to prevent them from being overwritten.
Updating your D_VOC file.  (Each * = 10 records)
*
11 item(s) were removed from your VOC file and placed in
file DICT TEMP to prevent them from being overwritten.
UniVerse Command Language 10.1
(c) Copyright IBM Corporation 2003. All rights reserved.
METAL logged on: Wed May  4 12:48:18 2005
---
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] Wedge Scanners

2005-04-29 Thread Roger Glenfield
Another source:  www.systemid.com
The wedge substitutes the data read by the scanner into keyboard 
entry.   But not all scanners will work with a wedge.  Terminal wedges 
are usually designed for specific manufacturers.

Or if you have old PCs that aren't in use right now, you can get another 
type of wedge.
Roger

Key Ally wrote:
Anthony,
   I've used Symbol Technologies scanners as wedge scanners. And 
you're right, the database shouldn't matter.

   - Chuck Wedg-ee Barouch
Anthony Caufield wrote:
I am curious as to what kind of wedge scanners people are using with
their dumb terminals. We have Wyse and Televideo terminals and we have
been asked to hook up scanners. I know I did this several years ago but
I cant remember what it was we used. So any input would be helpful. I
don't know if it matters on this but we are running UV 10.1.3 on a
Windows 2003 server.
---
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] uvo.net UvBasic .Net

2005-04-28 Thread Roger Glenfield
Isn't Universe/Unidata still using a runtime interpreter instead of 
generating assembler code?

David Jordan wrote:
The concept of having Basic.Net assembly language is one I am interested in
too.  One could write the business rules in PICK Basic in a class and use VB
or C# to develop the GUIs.  Best of Both Worlds.
I don't believe it is too complex; one of the open source PICK developers
may be able to adapt their compilers to the .Net framework to achieve this.
Regards
David Jordan
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Multiple OPEN statements

2005-04-16 Thread Roger Glenfield
Can't say for sure.  I remember seeing it in one of the old programs 
that I had to work on in 1976/77.

So I'm guessing very early Basic.  After all, as we all know.  Kevin 
only wanted to get a football program running.  So he probably didn't 
worry that much about data files.

Roger
Mark Johnson wrote:
How early Microdata. I have one client with November 1975 written source
code and it's the traditional
OPEN FILE1 TO F.FILE1 ELSE PRINT ELONGATED VERBOSE ERRORMESSAGE
OPEN FILE2 TO F.FILE2 ELSE PRINT ELONGATED VERBOSE ERRORMESSAGE
for their core programs, opening dozens of files.
Thanks.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Hold-file to CSV

2005-04-16 Thread Roger Glenfield
Monarch from Datawatch.  Converts report files into data.
Mark Johnson wrote:
The whole premise was to use the existing reports that are presently
designed and not re-engineer them.
Like many systems, this one is full of finished reports (both english and
databasic) and the object is to send them to the hold-file and convert from
there. I don't want to re-invent the report generation logic, just use the
hold files.
Thanks
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Multiple OPEN statements

2005-04-16 Thread Roger Glenfield
Senioritis has set in.  Yes Ken Simms.
Allen Bell wrote:
Who's Kevin?
Do you mean Ken Simms?
Roger Glenfield wrote:

Can't say for sure.  I remember seeing it in one of the old programs 
that I had to work on in 1976/77.

So I'm guessing very early Basic.  After all, as we all know.  Kevin 
only wanted to get a football program running.  So he probably didn't 
worry that much about data files.

Roger
Mark Johnson wrote:
How early Microdata. I have one client with November 1975 written 
source
code and it's the traditional
OPEN FILE1 TO F.FILE1 ELSE PRINT ELONGATED VERBOSE ERRORMESSAGE
OPEN FILE2 TO F.FILE2 ELSE PRINT ELONGATED VERBOSE ERRORMESSAGE
for their core programs, opening dozens of files.

Thanks.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Roaming Print Jobs

2005-04-15 Thread Roger Glenfield
Bill
Well, in UV/AIX.  Blank was the same as Form 0 as in zero.
SP.ASSIGN HS was the same as SP.ASSIGN HSF0
I never got around to trying to name the printers and the forms, I only 
used form numbers.   If you want to direct specific print outs to 
specific printers, you have to assign specific form numbers to the 
printers and the print jobs.

Use printer admin to assign form name to the printers.  I haven't tried 
recently, but users usually can't change the settings on a printer.  And 
can only change the settings on a print job that it owns.  Or the 
superuser.

In your job control proc,paragraph, program code SP.ASSIGN F1 or 
SP.ASSIGN F2 etc.
The print job will default to your standard setptr, but will be 
reassigned to whatever printer.  Of course, you can use SETPTR to do the 
same thing.  And/or change form lenght and other stuff such as blank 
pages/ejects.  Just remember to 'BRIEF' so it doesn't ask if the 
settings are okay.

Change only those jobs that you want directed to other then your main 
printer.  Remember to also include a reset at the end of the job so 
following printouts will default again.

Once multiple printers became available twenty years ago, most of my 
jobs defaulted to a standard printer.   We only modified those procs 
where the user wanted options.  My last two companies used a job 
scheduler that also asked about printer assignments, which annoyed the 
users but solved having to constantly make changes.

Good Luck
Roger
Brutzman, Bill wrote:
Right now, the FORM fields in the UV-Spooler are all blank.
We have something like three types of forms... 

  [1] blank paper (8.5 * 11)  ... laser printers
  [2] green_bar paper (wide carriage) ... impact printer 
  [3] checks 	 ... impact printer 

Considering the SETPTR command... FORM option... 
Perhaps the only way is to specify form names in the UV-Spooler like...
  Form = CUST
and update all of the corresponding SETPTR commands to say
  SETPTR... FORM CUST
Ugh...this would be a lot of work since many programs would be impacted.
Please confirm and thanks for writing...
--Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Roaming Print Jobs

2005-04-14 Thread Roger Glenfield
How are your printers setup  configed?  How are the jobs assigned?  Do 
you use form numbers?  What you're describing will happen if the first 
printer is busy and another printer is assigned the same form number as 
the first.

Roger
Brutzman, Bill wrote:
In both our old and new HP-Ux servers running UniVerse, when printing a job,
if the printer is busy, the job gets sent to another printer instead.
Suggestions would be appreciated.
--Bill
---
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/


[U2] duplicate messages

2005-04-08 Thread Roger Glenfield
No, it's not you.   First duplicate message seems to be from you,  
regarding system(49), at 4:47 pm.

Roger
Kevin King wrote:
First, is it just me or is everyone getting copies of yesterday's
posts?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UDT dynamic files

2005-03-17 Thread Roger Glenfield
If you're adding a lot of records to the archives at once and it was 
undersized, you're going to pay a hit while the system resizes on the 
fly.  If you're dramatically increasing the record count, it would be 
better to resize before copying.   Just as it's better to turn off 
indexing when copying records and rebuilding the index.

Roger
Chuck Mongiovi wrote:
Does anyone know what kind of a perfomance hit you take for using dynamic
files? .. I had thought that it was pretty minimal, since splitting
shouldn't occur too much, and merging almost never happens ..
Anyway, I was archiving data off of a dynamic file today and noticed that a
COPY command was taking a really long time .. I re-wrote the copy in BASIC
so I could put in display counters and got the same results .. I did some
testing and found that doing the same process (READ/COPY/DELETE) using a
STATIC file is faster by a factor of about 10 ..
Any ideas?
-Chuck
---
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]: Epicor

2005-03-16 Thread Roger Glenfield
Mostly true.   But how many systems are being chosen by the beancounters 
because they're standard?   Not because it helps to improve sales, 
manufacturing or operations, just accounting functions?  And then 
sales/manufacturing/operations has to adopt to the new, improved system?

If SAP and/or Oracle/Peoplesoft is that great, why are any other 
packages being bought?

Rog
[EMAIL PROTECTED] wrote:
Why is it us against them? as in IT vs the Bean counters?  Duh...that is where I always had my greatest problems as a project manager..getting IT and financial to play nice in the same sandbox.  

I hate to say it, but IT was always the worse of the two warring factions in 
this regard.  YOU ALL WORK FOR THE SAME COMPANY
An export tool has been used (and sometimes abused) for over 20 some odd years now.  Accounting wants pivot tables etc...they can create presentations, they reformat and consolidate, and sometimes it is the only way to get consolidated financials from disparate systems.  

If you had no idea why or if Accounting ever wanted spreadsheets, ask..if you 
think they don't...you've been living under a rock
--
Debster
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Question on File indexing...

2005-03-09 Thread Roger Glenfield
George
CREATE.INDEX FILE STATE NO.NULLS
CREATE.INDEX FILE ZIP NO.NULLS
And when no one needs to update the file
BUILD.INDEX FILE STATE
and from another terminal
BUILD.INDEX FILE ZIP
or from just one terminal
BUILD.INDEX FILE ALL
Which will generate a phantom for the other indexes.
Updating may resume when all of the indexes have finished generating.
George Gallen wrote:
I need to setup some file indexing, I've not used the internal B tree
indexes before, and I don't
  have my manuals with me today.
What do I need to do to setup a file for indexing?
I don't need any fancy indexing, just index on state and zip, about
200,000 items
Thanks
George
George Gallen
Senior Programmer/Analyst
Accounting/Data Division
[EMAIL PROTECTED]
ph:856.848.1000 Ext 220
SLACK Incorporated - An innovative information, education and management
company
http://www.slackinc.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] Order of criteria

2005-02-24 Thread Roger Glenfield
Under Universe 9.6, I found that it was much faster to do two selects, 
the first one with just the index and then the second for the rest of 
the conditions. 

The new versions are supposed to optimize for indexing and also for 
tfile conversions.

Roger
Kevin King wrote:
As I understand it, the query optimizer can shuffle things around as
necessary, but the real issue is whether any of the fields are
indexed.  If the fields are indexed you might get better response by
selecting those using an index first, and then subselecting the
remaining ones after the initial select has completed.  If you try to
select an indexed field alongside a couple of nonindexed fields, the
query optimizer may or may not choose to use the index; I'm still a
bit unclear as to the line there.
-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Aherne, John
Sent: Thursday, February 24, 2005 1:52 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Order of criteria
Hi All,
	Does the order of criteria matter in a select or list
statement, or is the execution order arbitrary? 

For example, if I wanted to select vendors who sell apples in Denver,
is Select vendors with location='Denver' and products='Apples' 
the same as Select vendors with products='Apples' and
location='Denver' 
Given that out of 300 vendors, 50 sell apples, and 100 are in denver,
and 15 of those in Denver sell apples.

If it does matter, should I put the criteria that is likely to return
the smallest result set first?
TIA,
John
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] Default Catalog?

2005-02-23 Thread Roger Glenfield
Yeah, I'm pretty sure if not globallyl or voc cataloged, it defaults to 
the calling program's file.  Been doing that for awhile.

Roger
Jacques G. wrote:
I've been working on a Universe 10.xx on an Dec Alpha
machine, I found an account where a subroutine was
being called and the routine wasn't catalogued in that
account.  It wasn't catalogued globally as well.
There seems to be some default at work where if the
subroutine isn't catalogued, it checks in the library
of the calling program ?  (Like the include statement
?).  

I've previously worked on versions 6.xx to 9.xx on a
HP-UX and I don't remember it doing this.  (But then,
most of the routines I used were usually in a
different library there)
Is this something new ?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] (ignore last email!) GE and LE question

2005-02-12 Thread Roger Glenfield
Universe 10 .PE /Windows 2000
Yes, Null passes a numeric test.  But, null will not pass that case 
statement.  Its not ge 1.

rog
[EMAIL PROTECTED] wrote:
I mispoke -17 would not be allowed, but null and 5.6 would still be allowed 
with this code below.
Will

In a message dated 2/11/2005 7:36:04 PM Pacific Standard Time, 
[EMAIL PROTECTED] writes:

 

CASE NUM(SEL) AND SEL GE 1 AND SEL LE MAX.VAL
Brenda this fix that you put in will allow yours users to enter nothing, and 
also to enter 5.6 or -17 as well.
Will Johnson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] GE and LE question

2005-02-11 Thread Roger Glenfield
Brenda Price wrote:
Will,
Since the input can be several alpha characters as well as numeric.  The fix is 
listed below.
CASE NUM(SEL) AND SEL GE 1 AND SEL LE MAX.VAL
Thank you everyone for the responses.  However, the programs were fixed before 
I asked the question.  The question was not how to fix the problem but why it 
occurred.  MAX.VAL represents the maximum attributes in a record in some cases, 
in others the maximum number of multi-values.
I just have a hard time visualizing why 1X is GE than 1 and LE 40 (from the program I tracked the error to).  We are assuming it has something to do with Scientific notation.
 

Or lack of typing?  Maybe the runtime sees a nonnumeric value and does a 
char conversion? 
1 = char(49) and variable MAX.VAL of 40 may be converted to char(52)  
char(48), which is more than char(49) char(88) aka 1X.

rog
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [AD] Programmer needed in New Jersey

2005-01-27 Thread Roger Glenfield
Rookies.
10355 days with MV and my age is 19571.  Now, where did I put my walker?
And no, we had Basic back then.
Dennis Bartlett wrote:
waal, ah'll be danged...
  you must be psychic.. ah'm 44 with 24 years...
-Original Message-
From: Phil Gurnee [mailto:[EMAIL PROTECTED]
Sent: Thursday, 27 January, 2005 9:44 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [AD] Programmer needed in New Jersey
Wouldn't that remove just about everybody from this list. Average age of
a multi-value programmer must be 45 with 10-25 years experience.
-
GWK BEPERK/LIMITED (REG: 1997/022252/06)
POSBUS 47 PO BOX 8730
DOUGLAS
Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes,
JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit,
WG M|lke, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl,
Sekr/Secr: E van Niekerk.
Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by:
http://www.gwk.co.za/DisclaimerVrywaring.asp
This e-mail is subjected to the disclaimer that can be viewed at:
http://www.gwk.co.za/DisclaimerVrywaring.asp
---
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] Customer Name Lookup

2005-01-19 Thread Roger Glenfield
Consider getting a zip code file so you can prompt for zip code before 
city/state and then having the user choose from the available town names 
and defaulting to state.  Bound to prevent a bunch of misspellings.

Mark Johnson wrote:
INDUSTRIAL and DISTRIBUTION were examples. I can't remember but there were a 
few that disappeared when I used a standard KEYWORD exclusion list.
Basically I'm looking for any help in the mis-spellings. MV traditionally 
doesn't have a spell checker and it probably wouldn't help with all the proper 
names. I have a client nead Philadelphia and you can imagine the hamburger 
helper to detect all the mis-spellings of Philadelphia to put back.
I may use the purge method to scrub the data and assign some consistency.
That's fine as a manual job for me, but on-going I think it's going to get out 
of hand as time goes on. Plus their user base is from another land so that 
enters in some mis-spellings.
Thanks.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Longstanding aversion to CNAME?

2004-07-22 Thread Roger Glenfield
hashing location of the new id is probably not the same as the old id, so
the record will still have to be removed/deleted from the original group
before writing it to new group.

Roger
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] Behalf Of Wendy Smoak
 Sent: Thursday, July 22, 2004 8:27 PM
 To: [EMAIL PROTECTED]
 Subject: [U2] Longstanding aversion to CNAME?


 It seems that CNAME is not a popular UniBasic command.  Is there some
 history here I'm not aware of, maybe it was unreliable?

 From a UniBasic program, why would you open a file, read a record, write
 it back to the same file under a different key, then delete the original
 record, when you could just:

   X.CMD = CNAME filename :X.ID:',':X.NEW.ID
   EXECUTE X.CMD

 No changes to the data are required.  For example, if a bunch of records
 get written with the wrong date embedded in the key.

 This situation came up on info-datatel.  Here, it happens so rarely that
 it's barely worth worrying about-- I'm just curious.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Proc

2004-06-26 Thread Roger Glenfield
It's not on Universe.  I had to convert all the b/add procs when moving from
GA 3820 to Universe.

Another Pick to Universe proc conversion issue, if your procs tried to
initialize the buffers with
IH/ / / / /
Make sure you don't have any extra spaces between the slashes.

Good luck.
Roger

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson
 Sent: Saturday, June 26, 2004 10:17 AM
 To: [EMAIL PROTECTED]
 Subject: Re: [U2] Proc


 Batch didn't make the cut from native to D3 conversions. I wonder if it's
 present on U2.

 - Original Message -
 From: Tom Dodds [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Friday, June 25, 2004 11:47 AM
 Subject: RE: [U2] Proc


  How about Batch Strings?
 
  Tom Dodds
  [EMAIL PROTECTED]
  630-235-2975
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Performance of File Universe

2004-06-25 Thread Roger Glenfield
a) you know that Micro$oft has cut off NT 4.0 support, as of about now?

b) 512 mb does seem small for anything Micro$oft related.  How many users?
And is the server used for anything else?

Roger

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] Behalf Of Cisar Riba
 Cervera
 Sent: Friday, June 25, 2004 9:04 AM
 To: [EMAIL PROTECTED]
 Subject: RE: [U2] Performancing of File Universe


 Hello,

   The size of record is about 300, and the OS is Windows NT.

 Cisar.

 Thanks.



 -Mensaje original-
 De: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] nombre de djordan
 Enviado el: viernes, 25 de junio de 2004 13:47
 Para: [EMAIL PROTECTED]
 Asunto: RE: [U2] Performancing of File Universe


 What is the size of the records, what OS are you running on?

 David Jordan

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Cisar
 Riba Cervera
 Sent: Friday, 25 June 2004 9:02 PM
 To: [EMAIL PROTECTED]
 Subject: RE: [U2] Performancing of File Universe


 Hello,


   I creating the Index and the time for the SELECT, is down to 5
 seconds, but I think that is very time. This is posible that the can is
 problem abouth memory bolcks or the server have chip memory (512 Mb RAM).


 Thanks.

 Cisar.
 ---
 Outgoing mail is certified Virus Free.
 Checked by AVG anti-virus system (http://www.grisoft.com).
 Version: 6.0.707 / Virus Database: 463 - Release Date: 15/06/2004
 ---
 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/

 ---
 Incoming mail is certified Virus Free.
 Checked by AVG anti-virus system (http://www.grisoft.com).
 Version: 6.0.707 / Virus Database: 463 - Release Date: 15/06/2004

 ---
 Outgoing mail is certified Virus Free.
 Checked by AVG anti-virus system (http://www.grisoft.com).
 Version: 6.0.707 / Virus Database: 463 - Release Date: 15/06/2004
 ---
 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] Printer Problem

2004-06-02 Thread Roger Glenfield
We had a QMS Kiss laser printer (mid 1980s).  One of it's standard features
was that it would not eject a 'blank' page.  It was considered a 'paper
saving feature'.  Very annoying if you forget to leave the eject option on.

Roger

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] Behalf Of Bjvrn Behr
 Sent: Wednesday, June 02, 2004 9:24 AM
 To: [EMAIL PROTECTED]
 Subject: RE: [U2] Printer Problem


 Wol

 Did suggest that. It has been set since, but on some reports it still does
 not work.

 The strangest of this to me, is that before we had Lexmark 2381
 on the same
 port with no problems,
 Now that we have replaced it with the 2480/2481 problems.

 PS: Both printers have been setup with the same settings  checked.

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


RE: [U2] [UD] Key Length Limit? [REPOST]

2004-05-28 Thread Roger Glenfield
Don

Do you have long file name turned off?

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] Behalf Of Don V
 Sent: Friday, May 28, 2004 12:53 PM
 To: [EMAIL PROTECTED]
 Subject: [U2] [UD] Key Length Limit? [REPOST]
 
 
 Is there a key length limit in UD [or SB]? I have a DIR type file 
 (Type 19 in UV) that I'm using to download my bank files to and 
 the filename length is 49.
 
 Yet if I do a LIST JPMORGAN_TEST I get:
 
  LIST JPMORGAN_TEST
 LIST JPMORGAN_TEST 16:06:04 MAY 26 2004 1
 JPMORGAN_TEST
 
 No records listed.
 
 The following record ids do not exist:
 80099_140013_20040524_144358_BulkAcct.re
 
 - - - - -
 The whole filename is:
 80099_140013_20040524_144358_BulkAcct.ret
 (notice the t and the end)
 
 Yet it's okay if it's 48 characters. Any ideas?
 
 HP-UX 11.11i / UD 5.2 / SB 5.3
 
 Thanks,
 
 --
 Donald Verhagen  
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users