Re: [U2] How do I get the U2 Metadata Manager to work
I can do all that with SSIS, VB.net and/or c# classes too without having to install another server, buy extra software and learn a new language. On 09/06/2013 01:09, Bill Brutzman wrote: Mecki: While the old-fashioned approach is decent, it appears that there would be the fallout of having to manually mop-up the dead rows. To me... a more robust way is to... have the CF middleware read the Seiki data... CF clean the old SQL rows... CF would call the new Rocket REST tool to call a UniBasic sub to write the data to the UD Avante table. The CF handler might be less than a dozen lines of HTML-like tags... or CF script. Upon doing this... there would likely be other data translation apps that would come to mind... like integrating Avante with other ODBC... United Parcel Service, employee time clock, shop floor equipment etc. Likewise, I expect that ASP.net could do most all of the CF part. Of course, the main idea here is that a server would be running agents (services). The latest CF 10 has TomCat built-in. I got turned on to The Zen of REST by the author Scott Davis at a Philadelphia Emerging Technologies conference. Slick Willy -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Saturday, June 8, 2013 3:52 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work Bill, What I try to achieve is converting production data collected by Seiki software into labour bookings on our Avante ERP system. Currently operators use Seiki on the machine and also book the jobs on a separate screen to update ERP. So I have one application writing to a SQL Server table and I want to run a phantom on UD that picks up changes on that table and updates several UD files using existing business logic when it finds any. That way the operator doesn't have to enter labour bookings and make mistakes any more. I also want to remove the rows from the SQL Server table once they are marked as completed operations and update SQL Server with changes of the production schedule to produce loading lists on the machines. How can a browser or Coldfusion help me with that? If I really wanted a browser based front end I would most likely use Designbais or SBXA since I don't see the point and don't have the time trying to learn yet another new language (or a whole bunch of them) just for that. I think I'll just go the old fashioned way and run a SSIS package on SQL server that checks for changes on the table and writes these to a Samba share on the UD server as a Tab delimited text file and also updates the tables Seiki uses for loading lists. Then my phantom can pick up those changed rows every minute or so and update my files. I just wanted a more elegant solution and and see if and how the UD tools work. Mecki On 07/06/2013 23:02, Bill Brutzman wrote: Mecki: While it may be counter-intuitive that ColdFusion is very hot... The compelling gravity in the entire web UniVerse is the idea is the idea browser front end. As CF was originally tag-based... if a programmer knows any HTML... that same programmer already knows much CF. Where CF shines is middleware to connect to databases... and rapid application development. It is worth it to go to adobe.com and check out CF. A related impossibility is that the CF community is even more gung-ho that the U2 community. Who knew? --Bill ___ 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] How do I get the U2 Metadata Manager to work
Mecki I already told you how to pick up changes to an SQl Table without using BCI We do it every night. And we don't need SAMBA either. We use bcp (not the P at the end not I) bcp has been around since the VW bug Try it, it works. It can pick up changes and write them to a tab delimited file -Original Message- From: Mecki Foerthmann mec...@gmx.net To: u2-users u2-users@listserver.u2ug.org Sent: Sat, Jun 8, 2013 12:52 am Subject: Re: [U2] How do I get the U2 Metadata Manager to work Bill, What I try to achieve is converting production data collected by Seiki software into labour bookings on our Avante ERP system. Currently operators use Seiki on the machine and also book the jobs on a separate screen to update ERP. So I have one application writing to a SQL Server table and I want to run a phantom on UD that picks up changes on that table and updates several UD files using existing business logic when it finds any. That way the operator doesn't have to enter labour bookings and make mistakes any more. I also want to remove the rows from the SQL Server table once they are marked as completed operations and update SQL Server with changes of the production schedule to produce loading lists on the machines. How can a browser or Coldfusion help me with that? If I really wanted a browser based front end I would most likely use Designbais or SBXA since I don't see the point and don't have the time trying to learn yet another new language (or a whole bunch of them) just for that. I think I'll just go the old fashioned way and run a SSIS package on SQL server that checks for changes on the table and writes these to a Samba share on the UD server as a Tab delimited text file and also updates the tables Seiki uses for loading lists. Then my phantom can pick up those changed rows every minute or so and update my files. I just wanted a more elegant solution and and see if and how the UD tools work. Mecki On 07/06/2013 23:02, Bill Brutzman wrote: Mecki: While it may be counter-intuitive that ColdFusion is very hot... The compelling gravity in the entire web UniVerse is the idea is the idea browser front end. As CF was originally tag-based... if a programmer knows any HTML... that same programmer already knows much CF. Where CF shines is middleware to connect to databases... and rapid application development. It is worth it to go to adobe.com and check out CF. A related impossibility is that the CF community is even more gung-ho that the U2 community. Who knew? --Bill ___ 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] How do I get the U2 Metadata Manager to work
Sorry - having tla troubles - I mean bci - I use it on 64bit redhat to read/write to a mysql db, using a standard mysql lib And I mean eda - I am not an expert - but I did think you can use it to read and write to/from an external source. I ti snot just for replication, tho that is one use of it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 07 June 2013 20:38 To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work This is really all new for me, so you have to excuse my ignorance. What is EDT? I know EDA but that is for writing data to SQL Server but not for reading from it. At least that's what it says in the documentation. Doesn't that use replication? I also have BDT working on 64 bit Linux but how does that help me? And if you actually have BCI working on 64 bit Linux, which ODBC driver did you use? Are there any 'gotchas' when installing it? In that regard I am totally at the mercy of our sys admin since he is the only one who installs anything on Linux. He installed a 64 bit ODBC driver and from a Linux shell he can connect to the SQL Server box I want to connect to with no problem. I followed the documentation in setting up BCI but when I try to use CONNECT in a Basic program I always get a memory error. On 07/06/2013 15:57, Symeon Breen wrote: Hi - I have udt 7.1 on redhat 64bit and we use BDT ok ??? Also EDT is for unidata to get access to external data sources like sql server so that would also solve the problem -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 07 June 2013 14:54 To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work I know, tried it and it doesn't work on our setup because BCI only seems to work if the OS on the UD server is 32 bit. We were told it didn't matter so they built a Redhat Linux 64 bit virtual server and put UD in that. Now if I try to connect trough BCI I only get memory errors. AFAIK EDA is only for connecting from SQL Server to U2 so no good for what I want to do. On 07/06/2013 09:39, Symeon Breen wrote: And I am still looking for a way to read data from a relational database in a Basic program. This has been around for years Mecki - look up the bci functions like SQLPrepare etc. Or there is the new EDA function as well. Rgds Symeon. ___ 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] How do I get the U2 Metadata Manager to work
Mecki: While the old-fashioned approach is decent, it appears that there would be the fallout of having to manually mop-up the dead rows. To me... a more robust way is to... have the CF middleware read the Seiki data... CF clean the old SQL rows... CF would call the new Rocket REST tool to call a UniBasic sub to write the data to the UD Avante table. The CF handler might be less than a dozen lines of HTML-like tags... or CF script. Upon doing this... there would likely be other data translation apps that would come to mind... like integrating Avante with other ODBC... United Parcel Service, employee time clock, shop floor equipment etc. Likewise, I expect that ASP.net could do most all of the CF part. Of course, the main idea here is that a server would be running agents (services). The latest CF 10 has TomCat built-in. I got turned on to The Zen of REST by the author Scott Davis at a Philadelphia Emerging Technologies conference. Slick Willy -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Saturday, June 8, 2013 3:52 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work Bill, What I try to achieve is converting production data collected by Seiki software into labour bookings on our Avante ERP system. Currently operators use Seiki on the machine and also book the jobs on a separate screen to update ERP. So I have one application writing to a SQL Server table and I want to run a phantom on UD that picks up changes on that table and updates several UD files using existing business logic when it finds any. That way the operator doesn't have to enter labour bookings and make mistakes any more. I also want to remove the rows from the SQL Server table once they are marked as completed operations and update SQL Server with changes of the production schedule to produce loading lists on the machines. How can a browser or Coldfusion help me with that? If I really wanted a browser based front end I would most likely use Designbais or SBXA since I don't see the point and don't have the time trying to learn yet another new language (or a whole bunch of them) just for that. I think I'll just go the old fashioned way and run a SSIS package on SQL server that checks for changes on the table and writes these to a Samba share on the UD server as a Tab delimited text file and also updates the tables Seiki uses for loading lists. Then my phantom can pick up those changed rows every minute or so and update my files. I just wanted a more elegant solution and and see if and how the UD tools work. Mecki On 07/06/2013 23:02, Bill Brutzman wrote: Mecki: While it may be counter-intuitive that ColdFusion is very hot... The compelling gravity in the entire web UniVerse is the idea is the idea browser front end. As CF was originally tag-based... if a programmer knows any HTML... that same programmer already knows much CF. Where CF shines is middleware to connect to databases... and rapid application development. It is worth it to go to adobe.com and check out CF. A related impossibility is that the CF community is even more gung-ho that the U2 community. Who knew? --Bill ___ 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] How do I get the U2 Metadata Manager to work
And I am still looking for a way to read data from a relational database in a Basic program. This has been around for years Mecki - look up the bci functions like SQLPrepare etc. Or there is the new EDA function as well. Rgds Symeon. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How do I get the U2 Metadata Manager to work
I know, tried it and it doesn't work on our setup because BCI only seems to work if the OS on the UD server is 32 bit. We were told it didn't matter so they built a Redhat Linux 64 bit virtual server and put UD in that. Now if I try to connect trough BCI I only get memory errors. AFAIK EDA is only for connecting from SQL Server to U2 so no good for what I want to do. On 07/06/2013 09:39, Symeon Breen wrote: And I am still looking for a way to read data from a relational database in a Basic program. This has been around for years Mecki - look up the bci functions like SQLPrepare etc. Or there is the new EDA function as well. Rgds Symeon. ___ 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] How do I get the U2 Metadata Manager to work
Mecki we use BCP You just execute it as a TCL command to the underlying OS command line (DOS or Unix) from your BASIC routine, and tell it to write the output to a file and error log, sleep a few seconds then read the resulting files. You might want to stomp the files before you start so you're not reading the previous output. And if you're doing this multi-user on demand you can put the user Login as part of the file name. -Original Message- From: Mecki Foerthmann mec...@gmx.net To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Jun 7, 2013 6:54 am Subject: Re: [U2] How do I get the U2 Metadata Manager to work I know, tried it and it doesn't work on our setup because BCI only seems to work if the OS on the UD server is 32 bit. We were told it didn't matter so they built a Redhat Linux 64 bit virtual server and put UD in that. Now if I try to connect trough BCI I only get memory errors. AFAIK EDA is only for connecting from SQL Server to U2 so no good for what I want to do. On 07/06/2013 09:39, Symeon Breen wrote: And I am still looking for a way to read data from a relational database in a Basic program. This has been around for years Mecki - look up the bci functions like SQLPrepare etc. Or there is the new EDA function as well. Rgds Symeon. ___ 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] How do I get the U2 Metadata Manager to work
Mecki: Consider using Adobe's ColdFusion as middleware... possibly with the new U2 REST tool. View = HTML Middle = CF, U2 ReST DataBase = U2, SQL A cool thing about U2 Rest is that... it is fairly easy to leverage existing UniBasic code... especially Subs. Rocket has an outstanding three-part video on how to do AJAX and ReST. ColdFusion has many desirable features. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Friday, June 7, 2013 9:54 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work I know, tried it and it doesn't work on our setup because BCI only seems to work if the OS on the UD server is 32 bit. We were told it didn't matter so they built a Redhat Linux 64 bit virtual server and put UD in that. Now if I try to connect trough BCI I only get memory errors. AFAIK EDA is only for connecting from SQL Server to U2 so no good for what I want to do. On 07/06/2013 09:39, Symeon Breen wrote: And I am still looking for a way to read data from a relational database in a Basic program. This has been around for years Mecki - look up the bci functions like SQLPrepare etc. Or there is the new EDA function as well. Rgds Symeon. ___ 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] How do I get the U2 Metadata Manager to work
Hi - I have udt 7.1 on redhat 64bit and we use BDT ok ??? Also EDT is for unidata to get access to external data sources like sql server so that would also solve the problem -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 07 June 2013 14:54 To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work I know, tried it and it doesn't work on our setup because BCI only seems to work if the OS on the UD server is 32 bit. We were told it didn't matter so they built a Redhat Linux 64 bit virtual server and put UD in that. Now if I try to connect trough BCI I only get memory errors. AFAIK EDA is only for connecting from SQL Server to U2 so no good for what I want to do. On 07/06/2013 09:39, Symeon Breen wrote: And I am still looking for a way to read data from a relational database in a Basic program. This has been around for years Mecki - look up the bci functions like SQLPrepare etc. Or there is the new EDA function as well. Rgds Symeon. ___ 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] How do I get the U2 Metadata Manager to work
Hi Dan, With respect to BDT version, I installed it a month or two ago, and recently applied an update (mine shows version 3.0.6) but note that in the text description it still says March 2012 as the date. Can we assume that 3.0.6 is the current version or did we miss something? Also, when using libraries like UDO for example, the syntax highlighting flags unassigned variable warnings; is there a way to teach it to avoid this? -Aaron *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Thu, Jun 6, 2013 at 3:35 PM, Daniel McGrath dmcgr...@rocketsoftware.comwrote: Hi Mecki, It sounds like you are running a old copy of BDT. Unassigned variable warnings from CALL statements was fixed sometime last year. Follow the instructions here (http://updates.rocketsoftware.com/u2/) to make sure you have the latest versions. I can't recall which version, but if you are on too old of a release, that update site won't work for you, so you would have to download the full version again before you can use it. The latest full package is MAR2013. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, June 06, 2013 1:22 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work I'll keep that refresh option in mind. Still a hassle and I would prefer if they would just get rid of that 'feature'. I also noticed that unassigned variable error that pops up for all functions including CALL that return a new variable. Some people may regard assigning a value before you use a function as good coding standard, I don't see the point, though. I haven't tried this in anger, but I recall that BDT treats all files as data files and you can edit data as well. Maybe this is a feature they could add to keep Dict files and hashed files separate so you don't have to look for the BP within 1000 data files every time. I have been using an external editor (mv developer) for several years now. I always save the program to disk, open it with ED, add a blank line somewhere and file it with FIBC. That takes care of PRC. Locking works when you open a program externally, so the only chance that someone could snatch the program ab incorporate it into another project is in that short period between saving in the external editor and opening it with ED on the UD server for the first time. Since I am the only UD programmer in the company it is virtually impossible that will ever happen. Well, and as long as you have OS.ED you can bypass PRC anyway. OK, if you NEVER EVER fix data with ED then you could probably remove it, but who would voluntarily block the only fire escape? We have a really old version of PRC (3.9) and I can't make a business case to invest in new software. There are other tools like mv.SSIS that I'd rather get first. Especially since tools like Rocket's Metadata Manager don't seem to work or I am too stupid to install them properly. I managed to get at least VSG to work on one SQL Server 2008 box, but that is a really primitive tool and I hate it. And I am still looking for a way to read data from a relational database in a Basic program. On 06/06/2013 18:30, Tom Whitmore wrote: Hi Mecki, One think that I always do with BDT is right-click on the program, select refresh, then open the program. That seems to be the only way to make sure I have the current version. Currently, BDT is sort of working with PRC but it isn't honoring file ownership so I'm unable to let the programmers use BDT. You do need to get some programs from Susan for things to work as I have it now. I'm told the latest version of PRC supports BDT. We are currently testing the new version of PRC but I haven't had an opportunity to try BDT on this version.. As far as false errors, the latest version of BDT is greatly improved. However, I have noticed couple of false errors: 1) if the numeric subroutine label does not have a : BDT doesn't recognize the label (like 99*). 2) LOCATE(J,ORIG.PH,2;XXXPOS) THEN FOUND=1 ELSE FOUND=0 , BDT will report that XXXPOS was never assigned a value. There are other instances of this type of problem. One thing I wish I could do is edit records in hashed files, but I don't see how to accomplish this. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, June 06, 2013 12:06 PM To: U2 Users List Subject: [U2] How do I get the U2 Metadata Manager to work Ever since we finally upgraded UniData at work I have been trying out the new tools and don't seem to have much fun with them. The best one is XAdmin and I use it a lot these days. IMHO the interface is a bit
Re: [U2] How do I get the U2 Metadata Manager to work
Aaron: BDT uses it own lexical analysis tool instead of the real compiler. So, you have to wait until Rocket updates BDT. Other than a version change which you have, there have been no updates in 8 months. [ad] Or try XLr8Editor for free for a couple of weeks. XLr8 Tools get updated every 3 or 4 weeks.[/ad] Regards, Doug www.u2logic.com/downloads.html Eclipse tools for U2 programmers On Fri, Jun 7, 2013 at 9:29 AM, Aaron Titus ati...@fwdco.com wrote: Hi Dan, With respect to BDT version, I installed it a month or two ago, and recently applied an update (mine shows version 3.0.6) but note that in the text description it still says March 2012 as the date. Can we assume that 3.0.6 is the current version or did we miss something? Also, when using libraries like UDO for example, the syntax highlighting flags unassigned variable warnings; is there a way to teach it to avoid this? -Aaron *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How do I get the U2 Metadata Manager to work
This is really all new for me, so you have to excuse my ignorance. What is EDT? I know EDA but that is for writing data to SQL Server but not for reading from it. At least that's what it says in the documentation. Doesn't that use replication? I also have BDT working on 64 bit Linux but how does that help me? And if you actually have BCI working on 64 bit Linux, which ODBC driver did you use? Are there any 'gotchas' when installing it? In that regard I am totally at the mercy of our sys admin since he is the only one who installs anything on Linux. He installed a 64 bit ODBC driver and from a Linux shell he can connect to the SQL Server box I want to connect to with no problem. I followed the documentation in setting up BCI but when I try to use CONNECT in a Basic program I always get a memory error. On 07/06/2013 15:57, Symeon Breen wrote: Hi - I have udt 7.1 on redhat 64bit and we use BDT ok ??? Also EDT is for unidata to get access to external data sources like sql server so that would also solve the problem -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 07 June 2013 14:54 To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work I know, tried it and it doesn't work on our setup because BCI only seems to work if the OS on the UD server is 32 bit. We were told it didn't matter so they built a Redhat Linux 64 bit virtual server and put UD in that. Now if I try to connect trough BCI I only get memory errors. AFAIK EDA is only for connecting from SQL Server to U2 so no good for what I want to do. On 07/06/2013 09:39, Symeon Breen wrote: And I am still looking for a way to read data from a relational database in a Basic program. This has been around for years Mecki - look up the bci functions like SQLPrepare etc. Or there is the new EDA function as well. Rgds Symeon. ___ 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] How do I get the U2 Metadata Manager to work
Do you want any solution or only one which requires use of BCI ? Why not get it working and then have more leisure to figure out why the BCI way won't work -Original Message- From: Mecki Foerthmann mec...@gmx.net To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Jun 7, 2013 12:38 pm Subject: Re: [U2] How do I get the U2 Metadata Manager to work This is really all new for me, so you have to excuse my ignorance. What is EDT? I know EDA but that is for writing data to SQL Server but not for reading from it. At least that's what it says in the documentation. Doesn't that use replication? I also have BDT working on 64 bit Linux but how does that help me? And if you actually have BCI working on 64 bit Linux, which ODBC driver did you use? Are there any 'gotchas' when installing it? In that regard I am totally at the mercy of our sys admin since he is the only one who installs anything on Linux. He installed a 64 bit ODBC driver and from a Linux shell he can connect to the SQL Server box I want to connect to with no problem. I followed the documentation in setting up BCI but when I try to use CONNECT in a Basic program I always get a memory error. On 07/06/2013 15:57, Symeon Breen wrote: Hi - I have udt 7.1 on redhat 64bit and we use BDT ok ??? Also EDT is for unidata to get access to external data sources like sql server so that would also solve the problem -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 07 June 2013 14:54 To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work I know, tried it and it doesn't work on our setup because BCI only seems to work if the OS on the UD server is 32 bit. We were told it didn't matter so they built a Redhat Linux 64 bit virtual server and put UD in that. Now if I try to connect trough BCI I only get memory errors. AFAIK EDA is only for connecting from SQL Server to U2 so no good for what I want to do. On 07/06/2013 09:39, Symeon Breen wrote: And I am still looking for a way to read data from a relational database in a Basic program. This has been around for years Mecki - look up the bci functions like SQLPrepare etc. Or there is the new EDA function as well. Rgds Symeon. ___ 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] How do I get the U2 Metadata Manager to work
I don't think that is an option for me. That sounds far too complicated for an old dinosaur like me. I am no nuclear physicist but even I know that cold fusion is an urban myth and doesn't work! You need temperatures and pressure like in the centre of the sun to get fusion going. And that is VERY hot! The Ajax I know has been dead for millennia and where I come from rest is for after work. :-) On 07/06/2013 15:51, Bill Brutzman wrote: Mecki: Consider using Adobe's ColdFusion as middleware... possibly with the new U2 REST tool. View = HTML Middle = CF, U2 ReST DataBase = U2, SQL A cool thing about U2 Rest is that... it is fairly easy to leverage existing UniBasic code... especially Subs. Rocket has an outstanding three-part video on how to do AJAX and ReST. ColdFusion has many desirable features. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Friday, June 7, 2013 9:54 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work I know, tried it and it doesn't work on our setup because BCI only seems to work if the OS on the UD server is 32 bit. We were told it didn't matter so they built a Redhat Linux 64 bit virtual server and put UD in that. Now if I try to connect trough BCI I only get memory errors. AFAIK EDA is only for connecting from SQL Server to U2 so no good for what I want to do. On 07/06/2013 09:39, Symeon Breen wrote: And I am still looking for a way to read data from a relational database in a Basic program. This has been around for years Mecki - look up the bci functions like SQLPrepare etc. Or there is the new EDA function as well. Rgds Symeon. ___ 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] How do I get the U2 Metadata Manager to work
This is an issue because UV is currently a 32bit app which will run on a 64 bit platform. The 64bit ODBC driver will work fine in isolation but will not link to Universe under the CONNECT manner. You could create a verb ISQL which would link to isql, provided by the Microsoft ODBC driver from memory, but this is not ideal. And if you actually have BCI working on 64 bit Linux, which ODBC driver did you use? Are there any 'gotchas' when installing it? In that regard I am totally at the mercy of our sys admin since he is the only one who installs anything on Linux. He installed a 64 bit ODBC driver and from a Linux shell he can connect to the SQL Server box I want to connect to with no problem. I followed the documentation in setting up BCI but when I try to use CONNECT in a Basic program I always get a memory error. [Phil Walker] --- On 07/06/2013 15:57, Symeon Breen wrote: Hi - I have udt 7.1 on redhat 64bit and we use BDT ok ??? Also EDT is for unidata to get access to external data sources like sql server so that would also solve the problem -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 07 June 2013 14:54 To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work I know, tried it and it doesn't work on our setup because BCI only seems to work if the OS on the UD server is 32 bit. We were told it didn't matter so they built a Redhat Linux 64 bit virtual server and put UD in that. Now if I try to connect trough BCI I only get memory errors. AFAIK EDA is only for connecting from SQL Server to U2 so no good for what I want to do. On 07/06/2013 09:39, Symeon Breen wrote: And I am still looking for a way to read data from a relational database in a Basic program. This has been around for years Mecki - look up the bci functions like SQLPrepare etc. Or there is the new EDA function as well. Rgds Symeon. ___ 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] How do I get the U2 Metadata Manager to work
Mecki: While it may be counter-intuitive that ColdFusion is very hot... The compelling gravity in the entire web UniVerse is the idea is the idea browser front end. As CF was originally tag-based... if a programmer knows any HTML... that same programmer already knows much CF. Where CF shines is middleware to connect to databases... and rapid application development. It is worth it to go to adobe.com and check out CF. A related impossibility is that the CF community is even more gung-ho that the U2 community. Who knew? --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How do I get the U2 Metadata Manager to work
On 07/06/13 20:49, Mecki Foerthmann wrote: I don't think that is an option for me. That sounds far too complicated for an old dinosaur like me. I am no nuclear physicist but even I know that cold fusion is an urban myth and doesn't work! You need temperatures and pressure like in the centre of the sun to get fusion going. And that is VERY hot! Actually, if it wasn't for cold fusion, then the sun wouldn't shine! As I learnt in one of my uni courses, I can't remember which step in the hydrogen cycle it is, but by all the standard calculations it's impossible. But, by dint of quantum tunneling (aka cold fusion) the impossible happens often enough to power the sun :-) Which is one of the reasons I'm a cold-fusion sceptic, but not an outright disbeliever. I studied the Fleischman-Pons debacle as another one of my uni courses, and I firmly believe that the bad publicity they generated basically destroyed a good avenue of research. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] How do I get the U2 Metadata Manager to work
Ever since we finally upgraded UniData at work I have been trying out the new tools and don't seem to have much fun with them. The best one is XAdmin and I use it a lot these days. IMHO the interface is a bit crude and clunky, but I guess that's Eclipse and you can't do much about that. The BDT is not of much use since I need to make tweaks of the program using AE (even if it only to make PRC work) but when I then open it again in BDT it reverts to the old version. Looks like it keeps that in memory on my PC so any changes made on the server are lost. Looks nice and shiny but the syntax check isn't really working either. 99% of the errors shown turn out to be no errors at all. The latest one I tried is the Metadata Manager. It installed fine and I can connect to the server and the database no problem. I can see the files and the dictionaries and can even change data on the server but that's it. The metadata tools I want to use are all greyed out, so what am I doing wrong? As stated in the Help I ran MIGRATE.SQL on the server but all I achieved is that I now cannot change anything using the old Avante Batch Schema Generation process. It goes through the motions but just hangs up at the end now. So at the end I am not overly impressed. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How do I get the U2 Metadata Manager to work
Hi Mecki, have you reported this to support? Glad to hear you are using XAdmin a lot and we would be interested to get any reproducible cases of where BDT break (false positives on errors especially). There is documentation for U2 Metadata Manager built in to the tool, but if you cannot work out intuitively how to get things to work, that is also an issue we want to solve. Just send us the steps you followed, along with what you were trying to acheieve and what either didn't work or wasn't available. We are working on a UX project internally, so the more information and stories about where we fall down, the better. Cheers, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, June 06, 2013 10:06 AM To: U2 Users List Subject: [U2] How do I get the U2 Metadata Manager to work Ever since we finally upgraded UniData at work I have been trying out the new tools and don't seem to have much fun with them. The best one is XAdmin and I use it a lot these days. IMHO the interface is a bit crude and clunky, but I guess that's Eclipse and you can't do much about that. The BDT is not of much use since I need to make tweaks of the program using AE (even if it only to make PRC work) but when I then open it again in BDT it reverts to the old version. Looks like it keeps that in memory on my PC so any changes made on the server are lost. Looks nice and shiny but the syntax check isn't really working either. 99% of the errors shown turn out to be no errors at all. The latest one I tried is the Metadata Manager. It installed fine and I can connect to the server and the database no problem. I can see the files and the dictionaries and can even change data on the server but that's it. The metadata tools I want to use are all greyed out, so what am I doing wrong? As stated in the Help I ran MIGRATE.SQL on the server but all I achieved is that I now cannot change anything using the old Avante Batch Schema Generation process. It goes through the motions but just hangs up at the end now. So at the end I am not overly impressed. ___ 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] How do I get the U2 Metadata Manager to work
Hi Mecki, One think that I always do with BDT is right-click on the program, select refresh, then open the program. That seems to be the only way to make sure I have the current version. Currently, BDT is sort of working with PRC but it isn't honoring file ownership so I'm unable to let the programmers use BDT. You do need to get some programs from Susan for things to work as I have it now. I'm told the latest version of PRC supports BDT. We are currently testing the new version of PRC but I haven't had an opportunity to try BDT on this version.. As far as false errors, the latest version of BDT is greatly improved. However, I have noticed couple of false errors: 1) if the numeric subroutine label does not have a : BDT doesn't recognize the label (like 99*). 2) LOCATE(J,ORIG.PH,2;XXXPOS) THEN FOUND=1 ELSE FOUND=0 , BDT will report that XXXPOS was never assigned a value. There are other instances of this type of problem. One thing I wish I could do is edit records in hashed files, but I don't see how to accomplish this. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, June 06, 2013 12:06 PM To: U2 Users List Subject: [U2] How do I get the U2 Metadata Manager to work Ever since we finally upgraded UniData at work I have been trying out the new tools and don't seem to have much fun with them. The best one is XAdmin and I use it a lot these days. IMHO the interface is a bit crude and clunky, but I guess that's Eclipse and you can't do much about that. The BDT is not of much use since I need to make tweaks of the program using AE (even if it only to make PRC work) but when I then open it again in BDT it reverts to the old version. Looks like it keeps that in memory on my PC so any changes made on the server are lost. Looks nice and shiny but the syntax check isn't really working either. 99% of the errors shown turn out to be no errors at all. The latest one I tried is the Metadata Manager. It installed fine and I can connect to the server and the database no problem. I can see the files and the dictionaries and can even change data on the server but that's it. The metadata tools I want to use are all greyed out, so what am I doing wrong? As stated in the Help I ran MIGRATE.SQL on the server but all I achieved is that I now cannot change anything using the old Avante Batch Schema Generation process. It goes through the motions but just hangs up at the end now. So at the end I am not overly impressed. ___ 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] How do I get the U2 Metadata Manager to work
Mecki, Just as an aside to your main point here... BDT can be PRC-enabled. Email me! Susan sjos...@sjplus.com Date: Thu, 06 Jun 2013 17:06:06 +0100 From: Mecki Foerthmann mec...@gmx.net To: U2 Users List u2-users@listserver.u2ug.org Subject: [U2] How do I get the U2 Metadata Manager to work Message-ID: 51b0b36e.1080...@gmx.net Content-Type: text/plain; charset=ISO-8859-1; format=flowed Ever since we finally upgraded UniData at work I have been trying out the new tools and don't seem to have much fun with them. The best one is XAdmin and I use it a lot these days. IMHO the interface is a bit crude and clunky, but I guess that's Eclipse and you can't do much about that. The BDT is not of much use since I need to make tweaks of the program using AE (even if it only to make PRC work) but when I then open it again in BDT it reverts to the old version. Looks like it keeps that in memory on my PC so any changes made on the server are lost. Looks nice and shiny but the syntax check isn't really working either. 99% of the errors shown turn out to be no errors at all. The latest one I tried is the Metadata Manager. It installed fine and I can connect to the server and the database no problem. I can see the files and the dictionaries and can even change data on the server but that's it. The metadata tools I want to use are all greyed out, so what am I doing wrong? As stated in the Help I ran MIGRATE.SQL on the server but all I achieved is that I now cannot change anything using the old Avante Batch Schema Generation process. It goes through the motions but just hangs up at the end now. So at the end I am not overly impressed. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How do I get the U2 Metadata Manager to work
I'll keep that refresh option in mind. Still a hassle and I would prefer if they would just get rid of that 'feature'. I also noticed that unassigned variable error that pops up for all functions including CALL that return a new variable. Some people may regard assigning a value before you use a function as good coding standard, I don't see the point, though. I haven't tried this in anger, but I recall that BDT treats all files as data files and you can edit data as well. Maybe this is a feature they could add to keep Dict files and hashed files separate so you don't have to look for the BP within 1000 data files every time. I have been using an external editor (mv developer) for several years now. I always save the program to disk, open it with ED, add a blank line somewhere and file it with FIBC. That takes care of PRC. Locking works when you open a program externally, so the only chance that someone could snatch the program ab incorporate it into another project is in that short period between saving in the external editor and opening it with ED on the UD server for the first time. Since I am the only UD programmer in the company it is virtually impossible that will ever happen. Well, and as long as you have OS.ED you can bypass PRC anyway. OK, if you NEVER EVER fix data with ED then you could probably remove it, but who would voluntarily block the only fire escape? We have a really old version of PRC (3.9) and I can't make a business case to invest in new software. There are other tools like mv.SSIS that I'd rather get first. Especially since tools like Rocket's Metadata Manager don't seem to work or I am too stupid to install them properly. I managed to get at least VSG to work on one SQL Server 2008 box, but that is a really primitive tool and I hate it. And I am still looking for a way to read data from a relational database in a Basic program. On 06/06/2013 18:30, Tom Whitmore wrote: Hi Mecki, One think that I always do with BDT is right-click on the program, select refresh, then open the program. That seems to be the only way to make sure I have the current version. Currently, BDT is sort of working with PRC but it isn't honoring file ownership so I'm unable to let the programmers use BDT. You do need to get some programs from Susan for things to work as I have it now. I'm told the latest version of PRC supports BDT. We are currently testing the new version of PRC but I haven't had an opportunity to try BDT on this version.. As far as false errors, the latest version of BDT is greatly improved. However, I have noticed couple of false errors: 1) if the numeric subroutine label does not have a : BDT doesn't recognize the label (like 99*). 2) LOCATE(J,ORIG.PH,2;XXXPOS) THEN FOUND=1 ELSE FOUND=0 , BDT will report that XXXPOS was never assigned a value. There are other instances of this type of problem. One thing I wish I could do is edit records in hashed files, but I don't see how to accomplish this. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, June 06, 2013 12:06 PM To: U2 Users List Subject: [U2] How do I get the U2 Metadata Manager to work Ever since we finally upgraded UniData at work I have been trying out the new tools and don't seem to have much fun with them. The best one is XAdmin and I use it a lot these days. IMHO the interface is a bit crude and clunky, but I guess that's Eclipse and you can't do much about that. The BDT is not of much use since I need to make tweaks of the program using AE (even if it only to make PRC work) but when I then open it again in BDT it reverts to the old version. Looks like it keeps that in memory on my PC so any changes made on the server are lost. Looks nice and shiny but the syntax check isn't really working either. 99% of the errors shown turn out to be no errors at all. The latest one I tried is the Metadata Manager. It installed fine and I can connect to the server and the database no problem. I can see the files and the dictionaries and can even change data on the server but that's it. The metadata tools I want to use are all greyed out, so what am I doing wrong? As stated in the Help I ran MIGRATE.SQL on the server but all I achieved is that I now cannot change anything using the old Avante Batch Schema Generation process. It goes through the motions but just hangs up at the end now. So at the end I am not overly impressed. ___ 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
Re: [U2] How do I get the U2 Metadata Manager to work
Hi Mecki, It sounds like you are running a old copy of BDT. Unassigned variable warnings from CALL statements was fixed sometime last year. Follow the instructions here (http://updates.rocketsoftware.com/u2/) to make sure you have the latest versions. I can't recall which version, but if you are on too old of a release, that update site won't work for you, so you would have to download the full version again before you can use it. The latest full package is MAR2013. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, June 06, 2013 1:22 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work I'll keep that refresh option in mind. Still a hassle and I would prefer if they would just get rid of that 'feature'. I also noticed that unassigned variable error that pops up for all functions including CALL that return a new variable. Some people may regard assigning a value before you use a function as good coding standard, I don't see the point, though. I haven't tried this in anger, but I recall that BDT treats all files as data files and you can edit data as well. Maybe this is a feature they could add to keep Dict files and hashed files separate so you don't have to look for the BP within 1000 data files every time. I have been using an external editor (mv developer) for several years now. I always save the program to disk, open it with ED, add a blank line somewhere and file it with FIBC. That takes care of PRC. Locking works when you open a program externally, so the only chance that someone could snatch the program ab incorporate it into another project is in that short period between saving in the external editor and opening it with ED on the UD server for the first time. Since I am the only UD programmer in the company it is virtually impossible that will ever happen. Well, and as long as you have OS.ED you can bypass PRC anyway. OK, if you NEVER EVER fix data with ED then you could probably remove it, but who would voluntarily block the only fire escape? We have a really old version of PRC (3.9) and I can't make a business case to invest in new software. There are other tools like mv.SSIS that I'd rather get first. Especially since tools like Rocket's Metadata Manager don't seem to work or I am too stupid to install them properly. I managed to get at least VSG to work on one SQL Server 2008 box, but that is a really primitive tool and I hate it. And I am still looking for a way to read data from a relational database in a Basic program. On 06/06/2013 18:30, Tom Whitmore wrote: Hi Mecki, One think that I always do with BDT is right-click on the program, select refresh, then open the program. That seems to be the only way to make sure I have the current version. Currently, BDT is sort of working with PRC but it isn't honoring file ownership so I'm unable to let the programmers use BDT. You do need to get some programs from Susan for things to work as I have it now. I'm told the latest version of PRC supports BDT. We are currently testing the new version of PRC but I haven't had an opportunity to try BDT on this version.. As far as false errors, the latest version of BDT is greatly improved. However, I have noticed couple of false errors: 1) if the numeric subroutine label does not have a : BDT doesn't recognize the label (like 99*). 2) LOCATE(J,ORIG.PH,2;XXXPOS) THEN FOUND=1 ELSE FOUND=0 , BDT will report that XXXPOS was never assigned a value. There are other instances of this type of problem. One thing I wish I could do is edit records in hashed files, but I don't see how to accomplish this. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, June 06, 2013 12:06 PM To: U2 Users List Subject: [U2] How do I get the U2 Metadata Manager to work Ever since we finally upgraded UniData at work I have been trying out the new tools and don't seem to have much fun with them. The best one is XAdmin and I use it a lot these days. IMHO the interface is a bit crude and clunky, but I guess that's Eclipse and you can't do much about that. The BDT is not of much use since I need to make tweaks of the program using AE (even if it only to make PRC work) but when I then open it again in BDT it reverts to the old version. Looks like it keeps that in memory on my PC so any changes made on the server are lost. Looks nice and shiny but the syntax check isn't really working either. 99% of the errors shown turn out to be no errors at all. The latest one I tried is the Metadata Manager. It installed fine and I can connect to the server and the database no problem. I can see the files and the dictionaries and can even change
Re: [U2] How do I get the U2 Metadata Manager to work
(Ad) XLr8Editor allows u to edit data, programs with out a refresh option, and any thing else. With our continuous compile option, you only see the real compiler errors. We have a before read option and and after write option to handle PRC. However our editor works with Git, Svn, Team Foundation and others, so U2 can play in sandbox too. Doug U2logic.com/tools.html Sent from my iPhone On Jun 6, 2013, at 1:35 PM, Daniel McGrath dmcgr...@rocketsoftware.com wrote: Hi Mecki, It sounds like you are running a old copy of BDT. Unassigned variable warnings from CALL statements was fixed sometime last year. Follow the instructions here (http://updates.rocketsoftware.com/u2/) to make sure you have the latest versions. I can't recall which version, but if you are on too old of a release, that update site won't work for you, so you would have to download the full version again before you can use it. The latest full package is MAR2013. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, June 06, 2013 1:22 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work I'll keep that refresh option in mind. Still a hassle and I would prefer if they would just get rid of that 'feature'. I also noticed that unassigned variable error that pops up for all functions including CALL that return a new variable. Some people may regard assigning a value before you use a function as good coding standard, I don't see the point, though. I haven't tried this in anger, but I recall that BDT treats all files as data files and you can edit data as well. Maybe this is a feature they could add to keep Dict files and hashed files separate so you don't have to look for the BP within 1000 data files every time. I have been using an external editor (mv developer) for several years now. I always save the program to disk, open it with ED, add a blank line somewhere and file it with FIBC. That takes care of PRC. Locking works when you open a program externally, so the only chance that someone could snatch the program ab incorporate it into another project is in that short period between saving in the external editor and opening it with ED on the UD server for the first time. Since I am the only UD programmer in the company it is virtually impossible that will ever happen. Well, and as long as you have OS.ED you can bypass PRC anyway. OK, if you NEVER EVER fix data with ED then you could probably remove it, but who would voluntarily block the only fire escape? We have a really old version of PRC (3.9) and I can't make a business case to invest in new software. There are other tools like mv.SSIS that I'd rather get first. Especially since tools like Rocket's Metadata Manager don't seem to work or I am too stupid to install them properly. I managed to get at least VSG to work on one SQL Server 2008 box, but that is a really primitive tool and I hate it. And I am still looking for a way to read data from a relational database in a Basic program. On 06/06/2013 18:30, Tom Whitmore wrote: Hi Mecki, One think that I always do with BDT is right-click on the program, select refresh, then open the program. That seems to be the only way to make sure I have the current version. Currently, BDT is sort of working with PRC but it isn't honoring file ownership so I'm unable to let the programmers use BDT. You do need to get some programs from Susan for things to work as I have it now. I'm told the latest version of PRC supports BDT. We are currently testing the new version of PRC but I haven't had an opportunity to try BDT on this version.. As far as false errors, the latest version of BDT is greatly improved. However, I have noticed couple of false errors: 1) if the numeric subroutine label does not have a : BDT doesn't recognize the label (like 99*). 2) LOCATE(J,ORIG.PH,2;XXXPOS) THEN FOUND=1 ELSE FOUND=0 , BDT will report that XXXPOS was never assigned a value. There are other instances of this type of problem. One thing I wish I could do is edit records in hashed files, but I don't see how to accomplish this. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, June 06, 2013 12:06 PM To: U2 Users List Subject: [U2] How do I get the U2 Metadata Manager to work Ever since we finally upgraded UniData at work I have been trying out the new tools and don't seem to have much fun with them. The best one is XAdmin and I use it a lot these days. IMHO the interface is a bit crude and clunky, but I guess that's Eclipse and you can't do much about that. The BDT is not of much use since I need to make
Re: [U2] How do I get the U2 Metadata Manager to work
I downloaded the March 2013 client tools today and will hopefully be able to install them tomorrow or early next week. So yes, my version of BDT is March 2012 IIRC. The Metadata Manager is March 13, though. I just ran the install with the default options, clicked on the program and selected the server already set up with UCI. This worked just fine with Xadmin and BDT and as I said before MDM also connects fine and displays all the UD accounts and files. But when I right click on a file all the MDM options are greyed out. All I can do is open the dictionary and maintain that. And what about my suggestion at the last U2U to make XAdmin use sudo so you can use all functions without having to log on as root? You may be allowed to log on as root on your test systems but my sys admin doesn't give anyone the root password for the production server. Cheers Mecki On 06/06/2013 20:35, Daniel McGrath wrote: Hi Mecki, It sounds like you are running a old copy of BDT. Unassigned variable warnings from CALL statements was fixed sometime last year. Follow the instructions here (http://updates.rocketsoftware.com/u2/) to make sure you have the latest versions. I can't recall which version, but if you are on too old of a release, that update site won't work for you, so you would have to download the full version again before you can use it. The latest full package is MAR2013. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, June 06, 2013 1:22 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work I'll keep that refresh option in mind. Still a hassle and I would prefer if they would just get rid of that 'feature'. I also noticed that unassigned variable error that pops up for all functions including CALL that return a new variable. Some people may regard assigning a value before you use a function as good coding standard, I don't see the point, though. I haven't tried this in anger, but I recall that BDT treats all files as data files and you can edit data as well. Maybe this is a feature they could add to keep Dict files and hashed files separate so you don't have to look for the BP within 1000 data files every time. I have been using an external editor (mv developer) for several years now. I always save the program to disk, open it with ED, add a blank line somewhere and file it with FIBC. That takes care of PRC. Locking works when you open a program externally, so the only chance that someone could snatch the program ab incorporate it into another project is in that short period between saving in the external editor and opening it with ED on the UD server for the first time. Since I am the only UD programmer in the company it is virtually impossible that will ever happen. Well, and as long as you have OS.ED you can bypass PRC anyway. OK, if you NEVER EVER fix data with ED then you could probably remove it, but who would voluntarily block the only fire escape? We have a really old version of PRC (3.9) and I can't make a business case to invest in new software. There are other tools like mv.SSIS that I'd rather get first. Especially since tools like Rocket's Metadata Manager don't seem to work or I am too stupid to install them properly. I managed to get at least VSG to work on one SQL Server 2008 box, but that is a really primitive tool and I hate it. And I am still looking for a way to read data from a relational database in a Basic program. On 06/06/2013 18:30, Tom Whitmore wrote: Hi Mecki, One think that I always do with BDT is right-click on the program, select refresh, then open the program. That seems to be the only way to make sure I have the current version. Currently, BDT is sort of working with PRC but it isn't honoring file ownership so I'm unable to let the programmers use BDT. You do need to get some programs from Susan for things to work as I have it now. I'm told the latest version of PRC supports BDT. We are currently testing the new version of PRC but I haven't had an opportunity to try BDT on this version.. As far as false errors, the latest version of BDT is greatly improved. However, I have noticed couple of false errors: 1) if the numeric subroutine label does not have a : BDT doesn't recognize the label (like 99*). 2) LOCATE(J,ORIG.PH,2;XXXPOS) THEN FOUND=1 ELSE FOUND=0 , BDT will report that XXXPOS was never assigned a value. There are other instances of this type of problem. One thing I wish I could do is edit records in hashed files, but I don't see how to accomplish this. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, June 06, 2013 12:06 PM To: U2 Users List Subject: [U2] How do I get the U2 Metadata Manager