RE: Common Universe/Unidata files

[Stuart Boydell]

> We have separate applications running on Universe and Unidata.
> The apps run on separate
> aix servers.
> We would like to create a common file that can be accessed by
> both applications
> but are not sure of the best approach to take.
> Any suggestions??
>

UniObjects for Java? A UOJ session on the UV box does the reads and writes
to the UD box and/or visa-versa.


--
Stuart








**
This email message and any files transmitted with it are confidential
and intended solely for the use of addressed recipient(s). If you have 
received this email in error please notify the Spotless IS Support Centre (61 3 9269 
7555) immediately who will advise further action.

This footnote also confirms that this email message has been scanned
for the presence of computer viruses.
**

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: File fixing documentation on the Tech Survival CD (was: Damaged files)

[Leroy Dreyfuss]

Dan,

Send me your organization name and address off-line and I will be happy to
have a CD sent to you.

Regards,

LeRoy F. Dreyfuss
Advanced Technical Services - UniVerse
IBM U2 Data Management Solutions
Tel: 303-672-1254  Fax: 303-294-4832
Mobile: 720-341-4317
External email:  [EMAIL PROTECTED]
WWW:  http://www.ibm.com/software/data/u2/support

www.ibm.com/software/data/u2/support - Open, Query, Update, Search -
Online!


   
 Dan Eichholz  
 <[EMAIL PROTECTED] 
 n.com> To 
 Sent by:  U2 Users Discussion List
 u2-users-bounces@ <[EMAIL PROTECTED]>   
 oliver.com cc 
   
   Subject 
 02/25/2004 10:23  File fixing documentation on the
 AMTech Survival CD (was: Damaged  
   files)  
   
 Please respond to 
 U2 Users  
  Discussion List  
   
   





>4. The file fixing documentation on the Tech Survival CD has some good
>advice.
>
>Colin Alfke
>Calgary, Alberta Canada

Where does one get this documentation or, better yet, the Tech Survival CD.

We just had some system downtime due to a faulty processor and are having
to fixfile a lot of tables. We've lost several blocks of data from some
invoice files. Hope it doesn't come back to bite us in the butt.

DanE


--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

File fixing documentation on the Tech Survival CD (was: Damaged files)

[Dan Eichholz]

4. The file fixing documentation on the Tech Survival CD has some good
advice.

Colin Alfke
Calgary, Alberta Canada
Where does one get this documentation or, better yet, the Tech Survival CD. 
We just had some system downtime due to a faulty processor and are having 
to fixfile a lot of tables. We've lost several blocks of data from some 
invoice files. Hope it doesn't come back to bite us in the butt.

DanE 

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Common Universe/Unidata files

[FFT2001]

In a message dated 2/25/2004 2:49:10 PM Eastern Standard Time, [EMAIL PROTECTED] 
writes:

> We have separate applications running on Universe and Unidata. The apps run on 
> separate
> aix servers.
> We would like to create a common file that can be accessed 
> by both applications 
> but are not sure of the best approach to take.
> Any suggestions??
> 
> 
> Randal LeBlanc
> JCL Associates, Inc.

Randal I can think of two ways to do this right off.
1) A file that is defined as a directory to both Universe and Unidata.  Of course one 
or the other server would have to be mounted on the other's filesystem in order to 
"see" this alien directory.  (Please forgive me if my nomenclauture is incorrect).  If 
you are concerned about a single directory having hundreds of thousands of files in 
it, cannot they be defined as dynamic (Unidata) or distributed (Universe) directory 
structures?  I.E. one directory with hundreds of subdirectories (or as many as you 
wish) each of which have hundreds or thousands of files in them.  To Unidata and/or 
Universe, it should see this huge structure as one "file".  Right?
2) Have the file be native to one system and setup a phantom on that system that wakes 
every five seconds, minute, or whatever and looks for something to "do".  The other 
system then, writes out updates to a "waiting" area and trips a flag for the first 
system to "do" something.  When the phantom wakes up, it sees the flag, grabs the 
update and updates the file.

The second method works just fine if the file in question is some sort of log type 
file.  Not as well if its not, but its still possible to fudgilate the systems to work.

I remember setting up a interactive, multi-user, multi-computer type update like this 
years ago to allow an ADDS to update files on an Ulimate using Mentor/Link and set of 
fancy schmancy (technical term) set of routines to co-ordinate the lock tables.  Most 
multi-computer schemes require operating systems from the same vendor, but with six 
months and a lot of free time and code that negotiates the first four or so layers for 
you, you can do it yourself...

Will "My bank account says it's better to over-engineer" Johnson
Fast Forward Technologies

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Common Universe/Unidata files

