RE: [U2] Why Buy (or develop in) UniVerse?

2008-08-13 Thread Anthony Youngman
Relational theory requires you to abstract the database to fit a (badly flawed) 
prescriptive theory of what data *should* be like. MV simply models the 
database to look like the real world.

Relational scatters the data about individual real-world items across multiple 
tables. MV (properly designed) puts it all in one place. That's why MV doesn't 
need optimisers etc - it doesn't need to guess what data is likely to be 
accessed as a blob - if data is tightly joined in the real world, it is likely 
to be tightly joined in an MV database (while it's guaranteed to be scattered 
everywhere in a relational database).

Relational REQUIRES that data comes in two dimensions. MV reflects the real 
world in accepting data that comes in more than two dimensions. A generic data 
is n-dimensional theory will ALWAYS be preferable to a data is 2-dimensional 
theory.

I liken that requirement of relational to Euclid's assertion in geometry that 
parallel lines never meet. Without realising it, he placed an artificial 
restraint on geometry and held it back centuries. CD have done the same for 
database theory.

Would you use Newtonian mechanics to model events in the LHC? The physicists 
would laugh you out of Switzerland.

As David said, Oracle market to CEOs - relational wins on marketing clout. 
Unfortunately, the mathematical foundation behind it is iredeemably flawed :-( 
It breaks the Einsteinian corollory to Occam - make it as simple as possible - 
but no simpler - relational theory has been simplified too far, with the 
result that it ends up far more complex than it need be.

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan
Sent: 13 August 2008 01:18
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Why Buy (or develop in) UniVerse?

Hi Louie

Intersystems have done some benchmarks of multidimensional databases versus
RDBMS and some of that logic follows through to UniVerse.

It is difficult to compare UniVerse to RDBMS in benchmarks as they are
designed for RDBMS strengths.  If a benchmark was designed for UniVerse
strengths instead, RDBMS would not look so rosy.

RDBMS databases are designed to optimise cache and indexing because of the
performance issues in the database.  UniVerse does not inherit those
performance issues, hence they do not need to optimise Cache and indexs to
the same extent and the optimisations needs to be different.

There are hosts of differences.
RDBMS have fixed length and fixed structure records, where as UniVerse has
variable length records and fields can be added at any time.  More UniVerse
records can fit on a disk sector than RDBMS rows increasing U2 performance.
RDBMS don't efficiently lock rows, they do group locks.  Universe can lock
individual records without performance hits.
RDBMS work with optimistic locking as pessimistic locking is a nightmare
with group locking.  UniVerse can handle both optimistic and pessimistic
locking.
RDBMS stores all tables within one file, UniVerse has a file for every
table.  Totally different approaches for BU, Restore and handling file
corruptions.
RDBMS have to join multiple tables which creates overhead and referential
integrity issues.  UniVerse stores all specific data in a multidimensional
record.
UniVerse is close to Zero-Administration, where RDBMS still require
expensive Database administrators.
RDBMS have large workloads in setting up security access to tables for
different users.  UniVerse can use table security or OS file security.
RDBMS have limited functionality in business rules stored in the database.
UniVerse can handle complex business rules with ease.  In complex
applications UniVerse is well ahead.

However the argument should not be technical.  The CEO and board does not
make decisions on Cache and indexes, they make it on a business case.  ROI,
Cost of running, Staff numbers to administer and develop, competitive
advantage.  The old joke was what hardware does Oracle run best on, a
projector.  Oracle markets to CEOs and does little technology discussion,
that is why they are successful.

Its horses for courses, but if a project is going to be complex, the success
rate of the project completing on time and on cost in UniVerse is near 100%,
on an RDBMS the numbers are scary.

Regards


David Jordan

Managing Consultant
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Why Buy (or develop in) UniVerse?

2008-08-13 Thread Brian Leach
David

As always, that is a great post.
Hit the nail on the head.

I think part of the problem is we continue to call UniVerse a database. It 
isn't - it's an application platform that happens to have a complex storage 
model behind it. When you compare *application* performance against the three 
tier models required for effective RDBMS backed apps, the numbers will stack up 
very differently.

Brian
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Why Buy (or develop in) UniVerse?

2008-08-13 Thread Brian Leach
To add to my post:

If you want one single good reason, take a look at the Wrox Press Expert One to 
One series books by Roger Jennings on database programming. He's a SQL Server 
and .Net guru. Read his chapters on performance tuning and concurrency 
management and weep for those guys.

And if that doesn't convince, I'd really recommend a good book on using the 
Oracle query optimiser to get performance out of that...

Then you'll know why so few RDMBS projects deliver robusness on time and on 
budget.

Brian
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] RE: TCL literal select

2008-08-13 Thread Anthony Youngman
Rather than writing a simple program ...

SELECT PARTS WITH EVAL DCOUNT(F1, '') GT 0

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R.
Sent: 12 August 2008 21:59
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] RE: TCL literal select

I tried using the lower case SELECT/LIST to use native UniData syntax, and 
that did not work.

Try writing a simple program to convert the double quotes to something else 
(like a tilda) then search the I-desc for that.

ED BP TILDA
SUBROUTINE TILDA(RTN.VAL, ORIG.VAL)
RTN.VAL = CONVERT(ORIG.VAL, '', '~')
RETURN


ED DICT PARTS F1.TILDA
I
SUBR(TILDA, F1)
...


SELECT PARTS WITH F1.TILDA = [~]



John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH  45342
937-866-0711 x44380

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway
Sent: Tuesday, August 12, 2008 4:00 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] TCL literal select

