Re: [U2] [OT] Travels with Mark: A Hitchhiker's Guide to the UniVerse, Part 1: Profiling the UniVerse

[Andy Pflueger]

>
> http://www-128.ibm.com/developerworks/edu/dm-dw-dm-0512baldridge-
> i.html?S_TACT=105AGX11&S_CMP=FP
>

A little tip for posting long URLs. As some mail clients may wrap this
URL making it unclickable, surrounding the entire hyperlink in "<" and
">" should helplike this:



Another alternative would be use www.notlong.com and convert the long
URL to a short one such as myshorturl.notlong.com.


--
The Linux philosophy is 'Laugh in the face of danger'.
Oops. Wrong One. 'Do it yourself'. Yes, that's it.
Linus Torvalds
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Fast file transfers

[Jeff Powell]

Susan,

We are on an AIX platform and we used NFS / CP to move from an IBM F50
to F80 recently. Additionally I use a CRON with find -mtime - 24 and cp
to copy anything that has changed in the last 24 hours so that old F50
becomes a standby system. This usually copies within 3 hours over a
100baseT network.

I'll be happy to provide scripts if you want them.

HTH

Jeff

On Mon, 2005-12-26 at 08:45 -0500, Susan Joslyn wrote:
> Greetings,
> 
> Anyone come up with a really clever way to move a great deal of data from
> one machine to another (completely different Multivalue Platforms; jbase ->
> Universe) all within the space of a weekend?
> 
> We've tried some of the telnet programs that have multivalue specific file
> transfers ... take too long.  Writing something on our own now -- but
> thought I'd check to see if one of you other smart guys or gals have solved
> this problem.
> 
> Cheers and TIA,
> Susan
> ---
> 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: Named common

[Keith W. Roberts]

Original Message
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin King
Sent: Tuesday, December 27, 2005 12:56 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UD: Named common

> And if you're using an include to bring in the named common, what's
> the big deal anyway?  Okay, so the named common name can't be larger
> than 7 characters.  Frankly, the 7 is a little weird (3 bits?) but
> considering we have so few limitations anyway and this one is so
> easily worked around for most apps, I just don't see anything of real
> concern. 
> 

Pooh!  A stupid (and antediluvian) restriction is still stupid (and
antediluvian) even if it can be worked around. :)

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

Re[2]: [U2] [OT] Travels with Mark: A Hitchhiker's Guide to the UniVerse, Part 1: Profiling the UniVerse

[David Tod Sigafoos]

another alternative is to join the lines and go to the url

Wednesday, December 28, 2005, 2:57:09 AM, you wrote:

AP> 
>>
>> http://www-128.ibm.com/developerworks/edu/dm-dw-dm-0512baldridge-
>> i.html?S_TACT=105AGX11&S_CMP=FP
>>

AP> A little tip for posting long URLs. As some mail clients may wrap this
AP> URL making it unclickable, surrounding the entire hyperlink in "<" and
">>" should helplike this:

AP> 


AP> Another alternative would be use www.notlong.com and convert the long
AP> URL to a short one such as myshorturl.notlong.com.




-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Should any political party attempt to abolish social security, unemployment 
insurance, and eliminate labor laws and farm programs, you would not hear of 
that party again in our political history. There is a tiny splinter group, of 
course, that believes you can do these things.  Among them are a few Texas oil 
millionaires, and an occasional politician or business man from other areas. 
Their number is negligible and they are stupid.  --President Dwight D. 
Eisenhower, 1954 (source:  Eisenhower Presidential Papers, Document #1147; 
November 8, 1954 The Papers of Dwight David Eisenhower, Volume XV - The 
Presidency: The Middle Way Part VI: Crises Abroad, Party Problems at Home; 
September 1954 to December 1954,) Chapter 13: "A new phase of political 
experience"
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] unoObjects File.Read Question

[George Smith]

The following code works if the item is on file but fails if item is not
on file. Is this correct, shouldn't it just return an empty string ?



If this behavior is the intended behavior then do we just wrap in a try
catch block.



Thanks for replies

george



// open customer file

UniFile fl = us1.CreateUniFile("CUSTOMER");



// read a record

UniDynArray ar_record = fl.Read("2");
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re[2]: [U2] UD: Named common

[David Tod Sigafoos]

Bill,

real programmers don't compile in PICK mode .. or use PICK .. they
just scale back the expectations 

Tuesday, December 27, 2005, 8:19:42 AM, you wrote:

BH> Of course, programs won't compile in PICK mode if the label exceeds 7
BH> characters.  :-)