[Timothy Snyder]

Randal,

With half a million records, I strongly agree that you don't want to put
this in a directory file.

Without knowing more about what you're doing, I'd be inclined to set up a
hashed file stored in either UniVerse or UniData (flip a coin).  Then you
could put together a socket client/server setup to handle updates from the
other side.  That could be set up with the appropriate rules to handle
locking and anything else that may be required to properly negotiate
updates.  You might need to pass around some other information, such the
next key, etc., but it shouldn't be too bad.

Is this something that would need to be accessed from many programs, or
just a few?  How frequently would the file be accessed and updated?


Tim Snyder
IBM Data Management Solutions
Consulting I/T Specialist , U2 Professional Services

Office (717) 545-6403  (rolls to cell phone)
[EMAIL PROTECTED]

Randal LeBlanc wrote on 02/25/2004 02:49:10 PM:

> We have separate applications running on Universe and Unidata. The
> apps run on separate
> aix servers.
> We would like to create a common file that can be accessed by both
> applications
> but are not sure of the best approach to take.
> Any suggestions??--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Common Universe/Unidata files

[Gordon Glorfield]

Unfortunately, there is no hashed file that can be common to both UniVerse
and UniData.  You may want to explore some sort of duplicate file with 2 way
updates.

Gordon J. Glorfield
Sr. Applications Developer
MAMSI (A UnitedHealth Company)
301-360-8839 



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Randal LeBlanc
Sent: Wednesday, February 25, 2004 3:13 PM
To: U2 Users Discussion List
Subject: Re: Common Universe/Unidata files


Rich,
Thanks for the reply.
Yes, that is a possibility. However, the file will be very large (over
500,000 records) and I am concerned about performance with an aix directory
structure.

-Original Message-
From: "Richard A. Wilson" <[EMAIL PROTECTED]>
Sent: Feb 25, 2004 12:08 PM
To: U2 Users Discussion List <[EMAIL PROTECTED]>
Subject: Re: Common Universe/Unidata files

without getting into odbc etc.

is record locking required
control file kind of data
can you set the file up as type 19 under universe and dir under unidata

Rich

Randal LeBlanc wrote:
> We have separate applications running on Universe and Unidata. The 
> apps run on separate aix servers. We would like to create a common 
> file that can be accessed by both applications but are not sure of the 
> best approach to take. Any suggestions??
> 
> 
> Randal LeBlanc
> JCL Associates, Inc.
> [EMAIL PROTECTED]
> www.jclinc.com

-- 
Richard A. Wilson
Lakeside Systems


