Anthony
there is a tutorial on using UniObjects with VB Express on the U2UG Knowledge
Base.
Check out : www.mvopen.org/cms and click the Knowledge Base link.
Regards,
Brian
Hi guys,
I am messing with Visual Basic Express edition. I was hoping to use
UniObjects against my Universe Database.
Or just use $OPTIONS EXTRA.DELIM.
This ensures that an empty element is still added with the correct delimiter.
Brian
In message [EMAIL PROTECTED], Allen E.
Elwood [EMAIL PROTECTED] writes
You can always test,
IF TEMP = '' THEN TEMP = NULL
and likewise on the end that processes after the
Hi
I tried UNLOAD.FILE with catalog command to export the database tables. But
it didn't work. I am able to catalog the subroutines in the exiting
account.Please help me in this regard to export the database table.
Thanks,
Sanjeeb
=-=-=
Notice: The information contained in
Hi
I successfully created a table in Universe database (using CREATE TABLE
Table Name.query as in SQL). In ORACLE all these database objects
reside inside a particular schema. So in Universe database where are the
user defined tables stored ? How can I see all the tables that are created
by
Hi Garry,
Aside from JayJay's comments on the release notes, UniVerse 9.6 is not
certified for AIX 5.3 , the first UniVerse release certified for AIX5.3 is
10.1.12, for reference please see the availability matrix at
https://www.ibm.com/software/data/u2/support/u2techconnect/matrix.asp
Hi
What type of report is generated in Universe Basic ?
Can any one tell me how to write a program that will generate a report ?
Please give me some example that will provide me a clear idea regarding
reports generation in Universe Basic.
Sanjeeb
=-=-=
Notice: The information
Hi
What type of report is generated in Universe Basic ?
Can any one tell me how to write a program that will generate a report ?
Please give me some example that will provide me a clear idea regarding
reports generation in Universe Basic.
Sanjeeb
=-=-=
Notice: The information
Hi Garry,
UniVerse 9.6 is not certified for AIX 5.3 , the first UniVerse release
certified for AIX5.3 is 10.1.12, for reference please see the availability
matrix at
https://www.ibm.com/software/data/u2/support/u2techconnect/matrix.asp
Regards,
Jonathan Smith
Advanced Support Engineer
Sanjeeb
The uniVerse environment is subdivided into a number of logical areas called
'Accounts'. In practise an account is a specific O/S directory: any files
created are physically resident in that directory (unless you do special things
to move them).
For example, the UniVerse directory
Sanjeeb,
You can generate reports in many, many different ways. BASIC is
just one set of options. You should first look at the ReTrieve language,
which is a query language, like SQL, but with a much simpler syntax
since the JOINs are built into the schema, not the query.
As to BASIC,
Can't wait for the answers on this one.
My submissions are:
1. External SSELECT then report formatting in Basic.
2. Parameters gathered in BASIC then report formatting in Basic.
3. Parameters gathered in BASIC then create an EXECUTEable TCL statement for
the report.
This thread should get
Has anyone had any problems implementing mvquery security profiles?
I have set up a security profile to allow access to a specified subset
of files, and attached users to that profile, but it seems as if the
only thing it will look at to get the list of files to display is the
MVQUERY_FILES VOC
All,
Please trim excess from your posts when responding. Just leave in
the parts you are responding to, as a courtesy to the others on the list
*especially* the digest readers.
If you read this list through Indexfocus, Nabble, or any other
replicator - and you would like to be able to
UniBasic is the best way, by far.
--Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Charles Barouch
Sent: Monday, March 12, 2007 8:11 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Re:
Sanjeeb,
You can generate reports in many, many different
Here is a simple example.
It uses two files: BOOK_AUTHORS and BOOK_TITLES. The BOOK_AUTHOR has a
multivalued list of IDs for titles by that author. The program prints the
author name followed by the titles in ascending order.
It's an example from a developers course I run.
You can download
I do want to state that being able to watch packets or make modifications to
them would mean that 'someone' would be sitting in a place where they would
see ALL packets whizzing by - like the phone company, or part of the packet
switching network world. And those people could screw with you daily
Dave
The security profiles work fine for me.
What platform are you using? AFAIR there is an issue with UniData on Windows
reporting the group name rather than the user name, which affects the profiles.
Brian
Has anyone had any problems implementing mvquery security profiles?
I have set up a
Dave
we use this all the time its fine
i spect our Brian will have the answer since he wrote it
bob
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Dave Davis
Sent: 12 March 2007 13:02
To: u2-users@listserver.u2ug.org
Subject: [U2] MVQuery Security
Hi
Once you have gotten the hang of the program to print something you will
have more questions but this example will start you off
Louie
--
*-- sample to illustrate how a report will be printed using U-Basic
*-- all bells and whistles to be added as soon as conceptual understanding
All,
I have done some more digging and I'm now stuck at writing about 6k new
records within one transaction. I don't know what I might be missing but
depending on different variations I get a max of 5k or 6k and then a READU
threshold reached error will break the transaction.
Any more insights
It sounds like he does.
It's the Windows servers where this is a problem. Only one of them has
complained about it.
Are the security profiles used on joined files as well? As in, the
file doesn't show up on the main list, but can be accessed if joined to
from an accessible file.
-Original
Dave,
Are the security profiles used on joined files as well? As in, the
file doesn't show up on the main list, but can be accessed if joined to
from an accessible file.
The security is deliberately not enforced directly on joins. This is by design
- the security has two uses: one to secure
I am running a long select via UniQuery and I'm getting a timeout.
Is there a parameter I can change to increase the timeout? This
operation will be done during the server's low utilization period.
I'm using uniobjects for java on a linux (rhel es4.5) server connecting
to unidata on a rs/6000
Does anyone have Unidata BCI up and running on AIX 5.3, and if you do,
what's involved in the original setup? We have a situation where we
want to send some data out to a SQL database from a UniBASIC program
and this seems to be a good way to make it happen.
-Kevin
[EMAIL PROTECTED]
Andre,
I am not quite sure what you are doing a transaction on, but even if
you successfully configured a Universe system to handle transactions
with that many elements simultaneously locked, I would guess that it
is inefficient to grab that many locks at once.
Your transaction is too
How about first some query questions written in basic regarding the options
available, and then followed by an internal building of the headings so left
parts are left justified, center parts are center justified, right parts are
right justified, and then building query statement within the
Hi group.
I'm trying to compare two file pointers to see if they are the same. Like
this example:
../../this.path/that.path/BANANA
And
/u1/ud/this.path/that.path/BANANA
I think what I'd want to do is start by resolving a path that had the
relative path indicators ../ in it.
All,
I need some opinions! I have a client who is willing to spend to put
up a nice sized box, but they only want to spend once. Here's what they
need to do: run a 4 user copy of Universe, holding a Type 30 file with a
mere 200k records. Requests will range from give me one record (average
quote who=Susan Joslyn
Hi group.
I'm trying to compare two file pointers to see if they are the same. Like
this example:
../../this.path/that.path/BANANA
And
/u1/ud/this.path/that.path/BANANA
I think what I'd want to do is start by resolving a path that had the
relative path indicators
Susan
UniVerse thankfully doesn't have the @ variable insertion.
Remember that on Windows, forward and backward slashes can be generally used
indiscrimiately, e.g.
C:\data\myaccount/myfile
Then of course there are symbolic links under UNIX, case insensitivity in
Windows..
Brian
Charles,
We are running an IBM xSeries with dual Xeons 2.5ghz and 5gb memory with
105 users all Universe (Linux) real time system, lots of files(type30),
lots of activity and our response time is exceptional. So, all I can
say is that you probably need less than that. Actually, these days you
Hi Karl,
Thanks! The thing is, I can figure out where I am, but I need to figure
out where two Fpointers are pointing.
Say I have two Fpointers (VOC entries):
001 F
002 ../../this.path/that.path/BANANA
003 ../../this.path/that.path/D_BANANA
And another
001 F
002
Karl,
Thanks again. It is clear -- I think. But unless I'm still
misunderstanding, you are giving me tools that I could use with my fingers
on a keyboard and I'm wanting to build a program smart enough to look at
static file pointers (fpointers) and resolve them to determine if they are
pointing
Try opening the two files, then comparing using FILEINFO(filename,2);
this gives the path to file.
-Original Message-
Thanks again. It is clear -- I think. But unless I'm still
misunderstanding, you are giving me tools that I could use with my
fingers
on a keyboard and I'm wanting to
Chuck:
A) Is this two different databases on one instance, or two separate
instances?
B) Just to clarify, the SQL database instances and the UV database
instance will be on the same box?
C) Which SQL database?
D) What underlying OS?
-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com
**
Susan,
You can execute an ls -i for each path (ls -i ../../blahblah). This returns
the inode for the file. If the inode is the same, the files are the same
(one inode for each file).
Lee H. Burstein
President
Dynamic Systems, Inc.
302-477-0180
Fax: 270-574-0180
www.dynamicsys.com
In UniVerse use the UniBasic STATUS statement and use either the 10th or
20th field.
- Original Message -
From: Susan Joslyn [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org
Sent: Monday, March 12, 2007 2:09 PM
Subject: Spam:RE: [U2] Help with File Pointers
Hi
Either I don't understand the implication or the answer seems way too
easy. Put a medium size box in the mix with Universe on it to keep it
away from the SQL box. Throw as much RAM on the SQL box as the MB will
allow and put a couple super fast network cards between the two servers.
Of course I
I like this answer even better!! I forget about FILEINFO!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Eastwood
Sent: Monday, March 12, 2007 3:31 PM
To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED]
Subject: RE: [U2] Help with File
You might want to take a look at the unirpcservices file on the server.
This is a text file located in the unishared directory. The last entry on
each line is a timeout value in 1/10th seconds.
Brian
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
If you have the current 'path' then .. is always the path before...
So if you are sitting in c:\IBM\ACCOUNTS\TESTIT
And the path in the VOC is to ..\..\bin
You can 'peel back' on each .. to the layer before:
So ..\..\bin would turn
C:\IBM\ACCOUNTS\TESTIT into
C:\IBM\bin
You would count the
Jeff Powell wrote:
I am running a long select via UniQuery and I'm getting a timeout.
Is there a parameter I can change to increase the timeout? This
operation will be done during the server's low utilization period.
I'm using uniobjects for java on a linux (rhel es4.5) server
connecting to
This: ../.. means the directory above the directory above the one I'm in
right now, so by knowing where you are right now (pwd) you can fill in
the complete path.and compare apples to apples
Susan Joslyn wrote:
Hi Karl,
Thanks! The thing is, I can figure out where I am, but I need to figure
Re: Susan,
You can execute an ls -i for each path (ls -i ../../blahblah). This returns
the inode for the file. If the inode is the same, the files are the same
(one inode for each file).
Lee H. Burstein
Lee, this is on face value okay, but technically wrong; there is a chance
that filea in
Just to add one more possible complication to your scenario. Depending on the
software or the UNIX admin people, you may need to worry about symbolic links
at a UNIX level.
For example, lets say you are in Unidata in the directory /usr/ud/ROD. In the
VOC for this directory is a file called
The FILEINFO idea is a good one -- but it will not serve.
[SJ]
Here's one file pointer
PRCPROCESS:
F
PRCPROCESS
D_PRCPROCESS
Here's the other:
DEMO.DOTS:
F
..\PRC\PRCPROCESS
..\PRC\D_PRCPROCESS
They actually do point to the same file. But the output of FILEINFO IS
THIS:
FILE
Kevin,
The SQL is a pair of MSSQL databases, each on their own machines. The
UV machine will have UV, a tiny Delphi program which reads from UV (via
UniObjects), and two tiny Delphi programs which do massive SQL selects
over the slow network and then process the SQL data into UV (via
Chuck,
I'd look building a custom box with a dual-CPU Opteron mainboard, a
64-bit (PCI-X) disk controller doing RAID10, and the quickest 4GB you can
find. You can run a single dual-core Opteron to start with and see how the
load is. Two dual-cores may be a waste to start with. You will have
That's a pain. Have you dont the STATUS test to see if it points out the
correct file path? I will guess it will produce the same results as
FILEINFO, however am curious. We use nothing but Q-pointers for just this
reason.
This, however, brings me to what I think is an undocumented feature of
You're back to this logic then... Count the number of .. and chop that
number of elements off the end.
Then stuff everything AFTER the last ..s onto the end.
There are dozens of ways to do this that would blow up your logic -- I
suspect you'll get to find them one by one. ;-)
David W.
Susan,
I noticed that err..that other software...had problems with relative paths.
With SB Installed (and maybe without) you can get the base path of the ACCOUNT
that the VOC from DMACCOUNTS1. You can then work with what the VOC entry from
the path ACCOUNT in the account.
I think you're
Here we go with the wide variety of 'examples'.
What is the sanity of PRINTER ON, then PRINT then PRINTER OFF?
Should we not be teaching PRINTER ON once and PRINTER OFF at the end?
I've only seen the redundant PRINTER ON, then PRINT then PRINTER OFF when
the programmer didn't know of CRT and
It looks like !VOC.PATHNAME will work to return the fully qualified path
of two VOC F file pointer entries. Here's what I did:
ED BOBW.BP TEST.VOC.PATH
8 lines long.
: P
0001: CALL !VOC.PATHNAME(,TESTFILE,VOC.PATH,STATUS)
0002: IF STATUS = 0 THEN
0003: PRINT TESTFILE PATH=:VOC.PATH
0004:
Bob,
I can't change the SQL boxes or the network. The only place I can
help myself is in the layout for the new box. The new box will have UV,
a tiny Delphi program which reads from UV (via UniObjects), and two tiny
Delphi programs which do massive SQL selects over the slow network.
Hi Everyone.
On help with file pointers thanks to everyone who has pitched in. So far
I'm no joy.
FILEINFO doesn't return just a hard path.
STATUS doesn't seem to return anything.
Ls -I might do the trick on UNIX but I need a Windows solution, too (and
first).
I think I can do the peel
Again, some quicker methods:
1. U50BB is supported on all platforms. Use it for the Port and Account and
possibly the user-id. Put this stuff in an external sub called GET.PORT or
GET.ACCT or GET.USER to not re-invent it every time. Plus, if you straddle
platforms like I do, I can always use CALL
Okay. I see now. The real benefit would be putting more memory on the
SQL boxes. The UV box won't be the bottleneck for your processing
ability. It's going to be the slow network and the speed of the SQL
systems. For UV, you'll probably get just as much out of 2 gigs as you
will 4 gigs, or
Hi Chuck
What version of SQL Server? Also are they running Windows 2003 or Windows
2000. Win2003 can make better use of memory than Win2000.
Regards
David Jordan
Managing Consultant
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit
FILEINFO always returns the correct fully resolved path (without any
double dots) under Universe on Unix. Maybe this problem only affects
Windows.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn
Sent: Tuesday, 13 March 2007 6:40 AM
To:
Chuck,
If the UV box is running XP Pro, 2Gb is your upper RAM limit. The OS
will take 3 Gb on the box but only address the first 2 Gb it finds.
Run a dual core AMD processor with some nice fast SCSI HDD. RAID 10 is
fast but expensive. A pair of large drives mirrored will do the trick if
the DB
Tony,
Great idea. I have the added luxury that the user will not interact with
this program.
My goal is to bounce the line items to a sql table during non-business
hours then after some digestion serve that up to the user through
standard sql queries to the now static data in the tables.
I plan
Thanks Brian.
It's set to six minutes (3600). That's the default. Can you tell me what
the Max value is?
By the way I didn't get this message until after 6 CDT. I think the list
is slow today.
Thanks again.
On Mon, 2007-03-12 at 19:53 +, Brian Leach wrote:
You might want to take a look
Chuck,
You can say 2GB or 3GB, but unless you're using a 64-bit CPU (I
think they all are, now) and a 64-bit O/S (which XP professional is
not), you can't effectively use more than 3GB, even though the box will
probably address 4GB (or even more) happily. A 32-bit O/S like Windows
uses a 4GB
Hi Susan,
When in Universe on windows, you can view the voc entry for UFD.
Attribute three (3) will have the path. Of course you will need to strip
out the DICT filename or extract it via
FIELD(vocRec3,'\',1,COUNT(vocRec3,'\')).
CT VOC UFD
UFD
0001 F
Hello U2 World
Mark
City of Salem
Salem, Va
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
65 matches
Mail list logo