>> -Original Message-
>> From: [EMAIL PROTECTED] 
>> [mailto:[EMAIL PROTECTED] On Behalf Of 
>> David Wolverton
>> Sent: Tuesday, December 27, 2005 4:58 AM
>> To: u2-users@listserver.u2ug.org
>> Subject: RE: [U2] UD: Named common
>> 
>> I probably should have been more clear -- that's why we 
>> rearranged and put our 'most unique' details at the front of 
>> the Named Common block -- but ulimately, we truncated all at 
>> 7 characters.
>> 
>> DW 
>> 
>> -Original Message-
>> 
>> >In terms of readability/maintainability, the named common 
>> label can be 
>> >more
>> than 7 characters, however - the first 7 >must be unique in 
>> your application (or much confusion can reign... :-(  )
>> 


-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

"...our behavior matters more than the beliefs that we  profess." Elizabeth 
Deutsch Earle
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re[2]: [U2] UD: Named common

[David Tod Sigafoos]

Keith,

Wednesday, December 28, 2005, 7:24:34 AM, you wrote:

>> And if you're using an include to bring in the named common, what's
>> the big deal anyway?  Okay, so the named common name can't be larger
>> than 7 characters.  Frankly, the 7 is a little weird (3 bits?) but
>> considering we have so few limitations anyway and this one is so
>> easily worked around for most apps, I just don't see anything of real
>> concern. 
>> 

KWR> Pooh!  A stupid (and antediluvian) restriction is still stupid (and
KWR> antediluvian) even if it can be worked around. :)


 bravo ..

 our customers expect a certain level of professionalism from use ..
 not bad if we expect the same from out vendors

-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

"Far better it is to dare mighty things, to win glorious triumphs even
though checkered by failure, than to rank with those poor spirits who
neither enjoy nor suffer much because they live in the gray twilight
that knows neither victory nor defeat." Theodore Roosevelt
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Travels with Mark: A Hitchhiker's Guide to the UniVerse, Part 1: Profiling the UniVerse

[Baakkonen, Rodney A (Rod) 46K]

Will there ever be a similar offering for Unidata? I struggle with
performance issues every day and would look forward any advice possible.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Clifton Oliver
Sent: Tuesday, December 27, 2005 11:45 PM
To: u2-users@listserver.u2ug.org
Cc: [EMAIL PROTECTED]
Subject: [U2] Travels with Mark: A Hitchhiker's Guide to the UniVerse,
Part 1: Profiling the UniVerse


For those of you who have been around The List for the 9 or so years  
I hosted it, you know I rarely give endorsements. This is one of  
those exceptions that pleases me. My friend and colleague, Mark  
Baldridge, has his first article published on IBM's Developer Works.  
The topic is profiling (benchmarking) UniVerse. For those of you who  
do not track Developer Works, this is a good time to start.


http://www-128.ibm.com/developerworks/edu/dm-dw-dm-0512baldridge- 
i.html?S_TACT=105AGX11&S_CMP=FP


I encourage everyone to access this article. U2 is getting more  
visibility within IBM. This is the kind of article that fulfills two  
purposes: first, it gives those of us in the U2 community much needed  
expertise and information; second, our support of this kind of  
article demonstrates to IBM our fervor for our database model and our  
U2 product loyalty.

Good on yer, Mark! We look forward to the next article in your series.


-- 

Regards,

Clif

President, International U2 Users 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: OT: [U2] UD: Named common

[Kevin King]

>Pooh!  A stupid (and antediluvian) restriction is still stupid (and
>antediluvian) even if it can be worked around. :)

>From Google:"define:antidiluvian": A term meaning or relating to a
timeless age wherein historical events "before the deluge" or "before
the Biblical Flood" took place. Because the destruction of the
Atlantean Maritime Kingdom was the result of COMET PHAETHON, which
caused the Biblical Flood, all global historical events and artifacts
of that time period belong to the ANTIDELUVIAN era. See ATLANTIS 1.



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

[U2] Posting looooong URL's

[Clifton Oliver]

Good point, Andy. I didn't know about www.notlong.com.  
www.tinyurl.com provides the same service. I wonder if, fearing a  
phishing attempt, there would be trepidation in clicking on a notlong  
or tinyurl link by someone who was not aware of these redirector  
services. But you've given me the idea of adding a Links area to  
Oliver.com. Thank you!



--

Regards,

Clif

~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER & ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
~~~


On Dec 28, 2005, at 2:57 AM, Andy Pflueger wrote:


A little tip for posting long URLs. As some mail clients may wrap this
URL making it unclickable, surrounding the entire hyperlink in "<" and
">" should helplike this:



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

RE: [U2] Travels with Mark:

[Wally Terhune]

Rod wrote:
"Will there ever be a similar offering for Unidata? I struggle with
performance issues every day and would look forward any advice possible."

Well, I have recently published another article that may be of interest to
you (Rod regarding RFS and deciphering sm.log messages. There is a link to
it on the U2 home page within developerWorks:

http://www.ibm.com/developerworks/db2/products/u2/

There are a number of other U2 articles available there, as well.

ps - for those of you accessing this page, I've sent a note off to the dw
folks suggesting Mark's tutorial should be highlighted there (it was just
published 12/22 - so possibly holiday schedules have gotten in the way of
getting this added to that page).

Wally Terhune
Manager - U2 Advanced Client Support
IBM Information Management
4700 South Syracuse Street, Denver, CO   80237
Tel:  303.773.7969
Fax: 303.773.5915
[EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] [UD] BASIC "LOCK"s

[David Wolverton]

Since we don't have Semaphore-like COMMON structures, I was going to use the
BASIC "LOCK" to know that a Phantom was running -- the lock missing would
tell me to start the process.

HOWEVER, if the phantom 'dies' - the documentation makes it read as if the
LOCK will stay engaged -- does anyone have practical knowledge if a phantom
falling over 'implies' an ECL QUIT?

I know I could use READU, but my understanding is that BASIC LOCKs use far
fewer resources to test - and as I will add a test for the Phantom being
'up' in several common routines, I don't want to cause extra bottlenecks.

(I really wish we had cross-process COMMON for things like this!)

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

[U2] RE: cross-process COMMON

[Tony Gravagno]

David Wolverton wrote:
> (I really wish we had cross-process COMMON for things
> like this!) 

Amen!  That's something that was ripe for development sometime in the 80's
but not a single one of the MV providers added the feature.  So many
applications are possible (not least of which would be MV-based multi-user
games ;) ) if users in different processes could share some common
workspace.  :)

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

RE: [U2] UD: Named common

[Bill Haskett]

Kevin:

You're correct that it's pretty easy to work around this problem...yes
they're in an include.  But, IMHO of course, the analysis that it's "no big
deal" is slightly off the mark.  

