Re: [U2] Extreme slow down on Universe periodically

[Horacio Pellegrino]

Use sysinternal tools and watch IO delta bytes, you can also trace CPU
utilization.


hp

On Fri, Apr 8, 2011 at 9:04 AM, Curt Stewart  wrote:

> Has anyone in the group experienced this issue and found a resolution?
>
> My client is reporting the periodic slow down of their system.  It slows
> down to almost the point of a hang.  This affects both existing processes
> (menu selections, data entry, reports) and logins.  Their system admins
> (IBM) reports that it is a Universe or application problem.  I haven’t been
> able to identify any runaway processes or hogs.  The log files that I’ve
> looked at haven’t shed any light on the matter.  Could there be a log file
> that I’m overlooking that might need to be cleared?  But if it’s an
> undersized file, why wouldn’t it be a consistent problem?  I’m hoping that
> the group might be able to suggest some things to look at and consider.
>
> Any and all suggestions would be appreciated.
>
> Environment
>  Universe  10.2.10
> Windows Server 2003
> Virtual Machine (sorry don’t know any details on this
> component)
> 34 user license, only about 15 active
>
> Thanks for your help.
>
> Curt Stewart
> TRI-SYS Consulting
>
>
>
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



-- 

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

Re: [U2] [AD] RE: Accessing Pervasive SQL database from Universe

[Horacio Pellegrino]

Keep it simple, just use old SQLCMD to "talk" to SQL.

EXECUTE "SQLCMD  ."




On Fri, Apr 8, 2011 at 4:22 PM, Robert Houben wrote:

> Richard,
>
> We have products that work for both Universe and PI Open.  You may wish to
> look at some of the products here:
>
> http://www.fwic.net/Products/MultiValueProducts.aspx
>
> Thank you,
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:
> u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard A. Wilson
> Sent: Friday, April 08, 2011 1:15 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Accessing Pervasive SQL database from Universe
>
> One of my clients who has been on Prime Information/Universe since the mid
> 80's is moving to a new package called Timberline (job costing etc)
>
> I would like to continue using some of the reports/rules/etc that reside in
> Universe.
>
> Mapping of the data might be much quicker that reworking the rules in a new
> environment
>
> The question is, what would be the best, most efficient way to access that
> sql data.
>
> I have searched the web for a couple of hours and most all related articles
> are connecting to Universe.
>
> thanks, Rich
> --
> Richard A Wilson
> Lakeside Systems
> Smithfield, RI, USA
> Voice 401-231-3959
> Fax   206-202-2064
>
> ___
> 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
>



-- 

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

Re: [U2] PDF Files directly from UniData or UniVerse

[Horacio Pellegrino]

We use a product called SwiftView converter, that works in Windows and
Linux.

hp

On Tue, Apr 12, 2011 at 9:39 AM, Doug Farmer  wrote:

> Here is a question for this group.
>
> Has anyone been able to generate PDF files directly from UniData and/or
> UniVerse without having a manual step involved?  In other words, just
> running a program using the standard PRINTER ON and PRINTER OFF commands,
> and having the output be a PDF file?
>
> Any pointers would be very welcome.
>
> Doug
> 
>
> This e-mail is for the use of the intended recipient(s) only. If you have
> received this e-mail in error, please notify the sender immediately and then
> delete it. If you are not the intended recipient, you must not use, disclose
> or distribute this e-mail without the author's prior permission. We have
> taken precautions to minimize the risk of transmitting software viruses, but
> we advise you to carry out your own virus checks on any attachment to this
> message. We cannot accept liability for any loss or damage caused by
> software viruses. Any views and/or opinions expressed in this e-mail are of
> the author only and do not represent the views of Epicor Software
> Corporation or any other company within its group.
>
>
> This message has been scanned for malware by Websense. www.websense.com
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



-- 

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

Re: [U2] trigger "issue"/archive question

[Horacio Pellegrino]

I've seen issues like that when a programmer is debugging and stepping line
by line in the WRITE statement.

hp

On Fri, Apr 15, 2011 at 1:18 PM, douglas chanco wrote:

> while my trigger works fine I am getting a weird error message (#2 the line
> number were added by me and are not part of the program).
>
> this error is returning from the following line of code in the trigger
> RESULTS = setDiagnostics('[ERROR] Sql updated failed .')
>
> so I suppose its OK
> 1. Program "TEST.TRIGGER": Line 19, [ERROR] Sql updated failed .
>
> this error message make no sense since the trigger worked fine (in this
> case the record was not updated)
> 2. Program "TEST.TRIGGER": Line 19, Error performing trigger for "".
>
> ** line 19 is the WRITE command
>
> and this error is from the program itself (as part of the else clause of
> the write)
> 3. error writing .
>
> what would be ideal would be just error 3 (as the program currently works)
>  but I suppose error 1 is useful to make it obvious that the web service
> call failed.  What I would like to get rid of is error 2 since it makes no
> sense since the trigger works, teh record is not updated and if the trigger
> succeeds the record is updated.
>
> what I am trying to do is make it such that there is no need to modify the
> pick code that writes the data, just add the trigger to the file
>
> I can add HUSH OH/OFF to hide it (error 2) but would rather figure out why
> universe returns "Error performing trigger for ""."
> '
> any suggestions/ideas/thoughts welcomed
>
> thanks
>
> dougc
>
> ps
>
> one  a slightly different note is there a way to search the archives?  I
> see them and can click on each one to see the topics but there has to be an
> easier way to search. (I am looking at them on the u2 web site)
>
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



-- 

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

Re: [U2] Credit Card Processing

[Horacio Pellegrino]

We use authorize.net, and you can just do a plain  CREATESECUREREQUEST call.
No need for 3rd party at all.



On Thu, Jun 30, 2011 at 12:04 PM, Bryan Evans  wrote:

> I am looking for a multi-value (UniVerse specifically) product to
> handle credit card processing.  Does anyone know of or can recommend a
> product?  We are an HP-UX UniVerse shop.  The volume of credit cards
> processed would be very low - 100 orders or less per day.
>
> Thank you in advance,
>
> Bryan Evans
> Orbit Irrigation Products Inc.
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



-- 

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

Re: [U2] SLOW

[Horacio Pellegrino]

Windows ? Linux ?


On Fri, Oct 7, 2011 at 4:21 PM, Drew William Henderson <
d.hender...@moreheadstate.edu> wrote:

