[U2] [UV] ICONV, OCONV --> STATUS() = 3 = "Successful conversion of possibly invalid data"

[Charles Stevenson]

For ICONV & OCONV the UV documentation says:

   The STATUS function reflects the result of the conversion:
   Value Description
   0 The conversion is successful.
   1 An invalid string is passed to the OCONV function;
 the original string is returned as the value of the conversion.
 If the invalid string is the null value, null is returned.
   2 The conversion code is invalid.
   3 Successful conversion of possibly invalid data.

0,1,2 ok.
But:
  "3 Successful conversion of possibly invalid data."  ? ! ?

What's THAT?
An example, anyone?

tia,
cds

P.S. We're talking STATUS() *function*, not *statement*.  There's a 
STATUS statement, but that's an entirely different animal.


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Resize Question

[Charles Stevenson]

Before you go too far down that path, make sure your sorting & selecting 
works like you want.
Are you more familiar with Pick-style A- & S-items?  If so, you realize 
how, if  you put a correlative or a conversion into the wrong spot, your 
sorts and selection criteria are goofy.  The same will happen by doing 
as a conversion what ought to be an I-descriuptor.  Or vice versa.


Like Martin, I'm curious to understand your dislike of I-descriptors.
Regards,
Chuck

On 2/5/2010 1:46 PM, u2ug wrote:

We have a process that works strictly with I&  D type dictionary items.
The fewer I-types we have the better.

One scenario where we can drop I-types in favour of D-Types is :

DATA.VALUE
D multi part '*' delimited : date / time
2
...

DATA.VALUE.DATE
I
DATA.VALUE["*",1,1]
D4-YMD
...

DATE.VALUE.TIME
I
DATA.VALUE["*",2,1]
MTS
...

This can be cooked down to :

DATA.DATE
D
2
G0*1|D4-YMD
...

DATA.TIME
D
2
G1*1|MTS
...


This works perfectly as long as the delimiter is not a system delimiter
( FM , VM , SVM , TM )
If we have :

DATA.VALUE
D multi value @VM delimited : date / time
2
...

DATA.VALUE.DATE
I
DATA.VALUE<1,1>
D4-YMD
...

DATE.VALUE.TIME
I
DATA.VALUE<1,2>
MTS
...

I don't see any way to drop the I-types because I don't see any
conversion codes that cam extract using system delimiters.

Am I missing something or are we just stuck with the I-types in these
cases ?

Gerry

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

   


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] extraction conversion codes

[Martin Phillips]

Hi Gerry,

Out of curiosity, why are you against I-types?


Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
+44-(0)1604-709200
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] extraction conversion codes

[u2ug]

Sorry - I forgot to change the subject - didn't mean to hijack the other
thread.


We have a process that works strictly with I & D type dictionary items.
The fewer I-types we have the better.

One scenario where we can drop I-types in favour of D-Types is :

DATA.VALUE
D multi part '*' delimited : date / time
2
...

DATA.VALUE.DATE
I
DATA.VALUE["*",1,1]
D4-YMD
...

DATE.VALUE.TIME
I
DATA.VALUE["*",2,1]
MTS
...

This can be cooked down to :

DATA.DATE
D
2
G0*1|D4-YMD
...

DATA.TIME
D
2
G1*1|MTS
...


This works perfectly as long as the delimiter is not a system delimiter
( FM , VM , SVM , TM )
If we have :

DATA.VALUE
D multi value @VM delimited : date / time
2
...

DATA.VALUE.DATE
I
DATA.VALUE<1,1>
D4-YMD
...

DATE.VALUE.TIME
I
DATA.VALUE<1,2>
MTS
...

I don't see any way to drop the I-types because I don't see any
conversion codes that cam extract using system delimiters.

Am I missing something or are we just stuck with the I-types in these
cases ?

Gerry

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Resize Question

[u2ug]

We have a process that works strictly with I & D type dictionary items.
The fewer I-types we have the better.

One scenario where we can drop I-types in favour of D-Types is :

DATA.VALUE
D multi part '*' delimited : date / time
2
...

DATA.VALUE.DATE
I
DATA.VALUE["*",1,1]
D4-YMD
...

DATE.VALUE.TIME
I
DATA.VALUE["*",2,1]
MTS
...

This can be cooked down to :

DATA.DATE
D
2
G0*1|D4-YMD
...