Hi,

I work with a Unidata/Dataflo system on HPUX.
I am having trouble selecting records in my PARTS file.

I want to select all parts that have a  in the description field (F1).
People have been using  instead of INCH.
This causes problems for me during processing some reports and exports.

I have tried quite a few select statements with no success.

LIST PARTS WITH F1 = [//]
LIST PARTS WITH F1 = //
LIST PARTS WITH F1 = /''/
LIST PARTS WITH F1 = ['']
LIST PARTS WITH F1 = ''
LIST PARTS WITH F1 = /''/
LIST PARTS WITH F1 = \[]\
LIST PARTS WITH F1 = [\\]
LIST PARTS WITH F1 = ''

Wildcards on my system are brackets, [ leading and ] following

Any ideas on what would work?
Somebody showed me once, so I know it can be done.
I lost my notes though.

Thanks,

Bruce Ordway


Viking Engineering  Development Inc.
5750 Main St. N.E.
Fridley, MN 55432

Visit us at www.Vikingeng.com

This message contains confidential information and is intended only for the 
individual named. If you are not the named addressee you should not 
disseminate, distribute or copy this e-mail. Please notify the sender 
immediately by e-mail if you have received this e-mail by mistake and delete 
this e-mail from your system. E-mail transmission cannot be guaranteed to be 
secure or error-free as information could be intercepted, corrupted, lost, 
destroyed, arrive late or incomplete, or contain viruses. The sender therefore 
does not accept liability for any errors or omissions in the contents of this 
message, which arise as a result of e-mail transmission. If verification is 
required please request a hard-copy version.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] RE: TCL literal select

2008-08-13 Thread Anthony Youngman
Ooops ...

COUNT, not DCOUNT

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman
Sent: 13 August 2008 12:01
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] RE: TCL literal select

Rather than writing a simple program ...

SELECT PARTS WITH EVAL DCOUNT(F1, '') GT 0

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R.
Sent: 12 August 2008 21:59
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] RE: TCL literal select

I tried using the lower case SELECT/LIST to use native UniData syntax, and 
that did not work.

Try writing a simple program to convert the double quotes to something else 
(like a tilda) then search the I-desc for that.

ED BP TILDA
SUBROUTINE TILDA(RTN.VAL, ORIG.VAL)
RTN.VAL = CONVERT(ORIG.VAL, '', '~')
RETURN


ED DICT PARTS F1.TILDA
I
SUBR(TILDA, F1)
...


SELECT PARTS WITH F1.TILDA = [~]



John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH  45342
937-866-0711 x44380

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway
Sent: Tuesday, August 12, 2008 4:00 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] TCL literal select

Hi,

I work with a Unidata/Dataflo system on HPUX.
I am having trouble selecting records in my PARTS file.

I want to select all parts that have a  in the description field (F1).
People have been using  instead of INCH.
This causes problems for me during processing some reports and exports.

I have tried quite a few select statements with no success.

LIST PARTS WITH F1 = [//]
LIST PARTS WITH F1 = //
LIST PARTS WITH F1 = /''/
LIST PARTS WITH F1 = ['']
LIST PARTS WITH F1 = ''
LIST PARTS WITH F1 = /''/
LIST PARTS WITH F1 = \[]\
LIST PARTS WITH F1 = [\\]
LIST PARTS WITH F1 = ''

Wildcards on my system are brackets, [ leading and ] following

Any ideas on what would work?
Somebody showed me once, so I know it can be done.
I lost my notes though.

Thanks,

Bruce Ordway


Viking Engineering  Development Inc.
5750 Main St. N.E.
Fridley, MN 55432

Visit us at www.Vikingeng.com

This message contains confidential information and is intended only for the 
individual named. If you are not the named addressee you should not 
disseminate, distribute or copy this e-mail. Please notify the sender 
immediately by e-mail if you have received this e-mail by mistake and delete 
this e-mail from your system. E-mail transmission cannot be guaranteed to be 
secure or error-free as information could be intercepted, corrupted, lost, 
destroyed, arrive late or incomplete, or contain viruses. The sender therefore 
does not accept liability for any errors or omissions in the contents of this 
message, which arise as a result of e-mail transmission. If verification is 
required please request a hard-copy version.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Why Develop in UniVerse?

2008-08-13 Thread Brutzman, Bill
A lot of CEO's have a finance background.  A lot of finance people revere
Oracle
financials.  They worship the functionality of the screens and reports.

That it takes an extra guy or two to admin the database... just does not
matter.

Invoking one of (soft) rock music's hard lessons... Give the people what
they want.

--Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [UV] Editing Subsequent Value Marks

2008-08-13 Thread Brutzman, Bill
I have what looks like ^253^253 that needs to be just ^253.

Without luck I have tried...

1: C/^253^253/^253

and

1: C\^253^253\^253

Suggestions would be appreciated.

--Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] RE: TCL literal select

2008-08-13 Thread Bruce Ordway
Hi,

I ended up using this from Martin C. (of Epicor fame).
I don't know why none of the TCL examples would work for me.
Something to do with Unidata 5.2 and my particular flavor I guess.

Thanks to you all

 a Virtual Field type dictionary using the INDEX function...
i.e.
001: V  
002: INDEX(F1,'',1)
003:
004:
005: 6L 
006: S

-Original Message-
From: Anthony Youngman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 13, 2008 7:08 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] RE: TCL literal select

Ooops ...

COUNT, not DCOUNT

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony
Youngman
Sent: 13 August 2008 12:01
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] RE: TCL literal select

