Re: Name Resolution

2004-04-30 Thread Ray Wurlod
You could add gethostbyname() as a GCI subroutine.  Take a look at getpid() as a 
template (in the UV account, LIST GCI).

- Original Message -
From: Craig Bennett [EMAIL PROTECTED]
Date: Fri, 30 Apr 2004 15:34:06 +1000
To: U2 Users Discussion List [EMAIL PROTECTED]
Subject: Name Resolution

 Hi All,
 
 does anyone currently do name resolution from within UV?
 
 I have a need to determine the dns name corresponding to an IP address under
 UV 10.0 on AIX, Linux and NT.
 I would prefer not execute an external utility and cannot use GCI.
 
 My current thoughts are to create a sockets client to query a DNS server,
 but I did wonder if there was a better way to do this.
 
 ICONV(203.42.18.135, DNSPTR) ;)
 
 thanks,
 
 
 Craig
 
 -- 
 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] B-TREE INDEX

2004-04-30 Thread Ray Wurlod
Ah, the well-known helpful error message.  Not.

What happens when you use these commands?
LIST.INDEX filename
LIST.INDEX filename STATS
LIST.INDEX filename DETAIL

Can you examine the INDEX.000 file (assuming it's that one) with uvfixfile or blook?

- Original Message -
From: Björn Behr [EMAIL PROTECTED]
Date: Fri, 30 Apr 2004 11:01:13 +0200
To: U2 User Group [EMAIL PROTECTED]
Subject: [UV] B-TREE INDEX

 We keep having a problem with our B-TREE INDEX that says
 ERROR IN B-TREE INDEX
 
 Can anybody help me out.
 
 Windows 2000, Universe 10.0
 
 Regards
 Björn Behr
 Programmer
 
 HYFLO Southern Africa (Pty) Ltd
 Tel : +27 11 386 5800
 Fax : +27 11 444 5391
 Mail: [EMAIL PROTECTED]
 WWW : http://www.hyflo.co.za 
 
 In the beginning, the universe was created.
  This made a lot of people very angry, and
  has been widely regarded as a bad idea.
  - Douglas Noel Adams (b. 1952), British author
 
 
 --
 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: Differences

2004-04-30 Thread Ray Wurlod
DB2 is the original, proprietary IBM first normal form database product.  IBM now 
prefers to call it DB2 UDB, where the UDB stands for universal database.  

Since acquiring all of the databases, including UniVerse and UniData, from Informix in 
2001, IBM have also used the term DB2 to refer generically to all its database 
products, no doubt to confuse the world into believing that DB2 is the only database 
(personal opinion).

UniVerse and UniData are very similar (to end users), non first normal form database 
products, based on a model that pre-dates SQL.  While each supports SQL, it is not 
currently the principal query language used.  The data model, while relational, 
incorporates nesting, which DB2 UDB does not.  That is, conceptually, a cell 
(row/column intersection) can have a data type of table.  IBM acquired these, along 
with six other database products, from Informix.

Administration of UniVerse is radically different from UniData, and both even more 
radically different from DB2 UDB.

Further, there is no such thing as a course.  There's one for the query language, 
one for the programmer, one (or more) for the administrator in each case.  Try linking 
to IBM's web site, going to www-306.ibm.com/software/data/u2 as your start point.  You 
can get to the library (manuals, tech bulletins, etc.) and training and certification 
from this page.

Sometimes you will end up on a DB2 page while following these links.  The U2 
(UniVerse/UniData) information is usually in tiny print at the bottom or somewhere 
else obscure on these pages.  Good luck!


- Original Message -
From: Trevor McNamara [EMAIL PROTECTED]
Date: Fri, 30 Apr 2004 20:26:15 +1000
To: [EMAIL PROTECTED]
Subject: Differences

 Hey,
 
 Can someone please answer some questions as i am unsure on some database 
 types.
 
 Whats the difference between DB2 and UniVerse/UniData?
 
 Are they the same sort of structure?
 
 Can you do a DB2 course and be qualified enough to use UniVerse?
 
 Any other information or websites on this sort of thing (Newbie questions:) 
 ) would be much appreciated.
 
 Thanks
 
 Trev
 
 _
 Find love today with ninemsn personals. Click here:  
 http://ninemsn.match.com?referrer=hotmailtagline
 
 -- 
 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: VOC corruption

2004-04-29 Thread Ray Wurlod
Another thought from left field.
I wonder whether the rotating file pool may be implicated?  There was a brief time 
when, for a single Dynamic file, opening OVER.30 rotated DATA.30 out and vice versa 
(!).  VOC is supposed to be exempt from rotating (it and its dictionary are two of the 
reserved eight file units for sizing MFILES), but it might be worth checking with 
support about your particular exact release - explicitly request that they check the 
source code.
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: FATAL : Cannot create transaction cache file

2004-04-28 Thread Ray Wurlod
Is this UniVerse or UniData?  My guess is either that you've hit some limit (disk 
full?, max number of transaction cache files?), or that there's a permissions issue in 
the directory where the transaction cache file needs to be created.

- Original Message -
From: Ang Suan Yong [EMAIL PROTECTED]
Date: Wed, 28 Apr 2004 10:33:56 +0800
To: U2-users [EMAIL PROTECTED]
Subject: FATAL : Cannot create transaction cache file

 Dear All,
 
   Do any one having facing the below problem before where the program
 run half way it prompt Cannot create transaction cache file . When such a
 problem occur, what we do is just rerun the program and is working well.
 
   Is it possible that this is due to hitting the maximun record lock ?
 
 
 
   Program UPD.SUB: Line 45, FATAL: Cannot create transactio
   n cache file.
   Rolling back uncommitted transactions begun within this
 execution environment.
   
 
 Thanks and Regards
 
 
 
 DISCLAIMER:-
 This email is confidential and intended only for the use of the individual
 or entity named above and may contain information that is privileged. If you
 are not the intended recipient, you are notified that any dissemination,
 distribution or copying of this email is strictly prohibited. If you have
 received this email in error, please notify us immediately by return email
 or telephone and destroy the original message.  Thank you.
 
 
 -- 
 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: VOC corruption

2004-04-28 Thread Ray Wurlod
Are you using UniVerse error message logging (enabled by creating the error message 
file in the UV account) and, if so, does it tell you anything?
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: [UV] Problem reactivating select list

