Re: [U2] Web service

2013-01-17 Thread David Jordan
Hi Ruby

You need to add the service to the C# project in the add services in the same 
menu as you add references to your project.   Once it is added, it is a 
datasource that can use.  Ie you can link it to a DataGridView as an 
objectdatasource.   You can also link the update, select, insert, delete to 
methods on the webservice.

Regards

David Jordan

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


Re: [U2] U2 Database provider for .Net

2012-12-25 Thread David Jordan


David Jordan
Has anyone loaded the U2 provider for .Net into Visual Studio 2012.  I cannot 
get VS to recognise U2 as a database provider and hence cannot use it in the 
entity model.

The provider works at the text level in application code, but I cannot use it 
with any of the VS tool.s

Regards

David Jordan

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


Re: [U2] Secrets was Vinnie Smith

2012-12-20 Thread David Jordan
Will.  No one is stopping you from doing it.  We explained the problems why it 
is hard to get this list together.  But if you can put it together, happy to 
support you.

David Jordan


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


Re: [U2] Vinnie Smith

2012-12-19 Thread David Jordan
The hard part is that databases have become commodity items.  You don't buy a 
Mercedes because it has a bosh EFI unit under the bonnet.   Now days people are 
buying applications for what they are not what is under the hood.   Keeping 
that secret is a competitive advantage.

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


Re: [U2] Secrets was Vinnie Smith

2012-12-19 Thread David Jordan
Hi Will

What you are raising is the issue of internal customised U2 sites which are a 
dying breed.   The new market is applications where people buy the 
applications, not the database.   Vendors see no benefit from advertising that 
they use U2 where they get no financial benefit and they could disadvantage 
themselves.   Even Oracle based packages are talking less about Oracle.  If a 
site is Microsoft SQL Server, why get yourself knocked off the list.   The 
trend is such that Oracle is buying ERP tools to sell, because people no longer 
make decisions on Databases.  SAP is moving the customer to their purchased 
Sybase database.   The market is all moving towards applications as the 
decision making process.

George and I advertise that we run on U2 product, but many of the ISVs don't 
see any benefit.

Regards

David Jordan


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


Re: [U2] Secrets was Vinnie Smith

2012-12-19 Thread David Jordan
Hi Will

They won't look for video software on the Rocket site, they are going to look 
for solutions in trade journals and on the internet.  That is where the ISVs 
are focusing their advertising.  

With the issue about finding solutions, make contact with a local sales person 
at Rocket or one of the Distributors.  They should be able to point you to 
references.   They can give you a one off verbal, that would not be allowed if 
it went to print or the internet.   If it is published it has to go to legal, 
if it is a verbal comment made one off, it does not require legal.  That is why 
George raised it is easier to make a phone call.

 
Regards

David Jordan

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


Re: [U2] Problem with openpath in UniVerse on windows server

2012-12-11 Thread David Jordan
Has anyone had a similar problem.   Our application uses openpath to read some 
csv files from a directory on windows server 2008R2.

However a couple of sites, only the owner is able to open the directory with 
openpath, all other users fail.   Even with the users given administration 
rights, it still fails.   This is not a problem with all sites, just 2 of them.

I run into the same problem with openseq.

I tried even setting Authorisation in the program to the owner name and still 
no luck.   I am not sure what else to try.

Regards

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


Re: [U2] Problem with openpath in UniVerse on windows server

2012-12-11 Thread David Jordan
They are all running on Rel 11 on Windows 2008R2.   The file is not open by 
another application.  It is to do with the directory owner being the only one 
able to access the file.  Even the same user copying a file to that directory, 
cannot read it from UniVerse.

Regards

David Jordan

Managing Director

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


Re: [U2] Another job ad written by people who have no clue

2012-11-01 Thread David Jordan
A good CEO knows the first rule of employing.  First look at attitude, then 
capability and last experience.   When you write a resume, don't list 
experience, list your capability to pick up languages, ability to adapt and 
ability to understand the business.   It is also worth looking at how to get 
jobs a different way to the usually job markets.   Politicians spin bad news to 
good news, your competitors in the job market spin their lack of ability to win 
jobs.   Step back and look at your resume a different way.

Regards

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


Re: [U2] Another job ad written by people who have no clue

2012-11-01 Thread David Jordan
I didn't say it was easy, I am saying if you want to increase your opportunity 
change the dynamics.   You can curse and disparate the selection until the cows 
come home and it won't change a thing, you have to change the way you get the 
job interview.

Regards

David Jordan


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


Re: [U2] Chap Up, Chap Down, Chap chap chap the chapper

2012-10-15 Thread David Jordan
Chap down a user would make them miss slots in the execution queue freeing it 
up for other users.   It was a Primos option, I have never tried it outside of 
Primos and don't know if it actually works or was there for compatibility 
reasons.

Regards

David Jordan

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


Re: [U2] Variable Interpolation

2012-08-23 Thread David Jordan
I wrote one myself.   There is some capability with one of the conv commands 
but it is limited to 255character.

Regards
David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Friday, 24 August 2012 1:56 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Variable Interpolation

 From: jjuser
 Does UniBasic have a way to do variable interpolation (without
writing to
 a file, compiling it as a program, and calling it)?


Do you mean something like this?

VAL = 0
CALL @SUB FOO(X,Y);Y=X+1;RETURN( 3, VAL ) CRT VAL ; *  4

That would be Awesome! I don't believe any of the MV platforms do that because 
I've been looking for it for 15 years. It can be simulated in various ways, but 
you did limit the scope of the challenge.

I think you're trying to avoid this?:

CODE = \ CRT DATE()+20\
EXECUTE PGEN :CODE CAPTURING OUT
* OUT is 16327
In this case the PGEN program reads from TCL, writes, compiles, runs, and that 
output gets captured. But at least the mechanism for performing that task is 
abstracted from this client/application code.

Cache' allows you to enter code at TCL and then execute it without 
saving/compiling. That can also be simulated in U2. I don't think I've ever 
seen anyone else ask for it here - certainly no one willing to pay for it. ;)

Out of curiosity, what's your application for this? And please correct the 
above if I've misunderstood the question.

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] Select Statement Invalid

2012-07-11 Thread David Jordan
Have you tried putting spaces between the IDs you are selecting.

David


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


Re: [U2] [u2] Professional Development

2012-06-12 Thread David Jordan
The issue is that pick jobs are not disappearing, it is an issue that they are 
changing as in all technologies.  There is a move from internal custom 
applications to packaged solutions.  U2 sales are growing but it is in ISV 
solutions.   What is a problem is a mismatch of current skills and new demands 
for skills.

The U2UG is setting up a professional development program to help build skills, 
career opportunities and opportunities.  However we need your feedback to make 
this work.  U2 developers and sales people are professionals whse skills go 
beyond just pick code.  As a user group we want to create an environment to 
recognise that professionalism that can be put on a CV.   We are looking at how 
to expand training opportunities and keep costs down.

This is an opportunity to raise U2 experience and awareness and I look forward 
to your support in helping the user group to help its members.

Regards

David Jordan

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


Re: [U2] [UV] Program X: Line 2, WRITE failure. ( SYS.MESSAGE 040019 )

2012-06-12 Thread David Jordan
If it is an SQL table it may be a conflict with table rules.  Ie you cannot 
write multivalues to a column that is not defined as multivalue.

David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
Sent: Wednesday, 13 June 2012 6:02 AM
To: U2 Users List
Subject: [U2] [UV] Program X: Line 2, WRITE failure. ( SYS.MESSAGE 040019 )

Does anyone have a complete list of what kinds of problems will throw this 
error?

 RUN CDS.BP X
Program X: Line 2, WRITE failure.

uv\errlog:
Tue Jun 12 15:54:05  12848 cdstevenson Program X: Line 2, Message[040019]


Although I generated it here by attempting to write a record with a 
system delimiter in the Id:

01 OPEN 'CDSTMP' TO F ELSE STOP 201
02 WRITE '' TO F, 'ABC':@VM:'XYZ'

while I have UVCONFIG's param prohibiting that:

ALLOWMARKS 0

Yet, I fear there are several  sundry ways to yield up that generic 
message.
Care to contribute to the list?
___
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] training material on LOCKS

2012-05-11 Thread David Jordan
Brian

You are too generous, I am stunned at how few SQL developers understand locking.

Regards

David Jordan


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


Re: [U2] U2UG Professional Development Program

2012-04-25 Thread David Jordan
As part of the Board's deliberations on ensuring that the user group continues 
to be relevant to the needs of its members, the user group is implementing a 
professional development program from the 1st of May 2012.

Individuals who maintain professional development in other technologies such as 
Microsoft and IBM are recognised for their efforts. Their professional 
development in those technologies adds value to their resume and benefits their 
career development. 

The user group wants to create the same advantage for U2 Developers, to have 
the same recognition and benefits for building U2 skills as their peers do in 
other disciplines.

Please read the full announcement and joint letter from David Jordan and Susie 
Siegesmund on the U2UG Website. 
http://www.u2ug.net/download/LetterFromU2UGPresident.pdf 

Regards
David Jordan
President of the U2UG

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


Re: [U2] Issue with SQL Users and Active Directory

2012-03-14 Thread David Jordan
Is anyone using SQL SCHEMAS and TABLES in UniVerse in a Windows Environment 
with Active Directory.   I have an intermittent issue where SQL Users are 
suddenly not recognised and I have to grant them access again.   It is an 
intermittent problem and cannot identify what is causing it.   

Like to hear if anyone else has had similar experiences.

Regards
David Jordan


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


Re: [U2] New U2 BDT

2012-03-11 Thread David Jordan
Will
I  was pointing out eclipse gives the ability to run a tool on windows and 
linux.  The alternative is that Rocket built a tool that only runs on windows.  
Whilst I am not particularly fond of eclipse I understand the reasoning for it. 
   Similar reason why Doug uses it as a base for his tools.  Eclipse comes from 
IBM and has a number of third party development tools that can interface with 
that environment.  For U2 Developers, they have access to a free tool, the same 
for web developer, restful services, etc.   Other environments may have 
attracted a charge for the base tools the environment is built.

Whilst it is easy to knock a solution, the key is to provide a better 
alternative and at this stage I have not seen a better alternative for Rocket 
to base its tools on.

David

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Sunday, 11 March 2012 9:49 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] New U2 BDT


 What specific advantage does Eclipse give to U2 developers ?
It's a standard doesn't really impress me, unless there is something I can 
use myself, today.
I'm  not asking what BDT gives me, what does Eclipse give me.
And the ability to use BDT is not a valid argument.


 

 

-Original Message-
From: David Jordan da...@dacono.com.au
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Sat, Mar 10, 2012 10:01 pm
Subject: Re: [U2] New U2 BDT


Bill

Eclipse is a pain, but at the moment it provides a base that works for windows 
and linux offerings.  It is a standard base for Rocket tools including datavu, 
webservices, restful servives, EDA, etc.

I support David's comments that rather than putting down products, we need to 
work with Rocket in how to improve the products.   There are many opportunities 
for test tools and other development tools to be integrated with BDT that could 
help developers productivity.  However Rocket will not invest in this product 
if we constantly put it down.

It is also something as developers should look at how they manage source code.  
 
Maybe the source code that is to be edited should be taken out of a library and 
stored in a development spot which would have a local directory.

Whilst there is still work to go on BDT, it is an evolving product and 
something that makes U2 look more professional something that the community has 
had to battle with in the eyes of management and consultants

Regards

David Jordan



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org]
On Behalf Of Bill Haskett
Sent: Sunday, 11 March 2012 5:32 AM
To: U2 Users List
Subject: Re: [U2] New U2 BDT

Thanks, Doug.

Not much of a tool, especially when you have to download and install all the 
junk that goes with it!  :-(

Bill


- Original Message -
*From:* dave...@gmail.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 3/10/2012 9:55 AM
*Subject:* Re: [U2] New U2 BDT
 Hi Bill:

 After testing BDT, I'm wrong.  BDT does recognize environment variables.
   However, you cannot open or edit any files that are not DIR files.  
 So you are trying to edit an LD file and it does not let you.

 I figured this out when our editor allowed editing of those files.  So 
 there really is not a bug but a BDT feature.

 Regards,
 Doug
 www.u2logic.com
 XLr8Editor the other Eclipse editor
 ___
 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] New U2 BDT

2012-03-11 Thread David Jordan
Hi Will

Eclipse is the same interface for the U2 Web Services, the U2 Restful Services, 
the U2 xml tools, the U2 EDA tools, U2 Web Developer.   It is a common 
interface for the range of U2 products, not just BDT.  It is an IDE used by 
other technology companies to host their tools.  It also has interfaces for 
other products.  Even Microsoft has an interface for Eclipse tools to integrate 
with Azure cloud services.   

Eclipse also runs on Apple's Macintosh.   With a growing base in that market, 
Rocket can provide tools  for developers who prefer to work in that environment.

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


Re: [U2] New U2 BDT

2012-03-10 Thread David Jordan
Bill

Eclipse is a pain, but at the moment it provides a base that works for windows 
and linux offerings.  It is a standard base for Rocket tools including datavu, 
webservices, restful servives, EDA, etc.

I support David's comments that rather than putting down products, we need to 
work with Rocket in how to improve the products.   There are many opportunities 
for test tools and other development tools to be integrated with BDT that could 
help developers productivity.  However Rocket will not invest in this product 
if we constantly put it down.

It is also something as developers should look at how they manage source code.  
 Maybe the source code that is to be edited should be taken out of a library 
and stored in a development spot which would have a local directory.

Whilst there is still work to go on BDT, it is an evolving product and 
something that makes U2 look more professional something that the community has 
had to battle with in the eyes of management and consultants

Regards

David Jordan



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Sunday, 11 March 2012 5:32 AM
To: U2 Users List
Subject: Re: [U2] New U2 BDT

Thanks, Doug.

Not much of a tool, especially when you have to download and install all the 
junk that goes with it!  :-(

Bill


- Original Message -
*From:* dave...@gmail.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 3/10/2012 9:55 AM
*Subject:* Re: [U2] New U2 BDT
 Hi Bill:

 After testing BDT, I'm wrong.  BDT does recognize environment variables.
   However, you cannot open or edit any files that are not DIR files.  
 So you are trying to edit an LD file and it does not let you.

 I figured this out when our editor allowed editing of those files.  So 
 there really is not a bug but a BDT feature.

 Regards,
 Doug
 www.u2logic.com
 XLr8Editor the other Eclipse editor
 ___
 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] Hello

2012-03-05 Thread David Jordan
I set up a function to open files.   Instead of using the open file command in 
a program, I call the function.  The function first calls the fileinfo command 
to see if the file is open and then returns otherwise it opens the file and 
returns.

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


Re: [U2] Editors and environments we like to use--digression from talking about mvToolBox.

2012-02-20 Thread David Jordan
How would you do this in a GUI Editor

I can use the TCL Editor in universe to change a variable name in a 1,000 
programs in a program file by the following process. 

ED ED PROG.CHANGE

2: C/OLD.ATTRIBUTE.NAME/NEW.ATTRIBUTE.NAME/G1000
3: FI
4: LOOP 2 1000

ED BP *
.X PROG.CHANGE

There are pros and cons of both environments

David Jordan


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


Re: [U2] Editors and environments we like to use

2012-02-20 Thread David Jordan
Whilst these editors can do it to a file in the directory, they are bypassing 
the record locking within UniVerse.   

