Re: [U2] Resize Question

2010-02-05 Thread Anthony W. Youngman
In message 000501caa516$38b303c0$aa190b...@com, Andrew E. Tegenkamp and...@g3.com 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

Re: [U2] U2UG Elections

2010-02-05 Thread 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:

Re: [U2] U2UG Elections

2010-02-05 Thread 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

Re: [U2] U2UG Elections

2010-02-05 Thread 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

Re: [U2] Resize Question

2010-02-05 Thread 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

Re: [U2] Resize Question

2010-02-05 Thread 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

[U2] extraction conversion codes

2010-02-05 Thread 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

Re: [U2] extraction conversion codes

2010-02-05 Thread 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

Re: [U2] Resize Question

2010-02-05 Thread 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

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

2010-02-05 Thread 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