2004-04-26 Thread Ray Wurlod
Have you thought of using trigger subroutines to keep the audit trail?
Much easier, and the before- and after-records and keys are available for you right 
there in the arguments.  :D
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: How far can U2 scale?

2004-04-23 Thread Ray Wurlod
There are quite a few sites running upwards of 2000 users in my region (Asia Pacific). 
 The model is many small users (such as insurance brokers, accountants, tax agents, 
etc.) having dial-in access.  One site is licensed for 3300 users, and sustains a load 
over 3000 users most of the day with acceptable response metrics.  Strictly two tier 
(one tier really).

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


Re: PI Open is going away

2004-04-17 Thread Ray Wurlod
I don't remember seeing any three comments!

- Original Message -
From: Clifton Oliver [EMAIL PROTECTED]
Date: Sat, 17 Apr 2004 12:12:35 -0700
To: U2 Users Discussion List [EMAIL PROTECTED]
Subject: Re: PI Open is going away

 That would be John 60,000 lines of PMA assemby code and only 3 
 comments Drumheller.
 
 -- 
 
 Regards,
 
 Clif

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


RE: PI Open is going away

2004-04-17 Thread Ray Wurlod
One of the reasons PI/open could not advance was that its source control system was 
written in MIDASPLUS. D'oh!
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: UniObjects

2004-04-07 Thread Ray Wurlod
UniObjects does not use a sockets-based interface, so SSL and so on aren't relevant.

Rather, UniObjects uses a proprietary interface built on an architecture called 
InterCall. The only security is a port number that's not used for anything else, and 
a check in the unirpcservices file about nodes permitted to access the uvcs/udcs 
service.

In particular, no encryption is available within the product.

- Original Message -
From: Kevin Vezertzis [EMAIL PROTECTED]
Date: Wed, 7 Apr 2004 14:53:23 -0400
To: [EMAIL PROTECTED]
Subject: UniObjects

 Does anyone have knowledge of how to handle secure communications from
 UniObjects into Universe?  (SSL, SSH, etc.)  We are covered from end
 user to UniObjects, but not from UniObjects to Universe.  I haven't been
 able to find any supporting documentation..
  
 Thanks,
 Kevin
  
  
 Kevin D. Vezertzis
 Project Manager
 Cypress Business Solutions, LLC.
 678.494.9353  ext. 6576  Fax  678.494.9354
  
 [EMAIL PROTECTED]
 Visit us at www.cypressesolutions.com
  
  
  
 -- 
 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 do I determine whether a file is using 64 bit or 32 bitaddressing

2004-04-06 Thread Ray Wurlod
The STATUS statement (not the same as the STATUS function) returns a dynamic array of 
information about an open file. According to the BASIC manual, there are 30 fields. 

A little research has revealed that there are, in fact, 32 fields returned. 

Field 31 is the magic number, for example ACEF010B. 
Field 32 is an indicator of addressing mode. 1 = 32-bit old format, 3 = 32-bit new 
format, 5 = 64-bit. 

Code: 
OpenPath hashedfilepath To FileVariable 
Then 
   Status FileStuff From FileVariable 
   Then 
  If FileStuff32 = 5 
  Then 
 * file uses 64-bit addressing 
  End 
  Else 
 * file uses 32-bit addressing 
  End 
   End 
End 

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


RE: Modern Universe (TESTING)

2004-04-03 Thread Ray Wurlod
One thing I think everyone's missed (deliberately or otherwise) was that Sara's 
original post had a constraint with a LEADING wildcard  (WHERE address LIKE 
'%EXPLORATION').
The argument that has been raging since has used examples with TRAILING wildcards 
(WHERE name LIKE 'Sara%').

Apples and oranges, folks, especially if B-tree indexes are involved.
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: Modern Universe (TESTING)

2004-04-03 Thread Ray Wurlod
Joe,

The example you specified (below) is case-SENSITIVE.  It will only return rows where 
the value begins with the four upper-case letters designated.  In particular, it will 
not produce the results you showed (and could never select the row with SARRA).  
Your query is identical to the SQL:
SELECT fieldname FROM filename WHERE fieldname LIKE 'SARA%';

My techniques showed how to render this into a case-insensitive search by performing 
on-the-fly conversion to upper-case. It would be just as valid to perform on-the-fly 
conversion to lower case.

However, this conversion is done in the WHERE clause, not in the SELECT clause (or in 
the RetrieVe equivalents), so that the data values are displayed in whatever case they 
are stored.

Regards
Ray