I am playing devil's advocate, that whilst there are some things easier to do 
in a Gui, there are some things easier to do in a green screen editor.  I jump 
back and forward between GUI editors and green screen editors all the time to 
take advantage of their different functionality.

Regards
David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart
Sent: Tuesday, 21 February 2012 10:02 AM
To: U2 Users List
Subject: Re: [U2] Editors and environments we like to use

I just read this article on tools and the concept of a backplane as an IDE. 
Read the article and the linked articles inside it to see that this discussion 
about X v Y is really pointless. :)

http://www.johndcook.com/blog/2012/02/17/whats-your-backplane/

David, I think most common IDEs/editors I can think of will do this type of 
universal search and replace across selected sets of files or entire directory 
trees. Most of them allow regex too which ED does not.

Cheers,
Stuart

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


Re: [U2] mvToolbox

2012-02-16 Thread David Jordan

Whilst I understand where you are coming from Doug.  I think we get too caught 
up that telnet is negative.   Microsoft had to bend to demand for a command 
line system for Windows because the tech guys said it was too slow to do things 
in Windows forms.   When I talk to Oracle databases, SQL Server database, I am 
still working with command prompt windows with some flash around them.   
Remember that easily 40% of code is still written in Cobol.  There are 
mainframes in multinationals across the world still using green screen systems 
and paying a lot of money for them.  Systems administrators across the world 
are driving unix, linux and windows systems through command prompt windows.   
The concern about telnet is more in the heads of U2 developers than in the 
customer base.

It is like the aversion to the word PICK, people are nervous about a negative 
reaction from mainstream IT.   But we have a new generation of IT people who 
have never heard of PICK, never mind having a closed mind to it.   Rather than 
getting caught up debating whether people are against telnet, we should promote 
its positives.   I have seen a company just buy a brand new cobol GL system.  
If they would buy a Cobol system, why wouldn't they buy a PICK GL.   We are our 
own worst critics.

If anyone has worked in a mainframe site and saw some of the systems they are 
working with, they would be shocked.  I think we have an incredible opportunity 
to grow U2 business in the current economic environment, if it was not for us 
tripping ourselves up by underselling U2 technology.

My 2c

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


Re: [U2] UniVerse Import XML data [not-secure]

2012-01-27 Thread David Jordan
Hi Tony
I partly agree with you.  But I should be able to process xml data in UniVerse 
far simpler than at the moment.  I should not have to read xml in one 
application, convert it to a dynamic string and then send it to 
universe/unidata, I should just be able to do it one step.   This is a failing 
of Rocket to provide suitable interfaces to unibasic.

Regards
David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Saturday, 28 January 2012 4:40 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniVerse Import XML data [not-secure]

From: John Thompson
 This is where I think languages like php get it right. 
 Their simple XML stuff makes it simple to parse even the junk you may 
 get from somewhere else.

I've commented here and blogged on this topic a number of times.
I shake my head at the pain people continually subject themselves to when 
trying to force the square peg of XML into the round hole of Pick BASIC just 
because that's the comfort zone.  There are any number of other tools out there 
specifically designed to work with XML.  If you go to many other forums, 
developers aren't focused on the XML processing.  They deftly convert to/from 
XML (and JSON) without a problem, and their questions are largely focused on 
what to do with the data.  MV professionals need to shift focus from doing 
everything within the MVDBMS to making the best use of all tools available and 
integrating the MVDBMS with whatever utility does the job that's required.  At 
the core of it, even when using external tools we convert XML to something
and that something ultimately needs to be saved in an MV structure.  
(Similarly for outbound XML.)  But if you're focused on namespaces and 
attributes then the tools you're using aren't providing adequate abstraction 
from the XML, and you might want to consider tools that convert XML to 
something else which is easier for you to use.


 The reality is, that there are a lot of sites and places out there 
 that will send you all kinds of xml, and I found that since I was not 
 proficient at massaging those non-standard feeds into what the
 U2 xml tools wanted, I just found it easier to do it another way.

Whoe - stop right there.  I tend to angle away from DBMS-oriented tools for 
processing XML, but in all fairness we can't expect any tool to behave properly 
if the data doesn't conform to standards.
No, I haven't seen a lot of sites sending all kinds of XML
that is non-standard.  If you have a trading partner that doesn't produce or 
consume industry-standard documents, you need to talk with their IT people, and 
escallate to management on both sides if you're not getting cooperation.

Respectfully, I'm guessing you're just not familiar with some of the details of 
XML, and when the U2 tools don't seem to address one of those details I'm 
guessing you're considering the document to be non-standard rather than the U2 
tools.  Again, in all fairness to the U2 team, I'm guessing this is a 
documentation issue or some lack of understanding along the way rather than any 
entity being non-standard.  If indeed the U2 tools aren't providing standard 
functionality, well, see paragraph 1 above.
:)

Good luck.

Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and 
provides related development services remove.pleaseNebula-RnD.com/blog Visit 
http://PickWiki.com! Contribute!
http://Twitter.com/TonyGravagno
NEW! http://groups.google.com/group/mvdbms/about

___
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] Redback Connection Problem

2012-01-23 Thread David Jordan
Hi John
Check beyond Redback.   Have you checked things like access to the temp 
directory.  I assume the pilot and test machines are different to the live site 
and it could be an issue of security being tied down further than on the test 
machines.

David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Tuesday, 24 January 2012 7:04 AM
To: 'U2 Users List'
Subject: Re: [U2] Redback Connection Problem

Correct.  That was part of my checking.  File pointers, catalog pointers, etc...

SPIDER command is working everywhere.

Very frustrating.

It is almost like there is something set up SOMEWHERE that says rbadmin can 
access everything except LIVE.DATA.

John


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy
Sent: Monday, January 23, 2012 2:54 PM
To: U2 Users List
Subject: Re: [U2] Redback Connection Problem

And no pointers missing in live back to eportal SFxxx files? 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Monday, January 23, 2012 11:49 AM
To: 'U2 Users List'
Subject: Re: [U2] Redback Connection Problem

Correct

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy
Sent: Monday, January 23, 2012 2:48 PM
To: U2 Users List
Subject: Re: [U2] Redback Connection Problem

I'm just throwing out some ideas, in hopes it would spark something for you or 
anyone following...

Check the global.asa in your live site one more time
1) You are setting Application(ERPAccount) = LIVE.DATA 
2) Your rgwresp has the same account, as #1
3) Before you do the oOrder.Open2 accnt,SF:oOrder,userid,passwd , you do 
accnt=Application(ERPAccount). Correct? 



Also, In your simple test page with connection test only, can you switch it to 
try and open something in the ECP module, like ECP:oOrders? Just wondering if 
you've only been using the ecp side of things so far, if it's possible you 
might be missing some pointers in live, like to SFINCLUDE or OORDER, or 
something like that



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Monday, January 23, 2012 11:18 AM
To: 'U2 Users List'
Subject: Re: [U2] Redback Connection Problem

Yes and No.

ePortal has been up and running for years.

StoreFront (the on-line ordering) has NEVER been live.  I have a due date of 
next week and tried to get it up and running over the past weekend in case I 
had issues (which I clearly did).

I do not know why Epicor coded it the way they did.
It works perfectly in TEST
It works perfectly in PILOT

I have run compare utilities against everything and cannot find any differences 
that are not intentional (like the name of the desired account, the web site, 
etc.)

The horribly annoying and confusing thing is it works in TEST and PILOT!  All 
of ePortal works cleanly until it tries to connect to LIVE.DATA.

Thanks

John


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy
Sent: Monday, January 23, 2012 1:57 PM
To: U2 Users List
Subject: Re: [U2] Redback Connection Problem

I'm guessing you're up and running on your production eportal site, and this is 
just a new method you're implementing, so the questions below are probably moot 
- but just in case

If it's something specific to the Avante account, have you verified:
1)  login paragraph in live is the same as in pilot? 
2) the workdir in your rgwresp.ini is correct path to your Avante account?
3) the port to your live.data account isn't blocked

Other than that, I haven't ever gotten anything useful out of this, but can you 
set trace and/or verbose levels in rgwresp.ini and see if you get any better 
information in the redback logs? 



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Monday, January 23, 2012 10:16 AM
To: 'U2 Users List'
Subject: Re: [U2] Redback Connection Problem

It is not returning an error to the web page at all (just the generic 500 
error message).  If I look at the server logs, it is giving a meaningless error 
stating it basically had a problem on the server and did not finish correctly.

I tracked it down to the open2 method that tried to connect to the Avanté 
account.  Everything looks good, so I am at a loss.

I build a simple web page that does nothing but attempt to make this 
connection, and if successful, give the pertinent parameters involved.  This 
works flawlessly in TEST and PILOT, but fails in LIVE.

I have a call into Epicor, and have been waiting for a call back

Re: [U2] Redback Connection Problem

2012-01-21 Thread David Jordan
Hi John

My guess is that there are security restrictions on the Live system that are 
not on the test system

Regards
David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Sunday, 22 January 2012 2:53 PM
To: 'U2 Users List'
Subject: [U2] Redback Connection Problem

I have 3 UniData accounts (LIVE.DATA, PILOT.DATA  TEST.DATA).  Each has its 
own web site (live, pilot  test).  We are using Redback (U2 Web DE).  We are 
using Epicor's Avanté backend and a HEAVILY customized version of their ePortal 
web software.  Over the past few months, I have developed code in TEST and 
moved it to PILOT for user testing.  Everything works 100% in TEST and PILOT.

Today, I loaded everything from PILOT to LIVE (UniData code, web stuff, Redback 
objects, etc.)  There are 2 ways that the web pages connect to UniData:
myCart.Open2 account,SF:oPreOrder - where
  myCart is the object
  account is the ePortal account (sister account to the Avanté account)
   and
oOrder.Open2 accnt,SF:oOrder,userid,passwd- where
  oOrder is the object,
  accnt is the Avanté account
  userid is the Redback login
  passwd is the Redback passwd

I have never been told the reason for a difference, but it works cleanly in 
TEST and PILOT , but the 2nd type of connection is failing in LIVE.  I have 
confirmed that the userid and password are correct (the same in TEST and PILOT 
since Redback is global) and accnt is the intended Avanté account.

If I do not get success over the weekend, I will be contacting Epicor for help, 
but I would REALLY like to get this working before Monday.

Any thoughts?

John






John Israel
Senior ERP Developer

Dayton Superior Corporation
1125 Byers Rd  Miamisburg, OH 45342
Office: 937-866-0711 x44380
Fax: 937-865-9182

johnisr...@daytonsuperior.com

This message w/attachments (message) is intended solely for the use of the 
intended recipient(s) and may contain information that is privileged, 
confidential or proprietary. If you are not an intended recipient, please 
notify the sender, and then please delete and destroy all copies and 
attachments, and be advised that any review or dissemination of, or the taking 
of any action in reliance on, the information contained in or attached to this 
message is prohibited.




___
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] Uniobjects and Record Locking

2012-01-08 Thread David Jordan
It is possible that design base is running a separate locking mechanism that it 
is caching.   The Uniobjects connection involves pooling where multiple user 
accesses use one UniVerse Login.  This is different to a telnet connection with 
one user per login.   If DesignBase cannot identify the process that updates as 
being the same as the one that locks the record then you could have a problem.  
You cannot identify who locked the record in a pooling environment as 10 people 
would have the same user ID, hence it has to be managed by designbase rather 
than universe.

What you are doing is pessimistic locking.   With a web based environment and 
pooling, you should be thinking optimistic locking where you only do locking at 
the time of update and compare before and after images.   If a user locks a 
record over an internet connection and then loses a connection, then that 
record can remain locked until an administrator releases it manually, this is 
why pessimistic locking is avoided in this environment.

Regards
David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Sunday, 8 January 2012 10:16 AM
To: U2 Mail List
Cc: DesignBais Support
Subject: [U2] Uniobjects and Record Locking

I'm using DesignBais and have run into an unusual problem.  When I display some 
data on a web form the dbms is contacted through UO and the returned data is 
displayed.  When I click on the [Save] button the same UO connection is used to 
contact the dbms and run whatever program is required to update the record.

In the called update program, the record is read and locked.  If it's already 
locked the program terminates and a message is returned informing the user the 
record is locked (try again).  If it's not locked the record is updated and, of 
course, the program terminates in the same manner.

Problem: if I edit the record via UniData's AE editor (LIST.READU shows a 
record lock) and try to update the record via the DesignBais form, the LOCKED 
clause is taken.  This is good.  However, after I release the record via the AE 
editor (LIST.READU now shows nothing locked), then click on the [Save] button, 
the LOCKED clause is still taken, even though no record is locked!  If I kill 
the UO connection, DesignBais will make another UO connection and all works 
fine.

So, it appears a UO connection won't release a lock under whatever 
circumstances I've happened to stumble upon.  Any ideas what causes this and 
how to work-around the problem?

Thanks,

Bill Haskett
Advantos Systems, Inc.
___
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] Uniobjects and Record Locking

2012-01-08 Thread David Jordan
Hi Bill
Where is the update program.  If it is a UniData subroutine, then UniObjects is 
not in the process.  As far as I know UniObjects has no locking process of its 
own, it uses Unidatas lock table.   I have not experienced this problem, this 
issue like this sounds like a program bug.

I would step through the logic carefully, as you may be locking the record 
twice in 2 different processes as part of the update.  Is DB doing an update 
through its application at the same time you are doing an update.   Check the 
subroutines call logic.  Check the security access, does the user have write 
access.

I suspect a process is aborting somewhere that leaves a record locked which is 
only cleared when the UniObject session is cleared.  Have you done a 
list.readu all after a record locked message has occurred, as you might 
identify the lock has occurred then.

PS did you do LIST.READU or LIST.READU ALL

Regards

David Jordan




-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Monday, 9 January 2012 6:34 AM
To: U2 Users List
Subject: Re: [U2] Uniobjects and Record Locking

David:

Thanks for the input.  This has nothing to do with DB, as the message that 
displays is generated by the update program due to the LOCKED clause being 
taken, even though there is no record locked.

We do a quasi-optimistic locking and only lock records during those few 
milliseconds where updating occurs. A record is NEVER locked until an update 
occurs, and since locks release when a program terminates (even a subroutine 
returns) we shouldn't be having such problems ( i.e. a record is never locked 
then left alone).

This is why I'm thinking it has something to do with Uniobjects.

Thanks again,

Bill


- Original Message -
*From:* da...@dacono.com.au
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 1/8/2012 1:33 AM
*Subject:* Re: [U2] Uniobjects and Record Locking
 It is possible that design base is running a separate locking mechanism that 
 it is caching.   The Uniobjects connection involves pooling where multiple 
 user accesses use one UniVerse Login.  This is different to a telnet 
 connection with one user per login.   If DesignBase cannot identify the 
 process that updates as being the same as the one that locks the record then 
 you could have a problem.  You cannot identify who locked the record in a 
 pooling environment as 10 people would have the same user ID, hence it has to 
 be managed by designbase rather than universe.

 What you are doing is pessimistic locking.   With a web based environment and 
 pooling, you should be thinking optimistic locking where you only do locking 
 at the time of update and compare before and after images.   If a user locks 
 a record over an internet connection and then loses a connection, then that 
 record can remain locked until an administrator releases it manually, this is 
 why pessimistic locking is avoided in this environment.

 Regards
 David Jordan

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill 
 Haskett
 Sent: Sunday, 8 January 2012 10:16 AM
 To: U2 Mail List
 Cc: DesignBais Support
 Subject: [U2] Uniobjects and Record Locking

 I'm using DesignBais and have run into an unusual problem.  When I display 
 some data on a web form the dbms is contacted through UO and the returned 
 data is displayed.  When I click on the [Save] button the same UO connection 
 is used to contact the dbms and run whatever program is required to update 
 the record.

 In the called update program, the record is read and locked.  If it's already 
 locked the program terminates and a message is returned informing the user 
 the record is locked (try again).  If it's not locked the record is updated 
 and, of course, the program terminates in the same manner.

 Problem: if I edit the record via UniData's AE editor (LIST.READU shows a 
 record lock) and try to update the record via the DesignBais form, the LOCKED 
 clause is taken.  This is good.  However, after I release the record via the 
 AE editor (LIST.READU now shows nothing locked), then click on the [Save] 
 button, the LOCKED clause is still taken, even though no record is locked!  
 If I kill the UO connection, DesignBais will make another UO connection and 
 all works fine.

 So, it appears a UO connection won't release a lock under whatever 
 circumstances I've happened to stumble upon.  Any ideas what causes this and 
 how to work-around the problem?

 Thanks,

 Bill Haskett
 Advantos Systems, Inc.
 ___
 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

