Re: [U2] UniObjects and Hibernate

2006-10-13 Thread Wendy Smoak

On 10/13/06, Brutzman, Bill [EMAIL PROTECTED] wrote:


Does it make any sense to use Hibernate with UniObjects for Java?


I don't think so.  Hibernate is built on top of JDBC, and UniObjects
for Java is a completely different animal.  (UOJ is a proprietary,
non-standard API to UniData.)

It might be possible to use Hibernate with UniData/UniVerse, if the
JDBC driver will behave itself.  I've never gotten very far with it--
I can access the demo account with plain JDBC, but as soon as I try
anything remotely complicated, things start breaking.

Is there a particular problem you're trying to solve?

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


[U2] Shorter link to mailing list subscription info?

2006-08-22 Thread Wendy Smoak

I remember asking once before... is there a nicer-looking link
available for the mailing list info page, instead of:

http://u2ug.org/index.php?module=ContentExpressfunc=displayceid=5bid=21btitle=Main%20Menumeid=14

Something like http://u2ug.org/mail.php ,  perhaps?

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


Re: [U2] Shorter link to mailing list subscription info?

2006-08-22 Thread Wendy Smoak

On 8/22/06, Glen Batchelor [EMAIL PROTECTED] wrote:


  The server admin can create a mail.php script that includes the URL.


That or a page that simply redirects to the right one would be
fine... anything but that long, ugly URL that wraps and potentially
breaks depending on your mailreader.

The use case is responding to private email inquiries with, Please
ask on the u2-users list, you can find subscription info here: .

And yes, I realize this is volunteer work. :)  If someone has time to
create such a page, great.  If not I'll probably ask once a year or so
when I forget when I last asked and what the answer was.

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


Re: [U2] IBM UniVerse JDBC driver with WebLogic web application server

2006-08-17 Thread Wendy Smoak

On 8/1/06, Vance, Kathy [EMAIL PROTECTED] wrote:


Does anybody have the experience on how to configure the weblogic
connection pool with IBM UniVerse JDBC driver?


No, but that error looks familiar from a brief experiment with Spring
JDBC and UniData. :(

  http://wiki.wsmoak.net/cgi-bin/wiki.pl?UniDataSpringJDBC

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


Re: [U2] Unicommand Paragraphs

2006-08-10 Thread Wendy Smoak

On 8/10/06, gibboda [EMAIL PROTECTED] wrote:

I am using UniObjects for Java.  I am working on trying to run datatel query
paragraphs using the Unicommands.  I have successfully been able to run
select statements, list statements and download statements individually with
the unicommands.  But I have several queries in paragraph forms and having
trouble getting the unicommands to execute them.  Any suggestions will be
helpful.


Before you do anything Datatel-related, make sure you execute
'ENVINIT' and FR.JUMPSTART'.   (That's for Benefactor.  It might be
ST.JUMPSTART for the student system, etc.)

My guess is that an I-Descriptor in one of your paragraphs expects the
Envision environment to be there.

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


Re: [U2] Installing UniObjects on Linux

2006-08-08 Thread Wendy Smoak

On 8/8/06, gibboda [EMAIL PROTECTED] wrote:

I am trying to install the UniDK on Linux.  My goal is to get UniObjects and
UniObjects for Java installed on a Linux Machine to be able to communicate
with a AIX system containing Unidata.  I have search the internet and found
several examples of using UniObjects but none on how to install the UniDK on
Linux.  Any resources is appriciated.


There are some old instructions on the wiki...

* http://www.pickwiki.com/cgi-bin/wiki.pl?Redhat8UD6PEInstallInfo
* http://www.pickwiki.com/cgi-bin/wiki.pl?RedhatUV10InstallInfo

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


Re: [U2] Connection pooling with UniObjects for Java

2006-08-08 Thread Wendy Smoak

On 8/8/06, Steven Tomcavage [EMAIL PROTECTED] wrote:

I'd like to setup the connection pool to restrict the number of
simultaneous connections to be within our license. I'm rolling this
application out in the next month or so, so I don't have the option
of waiting.


Take a look at Jakarta Commons Pool: http://jakarta.apache.org/commons/pool/

That said, I considered object pooling way back when I started
developing with UOJ, and decided against it.  I haven't done any
profiling, but my feeling is that creating a connection is cheap
compared to opening files and reading records.

Trying to keep UniSessions connected, making sure they got cleaned up
properly, etc., was more trouble than it was worth.  I have a Factory
[1] that creates sessions, and I just close and discard them when I'm
done. YMMV -- my apps are not heavily used.

I'm now using the Spring framework, and letting it handle creating
sessions and injecting them into the objects that need them.

I'm also working on 'Spring UOJ' which (like Spring JDBC on which it's
based) uses the template method pattern to pull all of the exception
handling into the framework, and leave application code to concentrate
on calling subroutines and reading records.

Let me know if any of that sounds interesting...

[1] http://www.pickwiki.com/cgi-bin/wiki.pl?FailoverUniSessionFactory

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


Re: [U2] Getting information on udt processes

2006-08-07 Thread Wendy Smoak

On 8/4/06, Symeon Breen [EMAIL PROTECTED] wrote:

BTW I have found that port.status stack.trace, atleast on linux, on a
unirpcd process sometimes does not work, it does not return anything ! Not
sure why.


Sadly, that's the case with UniData on HP-UX as well. :(

:PORT.STATUS PID 3570 CALL.STACK

Licensed/Effective # of Users   Udt Sql iPhantomTotal

100 / 100  49  0   0   49

Udtno Pid User   Port Last command processed
433570useridudcs

Any other ideas?  Can I send it a signal like 'kill -3' to get a stack
track (and would it do me any good?)

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


[U2] Getting information on udt processes

2006-08-02 Thread Wendy Smoak

Occasionally we have some udt process that take up lots of resources
and never finish.  Most likely there's an endless loop in some
subroutine.

I know it's coming through unirpcd, because the processes are owned by
a user that is only allowed to connect that way.  Most likely it's in
a subroutine called by one of the Java apps.

We just kill the processes and life goes on.  Somewhere, someone's
browser has probably timed out, but no one has called to complain so
it's hard to figure out what's going on.

Rather than just kill the process, is there some way to get a stack
trace from it?  I'd love to find out what subroutine it's running.

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


Re: [U2] Getting information on udt processes

2006-08-02 Thread Wendy Smoak

On 8/2/06, Timothy Snyder [EMAIL PROTECTED] wrote:


Try PORT.STATUS PID 9 CALL.STACK.  It reports the call stack,
including the current line number for all executed programs and external
subroutines.


Thank you!  That's *exactly* what I need.  Now I just have to wait for
it to happen again. :)

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


Re: [U2] Getting information on udt processes

2006-08-02 Thread Wendy Smoak

On 8/2/06, Tom Dodds [EMAIL PROTECTED] wrote:


If you are on UniVerse it is LAYER.STACK instead of CALL.STACK.


Thanks!  I created a page on the wiki with an example of PORT.STATUS:

  http://www.pickwiki.com/cgi-bin/wiki.pl?ViewCallStack

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


Re: [U2] SOX question (United States only, I believe)

2006-07-19 Thread Wendy Smoak

On 7/19/06, Horn, John [EMAIL PROTECTED] wrote:


To distinguish from hacker who is someone who breaks into systems
for fun and the challenge of it.  A cracker does it for malicious
purposes.


Nope.  Hacker is not a pejorative term... it's properly applied to
people who make stuff work often for fun.

* http://en.wikipedia.org/wiki/Hacker

See also:
  Care and Feeding of your Hacker
 http://web.demigod.org/~zak/geek/hack.shtml

   0.0: Won't my hacker break into my computer and steal my trade secrets?

   No. Hackers aren't, contrary to media reporting, the people who
break into computers. Those are crackers. Hackers are people who enjoy
playing with computers. Your hacker may occasionally circumvent
security measures, but this is not malicious; she just does it when
the security is in her way, or because she's curious.

  The Cathedral and the Bazaar
 http://www.catb.org/esr/writings/cathedral-bazaar/

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


Re: [U2] SOX question (United States only, I believe)

2006-07-19 Thread Wendy Smoak

On 7/19/06, Tom Dodds [EMAIL PROTECTED] wrote:


Wendy, thanks for the new word, pejorative.  That's a great one.


:) I think this thread gets the prize for the most deviation from the
initial topic.  Shall we adjourn to u2-community before we get
evicted?

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


Re: [U2] CALLHTTP....UV 10

2006-07-05 Thread Wendy Smoak

On 7/5/06, George Gallen [EMAIL PROTECTED] wrote:


OK. Adding in the setHTTPDefault and the setRequestHeader got it working.

Now...I need to read an https:// URL


Not reading for content, but see if anything here helps:

  http://www.pickwiki.com/cgi-bin/wiki.pl?CallHTTPWithSSL

also:http://www.pickwiki.com/cgi-bin/wiki.pl?CallHTTP

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


Re: [U2] UniObjects security in an applet

2006-06-15 Thread Wendy Smoak

On 6/14/06, Adrian Merrall [EMAIL PROTECTED] wrote:


