Re: [U2] Why don't calendars show the pick date?

[jpb-u2ug]

Simple if you have a calendar that shows the Julian date. Find out what the
internal date for December 31st of the previous year is and write it
somewhere on the calendar. Then all you have to do is add the Julian date to
it. 

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, November 11, 2010 8:01 AM
To: U2 Users List
Subject: [U2] Why don't calendars show the pick date?

Wouldn't it be so much easier if those desk calendars and wall calendars had
the pick date on them,
as well as the julian date.that would make them so much more useful!


George Gallen
Senior Programmer/Analyst
Accounting/Data Division, EDI Administrator
ggal...@wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com



___
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 On RedHat?

[jpb-u2ug]

I've never moved UV from HP-Ux to Red Hat but I have worked on both. We went
from a Sun Risc system to Red Hat on Intel and, like Drew said, you would
have to do recompiling of programs and I-descriptors, and either
uvbackup/uvrestore or fnuxi the files. If you use any operating system
scripts or programs those will have to be checked for differences. The
spooler should work pretty much the same. I did our conversion on a Saturday
morning. Moving from a 'nix system to Windows was not as easy.

Jerry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Friday, November 05, 2010 4:59 PM
To: U2 Users List
Subject: [U2] UniVerse On RedHat?

0. We are considering migrating from HP-Ux to RedHat.
1. How is RedHat?
2. Will I have to re-compile and re-catalog everything?
3. Did anyone migrate from HP-Ux to RedHat and then back to HP-Ux?
4. Is the RedHat Standard Edition Suitable?
5. Did anyone try running UV on RedHat on an HP Integritity (Itanium)
server?
6. Are there any gotchas?
7. Insights and hind-sights would be appreciated.

--Bill
___
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] I'm baaaack

[jpb-u2ug]

There are discussion email groups like this one as well as forums. Go to the
www.u2ug.org web site and sign up for all of that you want to belong to.

Welcome home.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Glorfield, Gordon
Sent: Thursday, October 28, 2010 8:49 AM
To: U2 Users
Subject: [U2] I'm bck

Greetings Group,

I just started a new position with a company running a Unidata / SB+ shop
after my hiatus from the multivalue market.  It seems some things have
changed since I left (Rocket instead of IBM) but many things seem the same.
I look forward to the discussions on this group which I've missed.

Gordon

Gordon J Glorfield | Software Application Engineer | Vertis Communications
250 W. Pratt Street, Suite 1800 | Baltimore, MD, 21201
T 410-361-8664 | M 443-280-7093
gglorfi...@vertisinc.com | http://www.vertisinc.com

Vertis Communications is a results-driven marketing communications company
that delivers inventive advertising, direct marketing and interactive
solutions to prominent brands across North America. Our deep industry
knowledge and extensive range of offerings-including integrated data
solutions, digital program management systems, creative services,
world-class print and mail production, logistics, out-of-home and business
process outsourcing-are used to deliver superior program performance that
drives bottom line results for our clients. With 100 strategically
positioned locations and more than 5,000 dedicated professionals, we deliver
impeccable quality and fast turn-around to any market.

___
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] Building XML using the UV XDOM API functions

[jpb-u2ug]

I'll have to disagree with you on this one Tony. As a vendor yourself you
would of course think this way. As an end user of the product we would like
it all to come from one source. This is the reason that Microsoft has got
such a jump on everyone else, they will provide you with all of the tools as
well as the database. I'm talking about the harsh reality of things, at one
time if you went IBM you went all the way, now it's Microsoft. Companies
don't want to deal with several vendors they want one.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Monday, October 25, 2010 11:35 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Building XML using the UV XDOM API functions

Gregor, your comments serve as a testimonial to support my
position against using many of these vendor-supplied toolkits.
Some of them are OK, but many not.  People insist on the DBMS
vendors building stuff for them, but then we get the mess that
you've described.  For this reason I continue to recommend at
least consideration for integration with tools that are outside
of the  DBMS.  DBMS vendors should be focusing on making superior
databases, not XML, web services, or a lot of this other fluff.
People in the open source and commercial markets spend a great
deal of time focused on  these things, and because of this, their
offerings are often much better.  So take a look around and weigh
other offerings against the built-in functionality.  It would be
nice to see people here comparing more toolkits - it might save
others from feeling like they're stuck with whatever is provided
by the DBMS vendors.

T

___
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] "too many values in sort"

[jpb-u2ug]

I don't think UniVerse has the same limits (SELBUF controls in memory size)
but then UniVerse doesn't use the same structure as Unidata in their
selects.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Monday, October 25, 2010 11:52 AM
To: U2 Users List
Subject: Re: [U2] "too many values in sort"

  Of course, why would anyone need a BASIC program larger than 32K?  I 
believe it's called progress.  Non-configurable size limits are just 
__NOT__ acceptable in today's computing environment.  The attendant 
"work-arounds" are just plain ugly, and inexcusable.

The greatest aspect of PICK is the narrow gulf between the logical and 
the physical; database structure is logical, query syntax is logical, in 
fact, the entire machine is a logical machine.  Twenty year old physical 
limitation should have been resolved at least ten years ago.  :-(

Bill


Kevin King said the following on 10/25/2010 8:27 AM:
> Agreed on all points.  Will check this on my customer's system.
>
> On Mon, Oct 25, 2010 at 9:11 AM, Dave
Daviswrote:
>
>> That's some shopping list.
>>
>> I haven't seen anything anywhere that lets you adjust this limit.
>>
>> Besides breaking the record up into separate tables, you may need to make
a
>> temp file that normalizes this for you, by doing something like stringing
>> the value or row number into the key.
>>
>> I've never had anything approaching 10240 values in a multivalue.
>>
>> -Original Message-
>> From: u2-users-boun...@listserver.u2ug.org [mailto:
>> u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
>> Sent: Monday, October 25, 2010 10:54 AM
>> To: U2 Users List
>> Subject: [U2] "too many values in sort"
>>
>> Unidata 6.1.15 on AIX.  The following command:
>>
>> SSELECT SHOPPING.LIST BY.EXP PROD.NUM
>>
>> Yields the message "too many values in sort".  There is one record in
this
>> file with 36,457 product numbers but would that "break" the BY.EXP?  If
so,
>> is there a config parameter somewhere that could be tweaked to make this
>> work?
>>
>> -Kevin
>> http://www.PrecisOnline.com
___
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] Licensing

[jpb-u2ug]

We changed from standard licensing to device licensing because of the fact
that many of our users have multiple sessions open of the same IP. It has
helped tremendously. We use to run out of licenses on a regular basis with
only 75 users on a 117 license system. Now we have kept the same number of
licenses except they are device licenses and we hardly ever run out. The
only time that we have is when we had too many objects left as zombies and
it was a heavy day for the web. Just as an aside we use Accuterm which has a
configuration selection for device licensing.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
charles_shaf...@ntn-bower.com
Sent: Thursday, October 21, 2010 3:27 PM
To: U2 Users List
Cc: 'U2 Users List'; u2-users-boun...@listserver.u2ug.org
Subject: Re: [U2] Licensing

>> I like to use a small script in the .profile of *ix to limit the number 
of
>> simultaneous logins to say 3

>> Roy

The users feel they have a legitimate need for having quick access to all 
of the screens.  I'm not sure if they do, but I've never done their jobs 
so I hesitate to argue with them.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
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] Compiling 102

[jpb-u2ug]

The usage of the CATALOG command depends on the flavor you are using.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
Sent: Thursday, October 21, 2010 2:24 AM
To: U2 Users List
Subject: Re: [U2] Compiling 102

 Bill,

By default CATALOG will catalog programs globally.
To catalog a program locally you have to use the LOCAL option.
This will generate a VOC entry for the program name without the file name.
So CATALOG BP CODE LOCAL will generate a VOC entry named CODE.
To run the program you only need to type CODE at ECL and your program
will run.
Quite simple really.

Mecki


On 20/10/2010 17:06, Bill Brutzman wrote:
> I have been using Revision suffixes and VOC.  In other words...
>
>> LOGTO SANDBOX
>> ED VOC SAMPLE.PROGRAM
>> PA
>> RUN BP SAMPLE.PROGRAM.R1  --> R2   save
>> BASIC BP SAMPLE.PROGRAM.R2
> After the program is found to be workable...
>
>> LOGTO METAL
>> ED VOC SAMPLE.PROGRAM
>> PA
>> RUN BP SAMPLE.PROGRAM.R1  --> R2   save
> I have only been using CATALOG to register global SUBs.
>
> --Bill
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood
> Sent: Wednesday, October 20, 2010 11:44 AM
> To: U2 Users List
> Subject: Re: [U2] Compiling 102
>
> You might want to consider having two "BP" files - Production and Test
> (Sandbox?) - e.g. BP and TEST.BP
> You then use the CATALOG command to control which version is running.
>
> Mark
>
>  
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
> Sent: Wednesday, October 20, 2010 8:28 AM
> To: U2 Users List
> Subject: [U2] Compiling 102
>
> 1. It works.  Thanks to Kat, Tom, Vance, and Drew.
> 2. I am wondering if others keep their source code in an UV account as
such.
> 3. Prior to this thread, I had two accounts
>   /u2/METAL
>   /u2/SANDBOX
>
> 4. The source code was not in a UV account in
>   /u2/SOFTWARE
>
> 5. An advantage that I seem to have now is that I can compile code when
logged in to either METAL or SANDBOX and the compiled code works in both
METAL and SANDBOX.  In other words, I do not have to compile the same source
code for each account.  It is not clear to me how VOC and Q-Pointers are
setup to handle this scheme.
>
> 6. Comments would be welcome.
>
> --Bill
>
> ___
> 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
> ___
> 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

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

Re: [U2] [U2} Cloud UniVerse?

[jpb-u2ug]

I could be wrong but I think they allow it with replication. Then again I
think you also have to keep a minimum number of seats on those systems too.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Thursday, October 07, 2010 1:39 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [U2} Cloud UniVerse?

No one else has mentioned this but there might be a conflict
between your desire to get "disaster recovery seats" and your
desire to run reports from a backup system.  Failover systems
generally should not be used for anything, though some sites do
use them purely for generating reports from the current but
otherwise unused data.  I don't know how Rocket licensing works,
just suggesting that you not be surprised if someone brings this
up.

T 

> From:Bill Brutzman 
> I expect that one of the kickers in this is printing 
> forms. Right now I cannot see how to send print jobs 
> from the cloud host through our static IP router to 
> our printers.
> 
> Also, I sent a message to our sales rep at Rocket to 
> ask about how licensing would work.  That is, would we 
> need to buy more seats or is there special pricing for 
> disaster recovery seats.

___
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] CUPS printing and sequence of jobs

[jpb-u2ug]

When we used cups on our Linux server I had to go directly to the IP address
of the printer circumnavigating the Windows print server. Going through the
print server created too many problems, especially for print jobs that we
had imbedded pcl coding.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Tuesday, October 05, 2010 1:21 PM
To: U2 Users List
Subject: Re: [U2] CUPS printing and sequence of jobs

it's a Canon Imagerunner copier/printer with it's own "pc" acting as a
server.
I'm not really sure what OS it's running, I don't think it's windows.

I'm submitting lpd protocol to it, directly to it's IP

I switched our side so that cups sends to a Windows PC running RPM lpd
server, 
   and RPM then sends the raw data to a windows network printer (same
copier/server)
   except it's getting it's jobs through the networks windows printer
server, and
   the jobs print as expected.

So, it's definitely in the Canons PC's lpd server specifically.

This all sounds great..and solved, EXCEPT, we have found another little
issue
with cups, it seems when the lpd server is busy, cups triggers the printer
queue
to disable (ErrorPolicy stop-printer), which is extremely annoying to have
to
keep reenabling the queue when you send a flurry of jobs. So we changed it
so the
ErrorPolicy retry-job instead, now it doesn't take the queue offline,
instead now
it just doesn't send a job to the server, but still deletes it from it's
queue.

SoUntil I can get this lost job issue solved, looks like I have choices:

1. Look into changing from lpd protocol (port 515) to Ipp protocol (port
9100) (next attempt)
2. See if the server's admin can set something so the lpd server does FIFO
3. have fun sorting printed jobs back into their correct order!

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Bob Rasmussen
> Sent: Tuesday, October 05, 2010 1:50 PM
> To: U2 Users List
> Subject: Re: [U2] CUPS printing and sequence of jobs
> 
> Is this with a standalone hardware printer server, or a PC acting as a
> printer server? If the latter, with what software on the PC?
> 
> Our Print Wizard software for Windows can act as a printer server. We
> have
> *some* capabilities for job sequencing, and we could explore more
> options
> with you if this is critical.
> 
> On Tue, 5 Oct 2010, George Gallen wrote:
> 
> > the debug info shows they were sent to the printer in the numerical
> unix job# order.
> > I disabled the printer, sent the jobs again, and the unix job# order
> was the same
> >as the order sent, I renabled the printer and when the jobs
> printed they were
> >in random order, according to the cups log, they were sent in the
> correct order.
> >
> > So it looks like it's the receiving print server that is sending them
> in random
> >order to the printer, of course the admin for that server swears
> it does FIFO...
> >
> > Thanks for the debug tip...
> >
> > > -Original Message-
> > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > > boun...@listserver.u2ug.org] On Behalf Of Steve Romanow
> > > Sent: Saturday, October 02, 2010 12:51 PM
> > > To: U2 Users List
> > > Subject: Re: [U2] CUPS printing and sequence of jobs
> > >
> > > Maybe turn the logging up a notch and verify the order they are
> being
> > > submitted?  It might not be considered "submitted" until it
> finishes
> > > spooling, where a large job can be surpassed by smaller jobs.  We
> would
> > > not really want it to "block" on large print jobs.  Take for
> instance
> > > you start spooling an invoice run that may take 5-6 minutes to
> spool,
> > > you do you not want to process any other jobs while this thing is
> > > transferring to the queue?
> > > ___
> > > 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
> >
> >
> 
> Regards,
> Bob Rasmussen,   President,   Rasmussen Software, Inc.
> 
> personal e-mail: r...@anzio.com
>  company e-mail: r...@anzio.com
>   voice: (US) 503-624-0360 (9:00-6:00 Pacific Time)
> fax: (US) 503-624-0760
> web: http://www.anzio.com
>  street address: Rasmussen Software, Inc.
>  10240 SW Nimbus, Suite L9
>  Portland, OR  97223  USA
> ___
> 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] UV index with duplicate nodes

[jpb-u2ug]

Does the correlative have any special coding in it? I would suggest deleting
the index for this field recreate the field as a D type then add the field
to the index again. Some correlatives don't give you what you would expect.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis
Sent: Thursday, September 30, 2010 7:47 PM
To: U2-Users@listserver.u2ug.org
Subject: [U2] UV index with duplicate nodes

We've just uncovered a rather unusual and unsettling situation.  We have a
file with a single index that has somehow gotten nodes with duplicate keys.
A simple example would be having an index on ZIPCODE in a address database,
and finding that there are _two_ nodes (records) in the index for ZIPCODE
12345, for example.  The source records referred to in the nodes are not
duplicated, but since most operations find the 'first' node, any source
records referred to in the duplicate node appear to not exist in the index.

>LIST.INDEX fname ALL
Alternate Key Index Summary for file fname
File... fname
Indices 1 (1 A-type, 0 C-type, 0 D-type, 0 I-type, 0 SQL, 0 S-type)
Index Updates.. Enabled, No updates pending

Index name  Type  BuildNulls  In DICT  S/M  Just Unique Field
num/I-type
fieldnameANot Reqd  YesYes  ML N2


The file contains 6,539,233 records, with 574,547 unique values in fieldname
(which is actually a single-valued field, and has been verified that each
record's fieldname contains one and only one value).  We found that 9 source
records appear to have not been included in the index, but upon further
research found the nodes with duplicate keys.  We created an F-pointer to
the index file itself (not normally recommended, but useful), then got the
results like the following:

LIST indexfile WITH @ID = "12345]" F1 F2

fname. F1 F2
12345  987654 876543
12345-6789 765432 543219
12345  654321

We are having our UniVerse administrator ask our dealer for assistance, but
were interested if any other users have had any recent similar experiences,
or advice.

Sincerely Best Regards,

Richard Lewis
IBM Certified Solutions Expert

Nu Skin Enterprises
___
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] UVRESTORE error

[jpb-u2ug]

Look up the command in the documentation. You will notice that if you are
going to restore to a lower revision you will need to back up with one of
the -rev options.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Tuesday, September 28, 2010 1:22 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] UVRESTORE error


Hello,

We have a new version of UniVerse on our new server and every night we make
a backup image
using UVBACKUP. Today I tried to do a UVRESTORE from last night's backup
onto the old server
which is running a slightly older version of UniVerse and received the
following message:

WARNING: Unable to restore image of revision level 10.  This
process is only capable of restoring backup images
created with revisions between 2 and 9, inclusive.

I'm assuming this message is due to the different versions of UniVerse but I
was curious if there
was a quick workaround that people have found? 

Thanks,

Chris
  
___
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] Does Reality Flavor have globally cataloged subroutines?

[JPB-U2UG]

We are running in Reality flavor and have many globally cataloged programs. 
We have separate catalog commands for doing this just as others have 
mentioned. I have never seen a problem doing this.

Jerry

--
From: "George Gallen" 
Sent: Thursday, August 26, 2010 9:53 AM
To: "U2 Users List" 
Subject: Re: [U2] Does Reality Flavor have globally cataloged subroutines?


I'll have to play around this this then

Thanks


-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Martin Phillips
Sent: Thursday, August 26, 2010 9:49 AM
To: U2 Users List
Subject: Re: [U2] Does Reality Flavor have globally cataloged
subroutines?

Hi George,

> If I do that, then I lose the features of the Reality Account
> correct? Or Do I change it, catalog the routine, then change
> it back?

You could create an alternative named VOC entry that uses
INFORMATION.FORMAT
to save changing it back.

However, it may not really be an issue. The Reality mode version of
CATALOG
behaves the same as the Information style one with no extra options
(what
Ideal/Information and PI/open call "normal mode"). By selecting the
INFORMATION format you gain LOCAL and global modes.

> The problem is that those accounts were imported from a
> Reality system, and I wanted to use some of the subroutines
> that were written on another account imported from a Prime
> system.

The mode of CATALOG has no effect on what you can call. It only
determines
how the cataloguing is done.


Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England
+44 (0)1604-709200

___
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


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

Re: [U2] Unix to SQLServer

[JPB-U2UG]

Hear, hear, and as an end user I welcome knowing about new, and old, 
products that are available for my use.


Jerry

--
From: "Larry Hiscock" 
Sent: Friday, August 13, 2010 11:26 AM
To: "'U2 Users List'" 
Subject: Re: [U2] Unix to SQLServer


At the risk of being roasted for mentioning my "vendor product" (see

other threads - it seems to be unpopular) ...

I'm not speaking for the U2UG officially, but as a moderator on this list,
and as the list host.  IMHO, there is nothing wrong with mentioning or
endorsing a product, whether it's free or commercial.  If it provides a
solution to the problem in question, then it's germane to the discussion.

What I personally find distasteful is when someone gives a product a 
glowing
review without disclosing the fact that they stand to benefit from its 
sale.

That's why we've simply asked that when endorsing a product with which one
has a fiduciary relationship, that it be disclosed as such.

Ok, back to the topic...

Larry Hiscock
Moderator

___
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] RetrieVe enhancements

[JPB-U2UG]

Yes, all of the time. It's still a very good ad hoc reporting tool. Plus we 
have many reports that are generated using retrieve that we transform into 
PDF's.


--
From: "Symeon Breen" 
Sent: Friday, July 16, 2010 2:42 PM
To: "'U2 Users List'" 
Subject: Re: [U2] RetrieVe enhancements


This got me thinking - pardon the question, I have not used retrieve for
such things for many years , but do people still use retrieve for print or
screen reporting ?



Symeon.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: 16 July 2010 16:28
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] RetrieVe enhancements

With full agreement that C justification would be helpful if
built-in, this function is easily accomplished with a correlative
or even a call to a common subroutine.

T

___
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


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

[U2] UV Session hang using spool.

[jpb-u2ug]

We've just converted over to Windows 2008 Server running UV 10.3.3 from RH
Linux and I've come across an error that we never had on the Linux system. I
set up a printer with the SETPTR command:

 

SETPTR 0,174,58,0,0,1,NFMT,NOHEAD,BRIEF,NOEJECT,AT
AccountPrint_Landscape,GDI,FONTNAME Courier New,FONTSIZE 8

 

Then I try to spool a file:

 

SPOOL PA_FILE LOGIN

 

Then I get the following error and the session I am working in locks up.

 

Pstartjob: Failed to impersonate user. Error = 6

 

Any answers?

 

Jerry Banker

UV Project Leader

Senior Programmer Analyst

IBM Certified Solutions Expert

Administration and Development

 

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

Re: [U2] UV Memory issues

[JPB-U2UG]

Do you have or have you added any other applications running on the same 
server or is it dedicated to UV? I have seen where having another 
application running on the same server will conflict with UV.


--
From: "u2ug" 
Sent: Tuesday, June 08, 2010 10:31 AM
To: "U2 Users List" 
Subject: [U2]  UV Memory issues


We started running into a situation recently where a box running
universe 10.2.11 on hpux 11.31 started to have severe performance
problems, zero response, processes that normally take seconds to run
taking hours etc.