-- 
u2-users mailing list
[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users


Randal LeBlanc
JCL Associates, Inc.
[EMAIL PROTECTED]
www.jclinc.com
-- 
u2-users mailing list
[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users


Notice of Confidentiality:  The information included and/or attached in this
electronic mail transmission may contain confidential or privileged
information and is intended for the addressee.  Any unauthorized disclosure,
reproduction, distribution or the taking of action in reliance on the
contents of the information is prohibited.  If you believe that you have
received the message in error, please notify the sender by reply
transmission and delete the message without copying or disclosing it. 

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: UniCommand via UniObjects (Java)

[Results]

Donald,
   Shame on you. We're technologists. We don't *read* questions or 
*listen* to questions, we are much to busy *answering* them. After all, 
anyone can read and listen.

   - Charles 'Tongue Firmly in Cheek' Barouch

Donald Kibbey wrote:

Thanks to all who have responded.  I didn't realize that you could/should stick "PA" in front of such a list?!?

The little project I was working on was due yesterday, so I ended up just running the QSELECT and filtering the resulting list within the C# program.  The list consisted of an invoice number tacked onto a client number and the program already had the invoice number as a variable.  The manual actually states only one command at a time, so it's not like this is a bug or anything.  Just that I have grown used to sticking 2-3 commands together with an @FM character and capturing the result.  

And I know for a fact you don't need the PA in front, at least not with Pick flavor UniVerse.

Don Kibbey
Financial Systems Manager
Finnegan, Henderson, Farabow, Garrett & Dunner LLP
(202) 216-5032
 

[EMAIL PROTECTED] 02/25/04 05:41AM >>>
   

I would actually try sending

PA @FM QSELECT @FM SSELECT

Dunno whether it would work, but if sending an @FM-delimited list of
commands screws up by giving all the rest of the string to the first
command, maybe making the first command PA (to invoke the paragraph
processor) would achieve exactly what he wants?
I never realised before I started reading cdp/oliver that you didn't
need PA at the start of an @FM list called by EXECUTE, so that's the way
I've always done things. 

Cheers,
Wol
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
On Behalf Of Phil Walker
Sent: 24 February 2004 21:25
To: U2 Users Discussion List
Subject: RE: UniCommand via UniObjects (Java)

I believe he can just call a paragraph such

PARAGRAPH 12345

Where PARAGRAPH is the following VOC entry

PA
* <>
QSELECT CLIENT.XREF "<>"
SSELECT AR.TR BY MATTER WITH INVOICE = "<>"


Phil Walker
+64 21 336294
[EMAIL PROTECTED] 
infocusp limited
\\ PO Box 77032, Auckland New Zealand

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Behalf Of Dawn M. Wolthuis
Sent: Wednesday, February 25, 2004 10:16 AM
To: 'U2 Users Discussion List'
Subject: RE: UniCommand via UniObjects (Java)

I think you can put the commands in a single paragraph and run that from
UniObjects.  You'll have to pass in the DATA to the paragraph (since I
figure that 12345 is the value of a variable) and I haven't tried that
with
UOJ, but I suspect others have.  Good luck.  --dawn
Dawn M. Wolthuis
Tincat Group, Inc.
www.tincat-group.com 

Take and give some delight today.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
On
Behalf Of Donald Kibbey
Sent: Tuesday, February 24, 2004 1:55 PM
To: [EMAIL PROTECTED] 
Subject: UniCommand via UniObjects (Java)

I'm attempting to send a compound command with the UniCommand object and
have hit what looks like a documented limitation.  Before I go off and
rethink how I'm doing this, I thought I'd ask to make sure this really
won't
work.
What I'm attempting is to run something like this under UniObjects.

QSELECT CLIENT.XREF "12345" :@FM: SSELECT AR.TR BY MATTER WITH INVOICE =
"12345"
On this system, doing this results in a very quick selection of a couple
hundred records out of the AR.TR file.  But, the docs for UniObjects say
only one command at a time.  Does this mean that sticking a couple
commands
together like this is just not possible?  I've tried it and it looks
like
the QSELECT is being attempted with all parts of the command string.
If it won't work, I suppose I'll be reduced to writing up a stub of a
program to do the same thing and just call it from the UniObjects side
of
things.  But, if there's a better way, I'm all ears.
Thanks,

--
u2-users mailing list
[EMAIL PROTECTED] 
http://www.oliver.com/mailman/listinfo/u2-users 

--
u2-users mailing list
[EMAIL PROTECTED] 
http://www.oliver.com/mailman/listinfo/u2-users 

 

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Common Universe/Unidata files

[Randal LeBlanc]

Rich,
Thanks for the reply.
Yes, that is a possibility. However, the file will be very large (over 500,000 
records) and I am concerned about performance with an aix directory structure.

-Original Message-
From: "Richard A. Wilson" <[EMAIL PROTECTED]>
Sent: Feb 25, 2004 12:08 PM
To: U2 Users Discussion List <[EMAIL PROTECTED]>
Subject: Re: Common Universe/Unidata files

without getting into odbc etc.

is record locking required
control file kind of data
can you set the file up as type 19 under universe and dir under unidata

Rich

Randal LeBlanc wrote:
> We have separate applications running on Universe and Unidata. The apps run on 
> separate
> aix servers.
> We would like to create a common file that can be accessed by both applications 
> but are not sure of the best approach to take.
> Any suggestions??
> 
> 
> Randal LeBlanc
> JCL Associates, Inc.
> [EMAIL PROTECTED]
> www.jclinc.com

-- 
Richard A. Wilson
Lakeside Systems


-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Randal LeBlanc
JCL Associates, Inc.
[EMAIL PROTECTED]
www.jclinc.com
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Common Universe/Unidata files

[Richard A. Wilson]

without getting into odbc etc.

is record locking required
control file kind of data
can you set the file up as type 19 under universe and dir under unidata
Rich

Randal LeBlanc wrote:
We have separate applications running on Universe and Unidata. The apps run on separate
aix servers.
We would like to create a common file that can be accessed by both applications 
but are not sure of the best approach to take.
Any suggestions??

Randal LeBlanc
JCL Associates, Inc.
[EMAIL PROTECTED]
www.jclinc.com
--
Richard A. Wilson
Lakeside Systems
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Common Universe/Unidata files

[Randal LeBlanc]

We have separate applications running on Universe and Unidata. The apps run on separate
aix servers.
We would like to create a common file that can be accessed by both applications 
but are not sure of the best approach to take.
Any suggestions??


Randal LeBlanc
JCL Associates, Inc.
[EMAIL PROTECTED]
www.jclinc.com
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

$OPTIONS TIME.MILLISECOND

[Sara Burns]

This may be of use to someone
 
When I converted to UniVerse from ADDS Mentor I needed to change the
behaviour of UniVerse to return SYSTEM(12) as milliseconds not seconds.  In
my conversion program I put the statement $OPTIONS TIME.MILLISECOND at the
top of every program.  
 
Later after conversion I put that statement into a piece of code that was
normally included in most programs - to avoid accidentally missing it out.
A couple of days ago I made a minor change to a program and recompiled.  The
result was that instead of SYSTEM(12) returning milliseconds it returned
seconds, with three decimal places.  This in on NT4.
 
Investigation showed that $OPTIONS TIME.MILLISECOND is a switch and I had
inadvertently switched it off again via my included code.
 
Thinking back I think I have seen this before on AIX but not recognised the
cause.  A while ago I think I recall there was discussion about SYSTEM(12)
returning decimal places on HPUX 11.  Maybe this was a contributory factor.
 
Sara burns
 
Sara Burns (SEB) 
Project Leader (Vantive)
Public Trust 
Phone: +64 (04) 474-3841 (DDI) 

Mobile: 027 457 5974
<  mailto:[EMAIL PROTECTED]>

Information contained in this communication is confidential. If you are not
the intended recipient the information should not be used, disclosed, copied
or commercialised. The information is not necessarily the views nor the
official communication of Public Trust. No guarantee or representation is
made that the communication is free of errors, virus or interference.

 
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Performance Discussion - Unidata

[Piers Angliss]

 If I perform tests via the system using both dd and mkfile, I see
speeds
of around 50MB/s for WRITES, 60MB/s for READS, however if a colleague
loads a 100MB csv file using READSEQ into a Unidata file, not doing
anything fancy, I see massive Average Service Times (asvc_t - using
IOSTAT) and the device is usually always 100% busy, no real CPU overhead
but with 15MB/s tops WRITE. There is only ONE person using this system
(to test throughput). 

I don't claim to be an expert in performance monitoring so I'm probably
setting myself up for a big fall but...

Are you comparing like with like ? dd is simply throwing data out
sequentially, Unidata is hashing the key for each record ( how many in 100
MB ?) and writing it to a possibly/ probably different area of the disk.

What happens if your colleague loads 100MB using READSEQ and throws the same
100MB back out into a different csv file using WRITESEQ ?

What sort of Unidata file is he writing to ? Static or Dynamic ? and what
does it look like at the end ?

Does your colleague's program first read to see whether the record exists ?
is there any correlation between the order of records in the csv file and
the groups they end up in the Unidata file ?

Just a few thoughts

Piers


-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

[AD] Job Opportunity for PRO:MAN Specialist in So. Calif.

[Aspen Technical Services]

Part-time/Full-time opportunity currently available for specialist in PRO:MAN 
manufacturing software in Southern California.

Please submit statement-of-interest, resume, CV.

Thankyou,

Aspen Technical Services
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Performance Discussion - Unidata

[Martin Thorpe]

Hi guys

Hope everybody is ok!

To get straight to the point, system as follows:

SunFire V880
2x1.2GHZ UltaSparc3cu Processors
4GB RAM
6x68GB 10krpm FC-AL disks
96GB backplane
Disks are grouped together to create volumes - as follows:

Disk 1   -   root, var, dev, ud60, xfer -   RAID 1  (Root Volume 
Primary Mirror)
Disk 2   -   root, var, dev, ud60, xfer -   RAID 1  (Root Volume 
Submirror)
Disk 3   -   /u-   RAID 10 
(Unidata Volume Primary Mirror - striped)
Disk 4   -   /u-   RAID 10 
(Unidata Volume Primary Mirror - striped)
Disk 5   -   /u-   RAID 10 
(Unidata Volume Submirror - striped)
Disk 6   -   /u-   RAID 10 
(Unidata Volume Sumkfs -F ufs -o 
nsect=424,ntrack=24,bsize=8192,fragsize=1024,cgsize=10,free=1,rps=167,nbpi=8275,opt=t,apc=0,gap=0,nrpos=8,maxcontig=16 
/dev/md/dsk/d10 286220352
bmirror - striped)

UD60   -   Unidata Binary area
XFER   -   Data output area for Unidata accounts (csv files etc)
/U -   Primary Unidata account/database area.
If I perform tests via the system using both dd and mkfile, I see speeds 
of around 50MB/s for WRITES, 60MB/s for READS, however if a colleague 
loads a 100MB csv file using READSEQ into a Unidata file, not doing 
anything fancy, I see massive Average Service Times (asvc_t - using 
IOSTAT) and the device is usually always 100% busy, no real CPU overhead 
but with 15MB/s tops WRITE. There is only ONE person using this system 
(to test throughput).

This is confusing, drilling down I have set a 16384 block interlace size 
on each stripe and the following info for the mounted volume:

mkfs -F ufs -o 
nsect=424,ntrack=24,bsize=8192,fragsize=1024,cgsize=10,free=1,rps=167,nbpi=8275,opt=t,apc=0,gap=0,nrpos=8,maxcontig=16 
/dev/md/dsk/d10 286220352

in /etc/system I have set the following parameters:

set shmsys:shminfo_shmmni=1024
set shmsys:shminfo_shmmax=8388608
set shmsys:shminfo_shmseg=50
set msgsys:msginfo_msgmni=1615
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=985
set semsys:seminfo_semmnu=1218
set maxpgio=240
set maxphys=8388608
I have yet to change the throughput on the ssd drivers in order to break 
the 1MB barrier, however I still would have expected better performance. 
UDTCONFIG is as yet unchanged from default.

Does anybody have any comments?

Things to try in my opinion:

I think I have the RAID correct, the Unidata TEMP directory I have 
redirected to be on the /U RAID 10 partition rather than the RAID 1 ud60 
area.

1. Blocksizes should match average Unidata file size.

One question I have is does Unidata perform its own file caching? can I 
mount filesystems using FORCEDIRECTIO or does Unidata rely heavily on 
the Solaris based buffers?

Thanks for any information you can provide

--
Martin Thorpe
DATAFORCE GROUP LTD
DDI: 01604 673886
MOBILE: 07740598932
WEB: http://www.dataforce.co.uk
mailto: [EMAIL PROTECTED]
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: [UV] How much do you pay for support each year?

[Eugene Perry]

I have heard that if you leave your original VAR you can only go to IBM.  I
was told that no other VAR can sell you additional seats for U2.  Is this
true?

Eugene
- Original Message -
From: "Dennis Bartlett" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Wednesday, February 25, 2004 4:42 AM
Subject: RE: [UV] How much do you pay for support each year?


> Whoa! Hold on...
>
> The original poster of this thread never questioned the need
> for support
> - he just questioned the need for "east coast" support...
>
> All he was asking is "is there a way to directly approach
> IBM for
> support, and if not, who can he go to as a VAR on the west
> coast... Not
> so difficult, hey?
>
> Perhaps the best response would be testimonials from those
> of you on the
> pacific seaboard about your VARs...
>
> A real no-brainer would be to read the question...
>
> -Original Message-
> From: Ross Ferris
> Sent: 24 February 2004 06:06
> Subject: RE: [UV] How much do you pay for support each year?
> [snip]
>
> As others have responded, UV support is a GOOD idea - and a
> relatively
> cheap "no brainer" option.
>
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
>


-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: UniCommand via UniObjects (Java)

[Brian Leach]

This doesn't seem to work with UniObjects, but is 
something I do all the time from Basic, so just wrote a 
subroutine to accept an @FM delimited list of  commands 
and execute it, and then call that subroutine from 
Objects. 

Brian

On Wed, 25 Feb 2004 10:41:37 -
 "Anthony Youngman" 
<[EMAIL PROTECTED]> wrote:
I would actually try sending

PA @FM QSELECT @FM SSELECT

Dunno whether it would work, but if sending an 
@FM-delimited list of
commands screws up by giving all the rest of the string 
to the first
command, maybe making the first command PA (to invoke the 
paragraph
processor) would achieve exactly what he wants?

I never realised before I started reading cdp/oliver that 
you didn't
need PA at the start of an @FM list called by EXECUTE, so 
that's the way
I've always done things. 

Cheers,
Wol
-Original Message-
From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]
On Behalf Of Phil Walker
Sent: 24 February 2004 21:25
To: U2 Users Discussion List
Subject: RE: UniCommand via UniObjects (Java)