No you mention it.  IIRC there was a change regarding zip files.  The
contents of zip files are no longer automatically added to the
classpath, only jars.  An easy fix is to rename asjava.zip to
asjava.jar.  I know this is the case for the tomcat class-loader, but
I don't know if this a tomcat thing or a jvm thing.


That's a Tomcat (or possibly Servlet Specification) thing.

The JVM thing is that you have to specify the jar (or zip) filename on
the classpath.  You can't just say -cp /path/to/lib (where lib
contains some jars) and have them automatically picked up.
Conversely, if you have class files loose in a hierarchy, you need
only put the top level directory on the classpath.

That's why people will often extract the files from a jar and then
discover that it works.  :)

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


Re: [U2] UniObjects security in an applet

2006-06-15 Thread Wendy Smoak

On 6/14/06, Adrian Merrall [EMAIL PROTECTED] wrote:


No you mention it.  IIRC there was a change regarding zip files.  The
contents of zip files are no longer automatically added to the
classpath, only jars.  An easy fix is to rename asjava.zip to
asjava.jar.  I know this is the case for the tomcat class-loader, but
I don't know if this a tomcat thing or a jvm thing.


That's a Tomcat (or possibly Servlet Specification) thing.

The JVM thing is that you have to specify the jar (or zip) filename on
the classpath.  You can't just say -cp /path/to/lib (where lib
contains some jars) and have them automatically picked up.
Conversely, if you have class files loose in a hierarchy, you need
only put the top level directory on the classpath.

That's why people will often extract the files from a jar and then
discover that it works.  :)

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


Re: [U2] UniObjects security in an applet

2006-06-15 Thread Wendy Smoak

On 6/15/06, Jeff Powell [EMAIL PROTECTED] wrote:


So, it seems that the browser still won't even touch the proxy unless it
is on the same machine


Same machine as what?  An (unsigned) applet can only connect back to
the server from which it was loaded.  If you have a separate web
server and database server, the proxy needs to be running on the web
server.


and then I still have problems with the proxy not
connecting to the UniData server. Incidentally I cannot connect a
regular Java app through the proxy. I get the same RPC message.


Could there be a firewall preventing access?

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


Re: [U2] UniObjects security in an applet

2006-06-15 Thread Wendy Smoak

On 6/14/06, Adrian Merrall [EMAIL PROTECTED] wrote:


No you mention it.  IIRC there was a change regarding zip files.  The
contents of zip files are no longer automatically added to the
classpath, only jars.  An easy fix is to rename asjava.zip to
asjava.jar.  I know this is the case for the tomcat class-loader, but
I don't know if this a tomcat thing or a jvm thing.


That's a Tomcat (or possibly Servlet Specification) thing.

The JVM thing is that you have to specify the jar (or zip) filename on
the classpath.  You can't just say -cp /path/to/lib (where lib
contains some jars) and have them automatically picked up.
Conversely, if you have class files loose in a hierarchy, you need
only put the top level directory on the classpath.

That's why people will often extract the files from a jar and then
discover that it works.  :)

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


Re: [U2] UniObjects security in an applet

2006-06-15 Thread Wendy Smoak

On 6/15/06, Jeff Powell [EMAIL PROTECTED] wrote:


So, it seems that the browser still won't even touch the proxy unless it
is on the same machine


Same machine as what?  An (unsigned) applet can only connect back to
the server from which it was loaded.  If you have a separate web
server and database server, the proxy needs to be running on the web
server.


and then I still have problems with the proxy not
connecting to the UniData server. Incidentally I cannot connect a
regular Java app through the proxy. I get the same RPC message.


Could there be a firewall preventing access?

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


[U2] U2 on Rails?

2006-06-05 Thread Wendy Smoak

Is anyone else interested in Rails?  http://www.rubyonrails.org/

For me, it's fun to play with, but I figured the chances of it ever
talking to UniData were slim to none.  Then again...
http://alphaworks.ibm.com/tech/db2onrails

Maybe we will see U2 on Rails one day. :)

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


Re: [U2] Unit testing and UniObjects for Java

2006-06-02 Thread Wendy Smoak

On 5/8/06, Brian Leach [EMAIL PROTECTED] wrote:

Wendy

Sorry for the long answer, and some of this sounds like it may be too late,
but you've hit a hobby horse of mine here !


(Wow, was it that long ago?)  Anyway:  Good stuff.  :)  This is
another one of those posts we need to save.  May I put the text on the
Pick Wiki?

But don't worry, you're not too late.  What you described is more or
less how I write my application code.  Each file has a pair of
S.A51.WRITE.FILENAME and S.A51.READ.FILENAME subroutines, etc.
Probably no two of them have the same set of parameters, but we try.
:)

The question of unit testing UOJ comes from a different place:
framework development.  Ever since I discovered Spring JDBC, I've
wanted... Spring UOJ.

The Spring Framework uses the Template Method pattern (and unchecked
exceptions) to turn the mess of try/catch and duplicate code you end
up writing to do simple JDBC operations, into three or four lines.

Likewise, [what may eventually become] Spring UOJ makes calling a
subroutine look like this:

   UojTemplate ut = getUojTemplate();
   //fill Object[] array of params
   ut.call( subroutineName, params );

However, there *is* a use case for a simple read without forcing
people to write and catalog a subroutine.  (Less so for a write, IMO.)
So I wrote the 'read' method for the template... and discovered that
the design of UOJ makes it *really* hard to unit test.

Part of this is simple frustration with not having the source code,
and not having the 'asjava.jar' file publicly available makes it hard
to ask questions on other lists.  (More on that later-- we need to get
the UOJ jars into the public Maven repository on ibiblio, but I'm not
sure what license they're under.)

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


Re: [U2] Universe Java Web Client

2006-06-02 Thread Wendy Smoak

On 6/2/06, Brutzman, Bill [EMAIL PROTECTED] wrote:


This answer helps a lot.  Thanks.


Okay, okay, so we're still curious what you want to do with Universe,
JSF, and AJAX. :)

One of the things on my really long list of things to do is a web
front end for the 'demo' app that ships with UniData.  And then to
re-do it with different combinations of webapp frameworks and
middleware.

Lately I've been playing with Sun Java Studio Creator, which is an IDE
for creating JSF apps.  Hooking a JSF component up to a web service is
trivial with Creator.  I haven't come back around to see how far IBM
has come with 'native' web services for UniData, though.  I wasn't all
that impressed with the plain old XML handling last time I looked.

All in my spare time, of course...

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


Re: [U2] Universe Java Web Client

2006-06-02 Thread Wendy Smoak

On 5/31/06, Brutzman, Bill [EMAIL PROTECTED] wrote:


Is anyone doing JSF (Java Server Faces), and/or AJAX, not using RedBack?


Yes.  The question was so vague that I'm tempted to leave it at that. ;)

Honestly I'm happier in the 'Action Framework' world (Struts, WebWork)
than with JSF, but I have a foot in both camps.

I'm really not sure what you're asking, because your JSF application
code (whether or not it's using AJAX) should be well insulated from
any details about where the data is coming from.

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


Re: [U2] Universe Java

2006-05-29 Thread Wendy Smoak

On 5/29/06, Anthony Dzikiewicz [EMAIL PROTECTED] wrote:


So, all of you Java guys and gals what do you use to develop in
Universe/Java ?


IntelliJ IDEA and JEdit.  And Maven 2, though you weren't asking about
project management and build tools. :)

http://www.jetbrains.com/idea/
http://www.jedit.org/
http://maven.apache.org/

If IDEA isn't an option (it's not free, but worth every penny,) then
Eclipse and NetBeans have similar features.  With the right
combination of plugins, JEdit can get pretty close to a full IDE.

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


[U2] Unit testing and UniObjects for Java

2006-05-05 Thread Wendy Smoak

I'm going to set this project aside for the day, but I want to toss
the question out to see if anyone else has an answer.

I'm having a horrible time trying to unit test code that uses UOJ.  In
the past I've just 'cheated' and tested against the database itself,
but that really shouldn't be necessary.  It's also not unit testing
as the tests then cover the interaction between the code and the
database.

Here's an example of the code under test:

 uFile = uSession.openFile( filename );
 uString = uFile.read( key );

I'm attempting to mock the UniFile object, but I get:
  asjava.uniobjects.UniFileException: Cannot instantiate this object
in this manner.
 Must use the UniSession object

(So why even *have* a default constructor in UniFile?)

I'd love to hear how you're unit testing your UOJ dependent code.

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


Re: [U2] Using the BCI

2006-05-02 Thread Wendy Smoak

On 5/2/06, Victor St Clair [EMAIL PROTECTED] wrote:


I've seen this question asked from time to time, but I can't get into
the archives to find out what the answer has been.


What archives are you having trouble with?  I usually use Nabble:
  http://www.nabble.com/U2---Users-f801.html


I find myself the person assigned to a new development project with the
responsibility of learning to use the Basic Client Interface to access
data in an SQL2005 DB.   I have the BCI manual from IBM and am starting
my journey through it.  But I recall seeing comments in the past to the
effect of  the examples supplied are not that useful, you can get
better examples at ..


I did okay with the manual and the example program, though IMO the
example overly complicates the process with all the error checking. 
You'll find a few messages of mine in the archives when I was fighting

with BCI about one thing or another.