- Original Message -
From: Joe Eugene [EMAIL PROTECTED]
Date: Wed, 31 Mar 2004 16:37:54 -0500
To: U2 Users Discussion List [EMAIL PROTECTED]
Subject: RE: Modern Universe (TESTING)

 Ray,
 
 I see you are doing a few things here, am not quite sure i understand.
 
 The only way i have OUR UV Programmers using BASIC/PICK do this
 is like
 
 SELECT [FILENAME] WITH [FIELDNAME] LIKE  'SARA]'  (NOTE **]* - Syntax might
 a bit OFF)
 
 Something like the above produces a CASE-INSENSITIVE Search and returns
 all the below
 
 Sara
 sarra
 saRraA etc.
 
 The UPCASE and LOWCASE only Returns those results right?
 
 So in your Experience, would you say SQL Interface is Faster than
 any other Interface within UV?
 
 Thanks,
 Joe Eugene
 
 
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 Behalf Of Ray Wurlod
 Sent: Wednesday, March 31, 2004 3:57 PM
 To: U2 Users Discussion List
 Subject: RE: Modern Universe (TESTING)
 
 
 On this basis here are the RetrieVe equivalents for my earlier
 post.  The main difference is that there's more than one verb (for
 different query result formats) and the selection criterion begins
 with the keyword WITH rather than WHERE.  And the pattern matching
 specifiers are different (for example ... rather than % for
 multi-character wildcard).
 
 verb PEOPLE NAME WITH NAME CONV MCU LIKE SARA...
 verb PEOPLE NAME WITH EVAL UPCASE(NAME) LIKE SARA...
 verb PEOPLE NAME WITH EVAL OCONV(NAME) LIKE SARA...
 verb PEOPLE NAME WITH EVAL UPCASE(LEFT(NAME)) = SARA
 
 where verb can be any of:
 LIST  SORTcolumnar report
 SELECTSSELECT Select List
 LIST.ITEM SORT.ITEM   raw format
 LIST.LABELSORT.LABEL  mailing labels
 REFORMAT  SREFORMAT   target is second file/table
 COUNT
 SUM   not really relevant for NAME
 
 HTH
 - Original Message -
 From: Joe Eugene [EMAIL PROTECTED]
 Date: Wed, 31 Mar 2004 15:33:20 -0500
 To: U2 Users Discussion List [EMAIL PROTECTED]
 Subject: RE: Modern Universe (TESTING)
 
  Tim,
 
  My apologies... Yes, i know UV has a SQL Interface but i didnt think
  many UV Programmers used this Interface...
 
  As a matter of Fact, i like the UV SQL Interface. I have a PE
 Edition of UV
  on all my machines and i have only used the SQL Interface within UV.
 
  In our UV Shop, UV Guys are NOT supposed to use this SQL Interface
  as they claim its very slow than using the Native SELECT WITH .
 
  I have read the UV Manual that reflects RDBMS, this manual explains you
  can setup Tables Exactly like any RDBMS using Data Types
 (Varchar, char,  Int etc)
 
  All the the testing i have done does NOT involve using the SQL
 Interface in UV,
  Our UV Shop uses FILE Types, NOT RDBMS Tables and we use
  PICK/BASIC/REDBACK to Interfact with these FILES.
 
  Perhaps the problem might be our UV Shop using PICK/BASIC...
  Maybe the SQL Interface on UV is much faster. I dont know.
 
  Thanks,
  Joe Eugene
 
 
 
  
 
  From: [EMAIL PROTECTED] on behalf of Timothy Snyder
  Sent: Wed 3/31/2004 3:12 PM
  To: U2 Users Discussion List
  Subject: RE: Modern Universe (TESTING)
 
 
 
 
  Joe Eugene wrote on 03/31/2004 02:59:29 PM:
 
   Please post your PICK/BASIC and SQL Query.. so we i can learn
   the magic you did on the PICK Side.
 
  Joe,
 
  Unless I'm missing something, Sara used the SQL statement against the
  UniVerse database.  Perhaps you weren't aware that UniVerse supports SQL
  statements to query the database.  I don't think she used any magic.
  Therefore, in her original post, she provided all the
 information you need
  to do a comparison.
 
  Also, you keep referencing PICK/BASIC.  BASIC is the programming
 language,
  not the query language.  There is also a native query language,
 but that's
  only one of many ways to access the database.
 
  I hope this helps to clarify your expectations.
 
 
  Tim Snyder
  IBM Data Management Solutions
  Consulting I/T Specialist , U2 Professional Services
 
  Office (717) 545-6403  (rolls to cell phone)
  [EMAIL PROTECTED]
  --
  u2-users mailing list
  [EMAIL PROTECTED]
  http://www.oliver.com/mailman/listinfo/u2-users
 
 
 
 
  --
  u2-users mailing

RE: [UV] Consult about SQL

2004-04-02 Thread Ray Wurlod
The first thing to notice is that a file scan is being performed on the LINFAC table.  
This could be speeded with an index on each of the constraining columns LINFAC.EMP and 
LINFAC.TIPFAC.

The inner joins are being performed via hash lookups, the fastest available method.  
There are 23469 matches between tables LINFAC and GCMCL and 131 matches between GCML 
and GCAREPRE, based on the join conditions specified.  There may be some gain to be 
had by indexing the foreign key columns LINFAC.CODCLI and GCML.CODREP1.

- Original Message -
From: Cesar Riba [EMAIL PROTECTED]
Date: Fri, 2 Apr 2004 10:37:21 +0200
To: 'U2 Users Discussion List' [EMAIL PROTECTED]
Subject: RE: [UV] Consult about SQL

 Hello,
 
   Another question
 
   Because a SQL query executed in Universe it take 20 seconds and the same
 query in MSAccess take 3 seconds.
 
 
   This is the result of EXPLAIN of this query
 
   SELECT LINFAC.GRUPART, SUM(LINFAC.BASPP * LINFAC.CAN) As SUMCANT,
 GCAREPRE.NOMBRE AS NOMREPRE,
   SQL+GCAREPRE.CODIGO AS CODREPRE
   SQL+FROM
   SQL+GCAREPRE INNER JOIN GCMCL ON GCAREPRE.CODIGO = GCMCL.CODREP1
   SQL+INNER JOIN LINFAC ON [EMAIL PROTECTED] = LINFAC.CODCLI
   SQL+WHERE LINFAC.EMP = 1 AND
   SQL+(LINFAC.TIPFAC='01' OR LINFAC.TIPFAC='03' OR LINFAC.TIPFAC='05' OR
 LINFAC.TIPFAC='06' OR LINFAC.TIPFAC='10')
   SQL+GROUP BY LINFAC.GRUPART, GCAREPRE.CODIGO, GCAREPRE.NOMBRE HAVING
 SUM(LINFAC.BASPP*LINFAC.CAN) IS NOT NULL
   SQL+EXPLAIN;
   Optimizing query block 0
   Table restriction: LINFAC.EMP = 1 AND (LINFAC.TIPFAC = '10' OR
 (((LINFAC.TIPFAC= '01' OR LINFAC.TIPFAC = '03') ORLINFAC.TIPFAC = '05') OR
 LINFAC.TIPFAC = '06'))
 
   Driver source: LINFAC
   Access method: file scan
 
   1st join primary:   LINFAC est. cost:   30445
  secondary: GCMCL est. cost:   23469
type:  hashed join (primary key)
 
   2nd join primary:   GCMCL est. cost:   23469
  secondary: GCAREPRE est. cost:   131
type:  hashed join (primary key)
 
   Grouped by: GRUPARTCODIGONOMBRE
 
 
 Thanks,
 
 -Mensaje original-
 De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 nombre de Ray Wurlod
 Enviado el: jueves, 01 de abril de 2004 22:44
 Para: U2 Users Discussion List
 Asunto: Re: [UV] Consult about SQL
 
 
 The best way to speed inner joins is to index the column that is the foreign
 key.
 
 For example, if your join is of the form:
 SELECT T1.ORDERNO, T2.CUSTNO, T2.CUSTNAME
 FROM ORDERS T1, CUSTOMERS T2
 WHERE T1.CUSTNO = T2.CUSTNO ;
 
 then you need an index on ORDERS.CUSTNO
 
 In other cases, depending on exactly what the query is, you can also
 sometimes obtain benefit by rewriting the SQL to use sub-queries, unions,
 and other techniques.
 
 
 - Original Message -
 From: Cesar Riba [EMAIL PROTECTED]
 Date: Thu, 1 Apr 2004 11:10:18 +0200
 To: [EMAIL PROTECTED]
 Subject: Consult about SQL
 
  Hello,
 
 
  I'm a problem when use a SQL query that have one or various INNER JOIN
 this
  is very very slow. How I can accelerate this tipus of query.
 
 
 
  Thanks.
 
 
  César
 
 
 
 
 
 
  --
  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

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