I believe he can just call a paragraph such

PARAGRAPH 12345

Where PARAGRAPH is the following VOC entry

PA
* <>
QSELECT CLIENT.XREF "<>"
SSELECT AR.TR BY MATTER WITH INVOICE = "<>"


Phil Walker
+64 21 336294
[EMAIL PROTECTED]
infocusp limited
\\ PO Box 77032, Auckland New Zealand
-Original Message-
From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]
Behalf Of Dawn M. Wolthuis
Sent: Wednesday, February 25, 2004 10:16 AM
To: 'U2 Users Discussion List'
Subject: RE: UniCommand via UniObjects (Java)

I think you can put the commands in a single paragraph 
and run that from
UniObjects.  You'll have to pass in the DATA to the 
paragraph (since I
figure that 12345 is the value of a variable) and I 
haven't tried that
with
UOJ, but I suspect others have.  Good luck.  --dawn

Dawn M. Wolthuis
Tincat Group, Inc.
www.tincat-group.com
Take and give some delight today.

-Original Message-
From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]
On
Behalf Of Donald Kibbey
Sent: Tuesday, February 24, 2004 1:55 PM
To: [EMAIL PROTECTED]
Subject: UniCommand via UniObjects (Java)

I'm attempting to send a compound command with the 
UniCommand object and
have hit what looks like a documented limitation.  Before 
I go off and
rethink how I'm doing this, I thought I'd ask to make 
sure this really
won't
work.