> 
>
> My boss has noticed today that we've been running SLOW, and isn't  happy
> about it.  He wants to  know if SLOW is industry standard, and what other U2
> shops might be running SLOW.
> I told him that I didn't know about other U2 shops, but that I know a lot
> of SQL shops have been running SLOW for years, and seem to be very
> satisfied.  I also let him know that running SLOW on Friday afternoons was
> almost industry standard, but I'm not sure he's buying it.
>
> So, if you're running SLOW in your environment, please let me know;
> otherwise, we might not be running SLOW on Monday morning.
>
> (sorry...couldn't help myself!  Have a good weekend, all!)
>
> Drew Henderson
> Director, Enterprise Systems Architecture and Security
> Morehead State University
> 301 Howell-McDowell Bldg
> Morehead, Ky 40351
> 606/783-2445
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



-- 

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

Re: [U2] End of Month date routine

[Horacio Pellegrino]

Using NEXT.MONTH and proper YEAR:

ICONV(NEXT.MONTH:'/01/':YEAR)-1

will make the trick.

HP


On Mon, Dec 5, 2011 at 2:03 PM, Wjhonson  wrote:

>
> Does someone have a routine that, no matter what day you run it, returns
> the End of Month Date ?
> (Assume the end of month date, is the calendar end of month date not some
> screwy business date)
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



-- 

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

Re: [U2] Solid State Drives (SSD) and Universe

[Horacio Pellegrino]

You will need to consider that a RAM disk will use way more CPU, specially
in a multiuser environment. So that process that took forever it will run
faster, but you might be at risk of not leaving enough CPU power for the
rest.

We use Ram drives but not for everything.

hp


On Mon, Dec 19, 2011 at 9:54 AM, Symeon Breen  wrote:

> I think the first thing you need to assess tho is - is it the diskio that
> is
> the bottleneck - if you have a *nix system with plenty of ram, you get a
> decent disk cache in ram. Analyse your wait on io stats for your
> processors,
> if this is higher than your actual cpu utilisation then you do have a disk
> bottleneck, Otherwise you may be better off getting better/more processors.
>
>
>
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
> Sent: 19 December 2011 13:45
> To: U2 Users List
> Subject: Re: [U2] Solid State Drives (SSD) and Universe
>
> I am currently attempting to as we speak, but, I don't have any hard
> numbers
> for you.
> I have some numbers from a benchmark tool, but, there are so many factors
> involved, I can't really tell you whether U2 performance is 30 times
> faster... Although I'm hoping this week I can get Universe installed and
> run
> through some jobs to see.
>
> The tool on RHEL 6 is telling me that on using the "sync" io engine, that
> random reads are 30 times faster, and, random writes are 60 times faster,
> which I find funny.  BUT, I'm no expert on which io engine Universe uses
> (sync, libaio, posixaio, etc. etc.)
>
> In my case, I don't work for that big of a company, but, IBM was offering a
> 40% rebate on some of their solid stuff in October, and our AIX support was
> slated to end in April.  That being said though, if you are the guy that
> has
> to research the hardware, I'll give you these pointers that I have learned
> painfully...
>
> If you are running on an x86 machine (intel-ish), keep in mind these
> points:
>
> 1) There are a couple of different types of solid state drives.
> -SATA, SAS attached to an actual disk controller (These are limited by the
> throughput on the disk controller, which they will quickly eclipse) -PCIe
> (PCI Express) that plug directly into the PCIe bus of the system (These are
> not limited by a disk controller and communicate almost directly with the
> CPU/RAM/bus)
>
> The PCIe are not bootable however, but, they bypass the latency of a
> traditional disk controller, and are even faster.
> They do come with the added complication of proprietary drivers, so if you
> don't get good support for this, things can get painful.
>
> 2) Be sure and buy enterpise SSD's.  For example, an Intel 320 SSD is
> probably not an enterprise SSD.  The quality of the firmware/drivers and
> flash memory is pretty key on these things, and the prices range from $200
> all the way up to $4,000+ a piece.
> Basically, just do your homework on what the predicted life of the drive
> is.
> Don't always pay attention to warranty or hours.  Its more about, "How much
> data in GB can I write to this thing before it wears out."
> Also the cheap ones really fall short on random write performance which I
> think is important in a U2 database.
>
> 3) Make sure its in your budget.  They are still at least double or triple
> the price of spindle disks (for the enterprise grade stuff).  However, the
> performance is more than double/triple, so, the cost justifies itself.
>
> I think IBM has some SSD's offerings for their new POWER 7 AIX machines as
> well.
>
> Now for some more specific Vendor advice, as a result of some of my pain I
> have experienced the last month or so.
>
> If you go with one of the big boys for a RHEL (Linux) or Windows server,
> here is some useful info.
>
> IBM and HP (not sure about Dell) offers mainly two types of SSD's The
> traditional SATA ones http://www.redbooks.ibm.com/abstracts/tips0792.html
>
> The PCIe Ones
> http://www.redbooks.ibm.com/technotes/tips0729.pdf
>
> *Be careful about how you hook up the traditional SATA ones.* My so called
> "Vendor" was supposed to do all of this "checking" for me, but, they
> dropped
> the ball big time.
>
> IBM has a list of controllers that are compatible with certain machines.
>
> http://www-03.ibm.com/systems/info/x86servers/serverproven/compat/us/xseries
> /controllers/matrix.html
> So make sure that matches up.  I'm sure HP, has a similar posting
> somewhere.
>
> THEN, make sure the controller can support SSD's.
> SSD's behave way differently than regular disks, so, IF you want to use a
> hardware RAID controller or something of the like, you must make sure it is
> intelligent enough to handle the SSD's.
>
> OR you can just hook it up to an HBA (Host bus adapter) with no actual
> intelligence, and then let the OS handle how it deals with the SSD's (i.e.
> software RAID, lvm, etc.)  If you know Linux lvm, RAID, or Windows disk
> management, this might be the best approac

Re: [U2] Passing by Value

[Horacio Pellegrino]