Re: [U2] Uniobjects and Record Locking

2012-01-08 Thread David Jordan
Hi Bill

You cannot assume the exit of a subroutine clears locks.   The way DB works, I 
suspect that DB has a worker program that calls routines.  If that worker 
program does not stop then locks may not be cleared.   When you restart UO you 
are only then clearing a persistent lock.  Also check that the locked message 
is from the routine you think it is.  I don't know your code, I am just passing 
issues I have seen in the past.  Do you have triggers doing an update.

It sounds like a lock from a previous step has not cleared.   Put a RELEASE 
statement in the routine before it exits and see if that helps.

Regards
David Jordan


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


Re: [U2] NEWVERSION

2012-01-03 Thread David Jordan
This is not my experience.   Check that it is not put in shared memory.  Also 
double check the voc item is pointing to the right source code.   Also check 
that the uniobject application is logging into the same account that you 
catalogued the program, I have seen programmers leave behind a redirection hard 
coded in the application or a divert to another account is occurring somewhere. 
  I have even had dumb moments of actually logging into the wrong account at 
the end of the long day where we had multiple test environments and wondering 
why nothing had changed.

Regards

David Jordan

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


Re: [U2] MS-SQL Question

2011-12-28 Thread David Jordan
You should be able to just use PID in the where clause.

David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, 29 December 2011 2:51 AM
To: U2 Users
Subject: [U2] MS-SQL Question

I'm querying a sequel server , I have a column in one table that the data is in 
the form of X|Y|Z.

I have the following in my SELECT:

substring(colname ,charindex('|',colname)+1, charindex('|',colname, 
charindex('|',colname)+1) - charindex('|',colname) -1) as PID

Is there anyway that I can then use the PID designation  in a where clause, 
without having to retype the string again?


I can't add a virtual column to the table , and I can't add a procedure either.

___
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] MS-SQL Question

2011-12-28 Thread David Jordan
You created PID as a synonym in the SELECT statement, you should be able to use 
it in the where clause.  I am sure I have done that before in the past with SQL 
Server.

Regards

David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, 29 December 2011 7:09 AM
To: U2 Users List
Subject: Re: [U2] MS-SQL Question

That didn't work because it is not a virtual column defined in the table 
layout. What I did was Created a variable in my program that contained the full 
string, and when I was creating the SQL String to pass to the server, I used 
the variable name instead.

It worked in the sense, I didn't have to retype the string multiple times, but 
the SQL query that Was passed to the MSSQL machine did have it multiple times 
still, but at least it's more manageable
From a programming standpoint, where I only have to make changes to one spot.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan
Sent: Wednesday, December 28, 2011 3:04 PM
To: U2 Users List
Subject: Re: [U2] MS-SQL Question

You should be able to just use PID in the where clause.

David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, 29 December 2011 2:51 AM
To: U2 Users
Subject: [U2] MS-SQL Question

I'm querying a sequel server , I have a column in one table that the data is in 
the form of X|Y|Z.

I have the following in my SELECT:

substring(colname ,charindex('|',colname)+1, charindex('|',colname, 
charindex('|',colname)+1) - charindex('|',colname) -1) as PID

Is there anyway that I can then use the PID designation  in a where clause, 
without having to retype the string again?


I can't add a virtual column to the table , and I can't add a procedure either.

___
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] Is there any ORM's for Universe. NHibernate, Entity Framework etc

2011-12-22 Thread David Jordan
What I would like to see is that U2 builds stronger interface between UniBasic 
Subroutines and DataSets/entity frameworks.   The current methodology is to 
create a 3 tier environment with a database server, an application server and a 
client server where U2 is just a simple data server.   If you use U2 as the 
data server and the application server, you have greater ability to take 
advantage of the performance benefits of multivalue databases and you simplify 
the transaction process and disaster recovery.   ORMs work with stored 
procedures, so why not subroutines.

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


Re: [U2] Graph DataBase

2011-12-18 Thread David Jordan
There is a dozen ways to achieve the same types of scalability.   Moving to a 
cloud environment, I am dealing with vm machines where the vm machine can be 
increased and reduced In memory and disk by software, not hardware.  It changes 
the thinking again.   There are techniques to spread U2 databases across 
multiple machines.   The issue is also a question of what is the bottleneck, 
read/write or the transformation process.   With U2 you could run multiple 
servers with multiple web servers handling the transaction process, that then 
sends data to another server for read/write.   But the other issues are the 
handling of transaction controls, rollback recover, backup.   

I believe that the next few years with cloud computing, people are going to 
have to change the way they think about systems design.   No one has a magic 
answer even the new NOSQL databases.  I think software design and techniques 
are more critical than having a database to automate the process through 
techniques like sharding.  The issue with licensing, Rocket is already working 
on providing alternative methods of licensing.  If there is a different way you 
want to do licensing, talk to them, they may be able to find a solution to 
accommodate or they may look at new licensing techniques.

The question to ask, would you be happy to have your banking transactions run 
on some of these NOSQL Databases, would they pass scrutiny of regulators and 
auditors for disaster recovery, security, etc.  These are the areas that are 
concerning mean, not the technology.

David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Monday, 19 December 2011 12:11 AM
To: 'U2 Users List'
Subject: Re: [U2] Graph DataBase

Scaling means more than just 'can it cope with so many million hits per 
minute', it is about the ability to easily scale upwards and downwards 
according to demand. Sure I can get a big box with 32 processors 128 gig of ram 
etc and it will perform impressively, but what if the business plan is to 
double demand for the next three months - will that cost me half a million for 
another massive box?  Typical 'scalable' databases can be clustered or sharded 
across multiple low spec machines, so scaling up requires the addition of 5 or 
10 new commodity servers into the cluster.
Both the technology built into the database, and their licencing schemes make 
this a very easy operation. Running multiple u2 servers in read write formation 
is very difficult and expensive 



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan
Sent: 17 December 2011 05:40
To: U2 Users List
Subject: Re: [U2] Graph DataBase

I have to pick you up on scaling.  U2 scales really well there are some 
staggering performance test that have been done.  U2 does things
differently, but it does scale.   An area that NOSQL databases are not
demonstrating in what I have looked at, is the transactional processing and 
security that a commercial database requires.  It is not to say that Rocket 
does not have some work to do in some areas, but I don't get that something new 
is the be all and end all and that something that is mature is outdated.
I like to try and get the best out of both.

David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of DavidJMurray
(mvdbs.com)
Sent: Saturday, 17 December 2011 1:38 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Graph DataBase


I also, to some extent, agree with Dawn.

The mv, NF**2, post relational, PICK, or whatever the correct model name is, it 
is not a relational database. There are very strict definitions to a relational 
database, namely, but not complete, normalisation, SQL, joins etc.

Yes, the mv model can emulate a relational database. But, it you throw away the 
dict part of a file, the data is actually in a form of a document.

And, if you go way back to the definition of a database model created for 
analysis - Entity-Relationship by Chen in the early 1980's, the mv model is 
very close to the ER model. So, if you add back the dictionaries, the database 
model could be a DDERDBMS - Dictionary Driven Entity-Relationship Data Base 
Management System.

Anyway, whatever mongoDB classify themselves as, so should the PICK model.

But then, U2 is not that well known, as it is not marketed to end users per se. 
It is an embedded database for VAR's. The focus is on the application, not the 
underlying database. This could be seen as a problem in some markets. So, it 
could be seen to be lost energy promoting the database to end users or 
developers within the nosql market as U2 is not open source, hence costs money, 
does not scale that well (sharding and/or federation) and is not really for 
high volume loads within a web service delivery

Re: [U2] Graph DataBase

2011-12-16 Thread David Jordan
I have to pick you up on scaling.  U2 scales really well there are some 
staggering performance test that have been done.  U2 does things differently, 
but it does scale.   An area that NOSQL databases are not demonstrating in what 
I have looked at, is the transactional processing and security that a 
commercial database requires.  It is not to say that Rocket does not have some 
work to do in some areas, but I don't get that something new is the be all and 
end all and that something that is mature is outdated.  I like to try and get 
the best out of both.

David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of DavidJMurray 
(mvdbs.com)
Sent: Saturday, 17 December 2011 1:38 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Graph DataBase


I also, to some extent, agree with Dawn.

The mv, NF**2, post relational, PICK, or whatever the correct model name is, it 
is not a relational database. There are very strict definitions to a relational 
database, namely, but not complete, normalisation, SQL, joins etc.

Yes, the mv model can emulate a relational database. But, it you throw away the 
dict part of a file, the data is actually in a form of a document.

And, if you go way back to the definition of a database model created for 
analysis - Entity-Relationship by Chen in the early 1980's, the mv model is 
very close to the ER model. So, if you add back the dictionaries, the database 
model could be a DDERDBMS - Dictionary Driven Entity-Relationship Data Base 
Management System.

Anyway, whatever mongoDB classify themselves as, so should the PICK model.

But then, U2 is not that well known, as it is not marketed to end users per se. 
It is an embedded database for VAR's. The focus is on the application, not the 
underlying database. This could be seen as a problem in some markets. So, it 
could be seen to be lost energy promoting the database to end users or 
developers within the nosql market as U2 is not open source, hence costs money, 
does not scale that well (sharding and/or federation) and is not really for 
high volume loads within a web service delivery environment.

It's a good solid product for well established actively-promoted vertical 
market applications which need to extend to the surrounding I.T. ecosystem.


Dawn Wolthuis wrote:
 
 I do disagree with this. If neo4j meets the not-determined criteria 
 (except by marketing departments) then MV products do too. MV  vendors 
 might have suggested they are relational at varying points in their 
 history (again marketing depts) but they do not meet Relational or at 
 least SQL-only DBMS criteria. We are very much in the not-SQL-only 
 camp whether we proclaim it or not. No product in that mix does 
 everything. I put Tom del's nodal logo on a blog entry in 2006. It is 
 someone in the MV space that has the nodal domains. We are NoSQL, no 
 doubt, but we can decide to stay in our MV sandbox rather than joining 
 the game if we so choose. --dawn
 
 
 


-

Learn and Do
Excel and Share


http://mvdbs.com http://mvdbs.com
--
View this message in context: 
http://old.nabble.com/Graph-DataBase-tp32982649p32989774.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


Re: [U2] Universe and SQL

2011-12-10 Thread David Jordan
You can use BCI and it works effectively.  You can write basic programs to 
select and update data on other databases.   EDA is another option where you 
could treat an RDBMS as if it were a UniVerse file.

Regards

David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Saturday, 10 December 2011 8:25 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Universe and SQL


I see a lot of stuff on Universe accessing it's own files as SQL tables, and 
also on how you can use OLE to access Universe tables using SQL.

But can Universe, access SQL tables which are *not* in Universe?
They are just other SQL tables in other places around the network that usually 
is update by other non Pick software.

Can Universe also access those tables?

___
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/NT default login account

2011-12-09 Thread David Jordan
Hi Kathleen
Try any directory.  You will run into a problem with UAC in Windows and will 
have to set it to the lowest security level and then reboot.  Then try changing 
the directory and see if that works.

Regards
David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kathleené M Hunter
Sent: Saturday, 10 December 2011 6:14 AM
To: 'U2 Users List'
Subject: Re: [U2] UniVerse/NT default login account

In UniAdmin I have the option set to ANY UV ACCOUNT, tried it as UV HOME and it 
still did not work.  On the window user account the profile has all the path 
blank.  Is there any way to know where it is getting this path from.
The only Admin user can log on because you have to enter a path. Everyone else 
is going to who knows where. I cannot make every user an Admin user.  




-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan
Sent: Wednesday, December 07, 2011 4:01 PM
To: U2 Users List
Subject: Re: [U2] UniVerse/NT default login account

Hi Kathleen
The uniadmin telnet area is where you resolve this.  It is currently pointing 
at their login directory on windows.  You have options to change to
login into particular uv.account, or directory.   There can be a problem
here with Windows UAC that inhibits this from working properly.  Are you 
getting a permissions error when you access the telnet menu in uniadmin.

Regards
David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kathleené M Hunter
Sent: Thursday, 8 December 2011 9:57 AM
To: 'U2 Users List'
Subject: Re: [U2] UniVerse/NT default login account

We use wIntegrate to telnet to the server. The UniVerse logon prompt appears, 
the user logins in and enter their password. Then the message This directory 
is not set up for UniVerse... Y/N. No matter what the user answers it logs 
them off. 



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Wednesday, December 07, 2011 12:53 PM
To: U2 Users List
Subject: Re: [U2] UniVerse/NT default login account

Kathleene:

When you say ...does not work, what does that mean?  With networking all 
kinds of things are happening and isolating the problem is imperative.

For instance, in order for anyone to log into our UD server, running on Windows 
2008 R2, they need to have a Windows user and be a member of the appropriate 
group(s) (those given to the dbms directory).  Active Directory adds a level of 
abstraction, but you should be able to create a simple domain user who has 
access to the machine.  Anyway, once the user is created and they're a member 
of the same group that the dbms directory gives full
privileges to, then you should be able to log in to the UV account (I can in 
UD).  When I make a telnet connection I should be able to see the UV login 
prompts.  This is also where problems might arise; if you can't see the UV 
login prompts your problems are prior to the user/group and UV login issue.

So, I guess my question is; can you be more specific regarding your problems?  
e.g. what appears, what you've tried, what were the results, etc?

HTH,

Bill


- Original Message -
*From:* kmhun...@resolutionprovider.com
*To:* 'U2 Users List' u2-users@listserver.u2ug.org
*Date:* 12/7/2011 12:35 PM
*Subject:* Re: [U2] UniVerse/NT default login account
 Tried this and it does not work

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill 
 Haskett
 Sent: Wednesday, December 07, 2011 12:22 PM
 To: U2 Users List
 Subject: Re: [U2] UniVerse/NT default login account

 Open up UniAdmin and log into the server.  Go to Network Services, 
 then Telnet Server.  Select the Users tab then edit the DEFAULT
 user.  Set the Startup Directory to what you want then save by 
 clicking [Ok] (a couple of times).

 If users aren't logged in, try looking at their permissions.  We 
 restrict permissions to our U2 dbms directories, so not everyone can 
 log