What I'm attempting is to run something like this under 
UniObjects.

QSELECT CLIENT.XREF "12345" :@FM: SSELECT AR.TR BY MATTER 
WITH INVOICE =
"12345"

On this system, doing this results in a very quick 
selection of a couple
hundred records out of the AR.TR file.  But, the docs for 
UniObjects say
only one command at a time.  Does this mean that sticking 
a couple
commands
together like this is just not possible?  I've tried it 
and it looks
like
the QSELECT is being attempted with all parts of the 
command string.

If it won't work, I suppose I'll be reduced to writing up 
a stub of a
program to do the same thing and just call it from the 
UniObjects side
of
things.  But, if there's a better way, I'm all ears.

Thanks,

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


***

This transmission is intended for the named recipient 
only. It may contain private and confidential 
information. If this has come to you in error you must 
not act on anything disclosed in it, nor must you copy 
it, modify it, disseminate it in any way, or show it to 
anyone. Please e-mail the sender to inform us of the 
transmission error or telephone ECA International 
immediately and delete the e-mail from your information 
system.

Telephone numbers for ECA International offices are: 
Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, 
London +44 (0)20 7351 5000 and New York +1 212 582 2333.

***

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

This email was checked by MessageLabs SkyScan before 
entering Microgen.



This email was checked on leaving Microgen for viruses, similar
malicious code and inappropriate content by MessageLabs SkyScan.
DISCLAIMER

