RE: [U2] question..

2008-01-31 Thread Manu Fernandes
Re, LOGTO UV WHO{enter} :to see what is your domain\userid REVISE UV.ACCESS{enter} Function=UVBACKUP{enter} S2{enter} Type the number of line witout userid 4? {enter} Users=DomainNAME\CHRIS {enter} !! respect the CASE (check value with WHO ) {enter} {enter} {enter} back to TCL > manu > -

Re: [U2] question..

2008-01-31 Thread Ray Wurlod
INSERT INTO UV.ACCESS_USERS (@ID, USERS) VALUES ('UVRESTORE', 'CHRIS'); > - Original Message - > From: "LuckY07" <[EMAIL PROTECTED]> > To: u2-users@listserver.u2ug.org > Subject: [U2] question.. > Date: Thu, 31 Jan 2008 06:56:23 -0800 (PST) > > > Manu, > > I appreciate the quick respons

Re: [U2] question(s)

2008-02-06 Thread john reid
1. we use ANALYZE.FILE .. it gives the scoop on anything not a directory and a little bit on dynamic files. 2. That's an indication of some type of memory leak or stack overflow I think. I'm pretty sure its an abnormal condition. You could probably duplicate it in a sub calling itself until it g

Re: [U2] question(s)

2008-02-06 Thread john reid
For number one, you could also open the file in BASIC and do a VAR=FILEINFO(,#) where number is any number between 1 and about 15. File type is returned with a var of 4 in our system. On 2/6/08, john reid <[EMAIL PROTECTED]> wrote: > 1. we use ANALYZE.FILE .. it gives the scoop on anything > no

RE: [U2] question(s)

2008-02-06 Thread Jeff Fitzgerald
1. Any of the UniVerse file utilities should tell you type; FILE.STAT, GROUP.STAT, HASH.HELP, etc. Or LISTFL has a TYPE column and is quick. 3. SELECT FILE SAMPLE 500 SAMPLED 1200 will select 500 records from the file, picking every 1200th record. Not truly random, but probably close enou

RE: [U2] question(s)

2008-02-06 Thread Brian Leach
Doug > 1.In universe how can I tell what type of pick file I am looking > at (type 2,3,4,5,6, etc ) PROGRAM FILEINFO Get(Arg.) FileName Else Crt 'File : ':; Input FileName If FileName = '' Then STOP End Open FileName To FL Else Crt 'Cannot open ':FileName STOP End Status FStat

RE: [U2] question(s)

2008-02-06 Thread Anthony Youngman
EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of john reid Sent: 06 February 2008 15:23 To: u2-users@listserver.u2ug.org Subject: Re: [U2] question(s) 1. we use ANALYZE.FILE .. it gives the scoop on anything not a directory and a little bit on dynamic files. 2. That's an indication of

Re: [U2] question(s)

2008-02-06 Thread Jeffrey Butera
> The one problem with SAMPLE and SAMPLED is that, afaik, they are > pseudo-random. Unless your file is volatile, you are likely to get > approximately the same result set every time (or exactly the same result > set, if your file hasn't changed). Correct - when we want psuedo-random, we create a

RE: [U2] question(s)

2008-02-06 Thread Doug Chanco
Thanks a million everyone! Great answers/suggestions/thoughts! dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] question(s)

2008-02-10 Thread Ray Wurlod
Printer memory segment removed occurs when you attempt to attach to a printer shared memory segment that was formerly owned by a now logged-out process but insufficient time has gone by for it to be cleaned up. It's an alert, and may be safely ignored. --- u2-users mailing list u2-users@lis

Re: [U2] Question about umask

2010-05-20 Thread Dan Goble
When it comes to setting up umasks on a system I prefer to set the default in the /etc/profile so that all who login in get this as default. Then anybody else who needs a different umask set in their /home/username/.profile -Dan -Original Message- From: u2-users-boun...@listserver.u2ug

Re: [U2] Question about umask

2010-05-20 Thread Bill Haskett
Augusto: Can't say for sure about UniVerse, but in UniData a UO connection runs the globally cataloged program "UOLOGIN", not the "LOGIN" paragraph. 1) I'm not sure if that's the way UniVerse operates, 2) When you say an RPC connection I'm not sure you mean UniObjects, which connects via th

Re: [U2] Question about umask

2010-05-20 Thread Charles_Shaffer
>>and it works from telnet connections. >>But if I do a EXECUTE "CREATE.FILE x" from inside a RPC connection, the >>permissions of the new file are "-rw-r--r--". The EXECUTE spawns a shell that might be owned by another user like system, I'm not sure about that. Whoever owns the shell is w

Re: [U2] Question about umask

2010-05-20 Thread Gregor Scott
We had the same problem. We had to change all our RPC connection logic so the first thing it does is to run a function (a "logon" program for UVCS connections) equivalent to the UV.LOGIN so we could trigger the execution of the UMASK for the duration of the RPC connection to UV. This works well for

Re: [U2] Question about umask

2010-05-20 Thread Augusto Alonso
Hi Gregor. How do you make the call to this routine? Is it made on the server (a PAragraph or something), or is it made by the client? Thanks -- Augusto Alonso 2010/5/21 Gregor Scott > We had the same problem. > We had to change all our RPC connection logic so the first thing it does is > to ru

Re: [U2] Question about umask

2010-05-20 Thread Gregor Scott
point of considering changing UV to use a non-root user as the UV administrator user and then changing this user's unix profile. Regards, Gregor From: Augusto Alonso [mailto:aalo...@quiter.com] Sent: Friday, 21 May 2010 10:21 AM To: gregor.sc...@pentanasolutions.com; U2 Users Li

Re: [U2] Question about indexing

2009-04-02 Thread Mecki Foerthmann
Hi Mark, Doing selects in a loop is never a good idea especially on large files and definitely not a sorted one like you are trying to do. But if you really have no other option, then you should at least create an index on ItmID on TABLE2. I don't know about Universe, but don't you have to do B

RE: [U2] Question About Indexing

2009-04-02 Thread Brutzman, Bill
While I am not entirely clear on the top-down business-logic requirements-analysis thing...I presume that we want to subtract Table2 from Table1. Perhaps the following is helpful. The index and the record contents are created at the same time as Table3 is generated. Open Table1 to F.Table1 els

RE: [U2] Question About Indexing

2009-04-02 Thread Mark Smith
Quoting "Brutzman, Bill" : Thanks Bill & Mecki for your quick response First, Mecki thats for your suggestion about not using for/next look on my cicle. And about BUILD.INDEX, yes... I did run BUILD.INDEX i just typed wrong the command that I used, on my email..:). About the files/t