Rather than writing a simple program ...

SELECT PARTS WITH EVAL DCOUNT(F1, '') GT 0

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R.
Sent: 12 August 2008 21:59
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] RE: TCL literal select

I tried using the lower case SELECT/LIST to use native UniData syntax,
and that did not work.

Try writing a simple program to convert the double quotes to something
else (like a tilda) then search the I-desc for that.

ED BP TILDA
SUBROUTINE TILDA(RTN.VAL, ORIG.VAL)
RTN.VAL = CONVERT(ORIG.VAL, '', '~')
RETURN


ED DICT PARTS F1.TILDA
I
SUBR(TILDA, F1)
...


SELECT PARTS WITH F1.TILDA = [~]



John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH  45342
937-866-0711 x44380

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway
Sent: Tuesday, August 12, 2008 4:00 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] TCL literal select

Hi,

I work with a Unidata/Dataflo system on HPUX.
I am having trouble selecting records in my PARTS file.

I want to select all parts that have a  in the description field (F1).
People have been using  instead of INCH.
This causes problems for me during processing some reports and exports.

I have tried quite a few select statements with no success.

LIST PARTS WITH F1 = [//]
LIST PARTS WITH F1 = //
LIST PARTS WITH F1 = /''/
LIST PARTS WITH F1 = ['']
LIST PARTS WITH F1 = ''
LIST PARTS WITH F1 = /''/
LIST PARTS WITH F1 = \[]\
LIST PARTS WITH F1 = [\\]
LIST PARTS WITH F1 = ''

Wildcards on my system are brackets, [ leading and ] following

Any ideas on what would work?
Somebody showed me once, so I know it can be done.
I lost my notes though.

Thanks,

Bruce Ordway


Viking Engineering  Development Inc.
5750 Main St. N.E.
Fridley, MN 55432

Visit us at www.Vikingeng.com

This message contains confidential information and is intended only for
the individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and
delete this e-mail from your system. E-mail transmission cannot be
guaranteed to be secure or error-free as information could be
intercepted, corrupted, lost, destroyed, arrive late or incomplete, or
contain viruses. The sender therefore does not accept liability for any
errors or omissions in the contents of this message, which arise as a
result of e-mail transmission. If verification is required please
request a hard-copy version.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Viking Engineering  Development Inc.
5750 Main St. N.E.
Fridley, MN 55432

Visit us at www.Vikingeng.com

This message contains confidential information and is intended only for the 
individual named. If you are not the named addressee you should not 
disseminate, distribute or copy this e-mail. Please notify the sender 
immediately by e-mail if you have received this e-mail by mistake and delete 
this e-mail from your system. E-mail transmission cannot be guaranteed to be 
secure or error-free as information could be intercepted, corrupted, lost, 
destroyed, arrive late or incomplete, or contain viruses. The sender therefore 
does not accept liability for any errors or omissions in the contents of this 
message, which arise as a result of e-mail transmission. If verification is 
required please request a hard-copy version.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Editing Subsequent Value Marks

2008-08-13 Thread Burwell, Ed
If it's Unidata, then do EV (Edit Values) and that will put you in a vertical 
editor of those values, then you can go to the one you want to remove and do a 
DE (Delete line) then FI (File Item) and it will return you to the level you 
where at.  You may want to play with this on a test item till you get the hang 
of it.
 
Ed Burwell
 
CASIO AMERICA, INC.
570 Mt. Pleasant Avenue
Dover, NJ  07801
973-361-5400 x1512
email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
www.casio.com http://www.casio.com 


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill
Sent: Wednesday, August 13, 2008 11:20 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] [UV] Editing Subsequent Value Marks


I have what looks like ^253^253 that needs to be just ^253.

Without luck I have tried...

1: C/^253^253/^253

and

1: C\^253^253\^253

Suggestions would be appreciated.

--Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

__
This e-mail has been scanned by MCI Managed Email Content Service, using 
Skeptic(tm) technology powered by MessageLabs. For more information on MCI's 
Managed Email Content Service, visit http://www.mci.com.
__

__
This e-mail has been scanned by MCI Managed Email Content Service, using 
Skeptic(tm) technology powered by MessageLabs. For more information on MCI's 
Managed Email  Content Service, visit http://www.mci.com.
__
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Editing Subsequent Value Marks

2008-08-13 Thread Edward Brown
Try a CW first? Although your first form works in AE on unidata 7.1...


Edward

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill
Sent: 13 August 2008 16:20
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] [UV] Editing Subsequent Value Marks

I have what looks like ^253^253 that needs to be just ^253.

Without luck I have tried...

1: C/^253^253/^253

and

1: C\^253^253\^253

Suggestions would be appreciated.

--Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

---
Please remember to recycle wherever possible. 
Reduce, reuse, recycle, think do you need to print this e-mail?
---
This e-mail and any attachment(s), is confidential and may be legally 
privileged. It is intended solely for the addressee. If you are not the 
addressee, dissemination, copying or use of this e-mail or any of its content 
is prohibited and may be unlawful. If you are not the intended recipient please 
inform the sender immediately and destroy the e-mail, any attachment(s) and any 
copies. All liability for viruses is excluded to the fullest extent permitted 
by law. It is your responsibility to scan or otherwise check this email and any 
attachment(s). Unless otherwise stated (i) views expressed in this message are 
those of the individual sender (ii) no contract may be construed by this 
e-mail. Emails may be monitored and you are taken to consent to this 
monitoring.  