RE: [UV] Case-Insensitive Comparison (was Modern Universe (TESTING))

2004-03-31 Thread Ray Wurlod
I haven't been following this thread very intensely.
However, a case insensitive pattern match is straightforward in UniVerse by specifying 
an on-the-fly conversion to upper case or lower case.
As normal there are several ways to accomplish this.  I will constrain examples to 
UniVerse SQL, but remember that the same techniques are available in UniVerse's other 
query language (RetrieVe).
SELECT NAME FROM PEOPLE WHERE NAME CONV 'MCU' LIKE 'SARA%';
SELECT NAME FROM PEOPLE WHERE EVAL UPCASE(NAME) LIKE 'SARA%';
SELECT NAME FROM PEOPLE WHERE EVAL OCONV(NAME,'MCU') LIKE 'SARA%';

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


RE: Modern Universe (TESTING)

2004-03-31 Thread Ray Wurlod
On this basis here are the RetrieVe equivalents for my earlier post.  The main 
difference is that there's more than one verb (for different query result formats) and 
the selection criterion begins with the keyword WITH rather than WHERE.  And the 
pattern matching specifiers are different (for example ... rather than % for 
multi-character wildcard).

verb PEOPLE NAME WITH NAME CONV MCU LIKE SARA...
verb PEOPLE NAME WITH EVAL UPCASE(NAME) LIKE SARA...
verb PEOPLE NAME WITH EVAL OCONV(NAME) LIKE SARA...
verb PEOPLE NAME WITH EVAL UPCASE(LEFT(NAME)) = SARA

where verb can be any of:
LIST  SORTcolumnar report
SELECTSSELECT Select List
LIST.ITEM SORT.ITEM   raw format
LIST.LABELSORT.LABEL  mailing labels
REFORMAT  SREFORMAT   target is second file/table
COUNT
SUM   not really relevant for NAME

HTH
- Original Message -
From: Joe Eugene [EMAIL PROTECTED]
Date: Wed, 31 Mar 2004 15:33:20 -0500
To: U2 Users Discussion List [EMAIL PROTECTED]
Subject: RE: Modern Universe (TESTING)

 Tim,
  
 My apologies... Yes, i know UV has a SQL Interface but i didnt think
 many UV Programmers used this Interface...
  
 As a matter of Fact, i like the UV SQL Interface. I have a PE Edition of UV
 on all my machines and i have only used the SQL Interface within UV.
  
 In our UV Shop, UV Guys are NOT supposed to use this SQL Interface
 as they claim its very slow than using the Native SELECT WITH .
  
 I have read the UV Manual that reflects RDBMS, this manual explains you
 can setup Tables Exactly like any RDBMS using Data Types (Varchar, char,  Int etc)
 
 All the the testing i have done does NOT involve using the SQL Interface in UV,
 Our UV Shop uses FILE Types, NOT RDBMS Tables and we use 
 PICK/BASIC/REDBACK to Interfact with these FILES.
  
 Perhaps the problem might be our UV Shop using PICK/BASIC...
 Maybe the SQL Interface on UV is much faster. I dont know.
  
 Thanks,
 Joe Eugene
  
  
 
 
 
 From: [EMAIL PROTECTED] on behalf of Timothy Snyder
 Sent: Wed 3/31/2004 3:12 PM
 To: U2 Users Discussion List
 Subject: RE: Modern Universe (TESTING)
 
 
 
 
 Joe Eugene wrote on 03/31/2004 02:59:29 PM:
 
  Please post your PICK/BASIC and SQL Query.. so we i can learn
  the magic you did on the PICK Side.
 
 Joe,
 
 Unless I'm missing something, Sara used the SQL statement against the
 UniVerse database.  Perhaps you weren't aware that UniVerse supports SQL
 statements to query the database.  I don't think she used any magic.
 Therefore, in her original post, she provided all the information you need
 to do a comparison.
 
 Also, you keep referencing PICK/BASIC.  BASIC is the programming language,
 not the query language.  There is also a native query language, but that's
 only one of many ways to access the database.
 
 I hope this helps to clarify your expectations.
 
 
 Tim Snyder
 IBM Data Management Solutions
 Consulting I/T Specialist , U2 Professional Services
 
 Office (717) 545-6403  (rolls to cell phone)
 [EMAIL PROTECTED]
 --
 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: U2UG Contract

2004-03-30 Thread Ray Wurlod
US copyright law doesn't help me in Australia.  Maybe applicable copyright law is 
a better term.  Then, Unless explicitly forbidden postings can be copied... is my 
preferred wording on that issue.

- Original Message -
From: [EMAIL PROTECTED]
Date: Tue, 30 Mar 2004 14:50:00 -0500
To: [EMAIL PROTECTED] (U2 Users Discussion List)
Subject: Re: U2UG Contract

 All postings to this forum remain the sole property of the poster.  Postings 
 however can be copied, observing US copyright law, for non-profit purposes.  U2ug 
 does not take any responsbility for any postings to this forum. 

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


RE: Setting up SQL step 1

2004-03-18 Thread Ray Wurlod
Manuals, etc., for UniVerse 9.5, 9.6 and 10.0 are all on the IBM website.  Also 
UniData 5.2 and 6.0.
Start at http://www-306.ibm.com/software/data/u2/pubs/library/

- Original Message -
From: Anthony Youngman [EMAIL PROTECTED]
Date: Thu, 18 Mar 2004 12:07:03 -
To: U2 Users Discussion List [EMAIL PROTECTED]
Subject: RE: Setting up SQL step 1

 Why might I have the 9.5 docu? Because we're still running it :-(
 
 It's all very well, but there is some truth in the old adage if it aint
 broke, don't fix it.
 
 Cheers,
 Wol

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