Re: [U2] Question About Indexing

2009-04-02 Thread Mecki Foerthmann
Mark, READNEXT works on any multi-attributed array not just on active select lists. Look up the FROM option or the SELECT command in the Unibasic manual. And of course instead of reading from the &SAVEDLISTS& file you might rather want to execute 'get-list listname' I gathered that the produ

Re: [U2] Question about Triggers

2004-11-01 Thread Clifton Oliver
I haven't tried this, but as an idea how about creating a synonym F pointer under a non-restricted name? -- Regards, Clif Jay Falck wrote: I have a need to put a trigger on a couple of Universe files that have names that are causing a problem. I'd like to know if there is a good work around. The

RE: [U2] Question about Triggers

2004-11-02 Thread Brian Leach
Jay, The following works for me: CREATE TRIGGER STUPID_TRIGGER BEFORE INSERT OR UPDATE OR DELETE ON "STUPID-FILE" FOR EACH ROW CALLING '*STUPID.TRIGGER'; Adding trigger "STUPID_TRIGGER" >ED STUPID-FILE TEMP New record. : i 0001= HELLO 0002= Bottom at line 1. : fi Message from trigger STU

RE: [U2] Question about Triggers

2004-11-02 Thread Jay Falck
PROTECTED] On Behalf Of Brian Leach Sent: Tuesday, November 02, 2004 7:50 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Question about Triggers Jay, The following works for me: CREATE TRIGGER STUPID_TRIGGER BEFORE INSERT OR UPDATE OR DELETE ON "STUPID-FILE" FOR EACH ROW CALLING '*STUPID.T

Re: [U2] Question about UniVerse indexes...

2011-11-18 Thread Mark Eastwood
I believe LIST.INDEX is just a basic program in the BP file (uv account) - you may find some info there. Mark -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Friday, November 18, 2011 3:11 PM To

Re: [U2] Question about UniVerse indexes...

2011-11-18 Thread Tom Whitmore
@listserver.u2ug.org Subject: Re: [U2] Question about UniVerse indexes... I believe LIST.INDEX is just a basic program in the BP file (uv account) - you may find some info there. Mark -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On