The main problem is that depending on your combination of OS and
target database, it can be difficult-to-impossible to find both a
driver and driver manager so that ODBC access to an external DB
actually works.

For example, connecting from UniData on HP-UX to Sybase never
worked... we ended up buying a single-user Windows license for UniData
so we could finish the project.  (Which then required the addition of
NFA to talk to the original UniData instance on HP-UX!)

I see your second note saying you're on Windows, so you'll be fine
there.  Give it a try and let us know if you have questions.

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


Re: [U2] Changes to the List

2006-03-16 Thread Wendy Smoak
On 3/16/06, Mike Preece [EMAIL PROTECTED] wrote:

 What do people think of the idea of moving this list to a google group
 instead?

If you prefer a newsgroup, it looks like the list is already on Gmane:
   http://dir.gmane.org/gmane.comp.db.u2.general

There's also Nabble, with a slightly different interface:
   http://www.nabble.com/U2---Users-f801.html

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


[U2] Re: [U2C] Changes to the List

2006-03-15 Thread Wendy Smoak
On 3/15/06, u2ug [EMAIL PROTECTED] wrote:
 All,
  We've now been living with the change to the lists for nearly a
 month. I'd like to invite opinions on the change. Are we all happy now
 that we are used to it?

My opinion hasn't changed.  I think reply-to-sender kills discussions
and does not serve the community well.  I try to be careful about
forwarding private mail to a public list, so now if I reply I have to
double check where the original post went, and then fix the To:
header.  Reply-to-all is not a solution, it causes duplicate mail
traffic and my filters flag replies as sent to me elevating their
importance when it's not warranted.

You can't please everyone, and there is no room for compromise on
this.  :::shrug::: It's not earth shattering, but since you asked...

--
Wendy Smoak
[EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2C] RE: [U2] Universe Scalability

2006-03-03 Thread Wendy Smoak
On 3/3/06, Jerry Banker [EMAIL PROTECTED] wrote:

Have you got any information on this or a link to the information?


The benchmark?  Here's a thread where it was discussed:
   http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg12746.html

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


Re: [U2] connection within UniVerse and Oracle

2006-03-01 Thread Wendy Smoak
On 2/28/06, Tony Gravagno [EMAIL PROTECTED] wrote:


 I agree with this approach and recommend mv.NET, which has many more
 features than UO (it can use UO as a pipe) but costs a lot less than
 RedBack.


 Having been outvoted on the choice of platform for a class project, I've
been spending some time in Visual Studio lately.  (Never say never!)  So of
course I want to see if I can talk to UniData. :)  Due to lack of time, I
haven't gotten farther than printing out the PDF mentioned here
http://pickwiki.com/cgi-bin/wiki.pl?AccessFromDotNet , but it's a start.

Would anyone else who's got this working care to contribute a .NET companion
to the longstanding UOJ example on the wiki?  Come on... here's your chance
to convert a confirmed Java developer. ;)

 * http://pickwiki.com/cgi-bin/wiki.pl?UniObjectsTest
 * http://pickwiki.com/cgi-bin/wiki.pl?TestMeInstructions

--
Wendy
http://marc.merlins.org/netrants/reply-to-useful.html
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] connection within UniVerse and Oracle

2006-02-28 Thread Wendy Smoak
On 2/27/06, [EMAIL PROTECTED] 
[EMAIL PROTECTED]  wrote:

 I am trying to establish a connection between UniVerse 10.1 ( aix unix )
 and Oracle (Window 2003), has anyone done this before? I was told to
 either use socket connection or ODBC. It seems that it is not that easy to
 use socket connection talking to Oracle, so I am thinking of using ODBC?
 Any ideas. Thanks.


BCI is supposed to work for this, but it really depends on the precise
combination of operating system and ODBC data source.  We were never able to
talk to Sybase from UniData running on HP-UX, but hopefully you'll have
better luck.  If there is a driver and driver manager available for your
combination, then you should be in business.

--
Wendy
... who hopes we put the list config back the way it was...
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Trouble writing to a file w/ trigger over NFA

2006-02-27 Thread Wendy Smoak
I'm having trouble writing to a file opened with NFA.  The file has an
update trigger, and I get:

WRITING TO RECORD TEST IN AS1.PERSON
Unable to open any log files.
Unable to open any log files.
ERROR WRITING TO TEST IN AS1.PERSON
Unable to open any log files.
Unable to open any log files.
Unable to open any log files.
:

(The two uppercase lines are my CRT statements.)

I can write to a plain file (no trigger) with no problems.

Any ideas?

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


[U2] Re: Trouble writing to a file over NFA

2006-02-27 Thread Wendy Smoak
On 2/27/06, Wendy Smoak [EMAIL PROTECTED] wrote:
 I'm having trouble writing to a file opened with NFA.  The file has an
 update trigger, and I get:

 Unable to open any log files.

Well, it's not the trigger.  I switched to the backup server, and saw
the same result.  Then I removed the trigger, and I *still* can't
write to the PERSON file.

What else could be different about two files that would make it
possible to write to one but not the other?

I'm picking files at random, setting up FX type VOC pointers and
testing whether I can read and write with NFA.  Some I can, some, I
can't... and so far I don't see a pattern.

Any ideas, even random guessing, is appreciated.  (Yes, I'm trying to
avoid calling my VAR.  They don't use NFA, and it was hard enough to
get them to sell it to us in the first place.)

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


[U2] Re: Trouble writing to a file over NFA

2006-02-27 Thread Wendy Smoak
On 2/27/06, Wendy Smoak [EMAIL PROTECTED] wrote:

 I'm picking files at random, setting up FX type VOC pointers and
 testing whether I can read and write with NFA.  Some I can, some, I
 can't... and so far I don't see a pattern.

 Any ideas, even random guessing, is appreciated.  (Yes, I'm trying to
 avoid calling my VAR.  They don't use NFA, and it was hard enough to
 get them to sell it to us in the first place.)

We figured it out.  The files I can't write to have one thing in
common:  indices on I-Descriptors that run Datatel-specific Envision
code.  That code won't run if the environment isn't properly set up. 
And I have no idea how to make FR.JUMPSTART and ENVINIT run as
part of an NFA connection.

:::sigh::: All this because we could never get ODBC to work from Unix.
 Workaround in progress... writing to a temporary file and then
processing it from the Unix side where the envionment will be correct.

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


Re: [U2] Creating a new record from UniObjects

2006-02-23 Thread Wendy Smoak
On 2/22/06, Jeff Powell [EMAIL PROTECTED] wrote:

 I'll look at how to implement using this. Because I'm new to UniData
 I've really only done a uni.command and parsed the response. That was
 fast but not very robust.

 I am planning to take a class in Denver next month but I think you may
 have given me a jump start.

I didn't mean to suggest that you should use the DAO pattern, just
that there are some examples of reading and writing scattered
throughout the page that might help. :)  I never finished that
example, it doesn't even show how to deal with multivalued and
mv-associated fields. :/

You'll probably also want to learn how to call subroutines from UOJ. 
IMO, that's the single most useful method for getting data out.  One
call, do whatever you need to do in UniBasic code on the database
side, and return whatever data the Java code needs.

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


Re: [U2][UV]Low user count Universe license available?

2006-02-22 Thread Wendy Smoak
On 2/22/06, Donnie Jacobs [EMAIL PROTECTED] wrote:
 Their commercial product runs on the linux version. I think the goal was
 to see the differences in the windows vs linux versions and see how the
 performance compared. I've since talked to him and he was aware of the
 limitations of the PE version. At this point, I suspect that he'll
 probably just buy whatever the lowest user count license he can get from
 his vendor and do his evaluations with that.

If he's evaluating the product, then why not ask for an evaluation
license?  We got one recently, a full version that worked for a month,
so we could make sure the Windows version of UniData would let us do
what we needed to. (Connect to an ODBC data source, which we never got
working from Unix.)

We ended up buying a single-user license of UniData for Windows.

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


Re: [U2] Creating a new record from UniObjects

2006-02-22 Thread Wendy Smoak
On 2/22/06, Jeff Powell [EMAIL PROTECTED] wrote:

 I would like know how to create a new record from UniObjects for Java.

 Any ideas would be appreciated.

What do you have so far?  Are you asking how to construct the Java
object, or how to make a new record appear in the database?

There are some examples of reading and writing on this page:
   http://www.pickwiki.com/cgi-bin/wiki.pl?DataAccessObjectPattern

If you write a record with a key that doesn't currently exist, you'll
have a new record.

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


Re: [U2] Is there a Better Editor?

2006-02-21 Thread Wendy Smoak
On 2/21/06, Caskey, Michael [EMAIL PROTECTED] wrote:

 2. Is there a better query editor; text-based or GUI or both?

If you have wIntegrate, you have the wIntegrate Editor.  You can 'open
from host' and edit UniBasic programs and UniQuery paragraphs locally,
saving changes back to the UniData account.

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


Re: [U2] Why does IBM make it so hard on the Newbies?

2006-02-17 Thread Wendy Smoak
On 2/17/06, Walter Vaughan [EMAIL PROTECTED] wrote:
 Tried to install UV Personal Edition on a RH-FedoraCore 3 box. Now I must 
 admit
 I am 3000% better admin on a FreeBSD box than anything else, however it should
 never be this hard to install demonstration software.