DATA.TIME
D
2
G1*1|MTS
...


This works perfectly as long as the delimiter is not a system delimiter
( FM , VM , SVM , TM )
If we have :

DATA.VALUE
D multi value @VM delimited : date / time
2
...

DATA.VALUE.DATE
I
DATA.VALUE<1,1>
D4-YMD
...

DATE.VALUE.TIME
I
DATA.VALUE<1,2>
MTS
...

I don't see any way to drop the I-types because I don't see any
conversion codes that cam extract using system delimiters.

Am I missing something or are we just stuck with the I-types in these
cases ?

Gerry

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Resize Question

[jpb-u2ug]

If you are starting out with trying to use SQL on a legacy database your
best bet would be to create a separate account just for SQL. In the new
account put in pointers to the main data files you will be using and create
dictionaries to the files locally. In this way you can build the
dictionaries to be SQL compliant and only have the fields that you will be
using for your SQL apps. It's a little more work to set up but will save
loads of time later. If you have files with the same data (current and
history files) you can use the same dictionaries so that can cut down on the
number of dictionaries used.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Wednesday, February 03, 2010 2:57 AM
To: 'U2 Users List'
Subject: Re: [U2] Resize Question

Hi Andrew

Because UniVerse dictionaries contain not only solid column definitions, but
also synonyms and virtual fields, you have to choose which of these will be
exposed for ODBC or similar relational protocols. A typical dictionary for a
mature system might have a thousand entries which makes navigating these in
something like MS query or the .NET data set designer very difficult!

So for this you need to do two things:

First, create a phrase named @SELECT. This is a dictionary entry in the
format:

Key: @SELECT
1: PH
2: list of fields SPACE delimited.

You can test this out by doing a SELECT * from file at TCL, which uses the
same phrase.

Then, you need to update the file information cache used by ODBC (prevents
it having to scan every dictionary on connect). For this, run the
HS.UPDATE.FILEINFO command after making your changes.

However, you might also want to step back and consider whether ODBC is
really your best choice. To use ODBC effectively you need to understand
about dynamic normalizing and the differences between the UniVerse data
model and the relational model expected by ODBC. Depending on what you wish
to do, ODBC may tie you up in knots and you may be better off looking at one
of the native protocols (the UniObjects family) or web services instead.

Also, I don't know why you chose to copy your VOC across. That will contain
pointers to all the files from the original system, which you don't have on
yours,  hence the large number of errors you are seeing. If you are brave,
you can try a CLEAN.ACCOUNT command, but take a backup first!

[AD]
You might want to consider my latest book, 'IBM UniVerse Client Developer'
(written when this was still an IBM product) which covers the various
protocols in depth. You can find details on my website,
www.brianleach.co.uk.
[/AD]

Regards

Brian 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Andrew E.
Tegenkamp
Sent: 02 February 2010 4:17 PM
To: 'U2 Users List'
Subject: Re: [U2] Resize Question

Thank you very much! That has helped a lot and I can now see the data in the
UV command line :)

If possible, I am now hoping to be able to expose this imported data to ODBC
so I can work with it in PHP, etc. But I am again finding problems I cannot
find an answer for in the help docs or searching the list archive.

First, I created a PICK account using the U2UG guide mentioned. I then used
HS.ADMIN option 3 to "Activate access to files in an account" which went
well and showed it as an activated account.  

I copied over the TEMP and VOC (D_VOC, D_VOCLIB, VOC, VOCLIB, etc) files
from the live UniVerse server to my account as well as my test table ZIP
(ZIP and D_ZIP). I fnuxi'd and SET.INDEX'd them and could see the data on
the command line using SELECT COUNT(*) FROM ZIP and the like.

However, when I went to ODBC I could only see 3 tables. AE_DOC, HELP_FILE,
and HS_FILE_ACCESS (ODBC reported no rows in HS_FILE_ACCESS). I ran HS.ADMIN
option 3 again on the account and for most things it said:

Could not open file FILENAME.  STATUS() = -2
  "FILENAME" was not written into File Information Cache.

For the file I copied over, ZIP, it said: 

ZIP's dictionary has no @ phrase or @SELECT phrase.
  "ZIP" was written into File Information Cache but
  may not behave as desired.

This is a little confusing as I thought D_ZIP was the dictionary file and
SELECT works on the command line. After this, I checked ODBC and saw the 3
above and one more table called UVMD. I am not sure what this was so I got
it but it appears to be a system table of some sort.