When we went from 300 baud to 1200 baud then to 4800 baud then to 9600 baud
all of us, well most of us anyway, would refuse to go back!  This is the
cost of progress.  That's the point here.  Either other systems have
progressed or other mvDbms products have progressed.  For U2 to keep up with
the front edge of technology some very important deficiencies need to be
addressed.  Limiting named common labels to seven characters is just one of
a numerous list of deficiencies.

Now, I'm not saying U2 is a bad product at all.  I'm just saying U2 can
certainly grow dramatically, if it appeals to new people and development.
In order to do this it's got to be easy to use and connect to and relatively
inexpensive to develop on.  

Certainly appealing to other mvDbms users/developers would be a good start.
It's difficult to warm up to the U2 products when it's terribly difficult to
move data and dictionaries into a U2 environment (re: see the T-DUMP and
Fast File Transfers list postings), working at TCL/ECL is like slicing
tomatoes with a stone knife, using a line editor is excruciatingly painful,
UniAdmin is unstable and doesn't include anywhere near the number of
administrative tasks needed, and UniDebugger is a good start but definitely
needs improvement.

So, following the good advice given by those such as you, I'm changing the
labels of the named common from "DtaSecurity_files" to "S_files", etc.  :-)

Thanks again.  The help I get from this list is greatly appreciated.

Bill
 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King
> Sent: Tuesday, December 27, 2005 12:56 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] UD: Named common
> 
> >On Behalf Of Mark Johnson
> >Perhaps the big difference is that while an older environment
> >could have hundreds of spreadsheets or basic programs, a MV
> >system probably won'd have but a few names common entities.
> 
> And if you're using an include to bring in the named common, 
> what's the big deal anyway?  Okay, so the named common name 
> can't be larger than 7 characters.  Frankly, the 7 is a 
> little weird (3 bits?) but considering we have so few 
> limitations anyway and this one is so easily worked around 
> for most apps, I just don't see anything of real concern.
> 
> -K
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UD] BASIC "LOCK"s

[Chuck Mongiovi]

David,
I don't currently use a READU on my UD system to "LOCK" phantoms, but I use it 
on UniVerse and it works unless you do an "End Task" on the UVSH process from 
the windows console .. Then you have to do some syntax of the UNLOCK command to 
fix things .. On my AIX machine, I use the listuser and ps commands to see if a 
phantom is actually still running .. This has it's quirks too ..

That being said, I tested a small phantom process and had it do a "LOCK 1" 
command and had it shutdown 3 ways without explicitly running a CLEAR.LOCKS 
command
1) normal exit (STOP)
2) deleteuser
3) input required

In all three cases, the LOCK went away .. I may start using this as a way to 
check that my phantoms are running ..

I know that UniVerse has similar LOCK syntax .. Does anyone else out there have 
any experience with LOCK and phantoms on UV?

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of David Wolverton
Sent: Wednesday, December 28, 2005 12:56 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UD] BASIC "LOCK"s


Since we don't have Semaphore-like COMMON structures, I was going to use the
BASIC "LOCK" to know that a Phantom was running -- the lock missing would
tell me to start the process.

HOWEVER, if the phantom 'dies' - the documentation makes it read as if the
LOCK will stay engaged -- does anyone have practical knowledge if a phantom
falling over 'implies' an ECL QUIT?

I know I could use READU, but my understanding is that BASIC LOCKs use far
fewer resources to test - and as I will add a test for the Phantom being
'up' in several common routines, I don't want to cause extra bottlenecks.

(I really wish we had cross-process COMMON for things like this!)

Thanks -
David W.
---
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] BASIC "LOCK"s

[D Averch]

When the phantom dies the semaphore lock get released.  We use this
mechanism for all of our background processes and it works like a champ.

Doug
www.u2logic.com

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton
Sent: Wednesday, December 28, 2005 10:56 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UD] BASIC "LOCK"s

Since we don't have Semaphore-like COMMON structures, I was going to use the
BASIC "LOCK" to know that a Phantom was running -- the lock missing would
tell me to start the process.

HOWEVER, if the phantom 'dies' - the documentation makes it read as if the
LOCK will stay engaged -- does anyone have practical knowledge if a phantom
falling over 'implies' an ECL QUIT?

I know I could use READU, but my understanding is that BASIC LOCKs use far
fewer resources to test - and as I will add a test for the Phantom being
'up' in several common routines, I don't want to cause extra bottlenecks.

(I really wish we had cross-process COMMON for things like this!)

Thanks -
David W.
---
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] Record count from an I-descriptor in the VOC

[Wendy Smoak]

In UniData 6.1, I need to list the F-type VOC items with counts of the
records and dictionary items.

So I though I'd select the items from VOC, then

LIST VOC A51.COUNT.FILE A51.COUNT.DICT

where those two fields are I-Descriptors that call a subroutine...

SUBROUTINE S.A51.COUNT.RECORDS( RESULT, FILENAME, DICT, X1, X2 )
   HUSH ON
   EXECUTE "COUNT ":DICT:" ":FILENAME
   RESULT = @SYSTEM.RETURN.CODE
   HUSH OFF
   RETURN

... passing the filename (@ID of VOC) and either "DICT" or nothing, depending.

It works great if you only want to list one record!  Either changing
@SYSTEM.RETURN.CODE or (more likely, a coworker pointed out,) changing
the active select list is causing a problem.

I'm still experimenting, but does anyone have other ideas of how I can
get this?  I need three columns:  the filename (@ID of VOC), the count
of records and the count of items in the dictionary.

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