I asked the Rocket Software guys to have LOCAL variables... but nothing...
:-(


On Thu, Jan 26, 2012 at 2:02 PM, Wjhonson  wrote:

>
> You've never worked on programs that are 8000 lines long I take it :)
>
>
>
>
> -Original Message-
> From: John Hester 
> To: U2 Users List 
> Sent: Thu, Jan 26, 2012 10:49 am
> Subject: Re: [U2] Passing by Value
>
>
> I like to use increasing roman numerals:
> FOR I = 1 TO COUNTER
>  GOSUB PROCESS
> EXT I
> PROCESS:
> OR II = 1 TO COUNTER2
>  FOR III = 1 TO COUNTER3
>   FOR IV = 1 TO COUNTER4
>
>   NEXT IV
>  NEXT III
> EXT II
> ETURN
> -Original Message-
> rom: u2-users-boun...@listserver.u2ug.org
> mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
> ent: Thursday, January 26, 2012 10:09 AM
> o: u2-users@listserver.u2ug.org
> ubject: Re: [U2] Passing by Value
>
> n a related note, any clever ideas to localize a variable to a local
> ubroutine?
> For I = 1 to 10
>  GOSUB PROCESS
> ext I
> top
> 3000 Lines of code later
> PROCESS:
> OR I = 1 TO 20
> RINT I
> EXT I
> ETURN
> __
> 2-Users mailing list
> 2-us...@listserver.u2ug.org
> ttp://listserver.u2ug.org/mailman/listinfo/u2-users
> __
> 2-Users mailing list
> 2-us...@listserver.u2ug.org
> ttp://listserver.u2ug.org/mailman/listinfo/u2-users
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



-- 

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

Re: [U2] Universe file trigger subroutine issue

[Horacio Pellegrino]

You might have a user with the file opened in a common area from before.

Cheers!

hp



On Wed, Mar 7, 2012 at 5:11 PM, Ken Ford  wrote:

> Greetings fellow U2 users.
> We use Universe 10.3 on an AIX 5.3 server.  We have file triggers on a
> number of files, with one master globally catalogued subroutine calling
> locally catalogued subroutines depending upon the file involved.
> My understanding was that if one of these Is changed and the triggers
> associated with the file involved are dropped and recreated, the changes in
> the subroutine would take effect.  But I found that programs updating the
> file associated with the trigger were still using the old version of the
> subroutine.  Should this be happening?  The work around was to rename the
> subroutine, drop the triggers and recreated them, using the renamed
> subroutine.  Any suggestions or thoughts would be appreciated.
>
> Thanks,
> Ken Ford
> Software Engineer
> ken.f...@firstmac.com.au
>
>
>
>
>  
> ---
> Note:
> This email (inc all attachments) is for the use of the intended
> recipient(s) only.
> Privileged or confidential information may be contained in this
> communication. If you have received this email in error, please notify the
> sender immediately and then delete all copies of this message from your
> computer network. If you are not the intended recipient, you must not keep,
> use, disclose, copy or distribute this email without the author's prior
> permission. If you are the intended recipient and you do not wish to
> receive similar electronic messages from us in future, then please respond
> to the sender to this effect.
> We have taken precautions to minimise the risk of transmitting software
> viruses, but advise you to carry out your own virus checks on this email
> and its attachments. We do not accept liability for any loss or damage
> caused by software viruses and do not represent that this transmission is
> free from viruses or other defects.
> FirstMacLimited (ABN 59 094 145 963) (AFSL 290600)
>
>  
> ---
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



-- 

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

Re: [U2] Unable to unlink the operating system file BILLS.123

[Horacio Pellegrino]

If it worked and in a loop, check that the previous shell did finish. It
might still have the file opened, therefore cannot be deleted (unlink).

Cheers!

hp

On Wed, Apr 4, 2012 at 2:15 PM, Wjhonson  wrote:

>
> After beating this program / phantom / script / shell /... I finally got
> it to spit out why it kept failing in the middle of the night.
> This is Universe 10.2.3 on Windows 7 Professional (if that matters)
>
> LINE 121 Unable to unlink the operating system file "BILLS.123"
>
> I'm trying to delete this file on this line, so what sort of thing causes
> this particular error ?
>
> Could it be that the file is being held open by something? That I don't
> have permissions to delete ?
> That the directory is read-only in Windows?
>
> What is my checklist to run through, to figure out which issue is my issue?
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



-- 

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

Re: [U2] File Sizing using concurrent option AND FAREWELL

[Horacio Pellegrino]

I remember a company that went bankrupt because they spent so much in SAP (
or was it Oracle? ) It was in the news.

Anybody?

HP

On Wed, May 23, 2012 at 3:07 PM, Dawn Wolthuis wrote:

> I have only seen SAP implementations from a bit of a distance and
> through reading stories, but in every case, my understanding was that
> those in charge of the project were gone before SAP went live. I have
> seen systems analysts and programmers survive the project, with plenty
> of stories once they do. It sounds like a really brutal ERP
> installation. I have not kept current on this front enough to know
> that people were still selecting it, although a whole lot of people
> are still maintaining it.
>
> Best wishes, Scott, and thanks for taking the time to write up your
> notes regarding some of those in the industry who have helped you.
> Cheers!  --dawn
>
> On Wed, May 23, 2012 at 1:58 PM, Holt, Jake  wrote:
> > I thought no one actually ever finished implementing SAP?
> >
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:
> u2-users-boun...@listserver.u2ug.org] On Behalf Of iggch...@comcast.net
> > Sent: Wednesday, May 23, 2012 1:31 PM
> > To: U2 Users List
> > Subject: Re: [U2] File Sizing using concurrent option AND FAREWELL
> >
> >
> >
> > Don't worry, we're not going to implement anything that's going to do
> damage.  Well, unless you call the outrageous cost a damage :)
> >
> >
> >
> > Any thoughts on the CONCURRENT option?
> >
> >
> >
> > - Original Message -
> >
> >
> > From: "Wjhonson" 
> > To: u2-users@listserver.u2ug.org
> > Sent: Wednesday, May 23, 2012 2:14:19 PM
> > Subject: Re: [U2] File Sizing using concurrent option AND FAREWELL
> >
> >
> > Well you used to be.  After SAP sucks ten years out of the life of your
> company, we'll see
> >
> >
> >
> > << I am being moved to our corporate office to join a eam of 10 who will
> be learning, configuring, and customizing SAP to meet the eeds of the best
> wine and spirits distribution company  in the world.  Ok, I'm
> >  little partial...  >>
> >
> >
> >
> >
> >
> > -Original Message-
> > From: iggchamp 
> > To: U2 Users List 
> > Sent: Wed, May 23, 2012 11:11 am
> > Subject: [U2] File Sizing using concurrent option AND FAREWELL
> >
> >
> >
> > Hi All,
> >
> > uv 10.2.7 / hpux 11.11
> >
> > First things first (skip this section if you don't care for goodbyes)...
> >
> >
> > I wanted to say thanks to all of the contributors to this list.  I have
> learned
> >  tremendous amount from all of you.  The passion that many of you have
> for your ork is really inspiring.  I am being moved to our corporate office
> to join a eam of 10 who will be learning, configuring, and customizing SAP
> to meet the eeds of the best wine and spirits distribution company  in the
> world.  Ok, I'm
> >  little partial...   All of you deserve a great deal of credit for my
> pportunity as you have all contributed to the things that I've been able to
> ccomplish with my current system.  Without the great system that we here in
> llinois have developed, I'm sure that noone would trust in my abilities to
> eliver in a different environment.
> >
> >
> >
> >
> >
> >
> > blockquote>
> >
> >  special thanks to a couple of people I have been blessed to work
> directly ith.  I cannot recommend their services enough!
> > /blockquote>
> >
> >
> > blockquote>
> >
> >
> > ony Gravagno ( http://www.nebula-rnd.com/ ):  When each division of SWS
> was
> > sked to provide a web service that would interface our sales force
> automation
> > nits to our business systems, I was terrified.  I had never had the
> opportunity
> > o work with web technology and, based on a heavy workload, did not have
> the
> > ime to dive in at that time.  I did take the web developer that Universe
> > ffered for a spin.  Pretty cool tool.  While I was able to develop a web
> > ervice that could work had I set the requirements myself, I could not
> get it to
> > eet the requirements that corporate was developed.  I even worked with
> one of
> > he IBM engineers and he could not get it done.  Keep in mind that I have
> always
> > elieved in my abilities to provide solid solutions using the tools that
> we have
> > n the multivalue world.  It killed me to have to bring in a resource
> from the
> > utside.  I swallowed my pride and turned to Tony.  I was amazed at the
> > ncredible service that he provided.  He developed a service for me that
> has
> > een rock solid.  I am still amazed that I have never had to revisit it
> after
> > ears of pounding by our sales force.  This is plug, play, and forget
> about it
> > t its best!  Not only that but our web service which provides incredibly
> > owerful and complicated pricing blows the web service developed on our
> > orporate as400 system out of the water from a performance standpoint.
>  Thanks
> > ony, you've made me look a lot better than I really am :)
> > /blockquote>
> >
> >
> >
> > eff Fitzerald ( http://www.fitzlong.co

Re: [U2] File Sizing using concurrent option AND FAREWELL

[Horacio Pellegrino]

YES! I guess you google SAP and BANKRUPTCY ?



On Wed, May 23, 2012 at 3:29 PM, Israel, John R. <
johnisr...@daytonsuperior.com> wrote:

> Is this it?
>
> http://www.bloomberg.com/apps/news?pid=newsarchive&sid=awweg53wmmJw&refer=germany
>
> John
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:
> u2-users-boun...@listserver.u2ug.org] On Behalf Of Horacio Pellegrino
> Sent: Wednesday, May 23, 2012 3:16 PM
> To: U2 Users List
> Subject: Re: [U2] File Sizing using concurrent option AND FAREWELL
>
> I remember a company that went bankrupt because they spent so much in SAP
> ( or was it Oracle? ) It was in the news.
>
> Anybody?
>
> HP
>
> On Wed, May 23, 2012 at 3:07 PM, Dawn Wolthuis  >wrote:
>
> > I have only seen SAP implementations from a bit of a distance and
> > through reading stories, but in every case, my understanding was that
> > those in charge of the project were gone before SAP went live. I have
> > seen systems analysts and programmers survive the project, with plenty
> > of stories once they do. It sounds like a really brutal ERP
> > installation. I have not kept current on this front enough to know
> > that people were still selecting it, although a whole lot of people
> > are still maintaining it.
> >
> > Best wishes, Scott, and thanks for taking the time to write up your
> > notes regarding some of those in the industry who have helped you.
> > Cheers!  --dawn
> >
> > On Wed, May 23, 2012 at 1:58 PM, Holt, Jake  wrote:
> > > I thought no one actually ever finished implementing SAP?
> > >
> > > -Original Message-
> > > From: u2-users-boun...@listserver.u2ug.org [mailto:
> > u2-users-boun...@listserver.u2ug.org] On Behalf Of
> > iggch...@comcast.net
> > > Sent: Wednesday, May 23, 2012 1:31 PM
> > > To: U2 Users List
> > > Subject: Re: [U2] File Sizing using concurrent option AND FAREWELL
> > >
> > >
> > >
> > > Don't worry, we're not going to implement anything that's going to
> > > do
> > damage.  Well, unless you call the outrageous cost a damage :)
> > >
> > >
> > >
> > > Any thoughts on the CONCURRENT option?
> > >
> > >
> > >
> > > - Original Message -
> > >
> > >
> > > From: "Wjhonson" 
> > > To: u2-users@listserver.u2ug.org
> > > Sent: Wednesday, May 23, 2012 2:14:19 PM
> > > Subject: Re: [U2] File Sizing using concurrent option AND FAREWELL
> > >
> > >
> > > Well you used to be.  After SAP sucks ten years out of the life of
> > > your
> > company, we'll see
> > >
> > >
> > >
> > > << I am being moved to our corporate office to join a eam of 10 who
> > > will
> > be learning, configuring, and customizing SAP to meet the eeds of the
> > best wine and spirits distribution company  in the world.  Ok, I'm
> > >  little partial...  >>
> > >
> > >
> > >
> > >
> > >
> > > -Original Message-
> > > From: iggchamp 
> > > To: U2 Users List 
> > > Sent: Wed, May 23, 2012 11:11 am
> > > Subject: [U2] File Sizing using concurrent option AND FAREWELL
> > >
> > >
> > >
> > > Hi All,
> > >
> > > uv 10.2.7 / hpux 11.11
> > >
> > > First things first (skip this section if you don't care for
> goodbyes)...
> > >
> > >
> > > I wanted to say thanks to all of the contributors to this list.  I
> > > have
> > learned
> > >  tremendous amount from all of you.  The passion that many of you
> > > have
> > for your ork is really inspiring.  I am being moved to our corporate
> > office to join a eam of 10 who will be learning, configuring, and
> > customizing SAP to meet the eeds of the best wine and spirits
> > distribution company  in the world.  Ok, I'm
> > >  little partial...   All of you deserve a great deal of credit for my
> > pportunity as you have all contributed to the things that I've been
> > able to ccomplish with my current system.  Without the great system
> > that we here in llinois have developed, I'm sure that noone would
> > trust in my abilities to eliver in a different environment.
> > >
> > >
> > >
> > >
> > >
> > >
> > > blockquote>
> > >
> > >  special thanks to a couple of people I have be

Re: [U2] UV Unix File Recovery

[Horacio Pellegrino]

We do *EMC replication manager* for snapshots in Windows and make a backup
out of it. It halts IO for 2-4 seconds only.

hp

On Fri, Jun 22, 2012 at 3:13 PM, Bill Haskett wrote:

> George:
>
> Unfortunately, I'm on Windows.  I do full backups each day, but the 15Gb
> backup files shut down the dbms for about 30 minutes each night.  We're not
> a 24/7 shop by any means, but we do span a number of time zones, so our
> window for backups is about three hours each evening.
>
> I've always wanted to use something simple but can't find anything.  One
> would think your backup method (mirrors, breaking them, backing up the
> mirror, then re-syncing) would be part of the U2 admin guide (or be on some
> wiki).  I do this with a couple of simple Windows scripts, but it's
> strickly a full backup operation with no mirrors.  I did have to change the
> scripts and the method of implementation for Windows 2008 R2 from previous
> windows using "ntbackup".
>
> Thanks,
>
> Bill
>
> --**--**
> 
> - Original Message -
> *From:* ggal...@wyanokegroup.com
> *To:* U2 Users List 
> *Date:* 6/22/2012 9:39 AM
> *Subject:* Re: [U2] UV Unix File Recovery
>
>> I don't know the method it uses, but if figures out what changed in the
>> file and saves just that part.
>>
>> I have a 300gb partition set for our backups, and it can hold apx 8
>> months of 20 minute interval diff checks
>> Granted, that figure would depend on the size of your database files (I'm
>> not really sure what our base gb
>> Figure is).
>>
>> It doesn't really impact noticeably our system processing speed either
>> when it runs.
>>
>> It either uses rsynch or a modified version of it to determine the
>> differences between the mirror and the
>> Active file - rsynch is pretty fast also.
>>
>> For unix system, it might already be loaded (Redhat has it preloaded),
>> otherwise it's pretty simple to
>> Install, (does require python to be loaded)
>>
>> Load it up, give it a try
>>
>> It does not replace backups - but it does make for those oops moments for
>> restore a file to it's previous
>> State much faster than pulling tapes, assuming you have the incrementals
>> for the time period you want.
>>
>> But to be honest, I've never actually tracked a large file with minor
>> changes to see how large the
>> Change files are.
>>
>> To help save space, the incremental files are stored in a compressed
>> format, great for UV ASCII data.
>>
>> George
>>
>>
>> -Original Message-
>> From: 
>> u2-users-bounces@listserver.**u2ug.org[mailto:
>> u2-users-bounces@**listserver.u2ug.org]
>> On Behalf Of Bill Haskett
>> Sent: Friday, June 22, 2012 12:06 PM
>> To: U2 Users List
>> Subject: Re: [U2] UV Unix File Recovery
>>
>> George:
>>
>> If you update a few records in a 2Gb file, isn't the incremental backup
>> going to save the entire 2Gb file?  So, your entire database will most
>> likely be saved each time the incremental backup is run.
>>
>> Or is this some kind of imaging backup (I didn't get this from their
>> website).
>>
>> Thanks,
>>
>> Bill
>>
>> --**--**
>> 
>> - Original Message -
>> *From:* ggal...@wyanokegroup.com
>> *To:* U2 Users List 
>> *Date:* 6/21/2012 8:20 PM
>> *Subject:* Re: [U2] UV Unix File Recovery
>>
>>> From: 
>>> u2-users-bounces@listserver.**u2ug.org[
>>> u2-users-bounces@listserver.**u2ug.org]
>>> On Behalf Of Wols Lists [antli...@youngman.org.uk]
>>> Sent: Thursday, June 21, 2012 6:56 PM
>>> To: u2-users@listserver.u2ug.org
>>> Subject: Re: [U2] UV Unix File Recovery
>>>
>>> On 21/06/12 16:53, George Gallen wrote:
>>>
 We use rdiff-backup for onsite backups, it creates a mirror and keeps
 differential for
 Restoring to specific backup date images (although that is a file by
 file).

>>> How easy is it to get back to any particular date? Disk space is cheap
>>> (though network bandwidth isn't, if big files get modified). Not saying
>>> my way is better, but it gives the appearance of multiple full backups,
>>> while only doing an incremental copy.
>>>
>>>   
>>> http://www.nongnu.org/rdiff-**backup/
>>>
>>>   Multiple full backups would only occur if you used a backup method
>>> to backup the mirror,
>>>  (excepting the directory which holds the incremental files).
>>>
>>>   To restore a file, you can specify an exact date/time or an
>>> estimated date (ie. 3d ago)
>>>   It also has a pruning utility if you need to free up disk space,
>>> by deleteing older incrmental info
>>>
>>>   It actually does a fairly good job at only saving the changes,
>>> even to big files.
>>>
>>>
 We run our nightly backups off the mirror

 And update the mirror every 20 minutes - except while the backup runs

>>> Yup - on the main server itself, I'd probably run mirrored disks, break
>>> the mirror to do the backup, an

RE: [U2] [UD] Spooling a PCL form

[Horacio Pellegrino]

Great code Bruce! I've been looking for something like that for a long time.

I think your problem is that UV translates some CHARS as soon as they go
through a memory variable. To avoid that try:

ASSIGN 1 TO SYSTEM(1017)

Then do your stuff
Then turn it back off

ASSIGN  TO SYSTEM(1017)

That works in UV-10.2.3 Windows2003.

Cheers!

Horacio Pellegrino



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, August 14, 2007 10:33 AM
To: u2-users, 
Subject: [U2] [UD] Spooling a PCL form

I created a PCL file from a PDF and moved the file to a directory on our 
UNIX machine where we run UniData (5.2 on DGUX, I'm pushing to upgrade. 
:-) )
My program reads this record, prints it then I fill in the blanks.
   PRINTER ON
   PRINT REC  ;* The PCL form
   PRINT ESC:'&l5D': ;* lines per inch
   PRINT ESC:'(s1p9v0s0B':ARIAL:
   PRINT ESC:'*p3600x1600Y':TABLE<14>"D4/"
   PRINT 
ESC:'*p200x1950Y':TABLE<1,1>:ESC:'*p2450X':TABLE<2>:ESC:'*p3600X':TABLE<3>
   PRINT ESC:'*p200X':TABLE<1,2>
   PRINT ESC:'*p200X':TABLE<1,3>
...

This works great when the print job is directly to the printer.  When it 
is sent to the _HOLD_ file for printing later (via SPOOL) the form prints 
fine, but the "fill in the blanks" info doesn't print on the top 3/4 of 
the page.  That is, only the very bottom of the page is filled in.

Any ideas?
 

Bruce M Neylon
Health Care Management Group 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [AD] Green Screen Dev. Environment

[Horacio Pellegrino]

Well, the .NET environment works fine with UniObjects in the Windows world.



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin King
Sent: Monday, October 08, 2007 10:37 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [AD] Green Screen Dev. Environment

True, not everyone has difficulty with SB+, but having trained a lot of SB+
developers over the years, that's the opinion I hear the most.  As you
stated, SB+ has a lot of features and functionality, but equally important
is the ability to rapidly get results, which can be a significant cost saver
over the development lifecycle.  And with that being said, there are still a
number of shops trying to implement SB+ solutions using BASIC implementation
paradigms and trading away much of the rapid development features in the
process.  This then leads to the perception that development actually takes
longer and is more difficult using SB+ than it does in BASIC, when the
reality is that personal choices of how the product is used is more likely
to have contributed to the reduced productivity.

-K
---
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] NEW ADO.NET ?