In Top we could see that the reported free memory was averaging about
28M at times dropping to less than 5M and that the vhand process was
chewing up a most of the cpu.  With the free memory that low, vhand
hogging the system makes sense.  Why the memory is that low is the
question.

The machine has 4G of memory, right after reboot before anyone but me
gets on the system top shows us at 3G free.  If we just let the system
sit, free memory will sit happily at 3G.  As soon as we start using
universe, the free memory starts to fall.   Logging out all universe
processes and even bringing universe down has no effect on free memory -
I would have expected the memory to be freed up once the universe
processes and in particular universe itself was terminated but that's
not what we are seeing.

We were in the process of setting up a new box physically the same as
the old box but running uv  10.3.6 on hpux 11.3.1. So I am looking at
this problem now on that box in isolation.  We were hoping that this
would turn out to be a hardware issue but we are seeing the same problem
on this new box as well.

This is out of my realm of experience and I am stumped as to where to go
next.  I have the system guy checking with hp , my guess is they are
going to point the finger at uv. I am going to check with our var - I'm
not overly optimistic there either.

Any suggestions ?
- Hpux/uv tunables we should be looking at
- can we tell universe to restrict the amount of physical memory
that it uses ?
- Or maybe this is a garbage collection issue ?
- universe or hpux being overly aggressive about caching
- any hpux utilities that we can use to see exactly where the memory is
being used ?
-  ?


Gerry




-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl
Sent: June 8, 2010 09:41 AM
To: 'U2 Users List'
Subject: [U2] [Unidata-Windows] Can login, but not execute any command

Upfront: The problem was solved by re-installing UniData

My client had UniData 7.2.3 on Windows within his domain. He rebooted
all
servers within his company over the weekend. Yesterday UniData suddenly
didn't work anymore. I could log in to the database, but any command,
whether Write, Select or catalogued subroutine would stop dead in its
track.
There was no error message, no indication what could have gone wrong.
UniObjects had no time-out, the application hung for hours.

I telneted into the database and many users got the unknown user error,
I
just found one user that allowed me to log in. I ran a few commands and
that
worked.

My hunch is that a Windows update changed NT-Authentication and UniData
didn't like it. Poking through the logs, I see in the Windows security
log
two entries for every UniData login, one success and one failure:
The first a success audit:
A trusted logon process has registered with the Local Security
Authority.
This logon process will be trusted to submit logon requests.
Logon Process Name: \udapi_server.exe

Then a failure audit:
The logon to account: HHC-Unidata
by: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0
from workstation: HORIZONSERV4
failed. The error code was: 3221225572

The error code means: 32212255720The specified user does not exist.

This behavior started already last year, and even now that everything
works
again.

Does anyone have ideas or similar experiences?


Martin Scholl
18910 New Hampshire Ave
Brinklow, MD 20862
Phone: 301-924-5537
Cell: 301-613-9572
martin.sch...@hipaasuite.com
www.HIPAAsuite.com


___
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


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

Re: [U2] OPENSEQ and Abnormal termination of UV

[jpb-u2ug]

Let me see, can it be because you are trying to cram over 4 GB of data into
a single cell. Unlike the OPEN statement that just puts the file variable
into a variable, the OPENSEQ opens the whole file to the variable.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rajesh Menon
Sent: Monday, May 17, 2010 1:56 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] OPENSEQ and Abnormal termination of UV

Does anyone knows what is happening here:
I am trying to open a text file (over 4Gb) using OPENSEQ and storing the
file variable into a array as follows:
COMMON /MYPROG/ FILEVARS(10)
OPENSEQ "/tmp/file.txt" to FILEVARS(1) ELSE ...
This operation results abnormal termination with fault type error 11. Fault
occurred at address 1c (which is the OPENSEQ command.). If the file size is
less than 2147483647 bytes (2Gb), it works.

Opening the same file using a scalar file variable always work irrespective
of the file size.
OPENSEQ "/tmp/file.txt" TO FV.FILE ELSE ...

Any reason why the first method failing for +2Gb files? Any workarounds?

Universe: 10.2.7
AIX:  5.3

Thanks
Rajesh Menon

___
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

[U2] UV on Windows

[jpb-u2ug]

Anybody know what permissions a person needs to use all of the UniAdmin
options on a Windows server running UniVerse. Right now I can bring up the
UniAdmin when I rdp to the system but I can't see any of the users except
myself. I can't kill a user because they don't show up on the users window.
Same thing with the locks. I try to clean the licenses but that doesn't seem
to do anything. I need to know what I need so I can tell the network
administrator what he has to do.

 

Jerry Banker

UV Project Leader

Senior Programmer Analyst

IBM Certified Solutions Expert

Administration and Development

 

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

Re: [U2] Looking for a Job.....

[jpb-u2ug]

You do realize that you have more of a chance of finding a job in India than
you do here, right. Most of the jobs here have been outsourced to your
country or China.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jaweed
Sent: Monday, April 12, 2010 10:58 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Looking for a Job.

Hi everyone,

 

I have around 9yrs of experience on Unidata, Pick Basic, Unibasic, Redback
and other technologies like ASP.Net, C# and XML.

I am currently leading a offshore team in India and now looking for a
change. I am looking a job near Dallas, Texas.

 

 

Thanks

Jaweed

___
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] import data to excel sheet...

[jpb-u2ug]

This is a function of the operating system. On Unix systems only a linefeed
character is added to the end of a line whereas on Windows both carriage
return and linefeed characters are added to the end of a line. If you open a
file created on a Unix system with the notepad app it will have one line
with strange characters in it. A quick fix, if you open the same file with
word pad it will be converted and you can save it. If you created a file on
a Unix system for use on a Windows system you have to add a carriage return
character to the end of the line.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben
Sent: Monday, April 12, 2010 11:01 AM
To: U2 Users List
Subject: Re: [U2] import data to excel sheet...

Hi Jaweed,

I haven't looked too closely at your code, but I did notice on thing that I
would consider the most likely candidate:

CHAR(13) is a carriage return, not a line feed.  Try using CHAR(10) instead
for your LINE.FEED variable. You might have to use CHAR(13):CHAR(10), but I
think CHAR(10) should do it.

Good luck!

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jaweed
Sent: Monday, April 12, 2010 7:53 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] import data to excel sheet...

Can anyone tell me what is wrong with the following code for importing data
from txt file to an excel sheet, when its launch

Excel it giving some error message, but when I open the downloaded file from
my disc, all the data is in one line with some especial

Chars. Any help will be appreciated.



034: **

035: * OPEN FILES *

036: **

037:   ERRMSG = ''

038:   OPEN TEXT.FILE.NAME TO TEXT.FILE ELSE

039: ERRMSG = 'CANNOT OPEN THE ' : TEXT.FILE.NAME : ' FILE!'

040:   END

041:   IF ERRMSG THEN

042: GOSUB 91000

043: RETURN

044:   END

*--: P

045: **

046: * INITIALIZE *

047: **

048:   PAGE.FEED = CHAR(12)

049:   LINE.FEED = CHAR(13)

050:   ;*

051:   ;* Read the text file to convert

052:   ;*

053:   READ TEXT.REC FROM TEXT.FILE, TEXT.REC.NAME ELSE

054: ERRMSG = "ITEM " : TEXT.REC.NAME : " DOES NOT EXIST IN " :
TEXT.FILE.NA

ME

055: GOSUB 91000

056: RETURN

057:   END

058:   ;*

059:   ;* Set default values (none are used now)

060:   ;*

061:   VALUE = "DEFAULT"

062:   LOCATE "PROPERTY" IN FORMATSTR<1> SETTING PTR THEN

063: VALUE = FORMATSTR<2,PTR>

064:   END

065:   ;*

066:   ;* Remove the first line if it contains a PAGE.FEED

*--: P

067:   ;*

068:   LOOP WHILE TEXT.REC<1> = PAGE.FEED DO

069:  TEXT.REC = DELETE(TEXT.REC,1)

070:   REPEAT

071:   IF TEXT.REC<1>[1,1] = PAGE.FEED THEN

072:  TEXT.REC<1> = TEXT.REC<1>[2,LEN(TEXT.REC)]

073:   END

074:   ;*

075:   ;* Find the header for each page

076:   ;*

077:   SLK.REC = ''

078:   SLK.ROWS = 0

079:   SLK.HEADER.LINES = 0

080:   IF TEXT.REC<1>[1,10] = "RUN D - T:" THEN

081: SLK.REC<-1> = "F;SD;R3"

082: SLK.REC<-1> = "F;SD;R4"

