[U2] MultiValue Video Series
Over the last few weeks, Elkie Holland from Prospectus IT (http://www.prospectus.co.uk/blog) created a series of video interviews with David Cooper, Lead Developer at BlueFinity International, on a variety of topics relevant to the MultiValue community. Please feel free to browse the video library: http://www.bluefinity.com/site/videos.html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Loading a UNIX-based UNIDATA file system on a Windows system...
And to add even further to the mix ... bear in mind my advice is about operating systems not U2, and my knowledge is UV not UD ... Are you SURE it's not needed if the source is Linux? Or do you actually mean Linux/x86? Certainly with UV, the OS is irrelevant, what matters is the endian-ness of the chip, so files can be freely copied between Intel machines regardless of OS. (Mind you, you probably can't get U2 for non-Intel linux :-) And nobody has even mentioned the file-corruption issue the OP asked about ... this is *probably* ftp. Could be samba. Anyways, you need to make sure that however you copy the files, you tell it that it is a binary file. If ftp or samba think it's a text file, it will translate between crlf and lf (and cr on a mac, I believe). Cheers, Wol On 06/11/12 21:03, Wally Terhune wrote: Fnuxi is UniVerse - not UniData. UDTBIN\convdata will convert the byte order of hashed files. If the source machine is Linux, this will not be necessary. You will need to run it - if the source UNIX is AIX, HPUX, Solaris. Convidx will convert UniData indexes. If you need to run programs: convcode Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Tuesday, November 06, 2012 1:49 PM To: U2 Users List Subject: Re: [U2] Loading a UNIX-based UNIDATA file system on a Windows system... After loading the data on the Windows system you will have to run fnuxi (C:\u2\UV\bin\fnuxi) on each file you wish to access. I would suggest you do this as follows: - locate the directory where the Unidata files are loaded - run fnuxi on the VOC and D_VOC - drop into Unidata and create a listing of the files in the directory (LIST ONLY VOC WITH F1 = F) output to the hold file and copy the list from the hold file to the directory containing the Unidata files - using the editor of your choice prefix each line in the file tie c:\u2\UV\bin\fnuxi.exe and save it as a windows .bat file - run the batch file to convert all the files. - edit the batch file and change all the filenames to D_filename - run it again Robert wrote: I have a client that has a client's tape containing the file system from a UNIDATA system running under some form of Unix. They want to load it up on a Windows PC and using the Windows version of UNIDATA, retrieve file data. I have seen in the past that sometimes a file from one OS (like Unix) was not able to be read under a different OS (Windows). This happened once to me with a PKZIP file. There was something slightly different about the file headers or something like that. So the question is, what is the best way to load the data? Is there a conversion utility that you run AFTER you load the data to convert any file header differences? Or are the file headers compatible? Or...? Robert Norman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Loading a UNIX-based UNIDATA file system on a Windows system...
and you want to make sure that the originating UNIX system does not have files named in both upper and lower case e.g. EMPLOYEES and employees. That causes some fun. Correct these on the UNIX side before an attempt is made. There are standard utilities e.g. NT_SCOUT for checking issues prior to conversion (written to _HOLD_) On UniData the simplest method of transferring ACCOUNTNAME from Unix to NT is:- tar -cvf MDB.tar ACCOUNTNAME compress MDB.tar This will then give you a single Unix file MDB.tar.Z which you can then ftp harmlessly. Accessing this file in NT will act as a zip file that can be extracted with folder names enabled. Go to the exploded NT directory and CONVMARK 255/192/129 ACCOUNTNAME CONVDATA -r ACCOUNTNAME CONVCODE ACCOUNTNAME CONVIDX -r ACCOUNTNAME UPDATEVOC -oca ACCOUNTNAME Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 07 November 2012 10:42 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Loading a UNIX-based UNIDATA file system on a Windows system... And to add even further to the mix ... bear in mind my advice is about operating systems not U2, and my knowledge is UV not UD ... Are you SURE it's not needed if the source is Linux? Or do you actually mean Linux/x86? Certainly with UV, the OS is irrelevant, what matters is the endian-ness of the chip, so files can be freely copied between Intel machines regardless of OS. (Mind you, you probably can't get U2 for non-Intel Linux :-) And nobody has even mentioned the file-corruption issue the OP asked about ... this is *probably* ftp. Could be samba. Anyways, you need to make sure that however you copy the files, you tell it that it is a binary file. If ftp or samba think it's a text file, it will translate between crlf and lf (and cr on a mac, I believe). Cheers, Wol On 06/11/12 21:03, Wally Terhune wrote: Fnuxi is UniVerse - not UniData. UDTBIN\convdata will convert the byte order of hashed files. If the source machine is Linux, this will not be necessary. You will need to run it - if the source UNIX is AIX, HPUX, Solaris. Convidx will convert UniData indexes. If you need to run programs: convcode Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Tuesday, November 06, 2012 1:49 PM To: U2 Users List Subject: Re: [U2] Loading a UNIX-based UNIDATA file system on a Windows system... After loading the data on the Windows system you will have to run fnuxi (C:\u2\UV\bin\fnuxi) on each file you wish to access. I would suggest you do this as follows: - locate the directory where the UniData files are loaded - run fnuxi on the VOC and D_VOC - drop into UniData and create a listing of the files in the directory (LIST ONLY VOC WITH F1 = F) output to the hold file and copy the list from the hold file to the directory containing the UniData files - using the editor of your choice prefix each line in the file tie c:\u2\UV\bin\fnuxi.exe and save it as a windows .bat file - run the batch file to convert all the files. - edit the batch file and change all the filenames to D_filename - run it again Robert wrote: I have a client that has a client's tape containing the file system from a UNIDATA system running under some form of Unix. They want to load it up on a Windows PC and using the Windows version of UNIDATA, retrieve file data. I have seen in the past that sometimes a file from one OS (like Unix) was not able to be read under a different OS (Windows). This happened once to me with a PKZIP file. There was something slightly different about the file headers or something like that. So the question is, what is the best way to load the data? Is there a conversion utility that you run AFTER you load the data to convert any file header differences? Or are the file headers compatible? Or...? Robert Norman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ== tflf2J7gTMnv4MtWkFx2NBVUENuAmfNZOqsCq9I+zBdpQ== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it
Re: [U2] Loading a UNIX-based UNIDATA file system on a Windows system...
Why not tar -cvzf MDB.tgz ACCOUNTNAME which will have the same effect as tar/compress. And depending on the nix system, if it's running samba and on the same net as the NT system, you should just be able to connect in Windows and do a drag-n-drop copy rather than faffing about with tar/compress/ftp. Or if it's a linux system you have the option of mount -t cifs ..., which I do regularly, then you can copy from the linux side to windows. Cheers, Wol On 07/11/12 11:37, Martin Braid wrote: and you want to make sure that the originating UNIX system does not have files named in both upper and lower case e.g. EMPLOYEES and employees. That causes some fun. Correct these on the UNIX side before an attempt is made. There are standard utilities e.g. NT_SCOUT for checking issues prior to conversion (written to _HOLD_) On UniData the simplest method of transferring ACCOUNTNAME from Unix to NT is:- tar -cvf MDB.tar ACCOUNTNAME compress MDB.tar This will then give you a single Unix file MDB.tar.Z which you can then ftp harmlessly. Accessing this file in NT will act as a zip file that can be extracted with folder names enabled. Go to the exploded NT directory and CONVMARK 255/192/129 ACCOUNTNAME CONVDATA -r ACCOUNTNAME CONVCODE ACCOUNTNAME CONVIDX -r ACCOUNTNAME UPDATEVOC -oca ACCOUNTNAME Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 07 November 2012 10:42 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Loading a UNIX-based UNIDATA file system on a Windows system... And to add even further to the mix ... bear in mind my advice is about operating systems not U2, and my knowledge is UV not UD ... Are you SURE it's not needed if the source is Linux? Or do you actually mean Linux/x86? Certainly with UV, the OS is irrelevant, what matters is the endian-ness of the chip, so files can be freely copied between Intel machines regardless of OS. (Mind you, you probably can't get U2 for non-Intel Linux :-) And nobody has even mentioned the file-corruption issue the OP asked about ... this is *probably* ftp. Could be samba. Anyways, you need to make sure that however you copy the files, you tell it that it is a binary file. If ftp or samba think it's a text file, it will translate between crlf and lf (and cr on a mac, I believe). Cheers, Wol On 06/11/12 21:03, Wally Terhune wrote: Fnuxi is UniVerse - not UniData. UDTBIN\convdata will convert the byte order of hashed files. If the source machine is Linux, this will not be necessary. You will need to run it - if the source UNIX is AIX, HPUX, Solaris. Convidx will convert UniData indexes. If you need to run programs: convcode Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Tuesday, November 06, 2012 1:49 PM To: U2 Users List Subject: Re: [U2] Loading a UNIX-based UNIDATA file system on a Windows system... After loading the data on the Windows system you will have to run fnuxi (C:\u2\UV\bin\fnuxi) on each file you wish to access. I would suggest you do this as follows: - locate the directory where the UniData files are loaded - run fnuxi on the VOC and D_VOC - drop into UniData and create a listing of the files in the directory (LIST ONLY VOC WITH F1 = F) output to the hold file and copy the list from the hold file to the directory containing the UniData files - using the editor of your choice prefix each line in the file tie c:\u2\UV\bin\fnuxi.exe and save it as a windows .bat file - run the batch file to convert all the files. - edit the batch file and change all the filenames to D_filename - run it again Robert wrote: I have a client that has a client's tape containing the file system from a UNIDATA system running under some form of Unix. They want to load it up on a Windows PC and using the Windows version of UNIDATA, retrieve file data. I have seen in the past that sometimes a file from one OS (like Unix) was not able to be read under a different OS (Windows). This happened once to me with a PKZIP file. There was something slightly different about the file headers or something like that. So the question is, what is the best way to load the data? Is there a conversion utility that you run AFTER you load the data to convert any file header differences? Or are the file headers compatible? Or...? Robert Norman
[U2] Multiple UniData Indexes in same select
Good morning, I should know this, but as the gray gets thicker, some of the old knowledge seeps away. If you have indexes on multiple attributes on a file in UniData AND you include both of those indexed attributes in the same Select statement, how does UniData know which index to use? Does it use both? Neither? Thanks in advance, Doug This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [OT] Sql Query
Our environment here is changing considerably and the focus is more and more inclusive of Sql database(s). My knowledge of Sql extends slightly past the ability to spell it. If I could get some suggestions on some good venues to learn the query language for this new database, it would be appreciated. There are so many books and venues out there, it is difficult to separate the good from the bad from the ugly. TIA, Barry Rogen ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Sql Query
I would advise that you learn about joins firste.g. http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.h tml -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: 07 November 2012 14:45 To: 'U2 Users List' Subject: [U2] [OT] Sql Query Our environment here is changing considerably and the focus is more and more inclusive of Sql database(s). My knowledge of Sql extends slightly past the ability to spell it. If I could get some suggestions on some good venues to learn the query language for this new database, it would be appreciated. There are so many books and venues out there, it is difficult to separate the good from the bad from the ugly. TIA, Barry Rogen ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Sql Query
If your just interested in an easy paced method, and not something you need to master tomorrow. Look into www.ed2go.com They work with many of the community colleges and offer many 6 week Mini-classes. They are not college credit classes, but they are fairly inexpensive apx $95.00 A class. I have taken a lot of these for fundamentals. The only thing I don't like, is when you want to do more, they only release the lessons twice a week, And you can't work ahead... The advantage is that the class is easy paced, and has an instructor (forum formatted for questions) that You can ask questions from, who will usually answer advanced questions that the course does not cover, just Because they can, not because they have to. George I was in the same boat. Also, If you don't apply it, it really makes it difficult. Setup a MySQL (WAMP) on A PC, and start playing with some database projects. I have found that having a PICK background gives me An unusual style in creating SQL queries, such as creating functions as mini I-DESC, then using the Functions in SQL queries vs trying to setup a complicated JOIN. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Wednesday, November 07, 2012 9:45 AM To: 'U2 Users List' Subject: [U2] [OT] Sql Query Our environment here is changing considerably and the focus is more and more inclusive of Sql database(s). My knowledge of Sql extends slightly past the ability to spell it. If I could get some suggestions on some good venues to learn the query language for this new database, it would be appreciated. There are so many books and venues out there, it is difficult to separate the good from the bad from the ugly. TIA, Barry Rogen ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Sql Query
I would love for someone to come out with a book that really does JOINS justice. Packed full of real examples that actually make sense -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, November 07, 2012 10:03 AM To: 'U2 Users List' Subject: Re: [U2] [OT] Sql Query I would advise that you learn about joins firste.g. http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.h tml -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: 07 November 2012 14:45 To: 'U2 Users List' Subject: [U2] [OT] Sql Query Our environment here is changing considerably and the focus is more and more inclusive of Sql database(s). My knowledge of Sql extends slightly past the ability to spell it. If I could get some suggestions on some good venues to learn the query language for this new database, it would be appreciated. There are so many books and venues out there, it is difficult to separate the good from the bad from the ugly. TIA, Barry Rogen ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multiple UniData Indexes in same select
It will never use both. Usually the first index command possible will be used. Although I believe an EQ will override an index with GE. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Farmer Sent: Wednesday, November 07, 2012 7:35 AM To: U2 Users List Subject: [U2] Multiple UniData Indexes in same select Good morning, I should know this, but as the gray gets thicker, some of the old knowledge seeps away. If you have indexes on multiple attributes on a file in UniData AND you include both of those indexed attributes in the same Select statement, how does UniData know which index to use? Does it use both? Neither? Thanks in advance, Doug This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Sql Query
Barry: My foray with ColdFusion has led to doing some UniVerse SQL things. As I struggle to get the machine to do what I think I want... I have found that it is less about the backend database and more about the middleware. Even though I tend to buy quite a lot of books... I have found the fastest SQL results by Googling. While I like the writings of author Larry Ullman... especially MySQL, Visual QuickStart Guide 2nd Edition, PeachPit Press... this book is not a silver bullet. The Rocket U2 SQL manuals are very worthwhile. I like the Dummies books. I have found that, although there are differences between, Oracle, SyBase, MS-SQL, Postgres, MySQL... my sense is that it is perhaps 98% overlap. A handy tool that I use with MySQL is HeidiSQL. Probably the best book is somewhere in the Oracle space. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Wednesday, November 07, 2012 9:45 AM To: 'U2 Users List' Subject: [U2] [OT] Sql Query Our environment here is changing considerably and the focus is more and more inclusive of Sql database(s). My knowledge of Sql extends slightly past the ability to spell it. If I could get some suggestions on some good venues to learn the query language for this new database, it would be appreciated. There are so many books and venues out there, it is difficult to separate the good from the bad from the ugly. TIA, Barry Rogen ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Sql Query
Barry: Also... check out Lynda.com --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Sql Query
Thank you all for places to get my foundation built. I think from there, I can build my own house Barry Rogen Senior Programmer/Analyst PNY Technologies, Inc. (973) 560-5327 bro...@pny.com We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, November 07, 2012 10:10 AM To: U2 Users List Subject: Re: [U2] [OT] Sql Query If your just interested in an easy paced method, and not something you need to master tomorrow. Look into www.ed2go.com They work with many of the community colleges and offer many 6 week Mini-classes. They are not college credit classes, but they are fairly inexpensive apx $95.00 A class. I have taken a lot of these for fundamentals. The only thing I don't like, is when you want to do more, they only release the lessons twice a week, And you can't work ahead... The advantage is that the class is easy paced, and has an instructor (forum formatted for questions) that You can ask questions from, who will usually answer advanced questions that the course does not cover, just Because they can, not because they have to. George I was in the same boat. Also, If you don't apply it, it really makes it difficult. Setup a MySQL (WAMP) on A PC, and start playing with some database projects. I have found that having a PICK background gives me An unusual style in creating SQL queries, such as creating functions as mini I-DESC, then using the Functions in SQL queries vs trying to setup a complicated JOIN. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Wednesday, November 07, 2012 9:45 AM To: 'U2 Users List' Subject: [U2] [OT] Sql Query Our environment here is changing considerably and the focus is more and more inclusive of Sql database(s). My knowledge of Sql extends slightly past the ability to spell it. If I could get some suggestions on some good venues to learn the query language for this new database, it would be appreciated. There are so many books and venues out there, it is difficult to separate the good from the bad from the ugly. TIA, Barry Rogen ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Sql Query
I often use www.w3schools.com for learning the many facets of SQL and integration of SQL with different products. This site though is not just limited to SQL, it is useful with other areas such as jquery, xml, asp.net, and php to name a few. If working in working with Unix and Windows environment I have found MobaXterm to be a wonderful cross platform software tool for management and development of my server and client machines. Daniel Nelson IT Manager Appalachian State University Bookstore nelso...@appstate.edu -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Wednesday, November 07, 2012 11:18 AM To: U2 Users List Subject: Re: [U2] [OT] Sql Query Thank you all for places to get my foundation built. I think from there, I can build my own house Barry Rogen Senior Programmer/Analyst PNY Technologies, Inc. (973) 560-5327 bro...@pny.com We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, November 07, 2012 10:10 AM To: U2 Users List Subject: Re: [U2] [OT] Sql Query If your just interested in an easy paced method, and not something you need to master tomorrow. Look into www.ed2go.com They work with many of the community colleges and offer many 6 week Mini-classes. They are not college credit classes, but they are fairly inexpensive apx $95.00 A class. I have taken a lot of these for fundamentals. The only thing I don't like, is when you want to do more, they only release the lessons twice a week, And you can't work ahead... The advantage is that the class is easy paced, and has an instructor (forum formatted for questions) that You can ask questions from, who will usually answer advanced questions that the course does not cover, just Because they can, not because they have to. George I was in the same boat. Also, If you don't apply it, it really makes it difficult. Setup a MySQL (WAMP) on A PC, and start playing with some database projects. I have found that having a PICK background gives me An unusual style in creating SQL queries, such as creating functions as mini I-DESC, then using the Functions in SQL queries vs trying to setup a complicated JOIN. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Wednesday, November 07, 2012 9:45 AM To: 'U2 Users List' Subject: [U2] [OT] Sql Query Our environment here is changing considerably and the focus is more and more inclusive of Sql database(s). My knowledge of Sql extends slightly past the ability to spell it. If I could get some suggestions on some good venues to learn the query language for this new database, it would be appreciated. There are so many books and venues out there, it is difficult to separate the good from the bad from the ugly. TIA, Barry Rogen ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Sql Query
While the given link is key... a bit of frustration that I have had with SQL is that... often I have data in more than two tables... following the first select list... there could be data in six or more tables. The joins that I have tried seem to max out at like... three tables. In UniBasic... it is easy to traverse tables. Suggestions would be appreciated. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, November 07, 2012 10:03 AM Subject: Re: [U2] [OT] Sql Query I would advise that you learn about joins firste.g. http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Sql Query
Hi Barry The first question with sql is - which sql? There are lots of variants, all offering very different capabilities and features (like U2 vs R83). SQL*Plus for Oracle is very different from TSQL for SQL Server: SQLite is a very 'standard' SQL but almost nobody uses the ANSI syntax to that level.. If you're an MSDN subscriber, Microsoft has partnered with PluralSight to offer some of their courses. I haven't done their SQL ones, but I have been through some of the other PluralSight stuff and it's been good. If not, download SQL Server Express anyway and the Management Studio. Then you want to download the adventureworks sample databases and then you can find some very good materials on MSDN and the SQL Server Books Online. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: 07 November 2012 16:18 To: U2 Users List Subject: Re: [U2] [OT] Sql Query Thank you all for places to get my foundation built. I think from there, I can build my own house Barry Rogen Senior Programmer/Analyst PNY Technologies, Inc. (973) 560-5327 bro...@pny.com We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, November 07, 2012 10:10 AM To: U2 Users List Subject: Re: [U2] [OT] Sql Query If your just interested in an easy paced method, and not something you need to master tomorrow. Look into www.ed2go.com They work with many of the community colleges and offer many 6 week Mini-classes. They are not college credit classes, but they are fairly inexpensive apx $95.00 A class. I have taken a lot of these for fundamentals. The only thing I don't like, is when you want to do more, they only release the lessons twice a week, And you can't work ahead... The advantage is that the class is easy paced, and has an instructor (forum formatted for questions) that You can ask questions from, who will usually answer advanced questions that the course does not cover, just Because they can, not because they have to. George I was in the same boat. Also, If you don't apply it, it really makes it difficult. Setup a MySQL (WAMP) on A PC, and start playing with some database projects. I have found that having a PICK background gives me An unusual style in creating SQL queries, such as creating functions as mini I-DESC, then using the Functions in SQL queries vs trying to setup a complicated JOIN. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Wednesday, November 07, 2012 9:45 AM To: 'U2 Users List' Subject: [U2] [OT] Sql Query Our environment here is changing considerably and the focus is more and more inclusive of Sql database(s). My knowledge of Sql extends slightly past the ability to spell it. If I could get some suggestions on some good venues to learn the query language for this new database, it would be appreciated. There are so many books and venues out there, it is difficult to separate the good from the bad from the ugly. TIA, Barry Rogen ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multiple UniData Indexes in same select
From the Using UniData manual: Alternate Indexes in UniQuery Statement Prior to UniData 5.2, only one index was used in the selection criteria of a UniQuery statement, even if the selection criteria contained more than one indexed attribute. UniQuery now uses all available indexes when processing a statement containing selection criteria.Note: You cannot use an alternate index with a LIKE clause when the comparative attribute is numeric. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Farmer Sent: Wednesday, November 07, 2012 7:35 AM To: U2 Users List Subject: [U2] Multiple UniData Indexes in same select Good morning, I should know this, but as the gray gets thicker, some of the old knowledge seeps away. If you have indexes on multiple attributes on a file in UniData AND you include both of those indexed attributes in the same Select statement, how does UniData know which index to use? Does it use both? Neither? Thanks in advance, Doug This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Multi-Level Files
Am not sure why you would be getting the last hashed dictionary item passed. However, I think you would need to pass something other than @ID to your subroutine - a multivalue of files via another I descriptor with subroutine. Don't know about in UniData but in UniVerse VOC4 has M and 7 an mv of data sections. The file to open is AccountPath/APOPEN/HISTORY for instance. As an alternative you could try using a Q pointer to each data section. HTH Brett Bill Haskett wphask...@advantos.net wrote in message news:5095a055.8090...@advantos.net... I build the following subroutine to be used by a dictionary. SUBROUTINE D.GETFILEINFO ( Value, atID ) * ** Get information on file using FILEINFO() * ** Initialize local variables SP1 = ' ' NULL$ = '' * ** Assign passed variables Value= NULL$ ; ** initialize return variable FileName = atID ; ** the name of the file (key) * ** Open the file and get the file information to pass back OPEN '', FileName TO FileName.FV THEN Modulo= FILEINFO(FileName.FV, 5) BlockSize = FILEINFO(FileName.FV, 8) BlockCode = INT(BlockSize / 1024) Value = Modulo : ',' : BlockCode CLOSE FileName.FV END ELSE Value = NULL$ END * RETURN END I use this program in a dictionary item called F_SIZE. 3 Dev (0)- AE VOC F_SIZE Top of F_SIZE in VOC, 6 lines, 95 characters. *--: P 001: I Return the file information on the defined size 002: SUBR ( D.GETFILEINFO, @ID ) 003: 004: FileInfo 005: 10R 006: S Bottom. ...which returns the size of the file. When I use this on a multi-level file it fails to return the file size. e.g. 3 Dev (0)- LIST VOC 'APOPEN''APPO' F_DATAW F_SIZE LIST VOC 'APOPEN''APPO' F_DATAW F_SIZE 14:50:50 Nov 03 2012 1 VOC... Data Location FileInfo.. APOPEN APOPEN HISTORY HOLD APPO APPO11,1 2 records listed It works fine on regular files. I tracked the problem down to UniData doesn't pass in the name of the file to the called subroutine, @ID doesn't work. What is passed is the last hashed dictionary item of the APOPEN dictionary file. When I put a CRT statement in the program code just below where the FileName variable is assigned... CRT FileName ...the list output looks like this: 3 Dev (0)- LIST VOC 'APOPEN''APPO' F_DATAW F_SIZE *BALANCE* LIST VOC 'APOPEN''APPO' F_DATAW F_SIZE 14:50:50 Nov 03 2012 1 VOC... Data Location FileInfo.. APOPEN APOPEN HISTORY HOLD *APPO* APPO APPO11,1 2 records listed I discovered this because I listed the dictionary of the APOPEN file; which looks like: 3 Dev (0)- LIST DICT APOPEN NOPAGE LIST DICT APOPEN NOPAGE 14:51:11 Nov 03 2012 1 Dict Name.. ACCT_F REP TEST2 @UQ ACCT_L . CHECK_ID @HOLD @APOPEN VNAME20 . APPROVED @ID AS_LKS . BNAME CBALANCE ACCTS_VCNT ACCT_CNT AMTS1 APMY *BALANCE* 99 records listed ...and BALANCE, which UD passes into the subroutine, happens to be the last dictionary item hashed into the APOPEN dictionary file. Any idea why this is the case, or is this some kind of feature. -- Untitled Page Bill Haskett ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This message contains information that may be privileged or confidential and is the property of GPM Development Ltd. It is intended only for the person to whom it is addressed. If you are not the intended recipient ,you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. This e-mail was sent to you by GPM Development Ltd. We are incorporated under the laws of England and Wales (company no. 2292156 and VAT registration no. 523 5622 63). Our registered office is 6th Floor, AMP House, Croydon, Surrey CR0 2LX. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multiple UniData Indexes in same select
Excellent news. However, is there a way to utilize two indexes with the SELECTINDEX command in Unibasic? Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Wednesday, November 07, 2012 11:47 AM To: U2 Users List Subject: Re: [U2] Multiple UniData Indexes in same select From the Using UniData manual: Alternate Indexes in UniQuery Statement Prior to UniData 5.2, only one index was used in the selection criteria of a UniQuery statement, even if the selection criteria contained more than one indexed attribute. UniQuery now uses all available indexes when processing a statement containing selection criteria.Note: You cannot use an alternate index with a LIKE clause when the comparative attribute is numeric. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Farmer Sent: Wednesday, November 07, 2012 7:35 AM To: U2 Users List Subject: [U2] Multiple UniData Indexes in same select Good morning, I should know this, but as the gray gets thicker, some of the old knowledge seeps away. If you have indexes on multiple attributes on a file in UniData AND you include both of those indexed attributes in the same Select statement, how does UniData know which index to use? Does it use both? Neither? Thanks in advance, Doug This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multiple UniData Indexes in same select
Thanks Wally. I was waiting for the official word. John Israel -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Wednesday, November 07, 2012 11:47 AM To: U2 Users List Subject: Re: [U2] Multiple UniData Indexes in same select From the Using UniData manual: Alternate Indexes in UniQuery Statement Prior to UniData 5.2, only one index was used in the selection criteria of a UniQuery statement, even if the selection criteria contained more than one indexed attribute. UniQuery now uses all available indexes when processing a statement containing selection criteria.Note: You cannot use an alternate index with a LIKE clause when the comparative attribute is numeric. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Farmer Sent: Wednesday, November 07, 2012 7:35 AM To: U2 Users List Subject: [U2] Multiple UniData Indexes in same select Good morning, I should know this, but as the gray gets thicker, some of the old knowledge seeps away. If you have indexes on multiple attributes on a file in UniData AND you include both of those indexed attributes in the same Select statement, how does UniData know which index to use? Does it use both? Neither? Thanks in advance, Doug This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multiple UniData Indexes in same select
No on UniBasic SELECTINDEX statement. Not sure I'd call a change made at UniData 5.2 in June of 2000 as 'news'. :-) Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Wednesday, November 07, 2012 9:54 AM To: U2 Users List Subject: Re: [U2] Multiple UniData Indexes in same select Excellent news. However, is there a way to utilize two indexes with the SELECTINDEX command in Unibasic? Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Wednesday, November 07, 2012 11:47 AM To: U2 Users List Subject: Re: [U2] Multiple UniData Indexes in same select From the Using UniData manual: Alternate Indexes in UniQuery Statement Prior to UniData 5.2, only one index was used in the selection criteria of a UniQuery statement, even if the selection criteria contained more than one indexed attribute. UniQuery now uses all available indexes when processing a statement containing selection criteria.Note: You cannot use an alternate index with a LIKE clause when the comparative attribute is numeric. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Farmer Sent: Wednesday, November 07, 2012 7:35 AM To: U2 Users List Subject: [U2] Multiple UniData Indexes in same select Good morning, I should know this, but as the gray gets thicker, some of the old knowledge seeps away. If you have indexes on multiple attributes on a file in UniData AND you include both of those indexed attributes in the same Select statement, how does UniData know which index to use? Does it use both? Neither? Thanks in advance, Doug This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multiple UniData Indexes in same select
The first one -Original Message- From: Doug Farmer dfar...@epicor.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Nov 7, 2012 6:35 am Subject: [U2] Multiple UniData Indexes in same select Good morning, I should know this, but as the gray gets thicker, some of the old knowledge seeps away. If you have indexes on multiple attributes on a file in UniData AND you include both of those indexed attributes in the same Select statement, how does UniData know which index to use? Does it use both? Neither? Thanks in advance, Doug This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multiple UniData Indexes in same select
What about Universe? -Original Message- From: Wally Terhune wterh...@rocketsoftware.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Nov 7, 2012 9:05 am Subject: Re: [U2] Multiple UniData Indexes in same select No on UniBasic SELECTINDEX statement. Not sure I'd call a change made at UniData 5.2 in June of 2000 as 'news'. :-) Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Wednesday, November 07, 2012 9:54 AM To: U2 Users List Subject: Re: [U2] Multiple UniData Indexes in same select Excellent news. However, is there a way to utilize two indexes with the SELECTINDEX command in Unibasic? Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Wednesday, November 07, 2012 11:47 AM To: U2 Users List Subject: Re: [U2] Multiple UniData Indexes in same select From the Using UniData manual: Alternate Indexes in UniQuery Statement Prior to UniData 5.2, only one index was used in the selection criteria of a UniQuery statement, even if the selection criteria contained more than one indexed attribute. UniQuery now uses all available indexes when processing a statement containing selection criteria.Note: You cannot use an alternate index with a LIKE clause when the comparative attribute is numeric. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Farmer Sent: Wednesday, November 07, 2012 7:35 AM To: U2 Users List Subject: [U2] Multiple UniData Indexes in same select Good morning, I should know this, but as the gray gets thicker, some of the old knowledge seeps away. If you have indexes on multiple attributes on a file in UniData AND you include both of those indexed attributes in the same Select statement, how does UniData know which index to use? Does it use both? Neither? Thanks in advance, Doug This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multiple UniData Indexes in same select
Appreciate the answer! I was going to guess it only used the first one. Doug -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Wednesday, November 07, 2012 11:05 AM To: U2 Users List Subject: Re: [U2] Multiple UniData Indexes in same select No on UniBasic SELECTINDEX statement. Not sure I'd call a change made at UniData 5.2 in June of 2000 as 'news'. :-) Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Wednesday, November 07, 2012 9:54 AM To: U2 Users List Subject: Re: [U2] Multiple UniData Indexes in same select Excellent news. However, is there a way to utilize two indexes with the SELECTINDEX command in Unibasic? Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Wednesday, November 07, 2012 11:47 AM To: U2 Users List Subject: Re: [U2] Multiple UniData Indexes in same select From the Using UniData manual: Alternate Indexes in UniQuery Statement Prior to UniData 5.2, only one index was used in the selection criteria of a UniQuery statement, even if the selection criteria contained more than one indexed attribute. UniQuery now uses all available indexes when processing a statement containing selection criteria.Note: You cannot use an alternate index with a LIKE clause when the comparative attribute is numeric. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Farmer Sent: Wednesday, November 07, 2012 7:35 AM To: U2 Users List Subject: [U2] Multiple UniData Indexes in same select Good morning, I should know this, but as the gray gets thicker, some of the old knowledge seeps away. If you have indexes on multiple attributes on a file in UniData AND you include both of those indexed attributes in the same Select statement, how does UniData know which index to use? Does it use both? Neither? Thanks in advance, Doug This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/ggi6XfpTfmPGX2PQPOmvUmET9b5tVcUOeAv!B!MNW r18fpuHNY5rzXyEfMBpW7rnUENuAmfNZOrX405xsHCs!A== to report this email as spam. This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in
Re: [U2] [UD] Multi-Level Files
Thanks Brett. It turns out that UD works this way. The solution was to also pass in @RECORD. Even though @ID passed in the wrong ID, @RECORD passed in the correct VOC item. So, I was able to read attribute #2 (the data file path) then proceed from there. In addition, if this was an LF file then I parsed through the dictionary to find the data files, then got each data file's information. Passing back as an MV comes out just fine. So a query can look like: 2 Dev (0)- LIST VOC 'APOPEN''APPO' F_DATA F_SIZE LIST VOC 'APOPEN''APPO' F_DATA F_SIZE 09:12:59 Nov 07 2012 1 VOC... Data Location FileInfo.. APOPEN APOPEN 31,4 HISTORY 1999,4 HOLD 5,1 APPO APPO11,1 2 records listed Although this doesn't work well for multi-level files in other accounts, especially using environment variables for the path, it worked for my purposes here. Bill Untitled Page - Original Message - *From:* bre...@gpmdev.co.uk *To:* u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org *Date:* 11/7/2012 8:51 AM *Subject:* Re: [U2] [UD] Multi-Level Files Am not sure why you would be getting the last hashed dictionary item passed. However, I think you would need to pass something other than @ID to your subroutine - a multivalue of files via another I descriptor with subroutine. Don't know about in UniData but in UniVerse VOC4 has M and 7 an mv of data sections. The file to open is AccountPath/APOPEN/HISTORY for instance. As an alternative you could try using a Q pointer to each data section. HTH Brett Bill Haskett wphask...@advantos.net wrote in message news:5095a055.8090...@advantos.net... I build the following subroutine to be used by a dictionary. SUBROUTINE D.GETFILEINFO ( Value, atID ) * ** Get information on file using FILEINFO() * ** Initialize local variables SP1 = ' ' NULL$ = '' * ** Assign passed variables Value= NULL$ ; ** initialize return variable FileName = atID ; ** the name of the file (key) * ** Open the file and get the file information to pass back OPEN '', FileName TO FileName.FV THEN Modulo= FILEINFO(FileName.FV, 5) BlockSize = FILEINFO(FileName.FV, 8) BlockCode = INT(BlockSize / 1024) Value = Modulo : ',' : BlockCode CLOSE FileName.FV END ELSE Value = NULL$ END * RETURN END I use this program in a dictionary item called F_SIZE. 3 Dev (0)- AE VOC F_SIZE Top of F_SIZE in VOC, 6 lines, 95 characters. *--: P 001: I Return the file information on the defined size 002: SUBR ( D.GETFILEINFO, @ID ) 003: 004: FileInfo 005: 10R 006: S Bottom. ...which returns the size of the file. When I use this on a multi-level file it fails to return the file size. e.g. 3 Dev (0)- LIST VOC 'APOPEN''APPO' F_DATAW F_SIZE LIST VOC 'APOPEN''APPO' F_DATAW F_SIZE 14:50:50 Nov 03 2012 1 VOC... Data Location FileInfo.. APOPEN APOPEN HISTORY HOLD APPO APPO11,1 2 records listed It works fine on regular files. I tracked the problem down to UniData doesn't pass in the name of the file to the called subroutine, @ID doesn't work. What is passed is the last hashed dictionary item of the APOPEN dictionary file. When I put a CRT statement in the program code just below where the FileName variable is assigned... CRT FileName ...the list output looks like this: 3 Dev (0)- LIST VOC 'APOPEN''APPO' F_DATAW F_SIZE *BALANCE* LIST VOC 'APOPEN''APPO' F_DATAW F_SIZE 14:50:50 Nov 03 2012 1 VOC... Data Location FileInfo.. APOPEN APOPEN HISTORY HOLD *APPO* APPO APPO11,1 2 records listed I discovered this because I listed the dictionary of the APOPEN file; which looks like: 3 Dev (0)- LIST DICT APOPEN NOPAGE LIST DICT APOPEN NOPAGE 14:51:11 Nov 03 2012 1 Dict Name.. ACCT_F REP TEST2 @UQ ACCT_L . CHECK_ID @HOLD @APOPEN VNAME20 . APPROVED @ID AS_LKS . BNAME CBALANCE ACCTS_VCNT ACCT_CNT AMTS1 APMY *BALANCE* 99 records listed ...and BALANCE, which UD passes into the subroutine, happens to be the last dictionary item hashed into the APOPEN dictionary file. Any idea why this is the case, or is this some kind of feature. -- Untitled Page Bill Haskett ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Sql Query
On 07/11/12 16:31, Bill Brutzman wrote: While the given link is key... a bit of frustration that I have had with SQL is that... often I have data in more than two tables... following the first select list... there could be data in six or more tables. The joins that I have tried seem to max out at like... three tables. In UniBasic... it is easy to traverse tables. Suggestions would be appreciated. --Bill A hint for both you and Barry ... ASSUMEing your back-end database has a half-way decent query optimiser, try creating views that match what you would expect to put in a MV FILE. Then do your selects against those views. The query optimiser should do all the hard work of building up a good query, stripping out redundant accesses, etc etc. But that way, you can make SQL behave a bit like MV until you've got to grips with it. You know my feelings :-) MV makes a far better relational back-end than a relational database, but you do have to design that back-end properly otherwise what comes out is ... Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multiple UniData Indexes in same select
On 07/11/12 17:18, Wjhonson wrote: What about Universe? imho, it just doesn't make logical sense in BASIC! just do SELECTINDEX, READLIST, SELECTINDEX, READLIST and then manipulate it yourself. Okay, that's more hassle, but IME the results of reading the index file always give me a sorted list, so doing a union or intersect of two sorted lists isn't that tricky. Cheers, Wol -Original Message- From: Wally Terhune wterh...@rocketsoftware.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Nov 7, 2012 9:05 am Subject: Re: [U2] Multiple UniData Indexes in same select No on UniBasic SELECTINDEX statement. Not sure I'd call a change made at UniData 5.2 in June of 2000 as 'news'. :-) Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Wednesday, November 07, 2012 9:54 AM To: U2 Users List Subject: Re: [U2] Multiple UniData Indexes in same select Excellent news. However, is there a way to utilize two indexes with the SELECTINDEX command in Unibasic? Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Wednesday, November 07, 2012 11:47 AM To: U2 Users List Subject: Re: [U2] Multiple UniData Indexes in same select From the Using UniData manual: Alternate Indexes in UniQuery Statement Prior to UniData 5.2, only one index was used in the selection criteria of a UniQuery statement, even if the selection criteria contained more than one indexed attribute. UniQuery now uses all available indexes when processing a statement containing selection criteria.Note: You cannot use an alternate index with a LIKE clause when the comparative attribute is numeric. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Farmer Sent: Wednesday, November 07, 2012 7:35 AM To: U2 Users List Subject: [U2] Multiple UniData Indexes in same select Good morning, I should know this, but as the gray gets thicker, some of the old knowledge seeps away. If you have indexes on multiple attributes on a file in UniData AND you include both of those indexed attributes in the same Select statement, how does UniData know which index to use? Does it use both? Neither? Thanks in advance, Doug ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SQL Views
Wol: The idea to do views is a big help and much appreciated. In UniVerse... to do views appears to require a schema. Thus, I need to get up-to-speed on SQL Schemas in UniVerse. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Wednesday, November 07, 2012 1:54 PM Subject: Re: [U2] [OT] Sql Query On 07/11/12 16:31, Bill Brutzman wrote: While the given link is key... a bit of frustration that I have had with SQL is that... often I have data in more than two tables... following the first select list... there could be data in six or more tables. The joins that I have tried seem to max out at like... three tables. In UniBasic... it is easy to traverse tables. Suggestions would be appreciated. --Bill A hint for both you and Barry ... ASSUMEing your back-end database has a half-way decent query optimiser, try creating views that match what you would expect to put in a MV FILE. Then do your selects against those views. The query optimiser should do all the hard work of building up a good query, stripping out redundant accesses, etc etc. But that way, you can make SQL behave a bit like MV until you've got to grips with it. You know my feelings :-) MV makes a far better relational back-end than a relational database, but you do have to design that back-end properly otherwise what comes out is ... Cheers, Wol ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Loading a UNIX-based UNIDATA file system on a Windows system...
Very good. Thank you for the responses. I will try those things out. Robert Norman On 11/6/2012 1:03 PM, Wally Terhune wrote: Fnuxi is UniVerse - not UniData. UDTBIN\convdata will convert the byte order of hashed files. If the source machine is Linux, this will not be necessary. You will need to run it - if the source UNIX is AIX, HPUX, Solaris. Convidx will convert UniData indexes. If you need to run programs: convcode Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Tuesday, November 06, 2012 1:49 PM To: U2 Users List Subject: Re: [U2] Loading a UNIX-based UNIDATA file system on a Windows system... After loading the data on the Windows system you will have to run fnuxi (C:\u2\UV\bin\fnuxi) on each file you wish to access. I would suggest you do this as follows: - locate the directory where the Unidata files are loaded - run fnuxi on the VOC and D_VOC - drop into Unidata and create a listing of the files in the directory (LIST ONLY VOC WITH F1 = F) output to the hold file and copy the list from the hold file to the directory containing the Unidata files - using the editor of your choice prefix each line in the file tie c:\u2\UV\bin\fnuxi.exe and save it as a windows .bat file - run the batch file to convert all the files. - edit the batch file and change all the filenames to D_filename - run it again Robert wrote: I have a client that has a client's tape containing the file system from a UNIDATA system running under some form of Unix. They want to load it up on a Windows PC and using the Windows version of UNIDATA, retrieve file data. I have seen in the past that sometimes a file from one OS (like Unix) was not able to be read under a different OS (Windows). This happened once to me with a PKZIP file. There was something slightly different about the file headers or something like that. So the question is, what is the best way to load the data? Is there a conversion utility that you run AFTER you load the data to convert any file header differences? Or are the file headers compatible? Or...? Robert Norman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] SQL Query
On 07/11/12 16:31, Bill Brutzman wrote: The joins that I have tried seem to max out at like... three tables. in UV have a look at SET.SQL to tweak the workspace memory used for the current session. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multiple UniData Indexes in same select
In Universe I have used the EXPLAIN keyword in the past to understand how the query will be processed. You just add the keyword EXPLAIN to the end of your query statement. The documentation says it for SQL statements but it seems to work on Universe SELECT statements. Showing How a Query Will Be Processed (EXPLAIN) Use EXPLAIN in a SELECT statement to display information about how the statement will be processed, so that you can decide if you want to rewrite the query more efficiently. You can also use EXPLAIN in an INSERT, UPDATE, or DELETE statement, whenever it contains a WHERE clause or a query specification. EXPLAIN lists the tables included in the query or WHERE clause, explains how data will be retrieved (that is, by table, select list, index lookup, or explicit ID), and explains how any joins will be processed. After each message, press Q to quit, or press any other key to continue the query. If a client program uses EXPLAIN in a SELECT statement, the statement is not processed. Instead, an SQLSTATE value of IA000 is returned, along with the EXPLAIN message as the message text. Regards Adrian Halid -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Thursday, 8 November 2012 3:00 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Multiple UniData Indexes in same select On 07/11/12 17:18, Wjhonson wrote: What about Universe? imho, it just doesn't make logical sense in BASIC! just do SELECTINDEX, READLIST, SELECTINDEX, READLIST and then manipulate it yourself. Okay, that's more hassle, but IME the results of reading the index file always give me a sorted list, so doing a union or intersect of two sorted lists isn't that tricky. Cheers, Wol -Original Message- From: Wally Terhune wterh...@rocketsoftware.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Nov 7, 2012 9:05 am Subject: Re: [U2] Multiple UniData Indexes in same select No on UniBasic SELECTINDEX statement. Not sure I'd call a change made at UniData 5.2 in June of 2000 as 'news'. :-) Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Wednesday, November 07, 2012 9:54 AM To: U2 Users List Subject: Re: [U2] Multiple UniData Indexes in same select Excellent news. However, is there a way to utilize two indexes with the SELECTINDEX command in Unibasic? Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Wednesday, November 07, 2012 11:47 AM To: U2 Users List Subject: Re: [U2] Multiple UniData Indexes in same select From the Using UniData manual: Alternate Indexes in UniQuery Statement Prior to UniData 5.2, only one index was used in the selection criteria of a UniQuery statement, even if the selection criteria contained more than one indexed attribute. UniQuery now uses all available indexes when processing a statement containing selection criteria.Note: You cannot use an alternate index with a LIKE clause when the comparative attribute is numeric. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Farmer Sent: Wednesday, November 07, 2012 7:35 AM To: U2 Users List Subject: [U2] Multiple UniData Indexes in same select Good morning, I should know this, but as the gray gets thicker, some of the old knowledge seeps away. If you have indexes on multiple attributes on a file in UniData AND you include both of those indexed attributes in the same Select statement, how does UniData know which index to use? Does it use both? Neither? Thanks in advance, Doug ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata 6.1.15 Oddity
We have a customer who has a system that was rebooted a couple days ago. Since then, and only in one certain subroutine, when doing an MCU conversion on a multivalued list, the ASCII 253 value marks are replaced with ASCII 221. Understanding that the difference between an lower and upper case A is 32 in the ASCII table (97 - 65), it seems like Unidata is treating the delimiters like normal characters. But again, this only happens in certain programs. If I extract the lines of code that exhibit this behavior into its own program, the problem does not occur. Any ideas what might be causing this and only in one subroutine? Both my test program and the real program with the problem are $BASICTYPE U. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1.15 Oddity
Kevin: Many releases ago on Unidata we noticed that this particular code was not working. The code would work when we had it in another program. The program would fail even when we added CRT statements around the code. So, we moved the offending code to another area of the program and the problem was no longer. It seems there was something in the area of code that was causing the compiler to work correctly. Of course we have not seen any of the problem on the current release of 7.3. Regards, Doug www.u2logic.com On Wed, Nov 7, 2012 at 5:25 PM, Kevin King ke...@precisonline.com wrote: We have a customer who has a system that was rebooted a couple days ago. Since then, and only in one certain subroutine, when doing an MCU conversion on a multivalued list, the ASCII 253 value marks are replaced with ASCII 221. Understanding that the difference between an lower and upper case A is 32 in the ASCII table (97 - 65), it seems like Unidata is treating the delimiters like normal characters. But again, this only happens in certain programs. If I extract the lines of code that exhibit this behavior into its own program, the problem does not occur. Any ideas what might be causing this and only in one subroutine? Both my test program and the real program with the problem are $BASICTYPE U. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multiple UniData Indexes in same select
Once again (I'm a fan of these) the answer is to create a file of composite keys (FldA * FldB etc) and index that... The bummer is that the xref file will always be out unless one adds a 'trigger' to each 'to be indexed' file Itypes can then be created to XLATE the data from the specific files. The index makes + the select quick, + the returned keys are in sequential FldA main sort, FldB nested, + there is a smaller subset of data to do direct reads to the two (or more files). It's nicer if you create the files with a set prefix to define that all they are is xref files. The SELECTINDEX can be used. !!! Don't create an IType of the composite and index that... seriously bad idea (or an excellent way to get a continually random, lossy select) On 8 November 2012 02:54, Dave Laansma dlaan...@hubbardsupply.com wrote: Excellent news. However, is there a way to utilize two indexes with the SELECTINDEX command in Unibasic? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1.15 Oddity
Kevin: You might try to re-compile the code. Ever since I went to UniData on Windows I have an occasional burp in programs. Last week one of our clients reported an index not working properly. A thorough review showed no problems. We had their IT people in and still were having problems. The index showed: ...removing indexes for ARTMASTER,ARTMASTER file... errno=13: Permission denied Delete index file 'ARTMASTER\X_ARTMASTER' failed There was absolutely no permissions problem! The solution was to simply recompile all code and the problem went away. I've had this /*very*/ occasional problem on every UD installation I've had since I moved to UD six years ago. Today, the first thing I do with clients who complain of weird things happening is to recompile the code. Sometimes two lines of code say WRITE... then WRITE... and the second write doesn't occur. Again, this is a very rare occurrence but it does happen. HTH, Bill - Original Message - *From:* ke...@precisonline.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 11/7/2012 4:25 PM *Subject:* [U2] Unidata 6.1.15 Oddity We have a customer who has a system that was rebooted a couple days ago. Since then, and only in one certain subroutine, when doing an MCU conversion on a multivalued list, the ASCII 253 value marks are replaced with ASCII 221. Understanding that the difference between an lower and upper case A is 32 in the ASCII table (97 - 65), it seems like Unidata is treating the delimiters like normal characters. But again, this only happens in certain programs. If I extract the lines of code that exhibit this behavior into its own program, the problem does not occur. Any ideas what might be causing this and only in one subroutine? Both my test program and the real program with the problem are $BASICTYPE U. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1.15 Oddity
From memory... The difference may depend on the UNIX LANG setting for different users. LANG=C may be required. You don't say what platform you are on. We may also have fixed something since 6.1.15. My memory isn't what it used to be. You can certainly scan the readmes for MCU and/or UPCASE. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, November 07, 2012 5:26 PM To: U2 Users List Subject: [U2] Unidata 6.1.15 Oddity We have a customer who has a system that was rebooted a couple days ago. Since then, and only in one certain subroutine, when doing an MCU conversion on a multivalued list, the ASCII 253 value marks are replaced with ASCII 221. Understanding that the difference between an lower and upper case A is 32 in the ASCII table (97 - 65), it seems like Unidata is treating the delimiters like normal characters. But again, this only happens in certain programs. If I extract the lines of code that exhibit this behavior into its own program, the problem does not occur. Any ideas what might be causing this and only in one subroutine? Both my test program and the real program with the problem are $BASICTYPE U. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