Civica Services Limited, Company No. 02374268; Civica UK Limited, Company No. 
01628868
Both companies are registered in England and Wales and each has its registered 
office at 2 Burston Road, Putney, London, SW15 6AR.
---
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Editing Subsequent Value Marks

2008-08-13 Thread Brenda Price
If you have a version of UV with AE and it is working you can use EV to
edit the mv position and delete the extra. 

Brenda 

-Original Message-
From: Brutzman, Bill [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 13, 2008 10:20 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] [UV] Editing Subsequent Value Marks

I have what looks like ^253^253 that needs to be just ^253.

Without luck I have tried...

1: C/^253^253/^253

and

1: C\^253^253\^253

Suggestions would be appreciated.

--Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] TCL literal select

2008-08-13 Thread Nick Gettino
I would suggest creating INDEX to access, build and maintain.
1.  create a virtual dictionary called CHECKINCH with the following
on line 2. IF INDEX(F1,'',1) THEN 1 ELSE 0
2.  create a virtual dictionary called INCH with this on line 2.
IF CHECKINCH THEN F1 ELSE 
3.  CREATE.INDEX PARTS INCH NO.NULLS
To view the data LIST.INDEX PARTS INCH DETAIL 
Now you have just the INCH records identified to do with as you like,
and any adds, deletes or modifications get automatically done with no
coding.
You can now also use SETINDEX and SELECTINDEX to go directly where a key
should be in the file or grab the entire file that has INCH.

Nick

Nicholas M Gettino | Director of Development | EnRoute Emergency
Systems, an Infor company | office: 813-207-6998 | fax: 678-393-5389
[EMAIL PROTECTED] | www.enroute911.com
Register Now! | EnRoute Emergency Systems Customer Conference |
September 22-25, 2008 | Mainsail Suites Hotel  Conference Center |
Tampa, Florida
 
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton
Sent: Tuesday, August 12, 2008 9:56 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] TCL literal select

Bruce Ordway wrote:
 Hi,
 
 I work with a Unidata/Dataflo system on HPUX.
 I am having trouble selecting records in my PARTS file.
 
 I want to select all parts that have a  in the description field
(F1).
 People have been using  instead of INCH.
 This causes problems for me during processing some reports and
exports.
 

To include double-quote within field to be searched, use single quote as

delimiter.

SELECT PARTS WITH F1 = '['
-or-
SELECT PARTS WITH F1 LIKE '..'


-- 
Allen Egerton
aegerton at pobox dot com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Editing Subsequent Value Marks

2008-08-13 Thread Colin Alfke
If you're using AE then DV will delete the last MV (whether it's empty or
not).

Check the help for more extensive syntax (you can delete specified values,
sub-values etc). There are a whole host of value editing functions.

Hth
Colin Alfke
Calgary, Canada

-Original Message-
From: Brutzman, Bill

I have what looks like ^253^253 that needs to be just ^253.

Without luck I have tried...

1: C/^253^253/^253

and

1: C\^253^253\^253

Suggestions would be appreciated.

--Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Editing Subsequent Value Marks

2008-08-13 Thread Caryl Lange
A dot?

C.^253^253.^253

Caryl


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill
Sent: Wednesday, August 13, 2008 8:20 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] [UV] Editing Subsequent Value Marks

I have what looks like ^253^253 that needs to be just ^253.

Without luck I have tried...

1: C/^253^253/^253

and

1: C\^253^253\^253

Suggestions would be appreciated.

--Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Editing Subsequent Value Marks

2008-08-13 Thread IT-Laure Hansen
Either should work.

When you are editing the record, type ^ (shift+6) alone then press (Enter) to 
reveal the hidden or mysterious codes. It may be that what looks like ^253^253 
is not truly that.

Laure Hansen,
City of Redwood City - Information Technology
1017 Middlefield Road - Redwood City, CA 94063
Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204
[EMAIL PROTECTED]

o Please think green before printing this e-mail

Subscribe to receive Redwood City E-News, news releases, 
or other documents via email: Click here to register/subscribe

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill
Sent: Wednesday, August 13, 2008 8:20 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] [UV] Editing Subsequent Value Marks

I have what looks like ^253^253 that needs to be just ^253.

Without luck I have tried...

1: C/^253^253/^253

and

1: C\^253^253\^253

Suggestions would be appreciated.

--Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] TCL literal select

2008-08-13 Thread Bill Haskett
Allen:

I use UD in PICK mode and the query processor has the same problem as the OP 
noted.
UD doesn't like single quotes in PICK mode.  In fact, numerous things don't 
work in
AQL when in PICK mode.

I wasn't able to get any of the suggestions to work in UD.

Bill

-Original Message-
From: [EMAIL PROTECTED] [mailto:owner-u2-
[EMAIL PROTECTED] On Behalf Of Allen Egerton
Sent: Tuesday, August 12, 2008 6:56 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] TCL literal select

Bruce Ordway wrote:
 Hi,

 I work with a Unidata/Dataflo system on HPUX.
 I am having trouble selecting records in my PARTS file.

 I want to select all parts that have a  in the description field (F1).
 People have been using  instead of INCH.
 This causes problems for me during processing some reports and exports.


To include double-quote within field to be searched, use single quote as
delimiter.

SELECT PARTS WITH F1 = '['
-or-
SELECT PARTS WITH F1 LIKE '..'


--
Allen Egerton
aegerton at pobox dot com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] RE: TCL literal select

2008-08-13 Thread Bill Haskett
Bruce:

I think it's UD specifically (even D3 works with a number of the suggestions).  
UD is
very finicky with AQL and drives almost ALL PICK people crazy, and many who 
work both
UD and something else concurrently.