RE: [U2] Travels with Mark:

[Baakkonen, Rodney A (Rod) 46K]

Thanks for the link Wally. I will look through it.


http://www.ibm.com/developerworks/db2/products/u2/

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

RE: [U2] [UD] BASIC "LOCK"s

[David Wolverton]

Thanks for doing those tests - I just thought someone would have already
done them and spout from memory! 

And really thanks for the validation - and I do think it bangs less on the
machine doing it this way.

But GOLLY I wish we had Cross-Process COMMON (and I wasn't even thinking of
MultiPlayer Games, Tony! )

DW

>-Original Message-
>From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Chuck Mongiovi
...
>That being said, I tested a small phantom process and had it do a "LOCK 1"
command and had it shutdown 3 ways without >explicitly running a CLEAR.LOCKS
command
>1) normal exit (STOP)
>2) deleteuser
>3) input required

>In all three cases, the LOCK went away .. I may start using this as a way
to check that my phantoms are running ..
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Record count from an I-descriptor in the VOC

[Koser, Mike]

Wendy
Try this:

RESULT<-1> = @SYSTEM.RETURN.CODE

Keep in mind that you are counting multiple records in the VOC.

I used the <-1> with your code and got the following result when I listing
10 records from my VOC.

LIST VOC DATA.RECORDS DICT.RECORDS 14:49:55 Dec 28 2005 1

   DATADICT

VOC... RECORDS RECORDS

 

PARTIAL.ORDER.FILE.PROMO 1 562

ORDER.LOG.PROMO 234065  10

ABBREVIATION   154   6

PARTS.FILE.PROMO  2255 220

UCC.XREF   1874862  52

MASTER.SKID -1  -1

MASTER.BILL.70  -1

privilege2   7

DICT.REFORMAT.UDT   -1  -1

UCC.XREF.0 1874865  52

10 records listed


Mike


-Original Message-
From: Wendy Smoak [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 28, 2005 2:16 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Record count from an I-descriptor in the VOC


In UniData 6.1, I need to list the F-type VOC items with counts of the
records and dictionary items.

So I though I'd select the items from VOC, then

LIST VOC A51.COUNT.FILE A51.COUNT.DICT

where those two fields are I-Descriptors that call a subroutine...

SUBROUTINE S.A51.COUNT.RECORDS( RESULT, FILENAME, DICT, X1, X2 )
   HUSH ON
   EXECUTE "COUNT ":DICT:" ":FILENAME
   RESULT = @SYSTEM.RETURN.CODE
   HUSH OFF
   RETURN

... passing the filename (@ID of VOC) and either "DICT" or nothing,
depending.

It works great if you only want to list one record!  Either changing
@SYSTEM.RETURN.CODE or (more likely, a coworker pointed out,) changing
the active select list is causing a problem.

I'm still experimenting, but does anyone have other ideas of how I can
get this?  I need three columns:  the filename (@ID of VOC), the count
of records and the count of items in the dictionary.

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

__
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.
__

__
This e-mail has been scanned by MCI Managed Email Content Service, using 
Skeptic(tm) technology powered by MessageLabs. For more information on MCI's 
Managed Email  Content Service, visit http://www.mci.com.
__
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: Re[2]: [U2] UD: Named common

[Bill Haskett]

:-)

Bill
 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> David Tod Sigafoos