Re: [U2] Question on Dictionary Items

2010-05-24 Thread Brian Leach
Jim >First value (a number of ways but this will work): > 002 9 > 008 F;9R No, this means 'repeat the value in field 9 for the depth of the expression' e.g. if you wanted to multiply each value in a multivalued field with a single valued field to get a multivalued result. >Last value: > 002 9

Re: [U2] Question on Dictionary Items

2010-05-24 Thread Bill Haskett
Brian: This is an old Pick trick. The 1st correlative always returns the first value. The 2nd correlative always returns the last. When I converted from D3 to UniData I changed these kinds of things to: First value: 002 EXTRACT ( ACCTS, 1, 1, 0 ) Last value: 002 EXTRACT ( ACCTS, 1, 0, 0 )

Re: [U2] Question on Dictionary Items

2010-05-24 Thread Tony Gravagno
> From: Brian Leach > Jim wrote: > >Last value: > > 002 9 > > 008 F;9;P;S;_ > > Not sure what you're trying to achieve here. It's equivalent > to @RECORD<9> - SUM(@RECORD<9>).. > > Or am I missing something? Explained: nospamNebula-RnD.com/blog/tech/mv/2010/05/lastmv.html Tony Gravagno Nebula

Re: [U2] Question on File indexing...

2005-03-09 Thread Allen Egerton
From: "George Gallen" <[EMAIL PROTECTED]> Sent: Wednesday, March 09, 2005 11:39 AM Subject: [U2] Question on File indexing... > I need to setup some file indexing, I've not used the internal B tree > indexes before, and I don't >have my manuals with me today. > > What do I need to do to setu

Re: [U2] Question on File indexing...

2005-03-09 Thread Roger Glenfield
George CREATE.INDEX FILE STATE NO.NULLS CREATE.INDEX FILE ZIP NO.NULLS And when no one needs to update the file BUILD.INDEX FILE STATE and from another terminal BUILD.INDEX FILE ZIP or from just one terminal BUILD.INDEX FILE ALL Which will generate a phantom for the other indexes. Updating may resu

RE: [U2] Question on File indexing...

2005-03-09 Thread George Gallen
Of Allen Egerton >Sent: Wednesday, March 09, 2005 12:26 PM >To: u2-users@listserver.u2ug.org >Subject: Re: [U2] Question on File indexing... > > >From: "George Gallen" <[EMAIL PROTECTED]> >Sent: Wednesday, March 09, 2005 11:39 AM >Subject: [U2] Question on

RE: [U2] Question about windows xp

2008-03-17 Thread Brian Leach
Hi Cisar Yes it is. Just remember that XP is a workstation O/S so it only allows a maximum of 10 connections. Brian Hello It is possible install universe in windows xp? Thanks. Cisar Riba Spain No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 26

RE: [U2] Question about windows xp

2008-03-17 Thread Tim Stokes
yes -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cisar Riba Cervera Sent: Monday, March 17, 2008 12:39 PM To: u2-users@listserver.u2ug.org Subject: [U2] Question about windows xp Hello It is possible install universe in windows xp? Thanks. Cisa

RE: [U2] Question about windows xp

2008-03-18 Thread César Riba Cervera
-- > De: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] nombre de Brian Leach > Enviado el: lunes, 17 de marzo de 2008 18:33 > Para: u2-users@listserver.u2ug.org > Asunto: RE: [U2] Question about windows xp > > > Hi Cisar > > Yes it is. Just remember that XP is a wor

Re: [U2] Question about windows xp

2008-03-18 Thread Mecki Foerthmann
] nombre de Brian Leach Enviado el: lunes, 17 de marzo de 2008 18:33 Para: u2-users@listserver.u2ug.org Asunto: RE: [U2] Question about windows xp Hi Cisar Yes it is. Just remember that XP is a workstation O/S so it only allows a maximum of 10 connections. Brian Hello It is possible in

Re: [U2] Question about windows xp

2008-03-18 Thread Helen Chenoby
ust visit: www.brianleach.co.uk Helen - Original Message - From: "CC)sar Riba Cervera" <[EMAIL PROTECTED]> To: Sent: Tuesday, March 18, 2008 6:27 PM Subject: RE: [U2] Question about windows xp Hello Thanks for your answers. Well, I install universe in windows xp, but when I l

RE: [U2] Question about windows xp