083: SLK.REC<-1> = "C;Y1;X1;K" :
QUOTE(TRIM(CHANGE(TEXT.REC<1>[1,30],';',';;

')))

084: SLK.REC<-1> = "C;Y2;X1;K" :
QUOTE(TRIM(CHANGE(TEXT.REC<2>[1,30],';',';;

')))

085: SLK.REC<-1> = "C;Y3;X1;K" :
QUOTE(TRIM(CHANGE(TEXT.REC<1>[31,90],';',';

;')))

086: SLK.REC<-1> = "C;Y4;X1;K" :
QUOTE(TRIM(CHANGE(TEXT.REC<2>[31,90],';',';

;')))

087: SLK.ROWS = 4

088: SLK.HEADER.LINES = 2

*--: P

089:   END

090:   ;*

091:   ;* Find the number of lines in the header

092:   ;*

093:   LINES = DCOUNT(TEXT.REC,@AM)

094:   SLK.HEADER.CNT = 0

095:   FOR IDX = SLK.HEADER.LINES+1 TO LINES

096: IF INDEX(TEXT.REC,"---",1) THEN

097:   SLK.HEADER.CNT = IDX

098:   EXIT

099: END

100:   NEXT IDX

101:   ;*

102:   ;* Find the column locations

103:   ;*

104:   COL.LIST  = ''

105:   IF SLK.HEADER.CNT THEN

106: DASHES.LINE = " " : TEXT.REC : " "

107: DASHES.LINE = TRIM(DASHES.LINE,'-')

108: DASHES.CNT  = COUNT(DASHES.LINE,'-')

109: DASHES.LINE = TEXT.REC

110: FOR DASHES.IDX = 1 TO DASHES.CNT

*--: P

111:   COL.START = INDEX(DASHES.LINE,'-',1)

112:   DASHES.REMAIN = LEN(DASHES.LINE) - COL.START + 1

113:   COL.LEN   = INDEX(DASHES.LINE[DASHES.REMAIN],' ',1)-1

114:   IF COL.LEN < 1 THEN COL.LEN = LEN(DASHES.LINE)

115:   COL.LIST = COL.START

116:   COL.LIST = COL.LEN

117:   DASHES.LINE[COL.START,COL.LEN] = SPACE(COL.LEN)

118: NEXT DASHES.IDX

119:   END

120:   ;*

121:   ;* Extract the column titles

122:   ;*

123:   COL.CNT = DCOUNT(COL.LIST,@AM)

124:   FOR HDR.IDX = SLK.HEADER.LINES+1 TO SLK.HEADER.CNT-1

125: SLK.ROWS = SLK.ROWS + 1

126: SLK.Y = "Y" : SLK.ROWS : ";"

127: ;*

128: ;* Make sure the header properly fits into the column

129: ;* If it does not, then add it to the spreadsheet's first column

130: ;*

131: CHEC

Re: [U2] Regex searching UD files

[jpb-u2ug]

I'm on UV and  from the Unix command line I can do the following:

cd /usr/ibm/uv
uv port.status | grep j_banker

It will list every line with my login.


Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath
Sent: Monday, March 29, 2010 4:13 PM
To: U2 Users List
Subject: Re: [U2] Regex searching UD files

Not even close... We run in ECLTYPE P and don't have access to EVAL and
the like.

"^[Cc][Hh][Qq].*[5-8][0-9][0-9][0-9]x"

Unless you can explain how to duplicate the above search with ESEARCH?

@Stuart, that would be ideal, but unfortunately I can't go dumping out
multi-gigabyte files. :(



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune
Sent: Tuesday, 30 March 2010 5:22 AM
To: U2 Users List
Subject: Re: [U2] Regex searching UD files

Does UniData ECL ESEARCH command not fill the bill already?

Wally Terhune
U2 Support Architect
Rocket Software
4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA
Tel: +1.720.475.8055
Email: wterh...@rs.com
Web: www.rocketsoftware.com/u2

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell,
Stuart
Sent: Monday, March 29, 2010 12:22 AM
To: U2 Users List
Subject: Re: [U2] Regex searching UD files

I think this should be one for Rocket to implement a RegexSearch in U2. 
However, if it's size non-impactive, what I would normally do is copy
the file to a temporary directory then run grep across that.

Stuart Boydell 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath
Sent: Monday, 29 March 2010 17:08
To: U2 Users List
Subject: [U2] Regex searching UD files

I've written a small utility to be able to run egrep on a UD file (not
UD directory), however its implementation is not ideal.

 

Essentially, I select the file I'm searching, writing each record one at
a time to a temp UNIX file and running egrep on it as follows

 

!egrep -q -f MyTempRegexFile MyTempRecordFile ; echo $?

 

Where MyTempRegexFile is a file containing the desired regex pattern
stored earlier and MyTempRecordFile is a file name unique to each user.

 

My problem with it is that I have to do a READ on each record, followed
by a WRITE then have egrep read it in as well. That's a lot of seemingly
unneeded disk IO if I could only stream the record to egrep without have
to do a WRITE after the READ.

 

Any ideas? I feel I'm missing something quite obvious.

 

Regards,

Dan



###
The information transmitted in this message and attachments (if any) is
intended only
for the person or entity to which it is addressed. The message may
contain confidential
and/or privileged material.  Any review, retransmission, dissemination
or other use of
or taking of any action in reliance upon this information by persons or
entities other
than the intended recipient is prohibited.  If you received this in
error, please
contact the sender and delete the material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose
or distribute
the information contained in this e-mail and any attached files with the
permission of IMB.

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

__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
__

###
The information transmitted in this message and attachments (if any) is
intended only
for the person or entity to which it is addressed. The message may contain
confidential
and/or privileged material.  Any review, retransmission, dissemination or
other use of
or taking of any action in reliance upon this information by persons or
entities other
than the intended recipient is prohibited.  If you received this in error,
please
contact the sender and delete the material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or
distribute
the information containe

Re: [U2] Pick on Mac

[jpb-u2ug]

I think I saw someone on this list that was using one of the U2 products on
Mac OSX or on the Windows virtual emulator. Could be wrong.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com
Sent: Monday, March 29, 2010 2:38 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Pick on Mac

Are there are native implementations of a Pick system on Macs?  Or are all 
Mac connections just terminal emulators into a Windows/Unix system?

I know there is or used to be an emulator by Carnation that rode on a Mac.  
But have all such implementations been to have it talk with a Pick system 
living on a Windows or Unix box?

Does Universe have any sites where users are connecting using Macs as their 
PC?

Will Johnson
___
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

[U2] Microsoft SQL Server Driver Support

[jpb-u2ug]

The U2 team at Rocket Software announces a renewed focus on improving SQL
interfaces to the UniData and UniVerse data servers.


Microsoft SQL Server Driver Support


Starting with the November release of UniData on Windows, the Rocket U2 team
will deliver and support the Microsoft SQL Server driver for External
Database Access (EDA) on Windows platforms. The same driver is available now
in the Early Adopter release of UniVerse 11.

To obtain the SQL Server driver for EDA, contact u2as...@rs.com. Please tell
us what database you're using when you do so. External Database Access (EDA)
is required in order to use the SQL Server Driver. EDA is available for
Workgroup and Server edition and is included with Enterprise edition of the
databases.


Common Mapping Tool and Schema Generator


In addition, we are in the early planning stages for an improved, common
mapping tool and schema generator for fully describing the U2 data model in
order to generate SQL and EDA schemas. This new tool will provide a modern,
extensible interface for both initial mapping as well as updating of
schemas. This tool, with its associated APIs, will improve deployment of ISV
solutions to end customer sites thereby saving time and speeding time to
market.

This tool will be available with UniVerse 11.1 and in a UniData 7.3 release
to follow.

 

Jerry Banker

UV Project Leader

Senior Programmer Analyst

IBM Certified Solutions Expert

Administration and Development

 

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

[U2] Spooler for Windows

[jpb-u2ug]

What products are out there that mimic the Unix UniVerse spooler in a
Windows environment? From what I can see on Windows, UniVerse uses the
Windows printer subsystem and in my estimation that was a mistake. There's
no retention of print jobs, no form type, no ability to use scripts, it is
the biggest stumbling block for conversion from a 'nix environment. I would
only like to look at packages that are built to work with UniVerse and are
like the Unix spooler with all the bells and whistles. We have moved from
Unix V5, to Solaris, to RH Linux, and our spooler scripts only needed minor
changes long the way. Now we are trying to go to Windows and the only
stumbling block the we have encountered is the spooler. We did so much with
it.

 

Jerry Banker

UV Project Leader

Senior Programmer Analyst

IBM Certified Solutions Expert

Administration and Development

 

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

Re: [U2] extraction conversion codes

[jpb-u2ug]

I wonder the same thing. All he's doing is converting a D type to a
correlative and in that case I would much rather have it an A or S type so
you don't have to be misled by the type and not looking for the special
coding in field 3.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips
Sent: Friday, February 05, 2010 1:33 PM
To: U2 Users List
Subject: Re: [U2] extraction conversion codes

Hi Gerry,

Out of curiosity, why are you against I-types?


Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
+44-(0)1604-709200
___
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] Resize Question

[jpb-u2ug]

If you are starting out with trying to use SQL on a legacy database your
best bet would be to create a separate account just for SQL. In the new
account put in pointers to the main data files you will be using and create
dictionaries to the files locally. In this way you can build the
dictionaries to be SQL compliant and only have the fields that you will be
using for your SQL apps. It's a little more work to set up but will save
loads of time later. If you have files with the same data (current and
history files) you can use the same dictionaries so that can cut down on the
number of dictionaries used.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Wednesday, February 03, 2010 2:57 AM
To: 'U2 Users List'
Subject: Re: [U2] Resize Question

Hi Andrew

Because UniVerse dictionaries contain not only solid column definitions, but
also synonyms and virtual fields, you have to choose which of these will be
exposed for ODBC or similar relational protocols. A typical dictionary for a
mature system might have a thousand entries which makes navigating these in
something like MS query or the .NET data set designer very difficult!

So for this you need to do two things:

First, create a phrase named @SELECT. This is a dictionary entry in the
format:

Key: @SELECT
1: PH
2: list of fields SPACE delimited.

You can test this out by doing a SELECT * from file at TCL, which uses the
same phrase.

Then, you need to update the file information cache used by ODBC (prevents
it having to scan every dictionary on connect). For this, run the
HS.UPDATE.FILEINFO command after making your changes.

However, you might also want to step back and consider whether ODBC is
really your best choice. To use ODBC effectively you need to understand
about dynamic normalizing and the differences between the UniVerse data
model and the relational model expected by ODBC. Depending on what you wish
to do, ODBC may tie you up in knots and you may be better off looking at one
of the native protocols (the UniObjects family) or web services instead.

Also, I don't know why you chose to copy your VOC across. That will contain
pointers to all the files from the original system, which you don't have on
yours,  hence the large number of errors you are seeing. If you are brave,
you can try a CLEAN.ACCOUNT command, but take a backup first!

[AD]
You might want to consider my latest book, 'IBM UniVerse Client Developer'
(written when this was still an IBM product) which covers the various
protocols in depth. You can find details on my website,
www.brianleach.co.uk.
[/AD]

Regards

Brian 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Andrew E.
Tegenkamp
Sent: 02 February 2010 4:17 PM
To: 'U2 Users List'
Subject: Re: [U2] Resize Question

Thank you very much! That has helped a lot and I can now see the data in the
UV command line :)

If possible, I am now hoping to be able to expose this imported data to ODBC
so I can work with it in PHP, etc. But I am again finding problems I cannot
find an answer for in the help docs or searching the list archive.

First, I created a PICK account using the U2UG guide mentioned. I then used
HS.ADMIN option 3 to "Activate access to files in an account" which went
well and showed it as an activated account.  

I copied over the TEMP and VOC (D_VOC, D_VOCLIB, VOC, VOCLIB, etc) files
from the live UniVerse server to my account as well as my test table ZIP
(ZIP and D_ZIP). I fnuxi'd and SET.INDEX'd them and could see the data on
the command line using SELECT COUNT(*) FROM ZIP and the like.

However, when I went to ODBC I could only see 3 tables. AE_DOC, HELP_FILE,
and HS_FILE_ACCESS (ODBC reported no rows in HS_FILE_ACCESS). I ran HS.ADMIN
option 3 again on the account and for most things it said:

Could not open file FILENAME.  STATUS() = -2
  "FILENAME" was not written into File Information Cache.

For the file I copied over, ZIP, it said: 

ZIP's dictionary has no @ phrase or @SELECT phrase.
  "ZIP" was written into File Information Cache but
  may not behave as desired.

This is a little confusing as I thought D_ZIP was the dictionary file and
SELECT works on the command line. After this, I checked ODBC and saw the 3
above and one more table called UVMD. I am not sure what this was so I got
it but it appears to be a system table of some sort.


Thanks again for any tips on how to properly setup/expose this file/table to
ODBC!
Andrew





-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Monday, February 01, 2010 11:55 AM
To: 'U2 Users List'
Subject: Re: [U2] Resize Question

Okay, a few things here...

First the index issue. When UniVerse creates an index on a file, it puts the
absolute pathname t

[U2] Sharing files

[jpb-u2ug]

I am very familiar with how to do things on Unix/Linux systems but my
knowledge of the MS Windows Server environment is substantially lacking. So
I am wondering if the group can give me some pointers. I have a folder on a
RH Linux system that I would like to share on a Windows 2K8 server running
UV 10.2. The share has been set up using Samba on the RH Linux as3 server
and from a desktop or an RDP session to the Windows server I can map the
share and us it. But, I would like to use the share from within our main UV
account for multiple telnet sessions. On 'nix all I had to do was mount the
folder from another system, put a pointer to it in the VOC, and I was up and
running. From UV Windows I am at a loss to know where the mount is. I have
tried to use a UNC path in the VOC pointer but it doesn't seem to work or
possibly I didn't create it properly (\\IPaddress\smbshare\file
 ). They are on two different subnets.
Can anyone enlighten me on how they are doing it?

 

Jerry Banker

UV Project Leader

Senior Programmer Analyst

IBM Certified Solutions Expert

 

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

Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS

[jpb-u2ug]

Is 5.2 still supported? That may convince them that it is time to upgrade. I
can't seem to find an availability matrix on Rocket's site.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gerd Forthmann
Sent: Wednesday, January 13, 2010 10:25 AM
To: U2 Users List
Subject: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS

Thanks Bill,

I don't think it is an ODBC problem since SSIS connection managers unlike
DTS don't use ODBC. They use OLEDB and connect even without the IBM U2 ODBC
driver installed. 
I maybe have to add that both SQL Server 2000 and 2008 run under Windows
2003, so I don't think this is an OS issue either.

If anybody has any suggestions how to use UniObjects with SSIS I would give
that a try immediately.

Easiest would of course be to upgrade to UD 7.2 but unfortunately I haven't
been able to convince management to approve that.

Mecki
 Original-Nachricht 
> Datum: Wed, 13 Jan 2010 10:36:27 -0500
> Von: "Brutzman, Bill" 
> An: "U2 Users List" 
> Betreff: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS

> 
> This problem resembles my recent problem with ODBC between HP-Ux and
> MS-SQL.  Tech Support at Rocket indicated that I would probably have to
> buy special (ODBC) drivers from companies that specialize in data
> integration because... ODBC is a Microsoft thing and this sort of
> connectivity is not bundled with most (maybe any) flavors of Unix.
> 
> Rocket agreed that using UniObjects would be an easier alternative.
> 
> --Bill
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki
> Foerthmann
> Sent: Wednesday, January 13, 2010 7:39 AM
> To: U2 Users List
> Subject: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS
> 
> Hi
> 
> I am trying to use SSIS to load UniData tables to SQL Server 2008.
> I already have been using DTS with SQL Server 2000 successfully for a
> while and I set up everything (System DSN and UCI Editor) the same on
> the 2008 server.
> The connection test works fine, but when I try to go further I get this
> error message.
> 
> > Cannot get string literals from the database connection 
> > "Provider=Informix.UniOLEDB.1;Password=;Persist Security 
> > Info=True;User ID=admin;Data 
> > Source=LIVE_DATA;Location=LIVE_DATA;Mode=Read"
> We are running Unidata 5.2 on Solaris. And I am using UniDK for that
> release on both SQL Server boxes.
> I had tried using a later version of UniDK before, but that didn't seem
> to want to connect to the older version of UD at all.
> 
> Any ideas?
> 
> Thanks
> 
> Mecki
> ___
> 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

-- 
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01
___
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] An interesting find....

[JPB-U2UG]

Instead of CASE -1 use CASE 1

--
From: "George Gallen" 
Sent: Tuesday, December 15, 2009 1:23 PM
To: "U2 Users List" 
Subject: [U2] An interesting find


Here is an interesting tidbit I happened to run across.

PROGRAM A:

OPEN "","FILE1" TO F.FILE1 ELSE STOP "NO FILE1"
OPEN "","FILE2" TO F.FILE2 ELSE STOP "NO FILE2"
* F.FILETOUSE = F.FILE1  (Adding this here will get rid of the compile 
warning)

BEGIN CASE
   CASE X=1  F.FILETOUSE = F.FILE1
   CASE X=2 F.FILETOUSE = F.FILE2
   CASE -1 F.FILETOUSE = F.FILE1
END CASE
READ XDATA FROM F.FILETOUSE,"TEST" ELSE XDATA=""

The above program when compiled says F.FILETOUSE never assigned a value
and when it executes, gives an improper file type error

HOWEVER:

PROGRAM B:

OPEN "","FILE1" TO F.FILE1 ELSE STOP "NO FILE1"
OPEN "","FILE2" TO F.FILE2 ELSE STOP "NO FILE2"
   F.FILETOUSE=F.FILE1
   IF X=1  THEN F.FILETOUSE = F.FILE1
   IF X=2 THEN F.FILETOUSE = F.FILE2
READ XDATA FROM F.FILETOUSE,"TEST" ELSE XDATA=""

Compiles and run just fine, no errors.

This is using UV 10.0.2 under the Prime Information flavor

George Gallen
Senior Programmer/Analyst
Accounting/Data Division, EDI Administrator
ggal...@wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com



___
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] SELECTs on FILEs

[JPB-U2UG]

While you are on the subject I have discovered another little annoyance from 
Windows as opposed to Unix. On Unix, Linux, Solaris, et al you can do a 
select on an account and get the same results every time, however, on 
windows you may not. At least with Universe. For a simple test do a select 
on your current account:

SELECT &UFD&
Then do it a second time:
SELECT &UFD&
On 'nix systems you will get no difference, but, on windows you will get a 
list of entries that it says do not exist and the selection count is lower. 
What I have found is that on the first pass it will select all entries but 
on the second pass none of the folder type files can be found. An account is 
usually made up of a variety of file types; including segmented hash and 
types 1, 19, 25, and 30. What an annoyance when you're trying to create 
lists for backing up or moving to a test location.


--
From: "Dan McGrath" 
Sent: Sunday, December 13, 2009 6:15 PM
To: "U2 Users List" 
Subject: [U2] SELECTs on FILEs


Hi all,



Just a quick question on SELECTs for UD.



I was under the impression that performing a wildcard SELECT with @ID
would only result the key section of a FILE been read.



Eg, SELECT MYFILE WITH @ID = "prefix]"



Is this incorrect? Does it actually result in the entire FILE being read
into memory to complete this SELECT?



Regards,

Dan


###
The information transmitted in this message and attachments (if any) is 
intended only
for the person or entity to which it is addressed. The message may contain 
confidential
and/or privileged material.  Any review, retransmission, dissemination or 
other use of
or taking of any action in reliance upon this information by persons or 
entities other
than the intended recipient is prohibited.  If you received this in error, 
please

contact the sender and delete the material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or 
distribute
the information contained in this e-mail and any attached files with the 
permission of IMB.

###
___
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

[U2] Uniobjects and login paragraph

[jpb-u2ug]

Did I see that someone said Uniobjects bypasses the login paragraph? What
else bypasses the login paragraph? Is this on both 'nix and Windows? 

 

Jerry Banker

UV Project Leader

Senior Programmer Analyst

IBM Certified Solutions Expert

 

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

Re: [U2] UV Transaction logging

[jpb-u2ug]

Thanks Brian.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Monday, November 30, 2009 10:25 AM
To: 'U2 Users List'
Subject: Re: [U2] UV Transaction logging

Jerry

All changes should be logged to any files that are marked for transaction
logging. You have to explicitly enable logging for individual files, with
the caveat that you can't log type 19 files.

If you don't use explicit transaction control in your code, each write will
be treated as a separate transaction and logged individually.

Brian 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug
Sent: 30 November 2009 4:14 PM
To: 'U2 Users List'
Subject: [U2] UV Transaction logging

If you have transaction logging turned on in UniVerse do all changes get
logged even those that don't have the code in the programs to start the
transaction and commit it?

 

Jerry Banker

UV Project Leader

Senior Programmer Analyst

IBM Certified Solutions Expert

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.709 / Virus Database: 270.14.87/2535 - Release Date: 11/29/09
19:31:00

___
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] Mapping files.

[jpb-u2ug]

You also have to have Allownfs set to 1 in your configuration and
permissions set on the other server so you can use the file.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Paul Parkinson
Sent: Monday, November 30, 2009 9:58 AM
To: 'U2 Users List'
Subject: Re: [U2] Mapping files.

Thanks Mas, tried that didn't work

Kind Regards
Paul Parkinson
Director, Ideal Business Services Ltd
mob: +1 758 721 4487 (Caribbean)
skype: 0161 408 2098
eml: pparkin...@idealnet.co.uk 
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mats Carlid
Sent: 30 November 2009 11:46
To: U2 Users List
Subject: Re: [U2] Mapping files.


Mount  \\serverB\unidata  as disk Z say
and make the voc entry:

F
Z:filenamn
Z:D_filename


BUT  there is a real  gotcha:
Don't even think about updating that file from server A
as there's no common lock mechanism.

-- mats



Paul Parkinson skrev:
> I have 2 servers both running Unidata 7.1 on Windows 2003.  In an
> application on server "A" I want to access data held in an application on
> server "B"
>
>  
>
> I have tried the voc entry in the application on serverA
>
>  
>
> 001: F
>
> 002: \\serverB\unidata\filename  
>
> 003: \\serverB\unidata\D_filename  
>
>  
>
> I have also tried replacing "serverB" in the above with the IP address
>
>  
>
> But I get the error "open file error no such file."
>
>  
>
> Anyone know what I should be doing?
>
>  
>
> Paul Parkinson
>
>  
>
>  
>
>  
>
> ___
> 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


___
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

[U2] UV Transaction logging

[jpb-u2ug]

If you have transaction logging turned on in UniVerse do all changes get
logged even those that don't have the code in the programs to start the
transaction and commit it?

 

Jerry Banker

UV Project Leader

Senior Programmer Analyst

IBM Certified Solutions Expert

 

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

Re: [U2] Code Coverage Project

[jpb-u2ug]

It won't be used by programmers but would by QC/QA types to check and see if
the code is being used or is just a bunch of fluff. One good example would
be if your company is using outsourcing to do your programming and the
outsource is getting paid on the amount of code they produce, instead of the
correct way of getting paid on the quality of their code. You can check to
see if all paths through the code are being used or not.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug
Sent: Friday, November 27, 2009 10:47 AM
To: 'U2 Users List'
Subject: Re: [U2] Code Coverage Project

Dan,

Although I missed code coverage in programming school, I'm not sure how much
UniBasic
programmers would or could use code coverage. That being said, why not take
an existing
program that is fully developed and change the syntax to handle basic
syntax.  This way
you do not have to develop the entire infastracture to run this tool.

My suggestion is there are several open source plug-in for Eclipse that can
be modified
to handle code coverage.  There are several examples like jcoverage or gcov
that could
be used for this type of project.

Regards,
Doug
www.u2logic.com
"Native U2 drivers for PHP"



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath
Sent: Thursday, November 26, 2009 2:35 PM
To: U2 Users List
Subject: [U2] Code Coverage Project

Hi all,

 

For those that are interested, I have setup a project on SourceForge for a
Statement Level Code Coverage Tool for UniBasic. It is based on the
prototype for a similar tool we now use at my current employer.

 

Although this version is incomplete, it still enables statement level
coverage for multiple programs/subroutine with html output. The "parser"
(I really shouldn't use that term) is still quite primitive in this version
and may not work with how some programs are coded.

 

http://sourceforge.net/projects/ucov/

 

For a screen shot of the output and a short post about it, visit:
http://u2tech.wordpress.com/

 

Regards,

Dan

___
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] [UV] Where is the COMMON block reserved ?

[jpb-u2ug]

In the first example the common is declared in program 1 and can be used in
both program 1 and the called subroutine program 2.
In the second example the common is declared only when the second program is
called and can only be used by the second program, and any programs called
from it. In this case program 1 doesn't know of the common at all.
It doesn't matter if you are using connection pooling.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jacques G.
Sent: Thursday, November 19, 2009 2:02 PM
To: U2 Users List
Subject: Re: [U2] [UV] Where is the COMMON block reserved ?

Hello,

I have a question pertaining to how the shell used by the connection pooling
works as it relates to memory allocation.

In the following cases:

Case 1:  Program 1 has a number of variables and matrixes declared in a
common section  it calls  Program 2 which has the same common matrixes and
variables declared.

Ex: Program 1:

COM ABC(100), D,E,F
ARG = "BLAH"
CALL PGM2(ARG)

Program 2:
SUBROUTINE PGM2(ARG)
COM ABC(100), D, E,F
CRT ARG
RETURN

 

Case 2: Program1 doesn't have any common variables declared it calls
Program2 which does have common matrixes and variables declared:

Program 1:  

ARG = "BLAH"
CALL PGM2(ARG)

Program 2:
SUBROUTINE PGM2(ARG)
COM ABC(100), D, E,F
CRT ARG
RETURN


In Case 2, is the common block declared in the stack segment or will the
common be declared in the same place in both cases ?   


  
___
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] Unidata odd error

[jpb-u2ug]

I can't speak for Unidata but with UniVerse there was no problem going from
Solaris to Red Hat. We went to it 4 years ago and I did it on a Saturday. I
set up the printers and themaster account ahead of time. 99% of the commands
are identical, I think the only problems I had were with the cp and rm
commands having an extra switch. If you don't use any of the operating
system commands you won't have any problems. Unlike going to Windows the
spooler is the same and cups is easy to use. If you are moving from a RISC
system to INTEL you have to run fnuxi on the accounts if you don't use
backup and restore utilities.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Rubeor
Sent: Monday, November 16, 2009 8:10 AM
To: Jeff Butera; U2 Users List
Subject: Re: [U2] Unidata odd error

We will be doing the same move next year.  Please let us know how the
process went, any "gotcha's", etc.
 
I've already tested once and did not have any problems with compiling and
running the application.  Didn't test printing, so I'm a little worried
about that.
 

>>> Jeff Butera  11/14/2009 6:47 PM >>>
> I have a question for you.  Why are you moving to RedHat from Solaris?  Do

> you think that Redhat is a better o/s?

We run everything else on linux here, the Solaris boxes for unidata are 
the oddballs.  Also, when you compare hardware costs (even with .EDU 
pricing from Sun) it's a no brainer to move.

Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
jbut...@hampshire.edu
413-559-5556

"I'm just having a conversation with myself
- it's about that time."
  Catherine Butera

___
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

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

Re: [U2] [UV] printing html documents

[jpb-u2ug]

If your html files are in a type 19 file and the location on your network is
reachable from your pc, you can kick off the IE browser from Accuterm
sending the path of the file and it will pop up like the wed editor. Then
you can print it or view it.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman
Sent: Friday, November 13, 2009 12:56 PM
To: U2 Users List
Subject: Re: [U2] [UV] printing html documents

Thanks everyone for your suggestions, I will try them all out!  BTW, I'm 
using Accuterm on linux.
-Dianne

Dianne Ackerman wrote:
> I have some documents that were created by users using html editors 
> (different kinds) which then were saved into uv files.  I want to read 
> in these documents from within a basic program and send them to the 
> printer, all nicely formatted.  Any ideas?  The reason I'm doing it 
> from basic is because I have a lot of other data that I'm working with 
> also, the html files are just a small part of it.  Thanks.
> -Dianne
> ___
> 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

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

[U2] Agile and Scrum

[jpb-u2ug]

http://www.agilegamedevelopment.com/2007/12/pair-programming.html


XP Development


Jerry Banker

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

Re: [U2] Unibasic: Sample program - to extract data from Table

[jpb-u2ug]

Documenting the program or application is always a good idea, it also helps
if changes to the programs are documented, but having to write the specs to
the smallest minutia is overkill. Unless, you are writing the specs for
someone else that doesn't know your business or the next person in line
shouldn't be in the position to start with. 

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Susan Lynch
Sent: Wednesday, October 14, 2009 11:35 AM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

John, I agree that listening to the super users is critical.  However, 
writing a detailed spec will give those super users the ability to review 
the spec, add their 'second thoughts' (and the "wow, this is really cool - 
could it also do this?" ideas before the files are designed and the code 
written, and really does not take a lot of time.  It ensures that the coding

team all understand all the aspects of the project the same way.  So even 
with super users, I always waited for a sign-off on the detailed spec before

laying out the files and writing the code.  I had clients that I worked with

for years, and knew their business very well, but taking the time to write a

detailed spec was never a waste of my time.

I am glad for you that your system works well, but I hope I never have to 
come in after you all retire!  ;-)

Susan Lynch
- Original Message - 
From: "Israel, John R." 
To: "U2 Users List" 
Sent: 10/14/2009 12:14 PM
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table


> You cannot buy knowledge of a business.  Experience with a technology: 
> yes.  Knowledge of how a specific company works: no.  That only comes with

> time working at that site.
>
> A key to our success is having super-users that really know how the 
> business works, how the software works, and the ability to clearly 
> describe how they want things enhanced.  The other half of this coin is 
> having programmer/analysts that understand what the user wants, where the 
> data is stored (or will need to be stored), who ask the right questions, 
> and can work with those super-users.  Our users are very happy with what 
> we produce.  We have a small U2 team, but a well seasoned team.
>
> I rarely have specs and never very detailed.  It is all screen shots with 
> hand written notes that come from a meeting or two with the super-users. 
> Requests from non-super-users must go through the super-users.  It is my 
> job to understand what they want (which is usually, but not always what 
> they ask for).
>
> However, not every business will have these conditions.  Contractors have 
> it even tougher since they may have little knowledge of the business they 
> are trying to help.
>
> Just my experience...
>
>
>
> John Israel
>
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Susan Lynch
> Sent: Wednesday, October 14, 2009 12:00 PM
> To: U2 Users List
> Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
>
> As a programmer who has had to maintain and enhance systems that were
> written apparently based on a one-page spec that "everyone on the team"
> understood, when the team members are no longer there, and the 
> documentation
> was all between their ears (and left with them), I am a big believer in
> detailed written specs that get turned into test plans and then into
> documentation.
>
> Eventually the lack of specs turns around and bites the organization that
> allowed it to happen (unless the application was a one-time 
> quick-and-dirty
> project that will never have to be resurrected).
>
> Susan Lynch
> - Original Message - 
> From: "jpb-u2ug" 
> To: "'U2 Users List'" 
> Sent: 10/14/2009 8:18 AM
> Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
>
>
>> Alleluia! Brother!
>>
>> Jerry Banker
>>
>> -Original Message-
>> From: u2-users-boun...@listserver.u2ug.org
>> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
>> Sent: Wednesday, October 14, 2009 5:00 AM
>> To: 'U2 Users List'
>> Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
>>
>> Exactly - i still stick to the belief that a small team of highly skilled
>> programmers will code quicker from a single page spec than a thousand low
>> quality coders using a high detail spec. Many an institution disagrees, 
>> or
>> rather has been stung by smaller teams giving promises th

Re: [U2] Unibasic: Sample program - to extract data from Table

[jpb-u2ug]

Alleluia! Brother! 

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Wednesday, October 14, 2009 5:00 AM
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Exactly - i still stick to the belief that a small team of highly skilled
programmers will code quicker from a single page spec than a thousand low
quality coders using a high detail spec. Many an institution disagrees, or
rather has been stung by smaller teams giving promises that they can then
not deliver, I suppose this is what bureaucracy is all about, something
simple runs perfectly until someone slips up, then all hell breaks loose and
15 procedures are put into place and before you know it you have a team of
20 doing what one guy did all on his own.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug
Sent: 13 October 2009 22:54
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

If you are going to go that far with the minutia then why not just type it
in and get done with it?

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Tuesday, October 13, 2009 2:09 PM
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Actually for many it is mass produced. Specification is being done to the
absolute minutia, for example in the Unified Rational process, when
generating use cases these get transmitted down to the architectural
specifications and become the actual classes in the code (there is even
software to build such skeleton code), with each method and property
defined, again this is then used by the test plan to test each
class/method/property etc. The coder kind of just fills in the gaps.  In my
previous employment we had whole teams of BA's, DBA's, System Architects, UI
Designers, UX analysts etc, Then a bunch of people in the Philipines to do
exactly as was written down in front of them.   This kind of scenario
happens a lot in larger projects.

 
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug
Sent: 13 October 2009 18:00
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

I don't see where you are coming from here. Every program I ever produce is
for a specific purpose. We don't create one program and then have an
assembly line that types it in several times over and over again. We just
make copies of it. Programming takes skill, intelligence, and imagination.
It is not a massed produced product like linen or towels where they have to
have a body to recreate the product over and over.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Tuesday, October 13, 2009 9:43 AM
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Indian development firms are pretty much the same as any other - if you get
a small highly focused team of experts they will achieve a lot. The problem
is when you get large pools of programmers of various skill levels, and so
need more management time than it would take to program it in the first
place. But then this is in theory more scalable.

I live in the north west of England, just outside Manchester, the Industrial
revolution started here, It was once very big in the textile industry-
However no textiles are made here anymore, the old Victorian buildings that
used to produce these are now trendy apartments, or business parks. There
are a few specialist providers, I can kind of see software going the same
way. Much of software is grinding out work, that can be done very cheaply in
India/China/and Africa soon. All we in the western world will be doing is
niche specialist development. 


Perhaps




-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock
Sent: 12 October 2009 22:09
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Indian development firms aren't all they're cracked up to be, especially in
anything other than Microsoft technologies.  I've seen exactly this
progression in other language lists to which I belong.  Indian firm gets
contract based on price and claim to know the language.  Indian firm tries
to get free help from mailing lists, newsgroups, etc, because they don't
understand the technology.  Indian firm loses contract or is not renewed.

We've got persona

Re: [U2] Unibasic: Sample program - to extract data from Table

[jpb-u2ug]

If you are going to go that far with the minutia then why not just type it
in and get done with it?

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Tuesday, October 13, 2009 2:09 PM
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Actually for many it is mass produced. Specification is being done to the
absolute minutia, for example in the Unified Rational process, when
generating use cases these get transmitted down to the architectural
specifications and become the actual classes in the code (there is even
software to build such skeleton code), with each method and property
defined, again this is then used by the test plan to test each
class/method/property etc. The coder kind of just fills in the gaps.  In my
previous employment we had whole teams of BA's, DBA's, System Architects, UI
Designers, UX analysts etc, Then a bunch of people in the Philipines to do
exactly as was written down in front of them.   This kind of scenario
happens a lot in larger projects.

 
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug
Sent: 13 October 2009 18:00
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

I don't see where you are coming from here. Every program I ever produce is
for a specific purpose. We don't create one program and then have an
assembly line that types it in several times over and over again. We just
make copies of it. Programming takes skill, intelligence, and imagination.
It is not a massed produced product like linen or towels where they have to
have a body to recreate the product over and over.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Tuesday, October 13, 2009 9:43 AM
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Indian development firms are pretty much the same as any other - if you get
a small highly focused team of experts they will achieve a lot. The problem
is when you get large pools of programmers of various skill levels, and so
need more management time than it would take to program it in the first
place. But then this is in theory more scalable.

I live in the north west of England, just outside Manchester, the Industrial
revolution started here, It was once very big in the textile industry-
However no textiles are made here anymore, the old Victorian buildings that
used to produce these are now trendy apartments, or business parks. There
are a few specialist providers, I can kind of see software going the same
way. Much of software is grinding out work, that can be done very cheaply in
India/China/and Africa soon. All we in the western world will be doing is
niche specialist development. 


Perhaps




-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock
Sent: 12 October 2009 22:09
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Indian development firms aren't all they're cracked up to be, especially in
anything other than Microsoft technologies.  I've seen exactly this
progression in other language lists to which I belong.  Indian firm gets
contract based on price and claim to know the language.  Indian firm tries
to get free help from mailing lists, newsgroups, etc, because they don't
understand the technology.  Indian firm loses contract or is not renewed.

We've got personal experience in taking development contracts away from this
type of firm.

Larry Hiscock
Western Computer Services



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net
Sent: Monday, October 12, 2009 1:47 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Doesn't matter which.  We are the next group that will be asked to work 
for reduced pay or our work will go to India. 

Bruce M Neylon
Health Care Management Group 
Phone: (301) 608-8633
___
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

___
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://listser

Re: [U2] Unibasic: Sample program - to extract data from Table

[jpb-u2ug]

I don't see where you are coming from here. Every program I ever produce is
for a specific purpose. We don't create one program and then have an
assembly line that types it in several times over and over again. We just
make copies of it. Programming takes skill, intelligence, and imagination.
It is not a massed produced product like linen or towels where they have to
have a body to recreate the product over and over.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Tuesday, October 13, 2009 9:43 AM
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Indian development firms are pretty much the same as any other - if you get
a small highly focused team of experts they will achieve a lot. The problem
is when you get large pools of programmers of various skill levels, and so
need more management time than it would take to program it in the first
place. But then this is in theory more scalable.

I live in the north west of England, just outside Manchester, the Industrial
revolution started here, It was once very big in the textile industry-
However no textiles are made here anymore, the old Victorian buildings that
used to produce these are now trendy apartments, or business parks. There
are a few specialist providers, I can kind of see software going the same
way. Much of software is grinding out work, that can be done very cheaply in
India/China/and Africa soon. All we in the western world will be doing is
niche specialist development. 


Perhaps




-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock
Sent: 12 October 2009 22:09
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Indian development firms aren't all they're cracked up to be, especially in
anything other than Microsoft technologies.  I've seen exactly this
progression in other language lists to which I belong.  Indian firm gets
contract based on price and claim to know the language.  Indian firm tries
to get free help from mailing lists, newsgroups, etc, because they don't
understand the technology.  Indian firm loses contract or is not renewed.

We've got personal experience in taking development contracts away from this
type of firm.

Larry Hiscock
Western Computer Services



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net
Sent: Monday, October 12, 2009 1:47 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Doesn't matter which.  We are the next group that will be asked to work 
for reduced pay or our work will go to India. 

Bruce M Neylon
Health Care Management Group 
Phone: (301) 608-8633
___
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

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

Re: [U2] Unibasic: Sample program - to extract data from Table

[jpb-u2ug]

I don't think anyone was questioning Jay's intelligence. He is probably a
very intelligent person or he would not have been hired. What is in question
is the intelligence of the individuals that hired the firm he works for and
the intelligence of the people that gave him the work to do without first of
having him trained on it.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Rubeor
Sent: Tuesday, October 13, 2009 8:26 AM
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Excellent points.  In my personal experience, I've had terrible dealings
with overseas firms.  On the flip side, the sharpest person I've ever worked
with was from New Delhi.
 
Getting back to the point at hand, I believe that Pick Systems had some
development work done in Russia, during the early 90's.  I remember their
work as being very good and remarkably bug-free. (Of course, I also drank a
lot during those days, so my memory may not be that good.)  Now,all of a
sudden, at the same time that Rocket Software picks up U2, we start getting
questions from rsystems in India.  Naturally, I wondered if Rocket Software
was the company that hired them.  Probably not, but I'm still curious.

>>> "Larry Hiscock"  10/12/2009 5:09 PM >>>
Indian development firms aren't all they're cracked up to be, especially in
anything other than Microsoft technologies.  I've seen exactly this
progression in other language lists to which I belong.  Indian firm gets
contract based on price and claim to know the language.  Indian firm tries
to get free help from mailing lists, newsgroups, etc, because they don't
understand the technology.  Indian firm loses contract or is not renewed.

We've got personal experience in taking development contracts away from this
type of firm.

Larry Hiscock
Western Computer Services



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net
Sent: Monday, October 12, 2009 1:47 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Doesn't matter which.  We are the next group that will be asked to work 
for reduced pay or our work will go to India. 

Bruce M Neylon
Health Care Management Group 
Phone: (301) 608-8633
___
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

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

Re: [U2] U2 is now Rocket U2

[jpb-u2ug]

Prime Information

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dawn Wolthuis
Sent: Monday, October 12, 2009 3:32 PM
To: U2 Users List
Subject: Re: [U2] U2 is now Rocket U2

Love the U2-rocket story, Dominic. I don't know if there is any U2 in
Russia or related countries, but I understand that some PICK or
PICK-a-like system was used to track Russian spies in the US, perhaps
all the way to the end of the cold war. If anyone has details on that,
such as which MV flavor it was (something I might have known at one
time), I'd be interested.  [And, yes, I know, I know, I shouldn't be
on this list--it should move over to U2C, but ...]  Cheers!  --dawn
-- 
Dawn M. Wolthuis

Take and give some delight today

On Mon, Oct 12, 2009 at 2:36 PM, Dominic Baron
 wrote:
>
>
> Yes, I also like U2. It has interesting historical associations, for those
of us of a certain age. It was a "U2" spy-plane that was shot down by a
"rocket" over the USSR in 1960 that led to quite a frosty first meeting
between Khruschev and Kennedy in Geneva that year.
>
> Which leads me to ask if anyone knows whether any U2 (DB's of course)
installations exist in Russia or in any of the former Soviet Republics?
>
> Dominic Baron.
___
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] U2 is now Rocket U2

[jpb-u2ug]

This all depends, if I am reading it correctly, their other products are
being advertised until their original names and Rocket is more in the
background. So they may advertise the U2 products under a completely
different name. What would you like the name to be? Maybe Rocket would like
some input on this point. After all we created the term U2 and IBM adopted
it. Now, I think we should drop the U2 brand, since a lot of people think we
are talking about the rock group, for a more 21st century name. Also we have
got to stop calling them Pick databases. Multi-dimensional, multi-valued and
extended relational are okay but maybe we can come up with a more futuristic
name than that. How about Rocket or the users group starting up a contest to
name the new division?

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Smith, Robert
Sent: Friday, October 09, 2009 8:24 AM
To: U2 Users List
Subject: Re: [U2] U2 is now Rocket U2

At some point, we will hopefully evolve beyond the "old = undesirable"
mentality that is pervasive in our society, and once again appreciate the
imagery that "old" things can evoke. As a technician with over thirty years
experience, I have thoroughly enjoyed the journey I have witnessed since the
days of the LP Player...to the iPod of today. What we largely lack today is
a sense of history relative to what it has taken for us to progress to this
point...and the imagination to achieve even more phenomenal accomplishments
in the future. Where once our thoughts were expansive and limitless, they
are now reserved and pedestrian. If someone with a sense of history and a
determination to use "Rocket" as a means to evoke the imagery of a time when
we thought in grander scales...then they were sadly mistaken. The company
should seriously consider changing its name, otherwise they will be the butt
of many a jokes.

My two cents
Rob  

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of inquieti
Sent: Friday, October 09, 2009 5:03 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] U2 is now Rocket U2


IBM is very sixties also.  Have you ever been to the Apollo space centre? 
All the computers were IBM and the IBM logo is splashed all around the
control room.  So I think if you're thinking retro then IBM sits there right
along side Sputnik et al.

Jacques G. wrote:
> 
> I wonder what is the marketing idea behind the name "Rocket" ?   To me it
> invokes late 1950 - 1960's Sputnik/Apollo technology to an epoch when cars
> designs were made to look like rockets, when there was a hockey player
> nicknamed "Maurice The Rocket Richard" and people watched "Flash Gordon"
> on a black and white television.
> 
> When I hear Rocket I think "retro" like a  LP Player, a typewriter, a
> PDP-1.  
> 
> Wouldn't one want a software product to sound more state of the art ?
> 
> Sci-fi hasn't used the term "Rocketship" in decades.
> 
> 
> Jacques
> 
> 
>   
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> 

-- 
View this message in context:
http://www.nabble.com/U2-is-now-Rocket-U2-tp25693358p25817827.html
Sent from the U2 - Users mailing list archive at Nabble.com.

___
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

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

Re: [U2] hpux to linux; Solaris 2.6 to Solaris 10

[JPB-U2UG]

A company decision to make everything Microsoft.

--
From: "Jeff Powell" 
Sent: Wednesday, October 07, 2009 1:25 PM
To: 
Subject: Re: [U2] hpux to linux; Solaris 2.6 to Solaris 10

Just out of curiosity, why are you moving to windows? Are there specific 
benefits?


Thanks.

On 10/07/2009 10:55 AM, jpb-u2ug wrote:
We have moved from Unix V5 on Motorola, to Solaris 2.6, to Solaris 8, to 
RH

Linux AS3, and are now in the process of moving to Windows 2008.

___
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] hpux to linux; Solaris 2.6 to Solaris 10

[jpb-u2ug]

We have moved from Unix V5 on Motorola, to Solaris 2.6, to Solaris 8, to RH
Linux AS3, and are now in the process of moving to Windows 2008. Also during
that time we moved from UV 7.4, to 9.6, to 10.1, to 10.2. All of the 'Nix
moves were relatively simple because the operating systems were relatively
the same. The easiest way to move, if possible, is to use uvbackup and
uvrestore. All magic numbers are taken care of. If you are copying the files
a different way then you will have to do fnuxi on the files. On Solaris if
you're moving from a RISC system to and Intel system or visa-versa then you
will have to do the same thing. Going into Universe the first time will
cause an account update which will most likely cause you to lose the long
file names option (LONGNAMES ON will fix this) and will overwrite any
reserved commands you may have changed for your own convenience. You should
do a COMPILE.DICTS to compile all of the dictionary I-Descriptors, compile
all of the programs, and catalog any programs that are globally cataloged.
Any programs/procs/paragraphs/scripts containing operating system commands
should be tested. If you have distributed files they will have to be broken
apart. If you change the path to your account any VOC items containing the
path will have to be changed. It's always best to test everything on the new
system before doing the move for real. When we moved between 'Nix systems it
only took a Saturday and one person that knew what they were doing. The
length of time all depends on how much data you are moving. You can always
set up the VOC file ahead of time and just copy all of the other files over
when you go live.
Moving to Windows is a different animal. You have to do the same things as
moving between 'Nix systems but you also have to find new ways of
manipulating your spooled reports. That is, if you have any specially built
spooler driver scripts. The spooler no longer exists as it does on the 'Nix
systems. I don't know why they couldn't have just done the same as they did
on the 'Nix systems. We've just started getting into this conversion so I
can't tell how it will turn out yet.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold
Sent: Tuesday, October 06, 2009 11:38 AM
To: U2 Users List
Subject: [U2] hpux to linux

We have Rocket's Universe 10.2 over hpux 11.11 but are considering
moving to a linux box. Has anyone ported a U2 app from hpux to linux?  I
am trying to estimate for management how long such a porting might take.
Just an opinion would be helpful, like 'easy', 'medium', 'hard', 'really
hard'.

Thanks-
Harold Oaks
Clark County



This e-mail and related attachments and any response may be subject to
public disclosure under state law.
___
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] [U2C] what's in a (rocket) name?

[jpb-u2ug]

Yes, but it may not be all that bad for Universe, you can "Take a Rocket to
the Universe!" But, that doesn't work for Unidata.

Jerry Banker


-Original Message-
From: u2-community-boun...@listserver.u2ug.org
[mailto:u2-community-boun...@listserver.u2ug.org] On Behalf Of Results
Sent: Saturday, September 19, 2009 11:45 AM
To: U2 Users Community
Subject: Re: [U2C] what's in a (rocket) name?

Allen,
I love it... I have it on good authority that the U2 brand (however 
it is branded) will probably not have Rocket anywhere in then name. So, 
all, the field is wide open: What would you name the U2 company if you 
were in charge?

- Chuck "I Would Name It Chuck" Barouch

Allen E. Elwood wrote:
> A LOT!
>
> Lets just hope nobody gets acronym crazy and decides to call U2 programs
>
> Software
> Hardware
> Intelligence
> Packet
> Streams
>
> Because then we'd have ROCKETSHIPS instead of programs
>
>
>
> Although, to compete with SQL U2 needs a name boost.
>
> Studies show that audiences respond more favorably to names with Q's and
X's
>
> So, perhaps 'Rocket X2' or 'Rocket XQL' would be a better name than U2???
>
> And of course 'Rocket Extreme' might make it more appealing to youngsters
> entering college.
>
>
> :-)
>
>
>
> ___
> U2-Community mailing list
> u2-commun...@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-community
> 
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com 
> Version: 8.5.409 / Virus Database: 270.13.107/2382 - Release Date:
09/19/09 06:03:00
>
>   