[Horacio Pellegrino]

Has anyone tried out the new ADO.NET provider for .NET IBM ?

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

RE: [U2] Server Processors (Universe)

[Horacio Pellegrino]

In Windows, every time a new user logs in it creates a new process. Each new
process can get a new processor. Now each process can contain several
threads but all working in the same one, unless you create some phantom
processes like the build index functions.

Horacio


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Liesse, Dave
Sent: Friday, December 28, 2007 4:19 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Server Processors (Universe)

I couldn't find anything on the IBM web site, so I'll ask the next batch
of experts.  Does anyone know whether Universe takes advantage of
multiple processors on a server?  Any difference - from a Universe
standpoint (I know there's a difference physically) - between a dual
processor and a single dual-core processor on a server?  Thanks.

Dave
---
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] Graphic Printing

[Horacio Pellegrino]

You might include raster graphics inside the spool job. We use it a lot.



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of James F Thompson
Sent: Thursday, January 03, 2008 6:43 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Graphic Printing

Does anyone have a suggestion for doing graphical printing from Windows and
Aix? I need to be able to embed dynamic images (i.e. Division logo, Shipping
label), along with form data.  We are using Universe.

James F Thompson 
Senior System Analyst 
Cypress Business Solutions 
678.494.9353 x1410

[EMAIL PROTECTED] 
www.cypressesolutions.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] SQL Server 2000 -- Connection