Bill

-Original Message-
From: [EMAIL PROTECTED] [mailto:owner-u2-
[EMAIL PROTECTED] On Behalf Of Bruce Ordway
Sent: Wednesday, August 13, 2008 8:26 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] RE: TCL literal select

Hi,

I ended up using this from Martin C. (of Epicor fame).
I don't know why none of the TCL examples would work for me.
Something to do with Unidata 5.2 and my particular flavor I guess.

Thanks to you all

 a Virtual Field type dictionary using the INDEX function...
i.e.
001: V
002: INDEX(F1,'',1)
003:
004:
005: 6L
006: S

-Original Message-
From: Anthony Youngman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 13, 2008 7:08 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] RE: TCL literal select

Ooops ...

COUNT, not DCOUNT

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony
Youngman
Sent: 13 August 2008 12:01
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] RE: TCL literal select

Rather than writing a simple program ...

SELECT PARTS WITH EVAL DCOUNT(F1, '') GT 0

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R.
Sent: 12 August 2008 21:59
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] RE: TCL literal select

I tried using the lower case SELECT/LIST to use native UniData syntax,
and that did not work.

Try writing a simple program to convert the double quotes to something
else (like a tilda) then search the I-desc for that.

ED BP TILDA
SUBROUTINE TILDA(RTN.VAL, ORIG.VAL)
RTN.VAL = CONVERT(ORIG.VAL, '', '~')
RETURN


ED DICT PARTS F1.TILDA
I
SUBR(TILDA, F1)
...


SELECT PARTS WITH F1.TILDA = [~]



John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH  45342
937-866-0711 x44380

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway
Sent: Tuesday, August 12, 2008 4:00 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] TCL literal select

Hi,

I work with a Unidata/Dataflo system on HPUX.
I am having trouble selecting records in my PARTS file.

I want to select all parts that have a  in the description field (F1).
People have been using  instead of INCH.
This causes problems for me during processing some reports and exports.

I have tried quite a few select statements with no success.

LIST PARTS WITH F1 = [//]
LIST PARTS WITH F1 = //
LIST PARTS WITH F1 = /''/
LIST PARTS WITH F1 = ['']
LIST PARTS WITH F1 = ''
LIST PARTS WITH F1 = /''/
LIST PARTS WITH F1 = \[]\
LIST PARTS WITH F1 = [\\]
LIST PARTS WITH F1 = ''

Wildcards on my system are brackets, [ leading and ] following

Any ideas on what would work?
Somebody showed me once, so I know it can be done.
I lost my notes though.

Thanks,

Bruce Ordway


Viking Engineering  Development Inc.
5750 Main St. N.E.
Fridley, MN 55432

Visit us at www.Vikingeng.com

This message contains confidential information and is intended only for
the individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and
delete this e-mail from your system. E-mail transmission cannot be
guaranteed to be secure or error-free as information could be
intercepted, corrupted, lost, destroyed, arrive late or incomplete, or
contain viruses. The sender therefore does not accept liability for any
errors or omissions in the contents of this message, which arise as a
result of e-mail transmission. If verification is required please
request a hard-copy version.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Viking Engineering  Development Inc.
5750 Main St. N.E.
Fridley, MN 55432

Visit us at www.Vikingeng.com

This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not 
disseminate,
distribute or copy this e-mail. Please notify the sender immediately by e-mail
if you have received this e-mail by mistake and delete this e-mail from your
system. E-mail transmission cannot be guaranteed to be secure or error-free as
information could be intercepted, corrupted, lost, destroyed, arrive late or
incomplete, or contain viruses. The sender therefore does not accept liability
for any errors or omissions 

[U2] uniobjects

2008-08-13 Thread doug chanco
does anyone know if its possible to run the uvrpc deamon (uniobjects) 
from the command line?  It appears that since we cannot find the problem 
we are going to rewrite our order entry program in .net from vb6, 
apparently from some initial testing that the .net version fo the 
program works whereas the vb6 version is still having problems.


Also is anyone aware of any ways to see what a deamon (in particular 
uvrpc) is doing?  We have talked to IBM and apparently the best 
suggestion we got from them was that the issue was being caused by the 
network card in the systems (which have been the same for years) so I am 
not even sure where that idea came from.


is anyone aware of any differences that would cause code written in .net 
to work versus code written in vb6 (I assume they are using different 
dll's anything on the server side)?  Also does the uvrpc have different 
daemons for .net and non .net?


thanks everyone

dougc
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Editing Subsequent Value Marks

2008-08-13 Thread Dan Fitzgerald
Did you do a shift-6 (^) first?

How about trying an R instead of a C?

_
Got Game? Win Prizes in the Windows Live Hotmail Mobile Summer Games Trivia 
Contest
http://www.gowindowslive.com/summergames?ocid=TXT_TAGHM
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Editing Paired Value Marks - Victory

2008-08-13 Thread Brutzman, Bill
Thanks to those who responded.

Using AE I was able to do a...

1: C/Sales.Order.ID^253/Sales.Order.ID

--Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] uniobjects

2008-08-13 Thread Nick Gettino
We had problems with the DLL's when they added the Chinese character set
and went from device licensing being on or off to it being a number from
0-9.
It was 7.1.6 Unidata on Windows, and 7.1.8 on AIX versions.
I am copying my RD Manager on this reply she can get you more details
if you believe this could be the issue.

Kim can you please read this thread and respond?

Thanks,
Nick

Nicholas M Gettino | Director of Development | EnRoute Emergency
Systems, an Infor company | office: 813-207-6998 | fax: 678-393-5389
[EMAIL PROTECTED] | www.enroute911.com
Register Now! | EnRoute Emergency Systems Customer Conference |
September 22-25, 2008 | Mainsail Suites Hotel  Conference Center |
Tampa, Florida
 
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of doug chanco
Sent: Wednesday, August 13, 2008 1:08 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] uniobjects