___
U2-Community mailing list
u2-commun...@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-community

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

Re: [U2] Indexing

[jpb-u2ug]

I just tried it on 10.2.4 or UV and it works!

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Henry Unger
Sent: Monday, September 14, 2009 8:55 PM
To: 'U2 Users List'
Subject: Re: [U2] Indexing

Yes indeed, however it was removed. Hopefully, it will reappear.

Best regards,

Henry

Henry P. Unger
Hitech Systems, Inc.
http://www.hitech.com

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton Oliver
Sent: Monday, September 14, 2009 4:26 PM
To: U2 Users List
Subject: Re: [U2] Indexing

I seem to recall that they added the CONCURRENT option to BUILD.INDEX  
several years back but didn't document it except in the patch file for  
that release.

Does anyone else remember this?

Regards,

Clif

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


On Sep 9, 2009, at 2:43 , Dan Fitzgerald wrote:

> Building indices means exclusive locks on the file, i.e., downtime.  
> The
> good news is that the builds are usually very quick.

___
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

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

Re: [U2] FW: Running a test program and getting an error

[jpb-u2ug]

Hum, oh yeah, that's the ticket, removed it from the line. :-) I've got to 
start reading what they send me. Good thing that system is our development 
system on a separate network. I think you were right.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
br...@brianleach.co.uk
Sent: Thursday, September 10, 2009 8:39 AM
To: U2 Users List
Subject: Re: [U2] FW: Running a test program and getting an error

Jerry

Well, let's deal with the obvious one first - I assume they did also specify the
password and you've removed it for the reason of not dumping passwords on to the
list?

Brian

On 10 September 2009 at 15:25 jpb-u2ug  wrote:

> Forwarding for one of our .NET developers. Have you got an answer?
> 
>  
> 
> Jerry Banker
> 
>  
> 
> Running the test program below and getting an error.  Any idea's?
> 
>  
> 
> C:\Program Files\IBM\SQLLIB\BIN>testconn20.exe
> Database=AACSQL;UserID=swd;Server
> 
> =linux2;Pooling=False;ServerType=UniVerse
> 
>  
> 
> Step 1: Printing version info
> 
> .NET Framework version: 2.0.50727.4016
> 
> DB2 .NET provider version: 9.0.0.2
> 
> DB2 .NET file version: 9.5.4.2
> 
> Capability bits: ALLDEFINED
> 
> Build: 20090430
> 
> Factory for invariant name IBM.Data.DB2 verified
> 
> Factory for invariant name IBM.Data.Informix verified
> 
>IDS.NET from DbFactory is Common IDS.NET
> 
> VSAI assembly version: 9.1.0.0
> 
> VSAI file version: 9.5.2.157
> 
>ERROR - VSAI file version different from DB2 .NET provider
> 
> Elapsed: 0.2028169
> 
>  
> 
> Step 2: Connecting using
> "Database=AACSQL;UserID=swd;Server=linux2;Pooling=False
> 
> ;ServerType=UniVerse"
> 
> ERROR [Env_CreateConnection]  [IBM U2][UCINET][UNIVERSE]:Failure to
> logi
> 
> n as remote user.
> 
>  
> 
> ___
> 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

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

[U2] FW: Running a test program and getting an error

[jpb-u2ug]

Forwarding for one of our .NET developers. Have you got an answer?

 

Jerry Banker

 

Running the test program below and getting an error.  Any idea's?

 

C:\Program Files\IBM\SQLLIB\BIN>testconn20.exe
Database=AACSQL;UserID=swd;Server

=linux2;Pooling=False;ServerType=UniVerse

 

Step 1: Printing version info

.NET Framework version: 2.0.50727.4016

DB2 .NET provider version: 9.0.0.2

DB2 .NET file version: 9.5.4.2

Capability bits: ALLDEFINED

Build: 20090430

Factory for invariant name IBM.Data.DB2 verified

Factory for invariant name IBM.Data.Informix verified

   IDS.NET from DbFactory is Common IDS.NET

VSAI assembly version: 9.1.0.0

VSAI file version: 9.5.2.157

   ERROR - VSAI file version different from DB2 .NET provider

Elapsed: 0.2028169

 

Step 2: Connecting using
"Database=AACSQL;UserID=swd;Server=linux2;Pooling=False

;ServerType=UniVerse"

ERROR [Env_CreateConnection]  [IBM U2][UCINET][UNIVERSE]:Failure to
logi

n as remote user.

 

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

Re: [U2] Hmmmm...Learn something new every day!

[jpb-u2ug]

You can tell it's Friday :-) 

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steven M Wagner
Sent: Friday, September 04, 2009 3:56 PM
To: U2 Users List
Subject: Re: [U2] H...Learn something new every day!

And a fine PERFORMance you are providing us. . . . .

-- Sent from my Palm Pre
George Gallen wrote:

I wonder if you use EXECUTE without any CLAUSES, the compiler

converts it to a PERFORM?



sounds like I'm anti-Santa hereEXECUTING CLAUSES!



> -Original Message-

> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-

> boun...@listserver.u2ug.org] On Behalf Of George Gallen

> Sent: Friday, September 04, 2009 4:33 PM

> To: U2 Users List

> Subject: Re: [U2] H...Learn something new every day!

>

> But the question is, why does removing the CAPTURING CLAUSE

>fix the problem (allow passing the data).

>

> with the CAPTURING, user0 won't pass

> without the CAPTURING, user0 passes fine

>

> I thought PERFORM and EXECUTE were the same?

>

> George

>

> > -Original Message-

> > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-

> > boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore

> > Sent: Friday, September 04, 2009 4:30 PM

> > To: U2 Users List

> > Subject: Re: [U2] H...Learn something new every day!

> >

> > EXECUTE creates a new environment, try PERFORM.  From BASIC Help:

> >

> > EXECUTE creates a new environment for  the  executed  command.

> > This  new  environment  is  initialized with the values of the

> > current prompt, current printer state, Break key counter,  the

> > values  of  in-line prompts, KEYEDITs, KEYTRAPs, and KEYEXITs.

> > If any of these values change  in  the  new  environment,  the

> > changes are not passed back to the calling environment. In the

> > new environment, stacked @variables are either initialized  to

> > 0 or set to reflect the new environment. Nonstacked @variables

> > are shared between the EXECUTE and calling environments.

> >