[Horacio Pellegrino]

If you prefer to use a built-in MS program you might try out to shell out
SQLCMD , and capture the output.



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Steve Jones
Sent: Tuesday, April 15, 2008 7:15 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] SQL Server 2000 -- Connection

I've recently start experimenting with accessing a SQL Server 2000 database
from within my UniData program.  I'm running on Windows XP SP2.  I have
modified a copy of the BCI.DEMO program delivered with my downloaded UniData
7.1 Personal Edition to point to my ODBC database.  When I attempt to
connect using the first three steps:

 

1)   SQLAllocEnv to allocate the database environment.

2)   SQLAllocConnect to allocate the connection environment

3)   SQLConnect to connect to the database, I get an error message
indicating a Status of -1 --> Error occurred.  SQLSTATE , NATCOD are:08003.

 

I've verified my ODBC resource by connecting to it from Excel.  I've also
set up an ODBC resource pointing to a UniData table and that works.

 

Can someone point me in the right direction to determine why my connection
isn't working?  Is there more I should do to prove the ODBC resource is
working correctly?

 

Thanks,

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

RE: [U2] UniVerse Triggers

[Horacio Pellegrino]

We started using triggers some months ago and so far no problems at all...
I'm interested in what kind of instability issues you came across. Please
let me know.