...
 IBM, Don't make it impossible for us to install PE without mind reading 
 skills.

Now that you've figured it out, could you take a look at the Wiki and
comment on whether it's out of date?
   http://www.pickwiki.com/cgi-bin/wiki.pl?Redhat8UD6PEInstallInfo

I also remember installing on Linux being somewhat less than intuitive. :)

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


[U2] BCI with two statement environments

2006-02-08 Thread Wendy Smoak
I'm able to use BCI (UniBasic SQL Client Interface) with one statement
environment, but when I try to add a second one it stops working.

The manual says You allocate the SQL statement environment with the
SQLAllocStmt function. This function allocates memory for an SQL
statement environment and returns its address, or handle, in a
variable. You can establish more than one SQL statement environment
for the same connection environment.

If I remove the query, then the update works.  Both the query and the
update work fine if I paste them into a SQL query tool.

Is there something else I need to do to get multiple statement
environments to work?

Code:
STATUS = ''
STATUS-1 = SQLAllocEnv(database.env)
STATUS-1 = SQLAllocConnect(database.env,connection.env)
STATUS-1 = SQLConnect(connection.env, DATASOURCE, USERNAME, PASSWD)

STATUS-1 = SQLAllocStmt(connection.env,query.stmt.env)
STATUS-1 = SQLAllocStmt(connection.env,update.stmt.env)
GOSUB CHECK.STATUS

;* Try querying before updating...
STATEMENT = 'select * from FoundationFamilyDataCollection'
CRT STATEMENT
STATUS-1 = SQLExecDirect(query.stmt.env,STATEMENT)
MSG = 'Executing query'
GOSUB CHECK.STATUS

DATESTAMP = OCONV(@DATE,D4/MDY)
STATEMENT = UPDATE tPAMemberInfo SET updatedDatetime =
':DATESTAMP:' WHERE rowId = '1'
CRT STATEMENT
STATUS-1 = SQLExecDirect(update.stmt.env,STATEMENT)
MSG = 'Executing update'
GOSUB CHECK.STATUS

Output:
: XWDS.TEST.BCI.WRITE
select * from foundationfamilydatacollection
UPDATE tPAMemberInfo SET updatedDatetime = '02/08/2006' WHERE rowId = '1'
STATUS IS -1
MSG IS Executing update
ERROR, STOPPING.

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


[U2] Re: BCI with two statement environments

2006-02-08 Thread Wendy Smoak
On 2/8/06, Wendy Smoak [EMAIL PROTECTED] wrote:

 If I remove the query, then the update works.  Both the query and the
 update work fine if I paste them into a SQL query tool.

... and if I do the update before the query from UniBasic, I don't get
an error.  That won't really work, though.  Until I query I have
nothing to update. :)

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


Re: [U2] BCI with two statement environments

2006-02-08 Thread Wendy Smoak
On 2/8/06, David Jordan [EMAIL PROTECTED] wrote:

 I'm able to use BCI (UniBasic SQL Client Interface) with one statement
 environment, but when I try to add a second one it stops working.

 It has been while since I worked with BCI, but I am sure that you have to
 reset the sqlallocstmt for each query.

Thanks for your help.  As far as I can tell, I allocating a new
statement for each one:

STATEMENT = 'update ...'
STATUS-1 = SQLAllocStmt(connection.env,update.stmt.env)
STATUS-1 = SQLExecDirect(update.stmt.env,STATEMENT)

STATEMENT = 'select * from ...'
STATUS-1 = SQLAllocStmt(connection.env,query.stmt.env)
STATUS-1 = SQLExecDirect(query.stmt.env,STATEMENT)

In that order, it works fine.  If I put the query first, (which I need
to do!) I get a status of -1 when I try to execute the update.

Does a query do something else to the overall environment that I need
to deal with in order to be able to update a table while I'm cursoring
through a selection from a view?

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


Re: [U2] BCI with two statement environments

2006-02-08 Thread Wendy Smoak
On 2/8/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:

 is the update section returning
 a value which you need for the query section?  Is something running
 after the update section before the query that is needed for the query
 section?

No.  That was lifted straight from a little test program I'm using to
try to figure out what's wrong.  In fact I need to run the query (and
the associated column bindings, etc.) first in order to get the rowId
I am supposed to update.

Still no idea why the update-then-query works, but not the other way around. :/

Thanks... keep the ideas coming.  I know other people are using two
statement environments, so clearly I'm doing something wrong. :)

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


Re: [U2] BCI with two statement environments

2006-02-08 Thread Wendy Smoak
On 2/8/06, David Jordan [EMAIL PROTECTED] wrote:

 Could you not do that as one SQL statement ie as below

 UPDATE .. WHERE ID = (SELECT id FROM table WHERE ...)

No.  That's stripped down from the actual code until I can figure out
what I'm doing wrong.

The original program selects a bunch of rows from a view, cursors
through them, and updates a different table as it processes each row. 
I can't write back to the view, and I don't want to write at all until
I've evaluated the data in the row and done my processing.

(And since once again I've forgotten to mention it:  UniData 6.1.)

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


Re: [U2] Index at infocus

2006-02-03 Thread Wendy Smoak
On 2/3/06, Doug Miller [EMAIL PROTECTED] wrote:

 Funny because I was just going to post about this as well.  Have not
 used it in quite a while and wouldn't you know it, when I wanted it,
 it was down.

There are archives here, though I don't think they go back as far as Infocus:
   http://www.mail-archive.com/u2-users%40listserver.u2ug.org/

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


Re: [U2][UV] Universe and SQL Server

2006-02-02 Thread Wendy Smoak
On 2/2/06, Nick Cipollina [EMAIL PROTECTED] wrote:

  I know there are ways to communicate directly between SQL
 server and Universe and I am looking for the best way to do this.

(Caveat:  my experience is with UniData.)

What OS is UniVerse running on?  If it's Windows, you can easily
access an ODBC data source from UniBasic using 'BCI'.

If it's Unix, it's going to depend on the precise combination of your
OS, and whether a driver and driver manager is available for the
target DB (SQL Server in this case.)

It ought to work in the other direction as well, UniVerse as an ODBC
data *source*, but I've never managed to get it to work.  (Probably
more due to Datatel than UniData.)

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


Re: [U2] Newbies need love too

2006-02-01 Thread Wendy Smoak
On 2/1/06, Nick Cipollina [EMAIL PROTECTED] wrote:
 Check out http://www.discoverycomputersystems.com/  I got my Universe
 training at Marcie's school.  She now only does onsite training, but she
 is definitely one of the best instructors I have ever had.  She has a
 lot of experience, and was one of the trainers at PICK.

I've attempted to capture all of the links that were suggested on this
Wiki page:
   http://www.pickwiki.com/cgi-bin/wiki.pl?UniVerse/GettingStarted