This email and any attachments are confidential and may also be
privileged.
If you are not the named recipient, please notify the sender
immediately and do not disclose the contents to any other
person, use it for any purpose, or store or copy the information.
In the event of any technical difficulty with this email, please
contact the sender or [EMAIL PROTECTED]
Microgen Information Management Solutions
http:

RE: UniCommand via UniObjects (Java)

[Donald Kibbey]

Thanks to all who have responded.  I didn't realize that you could/should stick "PA" 
in front of such a list?!?

The little project I was working on was due yesterday, so I ended up just running the 
QSELECT and filtering the resulting list within the C# program.  The list consisted of 
an invoice number tacked onto a client number and the program already had the invoice 
number as a variable.  The manual actually states only one command at a time, so it's 
not like this is a bug or anything.  Just that I have grown used to sticking 2-3 
commands together with an @FM character and capturing the result.  

And I know for a fact you don't need the PA in front, at least not with Pick flavor 
UniVerse.


Don Kibbey
Financial Systems Manager
Finnegan, Henderson, Farabow, Garrett & Dunner LLP
(202) 216-5032


>>> [EMAIL PROTECTED] 02/25/04 05:41AM >>>
I would actually try sending

PA @FM QSELECT @FM SSELECT

Dunno whether it would work, but if sending an @FM-delimited list of
commands screws up by giving all the rest of the string to the first
command, maybe making the first command PA (to invoke the paragraph
processor) would achieve exactly what he wants?

I never realised before I started reading cdp/oliver that you didn't
need PA at the start of an @FM list called by EXECUTE, so that's the way
I've always done things. 

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
On Behalf Of Phil Walker
Sent: 24 February 2004 21:25
To: U2 Users Discussion List
Subject: RE: UniCommand via UniObjects (Java)

I believe he can just call a paragraph such

PARAGRAPH 12345

Where PARAGRAPH is the following VOC entry

PA
* <>
QSELECT CLIENT.XREF "<>"
SSELECT AR.TR BY MATTER WITH INVOICE = "<>"




Phil Walker
+64 21 336294
[EMAIL PROTECTED] 
infocusp limited
\\ PO Box 77032, Auckland New Zealand

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Behalf Of Dawn M. Wolthuis
Sent: Wednesday, February 25, 2004 10:16 AM
To: 'U2 Users Discussion List'
Subject: RE: UniCommand via UniObjects (Java)