does anyone know if its possible to run the uvrpc deamon (uniobjects) 
from the command line?  It appears that since we cannot find the problem

we are going to rewrite our order entry program in .net from vb6, 
apparently from some initial testing that the .net version fo the 
program works whereas the vb6 version is still having problems.

Also is anyone aware of any ways to see what a deamon (in particular 
uvrpc) is doing?  We have talked to IBM and apparently the best 
suggestion we got from them was that the issue was being caused by the 
network card in the systems (which have been the same for years) so I am

not even sure where that idea came from.

is anyone aware of any differences that would cause code written in .net

to work versus code written in vb6 (I assume they are using different 
dll's anything on the server side)?  Also does the uvrpc have different 
daemons for .net and non .net?

thanks everyone

dougc
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] TCL literal select

2008-08-13 Thread Cordes, Tom (contractor)
Allen,

Changing the first letter of the verb forces processing of the query in
'U'nidata mode so you have to use 'LIKE' instead of '='.

If that doesn't work, try a virtual dictionary item that calls a subroutine
that outputs IN for every occurance of ''.

Tom
-Original Message-
From: Bill Haskett [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 13, 2008 12:48 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] TCL literal select

Allen:

I use UD in PICK mode and the query processor has the same problem as the OP
noted.
UD doesn't like single quotes in PICK mode.  In fact, numerous things don't
work in AQL when in PICK mode.

I wasn't able to get any of the suggestions to work in UD.

Bill

-Original Message-
From: [EMAIL PROTECTED] [mailto:owner-u2- 
[EMAIL PROTECTED] On Behalf Of Allen Egerton
Sent: Tuesday, August 12, 2008 6:56 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] TCL literal select

Bruce Ordway wrote:
 Hi,

 I work with a Unidata/Dataflo system on HPUX.
 I am having trouble selecting records in my PARTS file.

 I want to select all parts that have a  in the description field (F1).
 People have been using  instead of INCH.
 This causes problems for me during processing some reports and exports.


To include double-quote within field to be searched, use single quote 
as delimiter.

SELECT PARTS WITH F1 = '['
-or-
SELECT PARTS WITH F1 LIKE '..'


--
Allen Egerton
aegerton at pobox dot com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] TCL literal select

2008-08-13 Thread Allen Egerton

Bill Haskett wrote:

Allen:

I use UD in PICK mode and the query processor has the same problem as the OP 
noted.
UD doesn't like single quotes in PICK mode.  In fact, numerous things don't 
work in
AQL when in PICK mode.

I wasn't able to get any of the suggestions to work in UD.

Bill


I just created a temporary account on a Universe machine, in PICK 
flavor.  And ran right into the same problem.  Which suggests to me that 
I test my answers before I present them.


--
Allen Egerton
aegerton at pobox dot com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Editing Paired Value Marks

2008-08-13 Thread Brutzman, Bill
1.  Yes... I definitely did a shift-6 first.

2.  Although our LIVE data was fixed, I had made a copy to our SANDBOX.

I tested the R technique and found that works for other strings, but
the R does not work here (either) for the paired 
value marks.

3.  It is easy for anyone to test on their own machines.  I suppose that it
is something of a small curiosity.

--Bill

-Original Message-
[mailto:[EMAIL PROTECTED] Behalf Of Dan Fitzgerald
Subject: RE: [U2] [UV] Editing Subsequent Value Marks

Did you do a shift-6 (^) first?

How about trying an R instead of a C?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: RE: [U2] Why Develop in UniVerse?

2008-08-13 Thread rogu2
Same thing with SAP.   And SAPs magic financial systems.

- Original Message -
From: Brutzman, Bill 
Date: Wednesday, August 13, 2008 10:55 am
Subject: RE: [U2] Why Develop in UniVerse?
To: 'u2-users@listserver.u2ug.org' 

 A lot of CEO's have a finance background. A lot of finance 
 people revere Oracle financials. They worship the functionality of the 
 screens and 
 reports.
 That it takes an extra guy or two to admin the database... just 
 does not matter.
 
 Invoking one of (soft) rock music's hard lessons... Give the 
 people what they want.
 
 --Bill
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] U2.NET v IBM.NET v UNIOBJECTS.NET

2008-08-13 Thread Susan Joslyn
Greetings,
I'm studying the U2 University Agenda to see what mischief I can get into.
Anyone know what is the difference between IBM.NET, U2.NET and
UNIOBJECTS.NET?  There are three distinct sessions at U2U on these.

TIA,
Susan
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] can anyone shed any light on parts of this core file?

