RE: [U2] MV Fad
The reason large numbers of people don't attend spectrum, is that 90% of PICK users don't even know they use PICK. I was at the International CEBIT show in Sydney Australia today and I identified at least 3 Pick shops doing thriving business, but they were all sellinng solutions, not PICK. A number of software houses moved from PICK to other technologies, most of them have gone, whilst most PICK software houses have remained viable for years. With the IT depression of the last couple of years, you will find the proportion of PICK software houses to other will have increased in PICK's favour, as they are able to provide cost effective solutions. Regards David Jordan --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
[U2] Is there a better way?
I've got an attribute with value marks and sub-value marks. Is there a way that I can do a locate for a value that will give me both the value mark and sub-value make values in universe basic code. LIST1 = A:@SVM:B:@SVM:C:@VM:D:@SVM:E:@SVM:F If I want to find D I would like something to tell me it's location can be found at LIST1,2,1 ( VM = 2, SVM = 1) so I can quickly reference it. Is this possible? Thanks for any pointers. :) I used to be an Optimist until I knocked over the glass. Randy Smith Programmer/Analyst [EMAIL PROTECTED] http://users.adelphia.net/~lee_crystal/ http://www.sopranoboy.com Zaner Bloser http://www.zaner-bloser.com --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] Is there a better way?
Randy, If you are using UniBasic, there is a UniBasic command call FIND, that will do this job. If I remember correctly, I believe UniVerse has the same command, also. FIND is very similar to LOCATE. Hope this helps! Grant W. Boice, Jr. Systems Administrator Benchmark Electronics, Inc. Manassas Division 8500 Phoenix Drive Manassas, VA 20110 Phone: (703) 334-0156 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Web:www.bench.com http://www.bench.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 9:26 AM To: [EMAIL PROTECTED] Subject: [U2] Is there a better way? I've got an attribute with value marks and sub-value marks. Is there a way that I can do a locate for a value that will give me both the value mark and sub-value make values in universe basic code. LIST1 = A:@SVM:B:@SVM:C:@VM:D:@SVM:E:@SVM:F If I want to find D I would like something to tell me it's location can be found at LIST1,2,1 ( VM = 2, SVM = 1) so I can quickly reference it. Is this possible? Thanks for any pointers. :) I used to be an Optimist until I knocked over the glass. Randy Smith Programmer/Analyst [EMAIL PROTECTED] http://users.adelphia.net/~lee_crystal/ http://www.sopranoboy.com Zaner Bloser http://www.zaner-bloser.com --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] MV Fad
Better watch out, Jeff. Jeremy, a.k.a. Pope Innocent of the 8th century Transylvanian Church of the Immaculate Ellison, will have you crucified for heresy. The next thing you know, Jeff, you'll be talking just like Neo and Morpheus, Remember that Oracle is just a computer program. ;-) I've heard that PICK programmers are too arrogant to recognize a threat. Maybe that is why their database is losing to Oracle? :) Well, what are IBM's and Micro$leaze's excuses? Look at a legacy Oracle system with required database standards built in And the maintenance and consulting fees for which provide St. Larry with 85% of his profits. Licensing fees are a drop in the bucket because, like SAS, an Oracle DB ties a company to so much more. A stray bullet killed one bystander slightly. - from the Maryville (MO) Forum David Hanwell -Original Message- From: [EMAIL PROTECTED] On Behalf Of Jeff Ritchie Sent: Wednesday, May 05, 2004 6:50 PM EDT To: [EMAIL PROTECTED] Subject: RE: [U2] MV Fad And this month's Larry Ellison claim is ? Well, it will be coming in the next version, or the one after that, or at least some one has an email about it. If they didn't invent the term vaporware for Oracle they really should have. -Original Message- From: Jeremy Adell [EMAIL PROTECTED] Sent: Thursday, 6 May 2004 4:35 AM EDT To: [EMAIL PROTECTED] Subject: RE: [U2] MV Fad Stiletos? {SIC} Pink shoes? I can definitely see what these two have in common with a database. :) I've heard that PICK programmers are too arrogant to recognize a threat. Maybe that is why their database is losing to Oracle? :) Of course, now I will be labelled a heretic by the 12th century Catholic Church of database programmers, but really, look at those who designed the pick {SIC} systems. To last at anything, you have to be realistic about your threats and weaknesses. Look at a legacy Oracle system with required database standards built in and compare it to a PICK db with no standards and 20 years of maintenance. At the PICK convention in Vegas this year, maybe 500 people showed up. I heard 5 years ago there more like 5,000. Sound like a fad anyone? Maybe IBM can fix it. Yes, but Dawn, fads change. For example, I'm sure that you know that the fad among twentysomething female professionals used to be to wear pink or baby blue Nike jogging shoes to work and to carry their work shoes. Now when those women get off of a commuter train in Center City it looks like there's a morticians convention in town. They are all dressed in black business suits, hair tied back in a bun, and walking on ugly, clunky black Amish granny shoes. I can even feel the next fad coming, for suddenly stiletto shoes have made an appearance. I was walking up the stairs at Suburban Station, just fascinated by the twentysomething woman just in front of me who had: * a huge purse slung over her right shoulder, * a smaller purse in the crook of her right elbow, * the obligatory Starbucks travel mug in her right hand, and * a cell phone on which she was conversing in her left hand, all the while wobbling up the steps on thin 5 stiletto heels. It was a truly amazing athletic performance! ;-) Now, do we really want to be a fad? Behold I am become Death, the shatterer of worlds. - Vishnu, in the Hindu Bhagavad Gita. David Hanwell -Original Message- From: [EMAIL PROTECTED] On Behalf Of Dawn M. Wolthuis Sent: Wednesday, May 05, 2004 10:44 AM EDT To: u2- [EMAIL PROTECTED] Subject: [U2] MV Fad I'm just smilin' big and decided to pass this along in case it brings a smile to your face too. Others in the PICK world or MV arena have been chatting on comp.databases.theory for much longer than I have (Wol introduced me to it). But I've been on there for some months now, addressing the question of why we teach relational theory as if it were truth and yet non-1NF databases seem to yield greater flexibility and productivity when used in businesses. I've been asking a lot of questions and have learned quite a bit. I also invited others on comp.databases.pick to pipe up on a particular posting, and several folks (most of them likely on this list too - thanks!) piped up. And then today ... Someone chimed in about the MV Fad. So, there you have it -- you are not working with an outdated database, using an outdated data model -- now it's a fad! There are dollars in fads -- perhaps it's time to update our resumes. Smiles. --dawn P.S.-I would like to see non-relational data models (tree structures di-graphs in particular) really become more than a fad (the next thing after strict RELATIONAL) because they work well and should have more industry resources angled their way. So, there is more work to do. Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] Another 4GL
Mark, As a software business who has used a 4GL since 1985 to develop our software, I have never seen a 4GL that will generate an entire application. The BOM explosion shopfloor scheduling programs in our mfg. software are written Pick Basic, as are the translation programs in our EDI translator. Most of our data entry/update/review screens use Pick Basic subroutines after one or more entry fields and in the filing subroutine. The benefits of 4GL's are not that they never require the use of Pick Basic, but that they enable the development of software applications in a fraction of the time needed for writing applications entirely in Pick Basic, and that they improve the reliability of those applications by the use of standardized coding practices built into the 4GL. Add to any 4GL the capability of generating html-screens simultaneously with character-based screens, as se have, and you can reduce the time to develop browser-based software from months and years to hours and days. We face the same problem that you face when we are asked by a customer to support someone else's software that is written in a 4GL that we've never seen and that is totally undocumented, and we hate learning another 4GL just as much as you do. 4GL's are written by programmers to make their job easier and to enable them to be more productive. They are of greatest value to the businesses using their software supported either by in-house staff or a long-term software business. There is no doubt that the language most commonly used in Pick Basic and the 4GL's present a learning curve at first. Hopefully, by learning your customer's 4GL, you can assist them in preserving their software investment rather that just rolling in another application pkg. that may be easier for you to support. I understand that Fred has offered to assist you and he will do an excellent job for you. Best wishes, Dave Dave Taylor Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (F) 310-377-3550 www.sysmarkinfo.com - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 06, 2004 4:57 AM Subject: Re: [U2] Another 4GL Thanks. I was afraid of being stepped on. Hopefully it's not to hard to get going. My new client has a long list of needed changes. On another note, do programmers ever hit a wall with the functionality of program generators/4GL's such that they still spend a good amount of time writing straight code. Being a 100% straight code person, ie too many 4GL's to get good at, I tend to lean towards this solution as all of my other clients who have (had) code generators don't have the tools anymore and I'm enhancing finished code. thanks. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 11:01 PM Subject: Re: [U2] Another 4GL In a message dated 5/5/2004 8:52:10 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: Thus, any clues on where I could find more about the development tools. ScanNet is on the internet but only for their newer GUI developer stuff. The Programmer's Helper looks like generated code as opposed to parameter driven stuff. Thanks in advance. Mark Johnson Yes Mark, The Programmer's Helper generates code based on parameters. You can add code sections, but only if you use their tool to do it. Otherwise your changes are step on by the next programmer who does use their tool. Will Johnson --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] How to print value of variable used in a paragraph
Or... less elegantly, 0001: PA 0002: LIST VOC EVAL@ACCOUNT FIRST 1 HDR.SUP COL.SUP ID.SUP COUNT.SUP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Thursday, May 06, 2004 12:31 PM To: [EMAIL PROTECTED] Subject: RE: [U2] How to print value of variable used in a paragraph [mailto:[EMAIL PROTECTED] On Behalf Of ashish ratna How to display value of a variable in a paragraph... If I use DISPLAY @USER0 in the paragraph it just displays the text @USER0 and not the value of @USER0 Vanilla UV, UDT paragraph: you can't, but... I wrote my own verb that packs stuff from the command line into an inline prompt variable. ( What is called Inline-promts are really paragraph variables. the name of the variable is (sometimes) also a prompt. I think inline prompt is a poor name. ) PA ILPROMPT.DEF USER0 or anything you want @USER0 DISPLAY USER0 or anything you want The guts of my ilprompt.def program does the basic function: DATA @USER0 BREAK OFF ; HUSH ON DUM = ILPROMPT( 'A,USER0 or anything you want' ) HUSH OFF ; BREAK ON that makes it available subsequently in the calling paragraph. Of course, my DATA statement and ILPROMPT() arguments are more generalized parsing the command line for a variety of things, including a select or savedlists that does the equivalent of R(delim_string),... : Thanks in advance. Ashish. You're welcome in retrospect, Chuck --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users 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 [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] How to print value of variable used in a paragraph
I don't think there's a way to do that for @ variables in general, but for your @USERNO example, I always just put the paragraph line as WHO -Dianne ashish ratna wrote: Hi All, I want to know that- How to display value of a variable in a paragraph e.g. @USER0 tells us who is the user logged in. What is the command to display the value in variable through a universe paragraph. If I use DISPLAY @USER0 in the paragraph it just displays the text @USER0 and not the value of @USER0 Thanks in advance. Ashish. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] [UV] getting LISTU to show full user names or in raw for mat
Wow, another undocumented option. This could work if it was'nt so slow. Does anyone know why that port.status command runs so slow? Thanks for the help! -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 2:33 PM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] getting LISTU to show full user names or in raw format Hi Troy, There is an INTERNAL keyword that works with PORT.STATUS. Same deal as LIST.READU in that it returns everything separated by a value mark. It is detailed in the subroutine VMADMSUB.B in APP.PROGS. Look around line 11800 and you can see how it counts the number of attributes to tell you whether the user is a phantom, normal or other. HTH Regards David Logan --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] Get External Sql Data Dynamically
Take a look at BCI... this is the U2 feature that provides ODBC client functionality. I personally haven't used it, but several readers of this group have... Tom Firl Columbia Ultimate -Original Message- From: Kris Stevens [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 10:04 AM To: '[EMAIL PROTECTED]' Subject: [U2] Get External Sql Data Dynamically I am looking to setup a link from within unidata to a external SQL Db table. Has anybody done this? Background: This table needs to be maintained outside the unidata environment, but the data available inside the unidata environment. Any pointers would be nice to have. Thanks in advance! Kris Stevens Sr. Programmer/Analyst [EMAIL PROTECTED] St. Louis, MO --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] Get External Sql Data Dynamically
Yes, BCI is the tool. If you're on Unix, you also need to have an ODBC manager. Being on 64-bit HP-UX (which makes it hard to find compatible OTS software), we ended up using EasySoft's ODBC-ODBC bridge (they made a custom port to HP-UX for us), which is working great. Best, David Beahm Tom Firl wrote: Take a look at BCI... this is the U2 feature that provides ODBC client functionality. I personally haven't used it, but several readers of this group have... Tom Firl Columbia Ultimate --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] MV Fad
Ross and others, One would have to go back in time to around 1987 for those exciting attendance figures for Spectrum. The shows at that time were incredible events. Ask some of the old-timers like Charlie Noah and Henry Eggers - they can tell you some interesting stories about history. No, Pick isn't a fad, as fad's are fashion news. Most of us happen to work in an arena that is considered un-fashionable by mainstream IT, which tends to favor large staff and huge budgets that justify big salaries and senior IT titles. Pick shops don't generally have titles like chief information officer, Director of Information technology or Vice President of Information Systems. We tend to have a single programmer capable of supporting 500 users doing double duty as both support person and help desk while enhancing applications and running reports for management. We have allowed it to become an environment that is looked upon by management as a bastard child rather than as a valuable adjunct to the business. The mainstream world shines in their ability to sell management on their importance. I'll pose this question rhetorically to the group... what have we done to become the kicking post for CEO's and CFO's who now favor Oracle or even Microsoft SQL server as an environment? Essentially, we have tried to cheap out by telling ourselves and management that we can do it cheaper, when what we really should have been saying is that we can do it better, but we are going to need more money and more help and more education. We didn't get, because we didn't ask. Oracle sells because management buys in at the boardroom level or on the golf course where bragging is king and no one can brag about spending 50k on a database, but spending 2.5 million on Oracle implies bragging rights. Dick Pick although a gifted visionary in terms of seeing the elegance in the methodology to flexibly store and retrieve data, truly screwed up when Billy Gates asked hime if he would port Pick to a PC with two floppy disc drives, as he said no, go #$%(* yourself in a fit of pride. Lee Bacall http://www.binarystar.com Phone: +1 (954) 791-8575 Cell: +1 (954) 937-8989 - Original Message - From: Ross Ferris [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 8:51 PM Subject: RE: [U2] MV Fad I don't recall there EVER being 5,000 people at a Spectrum conference (not that I have been to many) - and based on the previous 2 years that I have attended, 500 sounds like an increase. By definition a fad is also relatively short lived to even make reference to 5 years ago indicates that this is not the case - and the first International Spectrum I went to was 1992 ?, so I think that for a 'fast paced' arena like technology, multi-valued is not a 'fad' . though the growth rate could always be better :-) Ross Ferris Stamina Software Visage an Evolution in Software Development --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] Get External Sql Data Dynamically
Thanks for the response. Here is a followup question, to verify I am asking my question clearly. What I am trying to do is: List MYLocalFILE where MyRemoteKey = X MyRemoteData where the MyLocalfile is a local unidata mv file. MyRemoteKey is a dict item that references the remote SQL table on the network. MyRemoteData is a dict item that returns the value from the remote SQL table. The clients would not have any software installed, just the server only. Would this need to be done in a datatel subroutine? Thanks! Kris Stevens -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Beahm Sent: Thursday, May 06, 2004 1:44 PM To: [EMAIL PROTECTED] Subject: Re: [U2] Get External Sql Data Dynamically Yes, BCI is the tool. If you're on Unix, you also need to have an ODBC manager. Being on 64-bit HP-UX (which makes it hard to find compatible OTS software), we ended up using EasySoft's ODBC-ODBC bridge (they made a custom port to HP-UX for us), which is working great. Best, David Beahm Tom Firl wrote: Take a look at BCI... this is the U2 feature that provides ODBC client functionality. I personally haven't used it, but several readers of this group have... Tom Firl Columbia Ultimate --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
[U2] D3 Master Dictionary
Pardon being a D3 question but someone may have run into this before. My new client has D3 on W2K. I edited MD BOB and made 001=PQN, 002=HTIME and 003=P, saved it and then type BOB at TCL and get [3] VERB?. I type LIST CUSTOMER and get output but when I type LIST MD = CUSTOMER I get nothing. I've found out that there's 2 MD's. One called MD which points to that accounts SYSTEM defined space and another called M/DICT which points to another account that contains the cataloged programs, filenames, verbs etc and lets BOB work. So my question is what would happen if I made MD point to that other account? Would I mess anything up. Their system runs 20/7 but I'm not there at 4am to try this. Please no VOC flames. Thanks. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] D3 Master Dictionary
Its been a while, but I seem to recall that Pick changed the name from MD to DM. Try placing your BOB there. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] -Original Message- From: Mark Johnson [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 3:46 PM To: [EMAIL PROTECTED] Subject: [U2] D3 Master Dictionary Pardon being a D3 question but someone may have run into this before. My new client has D3 on W2K. I edited MD BOB and made 001=PQN, 002=HTIME and 003=P, saved it and then type BOB at TCL and get [3] VERB?. I type LIST CUSTOMER and get output but when I type LIST MD = CUSTOMER I get nothing. I've found out that there's 2 MD's. One called MD which points to that accounts SYSTEM defined space and another called M/DICT which points to another account that contains the cataloged programs, filenames, verbs etc and lets BOB work. So my question is what would happen if I made MD point to that other account? Would I mess anything up. Their system runs 20/7 but I'm not there at 4am to try this. Please no VOC flames. Thanks. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] Is there a better way?
Use FIND rather than LOCATE for a whole-of-element search, or FINDSTR for a partial-element search. - Original Message - From: [EMAIL PROTECTED] Date: Thu, 6 May 2004 09:26:10 -0400 To: [EMAIL PROTECTED] Subject: [U2] Is there a better way? I've got an attribute with value marks and sub-value marks. Is there a way that I can do a locate for a value that will give me both the value mark and sub-value make values in universe basic code. LIST1 = A:@SVM:B:@SVM:C:@VM:D:@SVM:E:@SVM:F If I want to find D I would like something to tell me it's location can be found at LIST1,2,1 ( VM = 2, SVM = 1) so I can quickly reference it. Is this possible? Thanks for any pointers. :) I used to be an Optimist until I knocked over the glass. Randy Smith Programmer/Analyst [EMAIL PROTECTED] http://users.adelphia.net/~lee_crystal/ http://www.sopranoboy.com Zaner Bloser http://www.zaner-bloser.com --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] D3 Master Dictionary
AFAIK D3 doesn't like PQN in attribute 1 just PQ will work find (or N for a macro - loose the H prefix P lines) - this will solve your VERB issue. I would expect both MD and M/DICT to simply be null q-pointers and I assume that there was a typo when you said MD pointed to system space (did you mean MDS ?) Please feel free to email me direct rather than cluttering this list - happy to help you resolve any D3 issues (you never did say which account you were logged into in the first place, and there are other issues, like 'Is this account in the VME or the FSI' that can have an impact in terms of performance, reliability etc Ross Ferris Stamina Software Visage an Evolution in Software Development -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Friday, 7 May 2004 7:46 AM To: [EMAIL PROTECTED] Subject: [U2] D3 Master Dictionary Pardon being a D3 question but someone may have run into this before. My new client has D3 on W2K. I edited MD BOB and made 001=PQN, 002=HTIME and 003=P, saved it and then type BOB at TCL and get [3] VERB?. I type LIST CUSTOMER and get output but when I type LIST MD = CUSTOMER I get nothing. I've found out that there's 2 MD's. One called MD which points to that accounts SYSTEM defined space and another called M/DICT which points to another account that contains the cataloged programs, filenames, verbs etc and lets BOB work. So my question is what would happen if I made MD point to that other account? Would I mess anything up. Their system runs 20/7 but I'm not there at 4am to try this. Please no VOC flames. Thanks. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.677 / Virus Database: 439 - Release Date: 4/05/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.677 / Virus Database: 439 - Release Date: 4/05/2004 --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] D3 Master Dictionary
BTW, If you LIST MD WITH *A0 CUSTOMER it will parse through the entire file. If you LIST MD CUSTOMER it will go to that record directly. my 1 cent. - Original Message - From: Eugene Perry [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 06, 2004 7:05 PM Subject: Re: [U2] D3 Master Dictionary The highest file on a D3 system is known as MDS. It contains the account records. In your account called BOB, you have a file called MD which is the equivalent of VOC. It contains all the verbs, file definititions, cataloged programs etc. When you type LIST CUSTOMER, you are listing the customer file. If you want to list the MD for a record called CUSTOMER, which happens to be your CUSTOMER file, you could type LIST MD WITH *A0 CUSTOMER and it would display it. Eugene - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 06, 2004 3:45 PM Subject: [U2] D3 Master Dictionary Pardon being a D3 question but someone may have run into this before. My new client has D3 on W2K. I edited MD BOB and made 001=PQN, 002=HTIME and 003=P, saved it and then type BOB at TCL and get [3] VERB?. I type LIST CUSTOMER and get output but when I type LIST MD = CUSTOMER I get nothing. I've found out that there's 2 MD's. One called MD which points to that accounts SYSTEM defined space and another called M/DICT which points to another account that contains the cataloged programs, filenames, verbs etc and lets BOB work. So my question is what would happen if I made MD point to that other account? Would I mess anything up. Their system runs 20/7 but I'm not there at 4am to try this. Please no VOC flames. Thanks. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] Get External Sql Data Dynamically
Could Kris use an I-descriptor to call a BASIC SUBRoutine that uses BCI to retrieve the value in the SQL database? Tom Firl -Original Message- From: David Beahm [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 2:52 PM To: [EMAIL PROTECTED] Subject: Re: [U2] Get External Sql Data Dynamically BCI doesn't offer quite as tight an integration as that. What it gives you is the ability to read and write to SQL data sources from within UniBasic. For instance, we have a table that exists in MySQL, but we need to access the data from UniData (and for the moment we don't have time to change the user interface to support interfacing with UniData -- besides it made a good test case). Anyway, we were able to execute SQL queries against the external database from within a program. In your case, you might want to write a program that updates a local file with data from the SQL table. Then you can use all your familiar Retrieve logic (I-types, etc.) HTH, David Beahm Kris Stevens wrote: Thanks for the response. Here is a followup question, to verify I am asking my question clearly. What I am trying to do is: List MYLocalFILE where MyRemoteKey = X MyRemoteData where the MyLocalfile is a local unidata mv file. MyRemoteKey is a dict item that references the remote SQL table on the network. MyRemoteData is a dict item that returns the value from the remote SQL table. The clients would not have any software installed, just the server only. Would this need to be done in a datatel subroutine? Thanks! Kris Stevens -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Beahm Sent: Thursday, May 06, 2004 1:44 PM To: [EMAIL PROTECTED] Subject: Re: [U2] Get External Sql Data Dynamically Yes, BCI is the tool. If you're on Unix, you also need to have an ODBC manager. Being on 64-bit HP-UX (which makes it hard to find compatible OTS software), we ended up using EasySoft's ODBC-ODBC bridge (they made a custom port to HP-UX for us), which is working great. Best, David Beahm Tom Firl wrote: Take a look at BCI... this is the U2 feature that provides ODBC client functionality. I personally haven't used it, but several readers of this group have... Tom Firl Columbia Ultimate --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] D3 Master Dictionary
No, they changed that name of the SYSPROG account to DM. They also changed the name of the highest level file (where all the accounts are stored) from SYSTEM to MDS. Eugene - Original Message - From: Kryka, Richard [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 06, 2004 4:44 PM Subject: RE: [U2] D3 Master Dictionary Its been a while, but I seem to recall that Pick changed the name from MD to DM. Try placing your BOB there. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] -Original Message- From: Mark Johnson [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 3:46 PM To: [EMAIL PROTECTED] Subject: [U2] D3 Master Dictionary Pardon being a D3 question but someone may have run into this before. My new client has D3 on W2K. I edited MD BOB and made 001=PQN, 002=HTIME and 003=P, saved it and then type BOB at TCL and get [3] VERB?. I type LIST CUSTOMER and get output but when I type LIST MD = CUSTOMER I get nothing. I've found out that there's 2 MD's. One called MD which points to that accounts SYSTEM defined space and another called M/DICT which points to another account that contains the cataloged programs, filenames, verbs etc and lets BOB work. So my question is what would happen if I made MD point to that other account? Would I mess anything up. Their system runs 20/7 but I'm not there at 4am to try this. Please no VOC flames. Thanks. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] D3 Master Dictionary
Mark: Pardon being a D3 question but someone may have run into this before. My new client has D3 on W2K. I edited MD BOB and made 001=PQN, 002=HTIME and 003=P, saved it and then type BOB at TCL and get [3] VERB?. There are no PQN procs in D3 (I don't believe). Change field 001 to PQ. I type LIST CUSTOMER and get output but when I type LIST MD = CUSTOMER I get nothing. I'm not sure what's up since CUSTOMER is a file (or q pointer) and should reside in the MD. When you say you ...get nothing what do you mean (let's see the command and the result). I've found out that there's 2 MD's. One called MD which points to that accounts SYSTEM defined space and another called M/DICT which points to another account that contains the cataloged programs, filenames, verbs etc and lets BOB work. That's unusual. Usually the MD MD item is a q pointer to the current account and so is the MD M/DICT item. They're synonyms. There must be specific reasons to change that structure and I'm not going to guess. I'm not sure what you mean by the ...SYSTEM defined space but I'd guess you mean it points to the current account like: MD 'MD' size = 116 01 q 02 03 04 05 06 07 08 09 l 10 17 11 12 13 14 15 16 17 the item.id of a dictionary item is the name of the language element being defined. So my question is what would happen if I made MD point to that other account? Would I mess anything up. Their system runs 20/7 but I'm not there at 4am to try this. I'd suggest you NEVER mess with this as someone else has made the change for some reason. Normally the M/DICT item is a synonym to MD but is changed for some unknown reason. In D3, you can reference another accounts MD by simply referencing ACCOUNT,, or ACCOUNT,MD,. If the M/DICT item has changed I'd think there is a reference to M/DICT somewhere but won't guess where. I can't say for sure, but when you execute a verb the MD is searched first. I don't know if the M/DICT is searched next or at all. So, either the M/DICT MD item is inconsequential or it acts a little like a PATH. Maybe a posting to CDP would answer this. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users