2008-03-18 Thread César Riba Cervera
noby > Enviado el: martes, 18 de marzo de 2008 15:21 > Para: u2-users@listserver.u2ug.org > Asunto: Re: [U2] Question about windows xp > > > Hi Cisar > > > > I run Universe 10.2 PE in Wdows XP > > I created another user account on my PC with a password &g

Re: [U2] Question about windows xp

2008-03-18 Thread wagnersm
Helen Which version of WindowsXP? Thank you. Steve -Original Message- >From: Helen Chenoby <[EMAIL PROTECTED]> >Sent: Mar 18, 2008 10:21 AM >To: u2-users@listserver.u2ug.org >Subject: Re: [U2] Question about windows xp > >Hi Cisar > > > >I run Univer

RE: [U2] Question about windows xp

2008-03-18 Thread Eric Armstrong
- From: CC)sar Riba Cervera [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2008 12:28 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Question about windows xp Hello Thanks for your answers. Well, I install universe in windows xp, but when I like connect universe fail

Re: [U2] Question about windows xp

2008-03-18 Thread Helen Chenoby
Steve, I run Windows XP Professional version 5.1.2600 Helen - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Wednesday, March 19, 2008 2:38 AM Subject: Re: [U2] Question about windows xp Helen Which version of WindowsXP? Thank you. Steve -Original M

Re: [U2] Question about updating customer's systems...

2011-06-16 Thread Doug Averch
Hi Tom: We had a similar problem years ago trying to deliver our customers consistent releases that we could script. We tried Windows bat files and Unix shell scripts but each release was never quite right. Our staff would forget this file or this dictionary or just plain copy the wrong account

Re: [U2] Question about updating customer's systems...

2011-06-16 Thread Tom Whitmore
gotchas that others have come across. Tom -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch Sent: Thursday, June 16, 2011 12:19 PM To: U2 Users List Subject: Re: [U2] Question about updating customer'

Re: [U2] Question about updating customer's systems...

2011-06-16 Thread Kevin King
We typically recommend that customers have at minimum two accounts, a test account and a live account which are virtually identical and share nothing. This allows us to install to the test account and have them test the code and then we take the same ravel files and roll it up to their production

Re: [U2] Question about updating customer's systems...

2011-06-16 Thread Doug Averch
Hi Tom; 1) This is not a problem if you allow customers to do their on updates by allowing access to the base system or sending them it to them on a thumb drive, or allowing them to upload the base system via FTP, or some other mechanism. 2) This is always a problem that requires structure from th

Re: [U2] Question about updating customer's systems...

2011-06-16 Thread Dan McGrath
To: U2 Users List Subject: Re: [U2] Question about updating customer's systems... We typically recommend that customers have at minimum two accounts, a test account and a live account which are virtually identical and share nothing. This allows us to install to the test account and have them

Re: [U2] Question about updating customer's systems...

2011-06-16 Thread Wols Lists
On 16/06/11 17:18, Doug Averch wrote: > On some of our Client systems we open 3 connections and use all of those > connections to updating their site simultaneously. We do not have to do > linear installs anymore which cuts our installation time from several hours > per site to about 15 minutes de

Re: [U2] Question about updating customer's systems...

2011-06-16 Thread Kate Stanton
Use colours, so users know if they are in Live or Test (eg normal grey for live, yellow background for test). The users can happily copy live data to test, do any conversions, run things to make sure all OK. Before we did this, users would do some testing, then forget they were not in Live, and d

Re: [U2] Question about updating customer's systems...

2011-06-17 Thread Israel, John R.
: U2 Users List Subject: Re: [U2] Question about updating customer's systems... Use colours, so users know if they are in Live or Test (eg normal grey for live, yellow background for test). The users can happily copy live data to test, do any conversions, run things to make sure all OK. Befo

Re: [U2] Question about updating customer's systems...

2011-06-17 Thread Doug Averch
Hi Wol: We have 10/100 mb router and find no problems. Most of our clients have those or 1gb routers and find no problems. The reason to open more than one connection is not be linear on the updates and allow the staff to do something else than watch the update. Most of the time spent on instal

Re: [U2] Question about updating customer's systems...

2011-06-17 Thread Wols Lists
On 17/06/11 14:26, Doug Averch wrote: > Hi Wol: > > We have 10/100 mb router and find no problems. Most of our clients have > those or 1gb routers and find no problems. The reason to open more than one > connection is not be linear on the updates and allow the staff to do > something else than w

Re: [U2] Question about updating customer's systems...