2008-08-13 Thread doug chanco
well i finally got a core file but had no luck trying to read it with 
dbx (so I just vi'ed the file and below is what I was able to read)


I am praying that one of you universe/aix/uniobjects guru's can see if 
anything below is useful in finding our problem.


thanks!

dougc


-I/r-b/r-y/r. 
/r.,/r.=/r.P/r.e/r.^@/r.^U/r.$/r.@/r.V/r.}/r/^W/r/*/r/Muv_=/usr/ib

m/uv/bin/uvLANG=CLOGIN=carrmaPATH=/usr/bin:/usr/lbin:/usr/bin:/etc:/usr/sbin:/us
r/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/usr/java14/bin:/usr/local/samba/sb
in:/usr/ibm/uv/bin:/usr/opt/uv/bin:.LC__FASTMSG=trueCGI_DIRECTORY=/var/docsearch
/cgi-binLOGNAME=carrmaLOCPATH=/usr/lib/nls/locUVPATH=/usr/ibm/uv/binDOCUMENT_SER
VER_MACHINE_NAME=localhostUSER=carrmaAUTHSTATE=compatSHELL=/usr/bin/kshODMDIR=/e
tc/objreposDOCUMENT_SERVER_PORT=49213HOME=/home/everybodyTERM=viewpointITECONFIG
SRV=/etc/IMNSearchPWD=/usr2/zircon/INSTDOCUMENT_DIRECTORY=/usr/docsearch/htmlTZ=
EST5EDT,M3.2.0,M11.1.0UVHOME=/usr/ibm/uvITECONFIGCL=/etc/IMNSearch/clientsITE_DO
C_SEARCH_INSTANCE=searchNLSP^-o/r+@ 
^Eth^A/r,D/r,L^-o^-o^-o^-o^-o^-o^-o^
-o^-o^-o^-o^-o^-o^-o^-o^-o^-o^-o^-o^-o^-o^-o 
^AD^P^E^-o^P^Ax ^KR
H/r/x@(#)61 1.13  src/bos/usr/ccs/lib/libc/__threads_init.c, 
libcthrd, bos43
N 3/25/99 13:50:27 ^Eth ^EP^P-UVTLSVC-TLTIMEOUT
%cUVLICENSECHECK%dUVL

ICENSECHECKUVLICENSECHECKselect is over.

about to select.
received %d, %s, %s, %u

received %s, %s, %s, %s
write failed, errno is %d.
@(#)UniVerse Version 10.1.7%c%cA%cR%cD%cT%c%c%c%c%c%c%cioctl TCGETA 
failed, errn

o %d
Now get client identification about to write escape sequence.
ioctl TCSETAW failed, errno %d.
FD NOT SET on readfds, errno %d.
select returned 0; timeout, errno %d.
Debugging UNIX telnet server with timeout as 60.
Copyright )  IBM Corporation 2001, 2005. All rights reserved.%Z%UniVerse 
Platfor

m: International Business Machines (IBM) RS6000/AIX/r,0w%s-S%s%c%s
VOC^A^A^BYesIdealON.EXIT10.1.7CVIEW ^H ^E8ON.ABORT^G ^E^X^H 
^EPUV.LOGINphantom^E
^E^P^D ^E ^F ^E mkaccountALTER.IC 
updaccountMAXTRANSBUFUV_USERNO=LONGNAMES ON/b
in/mkaccount/bin/updaccountBUILD.INDEX PHANTOMLONGNAMES ON 
NEWACCUPDATE.INDEX PH
ANTOMRUN APP.PROGS UV.UPGRADESET.INDEX UV.TRANS INFORMBUILD.INDEX 
UV.TRANS FILER
UN APP.PROGS PACKAGE.INSCREATE.INDEX UV.TRANS 
FILESPECIAL.EDITOR.SELECT.DATA@(#)
UniVerse Version 10.1.7Copyright )  IBM Corporation 2001, 2005. All 
rights reser
ved.%Z%UniVerse Platform: International Business Machines (IBM) 
RS6000/[EMAIL PROTECTED] ^K
^TCS5 
-dWHORUNIAMTIMETERMRAIDQUITLOCKJOBSHUSHDATECORECHAPCASEBELLusrsUMASKT.REWT

.FWDT.EODT.BCKSLEEPPTIMELOGTOLOGONLIMITCHDIRBREAKABORTTEMPBELLTERM%s=%iT.WEOFT.
READSETPTRNOTIFYLOGOUTASSIGNT.WTLBLT.RDLBLSP.TAPERELEASEQSELECTPHANTOMNSELECTDIS
PLAYCATALOGLOGNAMEWARNINGSUVPROMPTUNASSIGNT.UNLOADGET.LIST^E ^H4^A 
^G^FSAVE.LIST

LIST.DIFFGET.STACKFORM.LISTCLEARDATAUV_USERNOSET.TELNETSAVE.STACKMERGE.LISTLIST.
UNIONLIST.LOCKSLIST.INTERDIVERT.OUTAUTOLOGOUT/bin/usrsRELEASE.XMLPREPARE.XMLLOGT
O.ABORTGET.SQLNULLENVIRONMENTDELETE.LISTDATE.FORMATCLEARSELECTCLEARCOMMONCLEAR.L
OCKSABORT.LOGINPAGE.MESSAGECLEARPROMPTS/tmp/utmp.%d5SET.REMOTE.IDSET.TERM.EUROGE
T.TERM.EUROCENTURY.PIVOTSETPTR.DEFAULTSET.SYSTEM.EUROGET.SYSTEM.EUROSET.CONVERT.
TERM.EUROGET.CONVERT.TERM.EURO  
\'~}|,^GDICTSAVEDLISTSSTACKWRITERELLEVELLOGI

NDEVICEPDICTONONOFFOFFTapeProcVerbMenuQueryPerformExecuteParagraphTransactionR
AID debuggerClient programExternal programCommand LanguageBASIC run 
machinewrarw
a r+w+a+r+w+a+ 
^LLfeofsemopfgetcfreadfputcftellfseekuvnetDBreadferrorfilenofflus

hfclosefwriteDBfinfoDBwblokDBrbloksselectDBwriteDBprobeDBclrflDBcloseDBstatusDBs
electDBdeleteDBscnat25DBreleaseDBReadLocknetgetstatsnetgetinfo30DBrecordlockedmi
smatch: offset = %ld, outoff = %ld

^ATCP^A^Atcpuvrpc0x%8x
0x%8x
^A,ARG DATA
TIMESTAMP
0x%8x
MESSAGE Key
0x%8d
   0x%8x   0x%8x
In rpc_init()
In uvrpc_call
In uvrpc_call
MESSAGE LENGTH
0x%4x   0x%4x
NW RETURN CODE
In send packet
In read packet
In build packet
In write packet
In read message
before the recv
In unpack packet
0x%2x   0x%2x   0x%2x
message_length=%d
message_length=%d
message_length=%d
before the select
0x%4x   %x %d (%.*s)
thissize set to %d
thissize set to %d
thissize set to %d
thissize set to %d
thissize set to %d
thissize set to %d
thissize set to %d
thissize set to %d
thissize set to %d
char arg(0x%8x)=%s
type of arg %d = %d
VERSION NUMBER  SEQNO
current version set!
encryption type set!
length of arg %d = %d
encryption state set!
In get encryption type
In set current version
In set encryption type
START OF ARG ARRAY DATA
low level timeout error
the read was interupted
low level read errno=%d
read returns 0 errno=%d
In get encryption state
In set encryption state
Element %3d Length  type
addr=0x%8x 0x%8x %c%c%c%c
Send Req: proc_name is %s
the select was interupted
after the recv nread = %d
uvrpc_call failed bad arg1
after the select rcnt = %d
In get current RPC version
compression threshold set!
going to read %d more chars
remote 

[U2] RE: TCL literal select and SQL Injection

2008-08-13 Thread Tony G
 From: Bruce Ordway
 I want to select all parts that have a  in the description 
 field (F1). People have been using  instead of INCH.
 This causes problems for me during processing some reports 
 and exports.

I don't didn't get the original post to this, only replies -
weird.

What's being described here is the concept called SQL Injection
where users intentionally or unintentionally put something in
data that causes queries to misbehave.

For example:

PRINT Enter your customer ID to see your data
INPUT CUSTID
EXECUTE SELECT ORDERS WITH CUST ':CUSTID:'
LOOP ... DISPLAY RESULTS ...

What if the user enters:
ME' OR NOT 'ME

Please excuse my Pick-style syntax, but obviously embedding the
user response into the query without filtering will allow anyone
to see pretty much anything.  Knowledge of the specific query
isn't always required, but if the user knows they're working with
a MV DBMS it's not tough to alter the query as easily as any SQL
query.

This isn't the sort of thing MV people grew up on with telnet
clients, but it's critical when deploying apps to a public
website - even with secured login.  The rest of the development
world is VERY aware of this concept and we aren't any more immune
to it - we've just survived with the good fortune of using
obscure software and being a more difficult target than your
average LAMP-based website.

This is a topic that I decided to NOT write about as the second
entry to my blog on website hacking.  But considering this is
still something I see on a daily basis I decided maybe it is
something that needs to be discussed somewhere.
remove.thisNebula-RnD.com/blog/tech/2007/01/website-hacks1.html/2


HTH
Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] uniobjects

2008-08-13 Thread David Jordan
Hi Doug

One of the problems is that VB6 is not really supported.  As the security
packs are added to XP there is more chance that a security pack causes
issues for VB6.  Of course .Net is supported.  If you upgrade to vista it is
likely not to work at all.  Check users are super users on the client.  If
you can make changes to the VB6, try and move the install out of program
files and keep registered dlls from the windows directory.

Regards

David Jordan
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] Editing Subsequent Value Marks

2008-08-13 Thread Ray Wurlod
C/^^253^^253/^^253/

 - Original Message -
 From: Brutzman, Bill [EMAIL PROTECTED]
 To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org
 Subject: [U2] [UV] Editing Subsequent Value Marks
 Date: Wed, 13 Aug 2008 11:19:36 -0400
 
 
 I have what looks like ^253^253 that needs to be just ^253.
 
 Without luck I have tried...
 
 1: C/^253^253/^253
 
 and
 
 1: C\^253^253\^253
 
 Suggestions would be appreciated.
 
 --Bill
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Editing Paired Value Marks

2008-08-13 Thread Brutzman, Bill
Ray:

Thanks for writing but the double-carat technique did not work on what I
have here.

--Bill

-Original Message-
[mailto:[EMAIL PROTECTED] Behalf Of Ray Wurlod

C/^^253^^253/^^253/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: RE: [U2] Why Develop in UniVerse?

2008-08-13 Thread David Jordan
A U2 reseller has just replaced a SAP site in Australia.  A good CFO should
be evaluating the business case. Also many businesses are getting hamstrung
by the lack of flexibility in some of these systems and U2 applications are
coming out on top in that area.

Regards
David Jordan
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] Editing Paired Value Marks

2008-08-13 Thread Clifton Oliver

Bill,

The assumption is that you are using the standard UniVerse ED editor.  
What editor are you using?


Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com



On Aug 13, 2008, at 5:13 PM, Brutzman, Bill wrote:


Ray:

Thanks for writing but the double-carat technique did not work on  
what I

have here.

--Bill

-Original Message-
[mailto:[EMAIL PROTECTED] Behalf Of Ray Wurlod

C/^^253^^253/^^253/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/