( We are a 370-Micro$oft Windows shop!)

Horacio Pellegrino


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes
Sent: Friday, April 25, 2008 8:02 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] UniVerse Triggers

Hello,

We have received reports that UV triggers have shown some instability. Does
anyone have anything to share on this?

We have been using them for a couple of years with no issues but were hoping
for more details from other users, if available.

Thanks much,
-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] UniVerse Triggers

[Horacio Pellegrino]

For performance, I keep the code in the triggers as light as possible. That
is no file opens and read/writes to a minimum.

Cheers!

Horacio


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver
Sent: Friday, April 25, 2008 11:21 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniVerse Triggers

I have several clients who have been using triggers for a couple of  
years with no reported issues, other than the performance hit.

Regards,

Clif

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




On Apr 25, 2008, at 11:42 PM, Horacio Pellegrino wrote:

> We started using triggers some months ago and so far no problems at  
> all...
> I'm interested in what kind of instability issues you came across.  
> Please
> let me know.
>
>
> ( We are a 370-Micro$oft Windows shop!)
>
> Horacio Pellegrino
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes
> Sent: Friday, April 25, 2008 8:02 AM
> To: 'u2-users@listserver.u2ug.org'
> Subject: [U2] UniVerse Triggers
>
> Hello,
>
> We have received reports that UV triggers have shown some  
> instability. Does
> anyone have anything to share on this?
>
> We have been using them for a couple of years with no issues but  
> were hoping
> for more details from other users, if available.
>
> Thanks much,
> -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/
---
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] uniobjects help needed!

[Horacio Pellegrino]

Do you have that problem in what exact instruction? 

Please copy & paste.

Horacio



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of doug chanco
Sent: Saturday, August 02, 2008 7:35 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] uniobjects help needed!

Hey,

We are having a problem with uniobjects that started a couple of days 
ago. We have a VB app that uses uniobjects to access an aix system 
running universe 10.1 and a few days ago we started getting errors where 
uniobjects would just die, its starting to look like it might be a 
network issue but so far nothing we can discover.

Our Cisco guy is not seeing any errors in the cisco switches, I am not 
seeing any errors on the aix system (5.2.6).

While is may or may not be a universe/uniobjects issue, so far we have 
been stumped as to what the problem is. We even called an IBM uniobjects 
engineer for several hours and he could not find a problem as neither 
could our VAR or IBM tech support for aix.

So I thought I would throw this out to youll who vast knowledge may 
hold the key to the answers we seek! The fact that in the past 3 days I 
have works close to 60 hours is a testimony to the amount of effort we 
have been putting in to try and solve this problem.

Basically what we are seeing that is

Run-TIme error '-2147417848 (80010108)':
Method 'Read' of object 'IUniFileEx' Failed

So any suggestions/thoughts/ideas/crystal balls/magic spells/voodoo 
chants are welcomed!

dougc
---
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] uniobjects help needed!

[Horacio Pellegrino]

Have you checked out if any external process ( non UV ) is using the same
file (i.e. a backup program)or has been recently been used by?

Horacio


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of doug chanco
Sent: Thursday, August 07, 2008 1:23 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] uniobjects help needed!

the drama continues . we are now getting GFE's or "BLINK" errors in some 
of our files ... while making modificatiosn to our VB app we have 
lessened the write/lockup issues now the transactions are running dog 
slow, placing an order which used to take @ 5 seconds are now taking 5 + 
minutes

I have been watching the network as as our cisco guy and we see nothing 
indicating a network issue, so now we are trying to figure out whats 
going on as placing orders from "green screens" take 5 seconds.

I have been looking at the aix error log and see no errors

this has got to be more exciting than watching "the young and the restless"

dougc



doug chanco wrote:
> Jeff Powell wrote:
>> May I add my experience here?
>>
>>   
>
> PLEASE!  We are going on day 8 (or 9 I am losing count)  with little 
> to no progress.  One thing I was wondering could it be an issue with 
> the unix memory segments "having issues"?
>
> also I am noticing what I think is a huge amount of "tcp bad checksum" 
> errors but very few rebroadcasts does anyone more familiar with 
> tcp/networks have a base line for what is "normal"  we have several 
> hundred users.
>
> Also what would happen if uvrpc ran out of licenses?
> also I am noticing that when our crappy system gets really loaded the 
> application seems to lock up more as well as take long times to 
> respond, could this be an indication of something?
>
> I wanted to say thank you to everyone (those who have responded and 
> everyone else who has not complained about the fact that this is not 
> truly a universe issue but maybe a network/socket/VB/uvrpc one)
>
> dougc
> ---
> 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] Triggers on PICK flavor of UV

[Horacio Pellegrino]

We use triggers UV w/Pick flavor and they work fine. 
Just some issues when you need to drop the trigger after moving the file.

Horacio

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman
Sent: Thursday, November 20, 2008 8:21 AM
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] Triggers on PICK flavor of UV

Which version of UV?

Triggers have only recently worked on UV files. They used to only work on
SQL-ized files.

If you're not using SQL and haven't upgraded recently you may be on a
version that's too old to support them. (And is HTTEST a type 1/19? No
triggers on them ...)

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Dallaire
Sent: 20 November 2008 15:59
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Triggers on PICK flavor of UV

Tom,
Yes they are, we use them in our Pick UniVerse system.
Mike

Michael Dallaire
Senior Applications Developer
IBM Certified Solutions Expert
Mortgage Builder Software, Inc.
[EMAIL PROTECTED]
Main:  800.850.8060 ext. 103
Fax:248.304.0601
www.mortgagebuilder.com
 Help Desk198
Confidentiality Notice
This transmission may contain confidential information which is intended for
the exclusive use of the intended recipient. Any disclosure, copying,
distribution or use of the contents by anyone other than the intended
recipient is strictly prohibited. If received in error, please reply to the
sender immediately
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds
Sent: Thursday, November 20, 2008 10:31 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Triggers on PICK flavor of UV

Does anyone know if Triggers are supported under the PICK flavor of
UniVerse.



>CREATE TRIGGER UPCASE BEFORE INSERT OR UPDATE ON HTTEST CALLING UPCASE.IT;

Statement triggers are not supported.



If they are not, does anyone know a cleaver way  around it other than
writing your own?



Thanks in advance



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

RE: [U2] [UV]Accuterm, Question of Links

[Horacio Pellegrino]

Roy:

You can print http://192.168.1.10 underlined with a PRINT command. Then
enable mouse, and make your input-inkey()... when analyzing contents of the
entered variable you can decide if they clicked on the link or somewhere
else. If they did you can execeute the code you have for your popup. 

You can even go fancier and before your popup you can reprint the link in
reverse, wait a bit then print it back as "visited" , creating the effect of
a real link.

