Kevin,
It sounds as though the server is seeing the disconnects, but the client is
not getting the response back to recognize that it is truly disconnected.
Therefore the object is waiting on a response. I am not sure if the
driver is thread safe, but I would not count on it.
I might suggest
I assume that the SUB.LOCKED.SOH.RO is called to do the lock and then
returns.
The problem is that you open the file in this routine to do the locking
against. Once this subroutine ends that file handle will go out of scope
(it was defined local to this subroutine) and the file is closed. That
I will be out of the office starting 03/18/2008 and will not return until
03/27/2008.
I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
I will be out of the office starting Tue 07/17/2007 and will not return
until Mon 11/26/2007.
I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Jim,
You have two choices:
First you can pass in @RECORDxx where xx is the attribute number you want
to work on.
The other way is to not pass anything at all. The Global UV variables
@RECORD and @MV are available in your program too. You could reference
them directly. Of course this would
We have a number of ODBC schemas setup in Unidata. Some have been around
for quite awhile and the person who created them is no longer around. What
is the methodology to change the documented ownership of these schemas?
Rich Taylor | Senior Programmer/Analyst| VERTIS
250 W. Pratt Street |
You don't indicate whether this is Unidata or Universe or the flavor
you are running in.
However one suggestion I can make is to enclose your calculations in
parenthesis to insure that operator precedence is not your problem.
IF (INTREC+PRNREC) # (INTPAY+PRNPAY) THEN
Rich
Try doing the ODBC Query, but tell Excel to generate an OLAP cube file
instead of returning the results of to excel directly. This is an
option off the last page of the query wizard. You can then run pivot
tables off the cube file (a .cub file). You can also save the
__
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Richard
Taylor
Sent: Monday, July 31, 2006 3:19 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Unidata/Oracle connection problem
I am attempting to setup a data
__
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Richard
Taylor [EMAIL PROTECTED]
Sent: Monday, July 31, 2006 3:19 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Unidata/Oracle connection problem
I am
I am attempting to setup a data source under Unix to allow access to
an Oracle database. I am having a lot of trouble getting this to
work.
I have:
7Installed the oracle client
7Setup a place to hold the driving library
7 Setup a folder
I will be out of the office starting 06/07/2006 and will not return until
06/14/2006.
I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
I wrote an application that used uniobjects with a Universe backend.
Here are some code fragments. You read a file using a UniFile object as
follows. If the Record member is NOTHING then the record was not found
Private rsFile As UniFile ' file handle to open file
Does anyone out there have any information regarding U2 training
availability in India? In particular the Kolkata area of India.
Rich Taylor | Senior Programmer/Analyst
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Well, I did some checking. Yes the Pixius website is still up, but you
can not find any mention of MVInternet from the main page. You can find
information if you do a search. I placed a call to the main number and
asked for information on MVI, but the person did not know what I was
talking
I am going to risk the abuse and repeat a question from the past. Does
anyone know where I can find a decompiler for UniData.
Before I we start with the copyright discussion. This is homegrown, legacy
code. We need to recover some of the source. So far the only resource I
have found for
Karl,
Thanks for the laugh of the day :)
Rich Taylor | Senior Programmer/Analyst| VERTIS
250 W. Pratt Street | Baltimore, MD 21201
P 410.361.8688 | F 410.528.0319
[EMAIL PROTECTED] | http://www.vertisinc.com
Vertis is the premier provider of targeted advertising, media, and
marketing
Rich Taylor is back in the office.
For all my fans that breathlessly awaited the next automatic
response...Sorry folks, forgot to set the exceptions list
Rich Taylor | Senior Programmer/Analyst| VERTIS
250 W. Pratt Street | Baltimore, MD 21201
P 410.361.8688 | F 410.528.0319
[EMAIL
I will be out of the office starting 10/14/2005 and will not return until
10/24/2005.
I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
I will be out of the office starting 10/14/2005 and will not return until
10/24/2005.
I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
I will be out of the office starting 10/14/2005 and will not return until
10/24/2005.
I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
I will be out of the office starting 10/14/2005 and will not return until
10/24/2005.
I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
I will be out of the office starting 10/14/2005 and will not return until
10/24/2005.
I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
I will be out of the office starting 10/14/2005 and will not return until
10/24/2005.
I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
I will be out of the office starting 10/14/2005 and will not return until
10/24/2005.
I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
I will be out of the office starting 10/14/2005 and will not return until
10/24/2005.
I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
I will be out of the office starting 10/14/2005 and will not return until
10/24/2005.
I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
I would point out that this is only a deadlock if you make the further
error of not doing proper error trapping. You can avoid the deadlock by
adding the ON LOCKED clause to your read. If this condition happens you
post/display the error, roll back the transaction and either abort or skip
to the
It looks like date and part are multi-valued. You can create a dictionary
that takes the MAX on the date field. Sort my descending and use SAMPLE 1
as others have indicated. This should give you just the ID of 1249.
You can also defined this new data reference on-the-fly in the retrieve
I agree. Subroutines should be of a reasonable size for the task to be
performed, but to limit by lines is really unnecessary. In fact it can
lead to a over-use of subroutines (yes there is such a thing) that creates
very fragmented code. I was guilty of this in a sizable utility and it
became
Named common can be a very powerful tool and where needed is often the
best, if not only, way to create a solution that works for the user. Like
any other tool it has its good and bad points.
First and foremost is selecting a name that is as unique to the process
(not filename) as possible.
Bill (and Will),
As I stated I have done the directory copy many times with great success.
It is not that difficult, but you have to be CAREFUL. See my earlier
posts for some caveats to the process. As to the size of the files, Will
has a point, but disk space is cheap. Also, if you are
As a general statement, want you are doing is not something you want to
experiment with unless you have a completely separate development machine
to work with that you can refresh if you mess it up. You need to have a
much better understanding of the file structure used by your application
before
Bill,
I see you have received many responses some of which give some hints as to
finding your missing verb so I will respond in general. I often copied
accounts to new directories and had little trouble as long as you know
what you are working with.
Remember that in UV the voc holds pointers
Well, I will admit that I have rarely used the SELECT filevar TO LIST
syntax so I can not pull out a specific example.
However, I have seen several occurrences where SELECT filevar missed
records and when the syntax was changed to EXECUTE SELECT filename it
worked perfectly. This has occurred
I have found that a general date conversion is pretty flexible in UV (not
sure about Unidata yet)
Try:
I.DATE = ICONV(EXTERN.DATE,D)
Rich Taylor | Senior Programmer/Analyst| VERTIS
250 W. Pratt Street | Baltimore, MD 21201
P 410.361.8688 | F 410.528.0319
[EMAIL PROTECTED] |
There can be a major problem with the second syntax depending on what you
are doing to the file. The SELECT filevar syntax does not create a select
list even in memory. It traverses each group in order as you perform the
readnext command keeping a pointer to where it left off. This is why is
Well, you raise a point, but not the one I think you intend. Transactions
should be designed to be active for the minimum span of time to avoid the
bottleneck mentioned. I would think very carefully about any transaction
the cached a large group of updates for a long period of time, say all
Not if you are using stored procedures (U2 basic subroutines) to do the
file manipulation. Passing the record to the subroutine provides one
layer of removal from the client program.
Rich Taylor | Senior Programmer/Analyst| VERTIS
250 W. Pratt Street | Baltimore, MD 21201
P 410.361.8688 | F
:[EMAIL PROTECTED] On Behalf Of Richard Taylor
Sent: Friday, May 27, 2005 8:09 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Uniobjects hack
[snipped]
2) Convert the account to an SQL schema. You can then attach file level
security via the SQL user. Just remember to create a security
I am hoping that someone out there has some knowledge of SB control
attributes. Specifically I am using GETATTR to examine all the attributes
of a textclass control. I am interested in the Callbacks and Events
attributes. My guess is that events tells you all the events defined for
the control
Dimensioned vs Dynamic--brain damaged code is still brain damaged code.
I could not agree more!
the music majors passing themselves off as Pick programmers
For the record I almost failed music history :)
For those keeping track of suggestions for IBM here is one that would help
bridge this
Rich Taylor | Senior Programmer/Analyst| VERTIS
250 W. Pratt Street | Baltimore, MD 21201
P 410.361.8688 | F 410.528.0319
[EMAIL PROTECTED] | http://www.vertisinc.com
Vertis is the premier provider of targeted advertising, media, and
marketing services that drive consumers to marketers more
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Larry Hiscock
Sent: Friday, May 13, 2005 5:57 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] I'm in an Array quandry, any suggestions...
Richard Taylor wrote:
Certainly not enough to justify throwing away one of the
best features
Ken,
Thanks for the suggestion, but that would require changing programs that
we had no intention of changing. Further making such changes is much
larger than can fit within the scope of the current enhancement project. A
global system switch that effected just this one behavior would have been
Don't confuse Dimensioned (fixed) arrays with dynamic arrays.
REC0 is a dynamic array reference and would always return the entire
record.
REC(0) references a dimensioned array and, apparently, in UV holds all
fields that could not fit into the dimension of the array. UniData does
not work this
We are faced with this same situation and the thought behind this truly
baffles me. Why take a flexible, dynamic database system and force it to
be fixed length. This is what you are doing using dimensioned arrays and
MATREADs. The most common justification I have heard is performance and
this
up the drain
- Montgomery Scott NCC-1701
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Friday, May 13, 2005 2:54 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] I'm in an Array quandry, any suggestions...
Richard Taylor
LeRoy,
Perhaps I don't fully understand your example, but I don't see the
distinction here. If I have a webpage that sends a request to the U2
database (via any method mentioned in this thread) and waits for it's
response then goes on with it's own life each web site vistor would only
be using
Just to clarify this discussion, you only get this if you purchase device
licensing. The last time I had the need to look into this you could still
purchase U2 via a concurrent user license model. This did not care about
IP addresses for license verification. If you opened up two sessions on
I believe that you are incorrect on this. My company recently purchased
this product and the company's website seems to still be active. I am
sending the link below
http://www.pixiussoftware.com/mvinternet.php
Rich Taylor | Senior Programmer/Analyst| VERTIS
250 W. Pratt Street | Baltimore, MD
Well, as I tell people about an IT career today
The great thing about my job is I can do it anywhere,
the bad thing about my job is I can do it anywhere
Rich Taylor | Senior Programmer/Analyst| VERTIS
250 W. Pratt Street | Baltimore, MD 21201
P 410.361.8688 | F 410.528.0319
[EMAIL PROTECTED] |
Actually, that looks like an attempt to adapt an SQL syntax. That type of
logic is common in SQL statements
Rich Taylor | Senior Programmer/Analyst| VERTIS
250 W. Pratt Street | Baltimore, MD 21201
P 410.361.8688 | F 410.528.0319
[EMAIL PROTECTED] | http://www.vertisinc.com
Vertis is the
From what I know (other replies indicate that newer version may have a
higher limit) the limit on a single part, hashed file is 2gb. You can
exceed this by making the file a multi-part file where the physical files
at the OS level are split, but you still reference a single file name in
UV. You
Not FoxPro, but I have done things with Access. I used basic ODBC
connections to UV to create GUI, client-based front-ends in Access. It
was mostly an experiment, but it worked fairly well.
If FoxPro supports DB connections via ODBC (as it should) then you would
need to install the U2 ODBC
If no catalog exists for a called subroutine UV looks in the same program
library as the calling program.
Rich Taylor | Senior Programmer/Analyst| VERTIS
250 W. Pratt Street | Baltimore, MD 21201
P 410.361.8688 | F 410.528.0319
[EMAIL PROTECTED] | http://www.vertisinc.com
Vertis is the premier
Which is exactly why it is a BAD IDEA to allow multiple programs to exist
in different code files with the same name, especially in the same
account.
There would be no way to properly catalog those programs meaning you need
to use the RUN command to execute them all the time.
The ability is to
John,
Basically, it comes down to a cultural (as in PICK community preference).
The logic is that dictionaries are cheap, easy, and reusable, so why not
create a virtual field. Back in the bad old days database structures were
fairly rigid constructs. PICK was one of the only models that
Leroy,
I am sorry, but that argument doe not hold water. The client has
purchased, whether directly or indirectly, a U2 database product. They
have full access to the system to do their own development if they desire.
They should be able to review any available knowledge-base. I can not
think
What an absolutely wonderful idea! Glad I thought of it ;)
Rich Taylor | Senior Programmer/Analyst| VERTIS
250 W. Pratt Street | Baltimore, MD 21201
P 410.361.8688 | F 410.528.0319
[EMAIL PROTECTED] | http://www.vertisinc.com
Vertis is the premier provider of targeted advertising, media, and
I would add my vote for UltraEdit. As has been mentioned you can do
syntax highlighting, but more important for me is the project organization
tools. You can very effectively organize files you are working on into
projects for easy retrieval. This works with files opened via FTP too.
The only
Sounds like you want to look into a product called MVInternet. We are
just starting to use this here, but from what I have seen it is easy to
use.
Here is a link: http://www.pixiussoftware.com/mvinternet.php
Rich Taylor | Senior Programmer/Analyst| VERTIS
250 W. Pratt Street | Baltimore, MD
One other thing to watch out for is when you make an account into a Schema
normal, non-sql users, will not have access to the files anymore. If you
want to use the account as a Schema and as a regular UV account you can do
so but you will need to grant permissions to the non-sql defined users.
, February 04, 2005 11:02 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Universe CREATE SCHEMA
Richard Taylor wrote:
One other thing to watch out for is when you make an account into a
Schema
normal, non-sql users, will not have access to the files anymore. If you
want to use the account
I have a co-worker that is trying to get a stored procedure to run from
Excel via an ODBC connection. What he is trying to do is have a routine
that will regenerate some data whenever this query is run or the refresh
button is clicked. This is a straight ODBC connection run against UniData
create VOC entries that point to the
same DATA files but have different DICT's? Is that enough?
-Original Message-
From: [EMAIL PROTECTED] [mailto:owner-u2-
[EMAIL PROTECTED] On Behalf Of Richard Taylor
Sent: Friday, February 04, 2005 10:22 AM
To: u2-users@listserver.u2ug.org
Subject
A transaction may only have a single BEGIN and END statement. You are
basically creating a logic block that contains the code that makes up the
'transaction'. In your case you have two choices
First, you could move the begin transaction above the LOOP and the End
transaction after the REPEAT.
Wow, I have not heard that name in a while.
I had to convert a client off ThoroughBred to a Universe base ERP system
many years ago. We never did find a good, direct export function.
Instead we printed reports to text files then used a product called
Monarch to map these files and covert the
I will be out of the office starting 01/27/2005 and will not return until
01/31/2005.
I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
SSELECT the file
SAVE-LIST MYLIST
EDIT-LIST MYLIST
You will probably see the offending item at the top or bottom of the list.
To see what is actually in the key try using 'up-arrow' mode in the line
editor; Type '^' an redisplay the record.
To remove delete from the list all the records you
I don't know of any configuration setting for this. This is actually a
'feature' of the TRANS function in UV. You could pass in a multi-valued
list of keys to translate and get a multi-value list of the entire record
back, hence the need to lower the record.
Rich Taylor | Senior
I remember having similar problems and the issue came down to how I
referenced the library. Are you doing a 'Reference' or a createobject?
I think the solution for me was to do a createobject, but it has been
awhile.
Another thing to keep in mind is that when you work in the IDE sometimes
I used UV subroutines extensively from VB6 and never had any problems. I
am not sure at this point how named common was used in that area.
I can tell you that my previous company tried to use named common in a
manner similar to what you are trying, but this was in straight UV
programming. We
I have to weigh in on this a bit. The issue with GOTOs is not one of
performance (as someone else pointed out a loop compiles down to GOTOs at
a low level) nor is it an instant sign of sloppy code. The problem is
that it is far easier to degrade into sloppy code. In a complex program it
can make
My $0.02
I strongly disagree with this approach.
1) I think you would lose some valuable and useful responses as not all
summaries will be posted
2) I like to see the alternative approaches as my particular problem may
not be exactly like the one posted, but one of the solutions might well
SQL statements are limited by the SQL definitions held at the end of the
dictionary item. These fields contain both a type and a length. SQL
standard requires that these be strongly applied so data that is
acceptable to U2 will give a data type error if the wrong SQL type is used
and the field
I think the basic concept here has very little to do with any kind of
low-level tweaking or variations on versions. Let me explain by example:
Software I used to work in had a financial ledger for material
transactions that could get to be VERY large. If I wanted to run a
Account analysis for a
-Original Message-
snip
I can't imagine anyone on this forum having to break up this sentence
likewise on the current platforms. On this client's older MCD, it truly
makes a difference.
/snip
-
Ah, Mark..I do this all the time for the performance reasons
Our company does some work with U2 interfaced to a website and we are
looking at doing more. You might want to check-out the MV/Internet
product. This basically allows you to have a website that can talk
directly to a Universe database. You write your site scripts in UniBasic
and do cgi calls
I certainly don't want this to become a compiler war, but for the sake of
a alternate opinion. I would agree with another post in that you can code
efficient code in .net. You DO need to override some of the defaults
assumed by the ide when you create project though. It seems like MS wants
to
IBM mainframe assembler difficult??? Not really, compared to
microprocessor assembly it was almost a high-level language. I had a lot
of fun with it way back when. Never used it in 'real' life, but it was
fun.
Ok, so I'm a geek. What can I say? :)
Rich Taylor | Senior Programmer/Analyst|
Well, one thing I can see and that is the 192 address is internal only.
The actual STATIC IP of your connection is the only thing the outside
world sees. You will either need to setup the router to forward that port
to the internal address you mentioned or enable VPN tunneling. I have a
similar
Many people have emailed to ask for the attachment since it got filtered.
I am inserting it as text below my signature.
Rich Taylor | Senior Programmer/Analyst| VERTIS
250 W. Pratt Street | Baltimore, MD 21201
P 410.361.8688 | F 410.528.0319
[EMAIL PROTECTED] | http://www.vertisinc.com
Vertis
83 matches
Mail list logo