Please feel free to add more!  (To edit, click preferences, and the
admin password is Mr. Pick's first name in lowercase.)

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


[U2] Is a dynamic array empty or not?

2006-02-01 Thread Wendy Smoak
I'm probably missing something obvious here...
What can I use to evaluate the emptiness of these arrays, so that 1
and 2 are considered empty and 3 is not?

   TEST.1 = @VM:@AM:@VM:@VM:@AM:@AM
   TEST.2 = @VM:@AM:' ':@VM:'  ':@VM:@AM:'   ':@AM
   TEST.3 = @VM:@AM:' ':@VM:'zzz':@VM:@AM:'abc':@AM

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


Re: [U2] Is a dynamic array empty or not?

2006-02-01 Thread Wendy Smoak
Here's what we came up with, just for fun:
IF SUM(NOTS(NOTS(TRIMS(REPORT.DATA2 THEN CRT 'Not empty!'

The TRIM(CONVERT(...)) answer would work as well, I think.  I don't
want to change the value of the array-- if it's not empty, I need to
print it.

(UniData, BTW, sorry I didn't mention it.  And the values that contain
only spaces should be considered empty.)

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


Re: [U2] Newbies need love too

2006-01-31 Thread Wendy Smoak
On 1/31/06, Walter Vaughan [EMAIL PROTECTED] wrote:

 Is there not a UniVerse for Dummies website? Our sales rep asked his
 programmer and he said, I learned it 20 years ago, I don't know how you would
 learn it today.

 I have 23 and 28 year old programers that will have to live with this solution
 for the next 20 years. They're bright, but in order to get them excited about
 this platform I need to let them experiment.

I'm not aware of any introductory material... you just have to dive in. :)

Have them install the Personal Edition on their development
workstations, then go through the library of PDFs.

 * http://www14.software.ibm.com/webapp/download/search.jsp?go=yrs=u2trials
 * http://www-306.ibm.com/software/data/u2/pubs/library/100univ/univ_101.html

It goes without saying that they should be subscribed to u2-users!

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


Re: [U2] Java Platform Struggles

2006-01-25 Thread Wendy Smoak
On 1/24/06, Vance, Kathy [EMAIL PROTECTED] wrote:

 You guys have lots of experience on using UniObjects. May I ask How do
 you manage the DB connection with UniObjects? How could I check the
 number of DB connections in UniVerse while a web based Java app is
 running?

Guessing that you mean you want to check the number of connections
coming *from* the Java app, a connection pool would be appropriate. 
Even if you never return connections to the pool, you can use the
general pattern to limit (and query for) the number of connections.

I don't, I just use a Factory (the UniSessionFactory mentioned earlier
in the thread) to create connections, and throw them away when I'm
done.  I had trouble trying to re-use connections early on, and
determined that it's fairly cheap to create a new one-- opening files
and reading records takes *far* more time.

IIRC there is a generic object pool in Jakarta Commons that works, I
used it briefly.  You won't be able to use any of the existing
connection pools because they all expect a JDBC DataSource or
something similar.

(I occasionally want to write a thin layer around UOJ that makes it
look like a JDBC driver... in fact I think someone here might have
done it already.)

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


Re: [U2] Java Platform Struggles

2006-01-23 Thread Wendy Smoak
On 1/23/06, Brutzman, Bill [EMAIL PROTECTED] wrote:

 I am writing to inquire... what Java tools are people using with U2?

 We have UniVerse running on HP-Ux.

What do you mean by 'tools'?

We use the JDK/JRE from HP.  We're on 1.5.0.01 at the moment, from
June 2005.  There might be a newer one out there.  In my experience,
HP's JVM can be a little flaky, but no major problems.

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


Re: [U2] [UD] XML Question...

2006-01-12 Thread Wendy Smoak
On 1/12/06, David Wolverton [EMAIL PROTECTED] wrote:

 So... Now I'm sitting in my UniBASIC routine, with a complete XML document
 in hand, assigned to a UniBASIC Variable - but - and this is the part that
 confuddles me - it appears none of the U2 UniBASIC XML extensions would be
 usable against that XML item held in a variable unless I write it out to
 disk, then 'open' it and read it...

I've only done it the other way around, creating XML in UniBASIC and
sending it out with CallHTTP.  When I was working with it (a while
ago) I could not create XML in memory, I had to write it to a file and
then read it back in as text.  I suspect you're seeing the same thing
in reverse, unfortunately.

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


Re: [U2] UniVerse call to Java class

2006-01-11 Thread Wendy Smoak
On 1/11/06, Brutzman, Bill [EMAIL PROTECTED] wrote:

 I believe that there is a way to invoke a Unix command-line thing (program)
 from within UniBasic.

On UniData it's PCPERFORM.  I may have edited it out, but one question
I had was, what kind of volume are we talking about here?  Five
transactions an hour?  A minute?  A second?  More?

You do *not* want to do the equivalent of:
PCPERFORM java com.exampleMyClass param1 param2
either directly, or indirectly by calling a script that does the same thing.
It's going to create a JVM (Java Virtual Machine) every time.  That
won't scale at all.

I'm finding it hard to believe that a Java API is the only way to talk
to the LiveProcessor software _and_ that all you can do with the Java
API is make a call to process a single transaction.  But assuming
that's all true, I'd approach this one of two ways:

I'd still lean towards a sockets-based solution.  UV would use
CallHTTP to talk to an instance of Jetty or Tomcat running a little
Servlet that picks up HTTP request parameters, makes the call to the
LP server, gets that response, and then sends a response back to UV.

The Servlet container will handle threading, parsing the request and
forming the response, etc.  All you'll have to do is call
request.getParameter(...) insert the Java code to talk to the LP
server, and response.write(...).  I think.  I haven't done pure
Servlets for a while. :)

I don't like this as much:  Have UV write a record to a table with the
transaction information.  From Java, with UOJ, constantly read records
from that table, process the transactions, and write back to it.  Make
sure you lock the records properly.

I don't see why you can't talk directly to the LiveProcessor software
with CallHTTP or a plain Socket, though.  Their Java client has to be
connecting somehow...

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


Re: [U2] UniObjects for Java on Linux

2006-01-11 Thread Wendy Smoak
On 1/11/06, PJ Velzeboer [EMAIL PROTECTED] wrote:
 I have an interesting problem. I have written a jsp page which queries data
 from a UniVerse database using UniObjects for java (asjava.uniobjects.*).
 Whenever I read a field from a file the contents of the UniString are in the
 following format field1?field2?field3?filed4 etc. Effectively this means that
 using UniDynArray.extract(field, value, subvalue); doesn't work. Does anyone
 have any ideas?

Yes.  Move the code to a Servlet, populate a collection of objects,
and use JSTL to display the values:
table
   c:forEach items=${transactions} var=txn 
 tr
td${txn.code}/tdtd${txn.branch}/tdtd${txn.operator}/td
 /tr
   /c:forEach
/table

Oh.  You meant about the question marks. ;)  Check the LANG settings
on both the client and server... LANG=C is known to work.

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


Re: [U2] CallHTTP

2006-01-09 Thread Wendy Smoak
On 1/9/06, Peter Veenhof [EMAIL PROTECTED] wrote:

 Does anyone have a simple example of doing a HTTP POST from within
 Universe Basic? The documentation doesn't have any example code and I've
 failed to get it to work.

The Pick Wiki has:
   http://www.pickwiki.com/cgi-bin/wiki.pl?CallHTTP
and
   http://www.pickwiki.com/cgi-bin/wiki.pl?CallHTTPWithSSL

There might be something here as well:  http://www.picksource.com/

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


Re: [U2] Java CallableStatement help

2006-01-04 Thread Wendy Smoak
On 1/4/06, Baker Hughes [EMAIL PROTECTED] wrote:

 I'm still trying to wrap my mind around the UniVerse implementation of
 Java.

IBM provides an implementation of the JDBC specification, (a JDBC
driver,) as well as a proprietary Java API known as UniObjects for
Java.

 I need to trigger a call, from UV, to a Java API, sending Credit Card
 data to our processor.

 From what I can read, the CallableStatement in UV looks like what I
 need.  Does anyone have any fragment or code example of this, or other
 call to a Java interface?

If you mean the the JDBC CallableStatement, you would use that to talk
to UV from Java.

It sounds like you want to use UniBasic to call a Java program.  Is
that correct?

What does the call to the credit card processor's Java API look like? 
Depending on how you interact with their API, there are lots of ways
to do this.  And if you name the processor or the API you're using,
quite possibly someone here has already done it. :)

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


Re: [U2] Java CallableStatement help

2006-01-04 Thread Wendy Smoak
On 1/4/06, Baker Hughes [EMAIL PROTECTED] wrote:

 Yes, I was reading the docs on it, but no code samples there, so things
 still a bit fuzzy.

Look in (the equivalent of) c:\ibm\unidk\uojsdk and c:\ibm\unidk\jdbc
for samples.

 I'm trying to call the Live Processor (from Retail Decisions) Java API.
 LPTransaction() has these methods:
 clear()
   Clears/Resets all the properties in this transaction.
 getField(java.lang.String keyword)
   Retrieves the value of the specified property identified by
 keyword.
 process(LPClient client)
   Sends the request to LiveProcessor server for processing and gets
 the response.
 setField(java.lang.String keyword, java.lang.String value)
   Assigns the specified value to the property identified by keyword.

Are you already able to process a transaction using (only) Java code? 
Is the question how to do the entire thing, or just how to hook it up
to UV?  I don't think we have enough information to be of much help...
I'm not sure where you're stuck.

Have they only given you a low level process a single transaction
API?  If so, you'll have to do some work in Java before it's ready to
be called from UniBasic.  And at that point I'd be leaning towards a
sockets-based approach.

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


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

2005-12-28 Thread Wendy Smoak
In UniData 6.1, I need to list the F-type VOC items with counts of the
records and dictionary items.

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

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

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

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

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

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

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

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


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

2005-12-28 Thread Wendy Smoak
On 12/28/05, Koser, Mike [EMAIL PROTECTED] wrote:

 RESULT-1 = @SYSTEM.RETURN.CODE

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

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

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

 LIST VOC DATA.RECORDS DICT.RECORDS 14:49:55 Dec 28 2005 1
DATADICT
 VOC... RECORDS RECORDS
 PARTIAL.ORDER.FILE.PROMO 1 562
 ORDER.LOG.PROMO 234065  10

With or without the -1, I get

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

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

PERSON  0 3909
1 record listed

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

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

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


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

2005-12-28 Thread Wendy Smoak
On 12/28/05, Mike Rajkowski [EMAIL PROTECTED] wrote:

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

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

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

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

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

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


Re: [U2] UniObjects for Java - UniDynArray question

2005-12-06 Thread Wendy Smoak
On 12/6/05, Bob Little [EMAIL PROTECTED] wrote:

 I am working with UD71 PE, and UniObjects for Java.  I cannot get a
 UniDynArray object to insert values as expected.  Here is some sample code:

 I would have expected to see Attribute 2 contain 2 values, but instead,
 value two becomes another attribute.

I get (Maven 2 build w/ your code in a unit test):

---
 T E S T S
---
[surefire] Running net.wsmoak.AppTest
[surefire] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.016 sec
Attribute count: 2
Attribute 1: ATTR 1 VAL 1
Attribute 2 Value 1: ATTR 2 VAL 1
Attribute 2 Value 2: ATTR 2 VAL 2
Value count of attribute 2 is:2
Attribute 3:
[surefire] Running net.wsmoak.uoj.UniDynArrayTest
[surefire] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 1.313 sec

Results :
[surefire] Tests run: 2, Failures: 0, Errors: 0

This is against UD6, but I doubt anything has changed significanty in
the UniDynArray code.  Check your LANG settings on both the client and
server, it's probably not writing the correct ASCII character for the
delimiter.

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


Re: [U2] MVInternet Replacement

2005-12-06 Thread Wendy Smoak
On 12/6/05, Andy Squires [EMAIL PROTECTED] wrote:

 We are currently using MvInternet to bridge quite a few UniBasic programs to 
 the Web.   We are about to undertake a major upgrade of our application 
 software, UniData
  and server.  We need to find a replacement

We used to use MVInternet, but have moved on to Java and UOJ.

I wonder... does anyone know who holds the copyright on the MVInternet
code and docs?  If they're not going to market it, could they be
convinced to put it under an appropriate open source license and set
it free?

Just a thought.  Unfortunately, I have no time to pursue it myself.

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


Re: [U2] MVInternet Replacement

2005-12-06 Thread Wendy Smoak
On 12/6/05, Wendy Smoak [EMAIL PROTECTED] wrote:

 I wonder... does anyone know who holds the copyright on the MVInternet
 code and docs?  If they're not going to market it, ...

Okay, maybe I should back up a step.  IIRC at some point after we
stopped using MVInternet, I heard that it was no longer available.  Is
that true?  I remember it changing hands between Infinetivity and
Pixius, but that's about it.

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


Re: [U2] User Name Change on Win XP affects Universe

2005-11-23 Thread Wendy Smoak
On 11/23/05, Anthony Dzikiewicz [EMAIL PROTECTED] wrote:
 Thanks for the tip.  I don't think this is the case here.  I don't have
 any network passwords stored.  I am using XP Home version on the Laptop.
 So, I have limited resources to modifying these kinds of things.  All I
 did was change my name in control panel.  Im not sure what Windows
 really does under the hood.

Having just changed my Windows username on XP Pro, it didn't seem to
change anything but the text you use to log into Windows.  For
example, under Documents and Settings, the user folder still had the
original name.

I ended up creating a new account and starting over, but I understand
there is a 'user migration tool' that can be used to transfer
settings.

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


[U2] Trouble with SQL privileges for JDBC access to UniData

2005-11-22 Thread Wendy Smoak
I never could get VSG to work in a Datatel account, but I followed the
instructions Simon posted to run 'sql' and exit, then call
'SCHEMA_MIGRATE' to create the files.
http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg12006.html

After that, when I try to access a file such as STAFF, I get:
   java.sql.SQLException: You have no privilege on file STAFF

Fair enough, so I try to grant privileges:

:sql
sql GRANT ALL PRIVILEGES ON STAFF TO PUBLIC;
Sorry, you have no privilege on this file!

I've tried this as root, and as the owner of all the files in the
account.  If neither of those users has priveleges on the file, then
who does?  And which file is it talking about?  The STAFF file, or one
of the ones that start with SQL?

JDBC access to the demo account works, so there must be something
wrong in this account, or with the way I'm setting up for SQL access.

Any advice?

Thanks!
--
Wendy Smoak
http://wiki.wsmoak.net/cgi-bin/wiki.pl?UniDataJDBC
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Need help with NFAUSER

2005-11-15 Thread Wendy Smoak
We have NFA working from Windows to HP-UX.  The last remaining problem is 
that, since we're running at a console, we get prompted for a username and 
password.


Page 3-28 of the Developing OFS/NFA Applications manual says,
UniBasic provides the NFAUSER function which enables you to set the user 
name and password in a UniBasic program.

Syntax:  NFAUSER(username, password)

When I try this, I get:

BASIC BP_SOURCE XWDS.BCI -i

Compiling Unibasic: BP_SOURCE\XWDS.BCI in mode 'u'.
main program: syntax error at or before
line 34 NFAUSER( user, pass )
 --^
Expecting: array,label,variable,verb,MAT,COM,ON,BREAK,PAGE,GOSUB

compilation failed

This seems to be the last holdup to our ODBC-access-from-UniData solution, 
which (since we never could get it to work from HP-UX) involves a Windows 
box speaking ODBC to Sybase, then NFA to UniData on HP-UX.


Am I missing something obvious?  There's no VOC pointer for NFAUSER.  The 
docs say it's been available since UniData 5.  Has it been replaced with 
something else?


Thanks,
--
Wendy Smoak 
---

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


Re: [U2] NFA and Triggers

2005-11-02 Thread Wendy Smoak

From: Wally Terhune [EMAIL PROTECTED]


I have not tried this, but I would expect the trigger defined on the file
on the remote system would work fine. There is no NFA file on the 'client'
system - just an 'FX' style file pointer - so you couldn't define a 
trigger

to fire on an FX pointer in the 'client' environment. (using 'client'
loosely - as the system with the FX pointer to a file on a 'remote' 
system)


We'll definitely try it out once we get it all set up.  Which brings me to 
another question... what do we need to buy?


From experimenting it seems like *only* the client machine [the one with the 
FX pointers] needs to have NFA turned on and licensed in confprod.  True? 
(We are in communication with our VAR but they are not experienced with 
NFA.)


--
Wendy 
---

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


Re: [U2] NFA and Triggers

2005-11-01 Thread Wendy Smoak

From: john reid [EMAIL PROTECTED]


Does NFA allow ANY trigger to run across machines?  I just tested with
Universe and I get a write failure with trigger code installed where
file lives, and I get an SQL error if I attempt to install the trigger
locally.  Kind've the worst of both worlds.


Thanks. :)  We're not quite to the point where I can try it out, but I 
wondered...


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