in.

 HTH,

 Bill

 --
 --
 - Original Message -
 *From:* kmhun...@resolutionprovider.com
 *To:* 'U2 Users List'u2-users@listserver.u2ug.org
 *Date:* 12/7/2011 12:12 PM
 *Subject:* Re: [U2] UniVerse/NT default login account
 On the new box when I created the account I pick ones as my default
 account.
 If there is someplace else let me know.  But my users are still not 
 being placed there. When a user logins into the new server, it states 
 that This directory is not set up for UniVerse. SO I do not fine 
 know where they are being placed.  All administrators are prompted 
 for the account

Re: [U2] UniVerse/NT default login account

2011-12-07 Thread David Jordan
Hi Kathleen
There are options in uniadmin under the telnet menu that have default login 
options.
Regards
David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kathleené M Hunter
Sent: Thursday, 8 December 2011 6:57 AM
To: 'U2 Users List'
Subject: Re: [U2] UniVerse/NT default login account

I believe that it is a register entry on the server that but I am on virtual 
windows 2008 server with UniVerse 10.3.10.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kathleené M Hunter
Sent: Wednesday, December 07, 2011 11:54 AM
To: 'U2 Users List'
Subject: Re: [U2] UniVerse/NT default login account

Not sure. Is there a way in the UV.LOGINS not to list ever user that will be 
login but a default one so that if the user is not listed that it does to that 
one.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Wednesday, December 07, 2011 9:48 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniVerse/NT default login account


Do you mean the UV.LOGINS file in the UV account ?
That lists, for each login, what path (universe account) they will go into when 
they log in



-Original Message-
From: Kathleené M Hunter kmhun...@resolutionprovider.com
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: Wed, Dec 7, 2011 9:43 am
Subject: [U2] UniVerse/NT default login account


Can anyone tell me where identify the default login account for all users hat 
log into UniVerse.
 am setting up a new server and the old server it working fine. All the ser 
login in with wIntegrate, there is no users in the telnet services isted, plus 
the user on the domain has no default path listed.
Thank you,
athleené

__
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

___
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] Cloud Legal Question - and a request for Contact Info - IT Legal Issues

2011-11-30 Thread David Jordan
Something people do not understand with many cloud applications.  When they say 
multitenant, that means that I have 1 table per function for all clients.   So 
my customer file would have a key client.no*customer.no, my parts file would be 
client.no*part.no and so on.

How client 1 sees only client 1 data is dependent on the software selecting 
client 1 from each table.   You cannot secure a database on the basis of an 
index, so client 1 and client 2 have the same access to the database and depend 
on security written in the program.  

You can then understand why the contract has such a term on it.

Regards

David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
Sent: Thursday, 1 December 2011 8:25 AM
To: U2 Users List
Subject: [U2] Cloud Legal Question - and a request for Contact Info - IT Legal 
Issues

The company I work for is looking at a product that stores a bunch of our
sales data in the cloud

Our internal legal person had a look at the contract that the company is 
proposing and apparently it has a little clause in their that they are not 
liable if the data gets stolen.
Is this standard with cloud products?

Also, I remember some folks at Spectrum talking about this, and I still have 
the business cards, but, I am not in the office, AND I foolishly forgot to 
store them in my contacts.

Susan J., I think you probably talked about this?
Maybe I can have my legal person fill out a contact form on your site?

(sj+ dot com)


--
John Thompson
___
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] AD Re: Converting an account from UniVerse to UniData AD

2011-11-25 Thread David Jordan
Hi Dave 
I am almost finished, but I am glad there is something out there for the next 
time I do a conversion.
Regards
David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Taylor
Sent: Saturday, 26 November 2011 6:57 AM
To: U2 Users List
Subject: [U2] AD Re: Converting an account from UniVerse to UniData AD

Hi David,

AD

Sorry I missed your inquiry last week.

We developed a product called File Caddy that consists of two programs, 
TAPE.DUMP and TAPE.LOAD.

TAPE.DUMP performs a series of T-DUMPs from a source database and TAPE.LOAD 
performs a series of T-LOADs onto the target database from the t-dumps on tape.

You can specify either one or more specific files to dump or all the files in 
an account, including the VOC.  Both the DICT and DATA sections of each 
selected file are dumped and then loaded.

The necessary characteristics of each section of each file are stored in the 
label of  the T-DUMP so that the file can be automatically recreated on the 
target database if it does not exist at the time of the T-LOAD.

These programs use any tape media that are the same type of media (eg. QIC, 
virtual tape, etc) on both databases and that support the T-DUMP and T-LOAD 
commands on both databases.

I 'll be glad to send you more detailed information if you think this might 
help.

AD/

Best regards,

Dave

Dave Taylor
Sysmark Information Systems, Inc.
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: David Jordan da...@dacono.com.au
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Tuesday, November 15, 2011 1:05 PM
Subject: [U2] Converting an account from UniVerse to UniData


 Does anyone have experience converting a UniVerse account to UniData.  I
 have used the UV_RESTORE.  It creates the files but does not copy the
 data.

 Regards

 David Jordan
 ___
 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] UniVerse to UniData Conversion

2011-11-24 Thread David Jordan
I am converting some UniVerse code to UniData.   The UniVerse code has a 
COMPARE function for comparing strings rather than just an = to handle some 
quirks about string comparisons of numbers.

Is there an equivalent in UniData.

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


Re: [U2] Code Collaboration

2011-11-17 Thread David Jordan
The U2UG board has been discussing with Rocket how to encourage excitement that 
U2 is not legacy but is a technology leader.  I was at a presentation of a U2 
VAR and they demonstrated product that would be indistinguishable from any 
other player in open systems, Service architecture, interoperability, web 
intefaces, etc.  How do we get this across to the market.

With collaboration, we need to first excite.   How do we excite people in U2 
technology.   Is it looking at a major enhancement of the BASIC programming 
language or a new one within U2.  What other things do we look at.

Currently young programmers are excited by web technology's, mobile apps, the 
sexy stuff.  They are not interested in the backend, whether Oracle RDBMS, SQL 
Server or U2.  This is a problem across the industry.

The board of the user group are interested in areas to look at and how to 
create infrastructure to make this happen.   If we can reignite excitement in 
the product and create a place for collaboration where that excitement can be 
put to good use then I believe we can achieve success.  However our success 
depends on a group of people not a few individuals.   If this is to occur, it 
is time for people to become involved in shaping a future.

Regards
David Jordan
VP U2UG
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Cloud Collaboration

2011-11-17 Thread David Jordan
I have had discussions with Rocket on running UniVerse on Azure and I have been 
experimenting with running UniVerse on Azure.   I believe Rocket was setting up 
a project to look at it, but have not heard anything more.

Regards
David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Friday, 18 November 2011 9:26 AM
To: U2 Users List
Subject: Re: [U2] Cloud Collaboration

I do not have a clear picture on where the Rocket is going regarding Cloud 
Computing.

Is the Rocket so far out in space that... there are no clouds?

Is the Rocket on the launch pad... waiting for an Azure-blue sky?

--Bill

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan
Sent: Thursday, November 17, 2011 3:55 PM
To: U2 Users List
Subject: Re: [U2] Code Collaboration

The U2UG board has been discussing with Rocket how to encourage excitement that 
U2 is not legacy but is a technology leader.  I was at a presentation of a U2 
VAR and they demonstrated product that would be indistinguishable from any 
other player in open systems, Service architecture, interoperability, web 
intefaces, etc.  How do we get this across to the market.

With collaboration, we need to first excite.   How do we excite people in U2 
technology.   Is it looking at a major enhancement of the BASIC programming 
language or a new one within U2.  What other things do we look at.

Currently young programmers are excited by web technology's, mobile apps, the 
sexy stuff.  They are not interested in the backend, whether Oracle RDBMS, SQL 
Server or U2.  This is a problem across the industry.

The board of the user group are interested in areas to look at and how to 
create infrastructure to make this happen.   If we can reignite excitement in 
the product and create a place for collaboration where that excitement can be 
put to good use then I believe we can achieve success.  However our success 
depends on a group of people not a few individuals.   If this is to occur, it 
is time for people to become involved in shaping a future.

Regards
David Jordan
VP U2UG
___
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] Code Collaboration

2011-11-16 Thread David Jordan
I am not sure what you are talking about David

You can buy a copy of U2 and PE allows development.  Rocket has to earn income 
or there will be no U2, so they do realistically expect commercial operations 
to pay for licenses.  For developers developing code there is a range of 
options, talk to Rocket.

Any code that is written does not belong to Rocket, Rocket licenses the 
software that it runs on not the code that is developed on it.   Source code 
licensing and copyright is related to the person who writes the code or the 
employment contract around that developer.

I see no difference in using Pick to using Oracle, DB2, Microsoft software.  
The same restrictions, licensing and copyright apply across the board and are 
not unique to Pick/U2.

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


Re: [U2] [UV] Suppress not found in RetrieVe

2011-11-15 Thread David Jordan
Hi Perry
You could use transaction control, where you prevent deletes until the report 
is completed.  For instance a GL report with Debits and Credits need to 
balance, you cannot allow the database to change in the middle of the report, 
so you wrap transaction control around to prevent updates until the report is 
complete.

David Jordan

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


[U2] Converting an account from UniVerse to UniData

2011-11-15 Thread David Jordan
Does anyone have experience converting a UniVerse account to UniData.  I have 
used the UV_RESTORE.  It creates the files but does not copy the data.

Regards

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


Re: [U2] [UV] uvcs Memory leak problems on 11.1.3

2011-11-14 Thread David Jordan
That triggered a memory.  If you are using an older version of uniobjects in 
the .Net you can get memory issues when you upgrade the database.   Have a look 
at upgrading the uniobject .Net to the lastest release.

Regards
David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Monday, 14 November 2011 8:27 PM
To: 'U2 Users List'
Subject: Re: [U2] [UV] uvcs Memory leak problems on 11.1.3

On unidata I have had to process many an xml file outside of the DB as the 
memory just shoots right up

If you are using uniobjects then I presume you have .net or java at the front 
end and it is likely that these environments are better suited to 'handling' 
the xml and simply passing data arrays to the universe layer to work on.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jacques G.
Sent: 11 November 2011 20:05
To: U2 Users List
Subject: Re: [U2] [UV] uvcs Memory leak problems on 11.1.3


Hello,

In order to save connection time on Uniobjects API requests, I came up with an 
Api which could contain several XML requests into one,  Process each one in the 
requested order and return the answer of each request in the resulting XML 
request.

On Universe 10.2.11,  the API runs anywhere from 10 to 50 requests in a batch 
like this taking no more than between 45 and 59 megs of ram on a HP-UX server.


Starting with Universe 11.1.3, doing far fewer requests  (ei from 5 to 9) the 
memory requirements go up as high as 100 to 122 megs of Ram on a HP-UX. 
Somewhere it looks like Universe's XML generation routines are gobbling up 
memory and this memory is not getting freed. It seems that many memory 
leaks were fixed from 10.2.1 to 11.1.3 according to the release notes but a 
huge new one was introduced.  

I know of the memory used by the process because I have a job which produce the 
output of the top command once a minute,  so the memory used by a process 
extracted from the output of the top command and logged.

Has anyone else experienced anything like this ?

Jacques G.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
-
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1411 / Virus Database: 2092/4010 - Release Date: 11/11/11

___
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] Using EDA

2011-11-13 Thread David Jordan

Has anyone got experience in using EDA to push data onto an RDBMS.   We need to 
do this for tender reasons, not practical reasons.

I get an error message when verifying the data that there is a problem with 
converting from varchar to float, but there is nothing about which attribute is 
impacted.  I actually suspect that it is related to a multivalue field, where 
it is taking the @VM as being text instead of treating it as a multivalue 
column.

The documentation is light on converting attributes with multivalue fields.  I 
would appreciate anyone's comments on the best approach to tackling Multivalue 
columns as I cannot seem to get this working correctly.

Regards

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


Re: [U2] How to fnuxi a SQL table

2011-11-03 Thread David Jordan
Hi Mark

I am sure I have fixed SQL Tables from uniadmin without any problems.   
Sometimes there are conflicts in schemas, you would use VERIFY.SQL SCHEMA 
schema FIX in other times, however I am not sure that will work for UV_TABLES 
in the UV account.   You may also be running into an issue of SQL permissions 
above directory permissions.  

David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood
Sent: Friday, 4 November 2011 8:53 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] How to fnuxi a SQL table

UV 10.0.13 on RH8.0

 

I tried to create a Trigger on a UV file, but got an error telling me to fnuxi 
the UV_TABLES file.

But when I try to fnuxi it, I get another error saying it's an SQL file and may 
not be fnuxi'ed. Details Below.

Any ideas how I can fix the UV_TABLES file?

 

Note; this system has been running for 10+ years, and may have migrated from 
different hardware as some point

 

Thanks,

Mark

 

 

 

CREATE TRIGGER TEST BEFORE INSERT OR UPDATE OR DELETE ON VS FOR EACH
ROW CALLING 'VS.TRIGGER';

?Byte-swapped magic number in operating system file 
/adv/uv/sql/catalog/UV_TABLES, use fnuxi /adv/uv/sql/catalog/UV_TABLES to 
convert.

UniVerse/SQL: Unable to open UV_TABLES.

 

 

ED VOC UV_TABLES

3 lines long.

: L22

0001: F

0002: /adv/uv/sql/catalog/UV_TABLES

0003: /adv/uv/sql/catalog/D_UV_TABLES

Bottom at line 3.

: EX

 

SH

$ cd /adv/uv/sql/catalog

$ /adv/uv/bin/uv

UniVerse Command Language 10.0

(c) Copyright IBM Corporation 2001. All rights reserved.

catalog logged on: Tue Jul  5 08:15:29 2011

 

LIST UV_TABLES

Byte-swapped magic number in operating system file 
/adv/uv/sql/catalog/UV_TABLES, use fnuxi /adv/uv/sql/catalog/UV_TABLES to 
convert.

Unable to open UV_TABLES file.

 

SH

$ /adv/uv/bin/fnuxi UV_TABLES

Processing 'UV_TABLES'.

File 'UV_TABLES' is an SQL file and may not be fnuxi'ed.

$

___
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] LIST.READU EVERY's waiters when there are writes w/o explicit readu.

2011-10-30 Thread David Jordan
Hi Charles
Just a thought.  When you ED VOC Dummy, you are creating a new record, where 
you are locking the Key to not be used by another process rather than locking 
the record.   I am not sure where the locks are on the file system, but I 
wonder if Dummy already existed before you edited, whether this would be 
different.  Also it would be worth test the difference of using READL and READU.
David

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
Sent: Sunday, 30 October 2011 10:22 AM
To: Charles Stevenson
Cc: U2 Users List
Subject: Re: [U2] [UV] LIST.READU EVERY's waiters when there are writes w/o 
explicit readu.

I hate to bring it up after 50+ responses over 4 days,  but . . .

Did anyone ever actually run my little test?

On something other than my UV10.2/Win?  Unix?  Before UV10.2?

Knowing that would help me assess the size  age of our problem.

I still think that in times past, a waiterfor a lockvia WRITE or DELETEwould 
show up at the 3rd section of LIST.READU EVERY, even as the typical READU (or 
FILELOCK, RECORDLOCKU) does.


The original test was request was this:


On 10/24/2011 4:11 PM, Charles Stevenson wrote:
 UV 10.2.10 on Windows is behaving differently from what I recall.
 Are my expectations out of line?

 Suppose Session A holds a readu lock; and Session B attempts a WRITE 
 to same record withOUT!!! 1st explicitly getting the readu lock.
 Session B waits for Session A to release the lock before writing the 
 record.

 While Session B is waiting,  does it show up as a waiter in 
 LIST.READU EVERY?
 I expected so,  but it doesn't.


 Session A   Session B
 _   ___
 1A. ED VOC DUMMY