> Sent: Wednesday, December 28, 2005 7:56 AM
> To: Bill Haskett
> Subject: Re[2]: [U2] UD: Named common
> 
> Bill,
> 
> real programmers don't compile in PICK mode .. or use PICK .. 
> they just scale back the expectations 
> 
> Tuesday, December 27, 2005, 8:19:42 AM, you wrote:
> 
> BH> Of course, programs won't compile in PICK mode if the 
> label exceeds 7 characters.  :-)
> 
> >> -Original Message-
> >> From: [EMAIL PROTECTED]
> >> [mailto:[EMAIL PROTECTED] On Behalf Of David 
> >> Wolverton
> >> Sent: Tuesday, December 27, 2005 4:58 AM
> >> To: u2-users@listserver.u2ug.org
> >> Subject: RE: [U2] UD: Named common
> >> 
> >> I probably should have been more clear -- that's why we rearranged 
> >> and put our 'most unique' details at the front of the Named Common 
> >> block -- but ulimately, we truncated all at
> >> 7 characters.
> >> 
> >> DW
> >> 
> >> -Original Message-
> >> 
> >> >In terms of readability/maintainability, the named common
> >> label can be
> >> >more
> >> than 7 characters, however - the first 7 >must be unique in your 
> >> application (or much confusion can reign... :-(  )
> >> 
> 
> 
> -- 
> DSig `
> David Tod Sigafoos  ( O O )
>  ___oOOo__( )__oOOo___
> 
> "...our behavior matters more than the beliefs that we  
> profess." Elizabeth Deutsch Earle
> ---
> 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] Fast file transfers

[Don Kibbey]

rsync is your friend!  Put a copy of this on both systems and then run
something similar to this.

echo "--- Processing APS ---"
/usr/local/bin/rsync -avzrpog --stats /dbms/APS [EMAIL PROTECTED]::dbms 
--password-file
=/root/reston

Makes a copy of the CHANGED files from one system to another at the
bit level.  Works great, and is easy on the bandwidth.

On 12/28/05, Jeff Powell <[EMAIL PROTECTED]> wrote:
> Susan,
>
> We are on an AIX platform and we used NFS / CP to move from an IBM F50
> to F80 recently. Additionally I use a CRON with find -mtime - 24 and cp
> to copy anything that has changed in the last 24 hours so that old F50
> becomes a standby system. This usually copies within 3 hours over a
> 100baseT network.
>
> I'll be happy to provide scripts if you want them.
>
> HTH
>
> Jeff
>
> On Mon, 2005-12-26 at 08:45 -0500, Susan Joslyn wrote:
> > Greetings,
> >
> > Anyone come up with a really clever way to move a great deal of data from
> > one machine to another (completely different Multivalue Platforms; jbase ->
> > Universe) all within the space of a weekend?
> >
> > We've tried some of the telnet programs that have multivalue specific file
> > transfers ... take too long.  Writing something on our own now -- but
> > thought I'd check to see if one of you other smart guys or gals have solved
> > this problem.
> >
> > Cheers and TIA,
> > Susan
> > ---
> > 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/
>


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

Re: [U2] Record count from an I-descriptor in the VOC

[Wendy Smoak]

On 12/28/05, Koser, Mike <[EMAIL PROTECTED]> wrote:

> RESULT<-1> = @SYSTEM.RETURN.CODE
>
> Keep in mind that you are counting multiple records in the VOC.

I *think* I'm counting records in the file whose name matches the @ID
of VOC as we're iterating through the select list.  I'm only returning
one count at a time... the subroutine gets called once for each key. 
Right?

> I used the <-1> with your code and got the following result when I listing
> 10 records from my VOC.
>
> LIST VOC DATA.RECORDS DICT.RECORDS 14:49:55 Dec 28 2005 1
>DATADICT
> VOC... RECORDS RECORDS
> PARTIAL.ORDER.FILE.PROMO 1 562
> ORDER.LOG.PROMO 234065  10

With or without the <-1>, I get

: SELECT VOC WITH F1 = "F" SAMPLE 2
2 records selected to list 0.
> LIST VOC A51.COUNT.FILE A51.COUNT.DICT

LIST VOC A51.COUNT.FILE A51.COUNT.DICT 13:48:31 Dec 28 2005 1
VOC. Record Count Dictionary Count

PERSON  0 3909
1 record listed

It only ever lists one line.  The record count for PERSON is wrong
(but the dictionary count is correct. (Yes, really.) )

Mike, do your I-Descriptors just look like this:
:AE DICT VOC A51.COUNT.FILE
Top of "A51.COUNT.FILE" in "DICT VOC", 9 lines, 125 characters.
001: I
002: SUBR("S.A51.COUNT.RECORDS",@ID,'','','')
003:
004: Record Count
005: 10R
006: S
007:
008: A51.COUNT.FILE}}SUBR("S.A51.COUNT.RECORDS",@ID,'','','')
009: VOC
Bottom.

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

[U2] Alternate Indexes

[Mark Waldron]

We just converted from DG/UX to Win/2003 UV 10.1.11 over the Christmas
extended weekend.  Everything went pretty well considering. My problem is my
Alternate indexes will not stay Enabled.  We Enable and Rebuild the indexes
but for some reason they won't stay.  We do a LIST.INDEX and it shows

:LIST.INDEX DELIN ALL
Alternate Key Index Summary for file DELIN
File... DELIN
Indices 2 (0 A-type, 0 C-type, 2 D-type, 0 I-type, 0 SQL, 0 S-type)
Index Updates.. Disabled, Indices require updating

Index name  Type  BuildNulls  In DICT  S/M  Just Unique Field
num/I-type
TAXNODNot Reqd  YesYes  SL N6
LOAN.CO.NO   DNot Reqd  YesYes  SR N27


Any suggestions.


Mark Waldron
City of Salem, Va
Email  [EMAIL PROTECTED]

---
[This E-mail scanned for viruses by Declude Virus]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] unoObjects File.Read Question

[Don Kibbey]

>From the semi colons (all hail the mighty semi colon!) I will guess
your using c# to do this.  If you want to "know" about your record not
being there, you'll have to use a try catch block to deal with the
exception that will be thrown when the file read occurs and no record
exists.


On 12/28/05, George Smith <[EMAIL PROTECTED]> wrote:
> The following code works if the item is on file but fails if item is not
> on file. Is this correct, shouldn't it just return an empty string ?
>
>
>
> If this behavior is the intended behavior then do we just wrap in a try
> catch block.
>
>
>
> Thanks for replies
>
> george
>
>
>
> // open customer file
>
> UniFile fl = us1.CreateUniFile("CUSTOMER");
>
>
>
> // read a record
>
> UniDynArray ar_record = fl.Read("2");
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
>


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

RE: [U2] Record count from an I-descriptor in the VOC

[David A. Green]

You will lose your active SELECT list if you don't save it and restore it.

Thank you,
David A. Green
DAG Consulting
(480) 813-1725
www.dagconsulting.com


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wendy Smoak
Sent: Wednesday, December 28, 2005 12:16 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Record count from an I-descriptor in the VOC

In UniData 6.1, I need to list the F-type VOC items with counts of the
records and dictionary items.

So I though I'd select the items from VOC, then

LIST VOC A51.COUNT.FILE A51.COUNT.DICT

where those two fields are I-Descriptors that call a subroutine...

SUBROUTINE S.A51.COUNT.RECORDS( RESULT, FILENAME, DICT, X1, X2 )
   HUSH ON
   EXECUTE "COUNT ":DICT:" ":FILENAME
   RESULT = @SYSTEM.RETURN.CODE
   HUSH OFF
   RETURN

... passing the filename (@ID of VOC) and either "DICT" or nothing,
depending.

It works great if you only want to list one record!  Either changing
@SYSTEM.RETURN.CODE or (more likely, a coworker pointed out,) changing
the active select list is causing a problem.

I'm still experimenting, but does anyone have other ideas of how I can
get this?  I need three columns:  the filename (@ID of VOC), the count
of records and the count of items in the dictionary.

Thanks,
Wendy Smoak
---
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] Record count from an I-descriptor in the VOC

[Koser, Mike]

Wendy
The dictionary entries look like this;

ED DICT VOC DATA.RECORDS

Top of "DATA.RECORDS" in "DICT VOC", 6 lines, 55 characters.

001: V

002: SUBR('COUNT.RECORDS',@ID,"","","")

003:

004: DATA}RECORDS

005: 7R

006: M  

Also, did you remember to re-catalog the subroutine after the <-1> change? I
sometimes forget.
The subroutine is called once for each file and the variable is built up
with each call.

Mike


-Original Message-
From: Wendy Smoak [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 28, 2005 4:02 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Record count from an I-descriptor in the VOC


On 12/28/05, Koser, Mike <[EMAIL PROTECTED]> wrote:

> RESULT<-1> = @SYSTEM.RETURN.CODE
>
> Keep in mind that you are counting multiple records in the VOC.

I *think* I'm counting records in the file whose name matches the @ID
of VOC as we're iterating through the select list.  I'm only returning
one count at a time... the subroutine gets called once for each key. 
Right?

> I used the <-1> with your code and got the following result when I listing
> 10 records from my VOC.
>
> LIST VOC DATA.RECORDS DICT.RECORDS 14:49:55 Dec 28 2005 1
>DATADICT
> VOC... RECORDS RECORDS
> PARTIAL.ORDER.FILE.PROMO 1 562
> ORDER.LOG.PROMO 234065  10

With or without the <-1>, I get

: SELECT VOC WITH F1 = "F" SAMPLE 2
2 records selected to list 0.
> LIST VOC A51.COUNT.FILE A51.COUNT.DICT

LIST VOC A51.COUNT.FILE A51.COUNT.DICT 13:48:31 Dec 28 2005 1
VOC. Record Count Dictionary Count

PERSON  0 3909
1 record listed

It only ever lists one line.  The record count for PERSON is wrong
(but the dictionary count is correct. (Yes, really.) )

Mike, do your I-Descriptors just look like this:
:AE DICT VOC A51.COUNT.FILE
Top of "A51.COUNT.FILE" in "DICT VOC", 9 lines, 125 characters.
001: I
002: SUBR("S.A51.COUNT.RECORDS",@ID,'','','')
003:
004: Record Count
005: 10R
006: S
007:
008: A51.COUNT.FILE}}SUBR("S.A51.COUNT.RECORDS",@ID,'','','')
009: VOC
Bottom.

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

__
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.
__

__
This e-mail has been scanned by MCI Managed Email Content Service, using 
Skeptic(tm) technology powered by MessageLabs. For more information on MCI's 
Managed Email  Content Service, visit http://www.mci.com.
__
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Record count from an I-descriptor in the VOC

[Mike Rajkowski]

It only ever lists one line.  The record count for PERSON is wrong
(but the dictionary count is correct. (Yes, really.) )


Looking at the code I would expect that. The active select list is
exhausted when you hit the first count.  Since none of the items in the
person file are in the select list no items are counted. ( 0 Items )
The second call to the dictionary items does not have an active select
list, so there is no problem.

Yet when the query looks for the next item to display, there is no more
items in the select list, so it stops.

( While the following is not a good work around it is a work around )

SUBROUTINE S.A51.COUNT.RECORDS( RESULT, FILENAME, DICT, X1, X2 )
HUSH ON
EXECUTE "SAVE.LIST MIKE"
EXECUTE "COUNT ":DICT:" ":FILENAME
RESULT = @SYSTEM.RETURN.CODE
EXECUTE "GET.LIST MIKE"
HUSH OFF
RETURN

 You do not need to use the variable name MIKE ;) 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Record count from an I-descriptor in the VOC

[Mike Rajkowski]

You may also have problems if the file ( or dict file ) is invalid or
does not exist. ( You will get a -1 )

Note, can also get around the select list issue, if you include the
select criteria on the list statement.

LIST VOC A51.COUNT.FILE A51.COUNT.DICT WITH F1 = "F"

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

Re: [U2] Alternate Indexes

[Jerry Banker]

Did you create the indexes on the new system or did you copy them over from 
the other system?


- Original Message - 
From: "Mark Waldron" <[EMAIL PROTECTED]>

To: 
Sent: Wednesday, December 28, 2005 3:12 PM
Subject: [U2] Alternate Indexes



We just converted from DG/UX to Win/2003 UV 10.1.11 over the Christmas
extended weekend.  Everything went pretty well considering. My problem is 
my
Alternate indexes will not stay Enabled.  We Enable and Rebuild the 
indexes

but for some reason they won't stay.  We do a LIST.INDEX and it shows

:LIST.INDEX DELIN ALL
Alternate Key Index Summary for file DELIN
File... DELIN
Indices 2 (0 A-type, 0 C-type, 2 D-type, 0 I-type, 0 SQL, 0 
S-type)

Index Updates.. Disabled, Indices require updating

Index name  Type  BuildNulls  In DICT  S/M  Just Unique Field
num/I-type
TAXNODNot Reqd  YesYes  SL N6
LOAN.CO.NO   DNot Reqd  YesYes  SR N27


Any suggestions.


Mark Waldron
City of Salem, Va
Email  [EMAIL PROTECTED]

---
[This E-mail scanned for viruses by Declude Virus]
---
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] Alternate Indexes

[Mark Eastwood]

Maybe the Index Pointer is confused since the Account's path has
changed; try using "SET.INDEX DELIN TO NULL" and re-create/build the
indexes? 

Mark

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Waldron
Sent: Wednesday, December 28, 2005 2:12 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Alternate Indexes

We just converted from DG/UX to Win/2003 UV 10.1.11 over the Christmas
extended weekend.  Everything went pretty well considering. My problem
is my
Alternate indexes will not stay Enabled.  We Enable and Rebuild the
indexes
but for some reason they won't stay.  We do a LIST.INDEX and it shows

:LIST.INDEX DELIN ALL
Alternate Key Index Summary for file DELIN
File... DELIN
Indices 2 (0 A-type, 0 C-type, 2 D-type, 0 I-type, 0 SQL, 0
S-type)
Index Updates.. Disabled, Indices require updating

Index name  Type  BuildNulls  In DICT  S/M  Just Unique Field
num/I-type
TAXNODNot Reqd  YesYes  SL N6
LOAN.CO.NO   DNot Reqd  YesYes  SR N27


Any suggestions.


Mark Waldron
City of Salem, Va
Email  [EMAIL PROTECTED]

---
[This E-mail scanned for viruses by Declude Virus]
---
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] BASIC "LOCK"s

[Womack, Adrian]

We use READU locks - they're much more friendly than semaphores as they can be
given meaningful names that show up with a LIST.READU.

Also they are very quick and easy to test with the RECORDLOCKED() function -
eg.

   IF NOT(RECORDLOCKED(filevar, recordname)) THEN ...

AdrianW







DISCLAIMER:
Disclaimer.  This e-mail is private and confidential. If you are not the
intended recipient, please advise us by return e-mail immediately, and delete
the e-mail and any attachments without using or disclosing the contents in any
way. The views expressed in this e-mail are those of the author, and do not
represent those of this company unless this is clearly indicated. You should
scan this e-mail and any attachments for viruses. This company accepts no
liability for any direct or indirect damage or loss resulting from the use of
any attachments to this e-mail.

[demime 1.01d removed an attachment of type application/ms-tnef which had a 
name of winmail.dat]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Record count from an I-descriptor in the VOC

[Hona, David S]

Performing a query from within a query is always going to cause
problems.
I think this topic has been covered before, but in relation to
performing a SELECT from within an subroutine called from an I-type
dictionary item.

Regards,
David



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wendy Smoak
Sent: Thursday, December 29, 2005 6:16 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Record count from an I-descriptor in the VOC

In UniData 6.1, I need to list the F-type VOC items with counts of the
records and dictionary items.

So I though I'd select the items from VOC, then

LIST VOC A51.COUNT.FILE A51.COUNT.DICT

where those two fields are I-Descriptors that call a subroutine...

SUBROUTINE S.A51.COUNT.RECORDS( RESULT, FILENAME, DICT, X1, X2 )
   HUSH ON
   EXECUTE "COUNT ":DICT:" ":FILENAME
   RESULT = @SYSTEM.RETURN.CODE
   HUSH OFF
   RETURN

... passing the filename (@ID of VOC) and either "DICT" or nothing,
depending.

It works great if you only want to list one record!  Either changing
@SYSTEM.RETURN.CODE or (more likely, a coworker pointed out,) changing
the active select list is causing a problem.

I'm still experimenting, but does anyone have other ideas of how I can
get this?  I need three columns:  the filename (@ID of VOC), the count
of records and the count of items in the dictionary.

Thanks,
Wendy Smoak
---
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] Record count from an I-descriptor in the VOC

[Wendy Smoak]

On 12/28/05, Mike Rajkowski <[EMAIL PROTECTED]> wrote:

> Looking at the code I would expect that. The active select list is
> exhausted when you hit the first count.  Since none of the items in the
> person file are in the select list no items are counted. ( 0 Items )
> The second call to the dictionary items does not have an active select
> list, so there is no problem.
>
> Yet when the query looks for the next item to display, there is no more
> items in the select list, so it stops.
>
> ( While the following is not a good work around it is a work around )

A coworker suggested basically the same thing, but with
READLIST/FORMLIST instead of SAVE.LIST/GET.LIST.

Thanks!  (This is a one-off 'how many files, records and dictionary
items do we have?', not something we'll be running often, so 'work
around' is fine.  I should have just done it from UniBasic and skipped
the I-Descriptors...)

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

RE: [U2] Record count from an I-descriptor in the VOC

[Gyle Iverson]

Wendy Smoak
>A coworker suggested basically the same thing, but with
>READLIST/FORMLIST instead of SAVE.LIST/GET.LIST.

That is a lot of mucking about with select-list 0. For more efficiency
without changing your subroutine, try:

SELECT VOC WITH criteria TO 1
LIST VOC FROM 1 A51.COUNT.FILE A51.COUNT.DICT

No work arounds are required with this approach, though I suggest adding a
test to your subroutine to abort if select-list 0 is active.

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

RE: [U2] Record count from an I-descriptor in the VOC

[Walter Pearson]

Wendy,
I setup the following and got the results I think you are looking for
without the need for selecting the VOC.

AE DICT VOC CTR
001: I
002: SUBR("CTR.VOC",@ID)
003:
004: FILE COUNT DICT COUNT
005: L#21
006: S

AE BP CTR.VOC
001: SUBROUTINE CTR.VOC(RESULT,ID)
002: RESULT = ""
003: EXECUTE 'COUNT ':ID CAPTURING OUTPUT
004: IF @SYSTEM.RETURN.CODE < 0 THEN
005:   RESULT = "EMPTY "
006: END ELSE
007:   RESULT = @SYSTEM.RETURN.CODE"L#10"
008: END
009: EXECUTE 'COUNT DICT ':ID CAPTURING OUTPUT
010: IF @SYSTEM.RETURN.CODE < 0 THEN
011:   RESULT<-1> = "EMPTY "
012: END ELSE
013:   RESULT<-1> = @SYSTEM.RETURN.CODE"L#10"
014: END
015: RESULT = CHANGE(RESULT,@AM," ")
016: RETURN
017: END
After you compile and catalog the subroutine all that you have to do is
a straight LIST or SORT of the VOC as follows:

LIST (OR SORT) VOC WITH F1 = "F" CTR

Walter

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wendy Smoak
Sent: Wednesday, December 28, 2005 1:16 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Record count from an I-descriptor in the VOC


In UniData 6.1, I need to list the F-type VOC items with counts of the
records and dictionary items.

So I though I'd select the items from VOC, then

LIST VOC A51.COUNT.FILE A51.COUNT.DICT

where those two fields are I-Descriptors that call a subroutine...

SUBROUTINE S.A51.COUNT.RECORDS( RESULT, FILENAME, DICT, X1, X2 )
   HUSH ON
   EXECUTE "COUNT ":DICT:" ":FILENAME
   RESULT = @SYSTEM.RETURN.CODE
   HUSH OFF
   RETURN

... passing the filename (@ID of VOC) and either "DICT" or nothing,
depending.

It works great if you only want to list one record!  Either changing
@SYSTEM.RETURN.CODE or (more likely, a coworker pointed out,) changing
the active select list is causing a problem.

I'm still experimenting, but does anyone have other ideas of how I can
get this?  I need three columns:  the filename (@ID of VOC), the count
of records and the count of items in the dictionary.

Thanks,
Wendy Smoak
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 0552-1, 12/28/2005
Tested on: 12/28/2005 11:52:45 PM
avast! - copyright (c) 1988-2004 ALWIL Software.
http://www.avast.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UD: Named common

[colin.alfke]

Bill;

Can't argue much about the 7 character limit on the common names. I'm not sure
why it will compile in basictype 'u' and not 'p'. It just seems awfully
dangerous to let it compile at all.

We moved a lot of systems from Pick to UniData quite easily. ACCT_RESTORE
would even read Pick tapes (AP/pro, AP/Sco, AP/Aix) although quite slowly. We
had an AP/Aix box that I used to restore file-save tapes, make sure all of the
filenames were upper-cased (made the restore into UniData go much cleaner),
and then did a save to a pseudo-floppy - which was a Unix file. Copied the
file to the NT box (ftp or SFU) and then did the restore. Worked very quickly.
Even had a larger system that I had to put compression on the pseudo-floppy to
keep under 2GB and used WinZip to unzip (which was way faster than cygwin).
Not sure why you had so much trouble getting UniVerse to dump to a file
instead of tape.

TCL/ECL is much like every other system (even MS/SQL as I get more exposure to
it). I started with Pick, and we use SB+ which requires ecltype 'p' so that is
what I use most of the time; however, sometimes I use the lower case commands
to get the 'u' type as there can be some power there.

With UniData the program files are simple text files. You can use any editor
you like on them. Some of my favourites that actually understand the
environment: SE (in SB+),. UniDebugger, UniEditor from
, U2Logic
www.u2logic.com just put out U2Editor. There are a couple that worked in a
telnet session - but I think the biggest trouble with them is the terminal
emulation. As Mark recently pointed out, working with terminal emulators can
be quite painful. There are a couple on www.picksource.com that you may find
useful. That being said, there are some handy things in AE that come in handy
(especially EV although that's more for data than programming). I don't use
UniAdmin much - mainly just the initial config. It seemed to have pretty much
everything in it - I just found some of the account/file stuff was a little
flakey.

There is an area on www.u2ug.org that is for enhancement requests. There is
also a committee to help promote these enhancements to IBM. Put out your
ideas, get some support, and get them implemented!

Colin "not sure why I'm so defensive - but at least I'm not commenting on the
weather" Alfke
Calgary, Canada



From:  Bill Haskett

Kevin:

You're correct that it's pretty easy to work around this problem...yes
they're in an include.  But, IMHO of course, the analysis that it's "no big
deal" is slightly off the mark.

When we went from 300 baud to 1200 baud then to 4800 baud then to 9600 baud
all of us, well most of us anyway, would refuse to go back!  This is the
cost of progress.  That's the point here.  Either other systems have
progressed or other mvDbms products have progressed.  For U2 to keep up with
the front edge of technology some very important deficiencies need to be
addressed.  Limiting named common labels to seven characters is just one of
a numerous list of deficiencies.

Now, I'm not saying U2 is a bad product at all.  I'm just saying U2 can
certainly grow dramatically, if it appeals to new people and development.
In order to do this it's got to be easy to use and connect to and relatively
inexpensive to develop on.

Certainly appealing to other mvDbms users/developers would be a good start.
It's difficult to warm up to the U2 products when it's terribly difficult to
move data and dictionaries into a U2 environment (re: see the T-DUMP and
Fast File Transfers list postings), working at TCL/ECL is like slicing
tomatoes with a stone knife, using a line editor is excruciatingly painful,
UniAdmin is unstable and doesn't include anywhere near the number of
administrative tasks needed, and UniDebugger is a good start but definitely
needs improvement.

So, following the good advice given by those such as you, I'm changing the
labels of the named common from "DtaSecurity_files" to "S_files", etc.  :-)

Thanks again.  The help I get from this list is greatly appreciated.

Bill

[demime 1.01d removed an attachment of type application/ms-tnef which had a 
name of winmail.dat]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/