> > Tom

> >

> ___

> 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


___
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

[U2] What ever happened...

[jpb-u2ug]

Whatever happened to the Toucan?

 

Jerry Banker

UV Project Leader

Senior Programmer Analyst

IBM Certified Solutions Expert

 

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

[U2] Error UV 10.2.4 Reality flavor

[jpb-u2ug]

I was wondering if any of you have an answer for this problem. We are trying
to connect to our test box using ado.net and getting errors. In visual
studio we are getting the messages:

 

An error occurred while connecting to the database. The database might be
unavailable, An exception of type 'System.Data.ProviderlncompatibleException
occurred. The error message is: 'The Provider Manifest is incorrect. 

(399,6): error 0019: Function 'DB2.LEFT with the same Storage
space type parameters already exists. Make sure that function overloads are
not ambiguous. 

(427,6): error 0019: Function 'DB2.LOwER' with the same
Storage space type parameters already exists. Make sure that function
overloads are not ambiguous. 

(441,6): error 0019: Function 'DB2.LTRIM' with the same
Storage space type parameters already exists. Make sure that function
overloads are not ambiguous. 

(484,6): error 0019: Function 'DB2.REPLACE with the same
Storage space type parameters already exists. Make sure that function
overloads are not ambiguous. 

 (501,6): error 0019: Function 'DB2.REPUCATE' with the same
Storage space type parameters already exists. Make sure that function
overloads are not ambiguous. 

(515,6): error 0019: Function 'D82.REVERSE' with the same
Storage space type parameters already exists. Make sure that function
overloads are not ambiguous. 

 (530,6): error 0019: Function 'DB2.RIGHT' with the same
Storage space type parameters already exists. Make sure that function
overloads are not ambiguous. 

 (544,6): error 0019: Function 'D82.RTRIM' with the same
Storage space type parameters already exists. Make sure that function
overloads are not ambiguous. 

(603,6): error 0019: Function 'D82.STUFF with the same Storage
space type parameters already exists. Make sure that function overloads are
not ambiguous. 

(647,6): error 0019: Function 'DB2.UpPER' with the same
Storage space type parameters already exists. Make sure that function
overloads are not ambiguous.. 

 

On the Universe side I am getting the following in the runtime errlog:

 

Wed Aug 26 12:00:25  -11765 root Program "*HS.OLEDBINFO": Line 431,
Message[0400

24]

Wed Aug 26 12:04:06  -11769 root Program "*HS.OLEDBINFO": Line 652,
Message[0400

36]

Wed Aug 26 12:04:06  -11769 root Program "*HS.OLEDBINFO": Line 653,
Message[0400

36]

Wed Aug 26 12:04:06  -11769 root Program "*HS.OLEDBINFO": Line 653,
Message[0400

36]

Wed Aug 26 12:04:06  -11769 root Program "*HS.OLEDBINFO": Line 654,
Message[0400

36]

Wed Aug 26 12:04:06  -11769 root Program "*HS.OLEDBINFO": Line 662,
Message[0400

36]

 

And repeats from there.

 

Jerry Banker

UV Project Leader

Senior Programmer Analyst

IBM Certified Solutions Expert

 

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

Re: [U2] SBClient 5.3.8 on 64 bit vista

[jpb-u2ug]

Accuterm has device licensing too.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Powell
Sent: Friday, August 21, 2009 10:34 AM
To: U2 Users List
Subject: Re: [U2] SBClient 5.3.8 on 64 bit vista

Thanks Steve.

I tried running Accuterm and a few other wyse60 emulators but I was
getting errors from system builder.

I forgot to mention that we have device licensing which is one of the
reasons I need to use sbclient.

Thanks again.

Jeff


Steve Romanow wrote:
> Jeff Powell wrote:
>> I have a user who needs to work from home with his Vista PC. We are 
>> having trouble installing sbclient on this machine it is saying "this 
>> program is not compatible with 64 bit".
>>
>> Has anyone made sbclient 5.3.8 work on a 64 bit vista machine? If not 
>> what can I do for this user. We are running Unidata 7.1 with 
>> SystemBuilder 5.3.8. We only use character mode.
>>
>> Thanks.
>>
>> Jeff
>>
>>
>> ___
>> U2-Users mailing list
>> U2-Users@listserver.u2ug.org
>> http://listserver.u2ug.org/mailman/listinfo/u2-users
> Does he use smart query or any dde transfer capability?  If not, you 
> can use other clients with SB+.  I personally use Putty (on windows 
> and linux) but pretty much any terminal emulator will work (with 
> enough tweaking.)
>
> I have TERM.DEFN records for VT100, VT220, and wy60 if you want to 
> tinker.
>
> It is a pretty painstaking process, most times you will find that for 
> each offering, almost everything works, but different things broken 
> with each one.
>
> Things to check are F1-F4, F11 and F12 for insert and delete.  
> Backspace and Delete compatibility.  All of this is easier if you do 
> not require 16-color.  I have color working with mine, but it takes 
> out half the work if monochrome is satisfactory.
> ___
> 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

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

[U2] UV on Windows

[jpb-u2ug]

We are setting up a networked UniVerse Windows 2008 server for future use
and coming from a long line of 'Nix processing systems I have some questions
about how database administration is handled from those that use a Windows
system. The users will all be entered through the network so I know I won't
have to worry about doing that any more but what about the other things like
file administration? I already know that there is no spooler anymore. Do you
use the UniAdmin much or is everything done from the command line? Do you
use a separate database administrator login to do database administration or
do you have to be the system administrator? The network administrator wants
to, understandably, lock the system down as tightly as possible without
shutting down the business so how far do you go? When resizing files do they
carry the same properties over or do they have to be reset? For those that
have moved from Linux to Windows, did you have to change any configuration
settings? I tested a short program that was recently bench marked by several
people on this list, building a dynamic array, and I was really surprised by
the difference in the speed between the various times reported and also my
own testing of our current Linux server and the new Windows server (0.6
seconds as opposed to 35 minutes). I reported the difference to my VAR and
they sent the results on the IBM. I'm thinking, hoping, that we will just
need to change some of the environment variables. I know I can ask my VAR
these questions but I want to get more of a consensus from the list.

 

Please let's not get caught up in the 'Nix/Windows battle J.

 

Jerry Banker

UV Project Leader

Senior Programmer Analyst

IBM Certified Solutions Expert

 

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

Re: [U2] FW: Universe just quits

[jpb-u2ug]

It also cleans the session up and leaves a system message (050005) in the
errlog file of the uv folder so you can track who has been leaving their
sessions active.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David
Sent: Wednesday, July 22, 2009 7:20 PM
To: 'U2 Users List'
Subject: Re: [U2] FW: Universe just quits

Harold,

Is there any reason you don't use the UV command AUTOLOGOUT to time out idle
sessions? 

It does what you want already from within UV already (and can be setup
individually or globally for all UV sessions) and doesn't have the problem
of just looking at terminal keyboard input idle time like the UNIX who
command does.

Regards
David



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold
Sent: Thursday, 23 July 2009 7:01 AM
To: U2 Users List
Subject: Re: [U2] FW: Universe just quits


Thanks to all who made suggestions.  I'm definitely going to use some of
them to improve processing. 

Good news: Universe is not at fault!  

So why did the process just end?  Because a background process we run
logs out processes idle for more than 3 hours.  To determine idle time
we check the 7th column of the output from the unix command "who -HTR".
Here was the surprise for me:  even though the process was furiously
performing I/O, as far as that unix command was concerned, it was idle.
Oops! Easy to fix that, of course.

The best parts of this were that UniVerse came through as more robust
than I had worried it wasn't, and that contributors gave me some great
advice.

Thanks again to all.
Harold Oaks


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return
email, do not use or
disclose the contents, and delete the message and any attachments from your
system. Unless
specifically indicated, this email does not constitute formal advice or
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its
subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us,
please reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
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 just quits

[jpb-u2ug]

Sounds like a job for indexing.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold
Sent: Tuesday, July 21, 2009 4:54 PM
To: U2 Users List
Subject: Re: [U2] Universe just quits

Barry:
Thanks for resonding.

The main activity is running thru text files (narratives), identifying
the next word then updating a file (DEXNAR) used to cross-reference all
the words.  For example, in record ABC123 in the narrative field the
next identified word is DECOMPOSING.  I read the record DECOMPOSING from
the DEXNAR file.  The record DECOMPOSING has 10 lines in it, because 10
other prior narratives had the word DECOMPOSING.  The program seeks the
current record key (ABC123) in the fields using the LOCATE command. If
not found, the key ABC123 is appended to the end of the DECOMPOSING
record and DECOMPOSING it is written out, now with 11 fields.

Some of the records in DEXNAR get long as they are for fairly common
words, like ALIAS. (The most common words I do not bother to
cross-reference, of course, like the word THE).  Thus, the LOCATE is
looking thru an ever increasing number of fields as we go along.  Some
records currently have over 11000 fields.  Is that the problem?  Maybe
the sytem tries to 'fit' the next very long record in memory to do the
LOCATE and it overflows something?

The dropping out, however, occurs normally after updating 25000+
records.  Shorter runs seem to 'hold out'.  What might be building up in
memory space?  These are also overnight runs, typically, so there are
fewer users to contend with making it unlikely that it's exceeded limits
for all users, I would think.

The point of the cross-reference file is to allow users to quickly
search thru all the 700,000 available (crime) narratives for the ones
that match a set of entered search words.  Searching that many
narratives using brute force would probably take 5+ minutes for each
search on our system, which would really stifle the crime analysts.

Thanks-
Harold

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen
Sent: Tuesday, July 21, 2009 1:03 PM
To: U2 Users List
Subject: Re: [U2] Universe just quits


Can you elaborate a little on these tasks

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 Oaks, Harold
Sent: Tuesday, July 21, 2009 2:41 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Universe just quits

I am having a very disconcerting problem.  A long job I have been
running, processing a large text file and then loading a Universe file,
is simply quitting sometimes.  No error message of any kind, Universe
just quits, the session drops into unix.  We have Universe 10.2 running
over HPux 11.1.  I have reduced the job to smaller pieces to get thru it
and indicate data values so that I restart at about the dropout point.
So I'll be able to finish but I would like to understand what's going
on.

Anybody seen this kind of thing before?  Is there a Universe parameter I
should look at?  A unix kernal parameter?  

Any ideas appreciated.
Thanks-

Harold Oaks
Sr. Analyst/Programmer
Clark County Information Systems
Clark County, Washington
ph: (360) 397-6121 x4132



This e-mail and related attachments and any response may be subject to
public disclosure under state law.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

21/7/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,

Re: [U2] UniBasic - Multiple Accounts

[jpb-u2ug]

I haven't been following this thread so excuse me if 'm off in left field,
but, wouldn't it be better just to set up a file pointer in the VOC that
points to where you want to write rather than setting up an entire account
and logging to it before you write?

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill
Sent: Tuesday, July 21, 2009 1:52 PM
To: U2 Users List
Subject: [U2] UniBasic - Multiple Accounts

 
Does it make any sense to
.
execute "LOGTO UPS"

open 'UPS' to F.UPS  else  null
.
write R.UPS to F.UPS...
.
.
execute "LOGTO METAL"

open 'PACK.SLIPS' to F.PS  else  null
.
write R.PackSlip to F.PS...

Our visiting UPS tech support rep (Ralph Sorrano) suggested creating a
new account with a single file in it.  
Thus, the UPS WorldShip desktop software would not be overwhelmed with
hundred of files upon launch.

I have not tried it yet.  Perhaps there is a better way.  Suggestions
would be appreciated.

--Bill

___
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] Converting from mvBase to Universe

[jpb-u2ug]

I'm sorry if I wasn't clear. After looking at what I wrote I can see why but
I think you answered my question.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Taylor
Sent: Monday, July 20, 2009 12:10 PM
To: U2 Users List
Subject: Re: [U2] Converting from mvBase to Universe

I'm not sure what you're asking, Jerry, but this may help.

The SP-ASSIGN commands differ in syntax between the generic Pick print 
spooler and the Reality spooler, as follows:

Ex. (PickR syntax): SP-ASSIGN (options) (copies) F(queuenumber), 
R(printfilenumber)

Ex. (RealityR syntax): SP-ASSIGN = (queuename) (options) (copies)

 SpoolerPlusR supports both of these forms of the SP-ASSIGN 
command.

Universe has its own form of SP.ASSIGN (SP-ASSIGN works also) command, and 
their syntax is slightly different for Universe/nix vs Universe/doz 
platforms and is unlike both the generic Pick and Reality syntax above.

I don't know if there is a difference between the syntax of the Universe 
SP-ASSIGN command in a Pick-flavor account vs in a Reality-flavor account on

the same operating system.  There is no indication in the IBM documentation 
of such difference based on the flavor of the account.

In Universe/nix: the documentation states "Use SP.ASSIGN to set the line 
printer spooler options for each of the 256 logical print channels."

In Universes/doz: the documentation states "Use SP.ASSIGN to set the line 
printer spooler options for Windows platform."

These differences are due to the fact that Universe/nix does have a spooler 
that provides some ability to manage and control print jobs other than just 
print them to the printer, where as Universe/doz has no spooler whatsoever 
and prints directly to the doz printer, after which ofcourse you lose all 
control over the print job from Universe.

In both cases, regardless of the platform, Universe prints to printers, not 
to queues, and does not support the print architecture used in both Reality 
and in other generic Pick databases (which afterall began with Reality) of 
printing to queues and then printing from queues to printers, including all 
the flexibilty of  holding/suppressing/both any print job, redirecting a 
print job from one printer to another, using the same printer for multiple 
print jobs with time to change paper before changing queues, listing and 
managing all print jobs on hold, etc.

 Changing the printing practices of an entire organization, including 
rewriting printing procecedures, retraining personnel, expanding the number 
of printers and serial/network connections and network support necessary to 
implement a far less powerful and flexible print architecture is usually far

more costly than the license fee for a complete generic Pick print spooler 
solution like SpoolerPlus.

If I didn't anwer your question, please rephrase it so maybe I'll understand

it.

hth,

Dave

Dave Taylor
Sysmark Information Systems, Inc.
Authorized IBM Business Partner
49 Aspen Way
Rolling Hills Estates, CA 90274
(O) 800-SYSMARK (800-797-6275)
(F) 310-377-3550
(C) 310-561-5200
www.sysmarkinfo.com

- Original Message - 
From: "jpb-u2ug" 
To: "'U2 Users List'" 
Sent: Monday, July 20, 2009 9:23 AM
Subject: Re: [U2] Converting from mvBase to Universe


> Is the SP-ASSIGN command that different in UV or is this just flavor
> dependant? We have an SP-ASSIGN and we are in Reality flavor.
>
> Jerry Banker
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman
> Sent: Monday, July 20, 2009 9:23 AM
> To: U2 Users List
> Subject: Re: [U2] Converting from mvBase to Universe
>
> We actually wrote our own subroutine SP-ASSIGN so that all embedded
> SP-ASSIGN commands within basic programs don't need to change - they
> just use our subroutine which calls SETPTR with appropriate commands.
> -Dianne
>
> Dave Taylor wrote:
>> Hi Curt,
>>
>> We have migrated the software on a number of systems from mvBase to
>> Universe running on both Windows and Linux.
>>
>> The good news is that the Pick-flavored account on Universe is very
>> close to mvBase.
>>
>> Also good news is that Universe has two file types - type 1 and type
>> 19 - that are both directory-type files: ie. the Universe file  is a
>> Linux directory/Windows folder and each item in the Universe file is a
>> Linux/Windows file in that directory/folder.
>>
>> When a record is written to the Universe file, all the Attr. marks are
>> converted to CRLF sequences and then converted back when it is read by
>> Universe, so the records can even be edited with Notepad from ouside
>> Universe if you wish.

Re: [U2] Converting from mvBase to Universe

[jpb-u2ug]

Is the SP-ASSIGN command that different in UV or is this just flavor
dependant? We have an SP-ASSIGN and we are in Reality flavor.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman
Sent: Monday, July 20, 2009 9:23 AM
To: U2 Users List
Subject: Re: [U2] Converting from mvBase to Universe

We actually wrote our own subroutine SP-ASSIGN so that all embedded 
SP-ASSIGN commands within basic programs don't need to change - they 
just use our subroutine which calls SETPTR with appropriate commands.
-Dianne

Dave Taylor wrote:
> Hi Curt,
>
> We have migrated the software on a number of systems from mvBase to 
> Universe running on both Windows and Linux.
>
> The good news is that the Pick-flavored account on Universe is very 
> close to mvBase.
>
> Also good news is that Universe has two file types - type 1 and type 
> 19 - that are both directory-type files: ie. the Universe file  is a 
> Linux directory/Windows folder and each item in the Universe file is a 
> Linux/Windows file in that directory/folder.
>
> When a record is written to the Universe file, all the Attr. marks are 
> converted to CRLF sequences and then converted back when it is read by 
> Universe, so the records can even be edited with Notepad from ouside 
> Universe if you wish.
>
> This means that you can strip out all the U-statements in mvBase code, 
> define your OS-level file as a type 19 file in Universe (supports long 
> file name compared with the type 1 file) and OPEN, READ, WRITE, etc. 
> directly to/from it just like you do with any other Universe file.
>
> In our EDI translator, we use the U-statements in mvBase extensively 
> in reading/writing EDI documents to/from the database to OS-level 
> files for automatic transfer to/from other computers and all the 
> U-statements have been stripped out and replaced with normal OPEN, 
> READ, WRITE statements to/from type 19 files in the Universe version 
> of the product.
>
> The only significant difference between mvBase (and all other generic 
> Pick databases for that matter) and Universe is that Universe does not 
> support the generic Pick print spooler for assigning user print output 
> to a queue and assigning a printer to the same queue to enable the 
> printing of the print job to the printer, and all the other features 
> of holding and spooling print jobs to selected printers.
>
> None of the generic Pick print spooler commands are available to 
> perform those functions - eg STARTSPOOLER, STARTPTR, SP-ASSIGN, 
> LISTPEQS, SP-EDIT, etc.
>
> So all embedded SP-ASSIGN commands have to be converted to SETPTR 
> commands, new print procedures have to be developed and all users have 
> to be retrained in using a much less robust print architecture than 
> they're used to using.
>
>  To bridge this gap in functionality, we developed SpoolerPlus, a 
> generic Pick print spooler, that runs on Universe, Unidata and QM, to 
> provide the generic Pick print spooler commands and functionality 
> built into software migrated from generic Pick databases.
>
> I will be pleased to send you some infomation about SpoolerPlus if you 
> wish..
>
> Also, please feel free to ask any specific questions about minor 
> differences between mvBase and Universe and I'll be glad to answer 
> them if I can.
>
> Best wishes for a successful conversion,
>
> Dave
>
> Dave Taylor
> Sysmark Information Systems, Inc.
> Authorized IBM Business Partner
> 49 Aspen Way
> Rolling Hills Estates, CA 90274
> (O) 800-SYSMARK (800-797-6275)
> (F) 310-377-3550
> (C) 310-561-5200
> www.sysmarkinfo.com
> - Original Message - From: "Curt Stewart" 
> 
> To: 
> Sent: Sunday, July 19, 2009 2:43 PM
> Subject: [U2] Converting from mvBase to Universe
>
>
>> I have a client that is considering moving from an mvBase system to a
>> Universe (Windows) system.  A lot of their processes are tied to 
>> specific
>> ports and ranges.  Is there an easy solution in Universe to "nail" the
>> telnet ports for the users?
>>
>> Also, they use UREAD and UWRITE and take advantage of the MVClients 
>> ability
>> to read and write to the local workstation, instead of the server 
>> when not
>> using MVClient.  I haven't heard of this separation being available in
>> Universe, other than using something like Accuterm, am I right? Or is 
>> there
>> an easy way to distinguish between writing to the local drive vs. the
>> server?  How has others handled this conversion issue?  Right now we're
>> planning on assigning each user a directory on the server to write 
>> to, does
>> anyone have any alternate ideas?
>>
>> Thanks for the help, I appreciate hearing your solutions.
>>
>> Thanks,
>> Curt
>> TRI-SYS Consulting
>>
>> u2-users@listserver.u2ug.org
>>
>> ___
>> U2-Users mailing list
>> U2-Users@listserver.u2ug.org
>> http://listserver.u2ug.org/mailman/listinfo/u2-users 
>
> ___

Re: [U2] UV and triggers

[JPB-U2UG]

If I remember correctly in Prime Information if you used a return in a 
subroutine it returned to the calling program but if you used a stop it 
stopped. I have also seen it happen in UV when running a program from Proc. 
I don't remember how it happened but after converting the program from stop 
to return I didn't have a problem with it anymore. After that happened I 
just started using returns all of the time when I built a new program.


Jerry

--
From: "Anthony W. Youngman" 
Sent: Sunday, July 19, 2009 10:29 AM
To: 
Subject: Re: [U2] UV and triggers

In message <4a63297f.2030...@comcast.net>, Charlie Noah 
 writes

John,

I can't believe you're recommending this. The only reason Universe treats 
a RETURN as a STOP in a top-level program is that Universe tries to be 
everything to everyone, forgiving mistakes and blunders, and trying to 
determine what the user really wanted, no matter how badly the code is 
written. In 1998, we converted from Universe to Jbase, and you can't 
imagine all the problems we had fixing bad Universe code that worked (sort 
of) so that it would work in a system that requires you to do things 
correctly. When coding and breaking rules, you have to consider that the 
code may be migrated someday. This is a case of "just because you can, 
doesn't mean you should".