(this sets the readu lock.)

 2A. (stay in editor)2B. run this:
 01:OPEN 'VOC' TO F ELSE STOP
 02: ***READU REC FROM F, 'DUMMY' 
 ELSE NULL
 03:WRITE '' TO F, 'DUMMY'

 3A. Within ED:
 XEQ LIST.READU EVERY


 If I UN-comment line 2, LIST.READU EVERY shows something like this:

 Active Read Waiters:  Owner   Waiter
 Device  Inode Userno  Userno
 746117947232860913  61163396


 But when I comment out line 2, LIST.READU is silent.
 I have not yet explored what the deadlock daemon does.

 TIA,
 cds


 P.S. Yes, yes, Bad Form, Legacy Software, 20 min wait is 
 configurable, . . . we can talk later.

Later is already past.  I'm not talking about that P.S. again!
thank-you,
cds
___
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] DataVu

2011-10-24 Thread David Jordan
The cost is a fraction of Cognos and DataVu provides more development 
functionality.  You also don't have the cost of adding an SQL Server database 
and work to copy from UniData to the SQL Server that you would normally do with 
a Cognos environment.   There is a development license and web based licenses 
for users to access the reports.

I am not experienced with MITS, but from my knowledge MITS first role is to 
develop a data warehouse and then has reporting facility against the 
datawarehouse.  It may not be the right tool if you are not building a data 
warehouse, however I may not be correct in that assessment.

DataVu is a tool that allows users to develop visual dashboards and reports 
from working data rather than data warehouse database like Cognos depends on.  
However it would make life easier to probably set up a separate account that 
you put reporting data into.   

The product is not so much a matter of learning how to use, but about getting 
your head around how to use it which is no different to other products.

DataVu provides flexibility to achieve functionality at a low cost.  It 
resolves a problem that most sites have of giving users more access to querying 
data themselves.

Regards
David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin
Sent: Tuesday, 25 October 2011 3:25 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] DataVu





Does anyone have solid experience with this product yet?  I am particularly 
interested in the license costs for a Unidata environment and some sense of 
what development efforts are required and the quality of the results, 
especially when compared with Cognos or MITS or the others in the 
space.Cheers,Kebbon   
___
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] test

2011-09-28 Thread David Jordan

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


Re: [U2] Rocket Authorization Page

2011-09-18 Thread David Jordan
It was impacting the USA authorisation, not the international one last Friday.

David Jordan
-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock
Sent: Monday, 19 September 2011 10:31 AM
To: 'U2 Users List'
Subject: Re: [U2] Rocket Authorization Page

Looks like a certificate on one of their internal servers has expired, and 
their ISA server is barfing on it.

Larry Hiscock
Western Computer Services


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Sunday, September 18, 2011 5:17 PM
To: U2 Users List
Subject: [U2] Rocket Authorization Page

Is anyone able to access https://u2tc.rocketsoftware.com/ today?

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


Re: [U2] ENCRYPT in Universe

2011-09-12 Thread David Jordan
Hi John
I have not played around with the encryption, but to my knowledge this is not 
the way it works.  The password is related to the data encrypted, not to the 
user, so every user would require the same key for the data.  To change the key 
you need to unencrypt and reencrypt the data.

The other option is encryption at rest where the whole database is encrypted.  
This has been greatly enhanced in Rel11 of UniVerse.

Regards
David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
Sent: Monday, 12 September 2011 10:35 PM
To: U2 Users List
Subject: Re: [U2] ENCRYPT in Universe

As far as passwords are concerned, I could use their password as the key?
That way it would be different every time, and in order for it to be decrypted, 
they would have to supply the right password, otherwise, they would have to 
reset it...

Is that a decent way of doing it?

I've also noticed that in the manual they seem to have encrypted files, where 
this is handled somewhat automatically.  But all of that seems much more 
complex to manage than this ENCRYPT() BASIC function.  I think...

Anyone ever use the encrypted file/field commands from TCL and had any luck 
with them?
It appears you have to jump through a lot of hoops form upgrade to upgrade 
though, which I'm not too fond of.

On Fri, Sep 9, 2011 at 9:25 PM, John Hester jhes...@momtex.com wrote:

 The key can be any text string you want and it's completely up to you 
 how you store it.  I would use a long, random mix of characters.  The 
 most secure place to store it would probably be on removable media 
 that has to be inserted for the application to work, but that's 
 probably overly inconvenient for most applications.  Storing it in the 
 same file as the encrypted data is probably the least secure place.  
 Storing the key in a separate file is a relatively secure method, 
 IMHO.  There is some security by obscurity here since only someone 
 with knowledge of the inner workings of the application would have any 
 idea where the key is stored.

 It's also up to you if you want to re-use a single key or not.  You 
 could use a different key for every piece of data, but you have to be 
 able to correctly marry the keys back to the right data to decrypt.
 Having another file with data that points to the IDs in the encrypted 
 file could also tip off an attacker as to what the keys are for.  I 
 suppose you could get elaborate and encrypt the keys themselves, then 
 the keys for those keys, etc., making it very difficult for an 
 attacker to determine the decryption sequence.  You could also 
 re-encrypt the already encrypted data a few more times with multiple keys.

 -John

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John 
 Thompson
 Sent: Friday, September 09, 2011 8:44 AM
 To: U2 Users List
 Subject: [U2] ENCRYPT in Universe

 I am exploring the Universe data encryption features...  Its my first 
 try at this really.
 I have decent understanding off ssh and ssl, just not the U2 stuff.

 My questions are...
 Where is a safe place to store the key (as referred to in the docs) 
 that the function needs to do encrypting and decrypting?
 How would I generate this key?
 Do I use the same key every time?
 Is there a thing to generate a key... like in ssh?

 For example, lets say I have a program that encrypts the user's 
 password and then writes it to the data file like so...

 *A test for storing encrypted passwords.
  OPEN \BAS.USERS\ TO f_bas_users ELSE
 CRT \Cannot open BAS.USERS file.\
 STOP
  END
 *
  CRT \Enter your email address: \:
  input email_address
  CRT \Enter your password: \:
  input password
 *
  key= \thisismykey\
  result = \\
  encrypt_status = \\
  encrypt_status = ENCRYPT(\des3\, 1, password, 1, key, 1, 1, \\, 
 \\, result, 1)
  CRT user_password
 *Apparently a status of 0 is a success.  Which is just plain weird.
  IF encrypt_status = \0\ THEN
 WRITEV result ON f_bas_users,email_address,3
  END

 --
 Now lets say I want to check the password to see if it is correct and 
 decrypt the data to do that...

 *A test for reading encrypted passwords.
  OPEN \BAS.USERS\ TO f_bas_users ELSE
 CRT \Cannot open BAS.USERS file.\
 STOP
  END
 *
  CRT \Enter your email address: \:
  input email_address
  CRT \Enter your password: \:
  input password
 *
  READV stored_password FROM f_bas_users,email_address,3 ELSE
 stored_password = \\
  END
  key= \thisismykey\
  result = \\
  decrypt_status = \\
  decrypt_status = ENCRYPT(\des3\, 3, stored_password, 1, key, 1, 
 1, \\, \\, result, 1) ; *This is actually decrypting, the 3 indicates

Re: [U2] DataVu Query [ad]

2011-09-07 Thread David Jordan
I spoke to Jackie Burhans at Rocket about the issues raised in this list on 
behalf of the user group and she is putting a team onto looking at how to 
improve the documentation and installation process for DataVu.   This is a 
product U2 users want to persevere with as it will make U2 stronger in the 
market and reduce the potential for competitor products pushing U2 out of a 
site.  It needs some issues ironing out, but the potential is great.

Regards

David Jordan
VP U2UG

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


Re: [U2] DataVu Query [ad]

2011-09-07 Thread David Jordan
Hi Steve
There have been 2 betas and I have been on both and requests were made through 
the Rocket newsletter.   The issues are probably a combination of people 
implementing on a broader spectrum of environments than was tested and also an 
issue of not being as intuitive to install.

Regards
David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow
Sent: Thursday, 8 September 2011 11:27 AM
To: U2 Users List
Subject: Re: [U2] DataVu Query [ad]

That is cool. Wish we could have done a beta and help shake some of these out.

Thank you Rocket for continuing to push the platform.
___
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] DataVu Query [ad]

2011-09-06 Thread David Jordan
Mecki
You do not need a JDBC driver, it uses uniobjects.   There is a video showing 
how to install and read the documentation.   The installation is not intuitive, 
but it is not hard.   I made the mistake first not to read the documentation 
which takes you through step by step.

Regards
David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gerd Forthmann
Sent: Wednesday, 7 September 2011 1:00 AM
To: U2 Users List
Subject: Re: [U2] DataVu Query [ad]

Well, I can't even connect to the host. A get an error message U2DB1004.
I reckon you guys really need to make this a lot easier if you want people tto 
use this and buy the other modules.
In the documentation it says something about a JDBC driver that needs to be 
installed but isn't included in the package and some obscure file that needs to 
be created somewhere and contains connection data but to me this is just Greek 
and doesn't mean anything.
Other products like mvDeveloper just work without having to find a driver 
somewhere and create any files by hand.
I bet you can do better than that.