2011-06-19 Thread Brian Leach
Tom Consider having a virtualized test system so that in the event of the install being rejected - unlikely I know - they can quickly revert to a stored image of how the test system was prior to update to ensure that the next attempt is a true clean point from the failed installation. That's much

Re: [U2] Question about updating customer's systems...

2011-07-08 Thread Tom Whitmore
Hi, Thanks you to everyone that responded. We had identified the items people suggested, and some addition items. Thanks again! Tom From: Tom Whitmore Sent: Thursday, June 16, 2011 11:11 AM To: U2-Users@listserver.u2ug.org Subject: Question about updating customer's systems... Hi, We develop so

Re: [U2] Question of permissions UV Linux

2006-04-27 Thread Glenn Herbert
When writing to a directory type file (type 1 or 19), the permissions are changed to match those of the directory. This is so that the owner of the directory is able to have access to all the contents regardless of the writer. In your test of shelling out, you bypass the permission change bec

RE: [U2] Question of permissions UV Linux

2006-04-27 Thread Jerry Banker
Thanks Glenn. From: Glenn Herbert [mailto:[EMAIL PROTECTED] Sent: Thursday, April 27, 2006 11:17 AM To: Jerry Banker Cc: [EMAIL PROTECTED]; U2Users Subject: Re: [U2] Question of permissions UV Linux When writing to a directory type file (type 1 or 19), the

Re: [U2] Question of permissions UV Linux

2006-04-27 Thread Geoffrey Mitchell
n the ./uv/bin directory to set the group while in UV. >The user ID is set as the owner though. > >-Original Message- >From: Geoffrey Mitchell [mailto:[EMAIL PROTECTED] >Sent: Thursday, April 27, 2006 11:38 AM >To: Jerry Banker >Subject: Re: [U2] Question of permis

RE: [U2] Question about a dictionary item

2006-06-28 Thread Allen E. Elwood
Hi Pamela, Personally, I would setup a SUBR type dict and then just do a loop: SUBROUTINE SUB.GET.NBR(RETURN.VALUE, DATA.ITEM) C = DCOUNT(DATA.ITEM,@VM) RETURN.VALUE = "" FOR I = 1 TO C IF DATA.ITEM<1,I>[1,8] = "COMBO YS" THEN RETURN.VALUE = FIELD(DATA.ITEM<1,I>,' ',3) RETURN END NEXT

RE: [U2] Question about a dictionary item

2006-06-28 Thread George Gallen
FIELDS(ATTNAME,REUSE("YS "),2) or is it FIELDS(REUSE("YS"),2,ATTNAME) I forget which format is used in the DICT I desc. I haven't tested this. I believe the REUSE needs to be there... George > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > Pamela J

RE: [U2] Question about a dictionary item

2006-06-28 Thread Kevin King
Is there any other number in there? If not, why not simply use the MCN conversion? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pamela J Robbins Sent: Wednesday, June 28, 2006 1:01 PM To: u2-users

RE: [U2] Question about a dictionary item

2006-06-28 Thread Tom Dodds
I would do it in a subroutine called from an I Type. 1: I 2: SUBR('GET.NUMBER',fieldname) ... The subroutine could walk the values of the field and find the "COMBO YS" and pick off the number. SUBROUTINE GET.NUMBER(ANS,FIELDNAME) ANS = '' VM.CNT = DCOUNT(FIELDNAME,@VM) FOR I = 1 TO VM.CNT

RE: [U2] Question about a dictionary item

2006-06-28 Thread gerry-u2ug
A 15 second I-Descriptor : NOTES[INDEX(NOTES,"COMBO YS ",1)+9,6] If the length of the data you are after is variable to the end of the field NOTES[INDEX(NOTES,"COMBO YS ",1)+9,99]<1,1> Or extends to the next space or end of field NOTES[INDEX(NOTES,"COMBO YS ",1)+9,99]<1,1>

RE: [U2] Question about a dictionary item

2006-06-28 Thread Mark Eastwood
Under very specific scenarios, something like this should work. But if the string 'COMBO YS' exists more then once, it will only retrieve the first value. And the syntax must be very consistent. 1> I 2> INDEX(@RECORD<999>,"COMBO YS","1");IF @1 > "0" THEN @RECORD<999>[EMAIL PROTECTED]"9","6"] EL

RE: [U2] Question about a dictionary item

2006-06-28 Thread gerry-u2ug
er will be "Y" not "COMBO YS " -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: June 28, 2006 15:18 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Question about a dictionary item FIELDS(ATTNAME,REUSE("YS "),2) or

RE: [U2] Question about a dictionary item

2006-06-28 Thread Stuart . Boydell
>Under very specific scenarios, something like this should work. But if >the string 'COMBO YS' exists more then once, it will only retrieve the >first value. And the syntax must be very consistent. >1> I >2> INDEX(@RECORD< 999>,"COMBO YS","1");IF @1 > "0" THEN >@RECORD

RE: [U2] Question about a dictionary item

2006-06-29 Thread Jeff Flynt
Hi Pam, I am guessing you are on Unidata and probably a Datatel client, and if so, many of the suggested methods won't work as they are designed for Universe. The i-desc below should work for you. It returns your number 073102. More over, it returns any number of numbers depending on how many "COM

Re: [U2] Question about a dictionary item

2006-06-29 Thread Pamela J Robbins
There could be other numbers within the attribute. I should have said earlier, but we're running Universe. Kevin King wrote: Is there any other number in there? If not, why not simply use the MCN conversion? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message

Re: [U2] Question about a dictionary item

2006-06-29 Thread Pamela J Robbins
Thanks, the 15 second I-Descriptor worked perfectly for me in Universe. Pam gerry-u2ug wrote: A 15 second I-Descriptor : NOTES[INDEX(NOTES,"COMBO YS ",1)+9,6] If the length of the data you are after is variable to the end of the field NOTES[INDEX(NOTES,"COMBO YS ",1)+9,99]<1,1>

RE: [U2] Question - retrieving file separation setting

2007-09-13 Thread Dan Fitzgerald
MST or UVFile should do it.> Date: Thu, 13 Sep 2007 22:59:59 -0400> From: [EMAIL PROTECTED]> To: u2-users@listserver.u2ug.org> Subject: [U2] Question - retrieving file separation setting> > In a Universe environment, (running either on Windows or *nix), does > anyone know a fast way to determine th

Re: [U2] Question - retrieving file separation setting

2007-09-14 Thread Allen Egerton
Dan Fitzgerald wrote: MST or UVFile should do it. I'm obviously missing something, 'cause I can't find either of those in any of the online HELP files, in my VOC or in a refreshed &MAP&. Can you enlighten me a bit further please? Thank you. -- Allen Egerton aegerton at pobox dot com

RE: [U2] Question - retrieving file separation setting

2007-09-14 Thread Brian Leach
Allen >From memory - Open FileName To FL Then Status FStat From FL Then FileType = FStat<21> FileMod = FStat<22> FileSep = FStat<23> End End You may need to check the numbers (HELP BASIC STATUS) - those are off the top my head. Brian In a Universe environment, (running either

RE: [U2] Question - retrieving file separation setting

2007-09-14 Thread Manu Fernandes
Use the STATUS stmt FROM filevar OPEN yourfile TO F.DUMMY ELSE EXIT STATUS F.STATUS FROM F.DUMMY ELSE EXIT TYPE = F.STATUS<21,1,1> IF TYPE <2 OR TYPE > 18 THEN EXIT MODULO= F.STATUS<22,1,1> SEPARATOR = F.STATUS<23,1,1> Regards Manu > ---

Re: [U2] Question - retrieving file separation setting

2007-09-14 Thread Allen Egerton
Brian Leach wrote: Allen From memory - Open FileName To FL Then Status FStat From FL Then FileType = FStat<21> FileMod = FStat<22> FileSep = FStat<23> End End You may need to check the numbers (HELP BASIC STATUS) - those are off the top my head. Brian Perfect. Thank you

Re: [U2] Question - retrieving file separation setting

2007-09-14 Thread Allen Egerton
Manu Fernandes wrote: Use the STATUS stmt FROM filevar OPEN yourfile TO F.DUMMY ELSE EXIT STATUS F.STATUS FROM F.DUMMY ELSE EXIT TYPE = F.STATUS<21,1,1> IF TYPE <2 OR TYPE > 18 THEN EXIT MODULO= F.STATUS<22,1,1> SEPARATOR = F.STATUS<23,

Re: [U2] Question about uvbackup dd and uvrestore

2011-04-14 Thread Rex Gozar
Universe admin documentation has the disclaimer: Note: uvrestore does not support reading from stdin. You'll need to gunzip the backup file to disk before you can uvrestore it. rex On Wed, Apr 13, 2011 at 9:12 PM, Augusto Alonso wrote: > Hi all. > I'm trying to pipe uvbackup (universe) and gzi

Re: [U2] Question about uvbackup dd and uvrestore

2011-04-15 Thread Augusto Alonso
Thanks Rex. It's a pity. This way, you need lots of space. And what's worse: If you try to restore from the decompressed image (bigger than 2Gb) you get an "end of reel" after restoring the first 2Gb... So that, if you need to backup more than 20 Gb you can't do it to disk, because of this 2Gb

Re: [U2] Question about uvbackup dd and uvrestore

2011-04-15 Thread Rex Gozar
Unless you need record-level restores, I would recommend using "tar" to backup your Universe accounts. rex ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Question about uvbackup dd and uvrestore

2011-04-15 Thread Tom Dodds
Ad I am not directly associated with Ashwood Computer Companies, but after the thrashing others have taken for not including the "Ad" moniker on their postings I felt compelled. Ashwood Computer Companies at www.ashwoodcomputer.com (do...@ashwoodcomputer.com) have a backup product that is speci

Re: [U2] Question about uvbackup dd and uvrestore

2011-04-15 Thread Israel, John R.
1125 Byers Road Miamisburg, OH  45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Dodds Sent: Friday, April 15, 2011 8:44 AM To: U2 Users List Subject: Re: [U2] Question about uvbackup dd and uvrestore Ad I am

Re: [U2] Question about uvbackup dd and uvrestore

2011-04-15 Thread Larry Hiscock
27;re recommending. It's just fair disclosure. Larry Hiscock Moderator -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Dodds Sent: Friday, April 15, 2011 5:44 AM To: U2 Users List Subject: Re: [U2] Ques

Re: [U2] Question about uvbackup dd and uvrestore

2011-04-15 Thread Tom
they're recommending. It's just fair disclosure. > > Larry Hiscock > Moderator > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Dodds > Sent: Friday, April 15, 20

Re: [U2] Question about uvbackup dd and uvrestore

2011-04-15 Thread Wols Lists
On 15/04/11 13:30, Rex Gozar wrote: > Unless you need record-level restores, I would recommend using "tar" > to backup your Universe accounts. > While UV is running and being used? tar is all very well, but if the database is being used 24/7 it could easily lead to a corrupt backup. Cheers, Wol

Re: [U2] Question about uvbackup dd and uvrestore

2011-04-15 Thread bpaige
...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Friday, April 15, 2011 12:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Question about uvbackup dd and uvrestore On 15/04/11 13:30, Rex Gozar wrote: > Unless you need record-level restores

Re: [U2] Question about uvbackup dd and uvrestore

2011-04-15 Thread Danny Ruckel
Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Friday, April 15, 2011 12:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Question about uvbackup dd and uvrestore On 15/04/11 13:30, Rex Gozar wrote: > Unl

Re: [U2] Question about uvbackup dd and uvrestore

2011-04-16 Thread Manu Fernandes
station of 64bit nGb files). My 2 pence. manu > -Message d'origine- > De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] De la part de bpa...@serta.com > Envoyé : vendredi 15 avril 2011 23:39 > À : u2-users@listserver.u2ug.org >

Re: [U2] Question about accessing external SQL database

2011-10-05 Thread Perry Taylor
We used EasySoft's ODBC driver with good success and I think it was quite a bit less expensive than the bridge. Perry Zirmed. Inc - Original Message - From: Jason Lin [mailto:temp...@ucla.edu] Sent: Wednesday, October 05, 2011 08:01 PM To: U2 Users List Subject: [U2] Question about acce

Re: [U2] Question about accessing external SQL database

2011-10-06 Thread Symeon Breen
The bridge is required because there is no ms sql odbc driver for linux. An alternative would be to use an install of UV on a windows machine to do the actual odbc interaction, it would just use the standard ms odbc driver. This in turn could communicate somehow to your main HP uv install the requi

Re: [U2] Question about accessing external SQL database

2011-10-06 Thread Holt, Jake
Breen Sent: Thursday, October 06, 2011 3:19 AM To: 'U2 Users List' Subject: Re: [U2] Question about accessing external SQL database The bridge is required because there is no ms sql odbc driver for linux. An alternative would be to use an install of UV on a windows machine to do the a

Re: [U2] Question about accessing external SQL database

2011-10-06 Thread George Gallen
riginal Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake Sent: Thursday, October 06, 2011 11:54 AM To: U2 Users List Subject: Re: [U2] Question about accessing external SQL database I created a simple .net app awhile ago to handle t

Re: [U2] Question about accessing external SQL database

2011-10-06 Thread Tony Gravagno
> From: Jason Lin > I am exploring a good way to access data on an external SQL database > from our Universe (10.2.7) environment running on HP-UX (11.23). I agree with suggestions to do this with tiers: Universe <> webservice <> localWin <> remote ODBC This can be done very quickly and it's

Re: [U2] Question about accessing external SQL database

2011-10-06 Thread Jason Lin
On 10/6/2011 1:51 PM, Tony Gravagno wrote: I agree with suggestions to do this with tiers: Universe<> webservice<> localWin<> remote ODBC I think that is the best approach for me as well since I already how to create web services in .Net Framework environment to query access SQL databa

Re: [U2] Question about accessing external SQL database

2011-10-07 Thread Symeon Breen
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake Sent: 06 October 2011 16:54 To: U2 Users List Subject: Re: [U2] Question about accessing external SQL database I created a simple .net app awhile ago to handle the connection so I could just pass a sql statement to it plus the

RE: [U2] Question about Uniobject and session encryption

2008-07-21 Thread Hona, David S
Try: uvSession.EncryptionEnabled = 1 True evaluates to -1 in VB usually. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason Lin Sent: Saturday, 19 July 2008 9:51 AM To: u2-users@listserver.u2ug.org Subject: [U2] Question about Uniobject and session en

Re: [U2] Question about execute and stacked data.

2006-02-13 Thread Mark Johnson
My 2 cents on this regardless of platform is to take the low road. Sure you can set up tricky DATA/EXECUTE statements that you hope will work but somewhere along the way they will get out of sync. I test things like consecutive selects, ie First Select for the majority and the second to fine tune

Re: [U2] Question about execute and stacked data.

2006-02-13 Thread Louie Bergsagel
What are you trying to do? If you want to execute different commands based on whether or not something like a SAVE.LIST exists, just test @SYSTEM.RETURN.CODE after your select and do what you wish. EXECUTE "GET.LIST TEST" IF @SYSTEM.RETURN.CODE LT 1 THEN CRT "Enter a SAVE.LIST name: ": INPU

RE: [U2] Question about execute and stacked data.

2006-02-13 Thread u2
; -Original Message- > From: [EMAIL PROTECTED] > [HYPERLINK "mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED] ver.u2ug.org] On Behalf Of > Louie Bergsagel > Sent: Monday, February 13, 2006 4:11 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Question about execu

Re: [U2] Question about execute and stacked data.

2006-02-13 Thread Louie Bergsagel
According to the documentation, DATA is only used "...as an input stack to act as responses to INPUT statements..." so your "basic.program.that.builds.a.list" would have to contain INPUT COMMAND;EXECUTE COMMAND or you could add another EXECUTE line after the DATA/EXECUTE lines which ran the fol

Re: [U2] Question about execute and stacked data.

2006-02-13 Thread Mark Johnson
is pretty splintered. My 1 cent. Mark Johnson - Original Message - From: "Louie Bergsagel" <[EMAIL PROTECTED]> To: Sent: Monday, February 13, 2006 6:34 PM Subject: Re: [U2] Question about execute and stacked data. > According to the documentatio

Re: [U2] Question about execute and stacked data.

2006-02-13 Thread Dave Taylor
61-5200 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Monday, February 13, 2006 2:51 PM Subject: RE: [U2] Question about execute and stacked data

RE: [U2] Question about execute and stacked data.

2006-02-14 Thread u2
m cannot? > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Dave Taylor > Sent: Tuesday, February 14, 2006 1:02 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Question about execute and stacked data. > > > Ed, > &

RE: [U2] Question about the U2 News Flash...

2008-02-28 Thread David Jordan
I believe U2.Net is mv.Net customised to work better with U2 products. Regards David Jordan > 1) U2.NET Beta available and > 2) developerWorks article on U2 and IBM Data Server Provider for .NET > > So... These two items are both to get .NET code working, but each uses > a > different process t

RE: [U2] Question about the U2 News Flash...

2008-02-28 Thread David Wolverton
@listserver.u2ug.org > Subject: RE: [U2] Question about the U2 News Flash... > > I believe U2.Net is mv.Net customised to work better with U2 products. > > Regards > > David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

  1   2   >