I doubt that's the case ... STOP may mean stop, but RETURN means "go back 
one level". So RETURN makes perfect logical sense even in an outer 
"program"...


I'm not talking about using the strengths of your particular 
implementation even though they are unique to your implementation, just 
doing dumb things that will bite you (or your predecessor) down the road.


I put "program" in quotes in my last paragraph, because I'm not even sure 
all variants of BASIC accept the PROGRAM keyword! Certainly in my early 
days programming PI I never used it, and I *think* the reason I didn't was 
because it didn't exist in INFOBASIC. iirc it was added at the same time 
as the FUNCTION keyword.


So I wouldn't say "John is recommending you use return", I'd say "RETURN 
*always* works because subroutines should always end in a return, and at 
one time everything BASIC was a subroutine". Oh - and I think PROGRAM and 
SUBROUTINE are actually synonyms as far as the compiler is concerned :-)


Just my 2 cents worth.


And my tuppence.

Cheers,
Wol
--
Anthony W. Youngman 
'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The 
man

lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
Visit the MaVerick web-site -  Open Source 
Pick

___
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] which files have triggers

[jpb-u2ug]

All this talk about triggers and I just received the following from IBM.

7.  UniVerse: Flashes

Using fixtool to repair UniVerse dynamic file header corruption may result
in data loss at 10.3.0
http://www.ibm.com/support/docview.wss?uid=swg21376672&myns=swgimgmt&mynp=OC
SSCRY4&mync=E

At UniVerse 10.3, modifications made to the new.record contents in a trigger
subroutine are not applied when the WRITE completes.
http://www.ibm.com/support/docview.wss?uid=swg21392473&myns=swgimgmt&mynp=OC
SSCRY4&mync=E


Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Monday, July 13, 2009 3:43 PM
To: U2 Users List
Subject: Re: [U2] which files have triggers

Thanks, I found the article. That would make tracking triggers easier.

One thing however, in the routine, you have

notriggers = dcount(triggers,@fm)
for trigno = 1 to notriggers
   trigger = triggers(trigno)
   call @trigger(...,newid,newrec,oldid,oldrec,...)
next trigno

Just curious, since with this routine, you effectively can have a trigger
   run as many triggers as needed, but, what I see as a problem, is if the
   2nd trigger routine modifies NewREC, it will overwrite any modifications
   that the first trigger may have made to NewREC (assuming a BEFORE
trigger).

I guess you could assign a temp varible to oldrec, then for each iteration
   make oldrec = newrec, but then each successive trigger wouldn't have the
   original data to go by.

George

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Brian Leach
> Sent: Monday, July 13, 2009 3:24 PM
> To: 'U2 Users List'
> Subject: Re: [U2] which files have triggers
>
> Hi George
>
> I wrote about this in one of the back issues of Spectrum (you can
> download
> these from www.intl-spectrum.com).
>
> I use a master trigger that reads a list of sub-triggers based on the
> file
> name. Okay it's an extra read, but it's worth it: the list of sub-
> triggers
> (which have the same calling arguments) are all called using regular
> Call @
> syntax; and it allows you to swap in and out sub-triggers without
> having to
> drop the main trigger, log everyone off, and recreate it. Since I first
> wrote that for a 24x7x365 site, that wasn't an option.
>
> Also, because UniVerse caches subroutines in memory, it means that when
> you
> recompile any changes you want to change the name e.g. MySubTrigger.1,
> MySubTrigger.2 and so forth. Then change the name in the sub-trigger
> list(s)
> when you are sure you've tested it.
>
> Brian
>
___
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] General guidelines on indexing

[jpb-u2ug]

I have 2 RH Linux AS3 64bit servers one on a Dell 6800 with 4 processors and
16GB memory with UV 10.1.12 and 117 users. The other is a Dell 2500 with 2
processors and 16GB memory with UV 10.2.4 and 6 users. The first takes
0.1876 seconds and the second is 0.1106 seconds. The time varies with the
amount of activity and if I run them consecutively but I haven't had any
trouble with memory or going over 1 second.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Friday, July 10, 2009 4:15 AM
To: 'U2 Users List'
Subject: Re: [U2] General guidelines on indexing

Ok I am very jealous now of all these quick times, when my one crashed out 

Can someone remind me (its been years since i did any udt config stuff) what
should i be looking at to fix this error 


Thanks



PS - i like this thread i think this can be of benefit to people to fine
tune both code and their os and u2 configuration !



-Original Message-
From: Symeon Breen [mailto:syme...@gmail.com] 
Sent: 09 July 2009 14:04
To: 'U2 Users List'
Subject: RE: [U2] General guidelines on indexing

Unidata 7.1 (32bit) on redhat EL 3 64bit, on XEON E5335 with 4 gig ram.


Error when creating a shared memory segment (size=35682416), errno=22



Lol

Hmmm ?




-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ron Hutchings
Sent: 09 July 2009 13:40
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] General guidelines on indexing


IBM BOX (OLDER)
PICK.FORMAT
10.0.11
6.9377 seconds

Linux box
PICK.FORMAT
10.2.0
0.3522 seconds

> Date: Thu, 9 Jul 2009 11:20:25 +0800
> From: adrian.wom...@rac.com.au
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] General guidelines on indexing
> 
> 
> I just tried this example on Universe 10.2.6 - it took 0.0665 seconds -
> basically instant, can't complain about that.
>  
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin
> Phillips
> Sent: Thursday, 9 July 2009 12:59 AM
> To: U2 Users List
> Subject: Re: [U2] General guidelines on indexing
> 
> 
> By way of a simple expample, I just tried the following program...
>s = ''
>z = str('*', 1000)
>t1 = time()
>for i = 1 to 10
>   s<-1> = z
>next i
>t2 = time()
>crt t2 - t1
> 
> This took six seconds on QM but 32 minutes on UniVerse. 
> 
> 
> 
> 
> 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.
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users

_
HotmailR has ever-growing storage! Don't worry about storage limits. 
http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tutoria
l_Storage_062009
___
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

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

Re: [U2] General guidelines on indexing

[JPB-U2UG]

I tried it on my system UV 10.1.12 on Linux AS3 0.643 seconds.

--
From: "Martin Phillips" 
Sent: Thursday, July 09, 2009 3:38 AM
To: "U2 Users List" 
Subject: Re: [U2] General guidelines on indexing


Hi Adrian,


I just tried this example on Universe 10.2.6 - it took 0.0665
seconds basically instant, can't complain about that.


I am sure that something must have been wrong with your test. This 
probably isn't long enough to do even the empty loop with no string copy.


I have just repeated my test on a different system running UV 10.2.8 and 
the test took 38 minutes.



Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
+44-(0)1604-709200



___
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] General guidelines on indexing

[jpb-u2ug]

It's been a long time since I've been in hardware so I may be all off on
this, but, this could be possible because after it sends the WRITESEQ it's
basically up to the disk subsystem to actually do the writing. The written
sequential record get's put in the queue and the subsystem sends back a
signal that it's been done and to continue. However that doesn't necessarily
mean it has completed the write. By the time the process is done the
sequential file may not have completed writing all of the records in the
queue but the process will think it has. I know I have noticed this happen
when writing to a networked file system and it makes the file unusable until
the writing has completed.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marco Manyevere
Sent: Wednesday, July 08, 2009 10:44 AM
To: U2 Users List
Subject: Re: [U2] General guidelines on indexing


In one test I did a couple of months back, I found that appending IDs to the
end of a dynamic array perfomed _much_ _much_ slower than a WRITESEQ to the
end of a disk file and the dynamic array wasnt even a 100 000 records long.
We were able to reduce the time required to produce a report from over 30
minutes to less than 2 minutes by removing the dynamic array operations and
replacing them with WRITESEQs. We tried all the different syntaxes of
appending to the array with no noticeable difference in poor performance
once the array got large.



- Original Message 
From: "Baakkonen, Rodney A (Rod) 46K" 
To: U2 Users List 
Sent: Wednesday, 8 July, 2009 17:15:57
Subject: Re: [U2] General guidelines on indexing

In theory, I would have to agree with you.  Who knows how all this stuff
really works under the hood. You have Unidata Shared memory management
and shared basic code server. We also have a huge SAN with a lots of
cache. Measuring performance and impacting it is different these days.
There are so many layers  and events, finding the bottleneck can be
tricky.

All I can tell you is that we did extensive testing and we would not be
doing what we are unless it worked. Maybe on you site, on your server
and your database, these techniques don't enhance performance. I'm
telling you what we found, your mileage may vary.

We have been told to use concatenate with a @AM to build our arrays, as
Unidata has a pointer to the end of a variable. We have been told to use
REMOVE when pulling data out of the array. We know that. We still had
performance gains that went from days to hours when we changed to a well
sized work file.

There are many reasons why we use the work file. Typically this is used
in the selection part of the process. The sorting and reporting is
after. Sometimes the work file contains more than keys ( vs. having
multiple dynamic arrays). Sometimes multiple reports are generated from
the same work file.  

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Wednesday, July 08, 2009 6:47 AM
To: U2 Users List
Subject: Re: [U2] General guidelines on indexing

I don't agree. Disk access is inherently slower than RAM access.
Therefore a process that makes efficient use of RAM will be faster than
an equivalent algorithm making efficient use of disk.

In your case, it's just a matter of scale:

50 million records at (lets say) 14 bytes per ID plus the multivalue
marker needed to build up the dynamic array.

15 * 50,000,000 = 750,000,000 bytes.

That's 732,422KB,  715MB

If your process is running on a modern server then this kind of op
becomes practical.

Assumptions:
- that the dynamic array isn't using Unicode. If it is then memory
reqirements double.
- That you select every record - normally (presumably) it would be just
a fraction?


In fact isn't all of this theoretical? Using the index select / readfwd
/ own tests method, there's no need to build workfiles or dynamic arrays
at all - simply do the tests as each record is retrieved with readfwd
and then create the report / do the processing all within the same loop?

Ed



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen,
Rodney A (Rod) 46K
Sent: 08 July 2009 12:30
To: U2 Users List
Subject: Re: [U2] General guidelines on indexing


When you have a  file with 50 million records, it does not matter how
you build the or parse the dynamic array. A well sized work file will
run circles around the dynamic array. 



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Wednesday, July 08, 2009 6:12 AM
To: U2 Users List
Subject: Re: [U2] General guidelines on indexing

> After indexing, we made a lot more use of the SETINDEX and READFWD
logic
in our programs. 

I find this curious / disappointing - is it really the case that unidata

Re: [U2] Mixed Case UV Basic Programming Standards.

[jpb-u2ug]

Code in uppercase and mixed case for Comments, displayed messages/queries,
and error messages.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
Sent: Wednesday, June 24, 2009 1:39 PM
To: U2 Users List
Subject: [U2] Mixed Case UV Basic Programming Standards.

I don't like the way I use mixed case, so it tends to evolve.  Not good, 
because consistency in programming style throughout an application makes 
for easier maintenance, & maintainability is the god of software quality.

So I am wondering how others use mixed case.
Do you capitalize/lower/mix case for  commands? Operators? Variables? 
Equates? etc.
How do you use/not use special characters in variable names?

For example:
   readu OrderMaster from ORDER.MASTER, OrderMasterId locked ...
   readU OE_rec from OE_f, OE_id  locked ...
   ReadVU OE_Date From ORDER.MASTER, OE$Id,  OE$Date Locked ...
   READU order.master.rec( oe$date ) FROM order.master.file, 
order.master.id LOCKED ...
That sort of thing.

I hesitate to even ask this for fear of starting a war. So ground rules 
for this thread:

1. NOT about MERITS of Uppercase only vs. Mixed Case programming.
 I am only interested in answers from people who actually use mixed 
case.
2. NOT about GOTO.  Take it outside.
3. This is about PREFERENCE, NOT SUBSTANCE.
 By "substantive" I mean rules like:
- Only open a file once.
   - Readu should always have a locked clause.
 By "preference" I mean stuff like my example.  They are all 
functionally equivalent.
4. NO ARGUMENTS about whether someone's style is good or bad, or yours 
is better.
   Explaining why you do it a certain way is helpful, though.
   Just remember, when it comes to preferences, no two programmers 
will agree,
   yet consistent style, whate'er it be, increases maintainability.

Thanks,
Chuck Stevenson
___
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] I Descriptor for long filename in type 1 file

[jpb-u2ug]

Create a type 19 file and redirect the logs to the new file. &UFD& is a bad
place to store these types of files anyway because it is the account
directory. When yo go to clean up the file you may accidently remove part of
your account.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: Tuesday, June 23, 2009 8:55 AM
To: U2 Users List
Subject: Re: [U2] I Descriptor for long filename in type 1 file

Why not just resize &UFD& to a type 19?

Norman, David (Health) wrote:
> UV 10.2.16 HP-UX 11i
> &UFD& is a type 1 file by default. I have some files in &UFD& with long
filenames that go down 1 level. I have created an I-type to extract
delimited fields within the @ID which either spans the 2 levels, or is
wholly in the 2nd level.
> Using this I-type to display in a LIST works perfectly. However, as soon
as a WITH references this field, nothing is returned. E.g.:
>
> LIST &UFD& WITH @ID LIKE ...as... SAMPLE 5 DATE2 11:10:14  23-06-09  PAGE
1
> OS filename...DATE
> LOG.as13713_15125_49176   29.05.09
> LOG.as13713_15125_58659   29.05.09
> LOG.as13713_15125_59104   29.05.09
> LOG.as13713_15125_59132   29.05.09
> LOG.as13713_15125_60631   29.05.09
>
> Sample of 5 records listed.
>
>
> ::LIST &UFD& WITH DATE2 = 29.5.09
> 0 records listed.
>
> The DICT of DATE2 is:
> 0001: I
> 0002: FIELD(@ID,'_',2)
> 0003: D2.
> 0004: DATE
> 0005: 8R
> 0006: S
>
> I don't want to resize &UFD& to type 19 on this mission-critical 24x7
system - how else can I get WITH to use these fields ???
>
> 
> David Norman
> Senior Software Engineer - SA Ambulance Service
>
> ICT Services
> SA Health
> Government of South Australia
>
> Box 3, GPO
> Adelaide, South Australia 5001
> *+61 8 8274 0384
> * fax +61 8 8271 4844
> * norman.da...@saambulance.com.au
>
>
> This e-mail may contain confidential information, which also may be
legally privileged. Only the intended recipient(s) may access, use,
distribute or copy this e-mail. If this e-mail is received in error, please
inform the sender by return e-mail and delete the original. If there are
doubts about the validity of this message, please contact the sender by
telephone. It is the recipient's responsibility to check the e-mail and any
attached files for viruses.
>
>
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>   

-- 

Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com

___
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] [UV] Currently preferred Linux distro

[jpb-u2ug]

This won't be a problem if you use uvbackup and uvrestore. Otherwise you
will have to do a fnuxi. If you've been testing with fedora then your best
bet would be RH Linux. It's supported and a fairly good track record.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow
Sent: Tuesday, June 16, 2009 7:46 AM
To: U2 Users List
Subject: Re: [U2] [UV] Currently preferred Linux distro

When you convert your data, be aware of the "endian-ness" of the two 
platforms.  AIX to x86 will require a conversion.


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

Re: [U2] UniVerse Unit Testing

[jpb-u2ug]

Doug and Brian,

Could you give me some numbers on how long and how many people (man hours)
it took to do the changes? Approximately how many programs did you have to
convert to the new way and what did you end up with?

 

Jerry Banker

 

From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
Sent: Thursday, June 11, 2009 7:55 AM
To: U2 Users List
Subject: Re: [U2] UniVerse Unit Testing

 

Brian,

 

You say that you "designed all our server code as subroutines such that all
of our subroutines had one of two calling interfaces".  This would seem to
mean that you built and maintained two different versions of every external
subroutine/function.  Is this correct or am I just missing something?

 

Thanks.

 

Perry

 

  _  

From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Thursday, June 11, 2009 3:19 AM
To: 'U2 Users List'
Subject: Re: [U2] UniVerse Unit Testing

Hi

 

 

At my last company, we spent a lot of effort on building an automated test
rig for our software, because we had to support multiple platforms and all
our code required full regression testing. It may be a slightly different
scenario to yours, since we were primarily building tools, and also this was
complicated by the fact that all of our software was client/server in some
way, and usually involved several languages .. but here is our experience
for what it's worth:

 

 

The bad news is that you really need to design these in from the start.

 

We designed all our server code as subroutines such that all of our
subroutines had one of two calling interfaces, either:

 

Subroutine name(InData, OutData, ErrText)

 

or

 

Subroutine name(Action, InData, OutData, ErrText)

 

That meant that we could generate a test rig that could feed the InData (and
Action) and then test for the OutData and log any ErrText values.

For reports, we would capture the report text and do 'spot checks' on the
expected results.

 

 

We also version stamped our routines, so we were certain we were testing the
right versions, and had build scripts to recompile everything. Nothing left
to manual operation since that opens up the opportunity for something to get
forgotten: there is no point testing stuff to QA and then doing something
different when you come to release! Incidentally, since this was
client/server, these involved VBScript scripts for the client end calling
cutting paragraphs on the server along the line.

 

 

Because Universe code doesn't break down into simple blocks, unless you want
to instrument your code and capture all your file I/O - which is possible -
and test for that, your only sensible option is to unit test at the
subroutine/external function level.

 

 

The good news is that because UniVerse caches subroutines in memory, the
overheads to breaking out code are not as high as on systems that do not. it
also means you end up with a more manageable system, better options for
reuse and if you adopt different client front ends, easier to migrate. You
may also find out that your code mass reduces as you split these out,
because there is less duplication (sorry if I'm stating the obvious here)
and so your testing domain is reduced also.

 

 

If you want clean-room regression testing, I highly recommend Virtual PC is
it will support your OS. We kept clean images of all the platforms we
supported, which was a huge time saver. One nice thing about VPC is that it
supports 'undo disks' which means that you can snapshot the image at a
particular point, and then any changes e.g. brought on by software loads for
testing are physically and transparently stored outside the virtual disk and
you choose at the end whether to commit those changes or not, making it very
easy to go back if that version didn't pass.

 

 

Finallly, having a predictable way to load routines from dev to QA and from
QA to live is a must - so I'll put in a very small [AD] for mvInstaller...

 

Regards

 

Brian

 

 

 

  _  

From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
Sent: 10 June 2009 20:33
To: u2-users@listserver.u2ug.org
Subject: [U2] UniVerse Unit Testing

The powers that be have been discussing the possibility of going to a unit
test model for QA.  As I understand the concept, portions of code are broken
down into smaller manageable chunks against which a dedicated unit test for
each may be run.  This seems like a good idea in an object oriented world
where methods of object can be easily invoked.  This would seem less
practical in with a procedural language like BASIC.

It feels like we would end up breaking out thousands of lines of code into
external subroutines which could then be run through a dedicated unit test.
This would introduce significant overhead with all the CALLs to hundreds
(thousands) of external subroutines.  Then there are complica

Re: [U2] [u2u] UV on Windows question

[jpb-u2ug]

I just rebooted my Linux systems last week the first time in about 6 months.
The reason, because the windows servers on our network have been changed so
many times that they were finally starting to affect Samba on the Linux
server. I couldn't just change the IP addresses anymore and restart Samba, I
actually had to reboot the system. I have had the system up so long that I
got a message like Lee's but I try to reboot at least once a year just so
the heads don't weld themselves to the disk surface if I do have to bring
them down for some reason. I don't think we have ever had a windows server
stay up more than a week so I think you are either lucky or you very seldom
install a patch on your server.

 

Jerry Banker

 

From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Tuesday, June 02, 2009 9:04 AM
To: 'Lee Bacall'; 'U2 Users List'
Subject: Re: [U2] [u2u] UV on Windows question

 

My main web server running windows server 2003 was last rebooted Feb 2008 ! 

 

I think people when you say windows think about their own experience of
their desktop whereas when it is on a server the whole usage is very
different, that is what i am trying to get across !

 

 

Having said all this yes i would prefer linux just because of its ease of
tuning using the shell and text based config files is much easier than say a
gui and the registry.

 

 

 

From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lee Bacall
Sent: 02 June 2009 14:14
To: U2 Users List
Subject: Re: [U2] [u2u] UV on Windows question

 

Right on Jerry.

We recently experienced a violent lightning storm here in South Florida.

While we have a backup generator and multiple UPS systems, transient
protection, etc.,

we thought it prudent to bring down some systems, do some spring-cleaning
and vacuum 

out the dust bunnies and cat fur from the fans and filters.

 

When bringing up one of the SUSE Linux servers, running uniVerse, I was
greeted with the message:

System has gone 220 days without a shutdown.

 

To quote Jerry, 

"Can you say the same about Windows?"

 

 

Lee Bacall

http://www.binarystar.com

 

 

 

 

- Original Message - 

From: jpb-u2ug <mailto:jpb-u...@hotmail.com>  

To: 'U2 <mailto:u2-users@listserver.u2ug.org>  Users List' 

Sent: Tuesday, June 02, 2009 8:58 AM

Subject: Re: [U2] [u2u] UV on Windows question

 

Let's see now. I have been working on Unix type systems for 30 years and
never had an anti-virus program running on any of them. Can you say the same
about Windows? In that time only one of them got hacked. Can you say the
same about Windows? I can go on if you wish.

 

Jerry Banker

 

 

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

Re: [U2] [u2u] UV on Windows question

[jpb-u2ug]

I really didn't want the question of the differences in administration of
Universe to turn into a Unix vs Windows battle. 

 

Jerry Banker

 

Ps: However if you want to then "bring it on".:-) On the community list.

 

