Hi
I've always used 'R2'
e.g. ANS = N1 * N2 'R2'
No scaling, just rounding
Regards
John Woollam | Group Function Support 1 (Finance Systems) | Travis
Perkins PLC | 01604 682751
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun
Hi
Never heard of the DROUND() function in Universe.
Anyway, why would I want to use a function syntax when I can do
ANS = N1 * N2 'R2' and it is the answer that gets rounded?
Easy to write.
Easy to read...
John Woollam | Group Function Support 1 (Finance Systems) | Travis
Perkins PLC
We have a large SQL server database behind our Business Objects setup.
We just export tilde-delimited flat files daily and have SQL Server
import them.
Dead easy.
No learning curve really.
No good for your CV, though...
John Woollam | Group Function Support 1 (Finance Systems) | Travis
We have used the SEEK filehandle, 0 2 statement
It is literally an exposure of the C seek statement.
Yes, it works
John Woollam | Group Function Support 1 (Finance Systems) | Travis Perkins
PLC | UK
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users
Nope
We use Universe 10.1 at present in REALITY flavour and a trial program
with your code does not compile.
I recall that you can do
MAT ARRAY1 = MAT ARRAY2
as an assignment,
but to compare the two arrays you would have to MATBUILD both to dynamic
arrays and compare those
John Woollam
If your Unifile is also a SQL Table, and the data you put into 73 is
illegal for that table, it will cause a write failure as the SQL
checking will not allow you to write it.
John Woollam | Group Financial Systems | Travis Perkins PLC |
01604 682751
-Original Message-
From: u2-users
We find that even in a simple, running on Unix, Databasic program, if
you try to write illegal data to a SQL table then you get a WRITE
FAILURE error, so we guess that the SQL integrity checking is working
even on a direct write from any source.
John Woollam | Group Financial Systems | Travis
.
John Woollam | Group Financial Systems | Travis Perkins PLC |
01604 682751
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve
Hinnenkamp
Sent: 20 November 2009 14:23
To: U2 Users
Subject: [U2] UniVerse
unnamed common, and include
one in one subroutine and both in another, you get the common size mismatch
error.
In short, put all your unnamed common in one include only and your problems
will go away
Regards
John Woollam | Group Financial Systems | Travis Perkins PLC | 01604 682751