This solution is more server-oriented. I hate having to touch AccuTerm
config.


Cheers!!

hp


-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of roy
Sent: Thursday, January 08, 2009 9:36 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UV]Accuterm, Question of Links

Has anyone been able to display a link  such as http://192.168.1.10
  or it's dns equal on an Accuterm screen and have the
user be able to click on it to get an image?

 

I can encode the url in basic and have it pop up but I want to be able to
display it and click it gui style.

 

A product called Smartterm does this without any code behind it.  Will
Accuterm do the same?

 

Thanks to the experts out there
---
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] OLEDB error

[Horacio Pellegrino]

Username has permissions to create and insert granted?

HP


-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Debra Fedchin
Sent: Wednesday, February 11, 2009 11:08 AM
To: u2-users@listserver.u2ug.org
Cc: owner-u2-us...@listserver.u2ug.org; 'u2-users@listserver.u2ug.org'
Subject: [U2] OLEDB error

ok

Can someone tell me why I got this error?

Debug: OLEDB driver: Insert SQL='SELECT BIG_01_Invoice_Date,
BIG_02_Invoice_Num, BIG_03_PO_Date, BIG_04_PO_Num, BIG_05_Rel_Num,
BIG_07_Trans_Type, Benco_Host, CTT_01_CTT_Amt, DTM_01_Date_Qualifer,
DTM_02_Date_Shipped, Date_Processed, EDI810_ID, Mailbox, N1_BT_01_Code,
N1_BT_02_Name, N1_BT_03_Qualifier, N1_BT_04_ID, N3_BT_01_Address1,
N3_BT_02_Address2, N4_BT_01_City, N4_BT_02_State, N4_BT_03_Zip,
N4_BT_04_Country_Code, TDS_01_Amount, Trading_Partner, Vendor_Num FROM
daf.EDI_INVOICE_HDR_NF_SUB WHERE (0=1)'
Error: Couldn't insert row into table 'EDI_INVOICE_HDR_NF_SUB'.
Error: Error 0x80004005: "[Ardent][UniData ODBC Driver][IBM][SQL
Client][UNIDATA]Can not insert into view EDI_INVOICE_HDR_NF_SUB"


Now -- this table was created, had SQL.CONVERT run against it, followed by
going through VSG to create both Views and Subtables, all Privileges have
been set to PUBLIC

The error states that the table is a view when in fact it is a Subtable




=
This communication (including any attachments) is intended only for use by
the
addressee(s) named herein and may contain legally privileged or confidential
information. If you are not the intended recipient or an authorized
representative of the intended recipient on this communication, you are
hereby
notified that any dissemination or distribution of this communication (or
attachments) is strictly prohibited. If you have received this communication
in error, please notify us immediately by e-mail and permanently delete the
communication and any attachments from your system.
---
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] pcl imaging question...

[Horacio Pellegrino]

In Windows you can do file-print and then select print to file. There you
most likely get a good PCL.



-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Mac Bhyat
Sent: Monday, May 25, 2009 1:03 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] pcl imaging question...

Hi,

Windows

Have you tried using gsprint
http://pages.cs.wisc.edu/~ghost/gsview/gsprint.htm

Convert the file from pcl to ps using ghostscript and print using gsprint -
supports both color and grayscale

Linux/Unix
---
Convert the file from pcl to ps using ghostscript and sent to a print (linux
printing understands ps)

I do this a lot and it works great, you can even go to pdf and back 

If you have questions, don't hesitate to ask







-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: 22 May 2009 09:05 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] pcl imaging question...

What does work for us, is the way you suggested. I use my image program
  to print to a file, then ftp the file, chop out the PJL coding.

I never really tried to make macros, But after all the emails, I might
  make a little perl printer post lpt driver to substitute a
   with the actual filedata. I never know when the printer
  gets turned on and off, and is shared by many people (imagerunner copier)
  since it's used so few times, it easier to send the image each time.

What I was asking, was more, how is the color RGB raster converted to a
raster that can be printed on a B&W printer? Is there a formulae to convert?

George

> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- 
> us...@listserver.u2ug.org] On Behalf Of Colin Alfke
> Sent: Friday, May 22, 2009 11:42 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] pcl imaging question...
>
> George;
>
>
>
> We use a product called "Forms Electric"
> http://www.visual.co.uk/formselectric.asp that converts a print file 
> into a macro. It's old and clunky - but paid for and works.
>
>
>
> Or you can edit your converted PCL file directly (or you can put the 
> graphic in a document and print it to a file using a generic HP 
> printer) and then remove any "page" type pcl commands from it so you 
> can turn it into a macro.
>
>
> It may also depend on how you're sending to the printer that's causing 
> your problem.
>
>
>
> hth
>
> Colin Alfke
>
> Calgary, Canada
>
>
> > From: George
> >
> > ok. All this talk about PCL images had me looking into this...
> >
> > I downloaded a few JPG -> PCL image conversion programs, and 
> > attempted to send them to the printer directly, after looking at the 
> > code.
> >
> > Instead of getting the image (even a b&W image), all I got was what 
> > looked like a bunch of 2D bar coding that was the size of the image. 
> > But if I view the PCL code in a PCL Viewer, it looks good.
> >
> > I'm guessing the problem is that the image was converted for viewing 
> > on the display (in RGB), but the printer is not RGB.
> >
> > Show do I convert the image from RGB PCL to PCL that I can 
> > print on the printer?
> >
> > What we wanted to do was scan an image, then convert the image to 
> > PCL, then work them into reports.
> >
> > George
>
> _
> Create a cool, new character for your Windows Live Messenger.
> http://go.microsoft.com/?linkid=9656621
> ---
> 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/


__ NOD32 4097 (20090522) Information __

This message was checked by NOD32 antivirus system.
http://www.eset.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] New user on Win2003/UV 10.2.3

[Horacio Pellegrino]

You can try the fully qualified domain name like

domain\username

in the logon prompt to let Windows know the right permissions.

Horacio



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen
Sent: Monday, May 14, 2007 8:02 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] New user on Win2003/UV 10.2.3

I just got the scare of my life: create a new active directory user on
my brand new server, then started getting calls from users unable to use
options in one account.

After some research, it turns out the creation of the new user caused
the permission of the account assigned as the user's home directory
("local path" in the login profile - the set up of a local path is
necessary for us) to be re-assigned to the new user. The old permissions
disappeared.

It seems to be a Windows 2003 issue, so this forum may not be the right
place - but if anyone has run into this and knows the fix, please let me
know.

thanks!

Laure Hansen,
City of Redwood City
Information Technology
1017 Middlefield Road
Redwood City, CA 94063
Tel 650-780-7087
Fax 650-556-9204
[EMAIL PROTECTED] 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UniVerse on SAN?

[Horacio Pellegrino]

We have a Dell Windows based UV dedicated server for 350users and I use 6
disks and 2 SANs with 10 and 12 disks each... It flies!

Horacio

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald
Sent: Wednesday, June 06, 2007 4:20 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] UniVerse on SAN?

I need  provide a customer with a few references of folks using UniVerse on
a SAN, both those who use it with the SAN dedicated to Uv, and with the SAN
being shared with other apps. Anybody using uv on SAN?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] UniVerse 11.1.9