I think you can put the commands in a single paragraph and run that from
UniObjects.  You'll have to pass in the DATA to the paragraph (since I
figure that 12345 is the value of a variable) and I haven't tried that
with
UOJ, but I suspect others have.  Good luck.  --dawn

Dawn M. Wolthuis
Tincat Group, Inc.
www.tincat-group.com 

Take and give some delight today.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
On
Behalf Of Donald Kibbey
Sent: Tuesday, February 24, 2004 1:55 PM
To: [EMAIL PROTECTED] 
Subject: UniCommand via UniObjects (Java)

I'm attempting to send a compound command with the UniCommand object and
have hit what looks like a documented limitation.  Before I go off and
rethink how I'm doing this, I thought I'd ask to make sure this really
won't
work.

What I'm attempting is to run something like this under UniObjects.

QSELECT CLIENT.XREF "12345" :@FM: SSELECT AR.TR BY MATTER WITH INVOICE =
"12345"

On this system, doing this results in a very quick selection of a couple
hundred records out of the AR.TR file.  But, the docs for UniObjects say
only one command at a time.  Does this mean that sticking a couple
commands
together like this is just not possible?  I've tried it and it looks
like
the QSELECT is being attempted with all parts of the command string.

If it won't work, I suppose I'll be reduced to writing up a stub of a
program to do the same thing and just call it from the UniObjects side
of
things.  But, if there's a better way, I'm all ears.

Thanks,


--
u2-users mailing list
[EMAIL PROTECTED] 
http://www.oliver.com/mailman/listinfo/u2-users 

--
u2-users mailing list
[EMAIL PROTECTED] 
http://www.oliver.com/mailman/listinfo/u2-users 


-- 
u2-users mailing list
[EMAIL PROTECTED] 
http://www.oliver.com/mailman/listinfo/u2-users 




***

This transmission is intended for the named recipient only. It may contain private and 
confidential information. If this has come to you in error you must not act on 
anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, 
or show it to anyone. Please e-mail the sender to inform us of the transmission error 
or telephone ECA International immediately and delete the e-mail from your information 
system.

Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong 
Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333.

***

--
u2-users mailing list
[EMAIL PROTECTED] 
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: [UV] How much do you pay for support each year?

[Dennis Bartlett]

Whoa! Hold on...

The original poster of this thread never questioned the need
for support
- he just questioned the need for "east coast" support...

All he was asking is "is there a way to directly approach
IBM for
support, and if not, who can he go to as a VAR on the west
coast... Not
so difficult, hey?

Perhaps the best response would be testimonials from those
of you on the
pacific seaboard about your VARs...

A real no-brainer would be to read the question...

-Original Message-
From: Ross Ferris
Sent: 24 February 2004 06:06
Subject: RE: [UV] How much do you pay for support each year?
[snip]

As others have responded, UV support is a GOOD idea - and a
relatively
cheap "no brainer" option.


-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: UniCommand via UniObjects (Java)

[Anthony Youngman]

I would actually try sending

PA @FM QSELECT @FM SSELECT

Dunno whether it would work, but if sending an @FM-delimited list of
commands screws up by giving all the rest of the string to the first
command, maybe making the first command PA (to invoke the paragraph
processor) would achieve exactly what he wants?

I never realised before I started reading cdp/oliver that you didn't
need PA at the start of an @FM list called by EXECUTE, so that's the way
I've always done things. 

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Phil Walker
Sent: 24 February 2004 21:25
To: U2 Users Discussion List
Subject: RE: UniCommand via UniObjects (Java)

I believe he can just call a paragraph such

PARAGRAPH 12345

Where PARAGRAPH is the following VOC entry

PA
* <>
QSELECT CLIENT.XREF "<>"
SSELECT AR.TR BY MATTER WITH INVOICE = "<>"




Phil Walker
+64 21 336294
[EMAIL PROTECTED]
infocusp limited
\\ PO Box 77032, Auckland New Zealand

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Dawn M. Wolthuis
Sent: Wednesday, February 25, 2004 10:16 AM
To: 'U2 Users Discussion List'
Subject: RE: UniCommand via UniObjects (Java)

I think you can put the commands in a single paragraph and run that from
UniObjects.  You'll have to pass in the DATA to the paragraph (since I
figure that 12345 is the value of a variable) and I haven't tried that
with
UOJ, but I suspect others have.  Good luck.  --dawn

Dawn M. Wolthuis
Tincat Group, Inc.
www.tincat-group.com

Take and give some delight today.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On
Behalf Of Donald Kibbey
Sent: Tuesday, February 24, 2004 1:55 PM
To: [EMAIL PROTECTED]
Subject: UniCommand via UniObjects (Java)