Mecki
 Original-Nachricht 
 Datum: Fri, 2 Sep 2011 17:20:14 +
 Von: Daniel McGrath dmcgr...@rocketsoftware.com
 An: U2 Users List u2-users@listserver.u2ug.org
 Betreff: Re: [U2] DataVu Query [ad]

 Okay, so once you download DV Query there is a quick start guide that 
 will tell you what you need to do.
 
 You need to run CONVERT.SQL on your files so that it has access to 
 them, but you don't need to worry about creating the schemas with VSG 
 or using HS.ADMIN like you would otherwise. Actually, there is a way 
 to just use UPDATE.SQL.PRIVILEGES to get around this 
 (https://u2tc.rocketsoftware.com/documentation/1410030.asp), although we 
 recommend you do the CONVERT.SQL way.
 
 If you are running older versions of U2 you may need to update 
 XTOOLSUB, which is also a Tech note on TechConnect.
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve 
 Romanow
 Sent: Friday, September 02, 2011 11:14 AM
 To: U2 Users List
 Subject: Re: [U2] DataVu Query [ad]
 
 On Fri, Sep 2, 2011 at 1:04 PM, Bill Haskett wphask...@advantos.net
 wrote:
  Steve:
 
  Really?  I was looking at DataVu for UniData and I understood that I 
  did need to SQL'ize all my data.  So, if I hosted a number of 
  accounts I'd have to go through the entire process of figuring how 
  to duplicate the accounts for SQL file access, keep them all 
  straight, and fight with all that this entails.
 
  Are you sure I misunderstood this?
 
  Thanks,
 
  Bill Haskett
 
  
  --
  --
  - Original Message -
  *From:* slestak...@gmail.com
  *To:* U2 Users List u2-users@listserver.u2ug.org
  *Date:* 9/2/2011 9:47 AM
  *Subject:* Re: [U2] DataVu Query [ad]
 
  On Fri, Sep 2, 2011 at 12:45 PM, John 
  Thompsonjthompson...@gmail.com
   wrote:
 
  For example:
 
  If my goal was to teach a fairly savvy computer user to get data 
  out of
  U2
  into, lets say Excel... without the user coming to ask me to write 
  some query for them...
 
  What would be the pros/cons of doing the ODBC way, vs. doing it 
  the DataVu way?
 
  Forgive my ignorance... Does that make sense?
 
  On Fri, Sep 2, 2011 at 12:41 PM, Daniel 
  McGrathdmcgr...@rocketsoftware.com
 
  wrote:
  I'm not entirely sure on what you want here?
 
  DataVu (the free Query and paid Report  Dashboard products) are 
  querying, reporting and dashboard tools whereas ODBC is just an 
  interface.
 
 
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org [mailto:
  u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
  Sent: Friday, September 02, 2011 10:36 AM
  To: U2 Users List
  Subject: Re: [U2] DataVu Query [ad]
 
  Is there a comparison chart of DataVu vs. ODBC?
 
  I am planning on investigating both for reporting purposes, but, 
  I was just curious if there was anything out there that listed 
  the pros and cons of both in a nice little table.
 
 
  On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath 
  dmcgr...@rocketsoftware.com
 
  wrote:
  Free as in free beer on the house.
 
  Just install and run. There is no need to authorize.
 
  Regards,
  Dan
 
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org [mailto:
  u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
  Sent: Friday, September 02, 2011 10:20 AM
  To: U2 Users List
  Subject: Re: [U2] DataVu Query [ad]
 
  Is this a licensed product?  Or does it come with the U2 
  licenses we have purchased?
 
  On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath 
  dmcgr...@rocketsoftware.com
 
  wrote:
  Since DataVu Query recently came up here, I thought I should 
  let you all know we have just released a new version of the 
  free DataVu Query tool
  (v2.0.1)
 
  We have

Re: [U2] DataVu Query [ad]

2011-09-06 Thread David Jordan
Hi Mecki
You need to set up in the UD.ACCOUNTS.   Install the xdemo account from the CD 
and try connecting to that first.   I have installed with UniVerse and I am not 
as familiar with UniData, you may have to do a CONVERT.SQL, you will need to 
check the documentation.  I would consider actually setting up a separate 
account with pointers to your live account or even build a mini datawarehouse 
in a separate account to do reporting from.   

Make sure that you are select the U2 options and not using the SQL database 
connectors.   There are specific U2 data connections and queries.

Regards
David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
Sent: Wednesday, 7 September 2011 9:02 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] DataVu Query [ad]

David,

I bet you are right, but what users want is to be able to install software like 
that without having to search the documentation for hours.
I don't mind if I have to search for and download a JDBC driver from the net to 
connect to SQL Server, DB2 or Oracle data sources but I expect a Rocket product 
to work straight away for U2.
I get a screen that asks me for the UD server name and even though that name 
one works for SB client, VSG, UniAdmin and tools like mvDeveloper it won't 
connect in DataVu.
All I found so far is that I need this driver (hell knows where to get it from) 
and a file called bi.jdbc,drivers (or something like that) that needs to be 
created somewhere by the administrator.
Hell, I am the administrator and I haven't got a clue how to do that!


On 06/09/2011 23:22, David Jordan wrote:
 Mecki
 You do not need a JDBC driver, it uses uniobjects.   There is a video showing 
 how to install and read the documentation.   The installation is not 
 intuitive, but it is not hard.   I made the mistake first not to read the 
 documentation which takes you through step by step.

 Regards
 David Jordan

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gerd 
 Forthmann
 Sent: Wednesday, 7 September 2011 1:00 AM
 To: U2 Users List
 Subject: Re: [U2] DataVu Query [ad]

 Well, I can't even connect to the host. A get an error message U2DB1004.
 I reckon you guys really need to make this a lot easier if you want people 
 tto use this and buy the other modules.
 In the documentation it says something about a JDBC driver that needs to be 
 installed but isn't included in the package and some obscure file that needs 
 to be created somewhere and contains connection data but to me this is just 
 Greek and doesn't mean anything.
 Other products like mvDeveloper just work without having to find a driver 
 somewhere and create any files by hand.
 I bet you can do better than that.

 Mecki
  Original-Nachricht 
 Datum: Fri, 2 Sep 2011 17:20:14 +
 Von: Daniel McGrathdmcgr...@rocketsoftware.com
 An: U2 Users Listu2-users@listserver.u2ug.org
 Betreff: Re: [U2] DataVu Query [ad]
 Okay, so once you download DV Query there is a quick start guide that 
 will tell you what you need to do.

 You need to run CONVERT.SQL on your files so that it has access to 
 them, but you don't need to worry about creating the schemas with VSG 
 or using HS.ADMIN like you would otherwise. Actually, there is a way 
 to just use UPDATE.SQL.PRIVILEGES to get around this 
 (https://u2tc.rocketsoftware.com/documentation/1410030.asp), although we 
 recommend you do the CONVERT.SQL way.

 If you are running older versions of U2 you may need to update 
 XTOOLSUB, which is also a Tech note on TechConnect.

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve 
 Romanow
 Sent: Friday, September 02, 2011 11:14 AM
 To: U2 Users List
 Subject: Re: [U2] DataVu Query [ad]

 On Fri, Sep 2, 2011 at 1:04 PM, Bill Haskettwphask...@advantos.net
 wrote:
 Steve:

 Really?  I was looking at DataVu for UniData and I understood that I 
 did need to SQL'ize all my data.  So, if I hosted a number of 
 accounts I'd have to go through the entire process of figuring how 
 to duplicate the accounts for SQL file access, keep them all 
 straight, and fight with all that this entails.

 Are you sure I misunderstood this?

 Thanks,

 Bill Haskett

 
 --
 --
 - Original Message -
 *From:* slestak...@gmail.com
 *To:* U2 Users Listu2-users@listserver.u2ug.org
 *Date:* 9/2/2011 9:47 AM
 *Subject:* Re: [U2] DataVu Query [ad]
 On Fri, Sep 2, 2011 at 12:45 PM, John 
 Thompsonjthompson...@gmail.com
   wrote:
 For example:

 If my goal was to teach a fairly savvy computer user to get data 
 out of
 U2
 into, lets say Excel... without the user coming to ask me to write 
 some query for them...

 What would be the pros/cons of doing the ODBC way, vs. doing

Re: [U2] DataVu Query [ad]

2011-09-06 Thread David Jordan
Hi Mecki

You should not need a jdbc driver, this is why I suspect you maybe using the 
data connector for RDBMs databases instead of U2 data connector which uses 
uniobjects.

David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
Sent: Wednesday, 7 September 2011 9:02 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] DataVu Query [ad]

David,

I bet you are right, but what users want is to be able to install software like 
that without having to search the documentation for hours.
I don't mind if I have to search for and download a JDBC driver from the net to 
connect to SQL Server, DB2 or Oracle data sources but I expect a Rocket product 
to work straight away for U2.
I get a screen that asks me for the UD server name and even though that name 
one works for SB client, VSG, UniAdmin and tools like mvDeveloper it won't 
connect in DataVu.
All I found so far is that I need this driver (hell knows where to get it from) 
and a file called bi.jdbc,drivers (or something like that) that needs to be 
created somewhere by the administrator.
Hell, I am the administrator and I haven't got a clue how to do that!


On 06/09/2011 23:22, David Jordan wrote:
 Mecki
 You do not need a JDBC driver, it uses uniobjects.   There is a video showing 
 how to install and read the documentation.   The installation is not 
 intuitive, but it is not hard.   I made the mistake first not to read the 
 documentation which takes you through step by step.

 Regards
 David Jordan

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gerd 
 Forthmann
 Sent: Wednesday, 7 September 2011 1:00 AM
 To: U2 Users List
 Subject: Re: [U2] DataVu Query [ad]

 Well, I can't even connect to the host. A get an error message U2DB1004.
 I reckon you guys really need to make this a lot easier if you want people 
 tto use this and buy the other modules.
 In the documentation it says something about a JDBC driver that needs to be 
 installed but isn't included in the package and some obscure file that needs 
 to be created somewhere and contains connection data but to me this is just 
 Greek and doesn't mean anything.
 Other products like mvDeveloper just work without having to find a driver 
 somewhere and create any files by hand.
 I bet you can do better than that.

 Mecki
  Original-Nachricht 
 Datum: Fri, 2 Sep 2011 17:20:14 +
 Von: Daniel McGrathdmcgr...@rocketsoftware.com
 An: U2 Users Listu2-users@listserver.u2ug.org
 Betreff: Re: [U2] DataVu Query [ad]
 Okay, so once you download DV Query there is a quick start guide that 
 will tell you what you need to do.

 You need to run CONVERT.SQL on your files so that it has access to 
 them, but you don't need to worry about creating the schemas with VSG 
 or using HS.ADMIN like you would otherwise. Actually, there is a way 
 to just use UPDATE.SQL.PRIVILEGES to get around this 
 (https://u2tc.rocketsoftware.com/documentation/1410030.asp), although we 
 recommend you do the CONVERT.SQL way.

 If you are running older versions of U2 you may need to update 
 XTOOLSUB, which is also a Tech note on TechConnect.

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve 
 Romanow
 Sent: Friday, September 02, 2011 11:14 AM
 To: U2 Users List
 Subject: Re: [U2] DataVu Query [ad]

 On Fri, Sep 2, 2011 at 1:04 PM, Bill Haskettwphask...@advantos.net
 wrote:
 Steve:

 Really?  I was looking at DataVu for UniData and I understood that I 
 did need to SQL'ize all my data.  So, if I hosted a number of 
 accounts I'd have to go through the entire process of figuring how 
 to duplicate the accounts for SQL file access, keep them all 
 straight, and fight with all that this entails.

 Are you sure I misunderstood this?

 Thanks,

 Bill Haskett

 
 --
 --
 - Original Message -
 *From:* slestak...@gmail.com
 *To:* U2 Users Listu2-users@listserver.u2ug.org
 *Date:* 9/2/2011 9:47 AM
 *Subject:* Re: [U2] DataVu Query [ad]
 On Fri, Sep 2, 2011 at 12:45 PM, John 
 Thompsonjthompson...@gmail.com
   wrote:
 For example:

 If my goal was to teach a fairly savvy computer user to get data 
 out of
 U2
 into, lets say Excel... without the user coming to ask me to write 
 some query for them...

 What would be the pros/cons of doing the ODBC way, vs. doing it 
 the DataVu way?

 Forgive my ignorance... Does that make sense?

 On Fri, Sep 2, 2011 at 12:41 PM, Daniel 
 McGrathdmcgr...@rocketsoftware.com
 wrote:
 I'm not entirely sure on what you want here?

 DataVu (the free Query and paid ReportDashboard products) are
 querying, reporting and dashboard tools whereas ODBC is just an 
 interface.


 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org

Re: [U2] Stuck getting started with DataVu

2011-08-24 Thread David Jordan
Hi all
I work with DataVu a bit.   The first trap I got caught on was skipping through 
the documentation and missing steps, double check the steps in installation.

A couple of things to check.
1.  make sure the entry is correct in the UV.ACCOUNTS file.
2.   This does not use ODBC, but it does use SQL.  If SQL is not working on 
your account you need to follow this through first.
3.  If linux is involved check if some other steps need to be added.  There was 
some issue with Linux in the beta that I thought was resolved but you may have 
to install something.  

In the beta a lot of work was done to ensure that DataVu works with all 
dictionary types and including SB+ dictionaries.

What many are doing is setting up a new account with remote pointers and 
restricted dictionaries pointing to the data account.  You can set that account 
to be ideal flavour and have different dictionaries to the data account and 
avoid touching the live account for reporting purposes.  You can do what you 
want to SQLise this account without touching the data account.

There is a little perseverance to get DataVu up and working, but in comparison 
to the work required to get up COGNOS, Chrystal reports and other BI tools to 
talk to U2, this is an easier path.   Remember also that DataVu talks to other 
RDBMS, which means that you stop the need for pushing data into some SQL Server 
for reporting purposes and you raise the status of U2 in management eyes 
reducing the threat of U2 being replaced in your organisation.

Another issue to look at.   It is easier to transform data to an appropriate 
format in U2 than trying to manipulate it at DataVu level.   Build SQL queries 
that produce an appropriate array to put into the DataVu Objects, this will 
save you some frustration going forward.

Regards

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


Re: [U2] uniobjects question

2011-08-09 Thread David Jordan
Uniobjects has the same facility to access TCL through the command method.

Regards
David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben
Sent: Tuesday, 9 August 2011 2:02 PM
To: U2 Users List
Subject: Re: [U2] uniobjects question [AD]

[AD]While it may be impossible with UO, FusionWare's Direct Data Access Server 
supports a mechanism called EXEC TCL in which you can call any program that can 
be run from TCL, and pass it inputs, like a PROC or a CGI program.  If you miss 
an input, things will get kind of stuck, but if you know your inputs, it works 
like a dream. We have customers who have been using it quite happily for a 
number of years. You can access this functionality from Java, OLE DB and 
Managed .NET (ADO.NET) clients.

We give some very simplistic examples here:
http://www.fwic.net/Resources/FusionWareIntegrationBlogs/tabid/116/EntryId/55/Other-Ways-to-Access-Our-MultiValue-SALESORDER-Data.aspx

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Monday, August 08, 2011 4:39 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] uniobjects question

Doug, as confirmed by the experience of others, and confirming your own 
suspicion, we can say with certainty it's not possible to have a functional 
app where CRT and INPUT are encountered by UO.

The only way to use traditional code like that is to skip UO and to use a 
telnet or SSH client from your language of choice, feeding input to the server, 
waiting for a response, and parsing the output.  That mechanism works fine 
until something unexpected comes up.  Then you need some supporting handlers 
around your code to recover from the error, avoid keeping the process and 
license locked, restart a new process, log the event, etc.  This is screen 
scraping, and while there are some fine solutions that do this, they are 
generally shunned for heavy processing in favor of less volatile solutions.

In summary, do you see the two big glowing eyes peering back at you from deep 
inside of that dark cave?  You know better than to go in there, right?  :)

HTH
T

 From: Doug Chanco
 I totally agree with your response but what me and the java developer 
 are discussing is if it's even possible (I say nay)

 I will write a java program to test but I was hoping with the vast sea 
 of knowledge on this group that someone would know, if it was possible 
 or not

 Yes it should never be done and yes your standards are spot on.  This 
 is just a I wonder if this is possible question

 Dougc

___
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] uniobjects question

2011-08-08 Thread David Jordan
I have done it Doug, but with the command processor not the subroutine call.  I 
would run the program in the command and receive a string which I would 
interpret as either a result or a request for information, which I would then 
respond accordingly.  It works but is cumbersome.  There is also an issue of 
timeouts where the connection would drop out after 6 minutes of no response.   
Creating subroutine calls are a better way to go with no prompts within the 
program.

David Jordan

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


Re: [U2] Why Pick U2?

2011-07-14 Thread David Jordan
I  developed a new application in U2 and I sell it.  I am not a dinosaur.   
What has been raised is technical comparisons, but if you are developing 
software to sell you need to think commercial advantages.  For instances, I 
never sell to IT, I sell to business decision makers, technology means nothing 
to them, they want results and they want delivery within budget and within time 
frames.  No one asks me what database I run on. You compete first on cost and 
second on functionality and thirdly they want reliability.   This is where U2 
shines for a new developer.

1.  I never fear that I will not meet cost and time targets, I don't have 
surprises that delay projects.
2.  Cost of Development,  I can achieve with 2 programmers in half the time 
what my competitors require 10+ programmers to do
3.  Support:  I sell a package and rarely go back to the site for years as it 
is self-maintaining.   Their IT rarely have to do anything with it.
4. Functionality, I can do complex business functionality that my competitors 
struggle with despite their modern programming languages and tools.
5. I can put a lot of fat into my quote and still undercut my competitors.
6. Code transports through technology changes.  If I had written something 15 
years ago in c++, VB for windows, I would have had to rewrite it several times 
to handle the evolution of windows technologies.   That is expensive.

The advantage of U2 is the KISS principal.  Use the right technologies for the 
right job.  For instances front ends, use .Net, Java, etc.

U2 Basic is a business programmers language, not a computer science programmers 
language.  It is good for people who are writing business rules as it is quick 
and simple to write and easy to read and debug.  I have written complex 
business logic that would have been difficult to manage in c#.

Sure there are many things that need to be improved in U2, but to think other 
technologies are perfect is a bit of the grass is greener on the other side.  I 
have worked with many databases and technologies over the years and have seen 
what looks good to start with often hits brick walls as you start to get 
serious with the technology and then there are massive costs to jump those 
brick walls.

I am winning with U2 and that's why I use it as do many others on this list.

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


Re: [U2] Why Pick U2 ?

2011-07-13 Thread David Jordan
One thing that all the other database lack is that U2 has a sophisticated 
business rules engine.   The SQL bastardise language in other databases is a 
nightmare compared to unibasic.When everyone is talking APIs, they are 
mostly talking about the presentation layer.  Presentation layer interface to 
other databases is better than U2, but U2 is better for storing business logic 
in the database.   I am seeing too many applications being developed out their 
that are breaking the rules of client server where the business logic is in the 
client.  Too many tools use the database as a simple data repository and 
require business rules to be built into the client.   

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


Re: [U2] Interesting article

2011-07-12 Thread David Jordan
Rob your comments are not wrong.  However U2 management want to go where they 
think the market is.  As users we don't tell them anything and then complain 
that they are not mind readers and are not heading in the direction we want to 
go.   As a user group, we give users a voice to be able to set direction.  Of 
course there are a million one views about the future, but we can build a 
business case based on the wishes of the majority.   I have sat down with 
Rocket and explained how Microsoft Azure could provide a market opportunity and 
how U2 could work in this environment and I am working with them to look at its 
feasibility.  Others are looking at REST and a range of other APIs.  Rocket is 
not so much ignoring us rather we as users are not talking to Rocket 
constructively.

What is important is to turn this discussion into something constructive.  If 
Rocket asked you what you want, what would you say.

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


Re: [U2] Interesting article

2011-07-12 Thread David Jordan
Hi Bill
There are some options for alternative licensing.  Rocket will not stay in 
business giving away licenses, but they are also not silly in turning away 
business because of licensing structure.  We as a user group need to put a 
business case to licensing.  There are subscription models we could put up, 
there are cloud based models.  We need to talk to Rocket about the options we 
need.  The user group gives an opportunity to show that these are not the 
wishes of an individual, but the wishes of a community.

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


Re: [U2] Epicor and Eclipse

2011-07-08 Thread David Jordan
Talk to Rocket.  I have heard that there have been some discussion to resolve 
this problem

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


Re: [U2] Convert to Numeric

2011-06-30 Thread David Jordan
Hi Greg

I may have misinterpreted your email.  However just wanted to make sure you 
understood that if you want to convert $13,000.00 to numeric you need to do an 
ICONV.   OCONV does the opposite and converts 130 to $13,000.00

Regards

David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho
Sent: Friday, 1 July 2011 10:50 AM
To: U2 Users List
Subject: Re: [U2] Convert to Numeric

Guys,

I'm getting some wildly unexpected values returned...   I have attempted 
formatting (FMT) and converting (OCONV) and have looked at the data which 
appears to be correct(no O etc...).  The DICT has them set at MD2, and 15R.  
I notice that I am also getting the following message:

 In CF.OBJ/_A26S.GET.GLS.INFO at line 212 Non-numeric found when numeric 
required.

Any suggestions how I can force these values numeric?

Thanks,

Greg
___
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] Interesting article (pro mobile web) vs mobile app -relating to previous discussion