From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Tuesday, June 02, 2009 3:07 AM
To: 'U2 Users List'
Subject: Re: [U2] [u2u] UV on Windows question

 

"It is the rated by the experts as the best of the systems,"

 

What experts ?

 

"The first reason is that Unix systems are not susceptible by Windows
viruses."

 

A protected windows server would not be either - we are not talking desktops
here with users surfing the internet all day.

 

 

 

 

 

 

 

From: Dave R [mailto:dave.ra...@juno.com] 
Sent: Monday, June 01, 2009 3:54 PM
To: jpb-u...@hotmail.com
Subject: Re: [u2u] UV on Windows question

 

Unix has it's own set of administration tools different the windows
administration tools, I don't believe they require about the same knowledge
to use, if you are a windows engineer you would like a windows platform and
if you are a Unix engineer you would prefer Unix.

Even thought I use a Windows platform I prefer Unix systems as a platform
for a Multi-Value system.  If you want to purchase a new system then I would
go to Reality (contact Northgate-IS, John Semen or Mark Pick). It is the
rated by the experts as the best of the systems, Unidata would be next, and
UniVerse would be 3rd.  

The first reason is that Unix systems are not susceptible by Windows
viruses.  The second reason is security, Most windows hackers are complete
lost in UNIX.  The Unix systems are more robust.  The file management is
improved in Unix and 

The Unix OS was designed for multi users and by mainframe software engineers
who have a far more knowledge of multi user environments.  

Most companies hire windows network engineers and they don't like the idea
of Unix platforms. However most large companies run Unix or Aix or Hpux for
the platform for Reality or U2.

Some other considerations would be if you are coming from a different
Multi-Value package like Pick D2 or mvBase, Reality and UniVerse have
switches to creating an environment to run that flavor of Multi-Value,
requiring little to no conversion of the software and database.  A big cost
factor in the conversion.

 




Dave R. 949 757 8519 (work) 

eFax (815)4259364

-- Original Message --
From: "JPB-U2UG" 
To: 
Subject: [u2u] UV on Windows question
Date: Sat, 30 May 2009 16:00:37 -0500

I've never worked with UV on Windows so I would like to know, apart from the
obvious differences of the operating system, is there much difference in
administering the database in Windows as compared to Linux/Unix.



 
Criminal Lawyers - Click here.
<http://thirdpartyoffers.juno.com/TGL2142/fc/BLSrjpTOVoK8MNQ2jcygQ1UHaGxeSYz
U7qCu4EnncAfGU1lK5Ikr5JJDuhy/> 

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

Re: [U2] [u2u] UV on Windows question

[jpb-u2ug]

Let's see now. I have been working on Unix type systems for 30 years and
never had an anti-virus program running on any of them. Can you say the same
about Windows? In that time only one of them got hacked. Can you say the
same about Windows? I can go on if you wish.

 

Jerry Banker

 

From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Tuesday, June 02, 2009 3:07 AM
To: 'U2 Users List'
Subject: Re: [U2] [u2u] UV on Windows question

 

"It is the rated by the experts as the best of the systems,"

 

What experts ?

 

"The first reason is that Unix systems are not susceptible by Windows
viruses."

 

A protected windows server would not be either - we are not talking desktops
here with users surfing the internet all day.

 

 

 

 

 

 

 

From: Dave R [mailto:dave.ra...@juno.com] 
Sent: Monday, June 01, 2009 3:54 PM
To: jpb-u...@hotmail.com
Subject: Re: [u2u] UV on Windows question

 

Unix has it's own set of administration tools different the windows
administration tools, I don't believe they require about the same knowledge
to use, if you are a windows engineer you would like a windows platform and
if you are a Unix engineer you would prefer Unix.

Even thought I use a Windows platform I prefer Unix systems as a platform
for a Multi-Value system.  If you want to purchase a new system then I would
go to Reality (contact Northgate-IS, John Semen or Mark Pick). It is the
rated by the experts as the best of the systems, Unidata would be next, and
UniVerse would be 3rd.  

The first reason is that Unix systems are not susceptible by Windows
viruses.  The second reason is security, Most windows hackers are complete
lost in UNIX.  The Unix systems are more robust.  The file management is
improved in Unix and 

The Unix OS was designed for multi users and by mainframe software engineers
who have a far more knowledge of multi user environments.  

Most companies hire windows network engineers and they don't like the idea
of Unix platforms. However most large companies run Unix or Aix or Hpux for
the platform for Reality or U2.

Some other considerations would be if you are coming from a different
Multi-Value package like Pick D2 or mvBase, Reality and UniVerse have
switches to creating an environment to run that flavor of Multi-Value,
requiring little to no conversion of the software and database.  A big cost
factor in the conversion.

 




Dave R. 949 757 8519 (work) 

eFax (815)4259364

-- Original Message --
From: "JPB-U2UG" 
To: 
Subject: [u2u] UV on Windows question
Date: Sat, 30 May 2009 16:00:37 -0500

I've never worked with UV on Windows so I would like to know, apart from the
obvious differences of the operating system, is there much difference in
administering the database in Windows as compared to Linux/Unix.



 
Criminal Lawyers - Click here.
<http://thirdpartyoffers.juno.com/TGL2142/fc/BLSrjpTOVoK8MNQ2jcygQ1UHaGxeSYz
U7qCu4EnncAfGU1lK5Ikr5JJDuhy/> 

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

Re: [U2] [u2u] UV on Windows question

[jpb-u2ug]

How interesting, you can't just reply to the email anymore, you have to
change the to address.

 

Jerry Banker

 

From: Dave R [mailto:dave.ra...@juno.com] 
Sent: Monday, June 01, 2009 3:54 PM
To: jpb-u...@hotmail.com
Subject: Re: [u2u] UV on Windows question

 

Unix has it's own set of administration tools different the windows
administration tools, I don't believe they require about the same knowledge
to use, if you are a windows engineer you would like a windows platform and
if you are a Unix engineer you would prefer Unix.

Even thought I use a Windows platform I prefer Unix systems as a platform
for a Multi-Value system.  If you want to purchase a new system then I would
go to Reality (contact Northgate-IS, John Semen or Mark Pick). It is the
rated by the experts as the best of the systems, Unidata would be next, and
UniVerse would be 3rd.  

The first reason is that Unix systems are not susceptible by Windows
viruses.  The second reason is security, Most windows hackers are complete
lost in UNIX.  The Unix systems are more robust.  The file management is
improved in Unix and 

The Unix OS was designed for multi users and by mainframe software engineers
who have a far more knowledge of multi user environments.  

Most companies hire windows network engineers and they don't like the idea
of Unix platforms. However most large companies run Unix or Aix or Hpux for
the platform for Reality or U2.

Some other considerations would be if you are coming from a different
Multi-Value package like Pick D2 or mvBase, Reality and UniVerse have
switches to creating an environment to run that flavor of Multi-Value,
requiring little to no conversion of the software and database.  A big cost
factor in the conversion.

 




Dave R. 949 757 8519 (work) 

eFax (815)4259364

-- Original Message --
From: "JPB-U2UG" 
To: 
Subject: [u2u] UV on Windows question
Date: Sat, 30 May 2009 16:00:37 -0500

I've never worked with UV on Windows so I would like to know, apart from the
obvious differences of the operating system, is there much difference in
administering the database in Windows as compared to Linux/Unix.



 
Criminal Lawyers - Click here.
<http://thirdpartyoffers.juno.com/TGL2142/fc/BLSrjpTOVoK8MNQ2jcygQ1UHaGxeSYz
U7qCu4EnncAfGU1lK5Ikr5JJDuhy/> 

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

[u2u] UV on Windows question

[JPB-U2UG]

I've never worked with UV on Windows so I would like to know, apart from the
obvious differences of the operating system, is there much difference in
administering the database in Windows as compared to Linux/Unix.

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

RE: [U2] Best algorithm for UV part files

[jpb-u2ug]

We use one part file made up of 13 different files. The record key makes it
easy for us because they are all numeric. We just made the algorithm
MOD(key,13) + 1. The reason for 13, it's a prime number and the number of
records per file seem to come out about equal. Of course we don't have a
special purpose for each part file it's just to reduce the size of the file.
The set of files contains 2.3 million records but each part has less than
180 thousand.

Jerry Banker

-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Thursday, May 28, 2009 11:16 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Best algorithm for UV part files

Hi Baker

Unless I misunderstand the question - it don't work like that :)

UniVerse uses the partitioning algorithm to determine which part file the
record goes into, based on some operation performed on the key that must
yield as its result a valid part file number. So you could, for example,
perform a hashing algorithm on the key by multiplying the seq() of each
character together and divide the whole lot by the number of parts to get a
modulus - just like the addressing inside a hashed file...

Once that algorithm is in place, every time you request a key it will
perform the same operation to determine in which part file it will find the
record.

So you don't need to specify the part file number along with the key - the
key determines the part file.

Regards

Brian

 

> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org 
> [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Baker Hughes
> Sent: 28 May 2009 16:06
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Best algorithm for UV part files
> 
> Very helpful Stuart (and Brian) thanks.
> 
> 1 follow-up question: given your algorithm below, when you 
> edit or copy those records over, what does the key look like. 
>  E.g. do you have to prefix the key generated by your 
> algorithm, with the part file number or name?  To edit the 
> record would you simply:
> 
> AE HAIRY.PF.NAME B123456
> 
> Or
> 
> AE HAIRY.PF.NAME 23-B123456  ?
> 
> 74 & Clear regards from Ft Worth,
> -Baker
---
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] SELECT from PHANTOM

[jpb-u2ug]

I don't know about Unidata but Universe phantoms run as the person that
kicked them off.

Jerry Banker

-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of
charles_shaf...@ntn-bower.com
Sent: Friday, May 15, 2009 8:19 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] SELECT from PHANTOM

We are using Unidata 7.1 on RedHat and are testing a new system.  A 
barcoding system drops transactions into a UNIX directory and a batch 
processor running in background (PHANTOM) periodically checks the 
directory to see if there are any transactions to process.  Transactions 
are making it to the directory OK.  And when you select the file at ECL it 
selects the transactions, but when the batch processor selects the file, 
it selects no records.

I guess I suspect an issue with the user that the PHANTOM process is 
running as.  Who is that?  The user that started the PHANTOM?  Or the 
system?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
---
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] Help with encryption

[jpb-u2ug]

Charles,
If you have Outlook you have to use the out of office assistant on the tools
menu. You can make it so no message goes to the list.

Jerry Banker

-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of
charles_shaf...@ntn-bower.com
Sent: Tuesday, May 12, 2009 3:38 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Help with encryption

Hello,

This is to the moderator.  I will be going on vacation next week for two 
weeks and will set my out of office message before I go.  How do I stop 
from sending these messages to the list and how do I reenable the list 
when I get back.


Charles Shaffer
Senior Analyst
NTN-Bower Corporation
---
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] Employment disaster

[jpb-u2ug]

I wouldn't say that too loudly there's a lot of potential employers on this
list. Most smart companies like to have someone that is willing to stick
around long enough to learn their business logic.

Jerry Banker

-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
Sent: Wednesday, April 22, 2009 5:54 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UV to SAP migration disaster

jpb-u2ug wrote:
> 
> Oh and one of these days you are going to be sitting in the same seat
> talking about the good old days too, and someone is going to be telling
you
> that you're a dinosaur. It's not easy trying to keep up with the
technology
> and if your company isn't using it you tend to gravitate toward what they
do
> use.
>
> Jerry Banker
>   
Not me Jerry, I usually don't stay long enough for that to happen.
If there's nothing new to learn I move on.
---
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 to SAP migration disaster

[jpb-u2ug]

I resemble that remark. Actually what I was trying to get at was the
education and marketing factors. I'm not trying to slam MS or any other
operating system. I think that all technology should be used for what it is
good at. The right technology for the right task. I just think that the
education these new programmers are getting has no depth. They're not being
told that what they are being taught may not be what they will encounter in
the business world.
A case in point is the new thread that just started with the subject:

[U2] Getting a graphical view of my data in UniVerse

Oh and one of these days you are going to be sitting in the same seat
talking about the good old days too, and someone is going to be telling you
that you're a dinosaur. It's not easy trying to keep up with the technology
and if your company isn't using it you tend to gravitate toward what they do
use.

Jerry Banker


-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
Sent: Monday, April 20, 2009 2:23 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UV to SAP migration disaster

I second that.

And don't forget those people who have been in the same company and the 
same office for over 20 years and still reminisce about the 'good old 
mainframe days'.
The first thing a new guy hears is, 'We don't like change here!'
Upgrading? Don't fix it if it ain't broke!
If you get a request, tell the requester that this is very difficult to 
do and could have all sorts of implications for the rest of the system.
Or even better, 'we can't make any changes because then we can't upgrade 
the software later, and therefore only the software vendor can make 
changes to the code.'
And of course at #1000 a day for their consultants it better be important.
If he or she still wants it, ignore it until they ask again.
If they don't, it obviously wasn't important enough anyway.
Users will find a way to solve their problems without IT, and in no time 
the whole business runs on spreadsheets because the stupid 'legacy' 
software is useless anyway.
And who's fault is that?

And then you get stupid software vendors who want to sell only their 
latest web-based, platform independent software product and tell 
management they will stop support for that old product soon and 
therefore they should rather not upgrade and buy their latest toy.

Or of course the old IT-manager retires and they hire a follower of the 
Church of Codd as replacement.

I've been around and seen it all.
It isn't always a PHB.

Symeon Breen wrote:
> There can also be blame at the coalface as well - I know many "pick" guys
> who really are dinosaurs and who bury their head in the sand if xml, web
> services, web access etc are mentioned ...
>
>
>
>
> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org
> [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Glenn Sallis
> Sent: 20 April 2009 14:48
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] UV to SAP migration disaster
>
> It's yet another story that makes people who know and understand the
> multivalue database model cringe. Often one of the reasons for migrating
> seems to be due to decisions being made upstairs by people who have not
> bothered to consult the people with the knowledge to inform of the
> technical realities and work involved in such a major change. 
>
> I have noticed over the years that SAP has been very heavily marketed.
> There is usually a reason for a product needing to be advertised ;-).
> Just because a product has massive marketing muscle behind it doesn't
> mean it's the bee's knees. I'm sure this story won't be the last
> expensive disaster!
>
> Glenn Sallis
> Software Developer
> Flextronics Logistics B.V
> ---
> 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 to SAP migration disaster

[jpb-u2ug]

In our particular case the IS Manager, who was a Pick programmer retired.

Jerry Banker


-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Rex Gozar
Sent: Monday, April 20, 2009 9:21 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UV to SAP migration disaster

I guess the basic premise of your argument is that the PHB's are 
listening to 90-day-wonder windows programmers, and they encouraged said 
PHB's that they needed to replace the UV database.

I don't buy it.

Even PHB's don't go spending millions of dollars on SAP just because 
their 25 year old windows programmers don't think UV is productive.

In the case of Shane Co. the PHB's decided to spend millions of dollars 
-- and no one bothered to do an ROI study?  Or it was fabricated by a 
bunch of idiots without any concept of reality?

At some point, Shane Co. must have been doing good.  They were 
expanding.  It seems a short time ago I heard they opened a new store 
here in Orlando, FL.  (Or maybe they weren't doing that good after all 
and the expansion was a feeble attempt at opening new markets to 
generate revenue.)

During this expansion, one of the PHB's must have said "we AREN'T 
getting what we need from IT; let's look into other solutions".  Or 
maybe they said, "we CAN'T get what we need".  (The former speaking to 
an unwillingness to address needs; the latter, lacking capability to do so.)

And this brings me back to my original question: what was Shane Co.'s 
REAL reason for deciding to migrate away from UV?  If Universe is 
supposed to be a superior environment for building and deploying 
business solutions, why couldn't their existing IT staff deliver?  Why?

It's too easy to characterize management decisions like this as 
"frivolous" or "political".  But it's irresponsible to ignore the true 
business reasons behind these decisions, dooming ourselves to repeat 
history's mistakes.

rex

JPB-U2UG wrote:
> I can't speak for everyone but if it's anything like at our place, it's 
> due to lack of education. UniVerse is contains all of our business logic 
> and Microsoft is used for our presentation layer, desktop and web. We 
> have 3 programmers working on UniVerse with an average age of 55. In our 
> windows area we have 10 programmers with an average age of 25. Most of 
> the people coming out of the colleges and universities only know one 
> platform Microsoft. They are taught nothing...
---
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 to SAP migration disaster

[JPB-U2UG]

I can't speak for everyone but if it's anything like at our place, it's due 
to lack of education. UniVerse is contains all of our business logic and 
Microsoft is used for our presentation layer, desktop and web. We have 3 
programmers working on UniVerse with an average age of 55. In our windows 
area we have 10 programmers with an average age of 25. Most of the people 
coming out of the colleges and universities only know one platform 
Microsoft. They are taught nothing about processing data, database 
structure, proper logic, or problem solving. They are not even being taught 
Unix anymore. I think the colleges are doing their students a disservice 
because most businesses are still running other platforms for their business 
logic and only have windows as the presentation layer. This causes a problem 
because when the business wants to hire someone they don't have anything 
except these 90 day wonders to choose from. The candidate has problems 
because they have never been taught how to use anything other than the 
windows tools. This isn't exclusive to U2, it's a problem with any of the 
proprietary operating systems/products and anything on Unix/Linux. This 
gives the PHB's the mistaken impression that anything not windows is 
obsolete and they should scrap what they have and go towards all MS or 
anything else that looks pretty. The new programmers are more than happy to 
get on board with the idea because most of them want to be working in what 
they are taught. They don't know what business logic is and they think it 
would be a walk in the park to switch. After all they were able to build 
that web page, right? They, of course, forget that the data had to be there 
before they could present it. The PHB's find that there is a bigger pool of 
willing low cost employees to choose from and force all of their people that 
actually know the business logic off the payroll. Then the nail is in the 
coffin. The new programmers all of a sudden discover that there is something 
happening in the background that they were not aware of, they try to 
reproduce it but nothing seems to work the same as it use to. Pride takes 
over and nobody wants to admit that they may have made a mistake. They don't 
notify the PHB's that there is a problem, they start panicking, they don't 
want to rehire the employees they got rid of, so they hire some consultants 
that don't know the business logic any more than the people that are there. 
It's not the consultants fault they were expecting that someone at the 
company knew something about how the company operates. By the time all of 
the problems come to light the company is on the brink of bankruptcy. Where 
does the blame go, the people that left were at fault for not giving the 
youngsters all of the information they needed.


--
From: "Rex Gozar" 
Sent: Friday, April 17, 2009 4:38 PM
To: 
Subject: Re: [U2] UV to SAP migration disaster

I've been wondering why the Shane Co. felt the need to migrate away from 
UV.


* Was their IT staff unable to meet business requirements due to the 
limitations of UV?


* Was their IT staff to blame, rather than the UV database environment? 
(i.e. understaffed, lack of skills, etc.)


At any rate, it appears that either (or both) caused Shane Co. management 
to look for a different solution.  Under the assumption "if it ain't 
broke, don't fix it" I would think that management thought something was 
broken, and they needed to spend money to fix it.


Does anyone have any first-hand knowledge of the specifics?  Anyone care 
to share their insights?


rex

John Hester wrote:

There were a few posts back in January about Denver jewelry retailer
Shane Co. and their disastrous migration from UV to SAP.  Today they're
starring in an eWeek slideshow about I.T. disasters:

---
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] Select Problem

[jpb-u2ug]

It's using it like matching.

Jerry Banker

-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Tuesday, April 14, 2009 11:07 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] Select Problem

I have just encountered an inconsistency between the native UniData select
and the PICK flavored select.

>From a PICK flavored account, it I use the lower case "sselect" to force
native UniData syntax, I get:
  sselect ITMMST WITH F2 LIKE "...J1A..." (6,213 keys - wrong)
If I immediately follow this with the PICK select:
  SELECT ITMMST WITH F2 = "[J1A]" (No keys - correct)

These two statements SHOULD return the same results.  Interestingly, if I
use a less restrictive select (search for J1 instead of J1A), I get the
following:
  sselect ITMMST WITH F2 LIKE "...J1..." (188 keys which is correct)

I am guessing that the UniData flavor is treating the J1A as something else,
but until I can figure out what it is doing, I can not come up with a
work-around.



John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH  45342
---
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] HP, Cron, Como, Execute, Capturing . Not

[jpb-u2ug]

We do it all of the time with no problem. UV 10.1.12 on RH Linux AS 3.

Jerry Banker


-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Tony G
Sent: Monday, February 23, 2009 9:37 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UV] HP, Cron, Como, Execute, Capturing . Not

We have a client on UV/HP-UX running a BASIC routine from a Cron
job.  The BASIC code shells out from EXECUTE and Captures data
from the OS.  The Capture is failing and it looks like COMO gets
the StdOut that should be directed into a variable.