Thanks again for any tips on how to properly setup/expose this file/table to
ODBC!
Andrew





-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Monday, February 01, 2010 11:55 AM
To: 'U2 Users List'
Subject: Re: [U2] Resize Question

Okay, a few things here...

First the index issue. When UniVerse creates an index on a file, it puts the
absolute pathname t

Re: [U2] U2UG Elections

[Symeon Breen]

Thanks Brian , i am working now - the other login can prob be deleted 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: 05 February 2010 12:31
To: 'U2 Users List'
Subject: Re: [U2] U2UG Elections

Hi Symeon

I notice you have two separate logins to the website, and one of them has
not been activated.
I've now activated that, so you should be able to see the elections page.
If not, drop me an email offlist and I'll sort it.

Brian 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: 04 February 2010 8:15 PM
To: lbc7...@gmail.com; 'U2 Users List'
Subject: Re: [U2] U2UG Elections

I have the same i cannot see a link on the home page, I am logged in -
u2ug.org ?




-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lloyd Cottrell
Sent: 04 February 2010 18:02
To: U2 Users List
Subject: Re: [U2] U2UG Elections

nvr mind, I logged out and back in and found it.

On Thu, Feb 4, 2010 at 10:28 AM, Lloyd Cottrell  wrote:
> I might be blind, but can you give a link to do the voting?
>
> On Wed, Feb 3, 2010 at 2:02 AM, Brian Leach 
wrote:
>> Calling all U2UG Members
>>
>> This is a reminder that voting has opened for the election of the new
U2UG
>> Board for 2010 - 2011.
>>
>> The board is composed of busy individuals who have volunteered their 
>> time
to
>> represent you, the U2 community.
>>
>> This year, following the transition to Rocket, the user groups plans 
>> to
be
>> even more active than ever.
>>
>> In order to secure a strong mandate, we need as many members as 
>> possible
to
>> vote.
>>
>> Please take a few moments to visit the elections page on the website 
>> and cast your vote. We have a strong slate of candidates once again, 
>> and they deserve your support.
>>
>> Voting will close on 10 Feb 2010. You can cast your vote more than 
>> once, however only the last vote cast will count.
>>
>> Votes can be cast through the website or by sending an email to:
>>
>> electi...@mvopen.org
>>
>> quoting your U2UG login name.
>>
>> The election page can be found under the Membership menu once you 
>> have logged into the site.
>>
>> Thank you.
>>
>> Brian
>>
>> On behalf of the U2 User Group Board.
>>
>> PS: If you are a member of the U2UG but have not received a previous
email
>> about voting, please check the email address in your member profile 
>> and
make
>> sure that it does not require verification.
>>
>>
>> ___
>> U2-Users mailing list
>> U2-Users@listserver.u2ug.org
>> http://listserver.u2ug.org/mailman/listinfo/u2-users
>>
>
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.733 / Virus Database: 271.1.1/2667 - Release Date: 02/04/10
07:35:00

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] U2UG Elections

[Brian Leach]

Dave

No. The u2ug is a redirect from the old u2ug site, the one we first set up
when we started the group off. Mvopen.org is the real address for this
server, but both should take you to the same place. We tried to switch the
u2ug address a little while back, but it stuffed up these lists (which are
hosted yet somewhere else) so we've been wary of trying that again .. It is
on the agenda for the new board to sort out though :)

Brian 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Taylor
Sent: 04 February 2010 10:29 PM
To: U2 Users List
Subject: Re: [U2] U2UG Elections

It almost sounds like the same url is connected to a different opening page
between the US and the UK.

Dave Taylor
Sysmark Information Systems, Inc.
49 Aspen Way
Rolling Hills Estates, CA 90274
(O) 800-SYSMARK (800-797-6275)
(F) 310-377-3550
(C) 310-561-5200
www.sysmarkinfo.com
- Original Message -
From: "Symeon Breen" 
To: "'U2 Users List'" 
Sent: Thursday, February 04, 2010 1:51 PM
Subject: Re: [U2] U2UG Elections


U2ug.org, but changed the url to mvopen.org and it is no different.


Under Membership i have 4 options Register, Join email List, U"UG charter,
U2UG Newsletter   - it is kind of like i have not logged in but at the top
of the left column it says you are logged in as Symeon Breen.