Re: [UV] SP.EDIT SP.ASSIGN HS

2004-03-18 Thread Ray Wurlod
SP.ASSIGN (HS sends the file to the spooler, with HOLD and RETAIN attributes asserted. 
 It does not send files to the HOLD file.  You will find your files in the directory 
referred to by your UVSPOOL configuration parameter.  You can use the SPOOL -LIST 
command to see that they are held from printing.

You can use the SP.EDIT command to print them and manage them (for example kill 
(de-queue) them).

If you want to send output to HOLD the correct command to use is SETPTR with the 
sixth argument set to 3.  For example:  SETPTR 0,132,2,0,0,3,BANNER MYFILE,BRIEF 
(this command directs the default print channel to a record called MYFILE in the 
HOLD file.

If you examine the SP.ASSIGN verb in the VOC file, and trace it back to source, you 
will find that SP.ASSIGN (HS actually ends up invoking the SETPTR command, but in mode 
1 (spooler), for example SETPTR 0,132,60,3,3,1,HOLD,RETAIN


- Original Message -
From: Cyndi Calvin [EMAIL PROTECTED]
Date: Thu, 18 Mar 2004 15:39:19 -0800
To: U2 Users Discussion List [EMAIL PROTECTED]
Subject: SP.EDIT  SP.ASSIGN HS

 Hi, I'm trying to use the 'SP.ASSIGN HS' to send the output to file under UNIX 
 HOLD directory.
 
 I'm doing and seeing the following -- but no file ever shows up under HOLD 
 directory.  Any clues or thoughts?  It gets to the queue?  But I don't know what to 
 answer to get it to file.  Thanks!!!
 
 All these Ready to Output should be deleted but I can't 
 
 SP.EDIT before I run the SP.ASSIGN 
 SP.EDIT
 Entry # 01200 : Is Ready to Output.
 Entry # 01201 : Is Ready to Output.
 Entry # 01202 : Is Ready to Output.
 Entry # 01203 : Is Ready to Output.
 Entry # 01211 : Is Ready to Output.
 Entry # 01227 : Is Ready to Output.
 Entry # 01230 : Is Ready to Output.
 Entry # 01231 : Is Ready to Output.
 Entry # 01234 : Is Ready to Output.
 Entry # 01236 : Is Ready to Output.
 Entry # 01238 : Is Ready to Output.
 Entry # 01239 : Is Ready to Output.
 Entry # 01259 : Is Ready to Output.
 Entry # 01260 : Is Ready to Output.
 Entry # 01264 : Is Ready to Output.
 Entry # 01267 : Is Ready to Output.
 Entry # 01277 : Is Ready to Output.
 Entry # 01282 : Is Ready to Output.
 Entry # 01364 : Is Ready to Output.
 Entry # 01370 : Is Ready to Output.
 Entry # 01371 : Is Ready to Output.
 SP.ASSIGN HS
 LIST.ITEM CUST (P
 Spooler Entry #2877
 SP.EDIT
 Entry # 01200 : Is Ready to Output.
 Entry # 01201 : Is Ready to Output.
 Entry # 01202 : Is Ready to Output.
 Entry # 01203 : Is Ready to Output.
 Entry # 01211 : Is Ready to Output.
 Entry # 01227 : Is Ready to Output.
 Entry # 01230 : Is Ready to Output.
 Entry # 01231 : Is Ready to Output.
 Entry # 01234 : Is Ready to Output.
 Entry # 01236 : Is Ready to Output.
 Entry # 01238 : Is Ready to Output.
 Entry # 01239 : Is Ready to Output.
 Entry # 01259 : Is Ready to Output.
 Entry # 01260 : Is Ready to Output.
 Entry # 01264 : Is Ready to Output.
 Entry # 01267 : Is Ready to Output.
 Entry # 01277 : Is Ready to Output.
 Entry # 01282 : Is Ready to Output.
 Entry # 01364 : Is Ready to Output.
 Entry # 01370 : Is Ready to Output.
 Entry # 01371 : Is Ready to Output.
 Entry   # 02877Status  : Hold*Size: 422305
 Priority: 88   Copies  : 1Delay   :
 Pages   : All  Eject   : Yes  Delete  : Yes
 Form: 1Printer : [Any]Options : None
 Display (Y/N/S/D/X/CR) ? N  (if I say Y it does show on the screen)
 Spool (Y/N=CR) ? Y
 Pages to output : ALL
 
 --
 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: Unable to read LOGS.DIR entry from D_UV_LOGS.

2004-03-16 Thread Ray Wurlod
If you're not using transaction logging (TXMODE=0) you can safely ignore this message. 
 It is the UniVerse transaction logging daemon trying to determine where it should 
keep its log files.
If you ARE using transaction logging (TXMODE=1) make sure that you have configured the 
logs directory.

- Original Message -
From: Evgenios Charalambus [EMAIL PROTECTED]
Date: Tue, 16 Mar 2004 04:26:17 -0800 (PST)
To: Discussion Universe [EMAIL PROTECTED]
Subject: Unable to read LOGS.DIR entry from D_UV_LOGS.

 After installing universe 9.5.1 and run the command:
   bin/uv -admin -stop
  
 I got the following errors:
   Unable to read LOGS.DIR entry from D_UV_LOGS.
   Unable to open uvdrlogd Daemon info file.
   Unable to locate UVDR log directory.
 
 I tried again start and stop but the error remains.
 
 
 
 Do you Yahoo!?
 Yahoo! Mail - More reliable, more storage, less spam
 -- 
 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: EVAL

2004-03-12 Thread Ray Wurlod
The result of every EVAL is (deemed to be) a string.
Try using both FMT and CONV field qualifiers.  FMT for the right justification and 
CONV to try to convince the query engine that it's dealing with numbers - either the 
MD or the MR conversion should do it.
LIST file EVAL expression CONV MD0 FMT 10R
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: Parsing Pathname from Object Code

2004-03-11 Thread Ray Wurlod
Yes, it will.

Were you rolling your own, you would need to know that the address of the source code 
pathname is in the object record header.  Usually it's right at the end, but this is 
not the case if you've used $COPYRIGHT or $* directives, as the text for these follows 
the pathname of the source code.

And it's different again if the code was compiled with the -I option.
SRS.UV.HEADER knows about these things.
- Original Message -
From: [EMAIL PROTECTED] (Vance Dailey)
Date: Thu, 11 Mar 2004 14:09:45 -0500
To: 'U2 Users Discussion List' [EMAIL PROTECTED]
Subject: RE: Parsing Pathname from Object Code

 I may have posted too soon. With a little more searching I found Gyle
 Iversons SRS.UV.HEADER program. It looks like it will do the trick.
 Vance
 
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 Behalf Of Vance Dailey
 Sent: Thursday, March 11, 2004 1:55 PM
 To: U2-Users (E-mail)
 Subject: Parsing Pathname from Object Code
 
 
 I am attempting to parse out the original pathname of a cataloged program
 from the object code. I am looking for some guidance on how to interpret the
 symbol table at the end of the file. Prior to the Basic compiler release
 6.2.2 it appears that the pathname could be stripped off the very end of the
 file, but now two additional char(0)s have been added on to the and. One
 appears to be for the $copyright notice and the other is unknown to me. In
 addition programs compiled with the -T do not contain the information
 which can cause confusion if I simply extract printable chars from the end
 of the file back to the last char(255).
 
 Does anyone have documentation on the object code symbol/line number table?
 
 Thanks,
 Vance
 
 --
 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: Executing Basic Programs from UniObjects for Java

2004-03-11 Thread Ray Wurlod
Does the troublesome BASIC make any use of terminal driver capability, even perhaps 
the @ function to switch off the press any key prompt?  Any SET.TERM.TYPE, 
GET.TERM.TYPE, TTYCTL() calls or the like?  PRINT (or CRT or DISPLAY) statements?
UniObjects connections do not, of course, have any terminal capabilities.

- Original Message -
From: [EMAIL PROTECTED]
Date: Thu, 11 Mar 2004 14:12:55 -0500
To: [EMAIL PROTECTED]
Subject: Executing Basic Programs from UniObjects for Java

 I am trying to execute a basic program using the  UniSession and UniCommand
 classes.  I have done this with other basic programs that are on the
 Universe system without any problems.  For the one I am trying to use now I
 get back an error message from the response method that reads:
 
 TERMTYPE IS NOT SETUP FOR THIS USER PORT
 
 The only difference that I can see with this basic program vs the other
 basic programs that I have working with this method is that this one makes
 a call to a basic subroutine.
 
 My java code looks something like this:
 
  // session is the currently connected UniSession
  UniCommand unicom = session.command();
 // COSTEST is the basic program on the host machine
  unicom.setCommand(RUN COSTEST);
  unicom.exec();
  String resp = unicom.response();
 
 Upon execution, the value of resp =   TERMTYPE IS NOT SETUP FOR THIS USER
 PORT
 
 COSTEST is a cataloged basic program on the host system with this line in
 it:
   .
   CALL S0903(CO,FILE,PGM,SEL,INITS)
   .
 
 If I comment out this line the program runs OK but the data that it returns
 is not correct.  Any suggestions?
 
 Thanks,
 Jim
 
 
 -- 
 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: Converting UniVerse

2004-03-11 Thread Ray Wurlod
Because UniVerse runs in a virtual machine (the run machine) that is customized to 
each of the platforms on which it runs, you'd be pleasantly surprised at how little 
difference switching hardware makes.  I've certainly moved suites of programs, which 
ran without needing to be recompiled (the run machine itself detects byte order).
The only problems I would foresee would be
(a) 64-bit hashed files are (cannot be) supported on 32-bit platforms, so if you have 
any of these they will need to be converted to 32-bit, Distributed if too large
(b) pathnames, particularly embedded pathnames (of secondary indices
If you are using SQL capability, you should use FORMAT.CONV with its -export and 
-import capabilities.  This is the recommended/approved mechanism for moving SQL 
schemas.

- Original Message -
From: Pritchard, Hugh (CSED) [EMAIL PROTECTED]
Date: Thu, 11 Mar 2004 14:30:35 -0500
To: 'U2 Users Discussion List' [EMAIL PROTECTED]
Subject: RE: Converting UniVerse

 64-bit (say, an AlphaServer/Tru64 Unix platform)
 to 32-bit (say, a Wintel platform)???
 I think the question should be about a switch in operating systems--that's
 of more immediate significance to the application.
 There are other 64-bit architectures out there besides Alphas.  Put the OS
 of your choice on one of them.  I bet the change in OS will break more
 things in the application than the change in hardware word size.  Even a
 small change in OS (Tru64 Unix to some other flavor of Unix) will break some
 things.
 Alpha/Tru64 is owned by HP now; HP would probably love to talk to you about
 other HP platform solutions.
 
Hugh
 ___
Hugh Pritchard (Tier), 202-546-3066, cell 301-467-1712
D.C. Ofc of Corporation Counsel, Child Support Enforcement Division
650 Pennsylvania Ave SE, Suite 250, Washington, DC 20003
mailto:[EMAIL PROTECTED]
 
 | -Original Message-
 | From: [EMAIL PROTECTED] 
 | [mailto:[EMAIL PROTECTED]
 | Behalf Of Dale Young
 | Sent: Thursday, March 11, 2004 1:35 PM
 | To: [EMAIL PROTECTED]
 | Subject: Converting UniVerse
 | 
 | Has any one converted a 64bit machine to a 32bit machine and 
 | if so what kind of problems were encountered??
 |  
 | 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


Re: [UV] Date-Time stamping

2004-03-08 Thread Ray Wurlod
Are you sure it doesn't (press F5 to refresh the Explorer view?)
If you're talking about a dynamic hashed file, it's DATA.30 (and/or OVER.30) that 
would be updated, not their parent directory.

- Original Message -
From: Marco Manyevere [EMAIL PROTECTED]
Date: Mon, 8 Mar 2004 08:16:38 + (GMT)
To: [EMAIL PROTECTED]
Subject: [UV] Date-Time stamping

 Hi All,
  
 When does universe update the OS level date time stamp ? On Windows XP UV9.6, if I 
 make changes to a record (even create a new record) and commit it to disk, the date 
 and time shown under the 'Date Modified' column in Windows explorer does not change. 
 However, if I modify the same record using the ED command, the time stamp in 
 explorer changes immediately. On Unix I remember relying on sorting files by the 
 time stamp to determine which files were actively being updated by users and I used 
 to get reasonable results. What do I need to change to get the same behaviour on XP?
  
 Regards, Marco
 
   
 -
   Yahoo! Messenger - Communicate instantly...Ping your friends today! Download 
 Messenger Now
 -- 
 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] Change prompt?

2004-03-08 Thread Ray Wurlod
If it helps, I can assert with certainty that there is nothing in UniVerse that allows 
this.
It's easy enough to roll your own; a small BASIC program into which you trap your 
users.
LOOP
   CRT myprompt
   INPUT command
WHILE command  'QUIT'
   GOSUB processcommand
REPEAT
PERFORM QUIT
- Original Message -
From: Barry Brevik [EMAIL PROTECTED]
Date: Mon, 8 Mar 2004 11:42:22 -0800 
To: U2 list (E-mail) [EMAIL PROTECTED]
Subject: [UV] Change prompt?

 OK, I know about UVPROMPT, but it will only let you specify a single
 character.
 
 I work in numerous accounts, and it would be good if the LOGIN PA could
 change the prompt to have multiple characters so I can see which account I'm
 in. Believe me, all it takes is one mistake to leave a lasting impression.
 
 Anyone know of a way to use multiple chars for the prompt without writing my
 own shell?
 -- 
 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] multiplying totals

2004-03-05 Thread Ray Wurlod
You need the TOTAL function to keep the running totals, and the CALC keyword to use 
them in the formula.
CALC EVAL TOTAL(IF FIELDZ = X THEN COUNTER ELSE 0) * FIELD1 / TOTAL(1)
- Original Message -
From: Kevin Michaelsen [EMAIL PROTECTED]
Date: Fri, 05 Mar 2004 14:55:33 -0500
To: [EMAIL PROTECTED]
Subject: multiplying totals

 I need help on the syntax when multiplying with an EVAL statement. I've 
 tried simplify the statement. It goes something like this:
 AVERAGE FIELD1 * TOTAL EVAL IF(FIELDZ=X )THEN COUNTER ELSE 0
 
 I basically want the average of FIELD1 (MULTIPLIED) BY COUNTER
 
 Any help would be appreciated.
 
 kevin
 
 -- 
 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: UniVerse 10 :Network writes not allowed within a transacton.

2004-03-05 Thread Ray Wurlod
I believe you will find that this is one of the things documented as being prohibited 
while a transaction is active.

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


Re: [UV] Parameters

2004-03-02 Thread Ray Wurlod
The good news is that each UniVerse process will demand only as much memory as it 
needs, there's not much you can do to force it to use more.  You might, perhaps, 
double the small memory buffers like OPTMEM and TXMEM, but there's no guarantee that 
you'll use it; the amount used is a function of the complexity of the query or the 
size of transaction (respectively) in these cases.
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: [UV] Trigger FILE parameter

2004-03-01 Thread Ray Wurlod
Hmm, looks like the SICA is preserved.  You should tell IBM about this, and request a 
utility for dropping the SICA.  In the meantime, you could (using the information in 
the file header, and in FILEINFO.H), zero the pointer to the SICA before creating the 
trigger anew.  Not for the faint of heart; you can damage your file if you don't do it 
correctly. You need to write a four byte binary zero into the correct location (using 
WRITEBLK).

- Original Message -
From: gerry simpson [EMAIL PROTECTED]
Date: Mon, 1 Mar 2004 03:39:55 -0500
To: U2 Users Discussion List [EMAIL PROTECTED]
Subject: Re: [UV] Trigger FILE parameter

 Hi Ray ,
 
 this does not work. LIST.SICA always lists the file name as it was when the
 1st trigger was created even if the triggers are dropped and recreated.
 
 
 
 
 - Original Message - 
 From: Ray Wurlod [EMAIL PROTECTED]
 To: U2 Users Discussion List [EMAIL PROTECTED]
 Sent: Saturday, February 28, 2004 7:45 AM
 Subject: Re: [UV] Trigger FILE parameter
 
 
  The only way to modify the SICA after a CNAME is to drop the trigger and
 create it afresh.
 
  -- 
  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: [UV] Trigger FILE parameter

2004-02-28 Thread Ray Wurlod
The only way to modify the SICA after a CNAME is to drop the trigger and create it 
afresh.

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


RE: [UV] PORT.SATUS error message

2004-02-28 Thread Ray Wurlod
There are some known issues with what ANALYZE.SHM reports.  There was one truly 
infamous case where one of the reports got the byte order wrong in one of the number 
of waiters count! (Can't remember exact details.)

- Original Message -
From: Stuart Boydell [EMAIL PROTECTED]
Date: Fri, 27 Feb 2004 12:08:07 +1100
To: U2 Users Discussion List [EMAIL PROTECTED]
Subject: RE: [UV] PORT.SATUS error message

  Try using UNLOCK PSTATLOCK SEMAPHORE from TCL in the UV account. Perhaps
  smat -s shows a PORT.STATUS lock in a state of 1?
 
 Thanks for answers everyone. UNLOCK PSTATLOCK SEMAPHORE worked.
 The strange thing was that SEMAPHORE.STATUS/smat etc wasn't showing any
 locks against PORT.STATUS.
 
 Regards,
 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
 

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


Re: [UV] paragraph labels

2004-02-23 Thread Ray Wurlod
1. also documented means that it's in the UniVerse manuals, but I don't have access 
to them right now.

2. I did not refer to non-existant labels earlier in the paragraph.  Check my words 
again.

3. Try it and see!


- Original Message -
From: Mark Johnson [EMAIL PROTECTED]
Date: Sun, 22 Feb 2004 11:46:25 -0500
To: U2 Users Discussion List [EMAIL PROTECTED]
Subject: Re: [UV] paragraph labels

 What does the 'also documented' sentence mean. How would a non-existant
 label appear before the GO in a paragraph.
 
 Regarding paragraphs: Do they behave like procs whereby you can accidentally
 have the same label twice and the proc goes to the first occurrence
 (starting at the beginning). This is a downside of procs due to not needing
 to be compiled.
 
 my 1 cent.
 
 - Original Message -
 From: Ray Wurlod [EMAIL PROTECTED]
 To: U2 Users Discussion List [EMAIL PROTECTED]
 Sent: Sunday, February 22, 2004 5:03 AM
 Subject: RE: [UV] paragraph labels
 
 
  It's documented behaviour that GO to a label that does not exist in a
 paragraph will cause the process to exit from the paragraph.  From memory
 it's in the UniVerse System Description somewhere.  There's no default
 label.  It's also documented that the same behaviour will occur if you
 attempt to GO to a label that is earlier in the paragraph than the GO
 command.
  --
  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: [UV] paragraph labels

2004-02-22 Thread Ray Wurlod
It's documented behaviour that GO to a label that does not exist in a paragraph will 
cause the process to exit from the paragraph.  From memory it's in the UniVerse System 
Description somewhere.  There's no default label.  It's also documented that the 
same behaviour will occur if you attempt to GO to a label that is earlier in the 
paragraph than the GO command.
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: UV - NLS

2004-02-17 Thread Ray Wurlod
The shared segment key is 0xaceea000 for version 10.x for any x.

The xMEMOFF parameters are tuneable in DataStage, but not in UniVerse.

You may have to ask IBM support to escalate this to ATS (advanced technical support) 
where someone like Leroy (sometime participant here) will be able to look at it.
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: [UV] Enabling ODBC for non-SQL file

2004-02-16 Thread Ray Wurlod
HS_FILE_ACCESS may be edited manually.
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: Hashing Algorithm

2004-02-14 Thread Ray Wurlod
It might be interesting if someone were to publish the Ardent hashing algorithms, 
then. ;) 
Not something I'm prepared to risk doing, however.

- Original Message -
From: [EMAIL PROTECTED]
Date: Sat, 14 Feb 2004 10:45:45 EST
To: [EMAIL PROTECTED]
Subject: Re: Hashing Algorithm

 I have to say that in general IMHO a company cannot retroactively seize 
 control of something that at one time was freely available.  Something in the US 
 about seizure without a warrant?  Bill of rights or something?
 Will I'm not a lawyer, but I play one on the Internet Johnson

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


Re: Hashing Algorithm

2004-02-14 Thread Ray Wurlod
It's not one, it's all 19 of them (types 2 through 18 and two for type 30).
The Type 18 algorithm is closest to the Pick hashing algorithm.

- Original Message -
From: Mark Johnson [EMAIL PROTECTED]
Date: Sat, 14 Feb 2004 18:00:26 -0500
To: U2 Users Discussion List [EMAIL PROTECTED]
Subject: Re: Hashing Algorithm

 Is that one similiar to the 'only' one available to native systems, which
 many people have known for years?


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


RE: UV write fatal error

2004-02-13 Thread Ray Wurlod
Permissions?  All the preceding steps (Open, BSCAN) can be done without write 
permission. Write, needless to add, cannot.

 -Original Message-
 From: Jimi DeRouen [mailto:[EMAIL PROTECTED]
 
 I am attempting to write a record to a type 25 file and apparently
 getting a fatal error. The platform is UV 9.5.1.1b Pick flavor on W2K
 SP4. I have constructed the WRITE statement to include all possible (I
 think) branching, yet the program goes to the command prompt when the
 WRITE is executed without following any of the branches. The WRITE
 statement is as follows:
  
 [SNIP]

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


Re: [UV] escaping temp in dos diectory

2004-02-03 Thread Ray Wurlod
TEMP can't be guaranteed to exist.  It's created if, during an upgrade, items are 
found in VOC that are different in type to the replacement that's to be installed in 
VOC as part of the upgrade.  If an account has never been upgraded, there won't be a 
TEMP file.  You'd be better off choosing SAVEDLISTS, which does always exist, but 
which doesn't help you get over your escaping problem.

You *should* be able to use double quotes around the pathname.  For example:
execute 'dos /c cscript temp/myscript.vbs' capturing cap

But this has two pieces of grief.

One is that the entire command must also be quoted (for the DOS /C command) if the 
command contains white space.  For example:
execute 'dos /C cscript temp/myscript.vbs' capturing cap
You can probably fiddle around with the third quote character, for example:
execute \dos /C 'cscript temp/myscript.vbs'\ capturing cap

The other is that EXECUTE - under what circumstances I can't quite remember - has a 
tendency to strip a level of quotes.

Anyway, try some of those variations.  If that doesn't work, create a Type 19 file as 
part of the command.  For example:

execute 'DOS /C mkdir mytmp; cscript mytmp/myscript.vbs' capturing cap

or even

execute 'DOS /C mkdir mytmp; cscript mytmp/myscript.vbs; del /S mytmp' capturing cap



- Original Message -
From: Stuart Boydell [EMAIL PROTECTED]
Date: Tue, 3 Feb 2004 15:25:33 +1100
To: U2-Users [EMAIL PROTECTED]
Subject: escaping temp in dos diectory

 Just a quick curly one, UV 10 Windows.
 
 I need to run a script in a temp directory because that's the only one
 that is generally going to be a type 1/19 in any given account.
 
 The ampersands are causing me grief, does anyone know how to escape them? If
 it's not possible, I'll just write it to a path but I would prefer it to be
 there for houskeeping.
 
 execute 'dos /c cscript temp/myscript.vbs' capturing cap
 
 Regards,
 Stuart Boydell
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 **
 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
 

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


Re: [UV] ANALYZE.OBJECT

2004-01-27 Thread Ray Wurlod
The information from $COPYRIGHT is right at the end, except that if there are any $* 
directives, those comments are also in the object code, and follow the $COPYRIGHT 
notice.

- Original Message -
From: Ray Daignault [EMAIL PROTECTED]
Date: Mon, 26 Jan 2004 10:15:32 -0800
To: U2 Users Discussion List [EMAIL PROTECTED]
Subject: Re: [UV] ANALYZE.OBJECT

 Try using VList on the program.  I'm sure copyright info is displayed even
 if source code is not available.
 
 Ray D
 - Original Message - 
 From: [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Monday, January 26, 2004 9:21 AM
 Subject: [UV] ANALYZE.OBJECT
 
 
  In the good old days of Prime INFORMATION, there existed an ANALYZE.OBJECT
  command.
 
  snippet book=programming with info/basic
  The object code header is displayed using the ANALYZE.OBJECT command.
  /snippet
 
  I cannot find such a command in UniVerse 10.x (for Windows).
 
  Specifically, does anyone know how to view text inserted into object code
  by the $COPYRIGHT compiler directive (assuming that ANALYZE.OBJECT no
  longer exists)?
 
  Thanks,
  John Appleyard.
 
 
 
  ___
  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