Re: Data typing in MV Basic

[Jim Garratt]

Would this not be set by your initialisation of the variable A.

eg A = '';*Alpha/Numeric or  String
 A = 0   ; Numeric


- Original Message -
From: "Trevor Ockenden" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Wednesday, March 31, 2004 2:25 PM
Subject: Re: Data typing in MV Basic


> Will, I stand corrected on that one. So far in 20 odd years of programming
> in MV I haven't needed to worry about it.
>
> Now Will raises a terrific question. If A = "1" assigns 1 as numeric. How
> would you determine if A contained a numeric or a string in this case?
>
> My short answer is - why would I need to know? BUT I'm sure somebody has a
> good answer to that one.
>
> Cheers
>
> Trevor Ockenden
> Open Systems Professionals
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, March 31, 2004 4:10 PM
> Subject: Re: Data typing in MV Basic
>
>
> > In a message dated 3/30/2004 8:19:18 PM Pacific Standard Time,
> > [EMAIL PROTECTED] writes:
> >
> >
> > > A = 1 assigns a numeric integer. The expression need not contain
> operators
> > > (+,-,etc) to be numeric.
> > > A = "1" assigns a string however, as you have explicitly declared it
to
> be
> > > string.
> > > A = "1" + 2 assigns a numeric integer value (3) as the result is
> numeric.
> > > A = "one" + 2 assigns a zero - according to the error message.
> >
> > yes
> > no
> > yes
> > yes
> >
> > they all assign numerics imho
> > "1" is cast as a numeric because the system is smart enough to realize
its
> a
> > numeric string and has no purpose casting it as a string
> >Any idea how to test which it is?
> > Will
> > --
> > u2-users mailing list
> > [EMAIL PROTECTED]
> > http://www.oliver.com/mailman/listinfo/u2-users
> >
>
>
> ---
> Outgoing mail is certified Virus Free by AVG 6.0.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.642 / Virus Database: 410 - Release Date: 25/03/2004
>
> --
> 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: Modern Universe (TESTING)

[Jim Garratt]

Well Said Sara.


- Original Message -
From: "Sara Burns" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 31, 2004 1:57 PM
Subject: RE: Modern Universe (TESTING)


> As requested
>
> My queries were done on our machine reasonably early in the morning before
> there were a lot of users.  I repeated them to ensure that data was in
> cache.
> Both had the same format
> SELECT CustomerNo
>   FROM CustomerFile
>   WHERE PostalAddLine1 like '%EXPLORATION%'
>   ORDER BY CustomerName
>
> I will admit that I was surprised at the performance when we set up the
> index in UniVerse on that field.  It showed me the value of using indexes.
> Before indexes were available in UniVerse this was done by different
means.
> This type of select would not have been considered.  I think this is a big
> difference between Oracle and UniVerse.  As these features have become
> available in UniVerse etc some leap at the chance to use them and others
> keep doing things the old way.  Sometimes they may have been bitten by odd
> bugs in the past.  UniVerse has most of the latest features if we choose
to
> use them.  This CustomerFile has 14 indexes.
>
> I cannot repeat the tests now as the machine is heavily loaded and will be
> until late this evening.  However I did try again just to convince myself
> and got the same relativity.  Maybe we need to tune Oracle better for this
> query
>
> One possible difference is that this query is directly to the database
from
> our UniVerse application, not via an intermediate layer.
>
> AIX 5.2, UniVerse 10.0.11, Oracle 9.0.2
>
> I think we should leave this discussion now.  Maybe it is time for
> experimentation - I have found you can get great improvements with the
right
> approach.
>
> Sara Burns (SEB)
> Development Team Leader
>
> 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

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

Re: SB+ Information

[Jim Garratt]

Look at Google Groups
One specifically for SB +
Regards,

Jim Garratt

- Original Message -
From: "Jan Shaw and Keith Johnson" <[EMAIL PROTECTED]>
To: "u2-users" <[EMAIL PROTECTED]>
Sent: Friday, March 26, 2004 8:38 AM
Subject: RE: SB+ Information


> Hi,
>
> I've just started some consulting work at a site that has partly moved to
> SB+.  I worked with System Builder some years ago and I was looking for
> information about SB+.  I've got the documentation and Kevin King's book,
> and I've had a look at Malcolm Bull's site, but the on-line group
> (ISBUG.net) seems to be defunct.  Is there a user group still active
on-line
> or any other information?  I'm looking for the sort of information that
> gives pointers and background, rather than straight documentation.
>
> For example, how does one stick a bunch of changes together and then
migrate
> them from a test environment to a live one?  It's a small site, so they
> can't afford a full-scale package like Susan's.  I would like to set
> something up for them.
>
>
> Thanks,  Keith Johnson "'tm'ing the post name space"
>
> --
> 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