2011-06-20 Thread David Jordan
It is not an issue of old dogs vs young dogs.   It is about the separation of 
presentation and business logic.  The U2 applications are the business logic, 
the html, java, .Net are the presentation layer.   All the young people are 
caught up on the presentation layer and are cheap.   What businesses are 
starting to struggle with is the development of the backend business logic.  

What people need to work out is how to sell that they are the backend solution 
providers and modify their applications to talk to a presentation layer that is 
done by someone else probably in India.

There are many successful U2 applications out there that have the business 
logic written in u2 Basic and a presentation layer written in java, .Net, html, 
etc

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


Re: [U2] Strange Selection Behavior

2011-06-14 Thread David Jordan
Hi Steve

This may be an issue of the EXECUTE creating another shell to perform the 
select which the tcl prompt does not require.  There has been past discussions 
of the use of EXECUTE and PERFORM for this reason.   However I am not sure that 
there is an difference for Universe and the PERFORM command is there for 
functionality.  Someone may be able to clarify that.  Mind you it should not 
cause a 22 second issue.

Do a print of the cmnd before the execute and capture it in a como.  You might 
see something strange in the way that the command is being constructed.

David Jordan


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


Re: [U2] Installing UniObjects on Windows 2008 64 bit

2011-06-13 Thread David Jordan
I had a problem with installing UniObjects on Windows 2008 R2 64bit where one 
of the dlls disappeared during install, I copied it back and registered it 
manually and everything worked OK.  I have not experienced it again, but it may 
be a clue to your problem.

David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jim.sto...@esc.edu
Sent: Tuesday, 14 June 2011 7:07 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Installing UniObjects on Windows 2008 64 bit

Hello,

We have a UniData server and are using UniObjects to access it from our web 
servers (using Lotus Notes/Domino).  We have UniObjects working in Domino's 
Lotusscript scripting language on our production servers running Windows 2003.  
It also works on my desktop running Windows XP.

I just tried to install the UniData client (udt_7.2acl, downloaded today from 
Rocket's website) on a development machine running Windows 2008 R2 64 bit, and 
the Domino agent that calls the Uniobjects.UnioaifCtrl object always fails with 
the error:  ERROR  208 : Cannot create automation object.  The UniObjects 
manual mentions that if you get an error saying it cannot create object that 
UniObjects didn't install property and instructing you to try re-installing.  
I've re-installed it three times with no luck.  The UniData client installer 
runs fine, and seems to install the UniDevelopers Kit (the element that 
installs UniObjects) without any errors.  There are no errors in the server's 
event log, and the file uniobjects.dll is placed into the C:\Windows\SysWOW64 
directory on the server, which seems to be correct for a 32-bit dll on a Windows
2008 server. 

Next I downloaded and installed Microsoft's OLE/COM Object Viewer (a Windows 
2008 compatible version is in the Windows 7 SDK installer), and installed that 
on both my desktop and the Windows 2008 server.  On my desktop, the viewer 
shows that the UnioaifCtrl class is registered/installed.  However, the 
UnioaifCtrl class does not appear in the viewer on the Windows 2008 server. 
Maybe the installation didn't register the object?

Has anyone installed the UniData client, especially UniObjects, on Windows
2008 R2?  Does anyone have any suggestions about why the client installer 
wouldn't be registering the automation object, or how to proceed?

Thank you,
Jim Stoner
___
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 11.1.2 list line limit

2011-06-06 Thread David Jordan
Hi Jack

I would use the OPENSEQ and READSEQ to deal with such files.  The problem with 
ED and READ apart from loading the whole record into memory is that to go to 
attribute 1M it goes to the start and then counts a million field marks.  Then 
you want to read 1,000,001 it goes back to the beginning and reads 1,000,001 
field marks it is extremely slow and unworkable.   READSEQ, WRITESEQ leaves a 
pointer from the last attribute position.  You have to process these files 
sequential but it would read 40MB in nanoseconds, far more efficient.

Regards

David Jordan



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jig
Sent: Monday, 6 June 2011 8:15 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Universe 11.1.2 list line limit


OK sorry Kate,

I should have given a little more information.

On our system (AIX v5.3) we recently upgraded to 11.1.2 of UV from v10.3, and 
we deal a lot with lists. Large lists with hundreds of thousands or even 
millions of lines (elements). These are just lists of keys to records in files. 
One in particular is a fixed length seven byte key (alphanumeric).
However the largest file has 3.5 million records in it. This means that our 
lists can get to over 3 million lines ( this is about 40MB of a single file in 
a Unix directory).

On version 10.3 when a basic program or the ED editor was used to read one of 
these lists (with anything over 2 million lines of keys in it) it would just 
core dump and not be able to read it. The same thing occurred whether one had 
the list in the SAVEDLISTS file or anywhere else. 

To get around this problem we wrote software to split these large lists.
However that was cumbersome and not always worked to specification. 

With UV 11.1.2 (and because according to Rocket they did a lot of work to 
improve memory management) we thought we'd be better off, handling some of 
these large lists. However it seems we were wrong. 
A Basic routine cannot read a list that is over 4 million records in it. It 
just falls over and the process dies. The AE editor is a little more graceful 
with some information before it also dies trying to open any large list of keys.

I know there are ways around this issue, but we expected a lot better 
performance from the new version. I dont have the exact error at the moment, 
because I am not at work, but I can add it here if requested. One can always 
try it themselves to see the error, because it happens every time. 

I am sure most companies do not work with such large lists, but even so, core 
dumping instead of a gracious exit is not good enough. This is the first thing 
we learned when we started out as programmers decades ago.

regards
jack


Kate Stanton wrote:
 
 What limit?  I do not understand.  TIA., Kate
 
 On 6 June 2011 19:32, jig iako...@gmail.com wrote:

 Wondering if anyone is aware of the line limit in a saved list for 
 the latest UV version?

 Has it improved since we went to 64-bit?
 --
 View this message in context:
 http://old.nabble.com/Universe-11.1.2-list-line-limit-tp31781147p3178
 1147.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

 
 
 
 --
 Kate Stanton
 Walstan Systems Ltd
 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand
 Phone: + 64 9 360 5310  Mobile: + 64 21 400 486
 Email: k...@walstan.com
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 

--
View this message in context: 
http://old.nabble.com/Universe-11.1.2-list-line-limit-tp31781147p31782039.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


Re: [U2] Pondering recent thread on compact framework

2011-05-18 Thread David Jordan
Microsoft has split their development products into 2 areas presentation and 
business rules.   The presentation people take results given to them by the 
business application and present it on the phone and web.  The business rules 
developers have little to do with presentation.   Many developments in the U2 
world are starting to move that way, where the business rules developers are U2 
and the presentation developers are another group such as .Net.  Hence U2 
people are not aware of the phone development.

Another issue that would concern organisations is how to handle security and 
identification of remote users.   Creating an application on the phone is 
simple.  How you connect from the phone to the database with encryption, 
passwords, etc is an area that people fear.  Simple web services are easy, but 
when you then want to know that it is really joe blog that is calling the web 
service, it becomes another level of complexity.

Finally the issue is the cost benefit analysis.  Do I write an app that allows 
executives to access KPIs from my application.   Would sending them an email 
with the KPIs be far cheaper and simpler.   At what point is it productivity 
and at what point is it playing with technology.  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Pondering recent thread on compact framework

2011-05-18 Thread David Jordan
Hi George

I use a Windows phone 7.  With a web page there is a cost of time for 
downloading a web page and a performance issue with screen loading.  With an 
app, I conform to the user interface of the phone which are more intuitive to a 
phone user.  The app loads quicker and runs quicker.   However if you have 
users using android, blackberry, iphone, etc then you need to create a separate 
app for each phone.   With the new phones you need to load the app from the 
marketplace which is difficult for an enterprise application.   Hence the 
decision to use an app vs web is related to performance and intuitive interface 
vs portable and easier to load.

Remember also that most phones have no virus protection and are a potential 
risk area for Trojans and viruses for web interfaces.  An app is a bit more 
secure.

Again there are other features I can use on the phone such as sending a 
spreadsheet of KPIs to the phone rather than having an application to access 
KPIs.  There are just too many ways to skin a cat.

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


Re: [U2] Uniobjects.Net Compact Framework and Visual Basic

2011-05-10 Thread David Jordan
Hi Jeff
I suspect that you may not have included all the components to be carried 
across to the device.  They are on your workstation, hence why it runs, but 
fails on the device.  I believe there is a description of the items that need 
to be included in the sdk in the ibm or rocket directory.

You can put the web service on a different machine and talk to the server hence 
isolating the data.  The U2 webservice can encrypt and provide security 
connection to that server and is fairly easy to set up.  With Web services your 
application runs on any device where .Net limits you to Microsoft.

Regards

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


Re: [U2] Reliability doesn't raise enough issues to keep the list busy

2011-05-04 Thread David Jordan
New sales are mostly packages.  A new site implementing a package does not 
equate to a new site needing U2 programmers.  Hence a growth in job advertising 
is not a measure.   Another impact is that new U2 applications have front ends  
developed with other languages like .Net, java. Etc.  Often they are training 
those people to write U2 code rather than hiring pure U2 people.

It is a sign of the times, those that are multiskilled in a number of 
environments will have greater opportunity to find work.

David Jordan

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


Re: [U2] uv v ud

2011-05-04 Thread David Jordan
Hi Bill

I ran into a funny like that.  The application was compile with an old version 
of uniobjects .Net and had an issue with the new version of universe.  I 
recompiled with the new version of uniobjects and the issue went away.
Other area to look for
- I have had issues where a subroutine returned an unsigned variable, make sure 
all variables are assigned when being returned back.
- Check the size of strings being passed back, a program may be passing back a 
long string as the result of a program bug.  It may be a corrupt record.  The 
problem with pick is we look at fld 10 and don't care what is after.  You can 
have a corrupt record with garbage on the end and it will not impact data 
quality in the application but it will impact on performance.

I have found uniobjects to be quite robust, but really only use it to make 
calls to subroutines, I don't use other functionality.   Whilst you can write 
business logic in the .Net client, there is a question if that does not breach 
good practice in relation to client server.  You should keep your business 
rules in a central place where you can change it once.  You cannot afford to 
update a 100 desktop applications every time you need to change business logic.

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


Re: [U2] Reliability doesn't raise enough issues to keep the list busy

2011-05-03 Thread David Jordan
One of the things that U2 has is the KISS principle.   What I find like in 
.Net, is sometimes it overcomplicates a solution.   80% of my code is in 
UniBasic and 20% in .Net, however I feel like 80% of my time is taken up 
managing the .Net code compared to 20% managing the greater amount of code in 
UniBasic.  That is something I hear from a number of developers who develop in 
both environments.

I agree we should not do everything in U2, but I wish some of the other 
environments kept it simple to.

One thing I have always liked about U2 is that I always felt confident that I 
would deliver a project close to time and close to budget, I rarely get 
surprises.  However with .Net, suddenly I hit strange problems relating to 
versions of OS, security issues, etc that muddy the waters.   Hence I spend a 
lot of time on .Net forums seeking solutions that I just don't need to do with 
U2.  Buggy may have been a bit harsh, but there is an issue of consistency and 
dependability of development.

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


Re: [U2] Reliability doesn't raise enough issues to keep the list busy

2011-05-03 Thread David Jordan
Databases have become utility. I don't see many applications today advertising 
they run on Oracle or Microsoft, many are trying to be generic.  People are 
more interested in buying SAP than worry what database it runs on.  Those days 
of user base and TPC ratings are gone.  Users and developers want to know does 
it run on the environments they want, does it interface with other 
applications, does it work with cloud, what are the costs, what are the returns 
it will deliver.  They are not asking who uses the database or how many users 
around the world use it, they are asking who uses the application that they are 
looking to buy.

There is nothing in U2 that stops me interfacing with new technologies.  Sure I 
would like some more native and sometimes simpler interfaces but I have been 
able to do most things talking to U2.

Rocket may not publish figures, but U2 is increasing staff, U2 are introducing 
new products such as DataVu, these are not indicators of a dying product.   

Less than 500 people attended U2 universities around the world which means 
everyone else failed to find out what Rocket is doing.  Rocket created the 
opportunity, but people failed to take advantage of it.  Stop focusing on what 
U2 does not do as all technologies have holes.  Focus on what it does do and 
then work with Rocket to further improve the technology.

People do not understand where they are touched by U2.  Your baggage being 
unloaded from the plane is probably using U2.   Dialing an emergency number, 
the operator could be using U2.  Doing a banking transaction often has a pick 
application involved, booking a flight, membership to a union, project 
management of a building site, dealing with a car distributor, going to the 
library, managing a nuclear reactor.  You name it you are being touched by U2 
applications everyday. 

For me U2 allows me to compete with a small RD staff, small support staff and 
at a lower cost.   I am able to deliver far more for a tenth of the cost of my 
competitors.  If new developers are making decisions based on technology awe 
instead of business justification, then they will have a short life span.   I 
don't really see why we need to know what the number of users in the market 
are, it is not that relevant.

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


[U2] Reliability doesn't raise enough issues to keep the list busy

2011-05-02 Thread David Jordan
It is the problem with a reliable product there are not enough issues to keep 
the list busy.  If you had one of the competitor products there would be a ton 
of issues to deal with to keep multiple forums busy.   Funny how buggy software 
can look good, because there are a ton of forums to deal with all the bugs.  

David Jordan


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


Re: [U2] Saying Goodbye...

2011-04-28 Thread David Jordan
HI Jake
A work group license is A$570

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


Re: [U2] Saying Goodbye...

2011-04-27 Thread David Jordan
Have people who criticised U2 interfaces actually worked with other database 
applications.  Remember the joke What hardware and operating system doe Oracle 
best run on, a projector and powerpoint.  Too much of the competitors' 
products are gloss and when it comes to writing applications they become a 
chain and ball.  When I look at competitor applications they have pretty 
interfaces but lack substance.  I beat competitors from major companies because 
I provide functionality at a price that leaves the others for dead.   Clients 
are starting to question the gloss and are looking for substance.

As I have said in previous emails, it is not about the technology, it is about 
how it is sold.  We have an Australian U2 GL package that kicked SAP out of a 
site, it is not impossible.  For too long U2 has sold it self, however due to 
competition, we need to apply more money to marketing and sales people.   
Marketing budgets of some of the competitors are well over 20%-40% of revenue, 
few U2 application vendors spend anywhere near that much.  

Marketing statistics identified that optimists outsold pessimists.   If you 
think U2 is not up to scratch with the competitor, then how are you going to 
convince the customer.  Rethink how you look at U2 compared to other databases 
and it will change the discussions with senior management.  Senior management 
are on bonuses and they do not get paid for buying brands they get paid for 
delivering results, you need to demonstrate how U2 improves their bonuses and 
you are in.

Of course there is room for improvement in U2 products and Rocket is working on 
them, but uniobjects is still one of the most efficient and effective APIs that 
I have worked with and you can easily add gloss to tired applications with a 
range of client tools including .Net, java, etc.

David Jordan




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


Re: [U2] Opinions on Cache

2011-04-10 Thread David Jordan
Rather my point about the Pick issue is not to say that it is not a problem, it 
is more the perception of how to sell Pick to senior executives.  Business 
management are not as concerned about technology as they are about results.  
They may have a concern or a perception about the technology being limiting but 
they can be convinced otherwise.  What I would point out is that it is 
important that we as a community build the right message that argues the point. 
 Unfortunately I hear too often people being apologetic of the technology 