?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Robinson
Sent: 04 February 2010 21:36
To: U2 Users List
Subject: Re: [U2] U2UG Elections

Are you logging into mvopen.org?

Cheers, Don Robinson






From: Symeon Breen 
To: U2 Users List 
Sent: Thu, February 4, 2010 4:24:07 PM
Subject: Re: [U2] U2UG Elections

Sorry it is deffo not there !



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood
Sent: 04 February 2010 20:20
To: U2 Users List
Subject: Re: [U2] U2UG Elections

I voted yesterday - after you Log in, under "Membership" (left side)
you'll see a link for 'U2UG Elections', click it, then go to bottom of
page.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Thursday, February 04, 2010 1:15 PM
To: lbc7...@gmail.com; 'U2 Users List'
Subject: Re: [U2] U2UG Elections

I have the same i cannot see a link on the home page, I am logged in -
u2ug.org ?




-Original Message-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 9.0.733 / Virus Database: 271.1.1/2667 - Release Date: 02/04/10
07:35:00

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] U2UG Elections

[Brian Leach]

Hi Symeon

I notice you have two separate logins to the website, and one of them has
not been activated.
I've now activated that, so you should be able to see the elections page.
If not, drop me an email offlist and I'll sort it.

Brian 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: 04 February 2010 8:15 PM
To: lbc7...@gmail.com; 'U2 Users List'
Subject: Re: [U2] U2UG Elections

I have the same i cannot see a link on the home page, I am logged in -
u2ug.org ?




-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lloyd Cottrell
Sent: 04 February 2010 18:02
To: U2 Users List
Subject: Re: [U2] U2UG Elections

nvr mind, I logged out and back in and found it.

On Thu, Feb 4, 2010 at 10:28 AM, Lloyd Cottrell  wrote:
> I might be blind, but can you give a link to do the voting?
>
> On Wed, Feb 3, 2010 at 2:02 AM, Brian Leach 
wrote:
>> Calling all U2UG Members
>>
>> This is a reminder that voting has opened for the election of the new
U2UG
>> Board for 2010 - 2011.
>>
>> The board is composed of busy individuals who have volunteered their 
>> time
to
>> represent you, the U2 community.
>>
>> This year, following the transition to Rocket, the user groups plans 
>> to
be
>> even more active than ever.
>>
>> In order to secure a strong mandate, we need as many members as 
>> possible
to
>> vote.
>>
>> Please take a few moments to visit the elections page on the website 
>> and cast your vote. We have a strong slate of candidates once again, 
>> and they deserve your support.
>>
>> Voting will close on 10 Feb 2010. You can cast your vote more than 
>> once, however only the last vote cast will count.
>>
>> Votes can be cast through the website or by sending an email to:
>>
>> electi...@mvopen.org
>>
>> quoting your U2UG login name.
>>
>> The election page can be found under the Membership menu once you 
>> have logged into the site.
>>
>> Thank you.
>>
>> Brian
>>
>> On behalf of the U2 User Group Board.
>>
>> PS: If you are a member of the U2UG but have not received a previous
email
>> about voting, please check the email address in your member profile 
>> and
make
>> sure that it does not require verification.
>>
>>
>> ___
>> U2-Users mailing list
>> U2-Users@listserver.u2ug.org
>> http://listserver.u2ug.org/mailman/listinfo/u2-users
>>
>
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.733 / Virus Database: 271.1.1/2667 - Release Date: 02/04/10
07:35:00

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Resize Question

[Anthony W. Youngman]

In message <000501caa516$38b303c0$aa190b...@com>, Andrew E. Tegenkamp 
 writes

Thanks again for taking the time to help me out. I have been researching
this all day as I did not want to bother the list anymore. I am still
looking up and reading commands to try to find the right commands to issue
to complete these tasks and I appreciate the time it takes to help me find
the right road to take.


There's an article on PickWiki about ODBC (written by yours truly :-)

Go into the Universe page and it should be visible from there iirc. It 
was written for 9.6 so things have changed a bit but it might have some 
useful information. In particular, it contains links to some programs 
that will go through your files looking for known "gotchas" with the 
data.


Oh - and ODBC now sits on top of OleDB, so you're better off using that 
if you can.


Cheers,
Wol
--
Anthony W. Youngman 
'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man
lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
Visit the MaVerick web-site -  Open Source Pick
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users