RE: [U2] Passed argument in Subroutines {Unclassified}
Mike, et al:
Many thanks for enlightening me. :-)
Bill
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> HENDERSON MIKE, MR
> Sent: Monday, February 06, 2006 4:50 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Passed argument in Subroutines {Unclassified}
>
> Bill,
>
> From the UV Basic Reference Manual (v10.0) page 11-121
>
> "The actual values of arguments are not passed to the subroutine.
> Instead, a pointer to the location of each argument is
> passed. Passing a pointer instead of the values is more
> efficient when many values need to be passed to the
> subroutine. This method of passing arguments is called
> passing by reference; passing actual values is called passing
> by value.
> All scalar and matrix variables are passed to subroutines by
> reference.
> If you want to pass variables by value, enclose them in parentheses.
> When data is passed by value, the contents of the variable in
> the main program do not change as a result of manipulations
> to the data in the subroutine. When data is passed by
> reference, the memory location of the variable is changed by
> manipulations in both the main program and the subroutines.
> Constants are passed to subroutines by value."
>
> Maybe D3 has the opposite default?
>
>
> HTH
>
> Mike
>
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of
> Bill Haskett
> > Sent: Tuesday, 7 February 2006 12:14
> > To: u2-users@listserver.u2ug.org
> > Subject: [U2] Passed argument in Subroutines
> >
> > I was converting a few programs from D3 to UD and noticed the
> > following:
>
> [snip]
>
> > Bill Haskett
> > Advantos Systems, Inc.
> > www.advantos.net
> > (760)944-5570 (CA)
> > (360)923-4838 (WA)
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> >
> The information contained in this Internet Email message is
> intended for the addressee only and may contain privileged
> information, but not necessarily the official views or
> opinions of the New Zealand Defence Force.
> If you are not the intended recipient you must not use,
> disclose, copy or distribute this message or the information in it.
>
> If you have received this message in error, please Email or
> telephone the sender immediately.
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[U2] Passed argument in Subroutines
I was converting a few programs from D3 to UD and noticed the following: BILL 001 InValue = "Test" 002 CALL BILL.SUBR (InValue, InValue) 003 END BILL.SUBR 001 SUBROUTINE BILL.SUBR (RtnValue, InValue) 002 CRT "InValue before-: " : InValue 003 RtnValue = '' 004 CRT "InValue after--: " : InValue 005 RETURN 006 END The value of "InValue", in the subroutine, is changed when the variable "RtnValue" is assigned a value. :RUN BP BILL InValue before-: Test InValue after--: This seems to indicate that there's a relationship between the variable InValue in the calling program and the subroutine; in the subroutine when RtnValue is initialized the variable InValue is also initialized. I'd have thought it's the positions that are important (since there must be the number of arguments must equal in both the calling and the called programs), not necessarily the variable names. Have I figured this out right, and is this correct? As I remember, the passed arguements in subroutines: 1) don't have to be the same name, and 2) are managed solely within the subroutine. Per the UniData documentation: SUBROUTINE Syntax SUBROUTINE sub.name[(argument1 [, argument2] ...)] Description If you pass arguments, the number of arguments in the CALL statement and the SUBROUTINE statement must match, although variable names do not need to be the same. Changes made to arguments in the subroutine retain their new values when UniData exits the subroutine and control reverts to the calling program. Naturally, I resolve the program by changing the code to pass different variables, as arguments, to the called subroutine. :-) Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata XML
Well, so U2 is having the same problems with casing the rest of us do when interfacing with outside systems. It never ceases to amaze me that some believe "Help", "HELP", and "help" __SHOULDN'T__ mean the same thing. I can always tell I'm accessing a unix web server when I try to access a directory, under the "root" directory, and I type the case of that directory incorrectly. e.g. http://www.consumerreports.org/Cro/Home.htm doesn't work while http://www.consumerreports.org/cro/home.htm does. This particular problem doesn't exist on Windows servers and I was caught by it when my son was trying to track down some information for his homework. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Monday, February 06, 2006 11:36 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Unidata XML > > There are some notes in the latest readme for the HTTP > functions which explains the proper casing in the different > versions. My guess is that the XML functions have the same > problem - different cases in different versions. > > The last couple of examples I've seen from IBM using these > have all come with the statement that you have to compile > them with the -I option. > > Hth > Colin Alfke > Calgary, Canada > > >-Original Message- > >From: jbutera > > > >I originally wrote about a compilation error with: > >> > >>X.STATUS = PrepareXML(X.XML.INPUT.FILE, X.XML.HANDLE) X.STATUS = > >>OpenXMLData(X.XML.HANDLE, X.XML.EXT.RULE.FILE, X.XML.DATA.HANDLE) > > > >On Sun, 5 Feb 2006, Allen Egerton replied: > >> > >> The compiler is seeing what you're defining as functions > as matrixes. > >> Which means that you've got a more basic problem 'cause you're not > >> trying to use matrixes. You need to somehow define the > >> subroutines/functions you're trying to use. > > > >Funny solution here - In Unidata 6.1.4, I have to enter > these function > >names in uppsercase to compile cleanly (although the > document indicates > >these are case-sensitive). After uppercasing everything, it > compiles > >cleanly. > > > >Jeff Butera, Ph.D. > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] Universe and SQL Server
Nick: I wonder how well an ODBC linked table can scale? Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Nick > Cipollina > Sent: Thursday, February 02, 2006 1:41 PM > To: u2-users@listserver.u2ug.org > Subject: [U2][UV] Universe and SQL Server > > Hello all, > > We are currently looking into ways to share our data between > universe and SQL Server, and I am trying to get some > suggestions on the best way to do this. We are currently > generating text files in UV and ftp'ing those files to a > designated location. We have a task scheduler that picks up > the files when they arrive and inserts them into SQL server. > I know there are ways to communicate directly between SQL > server and Universe and I am looking for the best way to do > this. It doesn't matter if Universe reaches out to SQL > Server or vice versa. Thanks. > > Nick Cipollina > > Pick Programmer > ACS Heritage, Inc. > 2810 North Parham Road, Suite 210 > Richmond, VA 23294 > (804)644-8707 x 314 > > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Newbies need love too
Wendy: Do you think it'd be a good idea to put a "Getting Started" link to this page on the main page, or did I miss it? :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Wendy Smoak > Sent: Wednesday, February 01, 2006 6:27 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Newbies need love too > > On 2/1/06, Nick Cipollina <[EMAIL PROTECTED]> wrote: > > Check out http://www.discoverycomputersystems.com/ I got > my Universe > > training at Marcie's school. She now only does onsite > training, but > > she is definitely one of the best instructors I have ever had. She > > has a lot of experience, and was one of the trainers at PICK. > > I've attempted to capture all of the links that were > suggested on this Wiki page: >http://www.pickwiki.com/cgi-bin/wiki.pl?UniVerse/GettingStarted > > Please feel free to add more! (To edit, click preferences, > and the admin password is Mr. Pick's first name in lowercase.) > > -- > Wendy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Trouble starting logs on Win Server 2003
Clif: I wonder if the log service is started (or on automatic). What happens if you configure the logs to write to D:\... instead of C:\perflogs. Are you starting the logging properly. I just did a quick 5 minute log on our system and had no problems. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Clifton Oliver > Sent: Monday, January 30, 2006 12:16 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] [UV] Trouble starting logs on Win Server 2003 > > When I try to start a counter log in Windows Server 2003 > Performance Monitor, I get the error "log or alert has not > started. Refresh the log or alert list to view current > status, or see the application event log for any errors." > > I am in the Administrators Group. I can watch the stats, I > just cannot get a log to capture them. > > Anyone been down this path? I've been reading tech docs over > on Microsoft 'til my eyes are crossed . > > Thanks for any answers, leads, or suggestions. > > > -- > > Regards, > > Clif > > ~~~ > W. Clifton Oliver, CCP > CLIFTON OLIVER & ASSOCIATES > Tel: +1 619 460 5678Web: www.oliver.com > ~~~ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] T-LOAD
Dave: Thanks for your insights. I'd like to hear any info from your UniData guys that might help with the T.LOADS. It's not critical as I can transfer one file at a time and this will only take me about 4-8 hours in total. I've actually found UniData more compatible to R83 (D3) in a number of important respects. The issues I'm having to mostly cope with are: 1) Dictionary conversions and 2) Data transport A few other items pop up, from time to time, but the application I'm helping convert is pretty straightforward, has its own list of custom verbs (VOC entries) so they're easy to identify, use straight BASIC (no PROCS or Paragraphs), and have files that hold the O/S commands for that kind of stuff (table-driven stuff). The biggest problem I have, otherwise, is the paleozic user interface. I'm at least 5 to 10 times more productive with a screen editor (I'm into tons of stuff like programs, VOC entries, dictionaries, and data and have difficulty managing a different editor for each type of item I'm working on) than I am with AE (or ED on UV). This means that I'm probably spending 20 days doing about 2-4 days of work. So far, with about 50 man days invested, we're about 90% complete, and like I've said before, most of the work is simply unnecessary (rarely is the issue U2 does it one way while other MVs do it another). All the unnecessary work is futzing with conversion issues that should have been published by IBM, futzing with data transport issues that should have been published by IBM, and futzing with dictionary conversions that should have been done by utilitites published by IBM. :-) Anyway, we're testing right now as the menus work, they can enter most data, and display reports/data to the screen. Their application does print stuff and uses a couple of programs (I think they're about 3-4 programs) that do the spooler stuff and I know U2 does it different. If you have some tools to help with spooler conversion to U2 I'd be interest in hearing about if off-line. Thanks again for all your help. :-) Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Dave Taylor > Sent: Friday, January 27, 2006 3:55 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] [UD] T-LOAD > > Bill, > > We developed a program, TAPE.DUMP, to T-DUMP any list of, or > all of the files and/or MD items in an account to tape, > including the file characteristics of each file (in the label > of the dump). > > We developed a companion program, TAPE.LOAD, to create each > file that did not exist and then T-LOAD the dumped files to > another database. > > We have used it successfully for moving all the files in an > accounts from A/P, R91 and mvBase to Universe in two steps > and have not run into the rewind problems that you described > on Unidata. > > It almost feels like Universe is finding only one file dumped > on the tape from D3 and is rewinding because it found and EOT marker. > > One of the associate consultants that works with us is a > Unidata guy and I'll be glad to ask him if he has run into > this on Unidata. > > The other observation I'd like to make is that several > knowledgeable Unidata people have suggested to me that > Unidata is decidedly not a Pick-like database, and that > converting software from D3 to Unidata will be a long and > expensive process, and will leave you with two versions of > your software that will be distinctly different from each. > > We also looked at Unidata several years ago and we chose to > convert our software to Universe instead of Unidata partly > because Universe offers the "Pick" flavor that allows us to > run essentially the same code on all generic Pick platforms, > with occasional platform-specific flags that can be searched > on and reset as we move the software from one platform to the other. > > Also, because Universe does not support the generic Pick > spooler commands (:STARTSPOOLER, STARTPTR, SP-ASSIGN, > LISTPTR, LISTPEQS, etc.), and because we didn't want to > rewrite all the print program in our software to SETPTR > commands, we developed a generic Pick spooler for Universe, > called UvSpoolerPlus. > > Using these two tools, you could migrate your software from > D3 to Universe with a minimal amount of modification compared > with the major effort you are facing migrating D3 code to Unidata. > > If you'd like to explore this further, please give me a call. > > Rgds, > > Dave > > Dave Taylor > President > Sysmark Information Systems, Inc. > 49 Aspen Way > Rolling Hills Est
[U2] [UD] T-LOAD
I'm able to take a T-DUMP from D3 (T-DUMP FileName (AHI) and move the file to UD server (via XCOPY only!) then: SETTAPE 9... T.LOAD FileName MU 09 PICK and it works fine. Now the problem is when I create a new T-DUMP from D3 for multiple files by doing: T-DUMP FileA (AHI T-DUMP FileB (AHI . . then move it to UniData and try: SETTAPE 9... T.LOAD FileA MU 09 OVERWRITING PICK T.LOAD FileB MU 09 OVERWRITING PICK the tape seems to rewind after each T.LOAD and only FileA's T-DUMP data is continually T.LOAD'd into each file on UniData. I was checking out the SETTAPE with the "no_rewind_driver" option but that doesn't seem to be what I'm looking for. Can anyone tell me how to T.LOAD multiple files on UniData, or is there some issue with D3 T-DUMPs that is causing the problem? Thanks, Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] Best practices
I've been converting dictionaries from a D3 dbms and am wondering what is considered "best practices" in virtual attribute design. Does one build standard "D"irect fields first then use these fields to build virtual attributes (I-Descriptors) or should one use the direct field references, "EXTRACT()" or "", in virtual attributes? DEPOSITED 001 D The date of the deposit. 002 2 VOID 001 D Is this a voided receipt? 002 12 DEPDATE 001 I The displayed deposit date (if not voided). 002 IF VOID = "" THEN DEPOSITED ELSE "*Voided*" or DEPDATE 001 I The displayed deposit date (if not voided). 002 EXTRACT( @RECORD, 2, 0, 0 ) ; EXTRACT( @RECORD, 12, 0, 0 ) ; IF @2 = "" THEN @1 ELSE "*Voided*" The obvious concern is if a direct field definition is renamed, then all references to the old field name need to be changed. I rarely rename a field, until I started exposing the data to other data sources and was forced to clean up the field names. So, hopefully, this won't be an issue in the future. Any thoughts. Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PROC question
Bob: Since the PROC buffer is getting trashed by the called PROC change the menu PROC to a more suitable format like: PQ 10 C Top of Main Menu RI RO OA number of lines that display the available menu choices ... OEnter choice + IP: IF # A X IF A = 1 GO 100 ... IF A = 99 GO 990 O O That is not a valid menu choice. OPRESS [ENTER] + IP GO 10 C--> 100 C Option# 1 [PROD.PL PROG1.PROC GO 10 ... 990 C Option# 99 [PROD.PL PROG99.PROC GO 10 Hope this helps. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Glenn Herbert > Sent: Wednesday, January 25, 2006 1:01 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] PROC question > > If this is for universe, the problem here stems from the fact > that your [PROD.xx procs are stomping all over the buffers of > the main menu proc. > There's not really much you can do about that, but you could > modify your main proc slightly as follows: > > 0001: PQ > 002 F-OPEN 1 VOC > 003 XNO VOC > 004 10 C TOP > 005 OEnter choice+ > 006 S1 > 007 IP: > 008 IF # A X > 009 MV &1.1 %1 > 010 IF A = 1 [VOC YYY > 011 IF &1.1 = 1 GO 10 > 012 IF A = 99 [VOC ZZZ > 013 IF &1.1 = 99 GO 10 > 014 O > 015 O > 016 ONOT VALID. PRESS ENTER+ > 017 IP: > 018 GO 10 > > In order to save your entry, you can't use input, output or > select list buffers - you are then left with using a file > channel (since you probably don't want to write anything > here). So at line 2 and 3, open the VOC file to channel 1 > and use that as a holder. Line 7 is used to make certain > input is always done on the first field. Line 9 then is used > to transfer your users input value into the first field of > the file channel - you then use the file channel as your test > to return to the menu (lines 11 and 13). > This means you should only have to modify slightly your > main menu program to retain the input value and not have to > modify the PROCxx files. > _ > "I reject your reality and substitute my own" - Adam Savage > > Glenn M. Herbert - Connectivity Development Engineer > Information Integration Solutions, IBM Software Group 50 > Washington Street Westboro, MA 01581 > 508-599-7281 direct > > [EMAIL PROTECTED] wrote on 01/25/2006 02:54:05 PM: > > > Hi folks, > > > > Maybe I'm just missing the finer points of PROC processing. > I've got > > a MENU proc that's structured like this: > > > > PQ > > 10 C Top of Main Menu > > OA number of lines that display the available menu choices ... > > OEnter choice + > > IP: > > IF # A X > > IF A = 1 [PROD.PL PROG1.PROC > > IF A = 1 G 10 > > ... > > IF A = 99 [PROD.PL PROG99.PROC > > IF A = 99 G 10 > > O > > O That is not a valid menu choice. > > OPRESS [ENTER] + > > IP > > G 10 > > > > My problem is when I come back from one of the > PROGxx.PROC's, I'm not > > getting the menu choice value back to execute the G 10 command. > > Instead it displays the error message at the bottom. The > PROGxx.PROC > > is structured like this: > > > > PQ > > 10 C Top of this PROC > > Ha number of things stuffed into the output buffer P Hmore things > > happen in the output buffer P RTN P > > 999 C should never get past this point OI never see this message X > > > > Now keep in mind that I've trimmed down the PROC's to keep this > > message fairly short. Everything is working as expected EXCEPT the > > falling through on the MAIN.MENU.PROC into the invalid menu > choice message. > > Anyone have any insight to my problem? > > > > TIA > > > > BobW > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] AE on UV
Bob: I typed in "HA" and got help. When I pressed [Enter] I got the following: E*---: and simply entered "EX" to exit and it worked fine. I wish I could help more. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward > Sent: Friday, January 20, 2006 2:06 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] AE on UV > > I got the same thing but when I tried HA and HELP ALL I get a > message that it's an invalid command. Since I've never used > AE before, I haven't a clue of how to get out of the command > prompt so I end up killing the telnet session. > > BobW > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett > Sent: Friday, January 20, 2006 12:48 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] AE on UV > > Using the latest release of UV PE on Windows I get (first > time use) and the program can be edited. > > >AE BP APMAINT > > AE 4.0-beta - first version for Universe; ported from Unidata. > AE command: HELP ALL, or HA, displays online documentation. > AE command: SPOOLHELP -BRIEF prints summary documentation. > AE command: SPOOLHELP -FULL prints complete documentation. > > Top of "APMAINT" in "DTABP", 1,001 lines, 29,433 characters. > *---: > > Bill > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Dave Taylor > > Sent: Friday, January 20, 2006 11:42 AM > > To: u2-users@listserver.u2ug.org > > Subject: Re: [U2] AE on UV > > > > The Workgroup Edition of Universe on NT Rel. 10.1.11 has > "AE 4.0-beta > > - first version for Universe; ported from Unidata". > > > > Dave Taylor > > President > > Sysmark Information Systems, Inc. > > 49 Aspen Way > > Rolling Hills Estates, CA 90274 > > 800-SYSMARK (800-797-6275) > > (O) 310-544-1974 > > (C) 310-561-5200 > > (P) 800-339-1497 > > (F) 310-377-3550 > > Your Source for Integrated EDI Translation and DataSync Integration > > www.sysmarkinfo.com > > > > - Original Message - > > From: "Gordon J Glorfield" <[EMAIL PROTECTED]> > > To: > > Sent: Friday, January 20, 2006 10:34 AM > > Subject: [U2] AE on UV > > > > > > > We are on UV 10.1.6. I just tried AE and I get the following: > > > > > > /u1/uv/catdir/AE_ICOM1 is not a uniVerse/BASIC object file. > > > Program "*AE": pc = A06, Unable to load file "AE_ICOM1". > > > Program "*AE": pc = A06, Unable to load subroutine. > > > > > > Any suggestions? > > > > > > Thanks, > > > Gordon > > > > > > > > > Gordon J. Glorfield > > > Sr. Applications Developer > > > MAMSI (A UnitedHealth Company) > > > 301-360-8839 > > > > > > > > > This e-mail, including attachments, may include > confidential and/or > > > proprietary information, and may be used only by the person > > or entity to > > > which it is addressed. If the reader of this e-mail is not > > the intended > > > recipient or his or her authorized agent, the reader is > > hereby notified > > > that any dissemination, distribution or copying of this e-mail is > > > prohibited. If you have received this e-mail in error, > > please notify the > > > sender by replying to this message and delete this e-mail > > immediately. > > > --- > > > u2-users mailing list > > > u2-users@listserver.u2ug.org > > > To unsubscribe please visit http://listserver.u2ug.org/ > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] AE on UV
Using the latest release of UV PE on Windows I get (first time use) and the program can be edited. >AE BP APMAINT AE 4.0-beta - first version for Universe; ported from Unidata. AE command: HELP ALL, or HA, displays online documentation. AE command: SPOOLHELP -BRIEF prints summary documentation. AE command: SPOOLHELP -FULL prints complete documentation. Top of "APMAINT" in "DTABP", 1,001 lines, 29,433 characters. *---: Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Dave Taylor > Sent: Friday, January 20, 2006 11:42 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] AE on UV > > The Workgroup Edition of Universe on NT Rel. 10.1.11 has "AE > 4.0-beta - first version for Universe; ported from Unidata". > > Dave Taylor > President > Sysmark Information Systems, Inc. > 49 Aspen Way > Rolling Hills Estates, CA 90274 > 800-SYSMARK (800-797-6275) > (O) 310-544-1974 > (C) 310-561-5200 > (P) 800-339-1497 > (F) 310-377-3550 > Your Source for Integrated EDI Translation and DataSync > Integration www.sysmarkinfo.com > > - Original Message - > From: "Gordon J Glorfield" <[EMAIL PROTECTED]> > To: > Sent: Friday, January 20, 2006 10:34 AM > Subject: [U2] AE on UV > > > > We are on UV 10.1.6. I just tried AE and I get the following: > > > > /u1/uv/catdir/AE_ICOM1 is not a uniVerse/BASIC object file. > > Program "*AE": pc = A06, Unable to load file "AE_ICOM1". > > Program "*AE": pc = A06, Unable to load subroutine. > > > > Any suggestions? > > > > Thanks, > > Gordon > > > > > > Gordon J. Glorfield > > Sr. Applications Developer > > MAMSI (A UnitedHealth Company) > > 301-360-8839 > > > > > > This e-mail, including attachments, may include confidential and/or > > proprietary information, and may be used only by the person > or entity to > > which it is addressed. If the reader of this e-mail is not > the intended > > recipient or his or her authorized agent, the reader is > hereby notified > > that any dissemination, distribution or copying of this e-mail is > > prohibited. If you have received this e-mail in error, > please notify the > > sender by replying to this message and delete this e-mail > immediately. > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] list output when captured
Thanks David: I also do all the niceties you mention, except the width. The reason I don't mess with the width is a D3 feature that the U2 products don't have; to wit, dynamic width dictionaries. These are dictionaries defined as "20X" where output will take 20 columns or the balance of the available screen width, whichever is wider. For instance, here's a D3 "A" dictionary: vendor_lfm 001 S 002 1 003 Vendor Name 004 005 006 007 008 CALL DTABP D.NAMELFM 009 TX 010 20 Here's what output looks like: :term 40 :list apopen vendor_lfm sampling 5 Page 1 apop11:34:41 20 Jan 2006 apopen Vendor Name.. 830*33309 SAN DIEGO WTR & WASTEWTR UTIL 167*10517 CATHCART LTD. . . :term 60 :list apopen vendor_lfm sampling 10 Page 1 apopen 11:34:51 20 Jan 2006 apopen Vendor Name.. 830*33309 SAN DIEGO WTR & WASTEWTR UTIL 167*10517 CATHCART LTD. . . :term 100 :list apopen vendor_lfm sampling 10 Page 1 apopen 11:34:59 20 Jan 2006 apopen Vendor Name .. 830*33309 SAN DIEGO WTR & WASTEWTR UTIL 167*10517 CATHCART LTD. . . a really cool feature! When I futz with the width (which I shouldn't have to anyway) I'll break the application on D3; as most output will print 255 columns wide, which is not what the user wants. :-( Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > David A. Green > Sent: Friday, January 20, 2006 7:03 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] list output when captured > > Bill, > > When I do these types of CAPTURING to gleam the output I also > set my TERM page width to 255,0 the 255 for the widest screen > size and 0 causes the pagination logic to be turned off. Of > course I read the TERM settings before changing them so that > I can restore them before exiting. > > Example: > > CMD = "LIST ..." > ! > MAX.ROW = @CRTHIGH > MAX.COL = @CRTWIDE > ! > PERFORM "TERM 255,0" CAPTURING BUFF ;* Set term characteristics > PERFORM CMD CAPTURING BUFF ;* Execute command and > capture output > ! > PERFORM "TERM ":MAX.COL:",":MAX.ROW CAPTURING BUFF ;* Reset term > > Thanks, > David A. Green > DAG Consulting > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett > Sent: Thursday, January 19, 2006 5:15 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] list output when captured > > David: > > Thanks...because I need the heading. :-) > > A SCROLL program takes the results of a query and simply > pages it so the user can move around the report (up, down, > all around, and search). We need the heading passed into the > program (assuming one is). > > Bill > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of David A. > > Green > > Sent: Thursday, January 19, 2006 6:01 AM > > To: u2-users@listserver.u2ug.org > > Subject: RE: [U2] [UD] list output when captured > > > > Why not just suppress the heading? HDR.SUP > > > > David A. Green > > DAG Consulting > > > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of > Bill Haskett > > Sent: Wednesday, January 18, 2006 5:20 PM > > To: u2-users@listserver.u2ug.org > > Subject: [U2] [UD] list output when captured > > > > I've got a simple scroll routine that parses the output > from a LIST or > > SORT command's "CAPTURING" variable of an EXECUTE statement. The > > routine tests for the 2nd empty line to determine when the column > > heading ends and the data begins, as all output with a > heading puts a > > blank line between the column heading and the data. > > > > So, typical captured output would look like: > > > > SCRATCH(1)=Dictionary of File: PERIPHERALS > > 16:05:08 Jan > > 18 > > 2006^Dict Name.. Typ # Col-Heading Field-Def... > > Conversion.. Formt Assoc > > ...^^@ Phr LPTRNO DEV_N^ > > . > > . > > > > The total width of the heading is 78 characters, while the > TERM width > > is 79. > > If I were to change the TERM width to 78 then rerun the > above listing > > the
RE: [U2] Difference between IBM Universe and IBM UniData
Kevin: > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King > Sent: Friday, January 20, 2006 6:17 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Difference between IBM Universe and IBM UniData [snipped] > You said: "2. The editor is named AE (there is an ED, but that's > different). It is fundamentally the same as the UniVerse ED editor." > > If by "fundamentally" you mean it can read, update, and write > records, then I agree. Past that, AE is a vast improvement > over the rudimentary features of ED. Yea, but it's still a stone knife. :-) Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] list output when captured
Thanks Adrian. With all the things to do, I make it a point to keep all things simple. :-) I can still simply execute the AQL query into the captured variable and parse that...plain and simple. We're just scrolling output that one would normally want to view on the screen. This is a simple, yet effective solution. It appears I need to monitor when the total column width equals the term width and make sure I work around that. Thanks again. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Womack, Adrian > Sent: Thursday, January 19, 2006 5:05 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] list output when captured > > I haven't been following this thread - but, why don't you > just LIST into the &HOLD& file and then get your program to > read the results and delete the &HOLD& record? > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett > Sent: Friday, 20 January 2006 8:15 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] list output when captured > > David: > > Thanks...because I need the heading. :-) > > A SCROLL program takes the results of a query and simply > pages it so the user can move around the report (up, down, > all around, and search). We need the heading passed into the > program (assuming one is). > > Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Referencing remote file directly
Thanks Mike. I'll soon find out how to read and write files from/to the O/S file system. As we know, with D3 there's no difference so one uses the same, standard, file I/O statements. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Mike Preece > Sent: Thursday, January 19, 2006 4:43 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] Referencing remote file directly > > Hi Bill > > >From: "Bill Haskett" <[EMAIL PROTECTED]> > >Reply-To: u2-users@listserver.u2ug.org > >To: > >Subject: RE: [U2] [UD] Referencing remote file directly > >Date: Thu, 19 Jan 2006 16:13:53 -0800 > > > >Rodney: > > > >Thanks. I was thinking this was true. U2 does allow direct > reference > >to an O/S path from within BASIC, e.g: > > > >OPEN 'DOS:E:\IBM\ud71\sys\BP' TO BP.FV ... (in D3) > >OSOPEN 'E:\IBM\ud71\sys\BP' TO BP.FV...(in UD) > > I'm not sure this is what you want really. If you OSOPEN a > file you're opening it as a sequential file aren't you - so > that you can then go on and READSEQ from it? It's as though > you're opening a connection to a tape drive, and therefore > you are limited to processing it in sequential order. I don't > think you'll be able to READ REC FROM BP.FV,"MYPROG"... I > could be wrong... > > Mike. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] list output when captured
Ed: Isn't that interesting. I was using a vt420 and tried it with a wy60 and it still does the same thing. I'll tread lightly. :-) Thanks, Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Thursday, January 19, 2006 9:55 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] list output when captured > > I think maybe the teminal handler is too smart for it's own > good?. There are 78 characters in the row, and 78 characters > wide on the screen, so when it gets to the end of the line it > realizes it's at the end and will autowrap to the next > line--so no need for a carriage return. In fact a carriage > return would probably insert an extra unwanted line on the display. > > So, possibilities: > 1. set your terminal width wider. > 2. Use a different term type that doesn't support auto-wrap > 3. Instead of executing with capture, print to a hold file, > and then process the hold file entry. > > > -Original Message- > > From: [EMAIL PROTECTED] > > Sent: Wednesday, January 18, 2006 5:20 PM > > To: u2-users@listserver.u2ug.org > > Subject: [U2] [UD] list output when captured > > > > I've got a simple scroll routine that parses the output > from a LIST or > > SORT command's "CAPTURING" variable of an EXECUTE statement. The > > routine tests for the 2nd empty line to determine when the column > > heading ends and the data begins, as all output with a > heading puts a > > blank line between the column heading and the data. > > > > So, typical captured output would look like: > > > > SCRATCH(1)=Dictionary of File: PERIPHERALS > > 16:05:08 Jan > > 18 > > 2006^Dict Name.. Typ # Col-Heading Field-Def... > > Conversion.. Formt Assoc > > ...^^@ Phr LPTRNO DEV_N^ > > . > > . > > > > The total width of the heading is 78 characters, while the > TERM width > > is 79. If I were to change the TERM width to 78 then rerun > the above > > listing the extra line between the column heading and the > 1st row of > > data disappears (the first of two attribute marks changes > to a space). > > > > SCRATCH(1)=Dictionary of File: PERIPHERALS > > 16:05:08 Jan > > 18 > > 2006^Dict Name.. Typ # Col-Heading Field-Def... > > Conversion.. Formt Assoc > > ... ^@ Phr LPTRNO DEV_N^ > > . > > . > > > > Is there a reason why this occurs (I've not seen this > before) or will > > I just have to be careful in the future? > > > > As always, thanks. > > > > Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] list output when captured
David: Thanks...because I need the heading. :-) A SCROLL program takes the results of a query and simply pages it so the user can move around the report (up, down, all around, and search). We need the heading passed into the program (assuming one is). Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > David A. Green > Sent: Thursday, January 19, 2006 6:01 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] list output when captured > > Why not just suppress the heading? HDR.SUP > > David A. Green > DAG Consulting > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett > Sent: Wednesday, January 18, 2006 5:20 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] [UD] list output when captured > > I've got a simple scroll routine that parses the output from > a LIST or SORT command's "CAPTURING" variable of an EXECUTE > statement. The routine tests for the 2nd empty line to > determine when the column heading ends and the data begins, > as all output with a heading puts a blank line between the > column heading and the data. > > So, typical captured output would look like: > > SCRATCH(1)=Dictionary of File: PERIPHERALS > 16:05:08 Jan > 18 > 2006^Dict Name.. Typ # Col-Heading Field-Def... > Conversion.. Formt Assoc > ...^^@ Phr LPTRNO DEV_N^ > . > . > > The total width of the heading is 78 characters, while the > TERM width is 79. > If I were to change the TERM width to 78 then rerun the above > listing the extra line between the column heading and the 1st > row of data disappears (the first of two attribute marks > changes to a space). > > SCRATCH(1)=Dictionary of File: PERIPHERALS > 16:05:08 Jan > 18 > 2006^Dict Name.. Typ # Col-Heading Field-Def... > Conversion.. Formt Assoc > ... ^@ Phr LPTRNO DEV_N^ > . > . > > Is there a reason why this occurs (I've not seen this before) > or will I just have to be careful in the future? > > As always, thanks. > > Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Referencing remote file directly
Rodney: Thanks. I was thinking this was true. U2 does allow direct reference to an O/S path from within BASIC, e.g: OPEN 'DOS:E:\IBM\ud71\sys\BP' TO BP.FV ... (in D3) OSOPEN 'E:\IBM\ud71\sys\BP' TO BP.FV...(in UD) OPENPATH 'E:\IBM\ud71\sys\BP' TO BP.FV... (in UV) I can do this (assuming I have permissions) in DOS or Linux by: >dir e:\IBM\ud71\sys\BP or #ls -al /ourdir/ourbankdata D3 allows such direct O/S reference from TCL, like: :LIST DOS:E:\IBM\ud71\sys\BP or :LIST UNIX:/ourdir/ourbankdata Or to a file within a different D3 account by: :LIST PAYROLL,EMPLOYEE,2004, or :LIST DM,BP, This would one less layer of "stuff" we'd have to go through when installing and configuring our application and I'm thinking: less is more (or where is the MV2006 standard). :-) Thanks again. Maybe this would be a good enhancement request. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Baakkonen, Rodney A (Rod) 46K > Sent: Thursday, January 19, 2006 1:15 AM > To: 'u2-users@listserver.u2ug.org' > Subject: RE: [U2] [UD] Referencing remote file directly > > Sorry late night. I did not see you want to do a LIST using > the full path. > You do need a VOC pointer in Unidata. Even ecltype u says a > direct reference is not a file name > > list /mccdata/mcc13/CLM.DETAIL > Not a filename : > /mccdata/mcc13/CLM.DETAIL > > Sure, you can use full paths in attribute 2 or 3 of Unidata > VOCS. We make extensive use of @UDTHOME on our dev box. We > have a development env, Systems and Acceptance, End To End > and a training environment on the same server. We have a UNIX > shell script that prompts a logged in user which environment > they want to go to. From a maintenance stand point, the VOC's > for all these environments are the same, using @UDTHOME. But > the shell script sets a different $UDTHOME, so each > environment has its own unique sets of the files. To see what > your UDTHOME home is set to, do a !echo $UDTHOME at ECL. > > Hardcoded paths would make the maintenance of these > environments a major headache. So I see @UDTHOME as a major > blessing. - Rod > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Mike Preece > Sent: Thursday, January 19, 2006 2:15 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] Referencing remote file directly > > > I think not. This is often mentioned as one of the > differences. I assume you'ved used indexinfocus to search? > > > > >From: "Bill Haskett" <[EMAIL PROTECTED]> > >Reply-To: u2-users@listserver.u2ug.org > >To: > >Subject: [U2] [UD] Referencing remote file directly > >Date: Wed, 18 Jan 2006 20:57:32 -0800 > > > >I can't find the old discussions of this but can one > reference a remote > >file > >directly in UniData. For instance, can I: > > > >:LIST D:\IBM\ud71\sys\VOC > > > >instead of needing a link like: > > > >001 F > >002 @UDTHOME\sys\VOC > >002 @UDTHOME\sys\D_VOC > > > >? > > > >Any help would be appreciated. :-) > > > >Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Referencing remote file directly
Mike: Yea. :-( Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Mike Preece > Sent: Thursday, January 19, 2006 12:15 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] Referencing remote file directly > > I think not. This is often mentioned as one of the > differences. I assume you'ved used indexinfocus to search? > > > > >From: "Bill Haskett" <[EMAIL PROTECTED]> > >Reply-To: u2-users@listserver.u2ug.org > >To: > >Subject: [U2] [UD] Referencing remote file directly > >Date: Wed, 18 Jan 2006 20:57:32 -0800 > > > >I can't find the old discussions of this but can one > reference a remote > >file > >directly in UniData. For instance, can I: > > > >:LIST D:\IBM\ud71\sys\VOC > > > >instead of needing a link like: > > > >001 F > >002 @UDTHOME\sys\VOC > >002 @UDTHOME\sys\D_VOC > > > >? > > > >Any help would be appreciated. :-) > > > >Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] Referencing remote file directly
I can't find the old discussions of this but can one reference a remote file directly in UniData. For instance, can I: :LIST D:\IBM\ud71\sys\VOC instead of needing a link like: 001 F 002 @UDTHOME\sys\VOC 002 @UDTHOME\sys\D_VOC ? Any help would be appreciated. :-) Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] list output when captured
I've got a simple scroll routine that parses the output from a LIST or SORT command's "CAPTURING" variable of an EXECUTE statement. The routine tests for the 2nd empty line to determine when the column heading ends and the data begins, as all output with a heading puts a blank line between the column heading and the data. So, typical captured output would look like: SCRATCH(1)=Dictionary of File: PERIPHERALS 16:05:08 Jan 18 2006^Dict Name.. Typ # Col-Heading Field-Def... Conversion.. Formt Assoc ...^^@ Phr LPTRNO DEV_N^ . . The total width of the heading is 78 characters, while the TERM width is 79. If I were to change the TERM width to 78 then rerun the above listing the extra line between the column heading and the 1st row of data disappears (the first of two attribute marks changes to a space). SCRATCH(1)=Dictionary of File: PERIPHERALS 16:05:08 Jan 18 2006^Dict Name.. Typ # Col-Heading Field-Def... Conversion.. Formt Assoc ... ^@ Phr LPTRNO DEV_N^ . . Is there a reason why this occurs (I've not seen this before) or will I just have to be careful in the future? As always, thanks. Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Active select list in BASIC
give you the account you're logged onto. "WHERE" does. .'Q' pointers don't exist in UD so one has to create something like: DTAPATCHES 001: LD 002: @UDTHOME\DTA\PATCHES 003: @UDTHOME\DTA\D_PATCHES This requires the "DTA" account be under the UDTHOME directory (not really a big deal) though. If 'Q' pointer(s) point to itself, 001 Q 002 003 DTA however, they will all have to be altered if the name of the account ever changes; a probability for production accounts. This list, it turns out, is indispensible. :-) There's more, but I forget, off the top of my head. I'll keep you posted, though, if you'd like. By the way, sorry about not limiting my comments strictly to the differences between "P" and "U" modes. :-) Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Mike Preece > Sent: Tuesday, January 17, 2006 9:37 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] Active select list in BASIC > > Which ones have you come across so far Bill? > > > > >From: "Bill Haskett" <[EMAIL PROTECTED]> > >Reply-To: u2-users@listserver.u2ug.org > >To: > >Subject: RE: [U2] [UD] Active select list in BASIC > >Date: Fri, 13 Jan 2006 19:29:33 -0800 > > > >David & Ed: > > > >Thank you. The "SELECT TO BPLIST" (I couldn't get the > SELECT TO 1 then > >the READNEXT FROM 1 to compile) works fine as long as I > assign BPLIST a > >value before using it (another quirk with UniData). :-) > > > >I wish the "quirky things that don't work like PICK" would be listed > >somewhere. It'd sure save me a lot of time. :-) > > > >Thanks again, > > > >Bill > > > > > > > -Original Message- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] On Behalf Of > > > [EMAIL PROTECTED] > > > Sent: Friday, January 13, 2006 3:32 PM > > > To: u2-users@listserver.u2ug.org > > > Subject: RE: [U2] [UD] Active select list in BASIC > > > > > > It never made any sense to me why unidata did this, and I never > > > found a setting that would change it. I got around it by always > > > putting select lists into variables. i.e: > > > > > > EXECUTE \SSELECT BP\ > > > SELECT TO BPLIST > > > HEADING "THIS IS A TEST 'CLT'" > > > LOOP > > >READNEXT ID FROM BPLIST ELSE EXIT > > >CRT ID > > > REPEAT > > > CRT > > > CRT "...Exiting program and clearing select list..." > > > END > > > > > > Which seemed to work (not sure if the above example works > as is--I > > > don't have a unidata system to test it on. I seem to recall that > > > maybe there had to be a file open, or the BPLIST variable > needed to > > > be assigned ahead of time for it to work) In ADDS, it was > possible > > > to prevent a user from exiting out of a paged list like that--I > > > think you have to have break off or something like that. > > > Universe can be made to return an active select list to TCL. > > > One of the options in the VOC catalog entry for the > program controls > > > that (I think it's K) but I don't think it returns a default list > > > that has been partially used. The numbered select lists > 1-10 (not 0) > > > are persistent like that though. > > > > > > > -Original Message- > > > > From: [EMAIL PROTECTED] > > > > [mailto:[EMAIL PROTECTED] On Behalf Of > > > Bill Haskett > > > > Sent: Friday, January 13, 2006 4:12 PM > > > > To: u2-users@listserver.u2ug.org > > > > Subject: RE: [U2] [UD] Active select list in BASIC > > > > > > > > > > > > David, Kevin and Ed: > > > > > > > > Thanks for the tip. My question was the select list > > > remaining active, > > > > rather than the page message or the program aborting. Although > > > > the program aborting sucks, it has always occurred in > pick-like systems. > > > > > > > > In all Pick systems I've ever used, Microdata, Adds, GA, > > > R83, R91, D3, > > > > and UV, when a file is selected then listed, within BASIC, > > > quiting the > > > > display doesn't leave
RE: [U2] Unidata on XP Lap Top
Jerry: Nothing, except nothing in Pick is 'LIKE "THAT"'; and to convert all syntax in an application is pretty scarey. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker > Sent: Wednesday, January 18, 2006 7:01 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Unidata on XP Lap Top > > So what is wrong with typing in SORT VOC WITH @ID LIKE "...LIST_..." > If I remember correctly Unidata followed the Prime > INFORMATION usage rather than the PICK usage. > > - Original Message - > From: "Bill Haskett" <[EMAIL PROTECTED]> > To: > Sent: Tuesday, January 17, 2006 8:51 PM > Subject: RE: [U2] Unidata on XP Lap Top > > > > Tony: > > > > It's amazing how much one constantly fights with the dbms, > isn't it? :-) > > Way too much is illogical or is segregated between Pick > mode, which is 30 > > years old, and "U" mode, which doesn't work well for Pick like > > environments. > > For instance, in "U" mode something so simple like 'SORT > VOC = "[LIST_]"' > > fails miserably. :-( > > > > One always has to ask the question, why would IBM and UD make it so > > difficult to work in, or move to, this environment? :-) > > > > Bill > > > > > >> -Original Message- > >> From: [EMAIL PROTECTED] > >> [mailto:[EMAIL PROTECTED] On Behalf Of > Tony Gravagno > >> Sent: Tuesday, January 17, 2006 10:02 AM > >> To: u2-users@listserver.u2ug.org > >> Subject: RE: [U2] Unidata on XP Lap Top > >> > >> George Smith wrote: > >> > I would like to propose to upper management that we replace > >> a single > >> > user laptop program using a non-pick database with a > Unidata single > >> > user system. We would use C# and the uniObjects for the gui > >> front end. > >> > This would be on about 400 laptops if successful. > >> > Anyone doing this and would like comments from the group. > >> > >> I have Unidata PE on my laptop with XP Pro for > >> development/testing with DesignBais and mv.NET, both of which > >> can use UO for connectivity. I haven't had any problems - > >> outside of being a D3 guy who desperately needs a "U2 for > >> Pick Dummies" book. :) > >> > >> Rather than letting the system auto-start the services, I > >> start/stop the environment with a single click on BAT files > >> on the desktop. (Provided here on request.) I do this to > >> eliminate CPU/memory usage when the environment isn't in use. > >> That said, UD only has a modest 15MB RAM footprint and zero > >> CPU usage when inactive, so it doesn't interrupt other > >> processes anyway - this is probably what you're interested in. > >> > >> The only other comment I would make is that it might be > >> appropriate to get licenses for production systems, rather > >> than running on personal/development licenses. I don't > >> recall what the actual license text has to say about this. > >> > >> Side comment: One of these days I wish the MV DBMS Vendors > >> would pay attention to requests like this and create "Lite" > >> versions of these environments with no BASIC compiler, no > >> spooler, no editors, no telnet or serial services, etc. - > >> just a low-profile runtime-only that's easy to install and > >> use with a GUI client, and for a similar cost. So far I > >> think the only candidates we have for this now are Revelation > >> OpenInsight and QM. > >> > >> HTH > >> T > >> --- > >> u2-users mailing list > >> u2-users@listserver.u2ug.org > >> To unsubscribe please visit http://listserver.u2ug.org/ > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata on XP Lap Top
Tony: It's amazing how much one constantly fights with the dbms, isn't it? :-) Way too much is illogical or is segregated between Pick mode, which is 30 years old, and "U" mode, which doesn't work well for Pick like environments. For instance, in "U" mode something so simple like 'SORT VOC = "[LIST_]"' fails miserably. :-( One always has to ask the question, why would IBM and UD make it so difficult to work in, or move to, this environment? :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno > Sent: Tuesday, January 17, 2006 10:02 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Unidata on XP Lap Top > > George Smith wrote: > > I would like to propose to upper management that we replace > a single > > user laptop program using a non-pick database with a Unidata single > > user system. We would use C# and the uniObjects for the gui > front end. > > This would be on about 400 laptops if successful. > > Anyone doing this and would like comments from the group. > > I have Unidata PE on my laptop with XP Pro for > development/testing with DesignBais and mv.NET, both of which > can use UO for connectivity. I haven't had any problems - > outside of being a D3 guy who desperately needs a "U2 for > Pick Dummies" book. :) > > Rather than letting the system auto-start the services, I > start/stop the environment with a single click on BAT files > on the desktop. (Provided here on request.) I do this to > eliminate CPU/memory usage when the environment isn't in use. > That said, UD only has a modest 15MB RAM footprint and zero > CPU usage when inactive, so it doesn't interrupt other > processes anyway - this is probably what you're interested in. > > The only other comment I would make is that it might be > appropriate to get licenses for production systems, rather > than running on personal/development licenses. I don't > recall what the actual license text has to say about this. > > Side comment: One of these days I wish the MV DBMS Vendors > would pay attention to requests like this and create "Lite" > versions of these environments with no BASIC compiler, no > spooler, no editors, no telnet or serial services, etc. - > just a low-profile runtime-only that's easy to install and > use with a GUI client, and for a similar cost. So far I > think the only candidates we have for this now are Revelation > OpenInsight and QM. > > HTH > T > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Deleting saved lists
Andy: Doesn't it strike you as odd that one can usually execute a verb against multiple items in a file from TCL, but not with DELETE.LIST, CATALOG, and I'm sure I'll run into a few more. Maintaining consistency of syntax has always been one of the hallmarks of MV systems. So, when I encounter anomolies where I need to remember unusual syntaxes, special exceptions, and develop work-arounds it makes me . :-) I'm finding UniData hasn't been updated very much. E.g. in a virtual attribute, in ECLTYPE P, one has to 'EXTRACT(@RECORD, 1, 0, 0)' if one wants the first attribute. This is 30 year old syntax that was obsolete 25 years ago with the "<>" syntax. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Andy Pflueger > Sent: Tuesday, January 17, 2006 2:56 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] [UD] Deleting saved lists > > Hi, > > On 1/17/06, Bill Haskett <[EMAIL PROTECTED]> wrote: > > I was trying to delete multiple lists on UD PE v7.1 in Pick > mode from > > the command line and it seems to only delete the last list. > > > > :DELETE.LIST BILL BILL1 > > Why not select the SAVEDLIST file with a LIKE clause and then > once you have an active list delete those SAVEDLIST records? > I know this can be dangerous but this is how I delete > multiple lists (after looking at my selected list BEFORE > actually deleting of course. :-) > > HTH, > Andy > -- > The Linux philosophy is 'Laugh in the face of danger'. > Oops. Wrong One. 'Do it yourself'. Yes, that's it. > Linus Torvalds > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] Deleting saved lists
I was trying to delete multiple lists on UD PE v7.1 in Pick mode from the command line and it seems to only delete the last list. :DELETE.LIST BILL BILL1 only deleted list BILL1! I'm thinking this must be some sort of UDT.OPTION but I can't figure it out yet. I can, however, delete one at a time. Is this some sort of circa 1985 concept? I've not seen it before and don't know why the verb would behave in this manner...the same thing happens when I try to catalog multiple programs, only it catalogs the 1st program in the list. Can someone enlighten me as to how to handle this peculiarity. As always, many thanks. Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Active select list in BASIC
David & Ed: Thank you. The "SELECT TO BPLIST" (I couldn't get the SELECT TO 1 then the READNEXT FROM 1 to compile) works fine as long as I assign BPLIST a value before using it (another quirk with UniData). :-) I wish the "quirky things that don't work like PICK" would be listed somewhere. It'd sure save me a lot of time. :-) Thanks again, Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Friday, January 13, 2006 3:32 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] Active select list in BASIC > > It never made any sense to me why unidata did this, and I > never found a setting that would change it. I got around it > by always putting select lists into variables. i.e: > > EXECUTE \SSELECT BP\ > SELECT TO BPLIST > HEADING "THIS IS A TEST 'CLT'" > LOOP >READNEXT ID FROM BPLIST ELSE EXIT >CRT ID > REPEAT > CRT > CRT "...Exiting program and clearing select list..." > END > > Which seemed to work (not sure if the above example works as > is--I don't have a unidata system to test it on. I seem to > recall that maybe there had to be a file open, or the BPLIST > variable needed to be assigned ahead of time for it to work) > In ADDS, it was possible to prevent a user from exiting out > of a paged list like that--I think you have to have break off > or something like that. > Universe can be made to return an active select list to TCL. > One of the options in the VOC catalog entry for the program > controls that (I think it's K) but I don't think it returns a > default list that has been partially used. The numbered > select lists 1-10 (not 0) are persistent like that though. > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of > Bill Haskett > > Sent: Friday, January 13, 2006 4:12 PM > > To: u2-users@listserver.u2ug.org > > Subject: RE: [U2] [UD] Active select list in BASIC > > > > > > David, Kevin and Ed: > > > > Thanks for the tip. My question was the select list > remaining active, > > rather than the page message or the program aborting. Although the > > program aborting sucks, it has always occurred in pick-like systems. > > > > In all Pick systems I've ever used, Microdata, Adds, GA, > R83, R91, D3, > > and UV, when a file is selected then listed, within BASIC, > quiting the > > display doesn't leave the select list active. How can I > turn off this > > unexpected feature? > > > > Thanks again, > > > > Bill > > > > P.S. It looks fortunate that I only have a couple of > programs that do > > this, like the list-files program. :-) > > > > > > > -Original Message- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] On Behalf Of David A. > > > Green > > > Sent: Friday, January 13, 2006 6:00 AM > > > To: u2-users@listserver.u2ug.org > > > Subject: RE: [U2] [UD] Active select list in BASIC > > > > > > Bill, > > > > > > You can turn this feature off by using an @ print command > i.e. PRINT > > > @(-1) or if you don't want to clear the screen just do a DMY = > > > @(-1), or issuing BPIOCPN command. > > > > > > Thanks, > > > David A. Green > > > DAG Consulting > > > > > > > > > -Original Message- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] On Behalf Of > > Bill Haskett > > > Sent: Friday, January 13, 2006 5:48 AM > > > To: u2-users@listserver.u2ug.org > > > Subject: [U2] [UD] Active select list in BASIC > > > > > > I have a simple program that looks like: > > > > > > EXECUTE \SSELECT BP\ > > > HEADING "THIS IS A TEST 'CLT'" > > > LOOP > > >READNEXT ID ELSE EXIT > > >CRT ID > > > REPEAT > > > CRT > > > CRT "...Exiting program and clearing select list..." > > > END > > > > > > When I run it in Pick mode I get the message "Enter > > line> to continue..." at the bottom of the 1st screen. If I > > > enter [Q] to quit, the program aborts, never prints the exit > > > message, and I'm left at TCL with the list active (a '>' prompt). > > > > > > This is not at all what I expected, and after several hours of > > > research I can't find anything close to a resolution. > > > > > > Any help would be appreciated. > > > > > > Bill Haskett > > > --- > > > u2-users mailing list > > > u2-users@listserver.u2ug.org > > > To unsubscribe please visit http://listserver.u2ug.org/ > > > --- > > > u2-users mailing list > > > u2-users@listserver.u2ug.org > > > To unsubscribe please visit http://listserver.u2ug.org/ > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Active select list in BASIC
David, Kevin and Ed: Thanks for the tip. My question was the select list remaining active, rather than the page message or the program aborting. Although the program aborting sucks, it has always occurred in pick-like systems. In all Pick systems I've ever used, Microdata, Adds, GA, R83, R91, D3, and UV, when a file is selected then listed, within BASIC, quiting the display doesn't leave the select list active. How can I turn off this unexpected feature? Thanks again, Bill P.S. It looks fortunate that I only have a couple of programs that do this, like the list-files program. :-) > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > David A. Green > Sent: Friday, January 13, 2006 6:00 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] Active select list in BASIC > > Bill, > > You can turn this feature off by using an @ print command > i.e. PRINT @(-1) or if you don't want to clear the screen > just do a DMY = @(-1), or issuing BPIOCPN command. > > Thanks, > David A. Green > DAG Consulting > > > -Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett > Sent: Friday, January 13, 2006 5:48 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] [UD] Active select list in BASIC > > I have a simple program that looks like: > > EXECUTE \SSELECT BP\ > HEADING "THIS IS A TEST 'CLT'" > LOOP >READNEXT ID ELSE EXIT >CRT ID > REPEAT > CRT > CRT "...Exiting program and clearing select list..." > END > > When I run it in Pick mode I get the message "Enter line> to continue..." at the bottom of the 1st screen. If I > enter [Q] to quit, the program aborts, never prints the exit > message, and I'm left at TCL with the list active (a '>' prompt). > > This is not at all what I expected, and after several hours > of research I can't find anything close to a resolution. > > Any help would be appreciated. > > Bill Haskett > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] Active select list in BASIC
I have a simple program that looks like: EXECUTE \SSELECT BP\ HEADING "THIS IS A TEST 'CLT'" LOOP READNEXT ID ELSE EXIT CRT ID REPEAT CRT CRT "...Exiting program and clearing select list..." END When I run it in Pick mode I get the message "Enter to continue..." at the bottom of the 1st screen. If I enter [Q] to quit, the program aborts, never prints the exit message, and I'm left at TCL with the list active (a '>' prompt). This is not at all what I expected, and after several hours of research I can't find anything close to a resolution. Any help would be appreciated. Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PROC Question
Bob: I used to be pretty proficient in PROC and have never heard of this...but that doesn't mean it doesn't exist. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward > Sent: Wednesday, January 11, 2006 9:35 AM > To: U2-Users List > Subject: [U2] PROC Question > > Hi folks, > > I can't find anything in the IBM Doc's for ProVerb's that > tells me how to create an entry that will allow me to put > multiple commands on a single line. In a nutshell, from a > "menu" when a user selects an option, I want to be able to > execute multiple commands. > > Currently, I use multiple lines such as: >IF A = 5 [USER.PL BASIC.PGM1 >IF A = 5 [USER.PL BASIC.PGM2 >IF A = 5 G 10 > > What I want to be able to do is: >IF A = 5 [USER.PL BASIC.PGM1];[USER.PL BASIC.PGM2];G 10 > > Is my mind fried? Maybe... But is there something that will work? > > BobW > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] How to determine the File Name within a dictionary called Subroutine
Thanks, David. I was trying to avoid changing a bunch of dictionaries but I
guess I've got some more re-engineering to do. :-(
Bill
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> David A. Green
> Sent: Monday, January 09, 2006 6:28 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] [UD] How to determine the File Name within
> a dictionary called Subroutine
>
> Can you send it into the Subroutine as a parameter?
>
> SUBR("MY.SUB", @FILENAME, Dict_Name, etc. )
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
> Sent: Friday, January 06, 2006 2:04 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] [UD] How to determine the File Name within a
> dictionary called Subroutine
>
> As I trudge along with a client conversion I've noticed a
> difficulty using @FILENAME within a BASIC program...it works
> fine in UniVerse but fails to compile in UniData ("P"
> Ecltype). I'm trying to determine, in a subroutine called
> from a virtual definition, if the file being processed needs
> to be opened. Code looks like:
>
> CurrFileName = @FILENAME
> IF CurrFileName = "EMPLOYEES" THEN
>ReturnValue = @RECORD<15>
> END ELSE
>ReturnValue = @RECORD<12>
> END
> RETURN
>
> I can use @FILENAME in a virtual dictionary definition but
> not in BASIC.
> How do I get the variable of the file being processed in a
> query, in UniData?
>
> Since the same code runs on U2 and D3 I'd like to keep this
> business rule in the subroutine, that can be used by both.
>
> Thanks, any help would be appreciated.
>
> Bill Haskett
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] How to determine the File Name within a dictionary called Subroutine
Thanks, but I've already tried this. This is on UD PE v7.1.
Bill
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Burwell, Edward
> Sent: Friday, January 06, 2006 1:57 PM
> To: 'u2-users@listserver.u2ug.org'
> Subject: RE: [U2] [UD] How to determine the File Name within
> a dictionary called Subroutine
>
> try @FILE.NAME
>
> -Original Message-
> From: Bill Haskett [mailto:[EMAIL PROTECTED]
> Sent: Friday, January 06, 2006 4:04 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] [UD] How to determine the File Name within a
> dictionary called Subroutine
>
>
> As I trudge along with a client conversion I've noticed a
> difficulty using @FILENAME within a BASIC program...it works
> fine in UniVerse but fails to compile in UniData ("P"
> Ecltype). I'm trying to determine, in a subroutine called
> from a virtual definition, if the file being processed needs
> to be opened. Code looks like:
>
> CurrFileName = @FILENAME
> IF CurrFileName = "EMPLOYEES" THEN
>ReturnValue = @RECORD<15>
> END ELSE
>ReturnValue = @RECORD<12>
> END
> RETURN
>
> I can use @FILENAME in a virtual dictionary definition but
> not in BASIC.
> How do I get the variable of the file being processed in a
> query, in UniData?
>
> Since the same code runs on U2 and D3 I'd like to keep this
> business rule in the subroutine, that can be used by both.
>
> Thanks, any help would be appreciated.
>
> Bill Haskett
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
>
> __
> This e-mail has been scanned by MCI Managed Email Content
> Service, using
> Skeptic(tm) technology powered by MessageLabs. For more
> information on MCI's Managed Email Content Service, visit
> http://www.mci.com.
> __
>
> __
> This e-mail has been scanned by MCI Managed Email Content
> Service, using Skeptic(tm) technology powered by MessageLabs.
> For more information on MCI's Managed Email Content Service,
> visit http://www.mci.com.
> __
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] How to determine the File Name within a dictionary called Subroutine
As I trudge along with a client conversion I've noticed a difficulty using
@FILENAME within a BASIC program...it works fine in UniVerse but fails to
compile in UniData ("P" Ecltype). I'm trying to determine, in a subroutine
called from a virtual definition, if the file being processed needs to be
opened. Code looks like:
CurrFileName = @FILENAME
IF CurrFileName = "EMPLOYEES" THEN
ReturnValue = @RECORD<15>
END ELSE
ReturnValue = @RECORD<12>
END
RETURN
I can use @FILENAME in a virtual dictionary definition but not in BASIC.
How do I get the variable of the file being processed in a query, in
UniData?
Since the same code runs on U2 and D3 I'd like to keep this business rule in
the subroutine, that can be used by both.
Thanks, any help would be appreciated.
Bill Haskett
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Is a file opened?
Thanks everyone. It looks like another redesign. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Wendy Smoak > Sent: Sunday, January 01, 2006 4:35 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] [UD] Is a file opened? > > On 1/1/06, Bill Haskett <[EMAIL PROTECTED]> wrote: > > How can I tell if a file is open in UniData (in ECLTYPE P)? I've > > tried the > > UNASSIGNED() function and this doesn't work under certain > conditions. > > Without looking it up, I think I've used 'FILEINFO' for this. > > -- > Wendy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] Is a file opened?
How can I tell if a file is open in UniData (in ECLTYPE P)? I've tried the UNASSIGNED() function and this doesn't work under certain conditions. For instance, in some code I want to open a file if it already isn't opened. Normally I'd do the following: COMMON FileVariable (or COMMON /FILES/ FileVariable) IF UNASSIGNED(FileVariable) THEN OPEN 'FileName' TO FileVariable ELSE DoSomethingElse END or, in other mvDbms I might: IF NOT(ASSIGNED(FileVariable))... Although this works fine in UV and all other mvDbms products it doesn't work in UniData. It appears it's because defining a variable as COMMON actually assigns it a value (zero or empty depending on UDT.OPTIONS 15). Of course, when I alter the critical line above to: IF UNASSIGNED(FileVariable) OR FileVariable = 0 THEN ... then if the variable has actually been assigned the program aborts with the message: "...Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX ,MQS, SOAP or database variable.". Is there a function I can use in UniData, anywhere in any program, to test if a file has been opened in common? As always, thanks. Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] Sharing a network directory
Since everyone has been so kind recently I thought I'd share a solution that may help others. I like to use a "shared" directory on another machine on the network, for a wide variety of reasons. UV and UD can easily access a local directory (a directory on the same machine as U2) but accessing a network "shared" directory is a little more difficult. I haven't figured out how to do it on UD yet but in UV here's how it's done: 1) In UniAdmin select "Configuration Editor" and change the "ALLOWNFS" parameter to "1". This is the "critical" piece and escaped me for days until someone suggested it. :-) 2) Get to TCL in UV and execute the following: DOS /C"net use Z: \\Server\Share Passwd /user:Server\U2Admin" "U2Admin" is the Windows user who's logged in. 3) Create an "F" item in the VOC that looks like: U2TEMP 0001 F 0002 Z:\Temp 0003 D_VOC This will allow UV to access shared network resources without UV/NET. Hope this helps somebody. :-) Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: Re[2]: [U2] UD: Named common
:-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > David Tod Sigafoos > Sent: Wednesday, December 28, 2005 7:56 AM > To: Bill Haskett > Subject: Re[2]: [U2] UD: Named common > > Bill, > > real programmers don't compile in PICK mode .. or use PICK .. > they just scale back the expectations > > Tuesday, December 27, 2005, 8:19:42 AM, you wrote: > > BH> Of course, programs won't compile in PICK mode if the > label exceeds 7 characters. :-) > > >> -Original Message- > >> From: [EMAIL PROTECTED] > >> [mailto:[EMAIL PROTECTED] On Behalf Of David > >> Wolverton > >> Sent: Tuesday, December 27, 2005 4:58 AM > >> To: u2-users@listserver.u2ug.org > >> Subject: RE: [U2] UD: Named common > >> > >> I probably should have been more clear -- that's why we rearranged > >> and put our 'most unique' details at the front of the Named Common > >> block -- but ulimately, we truncated all at > >> 7 characters. > >> > >> DW > >> > >> -Original Message- > >> > >> >In terms of readability/maintainability, the named common > >> label can be > >> >more > >> than 7 characters, however - the first 7 >must be unique in your > >> application (or much confusion can reign... :-( ) > >> > > > -- > DSig ` > David Tod Sigafoos ( O O ) > ___oOOo__( )__oOOo___ > > "...our behavior matters more than the beliefs that we > profess." Elizabeth Deutsch Earle > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: Named common
Kevin: You're correct that it's pretty easy to work around this problem...yes they're in an include. But, IMHO of course, the analysis that it's "no big deal" is slightly off the mark. When we went from 300 baud to 1200 baud then to 4800 baud then to 9600 baud all of us, well most of us anyway, would refuse to go back! This is the cost of progress. That's the point here. Either other systems have progressed or other mvDbms products have progressed. For U2 to keep up with the front edge of technology some very important deficiencies need to be addressed. Limiting named common labels to seven characters is just one of a numerous list of deficiencies. Now, I'm not saying U2 is a bad product at all. I'm just saying U2 can certainly grow dramatically, if it appeals to new people and development. In order to do this it's got to be easy to use and connect to and relatively inexpensive to develop on. Certainly appealing to other mvDbms users/developers would be a good start. It's difficult to warm up to the U2 products when it's terribly difficult to move data and dictionaries into a U2 environment (re: see the T-DUMP and Fast File Transfers list postings), working at TCL/ECL is like slicing tomatoes with a stone knife, using a line editor is excruciatingly painful, UniAdmin is unstable and doesn't include anywhere near the number of administrative tasks needed, and UniDebugger is a good start but definitely needs improvement. So, following the good advice given by those such as you, I'm changing the labels of the named common from "DtaSecurity_files" to "S_files", etc. :-) Thanks again. The help I get from this list is greatly appreciated. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King > Sent: Tuesday, December 27, 2005 12:56 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] UD: Named common > > >On Behalf Of Mark Johnson > >Perhaps the big difference is that while an older environment > >could have hundreds of spreadsheets or basic programs, a MV > >system probably won'd have but a few names common entities. > > And if you're using an include to bring in the named common, > what's the big deal anyway? Okay, so the named common name > can't be larger than 7 characters. Frankly, the 7 is a > little weird (3 bits?) but considering we have so few > limitations anyway and this one is so easily worked around > for most apps, I just don't see anything of real concern. > > -K --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: Named common
Of course, programs won't compile in PICK mode if the label exceeds 7 characters. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > David Wolverton > Sent: Tuesday, December 27, 2005 4:58 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] UD: Named common > > I probably should have been more clear -- that's why we > rearranged and put our 'most unique' details at the front of > the Named Common block -- but ulimately, we truncated all at > 7 characters. > > DW > > -Original Message- > > >In terms of readability/maintainability, the named common > label can be > >more > than 7 characters, however - the first 7 >must be unique in > your application (or much confusion can reign... :-( ) > > >Wally Terhune > >Manager - U2 Advanced Client Support > >IBM Information Management --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData phrases
Thanks David, I forgot about that. :-) Bill P.S. Still doesn't explain why ECLTYPE P doesn't use phrases. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > David A. Green > Sent: Tuesday, December 27, 2005 5:38 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] UniData phrases > > Did you know you can force UniData flavor by using the > lowercase verb equivalent? list, sort, etc. > > Thank you, > David A. Green > DAG Consulting > (480) 813-1725 > www.dagconsulting.com > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett > Sent: Monday, December 26, 2005 3:44 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] UniData phrases > > Allen: > > I tried that. I copied "@WIDE" to "WIDE". Even closed my > telnet session and restarted UD. Logged back on and tried: > > >LIST BP WIDE > > LIST BP WIDE 13:45:19 Dec 26 2005 2 > BP > > 123CONV.ASCII > . > . > AP.OVBAL > Enter to continue... > > >LIST BP > LIST BP ID-SUPP BP.NAME BP.MDATE BP.DESC TOTAL BP.SIZE > 13:48:04 Dec 26 2005 > 1 > PROG NAME. LASTMOD... DESCRIPTION > Size > > 123CONV.ASCII 10/20/2003 Converts 123-ascii file into PICK > 2600 > file items . > . > AP.OVBAL 10/14/2004 Read & total (APOPEN) then compare > 3023 > Enter to continue... > > I created the accounts via "mkdir" and "newacct", so they were clean. > > What I figured out is [EMAIL PROTECTED] phrases don't work in "ECLTYPE > P"; @UQ phrases work just fine. If I execute "ECLTYPE U" > just before the query "LIST BP @WIDE" and voi'la. I didn't > read where there were phrase differences between ECLTYPEs. > Oh well, the tribulations of ECLTYPE. :-) > > Thanks, > > Bill > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. > > Elwood > > Sent: Monday, December 26, 2005 9:35 AM > > To: u2-users@listserver.u2ug.org > > Subject: RE: [U2] UniData phrases > > > > Hi Bill, > > > > In Unidata you just get rid of the @. > > > > Make it WIDE, no at sign, and : > > > > LIST BP WIDE > > > > should work like a champ. > > > > hth, > > > > Allen E. Elwood www.tortillafc.com > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of Bill Haskett > > Sent: Monday, December 26, 2005 02:34 > > To: u2-users@listserver.u2ug.org > > Subject: [U2] UniData phrases > > > > > > I've built a phrase in UniData PE v7.1, besides the standard @UQ > > phrase. > > The phrases look like: > > > > @ID TYP LOC. > > @UQ PH ID-SUPP BP.NAME BP.MDATE > > BP.DESC TOTAL BP.SIZE > > @WIDE PH ID-SUPP BP.NAME BP.MDATE > > BP.DESCW TOTAL BP.SIZE > > > > When I enter "LIST BP" at ECL the "@UQ" phrase is used. > > However, when I enter "LIST BP @WIDE" at ECL nothing is displayed > > except the @ID. I've noticed this with all the tables I > brought over > > from UniVerse. > > > > I've read the documentation pretty thoroughly and it works > just fine > > on UV. > > In addition, it works fine in UD if I enter "LIST BP > ID-SUPP BP.NAME > > BP.MDATE BP.DESCW TOTAL BP.SIZE". Does anyone know what I missed? > > Then again, maybe it's just late and I'm fumbling with the use of > > those brutal, outdated tools. :-) > > > > Bill > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: Named common
Dave: The reason I suspected a joke was because most of us have never lived with restricted variable name lengths and no longer live with 8.3 DOS file names, except of course rundll32.exe, svchost.exe, etc. :-) A real pain when the application is used on various mvDbms environments. Thanks very much for your comments though. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > David Wolverton > Sent: Monday, December 26, 2005 7:21 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] UD: Named common > > At this moment and time, that would be true... But how many > unique combinations of 7 characters can be created? 26 to the > 7th power? (if we exclude numerics, anyway!) So far, 8 > billion+ choices has been enough leeway for us to work within > > - But it is a hard limit -- we just truncated our Common > Group labels to meet the requirement, and moved the 'unique' > attributes to the FRONT of the common block labels. > > DW > > -Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett > Sent: Monday, December 26, 2005 9:05 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] UD: Named common > > Is it true UniData named common cannot have a label longer > than 7 characters? Is this a paleozoic joke or is it a PICK > basic type thing? > "Onward & Upward". :-) > > Thanks. > > Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UD: Named common
Is it true UniData named common cannot have a label longer than 7 characters? Is this a paleozoic joke or is it a PICK basic type thing? "Onward & Upward". :-) Thanks. Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData phrases
Allen: I tried that. I copied "@WIDE" to "WIDE". Even closed my telnet session and restarted UD. Logged back on and tried: >LIST BP WIDE LIST BP WIDE 13:45:19 Dec 26 2005 2 BP 123CONV.ASCII . . AP.OVBAL Enter to continue... >LIST BP LIST BP ID-SUPP BP.NAME BP.MDATE BP.DESC TOTAL BP.SIZE 13:48:04 Dec 26 2005 1 PROG NAME. LASTMOD... DESCRIPTION Size 123CONV.ASCII 10/20/2003 Converts 123-ascii file into PICK 2600 file items . . AP.OVBAL 10/14/2004 Read & total (APOPEN) then compare 3023 Enter to continue... I created the accounts via "mkdir" and "newacct", so they were clean. What I figured out is [EMAIL PROTECTED] phrases don't work in "ECLTYPE P"; @UQ phrases work just fine. If I execute "ECLTYPE U" just before the query "LIST BP @WIDE" and voi'la. I didn't read where there were phrase differences between ECLTYPEs. Oh well, the tribulations of ECLTYPE. :-) Thanks, Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Allen E. Elwood > Sent: Monday, December 26, 2005 9:35 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] UniData phrases > > Hi Bill, > > In Unidata you just get rid of the @. > > Make it WIDE, no at sign, and : > > LIST BP WIDE > > should work like a champ. > > hth, > > Allen E. Elwood www.tortillafc.com > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Bill Haskett > Sent: Monday, December 26, 2005 02:34 > To: u2-users@listserver.u2ug.org > Subject: [U2] UniData phrases > > > I've built a phrase in UniData PE v7.1, besides the standard > @UQ phrase. > The phrases look like: > > @ID TYP LOC. > @UQ PH ID-SUPP BP.NAME BP.MDATE > BP.DESC TOTAL BP.SIZE > @WIDE PH ID-SUPP BP.NAME BP.MDATE > BP.DESCW TOTAL BP.SIZE > > When I enter "LIST BP" at ECL the "@UQ" phrase is used. > However, when I enter "LIST BP @WIDE" at ECL nothing is > displayed except the @ID. I've noticed this with all the > tables I brought over from UniVerse. > > I've read the documentation pretty thoroughly and it works > just fine on UV. > In addition, it works fine in UD if I enter "LIST BP ID-SUPP > BP.NAME BP.MDATE BP.DESCW TOTAL BP.SIZE". Does anyone know > what I missed? Then again, maybe it's just late and I'm > fumbling with the use of those brutal, outdated tools. :-) > > Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniData phrases
I've built a phrase in UniData PE v7.1, besides the standard @UQ phrase. The phrases look like: @ID TYP LOC. @UQ PH ID-SUPP BP.NAME BP.MDATE BP.DESC TOTAL BP.SIZE @WIDE PH ID-SUPP BP.NAME BP.MDATE BP.DESCW TOTAL BP.SIZE When I enter "LIST BP" at ECL the "@UQ" phrase is used. However, when I enter "LIST BP @WIDE" at ECL nothing is displayed except the @ID. I've noticed this with all the tables I brought over from UniVerse. I've read the documentation pretty thoroughly and it works just fine on UV. In addition, it works fine in UD if I enter "LIST BP ID-SUPP BP.NAME BP.MDATE BP.DESCW TOTAL BP.SIZE". Does anyone know what I missed? Then again, maybe it's just late and I'm fumbling with the use of those brutal, outdated tools. :-) Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] T-DUMP
Kate: > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Kate Stanton > Sent: Saturday, December 24, 2005 6:50 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] T-DUMP > > Is there any reason why you can't make a DOS (UV type 19) > file out, move it around however you like, and read it back into UD?Kate: Some data can be copied this way. However, when record keys are moved to a type 19 DOS file they're changed from, for example, 192*16 to 192%A16; which is a real pain. Most of our software is upgraded from within the mvDbms environment, as we do this simply by building all changes into a single file with a key of [DICT*]FileName*ItemID; old standard PICK stuff. But without T-DUMP/T-LOADs, this process needs to be reengineered and all kinds of issues arise. Most of our customers no longer have either tape drives or floppies and do backups to other drives and C/Ds and DVDs. What used to be simple is now becoming a convoluted mess. Oh well, that's what it's like working with 1980 technology. :-( So, now I have to copy some stuff via DOS files and some via wIntegrate. Anyway, thanks for the ideas. Bill >> Can anyone tell me how to define and assign a "virtual >> tape file" so I can T-DUMP from UV and T-LOAD onto UD? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] T-DUMP
I never thought that would work. So I tried it and you're right. In fact, I copied a D3 item to a network share, pointed to by a UV VOC item, then copied it out to a UV type 18 file and the values and subvalues were retained! This certainly provides a "work-around". :-) It's going to be tough to move data from one machine to another, not on the same network! Thanks Ed. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Thursday, December 22, 2005 1:59 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] T-DUMP > > An easier way might be to copy the items into a type-19 file > under universe, transfer it to the unidata machine, and copy > it into a hashed file there. This might fail if the file > contains special characters or has odd characters in the ids, > but for most files it should work. > Is your universe install on windows or unix? If you're on > windows, I think you're out of luck trying T-DUMP. If I > recall correctly, there is no way on windows to create a > "virtual tape" that universes can use. > Uvbackup has a -t filename option that lets it go to a file, > but T-DUMP does not. > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of > > [EMAIL PROTECTED] > > Sent: Thursday, December 22, 2005 4:09 PM > > To: u2-users@listserver.u2ug.org > > Subject: Re: [U2] T-DUMP > > > > > > I hate to do this, but here goes: > > > > Do you *have* to use T-DUMP? > > > > I would be more inclined to write a routine to create a > delimited text > > file, then compress the file, ftp to and uncompress it on the UD > > machine, then reverse the process... > > Just my two (or less) bits. > > > > Karl > > > > > > > > > I posted this once before and have checked with some > other experts. > > > However, we're coming up empty and hope someone has > experience with > > > this. > > > > > > I want to T-DUMP a file from UniVerse and T-LOAD it onto > > UniData. As > > > we don't use tapes anymore I need to create some kind of > > virtual tape > > > file. > > > > > > In D3 I'd do the following: > > > > > > :DEV-MAKE -T TAPE -A "E:\Backups\DiskBackup,p" > > > :SET-DEVICE 3 <-- assuming the above command created > > device#3 :T-REW > > > :T-DUMP CUSTOMERFILE > > > :T-REW > > > :T-DET > > > > > > This "E:\Backups\DiskBackup" file could then be handled > > like any other > > > file and sent to another D3 machine (either NT or Linux > > although the > > > commands are > > > slightly different for D3Linux). There, one could: > > > > > > :DEV-MAKE -T TAPE -A "D:\DiskBackup,p" > > > :SET-DEVICE 4 <-- assuming the above command created > > device#4 :T-REW > > > :T-LOAD CUSTOMERFILE > > > :T-REW > > > :T-DET > > > > > > The first two steps are what we're having problems with; > defining a > > > device and attaching it before we execute the "tape" > > commands. We've > > > found that UniAdmin doesn't create a &DEVICE& file properly > > and when > > > we adjust the &DEVICE& item and try: > > > > > > ASSIGN DiskBackup TO MTU 0 > > > Error, cannot get tape device configuration (87). > > > > > > We know UniAdmin will do a full, daily, or weekly backup > > directly to > > > any file (including path) we want; so UniAdmin knows how to > > define and > > > assign (or assign and attach) a Windows file path. > > > > > > Can anyone tell me how to define and assign a "virtual tape > > file" so I > > > can T-DUMP from UV and T-LOAD onto UD? > > > > > > As always, I appreciate any help anyone can offer. :-) > > > > > > Bill Haskett > > > Advantos Systems, Inc. > > > www.advantos.net > > > (760)944-5570 (CA) > > > (360)923-4838 (WA) > > > --- > > > u2-users mailing list > > > u2-users@listserver.u2ug.org > > > To unsubscribe please visit http://listserver.u2ug.org/ > > > > > > > > > -- > > karl > > > > _/ _/ _/ _/_/_/ __o > > _/ _/ _/ _/_/ _-\<._ > >_/_/_/ _/_/_/ (_)/ (_) > > _/ _/ _/ _/ .. > > _/ _/ arl _/_/_/ _/ earson[EMAIL PROTECTED] > > > > -- > > IT Director, ATS Industrial Supply, Inc. > http://www.atsindustrial.com > > Toll-free: 800-789-9300 x29 > > Direct2Desk: 801-978-4429 > > Facsimile: 801-972-3888 > > -- > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] T-DUMP
I posted this once before and have checked with some other experts. However, we're coming up empty and hope someone has experience with this. I want to T-DUMP a file from UniVerse and T-LOAD it onto UniData. As we don't use tapes anymore I need to create some kind of virtual tape file. In D3 I'd do the following: :DEV-MAKE -T TAPE -A "E:\Backups\DiskBackup,p" :SET-DEVICE 3 <-- assuming the above command created device#3 :T-REW :T-DUMP CUSTOMERFILE :T-REW :T-DET This "E:\Backups\DiskBackup" file could then be handled like any other file and sent to another D3 machine (either NT or Linux although the commands are slightly different for D3Linux). There, one could: :DEV-MAKE -T TAPE -A "D:\DiskBackup,p" :SET-DEVICE 4 <-- assuming the above command created device#4 :T-REW :T-LOAD CUSTOMERFILE :T-REW :T-DET The first two steps are what we're having problems with; defining a device and attaching it before we execute the "tape" commands. We've found that UniAdmin doesn't create a &DEVICE& file properly and when we adjust the &DEVICE& item and try: ASSIGN DiskBackup TO MTU 0 Error, cannot get tape device configuration (87). We know UniAdmin will do a full, daily, or weekly backup directly to any file (including path) we want; so UniAdmin knows how to define and assign (or assign and attach) a Windows file path. Can anyone tell me how to define and assign a "virtual tape file" so I can T-DUMP from UV and T-LOAD onto UD? As always, I appreciate any help anyone can offer. :-) Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniData create file
Whew. I figured it out. The key was to create a DICT only file, then change the 1st attribute from "F" to "LF", then I can create the data files by: CREATE-FILE MULTIFILE PATCHES,BP 11,4 Sometimes life is good during these pesky conversions. :-) Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniData create file
I'm trying to create a UniData multi-level file (v7.1). I was able to create a multi-level directory by: 1) changing field# 1 of the (VOC) "BP" item to LD 2) CREATE.FILE MULTIDIR BP,CUSTOM I cannot yet create a multi-leveled hashed file by: 1) changing field#1 of the (VOC) "PATCHES" item to LF 2) CREATE.FILE MULTIFILE PATCHES,BP 11,4 errno=2: No such file or directory Open PATCHES\BP error, CREATE.FILE failed. but yet there is a PATCHES dictionary and data: :AE VOC PATCHES Top of "PATCHES" in "VOC", 3 lines, 20 characters. *--: P 001: LF 002: PATCHES 003: D_PATCHES Bottom. CREATE.FILE Syntax CREATE.FILE [DICT | DATA] [DIR | MULTIFILE | MULTIDIR] filename [,subfile] [modulo [,block.size.multiplier]] Can anyone help me with the correct syntax? Thanks. Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] @variable for add/delete flags
Does either of the U2 products have an '@' variable to identify if the @RECORD read into a trigger program is a new record or a record being deleted? Thanks Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Best practice for Sequential IDs using TRANSACTION START & COMMIT/R...
Charles: But this doesn't solve the problem of missing sequence numbers if the TRANSACTION doesn't commit. :-( Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett > Sent: Thursday, June 16, 2005 11:57 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Best practice for Sequential IDs using > TRANSACTION START & COMMIT/R... > > Charles: > > I'm thinking of instead of a: > > READVU SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . > ...test for existence and get the next unique value ...update > record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 > > do something like: > > LOCK 50 > READV SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . > ...test for existence and get the next unique value ...update > record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 UNLOCK 50 > > Then make sure this is either an include or a subroutine used > by everything that needs a particular unique sequence no. In > this case, everyone gets the momentary lock they need and > transaction bracketing doesn't break the locking mechanism. > > Bill > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, > > Charles > > Sent: Wednesday, June 15, 2005 8:55 PM > > To: u2-users@listserver.u2ug.org > > Subject: RE: [U2] Best practice for Sequential IDs using > TRANSACTION > > START & COMMIT/R... > > > > From: Bill Haskett > > > I wonder if the same issue (transactions don't release > record locks > > > until they're committed) applies to the LOCK/UNLOCK statement? > > > > No, those are independent of transactions. > > So could they be leveraged for the question posed here? > > . . . I don't see it. > > > > cds > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Best practice for Sequential IDs using TRANSACTION START & COMMIT/R...
Charles: But this doesn't solve the problem of missing sequence numbers if the TRANSACTION doesn't commit. :-( Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett > Sent: Thursday, June 16, 2005 11:57 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Best practice for Sequential IDs using > TRANSACTION START & COMMIT/R... > > Charles: > > I'm thinking of instead of a: > > READVU SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . > ...test for existence and get the next unique value ...update > record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 > > do something like: > > LOCK 50 > READV SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . > ...test for existence and get the next unique value ...update > record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 UNLOCK 50 > > Then make sure this is either an include or a subroutine used > by everything that needs a particular unique sequence no. In > this case, everyone gets the momentary lock they need and > transaction bracketing doesn't break the locking mechanism. > > Bill > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, > > Charles > > Sent: Wednesday, June 15, 2005 8:55 PM > > To: u2-users@listserver.u2ug.org > > Subject: RE: [U2] Best practice for Sequential IDs using > TRANSACTION > > START & COMMIT/R... > > > > From: Bill Haskett > > > I wonder if the same issue (transactions don't release > record locks > > > until they're committed) applies to the LOCK/UNLOCK statement? > > > > No, those are independent of transactions. > > So could they be leveraged for the question posed here? > > . . . I don't see it. > > > > cds > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Best practice for Sequential IDs using TRANSACTION START & COMMIT/R...
Charles: But this doesn't solve the problem of missing sequence numbers if the TRANSACTION doesn't commit. :-( Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett > Sent: Thursday, June 16, 2005 11:57 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Best practice for Sequential IDs using > TRANSACTION START & COMMIT/R... > > Charles: > > I'm thinking of instead of a: > > READVU SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . > ...test for existence and get the next unique value ...update > record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 > > do something like: > > LOCK 50 > READV SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . > ...test for existence and get the next unique value ...update > record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 UNLOCK 50 > > Then make sure this is either an include or a subroutine used > by everything that needs a particular unique sequence no. In > this case, everyone gets the momentary lock they need and > transaction bracketing doesn't break the locking mechanism. > > Bill > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, > > Charles > > Sent: Wednesday, June 15, 2005 8:55 PM > > To: u2-users@listserver.u2ug.org > > Subject: RE: [U2] Best practice for Sequential IDs using > TRANSACTION > > START & COMMIT/R... > > > > From: Bill Haskett > > > I wonder if the same issue (transactions don't release > record locks > > > until they're committed) applies to the LOCK/UNLOCK statement? > > > > No, those are independent of transactions. > > So could they be leveraged for the question posed here? > > . . . I don't see it. > > > > cds > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Best practice for Sequential IDs using TRANSACTION START & COMMIT/R...
Charles: But this doesn't solve the problem of missing sequence numbers if the TRANSACTION doesn't commit. :-( Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett > Sent: Thursday, June 16, 2005 11:57 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Best practice for Sequential IDs using > TRANSACTION START & COMMIT/R... > > Charles: > > I'm thinking of instead of a: > > READVU SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . > ...test for existence and get the next unique value ...update > record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 > > do something like: > > LOCK 50 > READV SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . > ...test for existence and get the next unique value ...update > record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 UNLOCK 50 > > Then make sure this is either an include or a subroutine used > by everything that needs a particular unique sequence no. In > this case, everyone gets the momentary lock they need and > transaction bracketing doesn't break the locking mechanism. > > Bill > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, > > Charles > > Sent: Wednesday, June 15, 2005 8:55 PM > > To: u2-users@listserver.u2ug.org > > Subject: RE: [U2] Best practice for Sequential IDs using > TRANSACTION > > START & COMMIT/R... > > > > From: Bill Haskett > > > I wonder if the same issue (transactions don't release > record locks > > > until they're committed) applies to the LOCK/UNLOCK statement? > > > > No, those are independent of transactions. > > So could they be leveraged for the question posed here? > > . . . I don't see it. > > > > cds > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Best practice for Sequential IDs using TRANSACTION START & COMMIT/R...
Charles: But this doesn't solve the problem of missing sequence numbers if the TRANSACTION doesn't commit. :-( Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett > Sent: Thursday, June 16, 2005 11:57 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Best practice for Sequential IDs using > TRANSACTION START & COMMIT/R... > > Charles: > > I'm thinking of instead of a: > > READVU SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . > ...test for existence and get the next unique value ...update > record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 > > do something like: > > LOCK 50 > READV SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . > ...test for existence and get the next unique value ...update > record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 UNLOCK 50 > > Then make sure this is either an include or a subroutine used > by everything that needs a particular unique sequence no. In > this case, everyone gets the momentary lock they need and > transaction bracketing doesn't break the locking mechanism. > > Bill > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, > > Charles > > Sent: Wednesday, June 15, 2005 8:55 PM > > To: u2-users@listserver.u2ug.org > > Subject: RE: [U2] Best practice for Sequential IDs using > TRANSACTION > > START & COMMIT/R... > > > > From: Bill Haskett > > > I wonder if the same issue (transactions don't release > record locks > > > until they're committed) applies to the LOCK/UNLOCK statement? > > > > No, those are independent of transactions. > > So could they be leveraged for the question posed here? > > . . . I don't see it. > > > > cds > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Best practice for Sequential IDs using TRANSACTION START & COMMIT/RO...
Clif: Since I've been in both the accounting and information systems fields for over 25 years, I can't say as I understand the term "...non-information content, sequentially assigned, record counter". I'm sure it doesn't mean what I think it does as I've found sequential counters to be an invaluable tool in a number of auditing scenarios. However, it's always possible I could use a good flogging. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Clifton Oliver > Sent: Wednesday, June 15, 2005 10:49 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Best practice for Sequential IDs using > TRANSACTION START & COMMIT/RO... > > I just can't keep quiet any more. > > Any auditor who depends on a non-information content, > sequentially assigned, record counters as an audit trail > ought to be flogged and sent back to Auditing For Dummies. If > your auditor demands that, I'd suspect they are a paper-based > bean counter, not an Information Systems Auditor. > > > -- > > Regards, > > Clif > > Member ISACA > www.isaca.org > > ~~~ > W. Clifton Oliver, CCP > CLIFTON OLIVER & ASSOCIATES > Tel: +1 619 460 5678Web: www.oliver.com > ~~~ > > > On Jun 15, 2005, at 8:47 PM, Stevenson, Charles wrote: > > > Missing sequential numbers isn't important to me, but it's a good > > point for general discussion. > > > > cds > > > > From: Bruce Nichol > >> This is all well and good if the "commit" goes ahead, but if > >> "rollback" is the action, don't you lose a supposedly sequential > >> "root key" into the vapours? > >> > >> Never to be seen again? > >> > >> That'd make an auditor go spare. "61,62,63,65,66... Hang on! > >> Where's > >> 64? Stop the presses! Everybody down and look for 64..." > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Best practice for Sequential IDs using TRANSACTION START & COMMIT/RO...
Charles: No, you guys aren't the only ones. This is a pretty miserable hole in the mvDbms functionality. However, since we've been writing this stuff for years the routines are already built to solve our problems. I just didn't know TRANSACTION bracketing was going to break them. Unknowns like this are the reason we haven't implemented transactions, as we haven't been eager to rework some core functions in our application. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Stevenson, Charles > Sent: Wednesday, June 15, 2005 8:53 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Best practice for Sequential IDs using > TRANSACTION START & COMMIT/RO... > > Would this be a worthwhile enhancement request through U2UG? > Are Ken and I the only ones whining about this: --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Best practice for Sequential IDs using TRANSACTION START & COMMIT/R...
Charles: I'm thinking of instead of a: READVU SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . ...test for existence and get the next unique value ...update record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 do something like: LOCK 50 READV SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . ...test for existence and get the next unique value ...update record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 UNLOCK 50 Then make sure this is either an include or a subroutine used by everything that needs a particular unique sequence no. In this case, everyone gets the momentary lock they need and transaction bracketing doesn't break the locking mechanism. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Stevenson, Charles > Sent: Wednesday, June 15, 2005 8:55 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Best practice for Sequential IDs using > TRANSACTION START & COMMIT/R... > > From: Bill Haskett > > I wonder if the same issue (transactions don't release record locks > > until they're committed) applies to the LOCK/UNLOCK statement? > > No, those are independent of transactions. > So could they be leveraged for the question posed here? > . . . I don't see it. > > cds > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Best practice for Sequential IDs using TRANSACTION START & COMMIT/R...
Charlie: I wonder if the same issue (transactions don't release record locks until they're committed) applies to the LOCK/UNLOCK statement? Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Tuesday, June 14, 2005 4:25 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Best practice for Sequential IDs using > TRANSACTION START & COMMIT/R... > > Chuck, > > I've not worked with transactions, so I may be whizzing in > the wind here. > Could you call NEXT.AVAIL.ID before TRANSACTION START, and > again after the transaction rollback, assuming you can detect > if the transaction was rolled back? > If the transaction committed, then no further action would be > required. > > Charlie > > In a message dated 6/12/2005 3:46:58 PM Central Standard > Time, [EMAIL PROTECTED] writes: > > Charlie, > > I don't see how that addresses the TRANSACTION problem. > If the call to your NEXT.AVAIL.ID routine happens after > TRANSACTION START, the id control item will not be updated > nor will its lock be released until TRANSACTION COMMIT (or > rollback) is executed, even though the NEXT.AVAIL.ID routine > says to write and release it. This is a potential > bottleneck if other concurrent processes are wanting to do > the same, waiting for that control item. > > cds > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Recommendations for reporting tools
Clif and David: Don't let the Raining Data price fool you. Mv.NET will offer the same thing for a ___LOT___ less! I'm testing out SQL Reporting services using ODBC and it works nicely. At this point it's free. I'm going to be testing it with OleDB shortly. Still, at this point it's free or, as Microsoft says, at no additional charge. :-) Mv.NET will be a lot cheaper than PDP.NET Reporting services but I can't say for sure until I start using it. Anyway, with what I've been testing, SQL Reporting Services is so good I can't imagine why anyone would develop with anything else. Tomorrow may change though. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Monday, June 06, 2005 2:23 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Recommendations for reporting tools Microsoft SQL Reporting Services is a good product and I think it is Rainingdata that is providing an interface between MV and SQL Reporting Services. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Tuesday, 7 June 2005 7:04 AM To: u2-users@listserver.u2ug.org Subject: [U2] Recommendations for reporting tools One of my clients has asked me what reporting tools, other than Crystal Reports other U2 shops favor. Any recommendations of what they might want to evaluate? Thanks in Advance. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Printing from UniVerse
Charlie: It's funny you should raise Microdata. I was taught to never use EQUATEs unless I wanted to create a relationship between both sides of the equation. e.g I'd use the following: EQUATE APFILE$CUSTDATE TO APFILEREC(1) This would allow me to manipulate either side of the equate and know both sides would maintain their common value. I could MATREAD the APFILEREC and would know that the variable APFILE$CUSTDATE would be assigned appropriately. I could change the variable APFILE$CUSTDATE and know the record array would be updated simultaneously, so I could then just MATWRITE the APFILEREC and be done with it. However, with "EQUATE VM TO CHAR(254)" there is no such relationship, so I was taught not to do this as it wasn't the intention of the statement (even though I could). I think I was taught by someone who was very particular about these kinds of things. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, June 05, 2005 8:22 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Printing from UniVerse I've worked with Jbase for several years, and, even though Jbase changes EQUATEs to assignments when it renders its C code, I still use EQUATE for CHAR(nn), FALSE and TRUE. Just long-term habits from the old Microdata days when we bummed CPU microseconds instead of today's picoseconds, and worried about runtime page faults. Regards, Charlie Noah In a message dated 6/3/2005 6:30:37 PM Central Standard Time, [EMAIL PROTECTED] writes: Actually I like them as assignments for the very reasons you posted. Namely that you can 'see' them when using RAID. Or maybe some day, the IBM system programmers will include an Equate table with the other compiler tables, that would be the best of both worlds, then RAID could look in that table as well, but the code could still be rendered at compile time. Will Johnson Fast Forward Technologies From: Stevenson, Charles [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) Yes , very helpful, but those should be EQUATEs, not assignments. Equates of quoted texts, CHAR(27), and even concatenations of these will all be resolved to strings by the compiler. Nothing gets executed at runtime. If the file as written were $INCLUDEd in a utility routine that gets called frequently, all those concatenations and assignments would happen each time. The only reason not to use EQUATEs that I can think of is for readability in VLIST, I_pgm listings, and RAID, where literal escape sequences are going to start appearing. From: Joe Walter Excellent! Thanks for the include code. Very helpful. - Original Message - From: <[EMAIL PROTECTED]> > 0001 *(HP.LASER) - HP LASER CODES > 0002 * > 0003 ESC = CHAR(27); *Escape Character [snip] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Uniobjects hack
JayJay: Neither one of these verbs are invoked if someone logs onto an account and goes directly to TCL (no menu desired). For instance, one creates a UO account with Q-Pointers, ON.ABORT, and a few other things to allow extraction of data. :-) The two functions you refer to are accessed, I believe, either via a BASIC error or a debug error. What I was referring to was D3 validates a user "at TCL" (and "at debug"). This way, the developer doesn't need to worry about all the ways this could happen, just that it happens. It doesn't matter whether it happens in the Unix or Windows implementation. Since I'm nowhere near as knowledgeable as I would like, I'm hoping I can find a solution to this sticky problem: from within U2 (and not from Unix this way and Windows that way), how can I guarantee only those I authorize, in the manner I authorize, can access resources? Along with "UOLOGIN" this information will always help. Thanks. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Jenkins Sent: Wednesday, June 01, 2005 1:01 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Uniobjects hack ON.ERROR ON.ABORT (and remote verbs) JayJay It's funny. D3 has the capability to assign a macro to any user who gets to tcl (or the debug prompt). Often this macro is either a login (again) or a logoff. Works great. U2 doesn't seem to have addressed this issue because their client base has never required it. Hopefully, now they do! Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Uniobjects hack
It's funny. D3 has the capability to assign a macro to any user who gets to tcl (or the debug prompt). Often this macro is either a login (again) or a logoff. Works great. U2 doesn't seem to have addressed this issue because their client base has never required it. Hopefully, now they do! Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Tuesday, May 31, 2005 12:40 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Uniobjects hack There were a few times that I've seen people exploit the fact that they knew how to cause the program to error out to get them to the prompt level. Then it was open season for them since we were just working off a menu based security. They were just trying to be more efficient in how they worked. Using the program took too long. It was faster just to edit the records. Was the reasoning. They couldn't get to the payroll account but they could have if they knew how to make a pointer to the files in that account. Things could have been worse. A few bill of materials and some pricing needed to be fixed but nothing major. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Les Hewkin Sent: Tuesday, May 31, 2005 9:29 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Uniobjects hack Can we have a quick show of hands of those who have had there U2 system hacked? I am not saying that it's not an issue, I am just curious. I do not know of it happening. Les -Original Message- From: Ian Renfrew [mailto:[EMAIL PROTECTED] Sent: 31 May 2005 13:33 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Uniobjects hack Even scarrier, if a person has telnet (almost definitely since its a OS supported application), a valid user id, password and knows how U2 works then they may be able to access data. No need to install UniObjects or purchase Excel. Depending on the version of UniData or network access, the user may be able to go as far as utilizing Windows Explorer to access / view UniData data. The user could use a file browser to view report information contained within the HOLD (_PH_ / &PH&) file. ... Ian - Original Message - From: "Les Hewkin" <[EMAIL PROTECTED]> To: Sent: Tuesday, May 31, 2005 6:09 AM Subject: RE: [U2] Uniobjects hack >I have been following this thread with great intrest. The issues seems to >be that if someone has Excel, UniObjects and knows how U2 works that they >can gain access to the data. > > Where are these people? Are they working for the IT department? > > Is this a real life scenario? or an exercise in theory of what might > happen? > > Les > -Original Message- > From: Piers Angliss [mailto:[EMAIL PROTECTED] > Sent: 31 May 2005 10:07 > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Uniobjects hack > > > JayJay, > > Reading between the lines I think you're saying a firewall could be a good > idea > > I'm not sure that the other methods will work though. As I understand the > problem, it is that you can have a secure VB App using UniObjects on a > secure PC but if I have access to Excel on that PC, together with a valid > server login id and password (with update rights) and basic knowledge of > the > directory structure on the server then techniques 2, 5, 6 & 7 won't > trouble > me at all. Ok, I need to understand UniObjects and U2. > > I'm not even sure that a firewall would help because the PC I'm trying to > hack the database from has a valid IP address to run the VB App > > As somebody looking to implement UniObjects alongside traditional > server-based applications that's a big hole. I can plug it by taking David > Jordan's advice and using AUTHORIZE, but that's a lot of work for me at > this > stage. > > It sounds like UOLOGIN is a step in the right direction, but it is only > available on UniData and if Ian's experience is any guide may have some > "implementation issues". > > I've been impressed with how easy it is to use UniObjects, I'm less > impressed now. The functionality is great but in too many cases it's just > a > hugely inviting route to hack the database, it needs better server-side > authentication > > Piers > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of John Jenkins > Sent: 30 May 2005 01:56 > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Uniobjects hack > > > Other techniques posted on the group will work as well - but to list a > few: > > 1. firewall with nominated IP address interconnectivity ONLY > 2. Restricted accounts with purged VOCs > 3. O.S level permissions (or Tivoli Access Manager) > 4. Triggers > 5. Account level controls (remote verbs etc) > 6. UO application-level authentication (suggest public key and > one-time-pad > for the serious - stops network sniffing) > 7. Restrict access to Windows client PCs - stop anyone from doing anything > untoward as t
RE: [U2] Uniobjects hack
Richard: Am I accurate in thinking Pick __USED__ to have file level security but it doesn't exist in the U2 products because, it was always said, the O/S takes care of security (aka: "we don't need no stinkin file level security")! Perhaps, having dbms security isn't such a bad idea after all. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Taylor Sent: Friday, May 27, 2005 8:09 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Uniobjects hack [snipped] 2) Convert the account to an SQL schema. You can then attach file level security via the SQL user. Just remember to create a security entry for Public too otherwise you could end up locking out all the other users that are not subject to the tighter security. (i.e. GRANT ALL TO PUBLIC) If you are trying to allow them to access a file, but control what they do you may be out of luck. However you could use triggers to a least create audits. [snipped] Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