Re: [U2] connection from UniBasic to a SQL database

2005-10-14 Thread Wendy Smoak

From: HENDERSON MIKE, MR [EMAIL PROTECTED]


I've written stuff to read from a SQL database into UniBasic using the
BCI.

UV 10.0.15 to MS SQL Server 2000, all on Windows, using the MS SQL
Server driver.


I hear it does work on Windows.  On HP-UX, however, no one I know of has 
found the magic combination of driver manager and driver that actually 
works.


--
Wendy Smoak 
---

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


Re: [U2] connection from UniBasic to a SQL database

2005-10-14 Thread Wendy Smoak

From: Metherall, Arthur [EMAIL PROTECTED]


 We're running AIX and have found Easysoft ODBC-ODBC Bridge
software to be great!  (granted we're only pulling information from
MS SQL into UniData, but that's ALL we need it for.)


As soon as I hear from someone for whom it works on HP-UX on Itanium, we'll 
be there. :)


--
Wendy 
---

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


Re: [U2] [AD] What are you using to develop your web pages? JavaScript? PHP? .Net?

2005-10-13 Thread Wendy Smoak

From: Symeon Breen [EMAIL PROTECTED]


it is easy to read/write mysql from your Unibasic.


Really?  So far we have not been successful getting a connection from 
UniBasic to a SQL database.  What are you using?  (My guess is that you're 
on Windows.)


We're on HP-UX.  At the moment I'm reading from Sybase with their JDBC 
driver then using UniObjects for Java to write records into UniData.  It's 
working fine, but it would be *really* nice to connect directly to Sybase 
from a UniBasic program.


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


[U2] Visual Schema Generator 'unable to open dictionary of sysobjects'

2005-10-07 Thread Wendy Smoak
I'm trying (first time) to use VSG on an account, and all it will do is 
complain:  'Unable to open dictionary of sysobjects'.


All I can find online is a post on the u2ug forums from a person who had the 
same problem a while ago.  I also consulted our VAR's knowledge base, and 
found an article that said to make sure the various sys* files (sysobjects, 
syscolumns, etc.,) do NOT exist in the account, because VSG will create 
them.  Is that correct?


We did have 'empty' VOC pointers hanging around from somewhere, but none of 
the files were there.  I deleted the VOC pointers to sysobjects, etc., but 
it didn't help.  The This is on UniData 6.0 on HP-UX.


Any ideas?

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


Re: [U2] Visual Schema Generator 'unable to open dictionary of sysobjects'

2005-10-07 Thread Wendy Smoak

From: [EMAIL PROTECTED]


Does the D_sysobjects file exist and does your ID have permissions to
r/w it?


Nope... no dictionaries, no files, no VOC pointers for the sys* files.  I'm 
under the impression that VSG is supposed to create them.  Is that not true?


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


Re: [U2] Senior Pick Programming Position - Centennial, CO

2005-10-07 Thread Wendy Smoak

From: Debster [EMAIL PROTECTED]


Something most programmers hate to write


Not *nearly* as much as non-integrated documentation.  At least if the docs 
are in the program it's easier to keep them up to date.  (And with tools 
like Javadoc, you get neat HTML formated documentation out of the deal.)


I still don't know what a UniVerse flow diagram is... but it's nice to see 
someone looking for multi-value _and_ open source Java experience. :)


--
Wendy Smoak 
---

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


[U2] UniData as an ODBC _client_

2005-09-28 Thread Wendy Smoak
We've been trying to get this to work for years... it should be possible, in 
UniBasic, to connect to an ODBC data source and do a select, then cursor 
through the results.  I've even seen sample code.  Unfortunately, we've 
never been able to find all the pieces of the puzzle and make them fit 
together.  (Is this the same question as the Can Universe Play with Access 
thread?)