I'm attempting to send a compound command with the UniCommand object and
have hit what looks like a documented limitation.  Before I go off and
rethink how I'm doing this, I thought I'd ask to make sure this really
won't
work.

What I'm attempting is to run something like this under UniObjects.

QSELECT CLIENT.XREF "12345" :@FM: SSELECT AR.TR BY MATTER WITH INVOICE =
"12345"

On this system, doing this results in a very quick selection of a couple
hundred records out of the AR.TR file.  But, the docs for UniObjects say
only one command at a time.  Does this mean that sticking a couple
commands
together like this is just not possible?  I've tried it and it looks
like
the QSELECT is being attempted with all parts of the command string.

If it won't work, I suppose I'll be reduced to writing up a stub of a
program to do the same thing and just call it from the UniObjects side
of
things.  But, if there's a better way, I'm all ears.

Thanks,


--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users




***

This transmission is intended for the named recipient only. It may contain private and 
confidential information. If this has come to you in error you must not act on 
anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, 
or show it to anyone. Please e-mail the sender to inform us of the transmission error 
or telephone ECA International immediately and delete the e-mail from your information 
system.

Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong 
Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333.

***

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Help required on SEARCH

[Ken Wallis]

>Richard Sammartino wrote:

>This could be happening because a record that esearch is
>reading exceeds
>the maximum record size that can be read in unidata.  I get a similiar
>error when AE tries to edit a record that exceeds it allocated
>size.  This parameter can be increased if needed.

Yes, but you don't want to for this issue.  Because the ESEARCH is being run
against MFD and MFD is old Prime terminology for 'Master File Directory' -
usually the top level account directory - this ESEARCH is going to try and
pick up everything it finds in the directory and read it as a single record.
It looks like there is a 76MB file in the directory and that is too big for
UniData's current configuration to read as a single record.

Use "grep" and possible "strings" to search for things at the OS level, not
ESEARCH.

>
>>:ESEARCH
>>MFD
>> STRING :
>> 94067-004
>> STRING
>> :
>>Error when creating a shared memory segment (size=76288000),
>>errno=22 U_shmalloc() failed

Cheers,

Ken


-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: [OT] Making Linux bootable CD

[Anthony Youngman]

Actually, iirc, it's even easier than that. Roxio takes over the .iso
extension so double-click the iso, and up will fire Roxio all ready to
burn ... :-)

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Logan, David (SST - Adelaide)
Sent: 24 February 2004 20:27
To: U2 Users Discussion List
Subject: RE: [OT] Making Linux bootable CD

Hi Martin,

Having finished this exact task less than 24hrs ago 8-0 go into Roxio
CD, Create a Data CD and then goto File menu, Create a CD from an image,
browse to the directory where your iso files are (don't forget to change
the file mask in the drop down box from cif to iso) and click on the
file you wish to create.

I've just done slackware, suse and redhat so I am fairly sure it will
work 8-) I'm trying to get another database running that doesn't like
something Red Hat has done. Contact me offline if you have any more
problems.

HTH

Regards

David Logan
Database Administrator
HP Managed Services
139 Frome Street,
Adelaide 5000
Australia

+61 8 8408 4273
+61 417 268 665



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Martin Phillips
Sent: Wednesday, 25 February 2004 3:42 AM
To: [EMAIL PROTECTED]
Subject: [OT] Making Linux bootable CD


OK, I give up.  Someone out there must have done this and have the
answer

I need to set up a new Linux system.  I have downloaded the five RedHat
8.0
.iso CD image files.  I now need to make a set of bootable CDs.
Everything
on the RedHat web site starts from the assumption that your CD writer is
on
a running Linux system.  Mine isn't.  It's on a Windows 2000 system.  I
have
Roxio Easy CD Creator 5 which has an option to write bootable CDs.

RedHat suggest using cdrecord.  This in turn requires CygWin.  I
downloaded
this but the instructions don't work because the commands they use
aren't
there.  I want to do the job with my existing Easy CD software.

I have spent the entire day trying to do this.  I will be forever
grateful
to anyone who can email me the steps to make these CDs.  Unless you
think it
is worth publishing to the whole group, please email it to
[EMAIL PROTECTED] to reduce off topic mailings.

Martin Phillips
Ladybridge Systems
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
+44-(0)1604-709200

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users




***

This transmission is intended for the named recipient only. It may contain private and 
confidential information. If this has come to you in error you must not act on 
anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, 
or show it to anyone. Please e-mail the sender to inform us of the transmission error 
or telephone ECA International immediately and delete the e-mail from your information 
system.

Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong 
Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333.

***

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users