I'm not sure yet if Como plays any part or if all
Execute/Capturing instructions will fail when executed from Cron.
The code works fine from TCL.  I'm also checking to see if there
are any other options or middleware, and exactly what's being
executed in the Cron line.

Until I get more info though, I'd like to know if this is a
recognized issue.  Under what conditions can we expect something
like this to fail?:
  Execute "sh -c ... " Capturing result

Thanks.

Tony Gravagno
Nebula Research and Development
Info@ removeNebula-RnD.com
(Various other email addresses are currently down ... it's
Monday...)
---
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] Unidata to Oracle

[jpb-u2ug]

I'm sure we would all like to see how that turns out as well.

Jerry Banker


-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jeff Ritchie
Sent: Thursday, February 19, 2009 4:21 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Leaving U2 World to the Dark Side (SQL)

Good luck Don, actually finding MSSQL pretty easy to use in a web
application
I am helping to develop. Excellent integration with MS's Visual Web
Developer.

If it makes you feel any better I am currently involved in a project to move
a long term Unidata db to Oracle. 

Cheers,
Jeff

-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Don Verhagen
Sent: Thursday, 19 February 2009 10:04 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Leaving U2 World to the Dark Side (SQL)

To those that know me on this group. I have been using the Unidata databases
since 1998 when introduced to it by my former CIO. Over the years and
throughout my IT career, it has served me well. Decreasing software
production and maintenance costs, while at the same time increasing the
value of the software I (we) developed to solve complex business solutions.

I have accepted an Application Development management position with a
company here in the Philadelphia area. However, they are not a U2 shop.  I
view this opportunity as a chance to build my skills in and around the .NET
platform and evaluate the use MSSQL in a true business application that I
myself have built on a U2 platform in a previous time.

While this doesn't exclusively rule out U2 in the future, for now, I'll be
in SQL-land.

Just wanted give a heads up to those that know me here.

Don Verhagen
Application Development Manager
People 2.0
www.people20.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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Need help with SELECT limiting MV

[jpb-u2ug]

In this statement:

LIST TAB WITH F2 = "A" WHEN F2="B" AND F3="" F1 F2 F3

There is an implied "OR" before the "WHEN" so the statement actually is

LIST TAB WITH F2 = "A" or WHEN F2="B" AND F3="" F1 F2 F3
 
An OR will break the statement in two making the results in the list either
what is on the left side OR what is on the right side. In other words:

LIST TAB WITH F2 = "A" OR WHEN (F2="B" AND F3="") F1 F2 F3

Jerry Banker


-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Larry Hiscock
Sent: Wednesday, February 18, 2009 11:59 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Need help with SELECT limiting MV

Ummm ... you can when Status is a multivalued field, which was described in
the original post.

Larry Hiscock
Western Computer Services


-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Eric Armstrong
Sent: Wednesday, February 18, 2009 8:10 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Need help with SELECT limiting MV

Noah,
Try SELECT TAB WITH (STATUS = "A" OR STATUS = "B") AND ST_DATE = ""

You can' have status equaling A and B at the same time!

Eric Armstrong
IBM Certified Solutions Expert- U2 Family Application Development
Software Applications Developer/Analyst
Lobel Financial


-Original Message-
From: Noah Hart [mailto:n...@lipmantpa.com]
Sent: Tuesday, February 17, 2009 10:27 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Need help with SELECT limiting MV


I have a table with a MV status code and date field.

I am trying to select just those records that have both status code A
and B and when the date associated with code B is blank

I tried

SELECT TAB WITH STATUS = "A" AND STATUS = "B" AND ST_DATE = ""

But this will select records which might have a blank date for status
"C"


I see the data properly with a LIST WHEN command, but I want the
matching @IDs in a list

LIST TAB WITH F2 = "A" WHEN F2="B" AND F3="" F1 F2 F3

There must be a simple way to do this, but I'm just not getting it.

Ideas?

Thanks,

Noah




CONFIDENTIALITY NOTICE:
This message may contain confidential and/or privileged information. If you
are not the addressee or authorized to receive this for the addressee, you
must not use, copy, disclose, or take any action based on this message or
any
information herein. If you have received this message in error, please
advise
the sender immediately by reply e-mail and delete this message. Thank you
for
your cooperation.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

LOBEL FINANCIAL PRIVACY NOTICE: 
This communication may contain confidential company information that is
protected by federal law. Federal regulations prohibit the disclosure (or
re-disclosure) of confidential information without the written consent of
the person(s) to whom it pertains. Additionally, the views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.
---
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] POSTED ON BEHALF OF NONMEMBER: SB+ Error Message

[JPB-U2UG]

My first guess would be, since you are printing to the &HOLD& file (which is 
a directory type) is that your disk is getting full of temporary files. The 
second is that there is a record already in the file and the permissions are 
such that you can't write over it.


--
From: "Kevin King" 
Sent: Friday, January 16, 2009 10:52 PM
To: 
Subject: [U2] POSTED ON BEHALF OF NONMEMBER: SB+ Error Message


We are running a weekly batch process that runs multiple streams via
phantoms simultaneously.   The process consists of a mixture of SB+
processes, paragraphs, report writer reports & BASIC programs.   No 
changes
have been made to the particular area of the process for quite some time, 
&

all of a sudden, we have started having it crash with the following error
message:-

Program "SH.PRINT.MANAGER": Line 846, Queuing disabled for requested
printer.

Once the stream is manually restarted (by rerunning the process that
crashes), it continues through to the end without any problems, & never
crashes a second time.   The same weekly batch process is run on 2 other
live, & several other test systems with no problems.   Can anyone tell us
exactly what this line is trying to do, & what the problem could be?

- Could it be anything to do with DMSECURITY, as the phantom "logs on" to 
a
specific SB+ Account to perform its tasks ?  None of the reports in the 
area

where the crash occurs actually print - they all go to &HOLD&.   We are
running on SB+ 5.4 & UV 10.2 on Solaris (all systems).   No changes have
been made to any printers or setups recently either.   None of the 
programs
actually call SH.PRINT.MANAGER, so it must be being called from 1 of our 
SB+

report writer reports.   Any ideas anyone ???

MARY
---
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] Batch conversion of 32bit files to 64bit

[jpb-u2ug]

I believe you can do this by using the uvbackup and uvrestore utilities.

Jerry Banker

-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Arnold Bosch
Sent: Tuesday, December 23, 2008 3:17 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Batch conversion of 32bit files to 64bit

Hi

Does anyone know of an easy way to convert a lot (+/- 100) 32 bit UV files
to 64 bit ?

Doing them one-at-a-time is a pain, and I'd like to convert all of our
files, as we regularly run into the 32bit filesize limits.
Is it possible to RESIZE.FILE on a 32 bit file to convert it to 64 bit?

My System: UV 10.2.10 on W2K3 Server.

Regards

Arnold Bosch
IT Administrator
Taeuber & Corssen SWA (Pty) Ltd
Tel +264 (0)61 293 2106
Cell +264 (0)81 124 8625
Fax +264 (0)61 293 2104
Email: arno...@tc.com.na
--
---
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: {Blocked Content} RE: [U2] Need help with GCI system

[jpb-u2ug]

Are you doing this as the administrator or as a common user?

Jerry Banker

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Little
Sent: Friday, November 07, 2008 7:54 AM
To: u2-users@listserver.u2ug.org
Subject: RE: {Blocked Content} RE: [U2] Need help with GCI system

Hi David,

Yeah - I've done make, install, make, install, make install so many times in 
the last few days, I think I can do it in my sleep.  :)  Luckily I am not on a 
production box.

You mention the registry entry, but that gets updated when you do the 
"install", and currently says UvGciLibraries bin\magci.dll;bin\gci.dll.

I've done the environment variable thingie too, and it didn't seem to make a 
difference.

So... I don' know.

I'm waiting on a reply from the VAR but I aint holding my breath their gonna be 
of any help.

-bob

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S
Sent: Friday, November 07, 2008 3:14 AM
To: u2-users@listserver.u2ug.org
Subject: RE: {Blocked Content} RE: [U2] Need help with GCI system

Hi Bob,

Ah, forgot to ask the obvious, does this file exist:
e:\IBM\UV\bin\magci.dll

As Windows error 126 means missing file or registry entry is invalid.

I see you said you ran "Make a GCI Library from a GCI Definition File"
from the GCI Admin menu.

I don't see you saying you ran "Install a GCI Library" from the GCI
Admin menu.

Quote:

"This option does the following:

- Copies the DLL file from the gcidir directory to the bin directory in
the UV account directory
- Adds the name of the copied file to the GCI library list held in the
Windows Registry

The DLL is now ready for use."

Note it also states you can use the UVGCIDLLS variable to test your DLL,
before committing to updating your UV GCI configuration. Probably a wise
thing to do in a production or live environment! :)

Regards,
David


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Little
Sent: Friday, 7 November 2008 1:41 PM
To: u2-users@listserver.u2ug.org
Subject: {Blocked Content} RE: [U2] Need help with GCI system

Warning: This message has had one or more attachments removed
Warning: (not named).
Warning: Please read the "AngelicHost-Attachment-Warning.txt"
attachment(s)
for more information.



From: [EMAIL PROTECTED] on behalf of Hona, David S
Sent: Thu 11/6/2008 7:53 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Need help with GCI system

Isn't your module called "magci" and not "test"? As your error indicates
it's looking for "TEST" in your GCI library. From the GCI documentation:

Hi Davd,


Thanks for the reply.

The library is indeed called test.lib built from test.c/test.obj.  In it
is
the function "getSum()" I am trying to integrate.  The GCI definition
file
I've created on UV is called MAGCI.  UniVerse creates all the magci.*
items in
the gcidir when I take GCI.ADMIN menu option "5. Make a GCI Library from
a GCI
Definition File".

The way I thought it worked was:
The subroutine visible to UV would be getSum and the external subroutine
name
is the same and the module (.lib) is test because the function is in
test.lib.

What's odd is that the *hello example and it's accompanying BP GCI1
calling
program don't run either.   I'm using straight out of the box IBM
examples and
using the default GCI definition file: GCI.

-bob
This is a message from the MailScanner E-Mail Virus Protection Service
--
The original e-mail attachment "winmail.dat"
was believed to be infected by a virus and has been replaced by this
warning
message.

If you wish to receive a copy of the *infected* attachment, please
e-mail helpdesk and include the whole of this message
in your request. Alternatively, you can call them, with
the contents of this message to hand when you call.

At Thu Nov  6 18:40:48 2008 the virus scanner said:
   Could not parse Outlook Rich Text attachment

Note to Help Desk: Look on the AngelicHost MailScanner in
/home/virtual/site2/fst/var/spool/mail.quarantine/20081106 (message
mA72ejno008182).
--
Postmaster
---
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-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Antivirus and UV

[jpb-u2ug]

Does anyone know if we would have a problem with antivirus software,
specifically Symantec EndPoint 11, running UniVerse 10.1.12 on Red Hat Linux
AS3?

 

Jerry Banker

Senior Programmer Analyst

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

RE: [U2] [UD HP-UX] I need to track user logins

[jpb-u2ug]

The problem with last is that the file it uses for logging the users "wtmp"
is usually cleared every month, at least on Red Hat. What I do is create a
text file from the output of the last command at the end of each month and
import the results into the database. That way I have the start and stop
time and day for every user that has logged onto the system during the
month. This had made it easy to show when a user has been at work and for
how long. 

Jerry Banker

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Lunt, Bruce
Sent: Wednesday, November 05, 2008 11:50 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UD HP-UX] I need to track user logins

Hi All,

 

I need to provide a report that shows what users have not been on the system
for the last 90 days. I don't know how to do this and was hoping that
someone out there could help me.

 

Thanks in advance,

Bruce Lunt
---
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] UV 10.2

[jpb-u2ug]

Anybody know what it means when your program goes into a break condition and
it says:

Printer memory out of space

 

Or something like that, and not doing anything with a printer. We are
processing several hundred thousand records but not any print files.

 

Jerry Banker

Senior Programmer Analyst

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

RE: [U2] RE: spaces in file names

[jpb-u2ug]

That could be the answer to my question.
Tony, you've got to slow down. We all enjoy your posts on this list and you
would be missed, but, life is too short, smell some roses. You and I don't
know each other personally but I can tell by your writing that you should
probably take a vacation instead of paying for a doctor to take one.

Jerry Banker

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen
Sent: Saturday, October 04, 2008 3:35 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] RE: spaces in file names

I enjoy Tonys insights, what I dont understand is how he ever finds the
time to post such long responses not only in here but in cdp and on his own
blog as well



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin King
Sent: 04 October 2008 16:47
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] RE: spaces in file names

Nah, Tony's solid.  A bit stressed out - aren't we all? - and amazingly
comprehensive in his explanations, but SOLID overall.  Then again, not like
he needs my endorsement...

On Fri, Oct 3, 2008 at 7:59 PM, JPB-U2UG <[EMAIL PROTECTED]> wrote:

> Not offensive, I just think he sounds angry in a lot of his emails. He
> really should watch his blood pressure.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
No virus found in this incoming message.
Checked by AVG - http://www.avg.com 
Version: 8.0.173 / Virus Database: 270.7.5/1702 - Release Date: 01/10/2008
09:05
---
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] RE: spaces in file names

[JPB-U2UG]

Not offensive, I just think he sounds angry in a lot of his emails. He 
really should watch his blood pressure.


--
From: "Allen Egerton" <[EMAIL PROTECTED]>
Sent: Friday, October 03, 2008 5:52 PM
To: 
Subject: Re: [U2] RE: spaces in file names


jpb-u2ug wrote:

Do you wake up on the wrong side of the bed every morning?




Um, I'm not sure why you found what Tony wrote offensive.  I thought it 
was a reasonable presentation of his point of view.


--
Allen Egerton  [EMAIL PROTECTED]  860-912-8067
---
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/

FW: [U2] Copying UV data

[jpb-u2ug]

Sorry it should be SUSPEND.FILES ON and SUSPEND.FILES OFF

Jerry Banker


-Original Message-
From: jpb-u2ug [mailto:[EMAIL PROTECTED] 
Sent: Friday, October 03, 2008 4:23 PM
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] Copying UV data

SUSPEND ON
Copy
SUSPEND OFF

Jerry Banker


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin King
Sent: Friday, October 03, 2008 3:21 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Copying UV data

Re: UV 10.1 on Linux

Is there any "tricks" to picking up a data account from one system and
porting it over to another?  Do we have to stop UV before the move, or can
it be "paused" like with Unidata?

-Kevin
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] RE: spaces in file names

[jpb-u2ug]

Do you wake up on the wrong side of the bed every morning?

Jerry Banker


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tony G
Sent: Friday, October 03, 2008 3:59 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] RE: spaces in file names

For reference, Windows still stores path/file names internally in
short 8.3 format.  Support for long names and additional
characters was added in Windows 95 as an abstraction (a view)
over that for common usage where non-technical people want to use
file names like:
   "J. Jones Budget, 2007-2008 (revised).doc"
   "Chelsea smashed! at homecoming '07.jpg"

Windows was designed to be an operating system for home users and
later became a server.  (Most people forget that "PC" stands for
"Personal Computer".)  Macintosh supported long, friendly
filenames back in 1984 for the same reasons.  Unix is a system
for engineers, not intended to be used by people creating
OS-level filenames for their docs or pictures.

Now, just to be clear, I didn't suggest that DBMS files should be
allowed to have spaces in them, like "CUSTOMER MASTER".  I was
giving IBM a little grief for not making use of a file system
enhancement which was added to Windows 13 years ago so that we
can put IBM programs under "Program Files".  There's no need for
*nix compatibility at this level, commands like uv, udt,
UniAdmin, and the UniSDK tools are all platform-specific,
OS-level programs, and have nothing to do with the data in the
DBMS.

It's almost understandable that paths to data may give the DBMS
grief if they contain spaces, like:
  D:\Data Sources\ABC Company\UV\Accounts\WAREHOUSE
But even in this case, if ported to *nix anyone would know to
move that to something more appropriate like:
  /home/data/abc_company/uv/acccounts/WAREHOUSE
In either case, the DBMS-level file system should abstract the MV
DBA from OS-level issues.  For example, we should be allowed to
create files like the following without OS-related issues:
  .TEMP
  OPEN-A/R
  CUSTMAST*DEPT
That said, the CREATE.FILE verb should also prevent the creation
of filenames that are commonly agreed as being "a bad idea", like
"CUSTOMER MASTER".

As always (like case sensitivity) this whole situation is just
another case of engineers who decide not to make changes because
they "speak Unix" and they expect the rest of the world to do so
as well.  The burden is not on them to make software work for the
target OS but on developers to have to know how another OS works
so that they understand why their own platform isn't working.
That's just lazy and backwards thinking.

Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.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] Copying UV data

[jpb-u2ug]

SUSPEND ON
Copy
SUSPEND OFF

Jerry Banker


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin King
Sent: Friday, October 03, 2008 3:21 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Copying UV data

Re: UV 10.1 on Linux

Is there any "tricks" to picking up a data account from one system and
porting it over to another?  Do we have to stop UV before the move, or can
it be "paused" like with Unidata?

-Kevin
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] Updating UV/UD PE

[jpb-u2ug]

This may be true but it really isn't a smart move even in windows, almost
everything in programming is delimited by spaces. Personally I think it was
one of the dumbest things implemented by MS.

Jerry Banker


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart
Sent: Thursday, October 02, 2008 5:04 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Updating UV/UD PE

CREATE.FILE "FILE WITH SPACES IN'T" 30
Creating file "FILE WITH SPACES IN'T" as Type 30.
Creating file "D_FILE WITH SPACES IN'T" as Type 3, Modulo 1, Separation
2.
Added "@ID", the default record for RetrieVe, to "D_FILE WITH SPACES
IN'T".

>-Original Message-
>I'm not quite sure what you're getting at here, but never mind ...
Don't
>forget UV comes from a heritage where space was an illegal character in
>file names. (And it still is, for quite a lot of other programs that
run
>under Windows, too. Spaces cause me grief, even in Windows itself!)

 
**
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 communication in error, please reply to this e-mail to notify the
sender of its incorrect delivery and then delete it and your reply.  It is
your responsibility to check this email and any attachments for viruses and
defects before opening or sending them on. Spotless collects information
about you to provide and market our services. For information about use,
disclosure and access, see our privacy policy at http://www.spotless.com.au 
Please consider our environment before printing this email. 
** 
---
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] Crystal Reports and UniData

[jpb-u2ug]

Hu, IBM doesn't have market power? Maybe someone should tell them. On
the Fortune 500 IBM is 15 and Microsoft is 44.

Jerry Banker


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman
Sent: Friday, September 19, 2008 9:14 AM
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] [UD] Crystal Reports and UniData

There is, unfortunately, a question of "market power" here.

If Access and SQL-Server talk to each other, even if they use a *broken*
version of SQL to do so, the market place will expect other databases and
clients to talk the same - BROKEN - dialect of SQL.

It's all very well a vendor (like IBM, for example) saying "we comply with
the standard", but if the official and the de-facto standards don't agree,
then the smaller vendors (and here I include U2) are likely to get trampled.

Like it or not, IBM should treat any problems with a market-influential tool
like CR as high priority, even if it is CR that's at fault. In an ideal
world, if IBM said "CR is broken, and here's how", it would result in CR
getting fixed. In the world we live in, CR can probably get away with saying
"tough, on yer bike, mate".

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of jpb-u2ug
Sent: 19 September 2008 14:50
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UD] Crystal Reports and UniData

David,
I think you have the emphasis on the wrong party here. IBM U2 is the
database not the reporting tool. I don't think it is IBM's responsibility to
try and comply with a tool, any tool, it is the other way around. Since CR
is suppose to talk to a database and get the information from a database it
is their responsibility to try and comply with it. If they don't want to,
then they are not the tool you want to use. Find one that will. It is IBM
U2's responsibility to comply with the operating systems that are available
and to provide standardized access to the database. Do you think Microsoft
tries to make SQL Server compliant with CR?

Jerry Banker

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton
Sent: Thursday, September 18, 2008 11:37 PM
To: u2-users@listserver.u2ug.org
Cc: [EMAIL PROTECTED]
Subject: RE: [U2] [UD] Crystal Reports and UniData

Yup - I received your email -- And I'm glad this is moving up the chain.

The bigger question to the User Group -- Are there 3rd party products that
we as vendors and users **need** IBM to ensure work at some base level?  Are
there 'natural use' products that IBM really does need to test and assure a
base-level of compliance with??

Today, IBM certifies that UniData works on Windows, and several versions of
Unix and Linux -- and that if U2 does not work with those products, it would
be a 'tier one' issue to resolve.

In a very short period of time, it appears any new client we get will be
expecting that same 'Tier one' support for Crystal Reports, and we don't
have a mechanism to ensure that support.  Are there products like these that
are 'add ons', but essentially 'core' or 'natural use' extensions that need
to be tested in the same way the O/Ss are tested??


David W.


> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of David Peters
> Sent: Thursday, September 18, 2008 5:39 PM
> To: u2-users@listserver.u2ug.org
> Cc: [EMAIL PROTECTED]
> Subject: Re: [U2] [UD] Crystal Reports and UniData
>
> I wanted to send a note on this much earlier, but have been
> tied up until now.  We can't certify that other solutions,
> such as C.R., will work with our products, but we really do
> want them to work.  It sort of makes sense that we would,
> because if our customers can't succeed with their
> solutions, neither will we.
---
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-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/