Were need a driver manager and driver for Sybase and Microsoft SQL.

The driver manager must present a shared library (libodbc.sl) that is 
compatible with UniData 6.1 on HP-UX Itanium.


In the past it has been critical to have a 64-bit library for an application 
that was compiled as 64-bit.  It was also critical to have a single threaded 
library, as Unidata was compiled as single threaded.


I don't have any absolute knowledge of either of these parameters for the 
current version of Unidata 6.1 on Itanium, but I suspect it might be 64-bit 
and multi-threaded.


--
Wendy Smoak 
---

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


Re: [U2] DOWNLOAD 7.13 is available

2005-09-21 Thread Wendy Smoak

From: [EMAIL PROTECTED]


Version  7.13 of DOWNLOAD is available from:
ftp.cedarville.edu



Is this freeware?


From the PDF manual:  This software was written at Cedarville University by 
Doug Sjoquist and modified by Dave Rotman. You may freely distribute this 
software, but this software is not to be sold

by itself nor as part of any other software package.

We've been using it for years... it's wonderful.  Particularly the XML 
output, which was way ahead of UniData's native abilities last time I 
compared the two.  (UD may have caught up by now... but given the choice I'd 
still use DOWNLOAD.)


--
Wendy Smoak 
---

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


Re: [U2] U2/UV Enhanced reporting tools

2005-09-21 Thread Wendy Smoak

From: James F Thompson [EMAIL PROTECTED]


Take a look at Informer
(http://www.entrinsik.com/solutions/informer.cfm).
We are still in the process of development, but it is very impressive.


Add another vote for Informer.  And not _just_ because it's a Struts-based 
webapp. ;)


We're still sorting through our out-of-control dictionaries to decide what 
I-Descriptors to use with Informer, but so far it's shaping up to be very 
nice.


And support has been exceptional, even when I wanted to toss their 
authentication/authorization mechanism and insert a custom JAASRealm to work 
with the campus Kerberos server.  While I'd much prefer to see the source 
code, they were at least willing to give me enough information about the 
inner workings so that I could be confident my code would work without 
breaking any of theirs.


--
Wendy Smoak 
---

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


Re: [U2] UniObjects

2005-09-21 Thread Wendy Smoak

From: Lance Jahnke [EMAIL PROTECTED]

I have just started to experiment with html frames where I can basically
have multiple reports on a single WEB page. Currently I have 3 panes on
a page with a report running in each pane (http call back to UniVerse
via UniObjects). * Sometimes * I will receive an ASP script error in one
of the 3 frames. Other-times this process works just fine. Considering
ASP is an industrial strength platform, I am wondering if UniObjects is
having a problem firing 3 http requests simultaneously to populate the 3
frames. Any thoughts on this?


Check the list archives for more information on UniObjects and thread 
safety.  Google turned up this post on the u2ug message board:

http://www.u2ug.org/modules.php?op=modloadname=phpBB_14file=indexaction=viewtopictopic=1103

(If that wraps, try: http://tinylink.com/?PaRT0ARc6H )

--
Wendy Smoak 
---

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


Re: [U2] PHP Options

2005-09-18 Thread Wendy Smoak

From: Dawn Wolthuis [EMAIL PROTECTED]


I know I've read about this topic on the list before, but it is hard to 
find

with a search because of all of the URL's with php in them.

What are the options for communicating with UniData from PHP? 
Thanks. --dawn


Have you seen Jeff Butera's work with PHP and InterCall?

At one point I made an attempt at a PHP-U2 extension (or module, whatever 
they call them,) but their brand of highly pre-preprocessed C was beyond my 
capabilities.


There are some more options listed here:
http://www.pickwiki.com/cgi-bin/wiki.pl?CreateWebInterfaces

--
Wendy Smoak 
---

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


[U2] Installed UD61PE ... where's UOJ?

2005-09-02 Thread Wendy Smoak

I installed the Personal Edition of UniData 6.1, and (I think) all of the
extra stuff (odbc, UniDK, UniTools...)

Then I went looking for UniObjects for Java.  Wasn't it in /usr/unishared 
before?  The notes on the Wiki say:  asjava.zip comes with any recent U2 
distribution, and is usually found in /usr/unishared/uojsdk after 
installation. On Windows, I'm told you can find it in 
c:\ardent\unidk\uojsdk\lib.


So I went hunting for 'asjava' and found asjava.jar in 
c:\IBM\UniTools\XMLDBTool.  (Finally, they realize that Java ARchives are 
supposed to have a .jar extension... the filename used to be asjava.zip.)


Does UOJ not come with the PE anymore?  (I mean, that's the only file I 
need, but if I didn't *know* that, I'd be a bit lost at this point.  I 
wouldn't have thought to look there.  And asjava_p.jar is missing, in the 
event you need a proxy.)  Or did I miss installing something?


And yes, I realize that complaining about free stuff is impolite, but I'm 
the one who spends time answering UOJ Getting Started questions, so I 
figure I'm entitled. :)


Thanks,
Wendy Smoak 
---

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


Re: [U2] Installed UD61PE ... where's UOJ?

2005-09-02 Thread Wendy Smoak

From: Wendy Smoak [EMAIL PROTECTED]


I installed the Personal Edition of UniData 6.1, and (I think) all of the
extra stuff (odbc, UniDK, UniTools...)

Or did I miss installing something?


Apparently! :)  Having installed some subset of the extras, there was 
already a UniDK directory, so I crossed it off my list prematurely.  The 
directory must have come from UniTools.  I installed _actual_ UniDK and now 
everything seems to be present and accounted for.  Carry on...


(Anybody interested in data access with UOJ + Spring?)

--
Wendy Smoak 
---

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


Re: [U2] Java theme at Seattle Area Pick Users Group 9/15 meeting

2005-08-31 Thread Wendy Smoak

From: Ross Morrissey [EMAIL PROTECTED]


Lately this list seems to be a Java list :)  Here's a meeting that will be
of interest to current and future UniObjects for Java users in the Pacific
Northwest (and anyone wishing to stay in touch with their MV community).


Any chance you'll have the presentation slides available after the meeting?

Thanks!
--
Wendy Smoak 
---

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


Re: [U2] UniSubroutine: ErrorCode: 30106: Wrong number of arguments supplied to the subroutine

2005-08-30 Thread Wendy Smoak

From: Rick Ward [EMAIL PROTECTED]


Does anyone have any idea why one would encounter
ErrorCode: 30106, Wrong number of arguments supplied
to the subroutine


Because the wrong number of arguments is being supplied to the subroutine?
;)


when the correct number of
arguments are being supplied to the subroutine?


Sorry... my experience has been that UOJ is usually right about such things,
and without seeing both your Java code and the subroutine code, it's
impossible to tell what's going on.

If it's *really* happening, it must be a bug and should be submitted to IBM.

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


Re: [U2] Java UniCommand

2005-08-23 Thread Wendy Smoak

From: Rick Ward [EMAIL PROTECTED]


We've recently started investigating the UniVerse java
interface. We're able to set up a connection, read
files, and execute simple commands, but I'm having a
problem getting on of my commands to run and return
any results.


I use UOJ extensively and would be glad to help, *but* I would suggest 
ditching UniCommand almost immediately in favor of UniSubroutine.


Invariably, you need to do more than one thing before returning a result. 
It's far better to make one call, have it do its thing, and then return one 
result (or more-- you have access to all the subroutine parameters).


What's the end goal here, to generate some XML from U2 and get it back to 
the Java program?


--
Wendy Smoak 
---

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


[U2] JDBC access to the UD Personal Edition

2005-07-05 Thread Wendy Smoak
So... where do I start?  I've only used UOJ to connect to UniData.  Now I
want to play with Hibernate, which will need to connect with JDBC.  I've
heard of 'Visual Schema Generator', is that what I need to start with?

If someone will just point in the general direction of how to get started, I
would appreciate it.  Better yet, if someone has written up instructions!

I'm playing with a new web application framework, and figured I might as
well learn something else new while I'm at it. :)  And if all goes well...
it'll turn into a demo app that you can drop into Tomcat and play with.

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


Re: [U2] Custom Functions

2005-06-23 Thread Wendy Smoak
From: Ray Wurlod [EMAIL PROTECTED]

 Try using the SUBR() function, as I mentioned in another post.


Ouch.  Granted my function opens a file and [currently, for debug] prints to
the screen, but attempting to call it with SUBR from an I-Descriptor
caused... '25945 Bus error' and left the session unresponsive.

Leaving aside the I-Descriptor issue for a moment...

Is there a way for it a function to assume that the last file opened is
the one I want to use?  I thought there might be an @FILE or something, the
way there is @ID and you can have a 'default' file for READ.

http://www.pickwiki.com/cgi-bin/wiki.pl?TreeTraversal

I thought of opening the file in the calling program, and passing a file
handle instead of the filename.  But I need this to work when called
[indirectly] from UOJ also, and historically I've seen 'Error 30102' if I
attempt to pass file handles around in any code called from UOJ.

Advice on how to improve this would be gratefully accepted [see code in Wiki
link above].

While the first one isn't TOO bad... there's a companion function that finds
all of the children of a particular node, and it calls the first function to
look back up the tree for any child that has multiple parents.  In that case
I open the same file over, and over and over.

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