rather than pushing its merits.  Part of that problem is many people who have 
grown up with the PICK environment don't understand the limitations of other 
RDBMs.  Many of the new sales of U2 are application driven not technology 
driven, PICK or U2 is not even mentioned.   Many of the sites that are 
struggling with the PICK issue are sites that have based applications on the 
technology they have being PICK.   The question is not about the technology but 
a concern if the application is tired.   The application could be renewed two 
ways, replace it or put up a proposal to upgrade and renew the current 
application.   Unfortunately many of these applications have moved into 
maintenance mode giving it the tired image. 

What I was trying to do with my comments, is to get people thinking about the 
strengths of U2.  I invite some rigorous debate as it raises questions and 
generates new ideas people have never thought of.   

For instance with cloud computing, SQL database applications are designed to be 
multitenant.  In other words I have one set of tables for my applications but I 
prefix every key with a company identifier.  So on a multitenant CRM 
application where 100 companies are using the applications, the Customer Table 
would prefix the customer number with a unique identifier for each company 
using the application and they would all share the same table.  With the 
structure of U2, it would be efficient enough to have a separate account for 
each company.   Technically this might not be an issue to developers but 
perceptions to a business manager are different.  They could perceive an issue 
of their data sitting alongside other company's data.  As an IT manager trying 
to keep a Pick site, this information could stop a move to another application.

What I would put to everyone at the moment is that we have been is a siege 
mentality over the last decade trying to convince IBM, Informix and management 
that U2 is a going concern.  Now that Rocket has purchased U2 as a growth 
opportunity, the siege gates have been thrown open and we have the opportunity 
to attack the competition.   As in sport, it is how we think that wins or loses 
opportunities and I believe that this is the essential issue, we need to change 
our thinking about Pick.  In the last two years I have seen a major change in 
direction in IT thinking where U2 has some real opportunities.   Governments 
around the world are having to trim budgets and they are not prepared to waste 
money on brand names.  Larger corporations are cost sensitive.  I believe U2 is 
in a strong position to take advantage of that change.

Difficulty in finding people is not necessarily a negative.  Right at the 
moment Microsoft SQL has a major issue that those who know TSQL are mostly 40+, 
I don't see Microsoft sales slowing down because of this.

David Jordan


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


Re: [U2] Opinions on Cache

2011-04-09 Thread David Jordan
From my observations, I don't quite agree on Tony's summation of Cache vs U2.  
Cache has the same burden as U2 in that they came from mumps where U2 came 
from Pick.  The biggest difference between Cache and U2 is marketing where 
Cache takes on RDBMS and U2 is apologetic for being Pick, but that is not the 
issue with the technology.   Cache is a multi dimensional platform, the same 
as Pick but in a slightly different way.   U2 has SQL just as much as Cache, I 
have applications written in U2 that have SQL tables and SQL grants and can be 
accessed with SQL queries.   If Cache can sell itself as an SQL database, then 
so can U2 they are both in the same boat.  Whilst I think some of Cache's 
technology is clever in their object model, people need to consider some 
issues with Cache.   Check that the ATOMic transaction model is what you 
expect.  U2 complies to the standards, when I looked at Cache, I don't believe 
that they did.   Also consider the continuity of the company, what is the 
future of Intersystems when the founder exits, where Rocket is a more 
established business that is not so dependent on key managers.   

I am currently looking at how U2 fits in the cloud environment with products 
like Microsoft Azure and I think the model of U2 where each table  is a 
separate os file is better for cloud computing than Cache's one system file 
(similar to the approach of other RDBMs).  

DataVu provides a significant solution to an area of weakness in the U2 camp 
related to reporting.  DataVu gives U2 the equivalent of SQL Reporting services 
and more.   DataVu provides a competitive position to products like Cognos.  
This is one technology that I do not believe that Cache can cover off.

I think it is great to have Cache in the MV world, it provides competition and 
will keep Rocket on its toes, both have strengths and weaknesses.  However I 
would not agree in Tony's email that it is a better technology than U2 or that 
it is a solution to the management concerns who are more familiar with Oracle 
and SQL Server.  I also don't believe that U2 is locked  to green screen 
applications.  I am seeing new generations of applications that don't have 
green screens, they have a range of .Net, java and web interfaces.  Honestly 
the PICK issue does not come up as much as people think it does, nor is it a 
hindrance.   Management are looking for ROI, they want responses to business 
problems and they want to ensure that Risk management is ticked off.  All these 
can be achieved with U2 as a community we need to learn how to answer those 
concerns.

There are some areas of U2 that need to be refined and as U2 users we need to 
tell Rocket where to put the priority to ensure that meets our requirements.   
The U2UG has set up the better and better site and Rocket has the 
u2as...@rs.com email.  Please take advantage of these to refine U2 to meet your 
expectations.

Regards

David Jordan
U2UG VP

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


Re: [U2] Opinions on Cache

2011-04-09 Thread David Jordan
I am not familiar with UniData and I am aware that UniVerse has had better SQL 
support than uniData.  I have found that UniVerse SQL performs well.  The 
UniVerse query engine is used by both SQL and retrieve, where they pass the 
query over to an optimizer engine.   One thing that has been a bit slow is the 
ODBC driver which has been updated at release 11.1 .   Also the query 
integrates with EDA, so I can be selecting data off a UniVerse, Oracle and SQL 
Server at the same time.   I would be interested in comparisons in performance 
of a similar data file with similar indexs, triggers, etc.  There is also a 
consideration issue whether systems are designed for fast retrieval or fast 
update.  It is difficult to assess query performance, we all know how 
meaningless the old TPS tests were that the RDBMs used to quote all the time.

I agree with Dawn some of Caches object model for data is quite innovative and 
how it propagates to client tools is nifty.

With IBM U2 was under resourced, with Rocket U2 has better resources and it is 
in a much better position to advance quickly with new innovation, it is now 
time for ideas.

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


Re: [U2] U2UG Elections 2010 - Request For Comment

2011-03-21 Thread David Jordan
The user group is for the users.  If any user has an idea that we can put into 
a business plan then we can put it to Rocket and Rocket will respond on the 
merits of the plan.   What is difficult at the moment is what we can do.  
Rocket advertises the user group in its emails, at the U2 University.  Susie 
regularly advertises the user group in her presentations around the world.  
Every U2U bag has a U2UG advert paid for by Rocket.

The issue of membership is about relevance to users.   For a user who is using 
a ERP solution, they are more interested in belonging to the ERP solution user 
group than the U2 User group.  So who is our audience, ISVs, consultants, 
programmers, etc.   Both George in the UK and Brian in Australasia advertise 
the user group to their ISVs.  However the ISVs rarely advertise to their 
customer base.

We all wish we could get the message out there more, but what we need is ideas 
more than money.   


David Jordan

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


Re: [U2] U2UG Elections 2010 - Request For Comment

2011-03-21 Thread David Jordan
First Fft2001 Can we have your name.  How do we know that you are not someone 
from a competitor like Oracle trying to make Rocket look bad.  

Secondly the focus on money is pointless.  We don't need money we need ideas.  
If anyone has a good idea and it needs some money from Rocket to make it 
happen, then I am sure that Rocket will consider it.  Rocket is not like IBM 
who were sucking money out of U2 to push DB2, Rocket brought U2 to grow the 
business and if you have any ideas that will grow the business they will 
listen.   Throwing money at a problem does not solve it.  The board have racked 
their brains trying to come up with ideas to touch base with all users, if 
anyone has ideas let us know.

Thirdly the directors don't have the time to do everything that is required, 
many hands make light work and we need more involvement of other users.

Regards

David Jordan

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


Re: [U2] U2UG Elections 2010 - Request For Comment

2011-03-21 Thread David Jordan
Thanks Ron

Not knowing raises concerns of what are the motives behind the emails.  Will 
probably means well, but misunderstands what Rocket is doing for the U2UG and 
some of his comments are unfair to the people involved.

David

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


Re: [U2] U2UG Elections 2010 - Request For Comment

2011-03-21 Thread David Jordan
Hi Dawn

I was raising an issue of etiquette to put names to emails so that everyone 
knows who they are dealing with and it is transparent that there are no hidden 
agendas.  Not everyone knows who Will is as he has a meaningless email and he 
signs off with W.  George would not know that Will was on the board of U2UG.  I 
was trying to raise a perspective, that not knowing who you are dealing with 
raises questions about what are the motives.  Members particularly new members 
don't know if Will is working for jBase or Intersystems or other competitors, 
so being upfront with who you are clears the air for everyone in discussions 
and minimises misunderstandings.

Regards

David Jordan

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


Re: [U2] Unidata sessions stop at any time

2011-03-19 Thread David Jordan
Hi Marco

Call support of the guys you brought Unidata from, I think there is a patch for 
your issue.

Regards

David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marco Antonio Rojas 
Castro
Sent: Sunday, 20 March 2011 6:11 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Unidata sessions stop at any time


Hello

Unidata 7.1.0 on Windows 2008
installed 2 weeks ago. 80 users logged on Unidata sessions stop at any time

Event viewer show these messages

Error19/03/2011 11:42:17Application Error1000(100)
Aplicación con errores udt.exe, versión 7.1.0.3146, marca de hora 0x42c2d61b, 
módulo con errores unknown, versión 0.0.0.0, marca de tiempo 0x, código 
de excepción 0x8026, desplazamiento con errores 0x7549a57d, Id. de proceso 
0x38bc, hora de inicio de la aplicación 0x01cbe65488e6d5b1.
(1100 occurs)
Error19/03/2011 12:05:21UniData Telnet1004NingunoTelnet set 
client binary mode failed..
(13 occurs)
Error19/03/2011 11:41:47UniData Telnet1004NingunoTelnet 
Client/Site licensing inquiry failed..
(42 occurs)

How can I fix this ???

Regards, Marco Rojas

  
___
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] U2UG Elections 2010 - Request For Comment

2011-03-18 Thread David Jordan
 to improve 
membership, but what I can do to help others to prosper new members and spread 
the message.

I hope that I inspire others through passion and belief in the technology we 
use.  Whether it is working on the beta program for DataVu, or sitting down 
with Microsoft to see how to port UniVerse applications onto Microsoft Azure, 
or to talk to new developers about the benefits of U2 or seeing how we can get 
U2 to be included in University courses, all of these play a small role in 
making U2 stronger.  If there are 3,000 people all doing the same thing, think 
of what we could achieve.  

Regards

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


Re: [U2] Friendfeed and U2 EDA similarities

2011-02-20 Thread David Jordan
The main benefit for EDA is to be able to tell clients that your application 
runs on Oracle, DB2, SQL Server, etc.  At the end of the day the customer may 
just run U2, but it enables a VAR to meet a criteria.  Tender documents might 
require that products have to run on Oracle that would have denied U2 
applications the opportunity.  Termenos has sold their pick application on 
Oracle.  As a banking system, customers feel more comfortable with Oracle as a 
database, so why loose the sale when you can say I run on Oracle.

The question is, how much of the Database needs to be put on the external 
database to satisfy a customer's expectation.  Do you just transport 
information for enquiry/data warehouse data or do you transfer the whole 
transaction database.

One are to be aware is that most pick applications are pessimistic locking and 
SQL databases prefer optimistic locking for performance.   It would usually 
require U2 to the only application updating the database.

Regards

David Jordan

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


Re: [U2] Frustrated with Rocket / Unidata 7.2

2011-02-17 Thread David Jordan
U2 has probably spoiled us.   You should see some of the issues others face 
upgrading in Oracle, SQL Server, Windows and so on.  We have an expectation of 
seamless upgrades that does not occur in other environments.   For people to 
have software that is 25 years old still running on U2 is pretty good.

Regards

David Jordan

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


Re: [U2] U2 DataVu Query

2010-11-19 Thread David Jordan
You need to populate that UD.ACCOUNT with a record for that UD.ACCOUNT.  You 
can either manually create it or use UniAdmin to update an already created 
account.   You may also need to fill in the description field.

Regards

David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce McAdoo
Sent: Saturday, 20 November 2010 8:46 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] U2 DataVu Query

Using unidata 7.1, testing U2 DataVu Query, established and tested connection 
successfully, but unable to have any data files displayed to select via the 
Create New U2 Query.  I was able to view files and create U2 Query when I use 
the DEMO account.   Any ideas would be greatly appreciated.

Bruce W. McAdoo
Wagner  Brown, Ltd.
bmca...@wbltd.commailto:bmca...@wbltd.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] UniRPC Connection

2010-10-10 Thread David Jordan
Bill

At one stage in UniVerse, in Service to tick the box to allow the service to 
interact with the desktop.  If it is a Win2008 server there are issues with 
User access Control.   Finally I have had a problem with Win2008 with one of 
the rpc dlls going missing and had to copy back that dll.

Regards

David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Monday, 11 October 2010 11:19 AM
To: U2 Mail List
Subject: [U2] UniRPC Connection

  I have access to multiple UniData servers and connect to these servers via 
RDP on Windows.  I use UniAdmin to administer the UniData dbms.  On one 
particular server I last used UniAdmin about four months ago without any 
problem.  However, now when I try to connect via UniAdmin I get the message No 
RPC Connection active.

Looking on the machine at netstat I see:

C:\Documents and Settings\myusernetstat -an

Active Connections

   Proto  Local Address  Foreign AddressState
   TCP0.0.0.0:21 0.0.0.0:0  LISTENING
   TCP0.0.0.0:25 0.0.0.0:0  LISTENING
.
.
   TCP0.0.0.0:31438  0.0.0.0:0  LISTENING
.
   TCP192.168.20.141:139 0.0.0.0:0  LISTENING
   TCP192.168.20.141:1045216.52.233.221:443 ESTABLISHED
   TCP192.168.20.141:982375.145.23.137:1914 ESTABLISHED
   TCP192.168.20.141:3389192.168.20.140:56293   ESTABLISHED
   TCP192.168.20.141:31438   75.145.23.137:2739 TIME_WAIT
.

As can be seen, the service is in running and my failed attempt to connect has 
been noticed.  I've rebooted the server and still cannot connect.  I've tried 
several variations of login credentials to no avail and am logged in via telnet 
on port 9823.  A look at services shows that the UD RPC services, the UD Dbms, 
and the UD Telnet service are all running.

I can open up a DOS window on my local machine and telnet theiraddress  31438 
and connect, so I know the router is properly routing port 31438 to the correct 
machine.

Does anyone know what I'm missing on my Sunday's sojourn in troubleshooting 
hell?

Thanks,

-- 

Bill Haskett
* / Advantos Systems, Inc./ *

___
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] [ud] Unidata as a SQL Server Linked Server via OLEDB

2010-04-22 Thread David Jordan
Hi Kevin

They do the same thing in IIS.  It is a security issue to restrict unauthorized 
users from accessing greater functionality.  I would suspect this is to stop 
hackers being able to use SQL Queries to access the operating system and 
carrying out malicious activities.   This is probably part of the security 
enhancements being made to SQL Server, maybe different patch updates between 
the 2 servers.

Regards

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


Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB

2010-04-20 Thread David Jordan
Hi Kevin

It maybe permissions on other folders on that server.  I would suspect that 
OLEDB needs to hold data in a temporary area, that temporary area may not be 
the same level of permissions on the box that is failing.  Calling within 
linked server may change where that temporary area is located.  Have you been 
able to link from that SQL Server to the other SQL Server?

Regards

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


Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB

2010-04-19 Thread David Jordan
Hi Kevin

Are you putting the domain name in the username dn\user for the logon to 
Unidata?

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


  1   2   3   4   5   >