RE: [U2] Command that is the opposite of MATPARSE.
Mark: I don't believe this works in the U2 products. All those little niceties of D3 are not considered essential in U2. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Monday, October 02, 2006 4:14 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Command that is the opposite of MATPARSE. I don't know if this would work on U2 but as I was trying to remember this for D3, I simply equated them as such: DIM A(100) MATREAD A FROM FILE, ID ELSE STOP B=A PRINT A(49), B<49> My .001 cents. Mark Johnson - Original Message - From: "Kevin King" <[EMAIL PROTECTED]> To: Sent: Monday, October 02, 2006 6:53 PM Subject: RE: [U2] Command that is the opposite of MATPARSE. > >Just curious - Does anyone know if there is a command/function > >that will do just the opposite (of MATPARSE)? > > MATBUILD > > -Kevin > [EMAIL PROTECTED] > http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UD Basic Heading
I found a "work-around" for this. It seems there is a UniData bug with the BASIC Heading not being properly cleared from a called subroutine. My "work around" was to "EXECUTE \LISTPTR\ CAPTURING OUTPUT" at the end of the scrolling subroutine. Now, when the report generator calls a BASIC report subroutine, which captures a report with a BASIC heading, then passes it to a scroll subroutine, this scroll subroutine will now execute the aforementioned statement before returning to the report generator program that started the process. For some reason, the HEADING area gets cleaned up properly, which exiting the entire call stack would do too. Doing a "EXECUTE \LIST VOC 'VOC'\ CAPTURING OUTPUT" doesn't work. Don't know what it is with LISTPTR but it works. Aren't work-arounds great? Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Derwin Sent: Saturday, September 23, 2006 11:00 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UD Basic Heading Hi Bill, It's strange behavior with an easy fix: BPIOCP (all by itself) For example: 156: IF OUTPUT = 'SCREEN' THEN 157: BPIOCP ;* ALLOWS HEADERS & PAGING TO WORK 158: END ELSE 159: PRINTER ON 160: END "HELP BPIOCP" tells all. Hope this helps, Tom Derwin >>> [EMAIL PROTECTED] 09/23/06 11:41 AM >>> I'm using UD v7.1 on Win 2K3. An application we've converted from Pick is having some problems with the BASIC heading. We're running in Pick mode with the following options on: 2, 3, 7, 14, 15, 23, 32, 34, 43, 46, 48, 54, 56, 59, 64, 66, 75, 78, 83, 89, 91, 92, 104, 105, and 114. It seems if there's a UI structure like: Login > Run BP MainMenu > CHAIN SubMenu > Call ReportMenu > Call Report At the completion of each of the above the application moves back to the left one step. The problem I'm encountering is the BASIC heading isn't cleared from the subroutines until navigation moves all the way back to the "MainMenu" (out of the entire call process). For instance, I run a report, to the screen, with a BASIC heading in it. When the report is complete the user moves back to the ReportMenu. If I call a tcl shell subroutine that executes a list command, like "LIST VOC", the heading built in the report displays. Paging and cursor positioning is also corrupted as the next report I run in the Report process doesn't display properly either, nor are the screen display messages. It's as though the HEADING memory area isn't cleared upon completion of the called subroutine as it should and this interfers with all screen display. I should note, this doesn't happen in UV as the same software is running there. I've read the manuals, especially the UDT.OPTIONS manual, and can't find anything that would affect this. Does anyone know how to correct this? As always, thanks. Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Windows 2003 - Login Problem
Mac: Is UV certified on R2? I didn't think so. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat Sent: Tuesday, September 26, 2006 1:54 AM To: u2-users@listserver.u2ug.org Subject: [U2] Windows 2003 - Login Problem Hi, I wonder if anyone can help with this issue - We have a Windows 2003 R2 Server running UV 10.1.3 - The problem is that all users need to be setup as Administrative Users in order to be able to login to the telnet service. If they are setup as normal users in the AD, after entering the password, they lose connection. If anyone has a solution to this, please advise Thanks Mac -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.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] UniQuery SELECT WITH Limits
Charles: And some complain about the obtuse nature of "F" correlatives. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Monday, September 25, 2006 4:22 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2][UD] UniQuery SELECT WITH Limits Don't know about UD limits. Here's a workaround: Write a control record with the 251 different numbers that you are searching for. Then SELECT file WITH EVAL "SUBR( '!EQS', TRANS( controlfile, controlid, -1, 'X' ), REUSE( field.in.question ))" = "1" Something close to that, anyway. It loops through the entire file once (the expensive part), and does 251 comparisons for each record (not so sepenseive). cds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD Basic Heading
Thomas: Thanks. I'll give this a look. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Derwin Sent: Saturday, September 23, 2006 11:00 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UD Basic Heading Hi Bill, It's strange behavior with an easy fix: BPIOCP (all by itself) For example: 156: IF OUTPUT = 'SCREEN' THEN 157: BPIOCP ;* ALLOWS HEADERS & PAGING TO WORK 158: END ELSE 159: PRINTER ON 160: END "HELP BPIOCP" tells all. Hope this helps, Tom Derwin >>> [EMAIL PROTECTED] 09/23/06 11:41 AM >>> I'm using UD v7.1 on Win 2K3. An application we've converted from Pick is having some problems with the BASIC heading. We're running in Pick mode with the following options on: 2, 3, 7, 14, 15, 23, 32, 34, 43, 46, 48, 54, 56, 59, 64, 66, 75, 78, 83, 89, 91, 92, 104, 105, and 114. It seems if there's a UI structure like: Login > Run BP MainMenu > CHAIN SubMenu > Call ReportMenu > Call Report At the completion of each of the above the application moves back to the left one step. The problem I'm encountering is the BASIC heading isn't cleared from the subroutines until navigation moves all the way back to the "MainMenu" (out of the entire call process). For instance, I run a report, to the screen, with a BASIC heading in it. When the report is complete the user moves back to the ReportMenu. If I call a tcl shell subroutine that executes a list command, like "LIST VOC", the heading built in the report displays. Paging and cursor positioning is also corrupted as the next report I run in the Report process doesn't display properly either, nor are the screen display messages. It's as though the HEADING memory area isn't cleared upon completion of the called subroutine as it should and this interfers with all screen display. I should note, this doesn't happen in UV as the same software is running there. I've read the manuals, especially the UDT.OPTIONS manual, and can't find anything that would affect this. Does anyone know how to correct this? As always, thanks. Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. --- 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 Basic Heading
I'm using UD v7.1 on Win 2K3. An application we've converted from Pick is having some problems with the BASIC heading. We're running in Pick mode with the following options on: 2, 3, 7, 14, 15, 23, 32, 34, 43, 46, 48, 54, 56, 59, 64, 66, 75, 78, 83, 89, 91, 92, 104, 105, and 114. It seems if there's a UI structure like: Login > Run BP MainMenu > CHAIN SubMenu > Call ReportMenu > Call Report At the completion of each of the above the application moves back to the left one step. The problem I'm encountering is the BASIC heading isn't cleared from the subroutines until navigation moves all the way back to the "MainMenu" (out of the entire call process). For instance, I run a report, to the screen, with a BASIC heading in it. When the report is complete the user moves back to the ReportMenu. If I call a tcl shell subroutine that executes a list command, like "LIST VOC", the heading built in the report displays. Paging and cursor positioning is also corrupted as the next report I run in the Report process doesn't display properly either, nor are the screen display messages. It's as though the HEADING memory area isn't cleared upon completion of the called subroutine as it should and this interfers with all screen display. I should note, this doesn't happen in UV as the same software is running there. I've read the manuals, especially the UDT.OPTIONS manual, and can't find anything that would affect this. Does anyone know how to correct this? As always, thanks. Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] TEXT box subroutine
Sig: You're on the spot! :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen Sent: Friday, September 15, 2006 1:59 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] TEXT box subroutine I would really like it if all parties could give arguments to support their opinion of it: is it solid? Satisfying to the users? Supported or not on certain platforms? Working best or worst with certain types of programs? etc. I would help me and hopefully others cut through some time and efforts. Thanks in advance. Laure Hansen, City of Redwood City Information Technology www.redwoodcity.org 1017 Middlefield Road Redwood City, CA 94063 Tel: 650-780-7087 Fax: 650-556-9204 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dianne Ackerman Sent: Friday, September 15, 2006 12:29 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] TEXT box subroutine Wow, it's really something to say it's a "horrible tool for gui" without any explanation! We LOVE LOVE LOVE the Accuterm gui and switched our development from OpenInsight to Accuterm and have had nothing but success! -Dianne [EMAIL PROTECTED] wrote: >Accuterm, as we have found it, is a horrible tool for gui. You should >have check out OpenInsight. Real windows tool. > >But then eveyone has their favorites. > >DSig >David Tod Sigafoos >SigsSolutions, Inc. > > > > >> Original Message >>Subject: Re: [U2] [UV] TEXT box subroutine >>From: "Martin Phillips" <[EMAIL PROTECTED]> >>Date: Thu, September 14, 2006 9:32 am >>To: >> >>Hi Bob, >> >>Have you looked at AccuTerm as an alternative to Dynamic Connect. The >>associated GUI library is amazing. We were recently involved in >>conversion of a UniVerse application from character mode to GUI mode >>complete with mouse support and the major parts of the job took two >>people less than three days. >> >> >>Martin Phillips >>Ladybridge Systems >>17b Coldstream Lane, Hardingstone, Northampton NN4 6DB >>+44-(0)1604-709200 --- 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] [UV] UV.NET performance
Sorry, John...I was confused reading your post. You asked about UV.NET while I spoke of mv.NET. Again, sorry for the useless response. :-0 Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, September 08, 2006 6:48 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] UV.NET performance John: I'm guessing you're paying for support. So contact Bluefinity (or Tony G.). They always solve my problems. I run mv.NET on Unidata and it always runs great, and when it doesn't I call them and they tell me what I need to do to fix it. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Rodgers Sent: Friday, September 08, 2006 4:17 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] UV.NET performance uniVerse 9.6.1.6 Pick flavor running on HP-UX UV.NET has been in use here for some time. It was working fine until the production system was moved to a different box before my arrival. "Something" is now interfering with the UV.NET response times. Listing or selecting files via UV.NET now takes 'forever'. The UV.NET documentation does say... Performance. You should expect some decrease in performance when accessing remote files with UV/Net. But I think that what we are seeing is a symptom of an underlying problem. Can anyone advise of config settings or network or unix parameters which may be responsible ? Thanks John Rodgers -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.12.2/442 - Release Date: 9/8/2006 --- 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] [UV] UV.NET performance
John: I'm guessing you're paying for support. So contact Bluefinity (or Tony G.). They always solve my problems. I run mv.NET on Unidata and it always runs great, and when it doesn't I call them and they tell me what I need to do to fix it. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Rodgers Sent: Friday, September 08, 2006 4:17 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] UV.NET performance uniVerse 9.6.1.6 Pick flavor running on HP-UX UV.NET has been in use here for some time. It was working fine until the production system was moved to a different box before my arrival. "Something" is now interfering with the UV.NET response times. Listing or selecting files via UV.NET now takes 'forever'. The UV.NET documentation does say... Performance. You should expect some decrease in performance when accessing remote files with UV/Net. But I think that what we are seeing is a symptom of an underlying problem. Can anyone advise of config settings or network or unix parameters which may be responsible ? Thanks John Rodgers -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.12.2/442 - Release Date: 9/8/2006 --- 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] Show Empty Fields in Vertical Listing
Perry: Can't you do an EVAL in the selection? When I test this on UniData the blank field _DOES_ show up on a vertical listing. Go figure. :-0 Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Perry Taylor Sent: Tuesday, August 29, 2006 6:03 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2][UV] Show Empty Fields in Vertical Listing Hrm... That's a thought. Problem I see is then I would not be able to... LIST PTEMP WITH ZIP = "" Might be doable though as a secondary set of dictionary items specifically for this purpose. Thanks for the suggestion. Perry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: Tuesday, August 29, 2006 4:11 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2][UV] Show Empty Fields in Vertical Listing You could change the fields to an I type and have a formula something like this: I ZIP;IF @1 THEN @1 ELSE ' ' . . . etc This will put a space into the field so it will print. Tom Dodds [EMAIL PROTECTED] 513-563-2800 Cincinnati Office 708-234-9608 Chicago Office 630-235-2975 Anywhere Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Perry Taylor Sent: Tuesday, August 29, 2006 2:33 PM To: u2-users@listserver.u2ug.org Subject: [U2][UV] Show Empty Fields in Vertical Listing I can't seem to find a way to get UniVerse to display fields for which the record has no data when the listing goes vertically. Consider this example... LIST PTEMP "3" "4" CITY STATE ZIP 02:27:24pm 29 Aug 2006 PAGE1 PTEMP. CITY... STATE ZIP... 3 SALT LAKE CITY UT84119 4 OGDEN UT 2 records listed. But... LIST PTEMP "3" "4" CITY STATE ZIP VERTICALLY 02:28:02pm 29 Aug 2006 PAGE 1 PTEMP. 3 CITY.. SALT LAKE CITY STATE. UT ZIP... 84119 PTEMP. 4 CITY.. OGDEN STATE. UT 2 records listed. The ZIP field does not appear for record# 4. Does anyone know of a way to force them to show? Thanks Perry Taylor ZirMed 626 West Main St , 6th Floor b Louisville, KY 40202 CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. --- 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] Where's the beef??
Bob: Try "...\IBM\include\INFO_KEYS.INS.IBAS". Hope this helps. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Monday, August 21, 2006 5:27 PM To: U2-Users List Subject: [U2] Where's the beef?? Straight out of the online help is the following code: $INCLUDE SYSCOM INFO_KEYS.INS.IBAS IF SELECTINFO(3,IK$SLACTIVE) THEN READLIST LIST3 FROM 3 ELSE LIST3 = '' END Question I have is where the @[EMAIL PROTECTED] is SYSCOM located? I can't seem to find it anywhere. If not that then does anyone have the numeric values for SELECTINFO(x,???) 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/
RE: [U2] UD Tandem
Karl: Nope. Bill Haskett -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, August 18, 2006 10:56 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UD Tandem > > One of our clients runs an application all within BASIC. > There is no access to real ECL. They have a "tcl shell" > BASIC program to interface between the user and UD's ECL. > All input is controlled by: > [code snipped] > All has been working fine. However, when I "TANDEM" to a > port (port A tandems to port B) that's at the "tcl shell", > enter [Ctrl]+F to enter "feed" mode, then enter a command > in port A the [Enter] key seems to be stripped (or changed > to an up arrow), so the command isn't executed. I have to > press [Enter] in port B for the typed in command to execute. > > However, if I get to real ECL on both ports there is no such problem. Is > there a reason for this, or, better yet, is there a way around it? I've > tried using [Ctrl]+M but that's just the same as [Enter]. Try CTRL-J and see if that works. Karl --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UD Tandem
One of our clients runs an application all within BASIC. There is no access to real ECL. They have a "tcl shell" BASIC program to interface between the user and UD's ECL. All input is controlled by: LOOP ; ** UD version IF NOT(WaitTime) THEN ; ** UD version INPUT AsciiChar,1: UNFILTERED ; ** get a raw byteUD version END ELSE ; ** UD version INPUT AsciiChar,1: FOR WaitTime UNFILTERED THEN ; ** UD version NULL ; ** UD version END ELSE; ** UD version AsciiChar = WCHAR; ** UD version END ; ** UD version END; ** UD version DecChar = SEQ(AsciiChar); ** convert to decimalUD version HexStr := OCONV(AsciiChar, 'MX'); ** convert to hexUD version DecStr := DecChar : SP1 ; ** build decimal string UD version KeyStr := AsciiChar ; ** build ascii UD version UNTIL NOT(SYSTEM(14)) DO REPEAT All has been working fine. However, when I "TANDEM" to a port (port A tandems to port B) that's at the "tcl shell", enter [Ctrl]+F to enter "feed" mode, then enter a command in port A the [Enter] key seems to be stripped (or changed to an up arrow), so the command isn't executed. I have to press [Enter] in port B for the typed in command to execute. However, if I get to real ECL on both ports there is no such problem. Is there a reason for this, or, better yet, is there a way around it? I've tried using [Ctrl]+M but that's just the same as [Enter]. Thanks. Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: [U2] SV: [U2] Caché and UniVerse
Claus: Let us know how it works out. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Claus Derlien Sent: Tuesday, August 15, 2006 9:26 AM To: u2-users@listserver.u2ug.org Subject: [U2] SV: [U2] Cachi and UniVerse Thanks for quick replies, ill try the google group and see if that leads to something. Apparently Cachi is able to load in an account backup made with uvbackup, and that way you should be able to work with all your mv data in Cachi as well as you can continue to work with UniBasic. Looks like a really good product. Best regards from Denmark Claus Derlien --- 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] RE: Multivalued datatypes considered harmful | The Register
Tony: The general SQL rule is simple: if SQL then correct. However, the illogic of SQL proponents is often stunning, considering their membership in the scientific community. For instance, it is not true that "if A then B" logically infers "if NOT(A) then NOT(B)". But many in the SQL world insist this illogical inference...but then many in the SQL world never took Logic 101. :-) Bill P.S. Reviewing a link from that page took me to an interview with Jim Gray. It's interesting he should point out the following little gem, regarding "transactions": "Frankly, over 25 years there's been a lot of work in this area and not much success. Workflow systems have, by and large, come to the conclusion that what the accountants told us when we started was correct - the best thing you can do is have compensation if you run a transaction and something goes wrong. You really can't undo the transaction, the only thing you can do is run a new transaction that reverses the effects of that previous transaction as best you can." -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno Sent: Wednesday, July 19, 2006 3:23 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: Multivalued datatypes considered harmful | The Register Mike wrote: > http://www.regdeveloper.co.uk/2006/07/18/multivalued_datatypes_access/ That article summarizes with this final note: "So, my clear and certain advice to developers is not to use multi-valued fields. They have nothing to offer us except potential pain." This is also being discussed in comp.databases.pick. A couple people there have responded to The Register to let them know that this article is way off the mark. I highly recommend and request that someone from IBM send a similar note in support of the multi-valued concept. If nothing else this could serve as some free marketing in support of the U2 reseller community. I'm seriously hoping IBM isn't adverse to free marketing to a target audience of sales prospects... Tony Gravagno Nebula Research and Development TG@ removethisNebula-RnD.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: Synonym account
Thanks to all. @PATH will work fine. I just have to get my head around this a little (accounts to paths). :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, July 19, 2006 5:28 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD: Synonym account What if you used @PATH to get the full path? If you don't want the full path then just setup a subroutine or function to call and parse it out and return whatever you want. Hth Colin Alfke Calgary, Canada >-Original Message- >From: Bill Haskett > >How does one go about creating a synonym account. For >instance, I have an account > >E:\MyDirectory\Demo > >If I log into this directory, which I must do, the @WHO tells >me I'm logged into "DEMO". Makes sense. The path in the >(UD.ACCOUNT) file is "E:\IBM\ud71\Demo". So, if I want to log >into both accounts and want @WHO to reflect "MyDemo" in >"E:\MyDirectory\Demo" and "Demo" in the UniData demo account >how do I do it? I can't create a "MyDemo" item in >(UD.ACCOUNT) because I can't log into "MyDemo". > >Thanks. > >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] UD: Synonym account
How does one go about creating a synonym account. For instance, I have an account E:\MyDirectory\Demo If I log into this directory, which I must do, the @WHO tells me I'm logged into "DEMO". Makes sense. The path in the (UD.ACCOUNT) file is "E:\IBM\ud71\Demo". So, if I want to log into both accounts and want @WHO to reflect "MyDemo" in "E:\MyDirectory\Demo" and "Demo" in the UniData demo account how do I do it? I can't create a "MyDemo" item in (UD.ACCOUNT) because I can't log into "MyDemo". Thanks. Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV - tech support
Tony: Just a couple of comments to follow up your excellent points. :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno Sent: Friday, July 07, 2006 2:05 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV - tech support TG: IBM is a publicly owned company and manages its IP assets in a consistent manner. As David says, this is NOT a democracy. That said, someone in the U2 group at IBM might have some latitude in this matter, so contact your IBM sales rep, your Support manager, or your U2 development contact and present your case or ask them who can help with making documentation available. (I don't know the corporate structure for U2 like I do other MV companies, sorry.) BH: That is what has precipitated this thread. Sales reps have been contacted. VARs have been contacted. Support is difficult to contact. Cases have been presented. Many have dealt with the corporate structure. Many are striving to improve the business arrangements. TG: Regarding paying to report bugs - c'mon, how long have you guys been in the IT world? I am all for open support whenever possible but there are business concerns where lines need to be drawn. Think about how expensive it is to have people answer the phone or email, and how many people abuse free services. Most of us in this industry include yearly maintenance fees as part of our normal business model. If you don't pay a vendor a support fee why do you think you are still entitled to the same support as those who do? Asking off-support customers to pay for services they use ensures that only those who are serious will get through. The offer to refund payment in the case of bugs might seem like an obvious thing to do, but in this world it's actually a generous practice that many companies do not employ. By a show of hands, how many people here pay their clients back if a bug is found in their software? I didn't think so... BH: Most, if not all, involved in this thread __are__ paying support fees. That's the irony of this all. As a side note, our company never charges for bug reports and go out of our way to track them down. TG: Regarding going through a VAR for support, I've been through this at RD. There are mixed blessings on the policy but in general it's a good policy. An informed VAR channel is a good VAR channel. BH: This may, or may not, be advantageous. The principal reason for business, which many in the IT industry are forgetful of, is there's a mutual benefit in engaging in a business relationship. The key concept here is "mutual". This thread exists because of, and the above comment illustrates, the one sided nature a business relationship can take, and the consequences such a turn can have. TG: I wish people would consider the larger business issues before complaining about policies. BH: Be careful what you wish for. :-) Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV - tech support
Where do I sign? :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Results Sent: Friday, July 07, 2006 11:06 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV - tech support A few notes: The problem with IBm is that IBM isn't IBM. It is a series of IBM-lets with separate management, budgets, constraints and objectives. The IBMers on this list won't likely take up this challenge because it is out of their jurisdiction. The only people who could address this are levels above our fellow community members. Here's what I would do: Get a petition to people who are going to the IOD (IBM Information On Demand) conference. Make it clear, clean, and non venomous. Get a lot of signatures, especially from people who are related to IBM. I'll suggest the text: === As active customers, VARs, consultants, and Partners of IBM, we are frustrated by the lack of a single login for accessing information from the IBM website. Having such a single login would decrease phone support calls and would speed resolution of customer issues, resulting in more satisfied customers at a lower cost per incident to IBM. We the undersigned see an obvious value to us in this approach and hope that you will see it, too. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ === Oh, and I'm going to the IOD conference and I would be honored to carry forward a clear, clean, *polite* petition. I can't assure you that I will find the right person to receive it, but I can commit to trying. How about it, people? - Charles Barouch [EMAIL PROTECTED] (718) 762-3884 x 1 P. O. Box 540957, Linden Hill, NY 11354-0957 www.KeyAlly.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] UV - tech support
Jerry: I feel your pain! For many, IBM support is non-existent, in spite of paying for it; i.e. difficult to access, non-verbal (no phone calls please), and excruciating to document. :-( But then, I don't get any alerts and am restricted to U2Connect. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Friday, July 07, 2006 7:28 AM To: u2-users@listserver.u2ug.org Subject: [U2] UV - tech support Why does IBM send me alerts that document information is available but after I get on their site they won't let me read it. I have a couple of different logins on their site and I never know which one is necessary to get to where. Why not have one login that allows you to get to what they want to let you get to and have done with it? One way I log in it's my email address and a special IBM assigned user ID, another is a user name created by me with a password created by me, and then there is another screen that asks for a user ID and password but it isn't any that I have already mentioned. Yes I have a support contract with IBM but the contact letter/number combination seems to change yearly and the IBM site keeps telling me that the contract number is not valid. When I do get logged in the sites display my name and company name correctly so what is the problem. Jerry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] MICR fonts with UniData
Colin: Your point is well made. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, June 28, 2006 7:17 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] MICR fonts with UniData [snipped] I just wanted to impress upon John that the MICR line had to be printed precisely. Colin "who dreams at least once a day for the paperless office" Alfke Calgary Canada --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] MICR fonts with UniData
Colin: Wow, we've only worked with Troy chips, the template, and HP printers. With about 75 - 100 printers out in the field we've yet to have to go through the process you described with the bank; and some of these printers have been out in the field for about ten years. When the bank receives checks they go through a MICR reader. Those that aren't read properly go into the reject pile. An operator then puts a white tape on the bottom of the check and manually enters the information that the reader missed (check# and bank account#) then enters the clearing amount. If there's a large number of rejections we hear about it immediately. However, we've never heard about any rejections in excess of the normal amount. We do, however, always use HP printers, always use TROY DIMM chips, and make it a point to purchase high-quality magnetic ink. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, June 27, 2006 11:46 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] MICR fonts with UniData John - it's critical. Normally, we do a run of 20 cheques that we give to the bank which sends them to its testing centre. About a month later we get them back with a report detailing anything that is incorrect. They measure things like: MICR clear band, MICR character skew, MICR line skew, horizontal character position, vertical character position, character print quality, correct data, enough magnetic ink, etc. When we bought the MICR dimm we got a template that shows where everything needs to print. Good luck Colin Alfke Calgary, Canada >-Original Message- >From: John Varney > >I was told that the placement of the routing and account >number is very important. Thanks Colin! --- 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] OLEDB connection string
Nick: I created a new datasource as follows: Shared Data Source: Name--: UDOleDBReports Type--: OLE DB Connection string: Provider=IBM.UniOLEDB.1;Data Source=asidevud Connection Properties (via the [Edit] button in above dialog): Data Source: OLE DB (OLE DB) OLE DB Provider: UniOLEDB Provider Enter a server or file name: Server of file name: asidevud (in the uci.config item) Location---: leave blank (this messed me up for awhile) Log on to the server: Use a specific user name and password User name: valid Windows/UniData user (also in UniAdmin > Network Service > UDTelnet Server > Users) Password-: valid Windows password for above user Allow saving password The connection string looks like: Provider=IBM.UniOLEDB.1;Data Source=asidevud;Persist Security Info=True;User ID=DataTrustNET I used the UCI Configurator to create the OleDB section. Although the tool seems to indicate this is only an ODBC tool the OleDB documentation, without mentioning it, assumed ODBC and OleDB sections are exactly the same. Hope this helps. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina Sent: Monday, June 26, 2006 12:04 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OLEDB connection string In the connection string, what is the Data Source? Is that the server that Universe resides on? What is the Location? Is that the account name? Is it the path to the account? No matter what values I put in these fields, I cannot get it to connect. Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Saturday, June 24, 2006 3:26 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OLEDB connection string Nick: When I access UniOleDB from SQL Reporting Services my connection looks like: Provider=IBM.UniOLEDB.1;Data Source=asidevud And my uci.config item, on my client machine, looks like: DBMSTYPE = UNIDATA NETWORK = TCP/IP SERVICE = udserver HOST = MyDevServer ACCOUNT = E:\MyApps\Demo USERNAME = MyUserNET Maybe this helps. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina Sent: Friday, June 23, 2006 1:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] OLEDB connection string Can anyone provide me with a sample unioledb connection string that I could use in my .NET code? Thanks, Nick Cipollina Pick Programmer ACS Heritage, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804)965-8294 --- --- 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] MICR fonts with UniData
John: Only if it's designed to do so. For instance, you can use the same DIMM chip on a 4000 & 4050. You need to contact them by going to www.troygroup.com. Or use Google to search for TROY DIMM chips. These chips are really very inexpensive. Some of the toner, on the other hand, is rather expensive. Depending on your output load, solutions are really inexpensive overall. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Varney Sent: Monday, June 26, 2006 11:47 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] MICR fonts with UniData I'm looking at that as one option. Do you know if those DIMMs can be used in more than one printer, for instance the laser printer with the DIMM goes down. Can I trnasplant the DIMM into another like printer (HP 8100, 9000, etc) to get checks out the door? -Original Message----- From: "Bill Haskett" <[EMAIL PROTECTED]> To: Date: Mon, 26 Jun 2006 10:51:46 -0700 Subject: RE: [U2] MICR fonts with UniData > John: > > Make you life easier and use a MICR font DIMM chip. They can be > purchased > from TROY and make programming much easier and are much more reliable. > :-) > > Bill > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of John Varney > Sent: Monday, June 26, 2006 4:44 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] MICR fonts with UniData > > Has anyone used a MICR soft font with UniData? I have a project to > print > checks and am wondering how other people hander the MICR font for > account > / routine numbers. Thanks. > --- > 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] MICR fonts with UniData
John: If you install a MICR DIMM chip into the printer you can print the available fonts. If it is not listed the normal TROY font is: [esc](0Q[esc](s1p12v0s0b0T Then simply reference this in your output stream, like: "[esc]&a650h7725V" to loca the printer cursor, then "[esc](0Q[esc](s1p12v0s0b0TC0012002524C A123456789A12 3456789 019C[esc]" ...where: 1) "C0012002524C" is the check ID used by the bank, 2) "A123456789" is the Federal Reserve and bank routing#, and 3) "12 3456789 019C" is the bank account#. Now reset the character set (or change the font) like "[esc](8U". Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Varney Sent: Monday, June 26, 2006 10:28 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] MICR fonts with UniData That's a good start. Thanks! How is the MICR loaded into flash memory? Is it part of a DIMM for the pritner or do you load it like a PCL soft font? Thanks! -Original Message- From: "Norman Morgan" <[EMAIL PROTECTED]> To: Date: Mon, 26 Jun 2006 10:48:09 -0500 Subject: RE: [U2] MICR fonts with UniData > We do this. Our check stock is regular check safety paper with both > top > and bottom stubs. The center section has the security patterns, > microprinting, etc., along with a color logo. Everything else added by > the laser printer when we do the check printing with a UniBasic > program. > The printer has a MICR font stored in flash memory, along with a form > overlay image and uses a MICR toner cartridge. The program lays out > the > text for the check, shifting in and out of the MICR font as > appropriate, > then just before adding a form feed, it sends the escape sequences to > call the forms overlay which is stored as a PCL macro in the printers > flash memory. > > Here are some code snips from the program: > > *** Define control info for laser printers > ESC = CHAR(27); FORMFEED = CHAR(12) > FORM.DEF = ESC:"&f112Y" > FORM.CALL = ESC:"&f3X" > SET.FONT.COURIER = ESC:"(10U":ESC:"(s0p10h0s0b4099T" > SET.FONT.MICR = ESC:"(10O":ESC:"(s0p8.00h11.0v0s0b70T" > SET.FONT.LINE.PRT = ESC:"(10U":ESC:"(s0p16.67h8.5v0s0b0T" > PRINTER.RESET = ESC:"E" > SET.PRINTER.LANDSCAPE = ESC:"&l2a0o6d0S" > SET.PRINTER.PORTRAIT = ESC:"(&l2a1o0S" > PRINTER.FORM.SET = SET.PRINTER.LANDSCAPE : SET.FONT.COURIER > PRINTER.FORM.SET := ESC:"&l1e64F":FORMFEED > > GOSUB PrintTopStub > GOSUB PrintCheckBody > GOSUB PrintBottomStub > GOSUB PostGoodCheck > PRINT FORM.DEF: > PRINT FORM.CALL: > PRINT FORMFEED: > > PrintCheckBody: > *** Codes to position on form ** > PRINT ESC:"&a2585v5328H": > PRINT CKNO"R%6" > PRINT " ":CKNO"R%6":" ":OCONV(DATE(),"D2/")"R#8":" ":VNO"L#7" > PRINT > PRINT > PRINT > NET = TOT(3) > GOSUB BuildWordAmount > PRINT SPACE(4):WORD "L#80" > PRINT; PRINT > IF NET+0 = 0 THEN NET = "000" > PRINT SPACE(65):OCONV(NET,"MD2")"R2,*14" > PRINT > PRINT > PRINT SPACE(11):VEND<1> "L#40" > PRINT SPACE(11):VEND<2> "L#40" > IF VEND<3> # "" THEN PRINT SPACE(11):VEND<3> "L#40" > IF VEND<4> # "" THEN PRINT SPACE(11):VEND<4> "L#40" > PRINT SPACE(11):VEND<5,1>:' ':VEND<5,2>:' ':VEND<5,3> > *** Select MICR font & Position MICR line to Check # > PRINT SET.FONT.MICR: > PRINT ESC:"&a4730v1020H": > *** Print Check Number > PRINT CHAR(47):CKNO"R%6":CHAR(47):" ": > *** Print Routing Number > PRINT CHAR(38):ROUTING.NUM:CHAR(38):" ": > *** Print Account Number > PRINT ACCOUNT.NUM:CHAR(47): > *** Switch back to Courier Font > PRINT SET.FONT.COURIER: > RETURN > > === > Norman Morgan <> [EMAIL PROTECTED] <> http://www.brake.com > === > Why does mineral water that has trickled through mountains > for centuries have a 'use by' date? > === > > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker > > Sent: Monday, June 26, 2006 9:39 AM > > To: u2-users@listserver.u2ug.org > > Subject: RE: [U2] MICR fonts with UniData > > > > I thought you wanted it printed from Unidata? > > > > -Original Message- > > From: John Varney [mailto:[EMAIL PROTECTED] > > Sent: Monday, June 26, 2006 9:29 AM > > To: Jerry Banker > > Subject: RE: [U2] MICR fonts with UniData > > > > > > I wish I could do it that way, but the checks are coming > > directly from > > a unix box via a routine that uses PCL5 to format blank > > stock. As far as > > > > I can tell I have to either use a laser printer with the MICR font > > permanently installed or use an MICR soft type font that is loaded to > > the > > printer via PCL5 commands each time a c
RE: [U2] MICR fonts with UniData
John: Make you life easier and use a MICR font DIMM chip. They can be purchased from TROY and make programming much easier and are much more reliable. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Varney Sent: Monday, June 26, 2006 4:44 AM To: u2-users@listserver.u2ug.org Subject: [U2] MICR fonts with UniData Has anyone used a MICR soft font with UniData? I have a project to print checks and am wondering how other people hander the MICR font for account / routine numbers. Thanks. --- 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] OLEDB connection string
Nick: When I access UniOleDB from SQL Reporting Services my connection looks like: Provider=IBM.UniOLEDB.1;Data Source=asidevud And my uci.config item, on my client machine, looks like: DBMSTYPE = UNIDATA NETWORK = TCP/IP SERVICE = udserver HOST = MyDevServer ACCOUNT = E:\MyApps\Demo USERNAME = MyUserNET Maybe this helps. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina Sent: Friday, June 23, 2006 1:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] OLEDB connection string Can anyone provide me with a sample unioledb connection string that I could use in my .NET code? Thanks, Nick Cipollina Pick Programmer ACS Heritage, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804)965-8294 --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How to connect file remotely
Kevin: I'm not sure this is even true. For instance, I have UV on my notebook computer. I have access to a "shared" Windows folder on another server. I've "mapped" this shared folder to my local UV notebook computer using the "Z:" drive letter. I now have access to this "shared" directory through Windows but __NOT__ via UniVerse. There are several steps I need to take to gain access (note: this is not UV/NET access which is another story). These steps, in UniVerse, are: 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" "Server" is the name of the remote Windows server. "U2Admin" is the Windows user who's logged in. "Passwd" is the Windows password for the "U2Admin" Windows user. 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. In UniData, as I understand it, one only has to create (VOC) pointers such as: U2TEMP 001 DIR 002 \\Server\Share\Temp 003 D_VOC If this is not accurate (or the least number of steps to achieve this) I'd sure like to know. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Friday, June 23, 2006 8:35 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] How to connect file remotely Actually, I don't believe that's true. That will give you access, but not lock support. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Angelo Collazo Sent: Friday, June 23, 2006 7:35 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] How to connect file remotely Eugene, All you simply need to do is share your laptop drive and map it on the network with the path info. Hope this helps. Cheers, Angelo Collazo System Administrator Silver Line Building Products Corporation One Silver Line Drive North Brunswick NJ, 08902 [EMAIL PROTECTED] Ph: 732.435.1000 X4495 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Eugene Perry Sent: Thursday, June 22, 2006 6:42 PM To: u2-users@listserver.u2ug.org Subject: [U2] How to connect file remotely Hello, I am using a copy of Universe PE on my laptop and I am interested in accessing a file over the network. Is there anyway to do that and how? Thanks Eugene --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata 6 into SQL 2005
Steve: Perhaps "VSG" is what you're looking for. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, June 22, 2006 9:25 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata 6 into SQL 2005 We have a homegrown process where a cron job runs a nightly script that calls basic programs which create comma-delimited text files. Then a windows server runs a scheduled task to ftp the files to that server. Then a DTS script loads the SQL tables with the data. The problem is that the user wants us to "type" the data (dates mostly). Is there a way to do this with our current process? Thanks in advance. Steve Kunzman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Janet Bond Sent: Thursday, June 22, 2006 10:24 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata 6 into SQL 2005 [ad] Hello Graham, We have many customers moving MultiValue data to SQL Server or relational databases. We have two products, FusionWare Relational ODBC Driver Edition or FusionWare Direct mv2SQL. These two products have less developer time required If you have VB developer skills accessible to you could consider FusionWare OLEDB driver or FusionWare Direct ADO.Net Provider as an approach to this project. Just a note, the more code you include with your project you create an increased internal support factor as well. IF you are moving the data in one direction MultValue to Relational then I suggest you use the mv2SQL product it is much faster and uses newer technology (OLEDB) and has User Interface for setting up transfers. Lastly this product can be scheduled in SSIS or DTS. As you may be aware when using an ODBC technology the data is flatten during the transfer process, this has a performance penalty. Good Luck Janet Bond [/ad] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Angelo Collazo Sent: Wednesday, June 21, 2006 8:40 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata 6 into SQL 2005 Graham, If you are running your U2 database under Windows, You can download the CLIENT(s) and use the native U2 ODBC drivers. See this link: http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=u2trial s&S_ TACT=105AGX11&S_CMP=DNLD If your are running under UNIX you to purchase one. Two I know of. 1- http://www.easysoft.com/ 2- http://www.datadirect.com/index.ssp 3- Open source (http://www.mysql.com/) and search for ODBC. Two versions UNIX(AIX/HP/Others) and Linux unixODBC) May the force be with you. Cheers, Angelo Collazo System Administrator Silver Line Building Products Corporation One Silver Line Drive North Brunswick NJ, 08902 [EMAIL PROTECTED] Ph: 732.435.1000 X4495 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, June 21, 2006 9:22 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata 6 into SQL 2005 Does anyone have any advice for which odbc drivers are best for importing Unidata data into a SQL 2005 database? Thanks Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: Tuesday, June 20, 2006 2:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] .net - universe 10.1.14 Redback and .Net work perfectly together. I've used it in a variety of applications using both C# and VB.Net. Full power of .Net is available as Redback simply makes U2 available. You can build a Data Access Layer where U2 looks like any other database to .Net. If you are from the .Net/SQL world, you can access your Universe data via ADO same as other databases. If you are not an ADO guru, Redback provides its' own more U2 friendly commands to also access the Universe data and programs. You have total freedom in deciding how much or how little of your business logic to be in U2 or .Net. Unlike like some of the other offerings, Redback is not a 'do something on the web for the U2 programmer' type of application. It is a true enabler to allow you to use U2 with the web and do whatever you can do in your web technology of choice. Mike. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Tuesday, June 20, 2006 3:30 AM To: U2-Users (E-mail) Subject: [U2] .net - universe 10.1.14 Apologies I asked this before then went on tour for 3 weeks and my wonderfull staff cleared by emails So I am looking to tie Universe 10.1.14 to a .net development I am looking at biztalk and redback and one other piece of software to facilitate this Any experiences/opinions will be gratefully received (and read this time) Bob Witney IT Senior EXPLORE! Nelson House 55 Victoria Road Farnborough Hampshir
[U2] UD: HEADING page#
I have a question regarding UD v7.1 (Windows, Pick mode): 1) Is there a little trick to get the UniQuery page # left justified? "LIST VOC SAMPLE 5 HEADING "THIS IS PAGE: 'PL'" ...returns THIS IS PAGE: 1 VOC. WIN.PCRUN2 A9 WIN.SETPARAM LIST.LABEL IN 5 records listed I'm looking for the heading to look like: "THIS IS PAGE: 1". The page number is right-justified in a field of four blanks. In D3 I need to add the N option (e.g. "THIS IS PAGE: 'PNL'"). Thanks, Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniDebugger
Two months ago I was trying to update a program, using UniDebugger, on a remote server using the "Disk" Read/Write method and couldn't because the Unidata server directory has a minimal amount of security. I was able, however, to update the program using the "UniObjects" Read/Write method by entering the server name and credentials. Today, this no longer works. When I try to edit a program on the remote UniData server, using UniObjects, I get an "Unable to connnect to the host (39207)" error. I know UniObjects is installed and set up properly because I have mv.NET installed and can connect to the remote UniData server via UniObjects using the exact same credentials (server name, username, and password) I'm attempting to use in UniDebugger. I've uninstalled and reinstalled UniDebugger. This didn't help. Does anyone know what could be causing this problem? Bill Haskett Advantos Systems, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] Inhibiting Access to Debugger
Perry: What about the ON.ABORT phrase in the (VOC)? Combined with user management, which I'm sure you've already built, this should do the trick. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Perry Taylor > Sent: Wednesday, June 07, 2006 7:52 AM > To: u2-users@listserver.u2ug.org > Cc: Chris Schremser; Robin Harrison > Subject: [U2][UV] Inhibiting Access to Debugger > > Does anyone know of a way to prohibit selected users in an > account from gaining access to the debugger while still > allowing all users to break out of the application? > > Thanks. > > Perry Taylor > Zirmed, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] client ip
Craig: I fumbled with this (internal to UniData). *** GET.IP.ADDRESS: *** * IsNT = INDEX(OCONV(SYSTEM(33), 'MCU'), 'NT', 1) PORT.NO = OCONV(@UDTNO, 'MCU') IPAddress = "unknown" IF IsNT THEN IPAddress = SYSTEM(512) END ELSE UArray = LISTUSER() xHigh = DCOUNT(UArray, AM) FOR X = 1 TO xHigh ULine = UArray UPort = ULine<1,1> IF UPort = PORT.NO THEN IPAddress = ULine<1,7> EXIT END NEXT X END RETURN Hope this helps. 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 > Craig Peterson > Sent: Tuesday, June 06, 2006 11:43 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] client ip > > Is there a Unidata command for determining a client IP address? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Knowing where you have come from in a Unibasic subroutine
Martin: Try this: SUBROUTINE GET.CALLSTACK (ProgramStack) * ** Initialize local variables NULL$= '' ISNT = INDEX(OCONV(SYSTEM(33), 'MCU'), 'NT', 1) ProgramStack = NULL$ IF ISNT THEN PATH.SEP = "\" ELSE PATH.SEP = "/" * ** get the program CALL stack CallStack = SYSTEM(49) xHigh = DCOUNT(CallStack, @AM) FOR X = xHigh TO 1 STEP -1 BPName = CallStack LastV = DCOUNT(BPName, PATH.SEP) BPName = FIELD(BPName, PATH.SEP, LastV) BPName = TRIM(BPName[2,99]) IF BPName NE NULL$ THEN ProgramStack<1,-1> = BPName END NEXT X * ** remove itself from the stack ProgramStack = DELETE(ProgramStack, 1, 1) * RETURN END Hope this helps. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Martin Hutchinson > Sent: Tuesday, May 30, 2006 3:32 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] Knowing where you have come from in a Unibasic > subroutine > > I am looking for a command or method to determine where a > Unibasic subroutine has been called from. Something similar > to when you execute a debug statement and type '?'. Unidata > obviously knows where it is when executing a called > subroutine but can I get my hands on it at runtime? Any > comments or ideas gratefully received. > > regards > > Martin Hutchinson > --- > 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] Problem with Canon ImageRunner 5000 Printer
Kevin: It sounds like you've identified that the output from UD is exactly what it should be to print to the correct bin. You might take the spooled output and send it directly to the printer (with the binary option) to prove the UD output is correct. e.g. "copy /b SpoolFile \\PS123456\P2" (if you're using a hardware print server). If this prints correctly, I've found sometimes I have to adjust the printer settings themselves to work with U2 (and D3), because sometimes what works in Windows doesn't always work in MV. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Roger Glenfield > Sent: Tuesday, May 23, 2006 1:19 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Problem with Canon ImageRunner 5000 Printer > > Have you tried to send your Unidata output to the &HOLD& file. > > And then using the '^' edit command to check for any unknown > command strings? > > If none, then bypass the spooler and send the &hold& file > directly thru windoze? > > Paperless future? You did hear about the upcoming elections > somewhere in the USA, where they have to keep their fancy new > electronic voting machines in storage, because the new > machines don't produce a paper audit trail and the local > judges banned the new machines use. Somewhere in California, I think. > > Rog > Kevin King wrote: > >> On Behalf Of [EMAIL PROTECTED] > >> My first guess is that the bin you are > >> selecting to print letter is actually > >> for the 11x17. > >> > > > > I wish it were that simple. But having verified with the > manual, and > > having tried all the different bin selection PCL - and > having verified > > that the PCL is accurate, it always wants 11 x 17. It actually does > > select the right bin, but then it errors out asking to load > 11 x 17 in > > that bin. And yeah, I've tried setting the paper selection > to letter > > size both before and after selecting the bin, and still the printer > > insists on 11 x 17. > > > > > >> Try changing it to capture to a file and > >> print using a windows app and check the PCL > >> codes for how it selects the bin, or simply > >> try each PCL sequence until it prints > >> > > >from the correct bin. > > > > Done, and here's the mystery: If I send the EXACT codes from a > > Unidata app, it still wants to print on 11 x 17. Character for > > character the exact same as the Windows app, and still it wants to > > print on 11 x 17. > > > > > >> However, you said it errors out. Perhaps > >> there is some code that is trying to set > >> the page size that is invalid for the 400 > >> series and is ignored there but is causing > >> the grief here. Or the default measurement > >> (decipoints/dots/etc) is different > >> between the printers. > >> > > > > I've verified the measurements (actually this was one of the codes > > from the Win PCL) and as I mentioned I've sent the exact > codes through > > Unidata that went to the printer from a quick test message > printed via > > the Notepad app, and while the Notepad app prints perfectly, the > > Unidata app demands 11 x 17 in any bin I select. > > > > > >> Good luck, don't know about you > >> but I'm really wishing the "paperless" > >> office actually worked. > >> > > > > You have no idea, man... :-) > > > > -Kevin > > [EMAIL PROTECTED] > > http://www.PrecisOnline.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] [UD] ON.ABORT
Simon: I tried the following: Top of "TEST" in "BP"... 001: CRT "This test program is now running. Press [Enter] to abort " : 002: INPUT ZZ,1 003: ABORT 004: * 005: END Bottom. < 1 > Top of "SORRY" in "VOC", 3 lines, 32 characters. 001: PA 002: DISPLAY ...running SORRY 003: TEST.RUN Bottom. < 2 > Top of "TEST.RUN" in "VOC", 4 lines, 54 characters. 001: PA 002: DISPLAY ...running TEST.RUN 003: ON.ABORT SORRY 004: TEST Bottom. When I log on and execute the locally cataloged TEST program I get: :TEST This test program is now running. Press [Enter] to abort ? ...running SORRY ...running TEST.RUN This test program is now running. Press [Enter] to abort ? : I don't get it. What am I doing wrong? Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Simon Lewington > Sent: Monday, May 22, 2006 10:10 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] [UD] ON.ABORT > > "Bill Haskett"... > > Hmmm. I've set UDT.OPTIONS 14 ON and UTD.OPTIONS 105 ON. > > It seems that if ON.ABORT defines a BASIC program to run > > (the same program that executed an ABORT, like a TCL.SHELL > > program), this whole process works only once. It then > > fails and returns me to ECL. > > You need a paragraph which runs ON.ABORT and your BASIC program... > > TCL.SHELL.RUN > 001 PA > 002 ON.ABORT SORRY > 003 TCL.SHELL > > CHAIN this at the end of SORRY instead of TCL.SHELL > > Simon > --- > 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] Accessing UV Data from Microsoft SSIS in SQL Server 2005
Bill: VSG is the "Visual Schema Generator" available for UniData only. In order for the U2, or any MV dbms for that matter, to be accessed via an SQL type tool (via ODBC or OleDB) you need to "map" the MV data structures into a flat SQL schema. VSG is what's used for UniData and it's pretty easy to use. Setting up UniOleDB is a bit tricky though. For UniVerse, I don't believe VSG will do you any good. Hope this helps. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill Hazard > Sent: Friday, May 19, 2006 1:32 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] Accessing UV Data from Microsoft SSIS in SQL Server 2005 > > Hi All, > I would like to use Microsoft SQL Server Integration Services > to access data in UniVerse. Do any of you have advice on > accessing UV data from SSIS? > > Also, I have found several references to VSG ("Visual Schema > Generator"), but I cannot locate this application anywhere. > Is it of value in preparing for ODBC/OLEDB access? What > product includes VSG? > Thanks for help, > Bill Hazard > --- > 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] Phantom job started from another phantom job
George: Are you saying one cannot have a single service manager program running once as a phantom, like cron? So, this doesn't work: PHANTOM RUN MYCRON MYCRON 001 LOOP 002...Read if MyCron should be stopped 003...Stop MyCron if it should be stopped 004...Read jobs to run 005IF JobToRun THEN 006 PHANTOM RUN JOBDEFINITION 007END 008SLEEP 60 009 REPEAT ...but this does: PHANTOM RUN MYCRON PHANTOM.MYCRON 001 PA 002 PHANTOM RUN MYCRON MYCRON 001 LOOP 002...Read if MyCron should be stopped 003IF StopMyCron THEN STOP 004...Read jobs to run 005IF JobToRun THEN 006 PHANTOM RUN JOBDEFINITION 007 CHAIN \PHANTOM.MYCRON\ 007END 008SLEEP 60 009 REPEAT Do I understand this correctly? Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen > Sent: Friday, May 19, 2006 8:16 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Phantom job started from another phantom job > > After sleeping, instead of the process repeats itself, what > you need to do is CHAIN"" to itself, this will end that > phantom, which will release all it's child processes from > their zombie status. > > If you continue to build up zombies, without releaseing them, > you will eventually get the dreaded "no more processes available" > message, at which point, UV comes to grinding crash halt, > until you kill that one repeating phantom, then magically, > all the processes become available again, and UV picks itself > up and continues on with life. > > The only problem with this method, is you will build up a > crap load of very small files in the &PHANTOMS& file. We have > a process which every few days deletes old fileid (using the > ls to give us the date the file was created, and made our > &PHANTOMS& file a type 19) > > Oh, and YEA, looks like the reply is back to the way it was. > > George > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of Scott, Dave > > Sent: Friday, May 19, 2006 10:56 AM > > To: u2-users@listserver.u2ug.org > > Subject: [U2] Phantom job started from another phantom job > > > > > > A colleague of mine ask me to post this on his behalf. > > > > I have a Phantom job that runs continuously. The job performs a > > select, executes some processing on the records returned from the > > select, and then goes to sleep for a few minutes. After > sleeping, the > > process repeats itself. I recently added an additional step > after the > > processing. This step starts another Phantom process which > launches a > > program that does a select and processes the results of the > select and > > then stops (using CHAIN "OFF"). > > > > The problem is that our system admins have noticed that the "child" > > Phantom processes launched by the parent Phantom process go into a > > state of "defunct" > > from a Unix process perspective. > > > > $ ps -ef | grep defunct > > fhooven 23180 986 18 16:33:12 ? 0:00 > > dscott 23302 23199 1 16:33:32 pts/tW0:00 grep defunct > > > > The child Phantom process runs successfully and the > "defunct" process > > eventually goes away. > > > > Any idea what causes this? > > > > System is Universe 10.0 running on HPUX B.11.11 A > > > > Thanks for you help. > > > > ...Frank Hooven > > --- > > 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] ON.ABORT
Hmmm. I've set UDT.OPTIONS 14 ON and UTD.OPTIONS 105 ON. It seems that if ON.ABORT defines a BASIC program to run (the same program that executed an ABORT, like a TCL.SHELL program), this whole process works only once. It then fails and returns me to ECL. AE VOC SORRY Top of "SORRY" in "VOC", 3 lines, 69 characters. *--: P 001: PA 002: DISPLAY Sorry for aborting. ON.ABORT definition now running. 003: TEST Bottom. *--: EX Quit "SORRY" in file "VOC" unchanged. :AE BP TEST Top of "TEST" in "BP", 5 lines, 89 characters. *--: P 001: CRT "This test program is now running. Press [Enter] to abort. " : 002: INPUT ZZ,1 003: ABORT 004: * 005: END Bottom. *--: EX Quit "TEST" in file "BP" unchanged. :ON.ABORT SORRY :TEST This test program is now running. Press [Enter] to abort. ? (I pressed [Enter]) Sorry for aborting. ON.ABORT definition now running. This test program is now running. Press [Enter] to abort. ? (I pressed [Enter]) : If, instead of pressing [Enter] I pressed [Ctrl]+C I get the same thing. :TEST This test program is now running. Press [Enter] to abort. ?***DEBUGGER called at line 2 of program BP\_TEST !END Sorry for aborting. ON.ABORT definition now running. This test program is now running. Press [Enter] to abort. ?***DEBUGGER called at line 2 of program BP\_TEST !END : It doesn't seem as though I'm able to keep users from getting to ECL when they're running in a BASIC program. Setting UDT.OPTIONS 38, 41, and 77 didn't help either. Bill > -Original Message- > From: Bill Haskett [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 18, 2006 8:51 PM > To: 'u2-users@listserver.u2ug.org' > Subject: RE: [U2] [UD] ON.ABORT > > Wally: > > Thank you. This will give me plenty to chew on, so to speak. :-) > > 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 > Wally Terhune > > Sent: Thursday, May 18, 2006 7:36 PM > > To: u2-users@listserver.u2ug.org > > Subject: Fw: [U2] [UD] ON.ABORT > > > > UDT.OPTIONS 14 ON = if you type END in the debugger - > > run ON.ABORT paragraph You may also find the following > > UDT.OPTIONS of interest: 38, 41, 77, 105 > > > > Wally Terhune > > U2 Support Architect > > IBM Information Management > > 4700 South Syracuse Street, Denver, CO 80237 > > Tel: 303.773.7969 > > Fax: 303.773.5915 > > [EMAIL PROTECTED] > > > > > > - Forwarded by Wally Terhune/Denver/IBM on 05/18/2006 > > 08:29 PM - > > > > "Bill Haskett" > > <[EMAIL PROTECTED] > > os.net> > > To > > Sent by: > > > [EMAIL PROTECTED] > > cc > > stserver.u2ug.org > > > > Subject > >[U2] [UD] ON.ABORT > > 05/18/2006 07:59 > > PM > > > > > > Please respond to > > [EMAIL PROTECTED] > > er.u2ug.org > > > > > > > > > > > > > > I'm running UD 7.1 on Windows 2003 and am trying to use the > > ON.ABORT command to prevent user access to ECL. According > > to the UD Commands Reference manual: > > > > "The ECL ON.ABORT command identifies a command that UniData > > executes when a UniBasic program aborts. command may be an > > ECL command, a paragraph, or a directly or globally cataloged > > UniBasic program. This setting remains in effect until you > > clear it with the CLEAR.ONABORT command." > > > > Reading the UD Windows Admin manual, the following note is > > made: > > > > "Note: You can also use the ECL ON.ABORT command to prevent > > users from accessing the ECL or MS-DOS prompt. ON.ABORT > > defines a paragraph that executes whenever a UniBasic > > program aborts. See the UniData Commands Reference for > > information about ON.ABORT." > > > > If I set ON.ABORT, in the login paragraph, to execute a > > BASIC main menu program, then press [Ctrl]+C to break > > out of the main menu, then enter "END" at the "!" debug > > prompt, I end up at the ECL prompt. I thought the > > command specified by the ON.ABORT command was supposed > > to execute (the main menu program). > > > > So, how does one keep anyone from getting to ECL by > > any means? > > > > 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] ON.ABORT
Wally: Thank you. This will give me plenty to chew on, so to speak. :-) 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 Wally Terhune > Sent: Thursday, May 18, 2006 7:36 PM > To: u2-users@listserver.u2ug.org > Subject: Fw: [U2] [UD] ON.ABORT > > UDT.OPTIONS 14 ON = if you type END in the debugger - run > ON.ABORT paragraph You may also find the following > UDT.OPTIONS of interest: 38, 41, 77, 105 > > Wally Terhune > U2 Support Architect > IBM Information Management > 4700 South Syracuse Street, Denver, CO 80237 > Tel: 303.773.7969 > Fax: 303.773.5915 > [EMAIL PROTECTED] > > > - Forwarded by Wally Terhune/Denver/IBM on 05/18/2006 > 08:29 PM - > > "Bill Haskett" > <[EMAIL PROTECTED] > os.net> > To > Sent by: > [EMAIL PROTECTED] > cc > stserver.u2ug.org > > Subject >[U2] [UD] ON.ABORT > 05/18/2006 07:59 > PM > > > Please respond to > [EMAIL PROTECTED] > er.u2ug.org > > > > > > > I'm running UD 7.1 on Windows 2003 and am trying to use the > ON.ABORT command to prevent user access to ECL. According to > the UD Commands Reference > manual: > > The ECL ON.ABORT command identifies a command that UniData > executes when a UniBasic program aborts. command may be an > ECL command, a paragraph, or a directly or globally cataloged > UniBasic program. This setting remains in effect until you > clear it with the CLEAR.ONABORT command. > > Reading the UD Windows Admin manual, the following note is made: > Note: You can also use the ECL ON.ABORT command to prevent > users from accessing the ECL or MS-DOS prompt. ON.ABORT > defines a paragraph that executes whenever a UniBasic program > aborts. See the UniData Commands Reference for information > about ON.ABORT. > > If I set ON.ABORT, in the login paragraph, to execute a BASIC > main menu program, then press [Ctrl]+C to break out of the > main menu, then enter "END" > at the "!" debug prompt, I end up at the ECL prompt. I > thought the command specified by the ON.ABORT command was > supposed to execute (the main menu program). > > So, how does one keep anyone from getting to ECL by any means? > > As always, thanks. > > Bill Haskett > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > > [demime 1.01d removed an attachment of type image/gif which > had a name of pic30923.gif] > > [demime 1.01d removed an attachment of type image/gif which > had a name of ecblank.gif] > --- > 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] ON.ABORT
I'm running UD 7.1 on Windows 2003 and am trying to use the ON.ABORT command to prevent user access to ECL. According to the UD Commands Reference manual: The ECL ON.ABORT command identifies a command that UniData executes when a UniBasic program aborts. command may be an ECL command, a paragraph, or a directly or globally cataloged UniBasic program. This setting remains in effect until you clear it with the CLEAR.ONABORT command. Reading the UD Windows Admin manual, the following note is made: Note: You can also use the ECL ON.ABORT command to prevent users from accessing the ECL or MS-DOS prompt. ON.ABORT defines a paragraph that executes whenever a UniBasic program aborts. See the UniData Commands Reference for information about ON.ABORT. If I set ON.ABORT, in the login paragraph, to execute a BASIC main menu program, then press [Ctrl]+C to break out of the main menu, then enter "END" at the "!" debug prompt, I end up at the ECL prompt. I thought the command specified by the ON.ABORT command was supposed to execute (the main menu program). So, how does one keep anyone from getting to ECL by any means? As always, thanks. Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Multiple Data Files
Charles: Just a note about UniData... They do allow multi-level files. The data files are within the directory structure of the dictionary. It looks like the following on Windows: - Account - FileName FileName FileName_1 FileName_2 D_FileName The (VOC) entry for FileName is: FileName 001 LF 002 FileName 003 D_FileName In the dictionary of (FileName) there are three items that define the data files: @FileName @FileName_1 @FileName_2 ...each having "LF" in attribute 1. UniData recommends that this structure not be used but it is there for compatibility with Pick style accounts. In the Pick world one knows when the file is deleted all data portions of the file are deleted too; so there is a managed linkage between the data and dictionary portions of a file. This does not allow the "sharing" of dictionaries outside this structure, so when a query is run one has to use the "...USING DICT..." clause to use another dictionary. The benefit of the Pick vs PI method of file management is debatable, but I think most Pick people can easily deal with the PI method. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Stevenson, Charles > Sent: Wednesday, May 17, 2006 6:15 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Multiple Data Files > [Snipped] > I don't *think* UD recognizes Pick-style multiple-data-files. > That would be in keeping with their philosophy of "do it > right". (That's my take on the fundamental difference > between Vmark's & UniData's original startup cultures: "all > things to all men" vs. "don't be sloppy, do it > right.") > > If you are defining a UV application from scratch, multiple > F-pointers &/or distributed files are probably generally > preferred to the multi-level pick approach, but maybe that's > just the old primate bias in me talking. > > Chuck Stevenson > --- > 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] LIST DICT FILE Depth and Assoc
Dictionaries do not control the contents of data files, so there's no real way to to determine if an attribute contains multi-values or not. Generally, MV databases are multi-value self aware. This does not apply to UniData (except for conversion codes). By this I mean if you "LIST SOMEFILE SOMEFIELD" you will get output that will look like: SOMEFILE.. SOMEFIELD. 1 14016 14017 14018 2 14019 ...where records in the file have multi-values in the SOMEFIELD attribute. If you place a conversion code, like "D2/", in attribute 7 or 8 of an "A" or "S" type dictionary, the conversion will execute on each value: SOMEFILE.. SOMEFIELD. 1 05/16/2006 05/17/2006 05/18/2006 2 05/19/2006 For reasons I won't get into here, conversion codes are normally placed into attribute 7 of an "A" or "S" type dictionary (attribute 3 of "D" or "I"/"V" type dictionaries). "D" or "I"/"V" type dictionaries do contain a loose definition of whether an attribute is multi-value or not. Attribute 6 of this type of dictionary contains that information. In UniData, in order for multi-value processing to occur in UniQuery, this attribute __MUST__ be defined as multi-valued. Still, however, the database does not require it. The use of attribute 4 and 5 of an "A" or "S" type dictionary defines a multi-value association. For instance, if an A/P invoice record exists it usually has two attributes defined as G/L account#s and associated amounts. In this case you could define an association in these types of dictionaries as "D;.." and "C;..", where ".." is the appropriate associated attribute number. One of these is controlling and one is dependent. This concept doesn't really exist in UV and UD, except in these types of attributes (UV only). So, if you're using a front-end tool you can define an "A" or "S" type dictionary as multi-value by putting an "M" or "S" in attribute 11 of the dictionary then tell your tool to look there. Hope this helps. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of John Kent > Sent: Tuesday, May 16, 2006 4:26 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] LIST DICT FILE Depth and Assoc > > Stuart, > > If you make either one of these S, LIST DICT still > displays the depth and assoc as M not S > > On what does it base this decision. It looks like > Universe assumes all A types are inherently multivalue. > > jak > > - Original Message - > From: <[EMAIL PROTECTED]> > To: > Sent: Tuesday, May 16, 2006 5:30 PM > Subject: RE: [U2] LIST DICT FILE Depth and Assoc > > > > You can use attribute 4 and 5 of the dictionary (UV > > System Description pdf pp5-20 for complete details) > > or use the Retrieve keywords > > MULTIVALUE and SINGLEVALUE at TCL > > to override default behaviours. > > > > Cheers, > > > > Stuart > > > > > > > > Can anyone tell me if there is a way to tell Universe > > that an A type dictionary item is a single value and not > > a multivalue like you can in D or I type items. > > > > It seems that Universe catagorises these as M. > > Knowing this can be useful when combining dict items > > with a WHEN via a front end. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] D3 to U2 - how to import a FileSave tape
David: IBM advises that those migrating an MV system to U2 select UniVerse not UniData. UniData is not inherently multi-value aware and there are a number of other issues that IBM suggests will be avoided by migrating to UniVerse. So, take IBM's advice and move D3 to UniVerse not UniData. When saving D3 data try the following: 1) prepare the D3 system for conversion, + this is your choice of what you want. The U2 products are case sensitive. However, there are utilities in UV to help with the conversion and they will upper-case everything for you. + make sure you don't use the PE version of UV unless no file in D3 exceeds something like 60MB (I'm not sure and would have to look this up to be sure). 2) do an account-save of the selected accounts to a "pseudo" + account-saves are the only supported method for transfer + do the following: :set-device {n} (where {n} is a "pseudo" device) :t-rew : select mds,, 'acct1''acct2''acct3'... {n} items selected. :account-save (a . . :t-rew :t-det Note: the "pseudo" device you select may or may not be a compressed device. I always recommend you save to a non- compressed device. Don't mess with compression unless you're ftp'ing the file over the internet. If so, use whatever Linux tool exists to compress the file before using ftp but after the D3 backup. 3) use the "D3RESTORE" program to restore onto UniVerse + place the "pseudo" file onto the UV system + create a new UV account from which to run D3RESTORE + start a UV session and log to the "UV" account + copy the new versions of CONVERT.VOC and D3RESTORE to the APP.PROGS file + run BASIC APP.PROGS D3RESTORE CONVERT.VOC + run CATALOG APP.PROGS *D3RESTORE D3RESTORE FORCE + run CATALOG APP.PROGS *CONVERT.VOC CONVERT.VOC FORCE (note: overwrite existing if asked) + LOGTO the account from which to run D3RESTORE + run the D3RESTORE program from TCL General info from the account to run D3RESTORE from: :CT VOC D3RESTORE (this item must exist locally) D3RESTORE 0001 V 0002 *D3RESTORE 0003 B 0004 BN :LOGTO UV :LONGNAMES ON NEWAC All NEWACCs have been modified to use long file names. :LOGTO {AccountToLaunchFrom} :D3RESTORE INFILE {PathOfPseudo} - e.g. C:\IBM\d3save Next run the CONVERT.VOC program, which should convert the VOC. I had to recatalog the programs DC, DC.ITEM, and DC.CORR.CONV after recompiling them. Recompile in local account then recatalog in "UV" account. I had some real difficulties with the "DC..." programs in UniVerse. They didn't seem to work properly and I had to review them and activate a bunch of lines of code to make it work properly. This may be because I had the UV PE version. I still have these programs and here's a list of the ones I changed: CONVERT.VOC DC DC.A DC.CORR.CONV DC.F DC.ITEM DC.OPENS D3RESTORE Hope this helps a little. If you get this far ask and I'll offer whatever help I can. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > David Wolverton > Sent: Thursday, May 11, 2006 8:00 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] D3 to U2 - how to import a FileSave tape > > If I to a 'file save' from D3 to a 'disk' tape device, then > ZIP the file from a Linux Box onto a Windows Box and unZIP it > to do 'account restores' on a U2 box... > > What surprises await me? The issue on a test conversion I > need to run is that the tape drive on the Linux box cannot be > accessed on a Windows Box, and go figure, I don't have $3k to > throw down for a one-time conversion > > So - I'd like to use the tape 'disk' file to import. But > would love any knowledge from those bearing the arrows of > being leaders on this process! > > They have about 2GB of data - likely much smaller ZIPed, so I > can get it on a single 'tape file' and 'ftp' it from one > machine to the other (while I'm at lunch...). From there, is > it 'smooth sailing'? > > Also, this customer could care less if I dropped them into > UniVerse or UniData - I use UniData more, but that's just a > preference I can get over if UniVerse makes this substantially easier. > > TIA for any thoughts - > David --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata logging of BASIC Runtime errors
Wally: Aren't options great? :-) 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 Wally Terhune > Sent: Wednesday, May 10, 2006 4:05 PM > To: u2-users@listserver.u2ug.org > Subject: Fw: [U2] Unidata logging of BASIC Runtime errors > > Well, we added file open error logging at one point and upset > a lot of folks - until we made it optional (which was the > right thing to do...) :-( > > Wally Terhune > U2 Support Architect > IBM Information Management > 4700 South Syracuse Street, Denver, CO 80237 > Tel: 303.773.7969 > Fax: 303.773.5915 > [EMAIL PROTECTED] > > > - Forwarded by Wally Terhune/Denver/IBM on 05/10/2006 > 05:03 PM - > > "Bill Haskett" > <[EMAIL PROTECTED] > os.net> > To > Sent by: > [EMAIL PROTECTED] > cc > stserver.u2ug.org > > Subject >[U2] Unidata logging of BASIC > 05/10/2006 04:07 Runtime errors > PM > > > Please respond to > [EMAIL PROTECTED] > er.u2ug.org > > > > > > > Dave: > > UniData does not have logging for BASIC runtime errors (IBM > got back with me on this). There aren't enough requests for > this feature to include it in UniData. :-( > > Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unidata logging of BASIC Runtime errors
Dave: UniData does not have logging for BASIC runtime errors (IBM got back with me on this). There aren't enough requests for this feature to include it in UniData. :-( Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] call sunroutine in command line
Gordon: You might try: http://www.pickwiki.com/cgi-bin/wiki.pl?BPTest This is a program that runs at the command line like: :BPTEST A = "HELLO" ; B = "WORLD" ; CALL TEST.SUB ( A , B ) ; END Where TEST.SUB looks like: 001 SUBROUTINE TEST.SUB ( A , B ) 002 CRT A 003 CRT B 004 RETURN ...so it can easily test a subroutine from TCL. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Gordon J Glorfield > Sent: Tuesday, May 09, 2006 7:33 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] call sunroutine in command line > > No you can't call it directly from the command line. You'll > have to write a small calling program to test it. This test > calling program can just be one line: > > 001 CALL WEB.BI.RENTAL.SUB('X','','') > 002 STOP > > P.S. I had to change the numbers in your example to the 'X's > because our email watch dog would not deliver it with a > number that even looks like a SSN. > > Gordon J. Glorfield > Sr. Applications Developer > UnitedHealthcare's Mid-Atlantic Health Plans > 301-360-8839 > > [EMAIL PROTECTED] wrote on 05/09/2006 09:17:00 AM: > > > All, > > > How could I test a subroutine with AccuTerm command line? > For example, > > the subroutine is called > WEB.BI.RENTAL.SUB(BTN.ID,CUST.ID,ERR.MSG) and > > it has a select statement and returns a result set. In subroutine, > > there is something like: > > > SUBROUTINE WEB.BI.RENTAL.SUB(BTN.ID,CUST.ID,ERR.MSG) > > . > > EXECSQLSTMT = SQLSTMT > > ST=SQLExecDirect(@HSTMT,EXECSQLSTMT) > > > RETURN > > End > > [snip] > > > 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/
RE: [U2] Runtime errors
Dave: I have an request in with IBM for this information. I didn't get any feedback on the list and if I get an answer I'll post it for you and anyone else who might want it. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Dave Walker > Sent: Tuesday, May 02, 2006 7:14 AM > To: 'u2-users@listserver.u2ug.org' > Subject: [U2] Runtime errors > > I'm sure we've all seen the user that ignores umpteen "WARNING: > UNINITIALIZED VARIABLE USED! Zero Assumed!" errors scrolling > up their screen. > > Is there a way to log non-fatal runtime errors so that they > may be reviewed later? Are they already logged someplace that > I'm not aware of? I've checked the various logs in /usr/ud/ > bin/saved_logs without finding what I'm looking for. > > TIA, > -- > Dave Walker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] AccuTerm 2K2 keepalives in UniData
I use AccuTerm mostly and it has a "keepalive" function that sends a signal to the server every two minutes. I'm seeing these CHAR(255):CHAR(252) (IAC and WON'T) characters display at TCL (or in a menu) every two minutes on UniData. These characters interfere with data input. This does not seem to occur in UniVerse (or D3). According to Asent, "There is no specification for telnet keepalives, so we improvised them in AccuTerm. AccuTerm sends a telnet DM command every two minutes. The telnet spec says that unless a connection is in "urgent mode", DM commands are ignored. It looks like IBM did not interpret the spec the same way we did, and treats the DM command as data. Here's a quote from RFC854: 'When in normal mode, a DM is a no operation; when in urgent mode, it signals the end of the urgent processing.'". Does anyone else have this problem with AccuTerm "keepalives" and UniData? If so, have you found a "work-around" for this? As always, any assistance will 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/
RE: [U2] Escaping the '&' in Windows XP from Universe
Eric: Try: EXECUTE "DOS /C DIR 'UVUSR\LFC\?HOLD?\..." This ought to work. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Eric > Armstrong > Sent: Friday, April 28, 2006 9:59 AM > Cc: [EMAIL PROTECTED]; U2Users > Subject: [U2] Escaping the '&' in Windows XP from Universe > > Does anyone know how to escape the "&" in the following Basic EXECUTE > statement? > > EXECUTE DOS /C DIR > UVUSR\LFC\&HOLD&\INSRECAP\SutherlandIssues200604.csv > CAPTURING msg RETURNING err > > Windows is choking on the "&". It thinks "HOLD" is a file in the LFC > directory. > > I tried the following- > > EXECUTE DOS /C DIR > "UVUSR\LFC\&HOLD&\INSRECAP\SutherlandIssues200604.csv" > EXECUTE DOS /C DIR > 'UVUSR\LFC\&HOLD&\INSRECAP\SutherlandIssues200604.csv' > EXECUTE DOS /C DIR > UVUSR\LFC\&&HOLD&&\INSRECAP\SutherlandIssues200604.csv > > and a few other things, but no go. > > We are on > Universe 10.1.10 > Windows XP 2002 > > Thanks in advance. > > Eric Armstrong > Programmer/Analyst > Lobel Financial > 714.816.1207 > 714.995.7012 fax > --- > 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] Difficulty replying to U2 postings
I'm having some difficulty posting to the list. Occasional I get an email from the "community". When I try to respond by clicking on the appropriate reply-link I get a "You have no permission to write into this category or forun" error. When I try to login using my username and password, and clicked "Remember me" I was directed to www.microsoft.com. It works fine if I uncheck the "Remember me" box. Anyway, when I went to the web site and try to respond from the site I'm also told I don't have permissions (even though I'm a registered user). I guess the difficulty of communicating explains why the number of postings I receive has practically dried up. Oh well... Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Triggers
Please pardon my misstatement as you can put one update and one delete (for a total of two) triggers on a UniData file (there is a work-around). You can, however, debug the trigger by putting a DEBUG statement into the subroutine. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett > Sent: Thursday, April 20, 2006 7:55 AM > To: 'U2Users' > Subject: RE: [U2] [UV] Triggers > > Phil: > > Fortunately, this is not the case in UniData. However, > triggers (plural) is > really a misnomer as you can only put one trigger (singular) > on a UniData > file. > > Bill Haskett > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of phil walker > > Sent: Wednesday, April 19, 2006 11:02 PM > > To: U2Users > > Subject: [U2] [UV] Triggers > > > > How many people in this group as using triggers in there > applications? > > > > For those that do, how do they manage to use the debugger? > > > > As from what I have been able to ascertains it seems as soon > > as you try > > to debug a program which write/deletes to/from a file/table with a > > trigger on the program aborts, as you cannot have input within a > > trigger. > > > > This is a major design flaw as far as I am concerned, and very > > frustrating... > > > > Firstly, if someone wants to have an input statement inside > a trigger > > program let them. There is enough rope in UV for people to hang > > themselves. So let people make their own bed... > > > > Secondly, even if you cannot have input inside a trigger, > the debuging > > session should not be considered normal input, and UV > should recognise > > this and perform the write, stepping over the trigger code and > > performing the next operation in the program being debugged. > > > > Any comments? > --- > 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] Triggers
Phil: Fortunately, this is not the case in UniData. However, triggers (plural) is really a misnomer as you can only put one trigger (singular) on a UniData file. Bill Haskett > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of phil walker > Sent: Wednesday, April 19, 2006 11:02 PM > To: U2Users > Subject: [U2] [UV] Triggers > > How many people in this group as using triggers in there applications? > > For those that do, how do they manage to use the debugger? > > As from what I have been able to ascertains it seems as soon > as you try > to debug a program which write/deletes to/from a file/table with a > trigger on the program aborts, as you cannot have input within a > trigger. > > This is a major design flaw as far as I am concerned, and very > frustrating... > > Firstly, if someone wants to have an input statement inside a trigger > program let them. There is enough rope in UV for people to hang > themselves. So let people make their own bed... > > Secondly, even if you cannot have input inside a trigger, the debuging > session should not be considered normal input, and UV should recognise > this and perform the write, stepping over the trigger code and > performing the next operation in the program being debugged. > > Any comments? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] Enter to continue...
Just out of curiosity, does anyone know why UniData (in Pick mode) displays the message "Enter to continue..." on the next line after the terminal term depth? For instance, if I set the term to 79,25 I expect 25 lines of data to be displayed on the terminal. If I execute "LIST VOC HEADING "This is a test..." the aforementioned message displays on the 26th line; thus pushing the heading one line above the screen display. 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] [UD] UniOLEDB
I tried to make a UniOLEDB connection from MS VS2005 to UniData and get the error "Died in UCI::SQLConnect() with SQLSTATE IM976, Native error: 0 [IBM][SQL Client]UCI connections to non UniVerse databases is not allowed." I've read and followed the 155 page UniOLEDB manual. The following configurations exist: On the Client: Unirpcservices uvcs E:\IBM\UV\bin\uvapi_server.exe * TCP/IP 0 3600 defcs E:\IBM\UV\bin\uvapi_server.exe * TCP/IP 0 3600 uvserver E:\IBM\UV\bin\uvsrvd.exe * TCP/IP 0 3600 uvnet E:\IBM\UV\bin\uvnetd.exe * TCP/IP 0 3600 uvdrsrv E:\IBM\UV\bin\uvdrsrvd.exe * TCP/IP 0 3600 uvfilefix E:\IBM\UV\bin\uvfilefix_server.exe * TCP/IP 0 3600 I updated the uci.config file via the UCI Editor and it looks like: [ODBC DATA SOURCES] <-- this has looked funny from the beginning DBMSTYPE = UNIVERSE network = TCP/IP service = uvserver host = localhost DBMSTYPE = UNIDATA network = TCP/IP service = udserver host = localhost DBMSTYPE = UNIDATA NETWORK = TCP/IP SERVICE = udserver HOST = AsiOlyWaDev ACCOUNT = E:\DataTrust\DtaDemo USERNAME = MyUserName On the server: ud_database (although it shouldn't be needed) DATABASE=demo UDTHOME=E:\IBM\ud71 UDTACCT=E:\IBM\ud71\demo TRACE_LEVEL=0 # DATABASE=DtaDemo UDTHOME=E:\IBM\ud71 UDTACCT=E:\DataTrust\DtaDemo TRACE_LEVEL=0 I've read and followed the instructions in the VSG manual (Using VSG and the Schema API). All seemed to work just fine. I exposed a single file and all dictionaries in the file. The connection seems to work fine from VSG: 1 Dtademo (0)-> lu Licensed(UDT+CP)/Effective UdtSqliPhtmPooledTotal ( 32 + 0 ) / 32 10001 UDTNO USRNBR UID USRNAME USRTYPE TTY IP-ADDRESSTIME DATE 1 2712 197615 myadmin udt pts/1 192.168.1.51 05:22:37 Apr 14 2006 2 500 197631 DtaDemoNE sql pts/2 Console 12:15:50 Apr 14 2006 3 2608 197615 myadmin udt pts/3 192.168.1.51 05:47:12 Apr 14 2006 I've done this same sort of thing using D3ODBC and VS2005 and that connection worked just fine (well, mostly). :-)Can someone point me in the right direction? As always, thanks for any help offered. 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 - VSG
I've been working with VSG and have a question regarding privileges. I have UD v7.1 installed in "E:\IBM\ud71". I have several accounts installed in locations other than in @UDTHOME. The @UDHOME directory and the other accounts are restricted to users in the Administrators or UniData group. When creating VSG I have the ability to allow privileges to the PUBLIC, or to users, or, it seems, to Administrators if I type in an administrator user name. How do I restrict access to tables or views to users in the UniData group without having to add each user individually? How do I allow access to tables or views to those outside the Administrators or UniData group, say the SeniorMgmt group? 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/
RE: [U2] UD Indexes
Simon: Thanks very much. I'll pursue this immediately. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Simon Lewington > Sent: Wednesday, April 12, 2006 1:35 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] UD Indexes > > "Bill Haskett" ... > > I'm running UD v7.1 and got an error message from within a > > BASIC program like: > > > > In E:\DataTrust\DTA\BP\BP\_TRREC at line 1161 "-" is not > > an indexed/legal field. > > > > ...caused by the BASIC statement: > > > > SETINDEX NAME.KEY, A.CODE ON ARTDESC > > ...Am I correct in assuming that UniData won't accept > > a "-" in the indexed field? > > Nope > > > What's up with this? > > You've accidentally set NAME.KEY = "-" instead of "INDEX_1". > > Simon --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UD Indexes
I'm running UD v7.1 and got an error message from within a BASIC program like: In E:\DataTrust\DTA\BP\BP\_TRREC at line 1161 "-" is not an indexed/legal field. ...caused by the BASIC statement: SETINDEX NAME.KEY, A.CODE ON ARTDESC ...where the index looks like: :LIST ARTDESC INDEX_1 ARTDESC INDEX_1. ADV PREPAID ON ACCOUNT-1300 CAF COLLECTION AGENT FEE-5340 CLA CLEAR ACCOUNT-1300 EVI EVICTION NOTICE-2100 . . Am I correct in assuming that UniData won't accept a "-" in the indexed field? What's up with this? Is this another character I need to programatically manage? Are there others? As always, 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/
RE: [U2][UD] Logout/Logoff/? Udtno/Pid
Dave: Try this: ! ** Log off another line for UniData ** (C) Copyright 1985-2004, Advantos Systems, Inc. All Rights Reserved. ! ** Last Modified: 16 Mar 2006, wph ** First Created: 16 Mar 2006, wph ** Program Type-: Utility ! ** Notes: ** ** This process is designed to log off another UniData process (or ** port). It is necessary to logoff the user number as specified in ** the "LISTUSER" command. The syntax is: ** ** LISTUSER {USRNBR} ** ** If the user number isn't specified then the "LISTUSER" command is ** executed and one has the choice of entering the user number. ** **---** ** ** **I N I T I A L I Z A T I O N** ** ** **---** * ** Initialize local variables NULL$ = '' AM = @AM VM = @VM SP1= ' ' BadNos = NULL$ ** parse tcl sentence to get BASIC commands TclLine = @SENTENCE ** remove the command from the line and check if we need help TclLine = OCONV(TRIM(TclLine), 'G1 999') IF TclLine = '?' THEN GOTO DISPLAY.HELP ** convert spaces to VMs UserNos = CONVERT(SP1, VM, TclLine) * **---** ** ** ** S T A R T P R O G R A M R U N ** ** ** **---** * ** test if we need to enter the user numbers IF UserNos = NULL$ THEN EXECUTE \LISTUSER\ CRT CRT "Enter numbers from the USRNBR column separated by spaces:" INPUT UserNos ; UserNos = OCONV(TRIM(UserNos), 'MCU') IF UserNos[1,1] = 'E' THEN GOTO END.OF.PROGRAM IF UserNos[1,1] = 'X' THEN GOTO END.OF.PROGRAM IF UserNos[1,1] = 'Q' THEN GOTO END.OF.PROGRAM UserNos = CONVERT(SP1, VM, UserNos) END ** log off the selected user numbers xHigh = DCOUNT(UserNos, VM) FOR X = 1 TO xHigh UserNo = UserNos<1,X> PCPERFORM \stopudt \ : UserNo IF @SYSTEM.RETURN.CODE THEN BadNos := UserNo : SP1 NEXT X * GOTO END.OF.PROGRAM * **** **** ** S U B R O U T I N E S ** **** **** * ** Help display *** DISPLAY.HELP: *** * CRT CRT "Utility to log off UniData processes. This command is similar to" CRT "the PICK command 'LOGOFF {PortNo}'. If the User# isn't supplied" CRT "then the 'LISTUSER' command is executed and the user has the option" CRT "of selecting a listed USRNBR." CRT CRT "Syntax:" CRT " LOGOFF {UserNbr UserNbr ...}" CRT CRT "Example:" CRT " LOGOFF 3275" CRT CRT "The user# 3275 is logged off." CRT STOP * **** **** ** E N D O F P R O G R A M ** ** ** **----** * *** END.OF.PROGRAM: *** * IF BadNos NE NULL$ THEN CRT CRT "The following items were not logged off:" CRT TRIM(BadNos) END END 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: Wednesday, April 05, 2006 6:13 PM > To: u2-users@listserver.u2ug.org > Subject: [U2][UD] Logout/Logoff/? Udtno/Pid > > UD Ver 7.1.0 PE on Win 2000 Server: > > I have been unable to find a way to logoff/logout/otherwise > disconnect a > process running on another Udtno/Pid, including both > foreground and background > (phantom) processes. > > Any suggestions will be much appreciated. > > Thanks, > > Dave > > Dave Taylor --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] phantom processing
I'm trying to start up an application service as a phantom. In D3 I was able to put the phantom startup in the "system-coldstart" process that guaranteed it started when D3 was started. I also created a menu item so clients could start and stop the service on their own if they so desired. I've been testing this in UniData and have set the LOGIN paragraph like: ** Test for phantom processing IF @TTY = 'PHANTOM' THEN GO LOGIN.END: IF @TTY = 'phantom' THEN GO LOGIN.END: * ** Test for UniObjects processing IF @TTY = 'udcs' THEN GO LOGIN.END: . . ** Now bring up the application main menu APP.START * *** LOGIN.END: *** When I connect, and login, via UniAdmin (udcs) the application start process is skipped (I believe). But when I try to start a phantom the application start process is run. Does someone know why? Secondly, how can I start the phantom when UniData is started? My last question is where can I start runtime-error logs? The event logging in UniAdmin seems to refer me to the RFS logging and I haven't found out where logging is set up in the Documentation. Any help would be greatly 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/
RE: [U2] UD UniDebugger
Bob & Colin: I checked the permissions and they are all propagated down through the subdirectories and files. Only server Administrators and the UniData group have control over everything under the "MyApp" shared directory, nothing else. When I open a file I'm given a choice of how the file is opened: 1) Disk, 2) Ftp, and 3) UniObjects. I've been trying "Disk" but it appears I can't update these files because I've set them up so only server "administrators" and "UniData group" users can modify the files. From my workstation, I can view the files, just not change them. When I try access via UniObjects, I'm asked to provide my "server" user name and password (credentials). Upon entering these server credentials I can update the files. So, it appears when I connect to the "shared" directory on the server, using my workstation's Windows Explorer (or anywhere else for that matter), I'm using the "SYSTEM" windows user that I've explicitly removed from access to these directories. Therefore, when securing the directories, UniDebugger should only be used with UniObjects where the server's credentials can be entered and used...unless, of course, anyone else knows of a valid, secure, user/group that I can add to the list of authorized users of the "MyApp" directory to make the "Disk" option work. :-) Thanks. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Tuesday, April 04, 2006 10:52 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] UD UniDebugger > > Bill; > > Which read/write type are you using when you open the file? > > If you use "disk" then it uses standard windows permissions > (i.e.. if you can > update the program in notepad you can update it in > UniDebugger). I have > mapped drive letters - but I wouldn't think it would be any different. > > I've never gone through the hassle of setting up ftp to work > on a windows host. > But I have used it on an Aix host. Standard ftp... > > Lastly is UniObjects. I've gotten it to work - just to make > sure I could. The > only benefit I saw was having the program actually locked at > the UniData > level - never found it worth the trouble. Using straight disk > is so much > easier. > > What type of permissions/security do you have on the share? > What if you use the full unc path? > What if you map a drive? > You're not doing something silly like logging in as someone who > isn't a member of the admin or UniData group? > Was the user recently added to the group? Sometimes it takes a > while to take effect. > > hth > Colin Alfke > Calgary Canada > > > > > > From: Bill Haskett > > Speaking of UniDebugger, how does one go about updating a > UniData file on > another server? > > I have UD 7.1 running on a Win 2K3 server. The permissions > on this server > allow Administrators complete control and the "UniData" group complete > control. The group of accounts I want access to is located > in "E:\MyApp\". > I've "shared" this directory as "MyApp" then in UniDebugger I > open the "BP" > file in "\\AsiDev\MyApp\Dta\BP" then select a program. When > I try to update > the program I get a message that I don't have permissions. > > What permissions should I give to "E:\MyApp" so that > UniDebugger can update > these programs? > > 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] UD UniDebugger
Speaking of UniDebugger, how does one go about updating a UniData file on another server? I have UD 7.1 running on a Win 2K3 server. The permissions on this server allow Administrators complete control and the "UniData" group complete control. The group of accounts I want access to is located in "E:\MyApp\". I've "shared" this directory as "MyApp" then in UniDebugger I open the "BP" file in "\\AsiDev\MyApp\Dta\BP" then select a program. When I try to update the program I get a message that I don't have permissions. What permissions should I give to "E:\MyApp" so that UniDebugger can update these programs? 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/
RE: [U2] Xml/db
Gerry: Try chapter 8 of the UniData 6.1 New Features .pdf document. Maybe this will help a little. 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 gerry-u2ug > Sent: Tuesday, April 04, 2006 11:02 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Xml/db > > That's where the tool is but not any documentation > From a little playing with this it seems pretty useless anyway. > Although with the proper docs I might think otherwise. > > Gerry > > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Ron White > Sent: April 4, 2006 11:16 > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Xml/db > > It is under UniVerse Tools on the 10.1a client CD. It is not installed > during the database install and will need to be separately installed > > Ron White > > Clifton Oliver wrote: > > My confusion. I didn't realize you were talking about the > GUI tool for > > > building the XML Map file. I don't recall seeing any > documentation in > > a manual for that. > > Maybe someone else can point us to it. > > > > As to answering private, no. That was unintentional and a result of > > the brilliant addressing scheme, as was warned to no avail. > --- > 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] Executing save-list
Dave: I have no clue why this doesn't compile. I have a number of programs I wrote for UniData years ago that use this syntax frequently, so I know it's supposed to work. Here's some code that I used all the time: ECMD = \SSELECT BUSINESS.LINE BY BUS.CD\ EXECUTE ECMD RTNLIST COMP.LIST CAPTURING OUTPUT READSELECT ALL.COMPS FROM COMP.LIST ELSE COMP.LIST = '' SWAP @AM WITH '""' IN ALL.COMPS ALL.COMPS = DQUOTE(ALL.COMPS) This even indicates you don't need to ...RTNLIST... to a list number but can return to a list variable name. I created the same program as you did and got the same error. I then went to tcl then executed the following: :ECLTYPE U :BASICTYPE "U" ...then tried it again; I got the same error. However, when I replaced 'EXECUTE' with 'MDPERFORM' (not 'PERFORM') it compiled fine. I normally set PICK compatibility mode by executing "ECLTYPE P" and "BASICTYPE "P"" when the user logs on. Reviewing the UDT.OPTIONS documentation, and reading some other documents, I set the following UDT.OPTIONS to get additional Pick compatibility: UDT.OPTIONS 3 ON UDT.OPTIONS 7 ON UDT.OPTIONS 15 ON UDT.OPTIONS 23 ON UDT.OPTIONS 32 ON UDT.OPTIONS 34 ON UDT.OPTIONS 43 ON UDT.OPTIONS 48 ON UDT.OPTIONS 54 ON UDT.OPTIONS 56 ON UDT.OPTIONS 64 ON UDT.OPTIONS 66 ON UDT.OPTIONS 75 ON UDT.OPTIONS 78 ON UDT.OPTIONS 83 ON UDT.OPTIONS 89 ON UDT.OPTIONS 92 ON UDT.OPTIONS 104 ON UDT.OPTIONS 114 ON I guess I'll add this issue to the list of issues I've run into and submit then to IBM for possible help, now that I'm licensed and have support instead of PE. :-) Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) > -Original Message- > From: Dave Taylor [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 29, 2006 10:13 PM > To: Bill Haskett > Subject: Re: [U2] [UD] Executing save-list > > Bill, > > Thanks for pointing me to the documentation on the EXECUTE > statement on UD > PE 7.x on Windows 2000 Server. > > I think that I'm compliant. > > I can't even get the following 2-line program to compile > without an error: > > ED BP EX > 0001EXECUTE "SELECT CLIENTS" RTNLIST 1 > 0002END > > When I compile it I get the message: > > "Misuse of reserved word 'RTNLIST' > Expecting: end-of-file,END > > I must be missing something! > > BTW, you mentioned a PICK mode. Is there a PICK mode? I > haven't been able > to find any reference to PICK anywhere in the documentation. > > Thanks again, > > Dave > > 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: "Bill Haskett" <[EMAIL PROTECTED]> > To: "'Dave Taylor'" <[EMAIL PROTECTED]> > Sent: Wednesday, March 29, 2006 1:47 PM > Subject: RE: [U2] [UD] Executing save-list > > > > Dave: > > > > In UniData on Windows, when the "newacct" Windows command is run, > > a SAVEDLISTS director is created locally to the account. So, > > on Windows anyway, lists are kept in a local SAVEDLISTS > > subdirectory. > > > > According to the documentation: > > > > - - - - - - - - - - > > RTNLIST int.expr > > The RTNLIST clause must be an integer from 0-9, designating > the select > list > > to return to the calling program. You can use the resulting > list with > > subsequent READNEXT statements or in the PASSLIST clause of > an EXECUTE > > statement. If an expression is not given after RTNLIST, the > generated > select > > list replaces the contents of list 0. If RTNLIST is not > specified, no list > > is returned. > > If you use EXECUTE to call a UniBasic program, no select > list is returned > > even though you specify RTNLIST. On the other hand, > PASSLIST is always > > effective and transfers a select list to the called program. > > - - - - - - - - - - > > > > I've found a lot of stuff doesn't work in PICK mode, so I > > mess around with lower-casing the "save.list", "merge.list", > > etc commands with EXECUTE. > > > > Hope this helps. > > > > Bill > > > > > -Original Message- > > > From: Dave Taylor [mailto:[EMAIL PROTECTED] > > > Sent: Tuesday, March 28, 2006 6:46 PM >
RE: [U2] [UD] Executing save-list
Bruce: So, I'm guessing you're validating that the SAVE-LIST and SAVE.LIST (and probably SAVELIST) are all ignoring the local (VOC) file. I misstated, in my original mail, when I said the modified "SAVE-LIST" works from TCL because it doesn't; only the "SL" synonym works properly. Do you have any idea how to override this restrictive handling of verbs, and make the VOC the primary source for the verbs I identify? As always, thanks. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Nichol > Sent: Tuesday, March 28, 2006 11:06 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] [UD] Executing save-list > > Goo'day, Bill... > > At 16:52 28/03/06 -0800, you wrote: > > >I was following some suggestions to track saved lists and > >did the following: > > > >1) Created a "SAVE-LIST" (VOC) entry that looks like: > > SAVE-LIST > > 001 V > > 002 U2.LISTINFO > > > >2) Wrote a program "U2.LISTINFO" that updates a (LISTINFO) > > file with information then does an "EXECUTE \SAVE.LIST \ > > : LISTNAME". > > > >When I "EXECUTE \SAVE-LIST \ : LISTNAME" from a BASIC program > >the program "U2.LISTINFO" isn't called. It's as though there > >is a global "SAVE-LIST" command that is used instead of the > >local one. Is this true? Any ideas how I can overcome this? > >(ECLTYPE P) > > > If UD is anything like UV, SAVE-LIST is exactly the same as > SAVE.LIST, 'cos part of the comaptibility with Pick is that > a dot or a dash for TCL verbs are the same > > Regards, > > Bruce Nichol > Talon Computer Services > ALBURYNSW 2640 > Australia > > http://www.taloncs.com.au > > Tel: +61 (0)411149636 > Fax: +61 (0)260232119 > > If it ain't broke, fix it till it is! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] Executing save-list
I was following some suggestions to track saved lists and did the following: 1) Created a "SAVE-LIST" and "DELETE-LIST" (VOC) entry that look like: SAVE-LIST 001 V 002 U2.LISTINFO 2) Wrote a program "U2.LISTINFO" that updates a (LISTINFO) file with information then does an "EXECUTE \SAVE.LIST \ : LISTNAME". >From TCL the "SAVE-LIST ..." seems to work fine. However, when I "EXECUTE \SAVE-LIST \ : LISTNAME" from a BASIC program the program "U2.LISTINFO" isn't called. It's as though there's a global "SAVE-LIST" command that is used instead of the local one. Is this true? Any ideas how I can overcome this? (ECLTYPE P) As always, 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/
RE: [U2] [UD] Saved lists
Anthony: Thanks for the idea. I've been tinkering with "DIR" but it doesn't give me the correct owner of the file. I installed UD under using a user other than "administrator" and login to UD under a valid Windows user id. But, when I do a "DIR /Q" I get "BUILTIN\Administrators" as the owner, even though the logged in user created the list...not exactly what I had in mind. :-( However, the date/time stamp is worth something. Thanks again. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Anthony Corrente > Sent: Sunday, March 26, 2006 11:10 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] [UD] Saved lists > > Hi Bill, > > I believe all this information is already there.. (except > perhaps for Port and Account name), at the OS level. > > So, instead of using a trigger, you could list the contents > of SAVEDLISTS, like: > > ls -l SAVEDLISTS > > I think there are different options to the ls command which > gives you the create date and last modified date. > > On NT you could use the DIR command... > > The other alternative is to use FILEINFO?? (can't remember > and too lazy to look it up.. ;-) )... . Setup the DICT for > SAVEDLISTS with virtual attributes calling the relevant > FILEINFO for that list... > > Hope this helps, > > Anthony Corrente. > > --- Bill Haskett <[EMAIL PROTECTED]> wrote: > > In 1998 a client of ours, who we converted from D3 to UD, > attached a trigger to D3's pointer-file (SAVEDLISTS) that > keeps additional information like the following: > > Page 1 LISTINFO 17:47:46 26 Mar 2006 > > ListName Created. LastUDt. LPor LAcct.. LUser. LSize... > > ARSTMT.LIST 03/24/06 03/24/062 HCARES PAD 597 > TOMMY03/24/06 03/24/06 44 HCACOM SML 22 > BILL 03/24/06 03/24/06 42 hcares AZ 7739 > PR.RUN.LIST 02/28/06 03/23/06 45 HCARES YMC 463 > SYSPTR.LIST 03/22/06 03/22/06 39 HCARES PAD 8117 > DEPOSIT 12/16/05 03/22/061 hcacom CC 48328 > > This process is very similar to what Dave Weaver posted in > CDP about a year ago. > > Has anyone tagged SAVEDLISTS items with this kind of > information. Our client has everything built to use a > trigger but we can't put a trigger on a "DIR" file nor > can we change the SAVEDLISTS file to an "F" type file. > > Any ideas would be appreciated. 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] [UD] Saved lists
In 1998 a client of ours, who we converted from D3 to UD, attached a trigger to D3's pointer-file (SAVEDLISTS) that keeps additional information like the following: Page 1 LISTINFO 17:47:46 26 Mar 2006 ListName... Created... LastUDate. LPor LAcct. LUser.. LSize... ARSTMT.LIST 03/24/2006 03/24/20062 HCARES PAD 597 TOMMY 03/24/2006 03/24/2006 44 HCACOM SML 22 BILL03/24/2006 03/24/2006 42 hcares AZ 7739 PR.RUN.LIST 02/28/2006 03/23/2006 45 HCARES YMC 463 SYS.LPTR.LIST 03/22/2006 03/22/2006 39 HCARES PAD 8117 DEPOSIT 12/16/2005 03/22/20061 hcacom CC 48328 This process is very similar to what Dave Weaver posted in CDP about a year ago. Has anyone tagged SAVEDLISTS items with this kind of information. Our client has everything built to use a trigger but we can't put a trigger on a "DIR" file nor can we change the SAVEDLISTS file to an "F" type file. Any ideas would be appreciated. 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] [UD] Setptr
If I generate a report to _HOLD_ by using "SETPTR 0,3" can I then send the report to another printer, say unit 2, by using "SETPTR 2" just before I "SPOOL _HOLD_ P_."? According to the documentation each report generated to _HOLD_ is accompanied by another entry with the SETPTR commands; it even shows two separate hold entries. I only get one entry when I do this. Is this because I only have one printer on the Windows 2003 system? As always, thanks. Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10 and Windows 2003 Mapped Drives
Ray: Try this: 1) In UniAdmin select "Configuration Editor" and change the "ALLOWNFS" parameter to "1". 2) Get to TCL in UV and execute the following: DOS /C"net use Z: \\Server\Share Passwd /user:Server\U2Admin" ...where "Passwd" is the actual password of the "U2Admin" user on the "Server" server. 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. 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 Ray Buchner > Sent: Thursday, March 23, 2006 7:40 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] UV 10 and Windows 2003 Mapped Drives > > I have some simple DOS batch processes executed from Universe Proc's > that are failing now that I moved Universe 10 to a Windows > 2003 server. > > An example would be this seemingly simple one... > > copy d:\accounts\sklar\EDI.EXPORT\810.TXT Z:\Imports > > Z:\ Is a mapped drive to another 2003 server called ECOMM_PA1 > > When at a DOS command prompt (In windows) I can hit Z: and it connects > perfectly. I can also execute the above copy command within the batch > process perfectly. > > However, when I am in Universe and shell-out to DOS, I cannot hit this > mapped drive Z: It gives the following error message... > > C:\>Z: > The system cannot find the drive specified. > > I have triple checked all permissions on each side to no > avail. I have > also tried using a UNC path to ECOMM_PA1 which also failed. > > Does anyone have any ideas? > > -Ray > --- > 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] BASIC Footing statement
Mike: Your program illustrates my problem. Any other ideas? When I direct output to a hold file it looks like: < 1 > Top of "P_" in "PEQS", 561 lines, 1,438 characters. *--: 547: 548: Page 9 549: Paul's Produce 550: ^012 551: TEST 10 552: LINE 1 553: LINE 2 554: LINE 3 555: LINE 4 556: LINE 5 557: LINE 6 558: LINE 7 559: LINE 8 560: LINE 9 561: LINE 10 Bottom. All UDT.OPTIONS are OFF except the following: 1 Dtademo (0)-> UDT.OPTIONS 2 U_PSTYLEECL ON 3 U_SHLNOPAGE ON 7 U_NOMAKEPAGE ON 15 U_DYNAMICNUL ON 23 U_PK_READNEXT ON 32 U_PI_PRINT_AT ON 34 U_HEADING_DATEON 43 U_PRM_DETSUP ON 46 U_UNFLUSHDATA ON 48 U_UNBOUNDARY ON 54 U_PROC_KPTSELECT ON 56 U_CONV_BADRETURN ON 64 U_BASIC_FINISHON 66 U_PICK_NUMERIC_FILESON 75 U_PROC_DELIMITER ON 78 U_PICK_LOCK ON 83 U_INPUT_ESC ON 89 U_PICKSTYLE_MVSORT ON 92 U_INSENSITIVE_MATCH ON 104 U_TRAIL_FM_TLOAD ON 114 U_NOFORMFEED ON 1 Dtademo (0)-> SETPTR Unit 0 Width 132 Length 60 Top margin 3 Bot margin 3 Mode 1 Options are: 1 Dtademo (0)-> LISTPTR Printer... Port...Status..Comment. HPLJ2420 IP_192.168.1.41Running Dev printer 1 Dtademo (0)-> U2INFO Platform : INTEL Operating System : WIN32-2000 Service Pack 4 Porting Date : Wed Jun 29 10:05:40 MDT 2005 UniData Release : Version 7.1.0PE, Build 3146 Ported by: srcman ...Current account logged onto... E:\DataTrust\DtaDemo Licensed(UDT+CP)/Effective UdtSqliPhtmPooledTotal ( 2 + 0 ) / 210001 UDTNO USRNBR UID USRNAME USRTYPE TTY IP-ADDRESSTIME DATE 1 3096 197615 bill udt pts/1 192.168.1.101 08:34:06 Mar 23 2006 2 2148 197615 bill udt pts/2 192.168.1.101 08:36:05 Mar 23 2006 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 > Rajkowski > Sent: Thursday, March 23, 2006 7:57 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] BASIC Footing statement > > I did a quick test on the 7.1 PE, and it worked fine. Try > the following > on your system and see if it puts the last footer. > > Note that the footer I used was described in the online help. > > 001: PRINTER ON > 002: FOOTING "Page 'PL'Paul''s Produce" > 003: FOR A = 1 TO 10 > 004:PRINT "TEST ":A > 005:FOR B = 1 TO 10 > 006: PRINT "LINE ":B > 007:NEXT B > 008:IF A # 10 THEN > 009: PAGE > 010:END > 011: NEXT A > 012: PRINTER OFF > > > > Michael Rajkowski > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett > Sent: Thursday, March 23, 2006 8:10 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] [UD] BASIC Footing statement > > We're finalizing a conversion from D3 to UD and there are a few issues > remaining. Our client prints footings on all their reports. The > footing > doesn't print on the last page of the reports. We've set > UDT.OPTIONS 64 > ON > and still no luck. > > All their reports, both BASIC and UniQuery, are executed from a BASIC > program. We've also set UDT.OPTIONS 7 ON to make sure pages aren't > filled > on the screen. > > Any suggestions would be appreciated. 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-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] BASIC Footing statement
We're finalizing a conversion from D3 to UD and there are a few issues remaining. Our client prints footings on all their reports. The footing doesn't print on the last page of the reports. We've set UDT.OPTIONS 64 ON and still no luck. All their reports, both BASIC and UniQuery, are executed from a BASIC program. We've also set UDT.OPTIONS 7 ON to make sure pages aren't filled on the screen. Any suggestions would be appreciated. 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/
RE: [U2] [DC] Dynamic Connect, Ctrl V
Bill: In wIntegrate you would click on Setup > Keyboard then click on the "Alpha-numeric" radio button in the "Key List" section. Scroll down to "C_C", highlight it then make sure "Ctrl" and "Macro" are checked then in the "Definition" enter "Invoke EditCopy". Do the same thing for the "C_V" key except enter into the "Definition" "Invoke EditPaste". Hope this helps. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Brutzman, Bill > Sent: Wednesday, March 22, 2006 3:06 PM > To: 'u2-users@listserver.u2ug.org' > Subject: [U2] [DC] Dynamic Connect, Ctrl V > > I have a user who like to use that Ctrl-V, Ctrl-Something to > cut and paste. > > Although it runs as part of the install, I am having trouble > finding info on > it in the yr 2000 "Using Dynamic Connect" manual. > > Suggestions would be appreciated. > > --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD telnet server
> Simon: > > 1GB ethernet cards are notorious for dbms products. I know on D3, where > I've had a good deal of experience, a 1GB ethernet card that isn't an > (off-board) INTEL Pro 1000MT adapter can have very unusual symptoms that > basically cause the dbms to crash, the network to sputter, or the telnet > connection to crash. > > The first thing I'd do is to make sure each machine has a separate > quality NIC card and deactivate the on-board NICs...I've even had to > drop down to a 100MB card on some systems. > > Hope this helps a little. > > Bill > > > Simon: > > I wonder if these machines are using a 1GB ethernet card. > > 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 > > Simon Lewington > > Sent: Monday, March 20, 2006 1:58 AM > > To: u2-users@listserver.u2ug.org > > Subject: Re: [U2] UD telnet server > > > > "Steven Frost" wrote ... > > Hi -- we have UDT 6.1.5 running on a Windows 2003 server > > with a 5 user > > license but every now and then , usually within a > > week, the telnet > > service hangs and no logins are possible. UDT itself is > > OK. Restarting > > the UD telnet service fails, so then reboot is called for. > > > > Same problem on one of our customer's boxes. > > > > Unidata 6.1.5 > > Win 2000 sp 4 > > 4 user licence > > > > This is a test box on a test domain (in theory identical > > apart from the number of licences to the live box which > > is working file) so I've not raised > > it with IBM, and have just rebooted when necessary. > > > > Simon --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] D3 to UD conversion
Dave: Please feel free to post here, or to David directly. I haven't really wanted to irritate anyone on the list here; rather I've tried to just be as helpful as I can to those who can use the help. To such an end, I've been sending a fair number of emails off list. Those who've contacted me directly have been extremely kind and helpful, as has also, of course, been those who've posted publicly. Bill > -Original Message- > From: Dave Taylor [mailto:[EMAIL PROTECTED] > Sent: Friday, March 17, 2006 7:04 PM > To: Bill Haskett > Subject: Fw: [U2] D3 to UD conversion > > Hi Bill, > > Your very helpful comments to me today appeared to be sent > only to me and > not the the list. > > I think they would be most helpful also to David Wolverton > who has been a > part of this conversation in other msgs on the list. > > I would like to forward your comments to David if I have your > permission, > unless you have already done so. > > Please let me know if this would be all right with you. > > I will also mention our TAPE.DUMP and TAPE.LOAD programs and > our desire to > port our generic Pick spooler from Universe to Unidata. > > Thanks, > > Dave Taylor > > > - Original Message - > From: "Wally Terhune" <[EMAIL PROTECTED]> > To: > Sent: Friday, March 17, 2006 4:09 PM > Subject: Fw: [U2] D3 to UD conversion > > > > I know of a U2 partner who used a D3 pseudo drive and wrote > T-DUMP/T-LOAD > > routines to migrate data to UniData. Don't know the details, though. > > > > Wally Terhune > > U2 Support Architect > > IBM Information Management > > 4700 South Syracuse Street, Denver, CO 80237 > > Tel: 303.773.7969 > > Fax: 303.773.5915 > > [EMAIL PROTECTED] > > > > > > - Forwarded by Wally Terhune/Denver/IBM on 03/17/2006 > 05:06 PM - > > > > "David Wolverton" > > <[EMAIL PROTECTED] > > et> > To > > Sent by: > > > [EMAIL PROTECTED] > cc > > stserver.u2ug.org > > >Subject > >[U2] D3 to UD conversion > > 03/17/2006 04:48 > > PM > > > > > > > > > > > > > > > > > > I have a site running D3 Linux that is small, and would benefit from > > WorkGroup pricing - their current annual maintenance in D3 > is the same as > > new IBM UniData Seats will run... > > > > It this strictly a 'media move' - in that I cannot really > use a network or > > file to do the move? > > > > The client is not that big, but the tape drive they have on > their Linux > box > > is not anything I have on my Windows2K3 Server -- > > > > Is there a good way/any to do a Unix File move such that I > make a 'pseudo > > floppy/pseudo tape' on D3 and then take the resulting file > and feed it > into > > UniData's Account Restore process? > > > > One of the reasons I was so keen on Bill's experience was > that it sounded > > like experience I was about to have! > > > > David W. > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > > > > [demime 1.01d removed an attachment of type image/gif which > had a name of > pic01299.gif] > > > > [demime 1.01d removed an attachment of type image/gif which > had a name of > ecblank.gif] > > --- > > 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] D3 to UD conversion
David: Colin Alfke was able to use the UniData "ACCOUNT.RESTORE" utility. He was smart enough to get IBM support and not do this on UD PE. I'm going to purchase a 10 seat copy of UD for development and support this week. :-) With the appropriate D3 backup (the correct block size) data movement should be pretty straightforward. Colin sent me some instructions that I'd be happy to forward to you if you need them. Let me know if I can help. :-) Bill Haskett > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > David Wolverton > Sent: Friday, March 17, 2006 3:48 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] D3 to UD conversion > > I have a site running D3 Linux that is small, and would benefit from > WorkGroup pricing - their current annual maintenance in D3 is > the same as > new IBM UniData Seats will run... > > It this strictly a 'media move' - in that I cannot really use > a network or > file to do the move? > > The client is not that big, but the tape drive they have on > their Linux box > is not anything I have on my Windows2K3 Server -- > > Is there a good way/any to do a Unix File move such that I > make a 'pseudo > floppy/pseudo tape' on D3 and then take the resulting file > and feed it into > UniData's Account Restore process? > > One of the reasons I was so keen on Bill's experience was > that it sounded > like experience I was about to have! > > David W. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Triggers
Ken: ...Original Message... from Ken Wallis > It sounds like you feel exactly the same about UniData as I > did about D3 when I spent a few months contracting at a D3 > shop - antiquated stuff, how can anybody work with this when > xxx is so much better? Yea. There's a lot about D3 that wears on anyone; this explains why a lot of people want to convert. :-) > I'm not sure which MV enhancements you mean, but I suspect > the issue is really one of adapting to looking at things from > a different perspective. I would like to think our "perspective" differences is a basis for product improvement. :-) You should see what Microsoft has done with SQL Server 2005 and their admin tools; an impressive improvement from SQL Server 2000. Raining Data doesn't have the resources to achieve anywhere near this kind of improvement to D3. With IBM, however, one would think they would understand U2 can be improved (mostly to assist conversions and new users). I can only hope IBM will take the attitude that U2 can, and should, be improved to bring in other MV applications and encourage new application development. As always, thanks for your help and kind comments. :-) Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Triggers
David: Answers below. > -Original Message- > From: David Wolverton > Sent: Thursday, March 16, 2006 11:36 AM > To: 'Bill Haskett'; u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] Triggers > > What was the driving force to move from D3 to UniData? According to our client: 1) They want the IBM name, 2) D3 costs too much, 3) Support isn't what it should be, 4) D3 is less than stable, 5) Raining Data is treading water. > How difficult was the move - was it all green screen with > source code or more difficult? It wasn't that difficult. The biggest problems were UniData is like interfacing with Microdata in 1982...it's a time warp! The UniData environment is excruciatingly tedious and the lack of MV enhancements is what I'd expect from mvBASE (an end-of-line product). These issues cause our conversion to extend from about 30 man-days to close to 150 man-days. Those who use UniData have no clue about the issues with conversion. Why anyone involved with UniData wouldn't want it to be used by others is beyond my comprehension. > How did you actually DO the move - it's not like D3 files > will copy at any high level to UniData! They actually do. Colin has had success with "ACCOUNT.RESTORE" while I copied to UniVerse then to UniData (of course this digression did take about 10 man-days). > How long did it take to make the move (physically, once you > worked out the kinks)? We have about 4 man-months into this. We estimate if UniData had taken steps to update itself and provided a few utilities to assist in conversions we would have only taken about one man-month (30 days isn't bad for an enterprise application conversion). > Thanks -- I'm sure there are others here who would be > interested in knowing more about your migration... > > David W. > > -Original Message- > From: Bill Haskett > Sent: Tuesday, March 14, 2006 7:44 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] [UD] Triggers > > I've converted a client's system from D3 to UniData and > everything mostly works fine. One of the last items I > have to deal with are triggers. [snipped] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Trigger (singular)
Raymond: Thanks. I'm thinking the following ought to do the trick (unless, of course, I've missed something). :-) SUBROUTINE U2T.APVENDOR.U (ExecStat, DictFlag, atFILENAME, atID, atRECORD) ** Update trigger for APVENDOR file on UniData ** (C) Copyright 1985-2004, Advantos Systems, Inc. All Rights Reserved. ! ** Last Modified: 16 Mar 2006, wph ** First Created: 16 Mar 2006, wph ** Program Type-: Trigger (Web) ! ** Notes: ** ** This is a "trigger" program placed on the (APVENDOR) file. It has ** to execute all UPDATE triggers for this file. ** **---** ** ** **I N I T I A L I Z A T I O N** ** ** **---** * CALL U2.NAMES.BRIDGE.U (ExecStat, DictFlag, atFILENAME, atID, atRECORD) CALL U2.HOMETASTIC.UPD (ExecStat, DictFlag, atFILENAME, atID, atRECORD) * **** **** ** E N D O F P R O G R A M ** **** **----** * RETURN END Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) > -Original Message- > From: Raymond de Bourbon [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 16, 2006 2:21 PM > To: Bill Haskett; u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] Trigger (singular) > > Hi Bill, > > You are correct, Unidata only supports one trigger for both > update and delete. In order to have multiple triggers you > need a wrapper program... I can send you the source if you want. > > Regards > > Raymond de Bourbon > > > -Original Message- > From: "Bill Haskett" <[EMAIL PROTECTED]> > To: "u2-users@listserver.u2ug.org" > Sent: 16/03/06 21:03 > Subject: [U2] [UD] Trigger (singular) > > I'm almost done with triggers (thank goodness I only have a > few to create). > It appears UniData only allows one trigger created on a file > at a time. Is > this true? > > 2 Dtademo (0)-> LIST-TRIGGER APVENDOR > BEFORE UPDATE TRIGGER: U2.NAMES.BRIDGE.U > BEFORE DELETE TRIGGER: U2.NAMES.BRIDGE.D > 2 Dtademo (0)-> CREATE-TRIGGER APVENDOR U2.HOMETASTIC.UPD UPDATE > The specified trigger already exists. > > The documentation doesn't mention this at all. So, in order > to get multiple > triggers on a file would I have to create a "wrapper" BASIC > program that > CALLs each trigger program as a subroutine (or EXECUTEs each trigger > program)? > > Any enlightenment 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] [UD] Trigger (singular)
I'm almost done with triggers (thank goodness I only have a few to create). It appears UniData only allows one trigger created on a file at a time. Is this true? 2 Dtademo (0)-> LIST-TRIGGER APVENDOR BEFORE UPDATE TRIGGER: U2.NAMES.BRIDGE.U BEFORE DELETE TRIGGER: U2.NAMES.BRIDGE.D 2 Dtademo (0)-> CREATE-TRIGGER APVENDOR U2.HOMETASTIC.UPD UPDATE The specified trigger already exists. The documentation doesn't mention this at all. So, in order to get multiple triggers on a file would I have to create a "wrapper" BASIC program that CALLs each trigger program as a subroutine (or EXECUTEs each trigger program)? Any enlightenment would be appreciated. :-) Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] Triggers
I've converted a client's system from D3 to UniData and everything mostly works fine. One of the last items I have to deal with are triggers. I've read the UniData documentation on triggers and am intimately familiar with D3 triggers, so it's no wonder I'm confused about UniData triggers. Questions: 1) Can I create both an update and delete trigger on a file using the same BASIC program or do I need to create two separate programs? In D3 there's an internal function that indicates if the action is an add or delete. This allows a single program to be used for both an update and a delete. 2) How can I tell if a record is being added or changed? 3) Where do the passed variables come from? SUBROUTINE U2.NAMES.BRIDGE.U (ExecStat, DictFlag, FileName, RecIdExpr, RecValue) What specifically is "RecIdExpr"? The record key being updated (documentation says it's the record to be updated)? Is FileName the file name or the "opened" file (file variable)? Do I have to set "DictFlag"? It seems UniData requires a trigger to be defined as either UPDATE or DELETE. Does this mean I have to create two BASIC programs; one for updating and one for deleting? Any assistance 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] Determine path logged on users are in
How does one go about determining the account (path) other users are logged into? If I do an "LISTUSER" I get: 2 Dtademo (0)-> lu Licensed(UDT+CP)/Effective UdtSqliPhtmPooledTotal ( 2 + 0 ) / 210001 UDTNO USRNBR UID USRNAME USRTYPE TTY IP-ADDRESSTIME DATE 1 2232 197615 wphaskett udt pts/1 192.168.1.51 14:36:27 Mar 13 2006 2 1844 197615 wphaskett udt pts/2 192.168.1.51 18:17:13 Mar 13 2006 2 Dtademo (0)-> where E:\IBM\ud71\DtaDemo I'd like to allow some users to list all users logged onto their application (logged into their accounts) then give them the option to log them off. I'm not sure if this is possible in UniData. Any ideas would be appreciated. As always, 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] [UD] password
Is it possible to either extract the Windows password, in order to compare with an entered string, or to verify the entered string with the Windows password? A client's application we're converting requires the user to reenter their password to run some sensitive processes. Any help would be appreciated. Bill UniData v7.1 on Windows 2K3 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] Login
I've been logging into UniData v7.1 on Win 2K3 for a project and am finally asking a few questions about the login: 1) Do I have to type in the full path (instead of just the account), and 2) Am restricted (the 1st time I try) to sixteen characters in the path? Welcome to Advantos Telnet Server login: USERNAME Password: Path (E:\IBM\ud71\Dta) : E:\IBM\ud71\DtaDemo Unable to set current directory to E:\IBM\ud71\DtaD UniData telnet session terminating... If I try to log in again the path is set properly and I can just press [Enter] at that prompt to properly log into the DtaDemo account. Welcome to Advantos Telnet Server login: wphaskett Password: Path (E:\IBM\ud71\DtaDemo) : [Enter] UniData Release 7.1 Build: (3146) (c) Copyright IBM Corporation 2005. All rights reserved. Current UniData home is E:\IBM\ud71\. Current working directory is E:\IBM\ud71\DtaDemo. I've read all the manuals, I think, and can't find anything about this. 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/
RE: [U2] check signature
Steve: I always view hardware solutions as preferable. Put a reusable font (or signature) on a chip, then call it with a font#. Troy has these that can be controlled by software. You can also have soft fonts that can be downloaded to a printer for a particular purpose, like a signature font. When the check run is complete the signature font can be deleted from the printer. If you have more specific questions, ask. Hope this helps. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Thursday, March 09, 2006 3:44 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] check signature > > I am converting our AP Checks from tractor fed continuous > forms to laser print. They currently have a check signing > machine that they feed the stack of checks into after they > have printed. How do other companies handle check signing? Is > there a way to print a digitized signature from the basic > program? Any other ideas? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PCL extra page
Dave: Now I may be reading too much between the lines. :-) Our clients use printers from multiple applications; there are no MV only printers. So all printers have the appropriate Windows drivers installed. I've not seen where a print stream sent from an MV application gets altered by these Windows print drivers. What I was talking about was the reaction of the printer to this MV generated print stream. I've sent the same stream of text (a simple A/R customer report wrapped in PCL) to both HP, Canon, and Kyocera printers (all printers were PCL5 compatible). The string looked like: peqs '1' size = 7372 01 [EMAIL PROTECTED] ENTER LANGUAGE = PCL..[E[&l1o&l1e41F[&a3l105M[(s0p13h0s3b4099T...T/R 4.2.1 CUSTOMER NAME & INFORMATION FOR LAKEWOOD VIEW TWNHOME ASSN (450) THRU 30 Jan 05 PAGE1 02 . . 44 45 (C) Copyright 09:59:59 07 Mar 2006, Advantos Systems, Inc. All Rights Reserved. 46 .T/R 4.2.1 CUSTOMER NAME & INFORMATION FOR LAKEWOOD VIEW TWNHOME ASSN (605) THRU 30 Nov 04 PAGE2 47 . . 70 . 71 (C) Copyright 09:59:59 07 Mar 2006, Advantos Systems, Inc. All Rights Reserved. 72 .[E[%-12345X ...where '[' equals escape and the 1st '.' before each MV generated heading is a form feed generated by the MV AQL "HEADING" statement. What appears to happen is the Canon and Kyocera recognize the print buffer is empty (ignores the PCL code) and ignores this 1st form feed; which makes sense. The HP, on the other hand, simply kicks a page when it finds the 1st form feed. The [Esc]E doesn't kick the page on either the HP, Canon, or Kyocera. In order for us to solve this problem, we had to move the form feed from the 1st character of each mvDbms created heading to the end of each "...All Rights Reserved." part of the string. To do this, we were able to turn off the D3 created form feed completely (via TERM setting of formfeed delays to 0) and add a form feed to the end of the copyright text. Hopefully, I haven't missed the point completely. :-) Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) > -Original Message- > From: Dave Taylor [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 07, 2006 9:21 AM > To: Bill Haskett; u2-users@listserver.u2ug.org > Subject: Re: [U2] PCL extra page > > Bill, > > I may be reading too much between the lines here, but the following > statement: > > --- > Then, when this string is sent to the printer, HP interprets > "Pcl commands" > as text, so doesn't suppress the leading form feed...other > printers often > do. > -- > > suggests to me that the printer was installed using the manufacturer's > printer driver for that printer and that the printer driver > is performing > its usual tasks and, in addition, is not passing the ESC > sequences thru to > the printer: > > I didn't notice what platform you're running on, but on a > Windows platform, > we always install all Windows printers to be used by Universe > using the > Generic/Text driver found in the Generic Manufacturer's list > of printer > drivers. > > The Generic/Text driver performs no functions whatsoever, but > passes thru to > the printer all characters received by it, including ESC > sequences which the > printer interprets and reacts to correctly. > > I may be able to find a generic/text printer driver for > Windows to send you > if you don't have one. > > hth, > > Dave [snipped] > > - Original Message - > From: "Bill Haskett" <[EMAIL PROTECTED]> > To: > Sent: Tuesday, March 07, 2006 7:00 AM > Subject: RE: [U2] PCL extra page > > > > Steve: > > > > This is almost always limited to HP printers. > > > > What normally happens is that a print job always begins > with a form feed. > > When PCL preceeds this print job you get a string that looks like: > > > > Pcl commands : FF : Print job > > > > Then, when this string is sent to the printer, HP interprets "Pcl > commands" > > as text, so doesn't suppress the leading form feed...other > printers often > > do. > --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PCL extra page
Steve: This is almost always limited to HP printers. What normally happens is that a print job always begins with a form feed. When PCL preceeds this print job you get a string that looks like: Pcl commands : FF : Print job Then, when this string is sent to the printer, HP interprets "Pcl commands" as text, so doesn't suppress the leading form feed...other printers often do. In D3, I was able to start a printer and suppress the leading form feed. However, D3 interpreted "Pcl commands" as text so when the "Print job" was sent it got preceeded by a "FF" anyway. The only way I was able to resolve this was to remove all form feeds from the print job (you can turn this off in D3), use footings in all reports (we already did anyway), and append a "FF" to the end of the footing (our footing text resides in a file). I don't yet know what solution exists for U2 but I'll soon find out. :-( Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Sirulnick, Steve > Sent: Tuesday, March 07, 2006 4:47 AM > To: 'u2-users@listserver.u2ug.org' > Subject: [U2] PCL extra page > > Does anyone know why I could be getting an extra page that > spits out at the > beginning of a print job? This only happens when I format > the print job > with PCL first. It's almost like a banner page with nothing on it. > > Regards, > > Steve Sirulnick > Costa Fruit & Produce > 18 Bunker Hill Industrial Park > Boston, MA 02129 > Office: 617.912.8045 > Fax: 617.912.8145 > http://www.freshideas.com/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UD dictionary order and deleting from a select
I have a couple of questions. My first one is how to get rid of the "Do you want to ... (Y/N)" question when using select lists. For example: 2 Dtademo (0)-> SELECT DICT DTASCREENS = "2.1.2*]" 1 records selected to list 0. 2 Dtademo (0)>> DELETE (or delete) DICT DTASCREENS Do you want to delete records in select list?(Y/N)Y '2.1.2*ACTWY60' deleted. As a default, the presumption that I don't know I'm using a list is not accurate. Secondly, this causes problems in every script that uses a select list to delete, copy, etc. UDT.OPTIONS 16 only seems to address whether the items deleted are listed or just the delete count. The second question is what order are dictionaries used when including a definition in a listing? I read where the order of processing a dictionary is: 1) the dictionary of the file 2) the VOC 3) the DICT.DICT This does not seem to be true when listing a dictionary. For instance, a dictionary item (I-Descriptor) named "KEY1" only exists in VOC and I get the following: 1 Dtademo (0)-> LIST SCREENS SAMPLING 5 KEY1 LIST SCREENS SAMPLING 5 KEY1 13:11:12 Feb 28 2006 1 SCREENS . 0 0 LOGON LOGON 1 1 2 2 6.1 6.1 5 records listed 1 Dtademo (0)-> LIST VOC SAMPLING 5 KEY1 LIST VOC SAMPLING 5 KEY1 13:11:24 Feb 28 2006 1 @ID . STATS STATS COL.SPACES COL.SPACES WIN.PCRUN2 WIN.PCRUN2 A9 A9 WIN.SETPARAMWIN.SETPAR AM 5 records listed 1 Dtademo (0)-> LIST DTASCREENS SAMPLING 5 KEY1 LIST DTASCREENS SAMPLING 5 KEY1 13:11:33 Feb 28 2006 1 SCREENS . 2.7.1A 2.7.1A 2.7.1B 2.7.1B CONFIG.NEC-P5 CONFIG.NEC -P5 M.DOC.PRINT M.DOC.PRIN T 7.2.1_NEW 7.2.1_NEW 5 records listed 1 Dtademo (0)-> LIST DICT DTASCREENS SAMPLING 5 KEY1 Illegal attribute name: KEY1 1 Dtademo (0)-> LIST DICT DTASCREENS SAMPLING 5 USING VOC KEY1 LIST DICT DTASCREENS SAMPLING 5 USING VOC KEY1 13:23:31 Feb 28 2006 1 VOC... . @ID@ID 2.4.1*ACTW 2.4.1 Y60 0*ACTWY60 0 2.4.2*ACTW 2.4.2 Y60 1.2.1*ACTW 1.2.1 Y60 5 records listed Is this just the way it is or am I missing something? As always, any help would be appreciated. :-) Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UD OCONV from dictionaries
I'm trying to figure out why UD BASIC converts an empty string to five zeros on an OCONV "MR.." mask. USING the FMT function (FMT( , '5/0R')) works fine. AE DICT APOPEN CKDATE Top of "CKDATE" in "DICT APOPEN", 7 lines, 119 characters. *--: p 001: I The date of the check that paid this invoice. 002: OCONV( TRANS( "APCHECKS", CHECK_ID, 4, "X"), 'MR%5' ) 003: D2- 004: DATE PD 005: 8R 006: S 007: ...and UDT.OPTIONS 56 ON and UDT.OPTIONS 110 OFF. When I output the file using CKDATE, which is an empty string, I get: DATE PD. 12-31-67 ...and raw output (not converted for date) looks like: DATE PD. 0 The following adjustment to the dictionary: AE DICT APOPEN CKDATE Top of "CKDATE" in "DICT APOPEN", 7 lines, 119 characters. *--: p 001: I The date of the check that paid this invoice. 002: FMT( TRANS( "APCHECKS", CHECK_ID, 4, "X" ), '7/0R' ) 003: D2- 004: DATE PD 005: 8R 006: S 007: ...returns, correctly, the following: DATE PD. The OCONV function converts an empty string to a field of five zeros (0). Is there a fix for this, or is 'MR%5' an invalid mask? As always, 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/
RE: [U2] Changes to mail list configurations
David: I'm reminded of the building contractor who, when asked why there's no lock on the front and back doors, replies that none of the other doors in the house have locks on them...besides, you'll get used to it. It is a constant in the IT industry that we are all forced to overcome the lack of rationality and simplicity. (I see where I need to change the "TO" address when I click reply otherwise the reply goes to you, unless I remember to click the "Reply to All" button and remove you so as to not remind you of the consequences of responding to the list). :-) This could be worse, but aren't we all tired of dealing with this constant bull$%!t of taking different paths to process similar events (email receipt). I couldn't care less what Sun or MySql does; the MV market was built on rationality not inconvenient standards de'jour, so why should we have to "twiddle" with a simple reply due to some "technical" reason? Argh. Please forgive my attitude; I've almost completed a D3 to UniData conversion project and have been wondering why any non-MV developer would ever use U2 and any MV developer would use UniData. I'm sure I'll get over this soon though. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Logan, David (SST - Adelaide) > Sent: Monday, February 27, 2006 3:58 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Changes to mail list configurations > > This is a relatively minor change and the dark side of the > force seem to > be gathering strength against it. The list headers still have the u2ug > address in them and your rules should still apply. If not, then change > them so they do! > > Perhaps the dark side haven't really explained themselves well but I > can't understand what the fuss is about. There seem to be a number of > hypotheticals that assume people are incapable of managing change. > > I would note again, this is NOT a unique list situation. This is in > fact, a more common setup than one thinks. Perhaps somebody could > subscribe to the Sun Managers list, one does not reply to the > list, only > to the sender and the sender then publishes a summary, or > perhaps one or > two of the MySQL lists which use exactly this system. > > All lists to which I subscribe use their own methods for managing the > reply, you just get used to them. The subscribers to these > lists seem to > handle the situation quite well. In fact, I note recent > posters to this > list, have all managed to reply to the list without issue and > my outlook > rules have placed their messages in the correct folder. > > Regards > > > --- > ** _/ ** David Logan > *** _/ *** ITO Delivery Specialist - Database > *_/* Hewlett-Packard Australia Ltd > _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] > _/ _/ _/ _/ Desk: +618 8408 4273 > _/ _/ _/_/_/ Mobile: 0417 268 665 > *_/ ** > ** _/ Postal: 148 Frome Street, > _/ ** Adelaide SA 5001 > Australia > invent > --- > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Nichol > Sent: Tuesday, 28 February 2006 9:57 AM > To: Tony Gravagno; u2-users@listserver.u2ug.org > Subject: RE: [U2] Changes to mail list configurations > > At 14:03 27/02/06 -0800, Tony Gravagno wrote: > > >This is breaking all kinds of things including filters, > remailers, and > >maybe threading for some reader programs. It's going to create > confusion > >when people mail to one another off-list. And for anyone who isn't > >familiar with this completely unique solution people are > going to think > >they're responding to a list when they're responding to some person - > and > >we might start seeing ongoing inquiries about "hey, where did my > response > >go?" Sorry folks but I don't believe this is a good long-term > solution. I > >think we should go back to the way it was until a more standard > solution > >can be found. > > > >Tony > > For once, Tony, I totally agree with you All U2 list postings are > now > going to my "trash" bucket > > Please put it back to how it was... The knee jerk goes too > far t'other > way > > >Larry Hiscock wrote: > > > We have made some changes to the mailing list > configuration files in > > > an attempt to reduce some of the problems we have been > experiencing > > > these past few days. > > > >-- > >No virus found in this incoming message. > >Checked by AVG Anti-Virus. > >Version: 7.1.375 / Virus Database: 268.1.1/270 - Release > Date: 27/02/06 > > Regards, > > Bruce Nichol > Talon Computer Services > AL
RE: [U2] - Java - AJAX
Glen: You're a better man than I, being able to work with all these technologies! I've given up. People don't want what they say they want, nor do they want to minimize costs and maximize profit. Thanks to the educational system and current culture everything is now "form over substance". :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Glen > Batchelor [snipped] > Gah. I'm totally sick of web development. Just building a naviga- > tion structure that won't break in situation "Z" is a total PITA > these days. And NOooo, you can't have just a "plain-jane" text- > based web site anymore. It has to be "intuitive" and "visually > appealing". Whatever happen to plain `ole cross-the-board- > functionality? I guess the good `ole days went out when the > browser wars started. :/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] type-ahead buffer
Can the UniData type-ahead buffer be turned off? I know INPUTCLEAR/CLEARINPUT will clear it but how can I turn it off so a session cannot type ahead? 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] Why does IBM make it so hard on the Newbies?
Walter: Many of us feel your pain. There are numerous other "improvements", over the years, that would make the product slick and exciting for anyone to use. :-) I must add, however, the Windows installation is pretty painless. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Walter Vaughan > Sent: Friday, February 17, 2006 9:09 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] Why does IBM make it so hard on the Newbies? > > Tried to install UV Personal Edition on a RH-FedoraCore 3 > box. Now I must admit I am 3000% better admin on a FreeBSD > box than anything else, however it should never be this hard > to install demonstration software. > > 1) the installation PDF is dated 1995, which is fine, except > that all of the unix instructions were for everything but > what the download looks or acts like. > 2) the instructions are for pulling data from a CD or tape > "cpio" archive, but the download from IBM is a tar archive. > 3) you have to guess on how to extract the "./uv.load" > program from the STARTUP archive > 3.5) you have to guess that you have to change the options > for tape rewind and tape-no_rewind to be the same directory > that you untarred the download into. > 4) ./uv.load uses "uncompress" command which is not part of > the standard distribution of FC-3. I just edited it to use > "gunzip -d" instead > 5) ./uv.load calls binaries as part of the installation, > complaining about the lack of libstdc++.5 , nope only fix is > additional compat-libstdc++-8-3.3.4.2 RPM for i386 which > contained the needed .so > > I am not really whining about number #5, since that kind of > thing is hard to keep up to date with documentation, and with > the speed of versions of Red Hat in the last three years I > understand. They built it with RH 7.3 or whatever. > > But good *ord. > > IBM, Don't make it impossible for us to install PE without > mind reading skills. > > -- > Walter > --- > 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] [u2][ud] Poor select performance
Scott: This is true. I just tested a file loaded on three different mvDbms products and got the following results (all Windows servers were rebooted before testing): ** UniData on Dell 1425 w/2GB memory and 2SATA 80GB 7200 RAID0 drives ** :TIME 15:48:50 Feb 17 2006 :SELECT GLPOST WITH CLIENTNO = "605" 21565 records selected to list 0. :TIME 15:48:57 Feb 17 2006 :CLEARSELECT :COUNT GLPOST 870120 record(s) counted. ** D3 on IBM ThinkPad w/1GB memory and 1 60GB 7200 RPM drive ** :time 15:53:15 17 Feb 2006 Friday :select glpost with clientno = "605" [404] 21565 items selected out of 870120 items. :time 15:53:38 17 Feb 2006 Friday :clearselect ** UV on IBM ThinkPad w/1GB memory and 1 60GB 7200 RPM drive ** :TIME 16:01:17 17 FEB 2006 :SELECT GLPOST WITH CLIENTNO = "605" 21561 record(s) selected to SELECT list #0. :TIME 16:01:32 17 FEB 2006 :CLEARSELECT SELECT list number 0 cleared. :COUNT GLPOST 870114 records counted. So, your milage may vary. 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 Jerry Banker > Sent: Friday, February 17, 2006 2:13 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] [u2][ud] Poor select performance > > I selected 311000 records on our new Linux Dell 6800 server > and it took 5 seconds on our E450 Solaris system 30 > records took 1 minute 45 seconds. > It all depends on how much power you're working with. > > - Original Message - > From: "Scott Ballinger" <[EMAIL PROTECTED]> > To: > Sent: Friday, February 17, 2006 1:58 PM > Subject: RE: [U2] [u2][ud] Poor select performance > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of > > [EMAIL PROTECTED] > > Sent: Friday, February 10, 2006 6:09 AM > > To: u2-users@listserver.u2ug.org > > Subject: [U2] [u2][ud] Poor select performance > > > > [snip] > > Selecting a customer with 570 000 records can take 30 seconds. > > (example of statement SELECT A_FILE WITH FAKT.FINR = 66) > > Selecting other indexed values in the same file which gives > me 5 records > > out of the 5 million is very very fast. > > [snip] > > > > And my guess is that selecting a customer with 250 000 records takes > > about 15 seconds. This is likely normal, and probably as > fast as you can > > expect. Remember, that select (which takes 30 seconds) is building a > > string of 570 000 ids and delimiters, then passing it (or a > pointer to > > it?) back to you. This will not happen instantaneously, even if > > everything was already in memory. > > > > /Scott Ballinger > > Pareto Corporation > > Edmonds WA USA > > 206 713 6006 > > --- > > 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] Equivalent of CREATE.ACCOUNT and UV.ACCOUNT in unidata
Pankaj: According to the UniData manuals this is how accounts are created on Windows: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - There are three steps required to create a UniData account: 1.Use the MS-DOS mkdir command to create the directory that will house the account. The name of the UniData account directory can be in uppercase, lowercase, or mixed uppercase and lowercase. 2.Make the new directory your working directory. You can change to the directory with the MS-DOS cd command. 3.Use the UniData "newacct" command to create the VOC and other UniData-specific files in the directory. Note: You do not need to log in as Administrator to create a UniData account. However, you must have Change access in the account directory. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - It is true there is a UD.ACCOUNT file, but its contents seem to be dependent on what I enter as a new account in UniAdmin. You should get used to the idea of managing a number of UniData activities outside of UniData (security, backups, account creation, etc) and a lot of typical mvDbms activities just differently. Don't ask me why IBM hasn't fixed this but, I guess, UniData users don't think people should be converting to UniData. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Pankaj Gupta > Sent: Sunday, February 12, 2006 4:02 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] Equivalent of CREATE.ACCOUNT and UV.ACCOUNT in unidata > > Hi, > Can anyone please tell me the equivalent commands for > creating a new account in UNIDATA. Also how to see the > existing accounts in UNIDATA. > > I worked in Universe and the commands were CREATE.ACCOUNT. > One file UV.ACCOUNTS in UV account contains the list of > accounts. Is there any equivalent to these commands in UNIDATA? > > Thanks and regards, > Pankaj Gupta > --- > 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] backups
As an aside, what does one do when rebuilding a machine from one of these backups? 1) reinstall windows 2) reinstall UD into the previous UDTHOME directory 3) drag'n drop the old directory structure into UDTHOME and everything works, all accounts now exist? This is definitely cool. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett > Sent: Friday, February 10, 2006 9:52 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] backups > > Ken: > > Thank you very muchntbackup, here I come. :-) > > Bill > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis > > Sent: Thursday, February 09, 2006 8:31 PM > > To: u2-users@listserver.u2ug.org > > Subject: RE: [U2] [UD] backups > > > > Bill Haskett wrote: > > > > > I'm so confused. How does one go about doing a UniData (on > > > Windows) backup? > > > > The same way you back up any other application on Windows - using > > whatever windows tool you like, ideally against a quiescent > database - > > ie log everyone off, or do a dbpause. > > > > > 1) Drag & drop the @UDTHOME directory (but then how does > > one restore > > > it)? > > > > Yes, you can do that, but not everything has to live under > @UDTHOME of > > course. > > > > To restore files, you'd just drag and drop back the files you want. > > > > > 2) Is there some sort of "save" verb that I can use after I: > > >:SETTAPE 9 E:/Backups/UDBackups E:/Backups/UDBackups 512 > > > > No. > > > > > Following this, can one do something like a "SEL-RESTORE"? > > > > See above. > > > > Cheers, > > > > Ken > > --- > > 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] backups
Ken: Thank you very muchntbackup, here I come. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis > Sent: Thursday, February 09, 2006 8:31 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] backups > > Bill Haskett wrote: > > > I'm so confused. How does one go about doing a UniData (on > > Windows) backup? > > The same way you back up any other application on Windows - > using whatever windows tool you like, ideally against a > quiescent database - ie log everyone off, or do a dbpause. > > > 1) Drag & drop the @UDTHOME directory (but then how does > one restore > > it)? > > Yes, you can do that, but not everything has to live under > @UDTHOME of course. > > To restore files, you'd just drag and drop back the files you want. > > > 2) Is there some sort of "save" verb that I can use after I: > >:SETTAPE 9 E:/Backups/UDBackups E:/Backups/UDBackups 512 > > No. > > > Following this, can one do something like a "SEL-RESTORE"? > > See above. > > Cheers, > > Ken > --- > 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] backups
I'm so confused. How does one go about doing a UniData (on Windows) backup? 1) Drag & drop the @UDTHOME directory (but then how does one restore it)? 2) Is there some sort of "save" verb that I can use after I: :SETTAPE 9 E:/Backups/UDBackups E:/Backups/UDBackups 512 Following this, can one do something like a "SEL-RESTORE"? As always, 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/
RE: [U2] [UD] Break-on
; - > > Totals: PAYROLL TRUST ACCOUNT57,482.04 > > > > 9900 KEY BANK OF CALIFORNIA Checking 4000-64,729.34 > > 9900 KEY BANK OF CALIFORNIA Checking 4000 -925.00 > > - > > Totals: PROPERTY MANAGEMENT CORP. -65,654.34 > > > > -8,172.30 > > > >[405] 3 items listed out of 1089 items. > > > >This doesn't even come close to working in UniData; although > it works > >fine in UniVerse. I'm running in ECLTYPE P. It looks like: > > > >[UNIDATA] > >SORT BANKBOOK WITH PLANTNOS = "9800""9900" AND WITH YRMO = > "200411" > >BY-EXP PLANTNOS ID-SUPP BREAK-ON PLANTNOS " 'DL'" CURRBAL PLNT# CURR > >BAL. > > > > 9800 57,482.04 > >-925.00 > > > > 9900-64,729.34 > > 9900 57,482.04 > >-925.00 > > > >3 records listed > > > >[UNIVERSE] > >SORT BANKBOOK BY-EXP PLANTNOS ID-SUPP BREAK-ON PLANTNOS " > "DL"" CURRBAL > >PLNT# CURR BAL. > > > > 9800 57,482.04 > > > > 9900-64,729.34 > > 9900 -925.00 > > > > > >3 records listed. > > > >I've been fiddling with this for quite a while and am > obviously missing > >something. Can anyone help. 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-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] Break-on
I have a report I've been running in a Pick environment for years without problems. The data, using ECLTYPE P on UniData, looks like: [UNIDATA] SORT BANKBOOK WITH PLANTNOS = "9800""9900" AND WITH YRMO = "200411" BY PLANTNOS PLANTNOS TOTAL CURRBAL 22:45:48 Feb 07 2006 1 BANKBOOK... PLNT# CURR BAL. 28*2004119800 57,482.04 9900 -925.00 15*2004119900-64,729.34 = TOTAL -8,172.30 2 records listed One account has two plants associated with it while the other one has only one plant associated with it. On a Pick machine I do the following: [D3] :SSCROLL BANKBOOK WITH PLANTNOS = "9800""9900" AND WITH YRMO = "200411" BY-EXP PLANTNOS BY ATYPE_ACCTNO BY ATYPE_DESC ID-SUPP PLANTNOS BREAK-ON PNAME0 "Totals: 'UV'" BNAMES ATYPE_DESCS ATYPE_ACCTNOS TOTAL CURRBAL Command => SORT BANKBOOK 22:52:24 07 Feb 2006 PLNT# Name.. TypeDesc.. GLAcct CURR BAL. 9800 KEY BANK OF CALIFORNIA Checking 4000 57,482.04 - Totals: PAYROLL TRUST ACCOUNT57,482.04 9900 KEY BANK OF CALIFORNIA Checking 4000-64,729.34 9900 KEY BANK OF CALIFORNIA Checking 4000 -925.00 - Totals: PROPERTY MANAGEMENT CORP. -65,654.34 -8,172.30 [405] 3 items listed out of 1089 items. This doesn't even come close to working in UniData; although it works fine in UniVerse. I'm running in ECLTYPE P. It looks like: [UNIDATA] SORT BANKBOOK WITH PLANTNOS = "9800""9900" AND WITH YRMO = "200411" BY-EXP PLANTNOS ID-SUPP BREAK-ON PLANTNOS " 'DL'" CURRBAL PLNT# CURR BAL. 9800 57,482.04 -925.00 9900-64,729.34 9900 57,482.04 -925.00 3 records listed [UNIVERSE] SORT BANKBOOK BY-EXP PLANTNOS ID-SUPP BREAK-ON PLANTNOS " "DL"" CURRBAL PLNT# CURR BAL. 9800 57,482.04 9900 -64,729.34 9900 -925.00 3 records listed. I've been fiddling with this for quite a while and am obviously missing something. Can anyone help. 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/