Re: [U2] Custom Functions

2005-06-23 Thread Wendy Smoak
From: Ian McGowan [EMAIL PROTECTED]

 I don't get the example as posted - seems like F.FILE doesn't get saved
 anywhere between calls.

It doesn't -- it was enough to be able to pass in the file that I had
already opened in the calling program.

And then to pass the file handle into the A51.ALL.CHILDREN function and have
it pass the same file handle to A51.ULTIMATE.PARENT is the solution I wanted
for UniBasic programs.

The file gets opened once, that's what I was after.

Calling it from an I-Descriptor is another issue entirely, as it will get
called for each record.  I gather that common memory is the solution to
this, but I haven't done anything at all with that and I'm not sure I want
to... I just won't tell the report writers about these. :)

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


[U2] Connection Refused downloading PE

2005-06-23 Thread Wendy Smoak
After answering all those questions, I finally made it to the place where I 
could download UD 6.1 PE and the download applet reports  
http://service2.boulder.ibm.com:7618 Connection Refused .


The 'clients' .zip file is downloading over HTTP with no problems, but it 
looks like it's coming from a different place.


I'll try again tomorrow, meanwhile I figured I'd at least mention it in the 
hopes that someone from IBM might be able to check on it. Thank you!


--
Wendy Smoak 
---

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


RE: [U2] Status for READV?

2005-06-22 Thread Wendy Smoak
Ray Wurlod
 In UniVerse (you didn't specify) READV sets STATUS() in the 
 ON ERROR clause.
 The THEN clause is taken if the READV operation succeeded, 
 the ELSE clause is taken (and the receiving variable is set 
 to ) if the record does not exist.  According to online 
 help for STATUS() the function is not set in the THEN and 
 ELSE clauses unless there is a problem with NLS character 
 mapping (and then depending on a number of other factors.

Sorry... UniData 6.0 here.

The manual doesn't list READV as one of the things that sets STATUS() or
@SYSTEM.RETURN.CODE, and in my case I need to distinguish between the
receiving variable being  because there was really nothing in the
field vs. the 'ELSE' condition where it just couldn't be read.

It's just strange that STATUS() _does_ get set for all the other
versions of READ (READU, etc.)  Any insight on why it's missing for
READV? 

-- 
Wendy Smoak
Applications Systems Analyst, Sr.
Arizona State University, PA, IRM 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Custom Functions

2005-06-22 Thread Wendy Smoak
I was just looking at the documentation for FUNCTION after hearing a
couple of people make reference to custom functions.  How did we not
know about this?!  (Has this always been possible, or was it added
recently?)

We consider subroutines fairly expensive in terms of system resources,
and tend to just use GOSUB within most programs.  But coming from the
Java/OO world, the global variables are *killing* me.  And I'm partial
to the nested parenthesis notation as well.

Does anyone have any best practice advice or gotchas to impart?  We have
a need to find the Ultimate Parent in a tree of
corporation/parent/subsidiary relationships.

In particular, I might find a case where there is more than one
Ultimate Parent and I need to signify an error.  Do I return -1, or
set @SYSTEM.RETURN.CODE to a positive number?  

Thanks,
-- 
Wendy Smoak
Applications Systems Analyst, Sr.
Arizona State University, PA, IRM 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Custom Functions

2005-06-22 Thread Wendy Smoak
From: Burwell, Edward [EMAIL PROTECTED]

 I use/write functions all the time.  I love 'em.  You can return ANYTHING
 you want from a single digit to an array.  If you have some specific
 questions, ask away.

Can you use them in I-Descriptors?  Doesn't look like it from 'Using
UniData' though I suppose you could write a subroutine that did nothing but
call the function.

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


[U2] Status for READV?

2005-06-21 Thread Wendy Smoak
From the docs, (UniBasic Commands Reference) it doesn't look like READV
sets STATUS() or @SYSTEM.RETURN.CODE.

I have this...
  READV X.DATA FROM F.PERSON, X.NODE.ID, 12 THEN END

I want to say...
  IF X.DATA = '' AND NOT(STATUS()) THEN 
INS X.NODE.ID BEFORE X.LIST1,1
  END

Otherwise I may think that X.DATA is empty, and keep the key I used,
when it really just couldn't be read.  Do I have to use THEN/ELSE and
set a status variable myself?

   READV X.DATA FROM F.PERSON, X.NODE.ID, CORP.PARENT.CORPORATION THEN
 X.STATUS = 0
   END ELSE
 X.STATUS = 1
   END

   IF X.DATA = '' AND NOT(X.STATUS) THEN ... END

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


RE: [U2] When do globally cataloged programs get removed?

2005-06-07 Thread Wendy Smoak
[EMAIL PROTECTED] wrote:
 If you can su to root, you can CATALOG the subroutine with
 the NEWVERSION
 qualifier, or you can use the 'newversion' command, if not,
 then you can use the NEWPCODE ECL command to make your
 current session see the new version, but it won't affect
 other sessions.

We don't have root on this machine... We do have a user with some root
privileges, but apparently not enough to use NEWVERSION.

But that was enough of a hint to make me check who owns what.  I knew
that only the owner of the file (or root) can add a trigger to it, but
apparently it also matters who owns the executable code for the trigger.


I was compiling under my own userid yesterday when the changes were not
taking effect.  I just compiled as the privileged user, and now it's
working.

Thanks!
-- 
Wendy Smoak
Applications Systems Analyst, Sr.
Arizona State University, PA, IRM 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] When do globally cataloged programs get removed?

2005-06-07 Thread Wendy Smoak
I wrote:
 I was compiling under my own userid yesterday when the 
 changes were not taking effect.  I just compiled as the 
 privileged user, and now it's working.

I shouldn't try to figure things out this early in the morning.  It
wasn't file ownership or who compiled the trigger subroutine... it was
the fact that I didn't realize that I needed to re-catalog globally
cataloged programs when they're changed.

At least, that's what makes sense right now... 

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


[U2] When do globally cataloged programs get removed?

2005-06-06 Thread Wendy Smoak
I'm trying to modify a globally cataloged subroutine I'm using as a
trigger, and the changes don't seem to take for a while.

The docs say Periodically, sbcs checks shared memory and removes loaded
programs that are no longer in use.  

How long is periodically?  Likely I wouldn't want to change it as it
would be system-wide, but about how long should I wait before testing a
change?

Can I somehow convince it to reload a particular subroutine [that no one
is currently using]?  

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


RE: [U2] Questions about addRequestParameter

2005-05-17 Thread Wendy Smoak
Bruce Lunt wrote:

 I have been investigating using callhttp to send addresses to 
 the web for 
 address verification and the documentation is leaving me a little 
 unfulfilled.

There are some examples on the Wiki:
http://www.pickwiki.com/cgi-bin/wiki.pl?CallHTTP
  and
http://www.pickwiki.com/cgi-bin/wiki.pl?CallHTTPWithSSL

-- 
Wendy Smoak
Applications Systems Analyst, Sr.
Arizona State University, PA, IRM 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Archives (was RE: [U2] Dymanic vs Dimenssioned)

2005-05-13 Thread Wendy Smoak
Dan Fitzgerald wrote:
 
 Do we have archives somewhere?


If it's fairly recent, (since Jan 2005?) mail-archive.com should have
it:
http://www.mail-archive.com/u2-users%40listserver.u2ug.org/

This one goes back further, but the search doesn't work as well:
http://www.indexinfocus.com/

-- 
Wendy Smoak
Applications Systems Analyst, Sr.
Arizona State University, PA, IRM 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] OpenOffice.org 1.9.100 and UniVerse JDBC

2005-05-11 Thread Wendy Smoak
Ian Stuart wrote:
 
 Compare this to OOo response:  After being elated about the 
 success of the JDBC patch in OOo I found a problem updating tables via

 JDBC, so I posted an issue.  Not 1 hour later I get a meaningful 
 response along these lines:

This isn't anything specific to OpenOffice, it happens daily in dozens
of open source projects.  And it completely spoils you for traditional
software support. ;)

I'm now used to being able to talk to the developers of whatever it is
I'm using, have learned to ask good questions, and I expect to be taken
seriously.  Contrast that with having to fight your way through
first-level phone support in order to get to someone who *might* know
the answer when you have a problem with commercial software.

I haven't used the JDBC driver, but I have had issues with UniObjects
for Java that were only solved by begging for help here on the list, not
through official support channels.

-- 
Wendy Smoak
Applications Systems Analyst, Sr.
Arizona State University, PA, IRM 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] IBM Licensing Requirement

2005-04-18 Thread Wendy Smoak
Tony Gravagno wrote:

 I'd also like to get some real numbers on the table.  Some 
 people say you
 can get 10 users on a single license.  Anyone who has implemented a
 multi-user environment knows this isn't the case because, as 
 stated above,
 the first user will connect and you'll have 9 people waiting in line
 afterward.

With device licensing, you can get ten connections per license.  When
all the connections are coming from one 'factory' that can vary the
device subkey after each ten connections... there you go, potentially
ten different  users on one license.

-- 
Wendy Smoak
Applications Systems Analyst, Sr.
Arizona State University, PA, IRM 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


  1   2   >