[Horacio Pellegrino]

Turn off antivirus...

hp

On Tue, Sep 11, 2012 at 1:18 PM, Brian Leach  wrote:

> Dan
>
> Thanks! Guess I'll have to solve it myself :(
>
> Cheers
>
> Brian
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath
> Sent: 11 September 2012 18:13
> To: U2 Users List
> Subject: Re: [U2] UniVerse 11.1.9
>
> Hi Brian,
>
> Just letting you know I've checked our system and no-one has logged
> anything
> along these lines for UV 11.1.9
>
> Regards,
> Dan
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
> Sent: Tuesday, September 11, 2012 10:46 AM
> To: 'U2 Users List'
> Subject: [U2] UniVerse 11.1.9
>
> Hi
>
>
>
> Is anyone else experiencing performance problems with 11.1.9?
>
>
>
> I've just upgraded my laptop to 11.1.9 (Win7x64) and it's horribly slow,
> taking about 30 seconds to start any UniVerse process. This affects the
> initial uv.exe process, whether from cmd or telnet or UniObjects, and any
> sub-process it creates in turn e.g. running BASIC, CREATE.FILE etc.
> Anything internal e.g. LIST works fine.
>
>
>
> AV turned off, plenty of resources available, only using half my physical
> memory, standard uvconfig, nothing in any of the logs, no replication or
> transaction logging running . just a little 3 user system that I don't have
> time to pull apart.
>
>
>
> 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
>
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



-- 

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

Re: [U2] UV full screen editor

[Horacio Pellegrino]

We use EditPlus, works great for programs in Windows and Linux.



On Mon, Feb 25, 2013 at 9:04 AM, Nirvan Wijesekera <
nirvanwijesek...@hotmail.com> wrote:

>
> Hello all,
>
> I'm new to this forum, so apologies if this topic has been brought up
> before. Can anyone recommend a decent full-screen editor for Universe? I
> require it for editing source code as well as modifying data files. Seems
> like most of them can do one or the other, but not both. We do not run
> System Builder, so is there anything else available? We are trying to move
> away from the native UV line editor.
>
> Many thanks.
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



-- 

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

Re: [U2] File type 30 (dynamic)

[Horacio Pellegrino]

Dynamic files work well in most scenarios. We moved most our files to be
DYNAMIC and easy to maintain.
There could be a difference in speed but I don't believe is a game stopper.

RESIZE it when purged to remove unnecessary space.

Cheers!

HP




On Tue, Jul 9, 2013 at 12:15 PM, Scott Zachary wrote:

> I have very little experience with using dynamic (type 30) files and I'm
> looking for some pointers in that regard. I have a file that I am
> considering creating as a dynamic file. The file will be a log file with
> sequential numeric keys. The record size will normally range from about 200
> to 700 bytes, with a probable maximum size of less than 1,000 bytes. We
> expect the file to continually grow without deletions and we will likely
> purge it annually. What are the pro's and con's of creating this file as
> type 30 verses other file types?
>
> Thanks,
>
> Scott Zachary
> UniVerse Developer
> Gardens Alive! Inc
>
>
>
> --
> View this message in context:
> http://u2-universe-unidata.1073795.n5.nabble.com/File-type-30-dynamic-tp41129.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
>



-- 

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

Re: [U2] Multi-threaded phantom processing

[Horacio Pellegrino]

Why don't you have one port listening for requests, and as soon as they
come in, you create a new phantom to answer that request ( liberating the
listener immediately for the next request ), then when the phantom finishes
it could log off.

Might be you want to keep a "pool" of phantoms alive for a while, on the
assumption they might be reused. That way you are sill using one license
per request, but you have the benefit of "pooling"... You can always set
min-max limit for those phantom-workers.

Horacio Pellegrino




On Tue, Mar 4, 2014 at 11:30 PM, Peter Cheney
wrote:

> Thanks David. As they say "Bigger than Ben-Hur"!
>
> That's a great idea. The server I have is listening on a predetermined
> port. I trolled through /etc/services and a netstat on the remote host to
> select something that looked unused.
>
> So then if it the main phantom spawns 1-n children (presumably more
> phantoms?), it would also need to select 1-n ports which I suppose must
> also be predetermined? Or is there a call to the OS that can return an
> unused port? We're on AIX but the remote host is HPUX.
>
> Cheers
> Peter
>
>
>
> Peter Cheney
> Ultracs Developer
> t 07 3017 8837 | f 07 3002 8400
> e peter.che...@firstmac.com.au
> w firstmac.com.au
>
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:
> u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green
> Sent: Wednesday, 5 March 2014 13:01
> To: 'U2 Users List'
> Subject: Re: [U2] Multi-threaded phantom processing
>
> Peter, first of all let me congratulate you on this achievement.  Having
> just finished a similar feat using UniData I understand the complexities
> that went into it.
>
> The system I'm current working with will be relatively low traffic.  But I
> was pondering on the method of having a server socket that would just spawn
> a transfer server socket and send the socket address to the calling client.
>  Then the client disconnects from the main server and just uses the
> transfer server to complete the task.
>
> Having 10 open phantoms with sockets will use up 10 licenses.
>
> David A. Green
> (480) 201-7953
> DAG Consulting
>
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:
> u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney
> Sent: Tuesday, March 04, 2014 6:18 PM
> To: U2 Users List (u2-users@listserver.u2ug.org)
> Subject: [U2] Multi-threaded phantom processing
>
> Hi Everyone,
>
> A project that I'm currently working on requires transmission of
> transactional and ancillary data from one UV site to site to another.
> I have the communications all set up and it is working very well via the
> UV socket functions with a client at one end and a server at the other.
> Both the client and the server both run as a UV phantom processes written
> in UV basic and the data being transferred (also encrypted) is more or less
> real time with various UV file triggers on the client end creating queue
> items for transmission based on the data content / transaction type.
>
> This set up is a single threaded affair and I am wondering how it will
> cope and what options I'll have as the volume of data increases.
>
> Multi-threading my server process to dish out some of the load might be
> one possibility and I've seen examples in the past where the last digit of
> a numeric key (i.e. 0-9) is used to determine which one of 10 phantoms to
> call thus providing an effective distribution of the work.
>
> But even then, reading/writing processing data to a file for each child
> process seems to me to be the only way to achieve parent <-> child phantom
> communications at either end. Is there another way perhaps? It may be that
> I will need 2 sets of phantoms, 1 for the transactions and one for the
> ancillary data. Although we run UV on AIX the only other requirement is
> that I must be able to do it within UV Basic.
>
> Does anyone out there on the list know of a better way or any
> alternatives/advice so I can get a better appreciation of what else might
> be possible please?
>
> Many thanks in advance,
> Peter
>
>
> Peter Cheney
> Ultracs Developer
> t 07 3017 8837 | f 07 3002 8400
> e peter.che...@firstmac.com.au
> w firstmac.com.au
>
>
>
>  
> ---
> Note:
> This email (inc all attachments) is for the use of the intended
> recipient(s) only.
> Privileged or confidential information may be contained in this
> communication. If you have received this email in error, please notify the
> sender immediately and then delete all