RE: (no subject)

[Ken Wallis]

Steve Mayo wrote:


> I am trying to put together a demo application using
> UniObject for Java. I
> would like to be able to create a statement that selects
> names that start
> with "SMI". In Unibasic I would use the following statement:
>
> SELECT UBFMSTR WITH LAST.NAME = "SMI]"
>
> The Java statement I used is:
>
> uCommand.setCommand ("SELECT UBFMSTR WITH LAST.NAME = 'SMI]'")

If this is running against UniData then I suspect your problem is that
UniObjects is set up to run UniQuery commands in ECLTYPE 'u' and the "=
'SMI]'" wildcard matching syntax is a PICKism that only works in ECLTYPE
'p'.  Instead you should try using:

uCommand.setCommand ("SELECT UBFMSTR WITH LAST.NAME LIKE 'SMI...'")

HTH,

Ken


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

Unclassified RE: (no subject)

[HENDERSON MICHAEL MR]

Steve,

Is the U2 database UD or UV?

This might be a 'flavour' issue, 
if it's UD try substituting "sELECT" for "SELECT".
if it's UV try "  WITH LAST NAME LIKE SMI... "
   or"  WITH LAST NAME LIKE \"SMI...\" "


HTH

Mike

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Steve Mayo
Sent: Friday, 2 April 2004 05:52
To: [EMAIL PROTECTED]
Subject: (no subject)

Greetings one and all,

I am trying to put together a demo application using UniObject for Java. I
would like to be able to create a statement that selects names that start
with "SMI". In Unibasic I would use the following statement:

SELECT UBFMSTR WITH LAST.NAME = "SMI]" 

The Java statement I used is:

uCommand.setCommand ("SELECT UBFMSTR WITH LAST.NAME = ""SMI]""")

and 

uCommand.setCommand ("SELECT UBFMSTR WITH LAST.NAME = 'SMI]'")

and

uCommand.setCommand ("SELECT UBFMSTR WITH LAST.NAME = \"SMI]\"")

all to no avail. The first two get syntax errors and the last one seems to
run be it returns nothing. There are over 300 records that start with SMI.

Any help would be sincerely appreciated.


TIA,

Steve Mayo
Software Engineer


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

The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

(no subject)

[Steve Mayo]

Greetings one and all,

I am trying to put together a demo application using UniObject for Java. I
would like to be able to create a statement that selects names that start
with "SMI". In Unibasic I would use the following statement:

SELECT UBFMSTR WITH LAST.NAME = "SMI]" 

The Java statement I used is:

uCommand.setCommand ("SELECT UBFMSTR WITH LAST.NAME = ""SMI]""")

and 

uCommand.setCommand ("SELECT UBFMSTR WITH LAST.NAME = 'SMI]'")

and

uCommand.setCommand ("SELECT UBFMSTR WITH LAST.NAME = \"SMI]\"")

all to no avail. The first two get syntax errors and the last one seems to
run be it returns nothing. There are over 300 records that start with SMI.

Any help would be sincerely appreciated.


TIA,

Steve Mayo
Software Engineer


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

(no subject)

[rainer]

Well, not quite, this will be 6 char long when positive and 7 char long when 
negative and the question was for a format which stays the same length. 
Unfortunately some data transfers still use fixed length fields (I've seen some 
with one space as a delimiter) and then this won't work.

Rainer

Phil:

In BASIC:

  OCONV((wkVal < 0), 'S;"-";""') : ABS(wkVal) "R(%6)"

In AQL (assuming value is in attribute/field 001):

DICT FILENAME  'TEST' size = 76
01 S
02 1
03 Value
04
05
06
07
08 AIF 1 < '0' THEN 1(S;'-';''):1(MCN)(MR%6) ELSE 1(MR%6)
09 R
10 7

Hope this helps.

Bill

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Behalf Of Phil Walker
> Sent: Wednesday, March 10, 2004 8:53 PM
> To: U2 Users Discussion List
> Subject: Formating Negative Numbers
>
>
> Does anyone have a quick way to format a negative number in a field filled
> with zeros such that the '-' sign appears at the front replacing the 1st
> zero.
>
> For example
>
> -2using 'R%6' becomes -2
> 2using 'R%6' becomes 02
>
> But I would like -2 to become -2 and 2 to remain 02.

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

(no subject)

[Craig Peterson]

We are currently running Unidata 6.0. I am creating some
XML extracts for input to an ETL process. Does anyone know
if Unidata creates the DTD file on the fly or do I have to create
it manually?
 
Thanks,
 
Craig Peterson
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

(no subject)

[ACS]

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

(no subject)

[Glenn W. Paschal]

Hello, group!
 
Can anyone tell me if they have used or are using a product called Profi'C
from MBSII.net?  (It's an accounting package for UV)
 
If so, can you give me a general overview... pros/cons... likes/dislikes...
etc?
 
Thanks,
 
Glenn W. Paschal
PasTech LLC
Computer Consulting
ph. (931) 526-9631
fx. (931) 526-9678
email.   [EMAIL PROTECTED]
web.   www.pastech.net
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

(no subject)

[k_hw]

Here is my SQL Statement created in Wintegrate for Universe.
* SQL Statement
SQLBuilder.ESelect=`SI.BROKER,SUM(SI.F14)`
SQLBuilder.EFrom=`SI`
SQLBuilder.EWhere=`SI.PERIOD = <>`
SQLBuilder.EGroup=`SI.BROKER`
SQLBuilder.EOrder=`SI.BROKER DESC`
SQLBuilder.EFrom=`SI`
SQLBuilder.EHeading=``
SQLBuilder.EFooting=``
SQLBuilder.OutputTo=`Screen`
I need help on the following:
1.What syntax I should use to select for a specific Broker Code (Alpha 
Numeric).  
2. If I want to add the field SI.CUSTOMER.ID, what syntax to use to get total 
by CUSTOMER.ID and also total by GROUP for each BROKER in the same statement.

Krish

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