Re: [U2] Not Consistent Failure
Thanks for the help on this one. That one gave me just enough information to figure things out. First, when the login failed, I saw an error message There are running jobs... just as the process should have been passed to Universe. That was odd, so I checked the output of the truss command, and it appeared only in the stream of the failed logins. Then I got to thinking, hey, I remember a seldom seen bug in AIX (and a couple of other OSes) where if the PID table because full, and thus had to start at the beginning again, sometimes it wouldn't know a PID wasn't in use any more because it hadn't been cleared from the table correctly, and give some anomalous errors. So, I did 'uptime' and saw they hadn't rebooted the system in 60 days. I used to work for this client and know they have a month-end checklist that includes rebooting the server as part of closing out each month. So, I rebooted the system, and then logged in as 'bob' (the user who captured his screen for us to give things a go), and never once had a failed login after 30 or so attempts. It's been a long time since I was involved so deeply at the OS level of a system, so I really appreciate the help on this one. Karl On Tue, March 23, 2010 5:21 pm, Dan Fitzgerald wrote: truss -pdf pid will return a listing of every system call the process makes at the AIX kernel level, as well as any processes forked by the process (the 'f' option). It's hard to read without a reference like W. Richard Stevens' Advanced Programming in the Unix Environment, but if you see it bomb out right after it fails to open a file, for instance, that's a good clue. Date: Tue, 23 Mar 2010 16:34:35 -0600 From: ka...@ourldsfamily.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] Not Consistent Failure I've not uses the truss command. Pointers? They drop to the Unix directory specified in the passwd file. Karl On Tue, March 23, 2010 3:53 pm, Dan Fitzgerald wrote: One thing you could do is to make that sleep like 30 seconds, find that pid, then use the AIX truss command against it while it's sleeping, and see what bombs. When they drop to AIX, are they in the directory specified in /etc/passwd, or somewhere else? Date: Tue, 23 Mar 2010 15:26:16 -0600 From: ka...@ourldsfamily.com To: u2-users@listserver.u2ug.org Subject: [U2] Not Consistent Failure When ever I see someone post something that can't be replicated because it's inconsistent, I wonder what the answer is going to be. So, here goes: I have a client that has started experiencing a login anomaly. First, the use telnet, and second, they don't have passwords at the Unix level. They are on AIX 5.2.0.0 with Universe 10.2.12 The things I've seen are: - the session doesn't make it into UV for their password prompt but drops straight to Unix. - I've checked permissions at various locations and at various levels. - I've commented out various parts of both /etc/profile and /u1/ACCT/.profile with no consistent noticeable change. - I've checked UV.LOGIN and ACCT LOGIN as well and nothing has changed in either place, and they are performing minimal tasks. - I've added a sleep just before exec /u1/uv/bin/uv plus changed uv to uvsh to see if that mattered. It didn't change the failures. - Failures are either on the 2nd login, 4th login, 3rd and 4th, 6th and 7th, 2nd and 3rd and 5th or whenever the pattern can't be matched... In other words, there's no rhyme or reason that can be applied to this failure. This is a real head-scratcher for me and I'm hoping someone has seen this or has something to offer. TIA --- Karl Pearson ka...@ourldsfamily.com Owner/Administrator of the sites at http://ourldsfamily.com --- To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote. --Benjamin Franklin --- Children seldom misquote you. In fact, they usually repeat word for word what you shouldn't have said. --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ Hotmail: Trusted email with powerful SPAM protection. http://clk.atdmt.com/GBL/go/210850553/direct/01/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Karl Pearson ka...@ourldsfamily.com Owner/Administrator of the sites at http://ourldsfamily.com --- To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- Democracy is two wolves and a lamb voting on what to have for
Re: [U2] Pick Pocket Guide
My bad on the mid-cap drop; sorry. For TCL/ECL, maybe mvCommand or mvControl? I didn't say it will be easy or even worthwhile for the experts; but, I think it must help in some way to be known as the gurus in this market (better billable rates, makes you more desirable as a consultant, etc.). If there are five authors (for five platforms) and they each write 20% of the book and that book has the potential of selling 5 times more (for five platforms instead of one), essentially, you are producing a book for 1/5 of the cost. I know we can really work these numbers so in the end it will cost nothing to write [like the days we work in a year]. I know it's still a tough sell, but, maybe even include some ad-supported areas within the book (as long as it doesn't compromise objectivity concerning the platforms). I think the major platform vendors should also contribute to get this done as it directly benefits them the most. Recently, I have moved away from the MultiValue market [not by choice]. I must say that I'd have a difficult time in getting any 'buy-in' though on what I still consider an incredibly powerful database due to almost a complete lack of visibility. How do you promote a technology that hasn't had a book based on it in quite a long time? If the platform vendors, tool and integration companies, etc. still believe that they have a good story to tell, it's time to ante up and place your bets already. Regards, Jim -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton Oliver Sent: Wednesday, March 24, 2010 1:19 AM To: U2 Users List Subject: Re: [U2] Pick Pocket Guide Well, the terminology issue is something we (Spectrum magazine in particular) can promote since we are already committed to promoting the term MultiValue (note the mid-cap casing) and the MultiValue Logo. We just add such terms to our Style and Usage Guide and use them in the magazine. Side note: Is there any interest in us having our Style and Usage Guide available online? I'm interested in hearing what folks would find an acceptable term for TCL/ECL/etc. As to the idea of of a generic book, groups of experts, etc., that sounds like a fame and glory no profit Open Source kind of thing. A lot of the experts you might want to attract are dudes and dudettes trying to make a living. That goes back to some of Tony's comments. How could that be made worthwhile for said experts to forgo revenue producing time to produce a non-profit book? Considering some other Open Source documentation efforts, I'm not saying it can't be done. I'm just challenging everyone to present detailed ideas for how it could be made to work. Regards, Clif On Mar 23, 2010, at 6:09 PM, James Canale, Jr. wrote: I think it would be great do something like this. Multivalue Query [mvQuery] Multivalue Basic [mvBasic] Multivalue PROC [mvPROC] I also think it would be great if someone could write a piece of a book that is very generic (keep it at a 20,000 foot view) which covers each major topic area. Once complete, a group of experts-at-large in the various flavors add platform specific details. When complete, one or more of the know-it-alls [like some of the gurus on this list] combine the common parts, while leaving the unique areas in place. Basically, a wiki to book transformation. Many of the books sold today have two, three, and even more authors (especially the technically oriented books). Something like this could reduce the work required (just doing a piece of the whole) and increase the potential market (supports most platforms) for sales. I see a lot of talent on this list that can pull something like this off, it just needs a great leader (and I see many of them here too). Regards, Jim -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton Oliver Sent: Tuesday, March 23, 2010 6:39 PM To: U2 Users List Subject: Re: [U2] Pick Pocket Guide In Spectrum magazine, we use the term MultiValue Basic to talk about the programming language in articles that are not platform specific. I put it in the style and usage guide for just the reasons being brought up here. I don't see any reason not to add other MultiValue generic terms. MultiValue Query comes to mind. I'm open to suggestions about that and other terms. Post them here, or if you'd rather not, just send them to me at edi...@intl-spectrum.com (or my regular e-mail address). Regards, Clif -- Clifton Oliver, Managing Editor International Spectrum Magazine Spectrum Tel: +1 720 259 1356 Clif's Direct Tel: +1 619 460 5678 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list
Re: [U2] visual source safe plugin with basic developer toolkit
Has anyone tried the Microsoft visual source safe plugin for eclipse with the basic developer toolkit. I was trying to see if I could use a common source control mechanism for the .Net and unibasic code. http://sourceforge.net/projects/vssplugin/ Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] U2UG news (was Pick Pocket Guide)
All, 1. The good news is that the U2UG board has agreed to push ahead with our incubator project this year. This will combine learning materials and sample applications aimed at bringing the platform in front of genuinely new developers who have not encountered any flavour of multivalue before. The aim will be to make it as easy as possible to get people up and running to the point where they can seriously evaluate the technology, and to showcase the best that it can offer. No doubt we will be seeking volunteers along the road. We will be discussing exactly what we need to include, and how we will be developing these at the next board meeting (in two weeks' time). We already have a number of ideas taking shape, but in the mean time, suggestions are welcomed: just send them to me offlist and I'll keep everyone posted. Once we have a good batch, I'll add a new forum to the website dedicated to discussing and furthering this topic, since it is such an important piece for us as an industry. NOW - since we're going to be giving up a lot of time for this - we want something in return! Listen up! 2. One of the major problems has always been visibility. With the loss of the IBM name, that visibility has taken another dive. The best way to get that visibility and credibility back, is to be able to tell prospective customers and developers just how widespread this technology is. Which means, being able to tell them who is using it. I know we have top companies in every industry sector using U2. Half of them don't even know that there are other people in the same industry using it. And it makes them feel isolated and worried about the platform. We need a way to tell the world 'We Use U2'. So we are going to be launching an initiative for people to tell us that. No more than that - they don't need to tell us anything secret, how they are using it, what they are doing with it, nothing that points to a competitive advantage. Just that they are amongst the thousands of organizations that use it. So watch this space and think about how you can add your organizations names to this list. You might be surprised how many others are out there. Regards Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick Pocket Guide
Ahh we could discuss this at length. Firstly i agree Books are not uniquely sourced by product providers, and they shouldn't be - I think the difference is that there is a marketplace for books from these technologies hence why O'Reilly et al are there. When Microsoft first released Silverlight - the first books were from Microsoft themselves, the others quickly followed. I have had a similar experience with the Amazon web services, their own book by their product manager was an excellent overview, but i then had to wait for a bigger book to come out from one of the mainstream publishers. With MV, there is little marketplace, the big publishers are not going to get involved. I say rocket are ideally placed because they have a team of respected consultants, who (i may be wrong here) may not be 100% utilised and could be funded to produce literature as a project maybe in conjunction with some outside resources. How many MV vars, or consultants have teams of consultants ? - if Brian or John were to write a book at 2 days a week for 6 months thats 20% or their fee earning time for the year gone, I doubt they would recoup that. If rocket do the same it's a much smaller percentage, and in the long run may indeed help licence sales. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: 23 March 2010 04:51 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Pick Pocket Guide From: Tony Gravagno ... just like Linux, SQL Server, PHP, Java, C#, Excel, and hundreds of other technical topics From: Symeon Breen If you look at the other technologies you mention- the actual providers of these technologies are leaders in also providing books the providers are the best suited to producing such literature, and in my opinion should be taking the lead in this... My respected colleague, I must disagree. My extemporaneous sampling above mentions three Microsoft products and three non-Microsoft products about which Microsoft Press (I believe) does not have any publications. Many books are indeed published by Microsoft Press but take a look at your local store bookshelves and you'll find dozens of other publishers including Wrox, Apress, Manning, McGraw-Hill, IDG, O'Reilly, SAMS, and Addison-Wesley. Books are not uniquely sourced by product providers, and they shouldn't be. Who is the provider charged with writing books for open source software? We need books specifically because software authors are generally poor writers, and software providers generally don't invest in quality documentation. Put it back in their hands because they are best suited? The world would be a terrible place if software companies figured out that they could provide poor documentation and then make even more money as the unique source of for-fee books that explain their products. I also disagree that the DBMS software providers specifically are the best suited to producing product literature. I want documentation from my software vendors, but then I want them to continue working on the software, not books. The process for creating books is different than for product docs, and you'll get commentary about products from an independent author that you won't get from the software provider. One of the reasons why I said initially that this community is anti-book is that I've heard the same sort of commentary from other MV colleagues, that the DBMS vendors should be providing books, where you rarely get this sort of comment about any other product. Look at your local bookstore shelves and see how many books are written by the software provider - precious few. No, pushing the publication of books onto the DBMS providers simply goes nowhere. Don't bother. It's been tried before. DBMS vendors don't want to write books and they simply don't. They won't even accept help for their docs - both Clif and I have offered to help the DBMS vendors with their docs and after giving the concept some lip service these initiatives never go anywhere. Even if one indignantly maintains that they still should write books, it's a moot point - they won't. So we need to pick up from there and move forward. Best, T ___ 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] visual source safe plugin with basic developer toolkit
I use subversion for both my .net and unibasic code. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of djordan Sent: 24 March 2010 07:39 To: 'U2 Users List' Subject: Re: [U2] visual source safe plugin with basic developer toolkit Has anyone tried the Microsoft visual source safe plugin for eclipse with the basic developer toolkit. I was trying to see if I could use a common source control mechanism for the .Net and unibasic code. http://sourceforge.net/projects/vssplugin/ Regards David Jordan ___ 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] visual source safe plugin with basic developer toolkit
Ditto. I've found it the easiest to use with tortoise SVN for the desktop. But then, I don't use Eclipse or BDT. Tip - you also need to version manage other assets such as dictionaries. I've found the easiest way is to build my tables using definition scripts (similar to a create table statement in SQL) and to then version those scripts as part of the source code. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: 24 March 2010 10:05 AM To: 'U2 Users List' Subject: Re: [U2] visual source safe plugin with basic developer toolkit I use subversion for both my .net and unibasic code. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of djordan Sent: 24 March 2010 07:39 To: 'U2 Users List' Subject: Re: [U2] visual source safe plugin with basic developer toolkit Has anyone tried the Microsoft visual source safe plugin for eclipse with the basic developer toolkit. I was trying to see if I could use a common source control mechanism for the .Net and unibasic code. http://sourceforge.net/projects/vssplugin/ Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick Pocket Guide
When Microsoft first released Silverlight - the first books were from Microsoft themselves, the others quickly followed. You have just highlighted the essential difference between books and software.. Software is a single sale: you buy that product from the manufacturer and don't buy a rival product to do the same thing. That's not true with books - to take the Silverlight example, I have half a dozen different books on Silverlight on my shelves, each offering a different perspective and level of detail. Personally I've always found the microsoft press books rushed and full of errors, but I still buy them for the few useful nuggets they will hold, generally before the better written ones come out :) But all these things go hand in hand: We need new blood if we are going to support authors - since the hairy old MV developers won't be the ones buying books even though they can help bring their skills up to date with the new features in the products or up to date techniques. (It's the old 'this technology is easy so I shouldn't have to pay out for what I can work out by myself' argument - even though it's cheaper in the long run to get the advice rather than sacrifice paid time to do it yourself. See also: 'Not invented here syndrome'). But to attract that new blood, we need the publications and educational materials in place to tell them about the technology in the first place. Which is why the incubator project at the U2UG is such an important piece in this discussion. And why I will inevitably keep banging on about it for the next 12 months - you have been warned grin. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Using UNIVERSE Triggers for MYSQL?
I have used triggers to write the data I want to transfer to a queue file where I have another process that transfers the data in the queue to the remote database (Microsoft SQL). I designed the trigger that way because if for whatever reason the remote database becomes unavailable (and that does happen), it only impacts the process that is doing the transfer rather than causing my trigger to fail. Obviously the process that does the transfer has error handling to deal with failed transfers. Having a separate process to do the transfer allows the trigger to remain very small and fast with no noticeable impact to the end-user - and most important, no reason for the trigger to fail. We never use CLEARFILE on our main database files - so that is not an issue for us. Barry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of ARAMAIES BAGHDASRAIAN Sent: Tuesday, March 23, 2010 6:23 PM To: u2-users@listserver.u2ug.org Subject: [U2] Using UNIVERSE Triggers for MYSQL? Good day, I would like to learn on Universe Triggers for MYSQL. using Universe 10.3 . I have read the materials and there were issues on speed, dailiung to update if trigger fails, or Clearfile where the trigger does not get activated. Please let me know if you have used the Universe triggers in production environment to update MYSQL tables? Best regards, Ara ___ 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] MV MVP
I have been meaning to write to Suzie to ask Rocket to consider a MVP program. Microsoft, Sun, and other companies have this. Of course, MVP's are usually authors of books. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick Pocket Guide
As much as we can't seem to get away from referring to TCL, how about MVTCL or mvTCL! Date: Wed, 24 Mar 2010 03:16:06 -0400 From: jcan...@optonline.net To: u2-users@listserver.u2ug.org Subject: Re: [U2] Pick Pocket Guide My bad on the mid-cap drop; sorry. For TCL/ECL, maybe mvCommand or mvControl? I didn't say it will be easy or even worthwhile for the experts; but, I think it must help in some way to be known as the gurus in this market (better billable rates, makes you more desirable as a consultant, etc.). If there are five authors (for five platforms) and they each write 20% of the book and that book has the potential of selling 5 times more (for five platforms instead of one), essentially, you are producing a book for 1/5 of the cost. I know we can really work these numbers so in the end it will cost nothing to write [like the days we work in a year]. I know it's still a tough sell, but, maybe even include some ad-supported areas within the book (as long as it doesn't compromise objectivity concerning the platforms). I think the major platform vendors should also contribute to get this done as it directly benefits them the most. Recently, I have moved away from the MultiValue market [not by choice]. I must say that I'd have a difficult time in getting any 'buy-in' though on what I still consider an incredibly powerful database due to almost a complete lack of visibility. How do you promote a technology that hasn't had a book based on it in quite a long time? If the platform vendors, tool and integration companies, etc. still believe that they have a good story to tell, it's time to ante up and place your bets already. Regards, Jim -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton Oliver Sent: Wednesday, March 24, 2010 1:19 AM To: U2 Users List Subject: Re: [U2] Pick Pocket Guide Well, the terminology issue is something we (Spectrum magazine in particular) can promote since we are already committed to promoting the term MultiValue (note the mid-cap casing) and the MultiValue Logo. We just add such terms to our Style and Usage Guide and use them in the magazine. Side note: Is there any interest in us having our Style and Usage Guide available online? I'm interested in hearing what folks would find an acceptable term for TCL/ECL/etc. As to the idea of of a generic book, groups of experts, etc., that sounds like a fame and glory no profit Open Source kind of thing. A lot of the experts you might want to attract are dudes and dudettes trying to make a living. That goes back to some of Tony's comments. How could that be made worthwhile for said experts to forgo revenue producing time to produce a non-profit book? Considering some other Open Source documentation efforts, I'm not saying it can't be done. I'm just challenging everyone to present detailed ideas for how it could be made to work. Regards, Clif On Mar 23, 2010, at 6:09 PM, James Canale, Jr. wrote: I think it would be great do something like this. Multivalue Query [mvQuery] Multivalue Basic [mvBasic] Multivalue PROC [mvPROC] I also think it would be great if someone could write a piece of a book that is very generic (keep it at a 20,000 foot view) which covers each major topic area. Once complete, a group of experts-at-large in the various flavors add platform specific details. When complete, one or more of the know-it-alls [like some of the gurus on this list] combine the common parts, while leaving the unique areas in place. Basically, a wiki to book transformation. Many of the books sold today have two, three, and even more authors (especially the technically oriented books). Something like this could reduce the work required (just doing a piece of the whole) and increase the potential market (supports most platforms) for sales. I see a lot of talent on this list that can pull something like this off, it just needs a great leader (and I see many of them here too). Regards, Jim -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton Oliver Sent: Tuesday, March 23, 2010 6:39 PM To: U2 Users List Subject: Re: [U2] Pick Pocket Guide In Spectrum magazine, we use the term MultiValue Basic to talk about the programming language in articles that are not platform specific. I put it in the style and usage guide for just the reasons being brought up here. I don't see any reason not to add other MultiValue generic terms. MultiValue Query comes to mind. I'm open to suggestions about that and other terms. Post them here, or if you'd rather not, just send them to me at edi...@intl-spectrum.com (or my regular e-mail address). Regards, Clif -- Clifton Oliver, Managing
Re: [U2] Pick Pocket Guide
From: Tony Gravagno The world would be a terrible place if software companies figured out that they could provide poor documentation and then make even more money as the unique source of for-fee books that explain their products. Game software companies figured that out a long time ago, I'm afraid. Even before a game hits the stores, you'll find strategy guides, hint guides, walkthroughs, you name it... John M. Horn | Solutions Engineer, Advisor Sr. | HealthLink | 314-925-6050 | jh...@healthlink.com CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information or otherwise protected by law. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] JDBC - ClassPath - Victory
Ben:
Thanks for the follow-up. I appreciate it.
--Bill
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ben Souther
Sent: Tuesday, March 23, 2010 5:34 PM
To: U2 Users List
Subject: Re: [U2] JDBC - ClassPath - Victory
Glad it's working.
Tip: You should always put the con.close() statement in a finally
block.
The close method itself can throw an exception so it needs to be in a
nested try/catch.
Putting in in a finally block insures that come Hello or high water the
connection gets closed.
One of the most common causes for memory leaks in JDBC applications is
the build up of unclosed database connections.
Connection con = null;
try{
// establish connection and do stuff
}catch(Exception e){
// deal with any problems
}finally{
try{
con.close();
}catch(Exception ignored){}
}
On Mar 23, 2010, at 3:33 PM, Brutzman, Bill wrote:
The following code works ok...
Thanks to all those who responded especially John, Jeff, Bruce,
Charles, Ben, and Mike.
--Bill
import java.sql.*;
public class Uni_101 {
public static void main(String[] args) {
try {
try {
Class.forName(com.ibm.u2.jdbc.UniJDBCDriver);
}
catch(Exception x){
System.out.println( Here + x );
}
String url =
jdbc:ibm-u2://192.168.0.102/SHIPPING;
String userid
= ups;
String passWord =
brown;
Connection con = DriverManager.getConnection(url, userid,
passWord);
Statement stmt = con.createStatement();
String sql = select @ID, NAME,
CITY, STATE from PACKSLIPS.X;
ResultSet rs = stmt.executeQuery(sql);
int i = 1;
while (rs.next() i 6)
{
System.out.println(\nRecord + i + :);
System.out.println(\...@id : \t + rs.getString(1));
System.out.println(\tNAME :\t + rs.getString(2));
System.out.println(\tCITY :\t + rs.getString(3));
System.out.println(\tSTATE :\t + rs.getString(4));
i++;
}
rs.close();
stmt.close() ;
System.out.println(\n\t*--- QUERY test is done successful
---*\n);
}
catch (SQLException e ) {
System.out.println(e);
}
}
}
___
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] JDBC - Finally - Hitch
Ben:
1. I am glad to find out about the finally command. I was not aware
of this feature in Java.
2. The new code below yields an IDE error... con cannot be resolved
3. Connection con was already defined... it gives an error when I do a
con = null;
4. IDE does not accept con.close;
5. While I am happy to look into this and figure it out... right now I
do not know the fix.
Regards,
--Bill
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBC_1001 {
public static void main(String[] args) {
try {
try {
Class.forName(com.ibm.u2.jdbc.UniJDBCDriver);
}
catch(Exception x){
System.out.println( Here + x );
}
String url
= jdbc:ibm-u2://192.168.0.102/SHIPPING;
String userid
= ups;
String
passWord = brown;
Connection con = DriverManager.getConnection(url, userid,
passWord);
Statement stmt = con.createStatement();
String sql = select @ID, NAME,
CITY, STATE from PACKSLIPS.X;
ResultSet rs = stmt.executeQuery(sql);
int i = 1;
while (rs.next() i 6)
{
System.out.println(\nRecord + i + :);
System.out.println(\...@id : \t + rs.getString(1));
System.out.println(\tNAME :\t + rs.getString(2));
System.out.println(\tCITY :\t + rs.getString(3));
System.out.println(\tSTATE :\t + rs.getString(4));
i++;
}
rs.close();
stmt.close() ;
System.out.println(\n\t*--- QUERY test is done successful
---*\n);
}
catch (SQLException e ) {
System.out.println(e);
}
finally{
try{
con.close();
}
catch(Exception ignored){}
}
}
}
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ben Souther
Sent: Tuesday, March 23, 2010 5:34 PM
To: U2 Users List
Subject: Re: [U2] JDBC - ClassPath - Victory
Glad it's working.
Tip: You should always put the con.close() statement in a finally
block.
The close method itself can throw an exception so it needs to be in a
nested try/catch.
Putting in in a finally block insures that come Hello or high water the
connection gets closed.
One of the most common causes for memory leaks in JDBC applications is
the build up of unclosed database connections.
Connection con = null;
try{
// establish connection and do stuff
}catch(Exception e){
// deal with any problems
}finally{
try{
con.close();
}catch(Exception ignored){}
}
On Mar 23, 2010, at 3:33 PM, Brutzman, Bill wrote:
The following code works ok...
Thanks to all those who responded especially John, Jeff, Bruce,
Charles, Ben, and Mike.
--Bill
import java.sql.*;
public class Uni_101 {
public static void main(String[] args) {
try {
try {
Class.forName(com.ibm.u2.jdbc.UniJDBCDriver);
}
catch(Exception x){
System.out.println( Here + x );
}
String url =
jdbc:ibm-u2://192.168.0.102/SHIPPING;
String userid
= ups;
String passWord =
brown;
Connection con = DriverManager.getConnection(url, userid,
passWord);
Statement stmt = con.createStatement();
String sql = select @ID, NAME,
CITY, STATE from PACKSLIPS.X;
ResultSet rs = stmt.executeQuery(sql);
int i = 1;
while (rs.next() i 6)
{
System.out.println(\nRecord + i + :);
System.out.println(\...@id : \t + rs.getString(1));
System.out.println(\tNAME :\t + rs.getString(2));
System.out.println(\tCITY :\t + rs.getString(3));
System.out.println(\tSTATE :\t + rs.getString(4));
i++;
}
rs.close();
stmt.close() ;
System.out.println(\n\t*--- QUERY test is done successful
---*\n);
}
catch (SQLException e ) {
System.out.println(e);
}
}
}
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing
Re: [U2] visual source safe plug-in with basic developer toolkit
BDT, Rocket's Eclipse based U2 editor, does not manage any source control either program, procs or dictionaries. Using the other Eclipse based editor manages all of the above and even data for the those code files. This other Eclipse based editor can use Subversion, CVS, Perforce, or GIT as you source control. Regards, Doug www.u2logic.com/tools.html The other Eclipse based U2 Editor for $49.00 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Wednesday, March 24, 2010 4:36 AM To: 'U2 Users List' Subject: Re: [U2] visual source safe plugin with basic developer toolkit Ditto. I've found it the easiest to use with tortoise SVN for the desktop. But then, I don't use Eclipse or BDT. Tip - you also need to version manage other assets such as dictionaries. I've found the easiest way is to build my tables using definition scripts (similar to a create table statement in SQL) and to then version those scripts as part of the source code. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] JDBC - Finally - Hitch
In Java, variables are local to the block in which they were declared.
So, in order to reach your 'con' variable from outside the 'try' block
it needs to be declared outside of that block.
Connection con = null; // declare con outside of try block.
try{
con = DriverManager...
// do stuff with the connection
}catch(Exception e){
// handle any exceptions
}finally{
try{
con.close();
}catch(Exception ignored){
}
}
On Wed, 2010-03-24 at 11:49 -0400, Brutzman, Bill wrote:
Ben:
1. I am glad to find out about the finally command. I was not aware
of this feature in Java.
2. The new code below yields an IDE error... con cannot be resolved
3. Connection con was already defined... it gives an error when I do a
con = null;
4. IDE does not accept con.close;
5. While I am happy to look into this and figure it out... right now I
do not know the fix.
Regards,
--Bill
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBC_1001 {
public static void main(String[] args) {
try {
try {
Class.forName(com.ibm.u2.jdbc.UniJDBCDriver);
}
catch(Exception x){
System.out.println( Here + x );
}
String url
= jdbc:ibm-u2://192.168.0.102/SHIPPING;
String userid
= ups;
String
passWord = brown;
Connection con = DriverManager.getConnection(url, userid,
passWord);
Statement stmt = con.createStatement();
String sql = select @ID, NAME,
CITY, STATE from PACKSLIPS.X;
ResultSet rs = stmt.executeQuery(sql);
int i = 1;
while (rs.next() i 6)
{
System.out.println(\nRecord + i + :);
System.out.println(\...@id : \t + rs.getString(1));
System.out.println(\tNAME :\t + rs.getString(2));
System.out.println(\tCITY :\t + rs.getString(3));
System.out.println(\tSTATE :\t + rs.getString(4));
i++;
}
rs.close();
stmt.close() ;
System.out.println(\n\t*--- QUERY test is done successful
---*\n);
}
catch (SQLException e ) {
System.out.println(e);
}
finally{
try{
con.close();
}
catch(Exception ignored){}
}
}
}
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ben Souther
Sent: Tuesday, March 23, 2010 5:34 PM
To: U2 Users List
Subject: Re: [U2] JDBC - ClassPath - Victory
Glad it's working.
Tip: You should always put the con.close() statement in a finally
block.
The close method itself can throw an exception so it needs to be in a
nested try/catch.
Putting in in a finally block insures that come Hello or high water the
connection gets closed.
One of the most common causes for memory leaks in JDBC applications is
the build up of unclosed database connections.
Connection con = null;
try{
// establish connection and do stuff
}catch(Exception e){
// deal with any problems
}finally{
try{
con.close();
}catch(Exception ignored){}
}
On Mar 23, 2010, at 3:33 PM, Brutzman, Bill wrote:
The following code works ok...
Thanks to all those who responded especially John, Jeff, Bruce,
Charles, Ben, and Mike.
--Bill
import java.sql.*;
public class Uni_101 {
public static void main(String[] args) {
try {
try {
Class.forName(com.ibm.u2.jdbc.UniJDBCDriver);
}
catch(Exception x){
System.out.println( Here + x );
}
String url =
jdbc:ibm-u2://192.168.0.102/SHIPPING;
String userid
= ups;
String passWord =
brown;
Connection con = DriverManager.getConnection(url, userid,
passWord);
Statement stmt = con.createStatement();
String sql = select @ID, NAME,
CITY, STATE from PACKSLIPS.X;
ResultSet rs = stmt.executeQuery(sql);
int i = 1;
while (rs.next() i 6)
{
System.out.println(\nRecord + i + :);
System.out.println(\...@id : \t + rs.getString(1));
System.out.println(\tNAME
Re: [U2] Pick Pocket Guide [not-secure]
Heh - name it Genius and you invite a lawsuit from Apple... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green Sent: Tuesday, March 23, 2010 4:26 PM To: 'U2 Users List' Subject: Re: [U2] Pick Pocket Guide I say we name it Genius so we can all feel smarter when we go to work! GeniusDB GeniusQuery GeniusCode (Not GeniusBasic that's an oxymoron) Etc. Hey! We've all just been elevated to Genius Programmers! 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 fft2...@aol.com Sent: Tuesday, March 23, 2010 12:42 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Pick Pocket Guide In a message dated 3/23/2010 4:14:07 AM Pacific Daylight Time, br...@brianleach.co.uk writes: So suggestions welcomed. I'm opining that we need a name that is NOT an existing word or acronym of anything else. Something brand new and fresh and unique so no more false positives. Will ___ 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] wIntegrate Launch Label Program - Problem
Sometimes when launching SeaGull Scientific's BarTender program via wIntegrate, the computer appears to stall. A band-aid is to Alt-Tab and then choose the BarTender program... and then the label prints. Is there a wIntegrate setting to do something like a Set Focus such that BT is on top when invoked from a UniBasic program ? Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] U2 on Windows wierdness
OK. Here's a strange one. If I type up a program in the text editor, and save it. Then I copy that file to windows folder, which Universe has access to If I then copy that file from this folder to SOURCE (from within Universe), it's all in lower case What's the deal? How can fix this. UV is in Reality mode, on a Windows platform. George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 on Windows wierdness
I've seen things like this when using a mapped drive from Windows to UNIX. I create something in upper case yet it is in lower case on the UNIX box. If I build it on the UNIX box first (even just an empty file), the file name is in the upper/lower as I wanted. It appears to only be an issue when I first create it using Windows. I hope that helps. John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH 45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, March 24, 2010 2:41 PM To: U2 Users List Subject: [U2] U2 on Windows wierdness OK. Here's a strange one. If I type up a program in the text editor, and save it. Then I copy that file to windows folder, which Universe has access to If I then copy that file from this folder to SOURCE (from within Universe), it's all in lower case What's the deal? How can fix this. UV is in Reality mode, on a Windows platform. George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.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] U2 on Windows wierdness
The original file was created on a windows machine, Then transferred to another windows machine using remotePC website This machine has a mapped drive which is on an NT server The UV server is on the NT machine No unix (maybe that's the problem :) ) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Wednesday, March 24, 2010 2:44 PM To: U2 Users List Subject: Re: [U2] U2 on Windows wierdness I've seen things like this when using a mapped drive from Windows to UNIX. I create something in upper case yet it is in lower case on the UNIX box. If I build it on the UNIX box first (even just an empty file), the file name is in the upper/lower as I wanted. It appears to only be an issue when I first create it using Windows. I hope that helps. John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH 45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, March 24, 2010 2:41 PM To: U2 Users List Subject: [U2] U2 on Windows wierdness OK. Here's a strange one. If I type up a program in the text editor, and save it. Then I copy that file to windows folder, which Universe has access to If I then copy that file from this folder to SOURCE (from within Universe), it's all in lower case What's the deal? How can fix this. UV is in Reality mode, on a Windows platform. George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.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] U2 on Windows wierdness
I don't mean the filename is lowercase, I mean the contents of the file. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Wednesday, March 24, 2010 2:44 PM To: U2 Users List Subject: Re: [U2] U2 on Windows wierdness I've seen things like this when using a mapped drive from Windows to UNIX. I create something in upper case yet it is in lower case on the UNIX box. If I build it on the UNIX box first (even just an empty file), the file name is in the upper/lower as I wanted. It appears to only be an issue when I first create it using Windows. I hope that helps. John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH 45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, March 24, 2010 2:41 PM To: U2 Users List Subject: [U2] U2 on Windows wierdness OK. Here's a strange one. If I type up a program in the text editor, and save it. Then I copy that file to windows folder, which Universe has access to If I then copy that file from this folder to SOURCE (from within Universe), it's all in lower case What's the deal? How can fix this. UV is in Reality mode, on a Windows platform. George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.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] JDBC - BrainTeaser
Thanks to Ben and Ross but...
Of course the Class.forName connection string has to be invoked first.
My brain hurts.
--Bill
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ben Souther
Sent: Wednesday, March 24, 2010 1:24 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] JDBC - Finally - Hitch
In Java, variables are local to the block in which they were declared.
So, in order to reach your 'con' variable from outside the 'try' block
it needs to be declared outside of that block.
Connection con = null; // declare con outside of try block.
try{
con = DriverManager...
// do stuff with the connection
}catch(Exception e){
// handle any exceptions
}finally{
try{
con.close();
}catch(Exception ignored){
}
}
On Wed, 2010-03-24 at 11:49 -0400, Brutzman, Bill wrote:
Ben:
1. I am glad to find out about the finally command. I was not aware
of this feature in Java.
2. The new code below yields an IDE error... con cannot be resolved
3. Connection con was already defined... it gives an error when I do a
con = null; 4. IDE does not accept con.close; 5. While I am happy to
look into this and figure it out... right now I do not know the fix.
Regards,
--Bill
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBC_1001 {
public static void main(String[] args) {
try {
try {
Class.forName(com.ibm.u2.jdbc.UniJDBCDriver);
}
catch(Exception x){
System.out.println( Here + x );
}
String url =
jdbc:ibm-u2://192.168.0.102/SHIPPING;
String userid
= ups;
String passWord =
brown;
Connection con = DriverManager.getConnection(url, userid,
passWord);
Statement stmt = con.createStatement();
String sql = select @ID, NAME,
CITY, STATE from PACKSLIPS.X;
ResultSet rs = stmt.executeQuery(sql);
int i = 1;
while (rs.next() i 6)
{
System.out.println(\nRecord + i + :);
System.out.println(\...@id : \t + rs.getString(1));
System.out.println(\tNAME :\t + rs.getString(2));
System.out.println(\tCITY :\t + rs.getString(3));
System.out.println(\tSTATE :\t + rs.getString(4));
i++;
}
rs.close();
stmt.close() ;
System.out.println(\n\t*--- QUERY test is done successful
---*\n);
}
catch (SQLException e ) {
System.out.println(e);
}
finally{
try{
con.close();
}
catch(Exception ignored){}
}
}
}
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ben Souther
Sent: Tuesday, March 23, 2010 5:34 PM
To: U2 Users List
Subject: Re: [U2] JDBC - ClassPath - Victory
Glad it's working.
Tip: You should always put the con.close() statement in a finally
block.
The close method itself can throw an exception so it needs to be in a
nested try/catch.
Putting in in a finally block insures that come Hello or high water
the connection gets closed.
One of the most common causes for memory leaks in JDBC applications is
the build up of unclosed database connections.
Connection con = null;
try{
// establish connection and do stuff
}catch(Exception e){
// deal with any problems
}finally{
try{
con.close();
}catch(Exception ignored){}
}
On Mar 23, 2010, at 3:33 PM, Brutzman, Bill wrote:
The following code works ok...
Thanks to all those who responded especially John, Jeff, Bruce,
Charles, Ben, and Mike.
--Bill
import java.sql.*;
public class Uni_101 {
public static void main(String[] args) {
try {
try {
Class.forName(com.ibm.u2.jdbc.UniJDBCDriver);
}
catch(Exception x){
System.out.println( Here + x );
}
String url =
jdbc:ibm-u2://192.168.0.102/SHIPPING;
String userid
= ups;
String passWord =
brown;
Connection con = DriverManager.getConnection(url, userid,
passWord);
Statement stmt = con.createStatement();
Re: [U2] U2 on Windows wierdness
I've had very similar weird things happen with uv on windows. Possibly stemming from the PTERM CASE setting? -Dianne George Gallen wrote: OK. Here's a strange one. If I type up a program in the text editor, and save it. Then I copy that file to windows folder, which Universe has access to If I then copy that file from this folder to SOURCE (from within Universe), it's all in lower case What's the deal? How can fix this. UV is in Reality mode, on a Windows platform. George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 on Windows wierdness
Why would that matter (not saying it doesn't)? I'm not typeing the file in UV, I'm copying it into a File UV has access to. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman Sent: Wednesday, March 24, 2010 2:55 PM To: U2 Users List Subject: Re: [U2] U2 on Windows wierdness I've had very similar weird things happen with uv on windows. Possibly stemming from the PTERM CASE setting? -Dianne ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 on Windows wierdness
HMMM. Maybe you have somethingI just HELPd on PTERM. I'll have to check into that next time I'm on that machineThanks -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman Sent: Wednesday, March 24, 2010 2:55 PM To: U2 Users List Subject: Re: [U2] U2 on Windows wierdness I've had very similar weird things happen with uv on windows. Possibly stemming from the PTERM CASE setting? -Dianne ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] svn with U2
Hi Symeon, Have you a way of versioning SB+ objects and dict items? I would really like to devise a way to version reports, screens and FD's. TIA, Steve ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick Pocket Guide
I'd like to also suggest nSQL and mvSQL Why not say SQL ? And then add n for nested or mv for multi-value And we can just say this is our BRAND of SQL it's SQL with added features. In a message dated 3/24/2010 7:30:47 A.M. Pacific Daylight Time, ron_hutchi...@hotmail.com writes: As much as we can't seem to get away from referring to TCL, how about MVTCL or mvTCL! Date: Wed, 24 Mar 2010 03:16:06 -0400 From: jcan...@optonline.net To: u2-users@listserver.u2ug.org Subject: Re: [U2] Pick Pocket Guide My bad on the mid-cap drop; sorry. For TCL/ECL, maybe mvCommand or mvControl? I didn't say it will be easy or even worthwhile for the experts; but, I think it must help in some way to be known as the gurus in this market (better billable rates, makes you more desirable as a consultant, etc.). If there are five authors (for five platforms) and they each write 20% of the book and that book has the potential of selling 5 times more (for five platforms instead of one), essentially, you are producing a book for 1/5 of the cost. I know we can really work these numbers so in the end it will cost nothing to write [like the days we work in a year]. I know it's still a tough sell, but, maybe even include some ad-supported areas within the book (as long as it doesn't compromise objectivity concerning the platforms). I think the major platform vendors should also contribute to get this done as it directly benefits them the most. Recently, I have moved away from the MultiValue market [not by choice]. I must say that I'd have a difficult time in getting any 'buy-in' though on what I still consider an incredibly powerful database due to almost a complete lack of visibility. How do you promote a technology that hasn't had a book based on it in quite a long time? If the platform vendors, tool and integration companies, etc. still believe that they have a good story to tell, it's time to ante up and place your bets already. Regards, Jim -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton Oliver Sent: Wednesday, March 24, 2010 1:19 AM To: U2 Users List Subject: Re: [U2] Pick Pocket Guide Well, the terminology issue is something we (Spectrum magazine in particular) can promote since we are already committed to promoting the term MultiValue (note the mid-cap casing) and the MultiValue Logo. We just add such terms to our Style and Usage Guide and use them in the magazine. Side note: Is there any interest in us having our Style and Usage Guide available online? I'm interested in hearing what folks would find an acceptable term for TCL/ECL/etc. As to the idea of of a generic book, groups of experts, etc., that sounds like a fame and glory no profit Open Source kind of thing. A lot of the experts you might want to attract are dudes and dudettes trying to make a living. That goes back to some of Tony's comments. How could that be made worthwhile for said experts to forgo revenue producing time to produce a non-profit book? Considering some other Open Source documentation efforts, I'm not saying it can't be done. I'm just challenging everyone to present detailed ideas for how it could be made to work. Regards, Clif On Mar 23, 2010, at 6:09 PM, James Canale, Jr. wrote: I think it would be great do something like this. Multivalue Query [mvQuery] Multivalue Basic [mvBasic] Multivalue PROC [mvPROC] I also think it would be great if someone could write a piece of a book that is very generic (keep it at a 20,000 foot view) which covers each major topic area. Once complete, a group of experts-at-large in the various flavors add platform specific details. When complete, one or more of the know-it-alls [like some of the gurus on this list] combine the common parts, while leaving the unique areas in place. Basically, a wiki to book transformation. Many of the books sold today have two, three, and even more authors (especially the technically oriented books). Something like this could reduce the work required (just doing a piece of the whole) and increase the potential market (supports most platforms) for sales. I see a lot of talent on this list that can pull something like this off, it just needs a great leader (and I see many of them here too). Regards, Jim -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton Oliver Sent: Tuesday, March 23, 2010 6:39 PM To: U2 Users List Subject: Re: [U2] Pick Pocket Guide In Spectrum magazine, we use the term MultiValue Basic to talk about the programming language in articles that are not platform specific. I put it in the style and usage
Re: [U2] svn with U2
Outside of using PRC, you will have to script things. You can use executables like UVread loadfile, UVwrite, etc. Take a look in the sample director under the uv directory to get the format of the .u files you will need to build. Regards, LeRoy From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow [slestak...@gmail.com] Sent: Wednesday, March 24, 2010 9:07 PM To: u2-users@listserver.u2ug.org Subject: [U2] svn with U2 Hi Symeon, Have you a way of versioning SB+ objects and dict items? I would really like to devise a way to version reports, screens and FD's. TIA, Steve ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users To read FRSTIA's disclaimer for the e-mail go to http://www.frstia.co.za/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 on Windows wierdness
Try PTERM CASE NOINVERT Ivan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, March 24, 2010 3:00 PM To: U2 Users List Subject: Re: [U2] U2 on Windows wierdness HMMM. Maybe you have somethingI just HELPd on PTERM. I'll have to check into that next time I'm on that machineThanks -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman Sent: Wednesday, March 24, 2010 2:55 PM To: U2 Users List Subject: Re: [U2] U2 on Windows wierdness I've had very similar weird things happen with uv on windows. Possibly stemming from the PTERM CASE setting? -Dianne ___ 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] U2 on Windows wierdness
Just to make sure.this would only affect my login? Wouldn't want the rest of the folks on the system think their caps locks key is broken :O -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Ivan Micklin Sent: Wednesday, March 24, 2010 3:19 PM To: 'U2 Users List' Subject: Re: [U2] U2 on Windows wierdness Try PTERM CASE NOINVERT Ivan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Trouble sending reply emails
Does anyone have any idea why I would be getting the following error message bounced to me when I reply to a message on the list? To send a message to the list, I have to initiate the message, I can't seem to reply. Thanks. -Dianne The message's content type was not explicitly allowed ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 on Windows wierdness
That is correct. It worked fine for me. Since it only worked for the current session, I had it in a paragraph with a couple of settings for my use. I ran the paragraph as soon as I logged in. Ivan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, March 24, 2010 3:21 PM To: U2 Users List Subject: Re: [U2] U2 on Windows wierdness Just to make sure.this would only affect my login? Wouldn't want the rest of the folks on the system think their caps locks key is broken :O -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Ivan Micklin Sent: Wednesday, March 24, 2010 3:19 PM To: 'U2 Users List' Subject: Re: [U2] U2 on Windows wierdness Try PTERM CASE NOINVERT Ivan ___ 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] Pick Pocket Guide
At the risk of stating the obvious, I think the following is the best 'centrist' approach for the common query commands: MVQL - Multi Value Query Language. As for the database resource - it's almost a non-issue any more who the provider is since most have 'flavors' that mimic the major variants. This generic primer would be the documentation that most interests the potential reader. System internals would come later and that would be something that we all obtain from the vendor. Free code is an excellent way to get others to embrace MV. We frequently borough code from PHP or other code sharing sites and cobble it into our basic routine if we're doing something new. If we could get more of this going, and offer the 'pocket guides' there, we'd garner more respect and affection. I know we have a couple wiki's out there - lets improve these and get a generic MV code foundry up. I must express my debt of gratitude to Jon also. He graciously allowed me to republish parts of his work when I taught a Programmers class for clients of Pick Professionals in St Louis. Fascinating thread. I've only read thru 1/2 of it so forgive me if any of my suggestions are redundant. -Baker This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick Pocket Guide
Brilliant! I have had a terrible time explaining to users why the term TCL exists, at least since the last time I was using an ADDS Viewpoint as my I/O device. Dan McGrath wrote: Hi Clif, I'd be interesting in reading. I write the occasional piece and probably should use more encompassing terms to enhance future search-ability and to promote the database style. Regarding ECL/TCL/etc, since I'm normally in Unix/Linux land, I normally think of them as shells, which brings MultiValue Shell (MVSH) to mind. -- 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
Re: [U2] Pick Pocket Guide
Because its not SQL. To many big differences between the purpose, theory, and operation of the two fft2...@aol.com wrote: I'd like to also suggest nSQL and mvSQL Why not say SQL ? And then add n for nested or mv for multi-value And we can just say this is our BRAND of SQL it's SQL with added features. In a message dated 3/24/2010 7:30:47 A.M. Pacific Daylight Time, ron_hutchi...@hotmail.com writes: As much as we can't seem to get away from referring to TCL, how about MVTCL or mvTCL! Date: Wed, 24 Mar 2010 03:16:06 -0400 From: jcan...@optonline.net To: u2-users@listserver.u2ug.org Subject: Re: [U2] Pick Pocket Guide My bad on the mid-cap drop; sorry. For TCL/ECL, maybe mvCommand or mvControl? I didn't say it will be easy or even worthwhile for the experts; but, I think it must help in some way to be known as the gurus in this market (better billable rates, makes you more desirable as a consultant, etc.). If there are five authors (for five platforms) and they each write 20% of the book and that book has the potential of selling 5 times more (for five platforms instead of one), essentially, you are producing a book for 1/5 of the cost. I know we can really work these numbers so in the end it will cost nothing to write [like the days we work in a year]. I know it's still a tough sell, but, maybe even include some ad-supported areas within the book (as long as it doesn't compromise objectivity concerning the platforms). I think the major platform vendors should also contribute to get this done as it directly benefits them the most. Recently, I have moved away from the MultiValue market [not by choice]. I must say that I'd have a difficult time in getting any 'buy-in' though on what I still consider an incredibly powerful database due to almost a complete lack of visibility. How do you promote a technology that hasn't had a book based on it in quite a long time? If the platform vendors, tool and integration companies, etc. still believe that they have a good story to tell, it's time to ante up and place your bets already. Regards, Jim -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton Oliver Sent: Wednesday, March 24, 2010 1:19 AM To: U2 Users List Subject: Re: [U2] Pick Pocket Guide Well, the terminology issue is something we (Spectrum magazine in particular) can promote since we are already committed to promoting the term MultiValue (note the mid-cap casing) and the MultiValue Logo. We just add such terms to our Style and Usage Guide and use them in the magazine. Side note: Is there any interest in us having our Style and Usage Guide available online? I'm interested in hearing what folks would find an acceptable term for TCL/ECL/etc. As to the idea of of a generic book, groups of experts, etc., that sounds like a fame and glory no profit Open Source kind of thing. A lot of the experts you might want to attract are dudes and dudettes trying to make a living. That goes back to some of Tony's comments. How could that be made worthwhile for said experts to forgo revenue producing time to produce a non-profit book? Considering some other Open Source documentation efforts, I'm not saying it can't be done. I'm just challenging everyone to present detailed ideas for how it could be made to work. Regards, Clif On Mar 23, 2010, at 6:09 PM, James Canale, Jr. wrote: I think it would be great do something like this. Multivalue Query [mvQuery] Multivalue Basic [mvBasic] Multivalue PROC [mvPROC] I also think it would be great if someone could write a piece of a book that is very generic (keep it at a 20,000 foot view) which covers each major topic area. Once complete, a group of experts-at-large in the various flavors add platform specific details. When complete, one or more of the know-it-alls [like some of the gurus on this list] combine the common parts, while leaving the unique areas in place. Basically, a wiki to book transformation. Many of the books sold today have two, three, and even more authors (especially the technically oriented books). Something like this could reduce the work required (just doing a piece of the whole) and increase the potential market (supports most platforms) for sales. I see a lot of talent on this list that can pull something like this off, it just needs a great leader (and I see many of them here too). Regards, Jim -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton Oliver Sent: Tuesday, March 23, 2010 6:39 PM To:
Re: [U2] svn with U2
Only if they are held in type 1 files -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: 24 March 2010 19:07 To: u2-users@listserver.u2ug.org Subject: [U2] svn with U2 Hi Symeon, Have you a way of versioning SB+ objects and dict items? I would really like to devise a way to version reports, screens and FD's. TIA, Steve ___ 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] Trouble sending reply emails
Try sending in plain text? On Wed, March 24, 2010 1:30 pm, Dianne Ackerman wrote: Does anyone have any idea why I would be getting the following error message bounced to me when I reply to a message on the list? To send a message to the list, I have to initiate the message, I can't seem to reply. Thanks. -Dianne The message's content type was not explicitly allowed ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Karl Pearson ka...@ourldsfamily.com Owner/Administrator of the sites at http://ourldsfamily.com --- To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote. --Benjamin Franklin --- Children seldom misquote you. In fact, they usually repeat word for word what you shouldn't have said. --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Cold Fusion Connection - Victory
I am pleased to report I was able to connect ok from Adobe ColdFusion 9 (running on our Windows Server) to UniVerse 10.1 running on HP-Ux. A bunch of people on the Adobe forum reported similar trouble. The recent U2-JDBC posts on this list were key to solving this problem. I expect that when the other Adobe forum users apply this new result, they will be especially appreciative. Thanks again to those who responded to this JDBC thing. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] svn with U2
You can accomplish a complete solution using the tools UV comes with, i.e. the tools that are used to install configure it, such as loadfile, UVread, UVwrite and so forth. Just determine how the .u files are structure, but take note that they are harder to user if you need to format one with records that are sub-valued. UV doesn't come with an example of how to do it. Wally Terhune may have some ideas about UniData. From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen [syme...@gmail.com] Sent: Wednesday, March 24, 2010 9:59 PM To: 'U2 Users List' Subject: Re: [U2] svn with U2 Only if they are held in type 1 files -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: 24 March 2010 19:07 To: u2-users@listserver.u2ug.org Subject: [U2] svn with U2 Hi Symeon, Have you a way of versioning SB+ objects and dict items? I would really like to devise a way to version reports, screens and FD's. TIA, Steve ___ 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 To read FRSTIA's disclaimer for the e-mail go to http://www.frstia.co.za/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Writeseq - getting to the EOF
ok. UV 10.0.2 Is there a quick way to get to the end of a file to start appending after an OPENSEQ Otherthan, a loop to READSEQ until it hits the EOF. Right now, that is not a problem, but this file could grow to some considerable size, and that loop might take a little bit to cycle through. I didn't see any options for the OPENSEQ to start at the EOF, and didn't find any commands that would set the eof (other than WEOFSEQ which doesn't seem likely to help). Thanks George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Writeseq - getting to the EOF
Try SEEK -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, March 24, 2010 4:26 PM To: U2 Users List Subject: [U2] Writeseq - getting to the EOF ok. UV 10.0.2 Is there a quick way to get to the end of a file to start appending after an OPENSEQ Otherthan, a loop to READSEQ until it hits the EOF. Right now, that is not a problem, but this file could grow to some considerable size, and that loop might take a little bit to cycle through. I didn't see any options for the OPENSEQ to start at the EOF, and didn't find any commands that would set the eof (other than WEOFSEQ which doesn't seem likely to help). Thanks George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.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] Writeseq - getting to the EOF
thanksworked. SEEK filehandle,0,2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of David Ward Sent: Wednesday, March 24, 2010 5:30 PM To: 'U2 Users List' Subject: Re: [U2] Writeseq - getting to the EOF Try SEEK -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, March 24, 2010 4:26 PM To: U2 Users List Subject: [U2] Writeseq - getting to the EOF ok. UV 10.0.2 Is there a quick way to get to the end of a file to start appending after an OPENSEQ Otherthan, a loop to READSEQ until it hits the EOF. Right now, that is not a problem, but this file could grow to some considerable size, and that loop might take a little bit to cycle through. I didn't see any options for the OPENSEQ to start at the EOF, and didn't find any commands that would set the eof (other than WEOFSEQ which doesn't seem likely to help). Thanks George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.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] Writeseq - getting to the EOF
How about WRITESEQ DATA APPEND ON S.FILE... 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 George Gallen Sent: Wednesday, March 24, 2010 2:26 PM To: U2 Users List Subject: [U2] Writeseq - getting to the EOF ok. UV 10.0.2 Is there a quick way to get to the end of a file to start appending after an OPENSEQ Otherthan, a loop to READSEQ until it hits the EOF. Right now, that is not a problem, but this file could grow to some considerable size, and that loop might take a little bit to cycle through. I didn't see any options for the OPENSEQ to start at the EOF, and didn't find any commands that would set the eof (other than WEOFSEQ which doesn't seem likely to help). Thanks George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.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] Trouble sending reply emails
Do you use Thunderbird? Bill Dianne Ackerman said the following on 3/24/2010 12:30 PM: Does anyone have any idea why I would be getting the following error message bounced to me when I reply to a message on the list? To send a message to the list, I have to initiate the message, I can't seem to reply. Thanks. -Dianne The message's content type was not explicitly allowed ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] svn with U2
Hi Leroy, Just had a quick look. I didn't even know those commands existed (or maybe I did and forgot). Loadfile sounds interesting. Just parsing UVread... $UVread usage: UVread [-q] [-f] [-s] file item ... $UVread -q VOC WHO 'V' 'WHO' 'I' 'G' $UVread -f /pathToOtherAccount/VOC WHO WHO V WHO I G $UVread -s VOC WHO I get the -f (formatted?) -q (quoted?) options -s ? Is there any documentation on these OS calls anywhere? Could someone provide it? Pick Pocket Guide update maybe ;) Cheers, Stuart Boydell -Original Message- You can accomplish a complete solution using the tools UV comes with, i.e. the tools that are used to install configure it, such as loadfile, UVread, UVwrite and so forth. Just determine how the .u files are structure, but take note that they are harder to user if you need to format one with records that are sub-valued. UV doesn't come with an example of how to do it. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] JDBC - Finally - Hitch
Bill,
You're trying to reference the connection out of it's scope.
Try moving the declaration like the example below.
On 03/24/2010 10:49 AM, Brutzman, Bill wrote:
Ben:
1. I am glad to find out about the finally command. I was not aware
of this feature in Java.
2. The new code below yields an IDE error... con cannot be resolved
3. Connection con was already defined... it gives an error when I do a
con = null;
4. IDE does not accept con.close;
5. While I am happy to look into this and figure it out... right now I
do not know the fix.
Regards,
--Bill
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBC_1001 {
public static void main(String[] args) {
Connection con=null;
try {
try {
Class.forName(com.ibm.u2.jdbc.UniJDBCDriver);
}
catch(Exception x){
System.out.println( Here + x );
}
String url
= jdbc:ibm-u2://192.168.0.102/SHIPPING;
String userid
= ups;
String
passWord = brown;
*Connection* con = DriverManager.getConnection(url, userid,
passWord);
Statement stmt = con.createStatement();
String sql = select @ID, NAME,
CITY, STATE from PACKSLIPS.X;
ResultSet rs = stmt.executeQuery(sql);
int i = 1;
while (rs.next() i 6)
{
System.out.println(\nRecord + i + :);
System.out.println(\...@id : \t + rs.getString(1));
System.out.println(\tNAME :\t + rs.getString(2));
System.out.println(\tCITY :\t + rs.getString(3));
System.out.println(\tSTATE :\t + rs.getString(4));
i++;
}
rs.close();
stmt.close() ;
System.out.println(\n\t*--- QUERY test is done successful
---*\n);
}
catch (SQLException e ) {
System.out.println(e);
}
finally{
try{
* if(con != null)*
con.close();
}
catch(Exception ignored){}
}
}
}
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ben Souther
Sent: Tuesday, March 23, 2010 5:34 PM
To: U2 Users List
Subject: Re: [U2] JDBC - ClassPath - Victory
Glad it's working.
Tip: You should always put the con.close() statement in a finally
block.
The close method itself can throw an exception so it needs to be in a
nested try/catch.
Putting in in a finally block insures that come Hello or high water the
connection gets closed.
One of the most common causes for memory leaks in JDBC applications is
the build up of unclosed database connections.
Connection con = null;
try{
// establish connection and do stuff
}catch(Exception e){
// deal with any problems
}finally{
try{
con.close();
}catch(Exception ignored){}
}
On Mar 23, 2010, at 3:33 PM, Brutzman, Bill wrote:
The following code works ok...
Thanks to all those who responded especially John, Jeff, Bruce,
Charles, Ben, and Mike.
--Bill
import java.sql.*;
public class Uni_101 {
public static void main(String[] args) {
try {
try {
Class.forName(com.ibm.u2.jdbc.UniJDBCDriver);
}
catch(Exception x){
System.out.println( Here + x );
}
String url =
jdbc:ibm-u2://192.168.0.102/SHIPPING;
String userid
= ups;
String passWord =
brown;
Connection con = DriverManager.getConnection(url, userid,
passWord);
Statement stmt = con.createStatement();
String sql = select @ID, NAME,
CITY, STATE from PACKSLIPS.X;
ResultSet rs = stmt.executeQuery(sql);
int i = 1;
while (rs.next() i 6)
{
System.out.println(\nRecord + i + :);
System.out.println(\...@id : \t + rs.getString(1));
System.out.println(\tNAME :\t + rs.getString(2));
System.out.println(\tCITY :\t + rs.getString(3));
System.out.println(\tSTATE :\t + rs.getString(4));
i++;
}
rs.close();
stmt.close() ;
System.out.println(\n\t*--- QUERY test is done successful
---*\n);
}
catch (SQLException e ) {
System.out.println(e);
}
}
}
Re: [U2] JDBC - Finally - Hitch
This text was supposed to be strikethrough to indicate that it needs to be removed since it's declared outside the outer try scope. On 03/24/2010 05:40 PM, Jeff Powell wrote: *Connection* con = DriverManager ... Should read con = DriverManager ... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] JDBC - con.close - Victory
Jeff:
It works... and answers a few of the minor mysteries. Thanks for
following-up.
Much obliged.
--Bill
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBC_1003 {
public static void main(String[] args) {
Connection con = null;
try {
try {
Class.forName(com.ibm.u2.jdbc.UniJDBCDriver);
}
catch(Exception x){
System.out.println( Here + x );
}
String url =
jdbc:ibm-u2://192.168.0.102/SHIPPING;
String userid =
ups;
String passWord =
brown;
con = DriverManager.getConnection(url, userid, passWord);
Statement stmt = con.createStatement();
String sql = select @ID, NAME, CITY,
STATE from PACKSLIPS.X;
ResultSet rs = stmt.executeQuery(sql);
int i = 1;
while (rs.next() i 6)
{
System.out.println(\nRecord + i + :);
System.out.println(\...@id : \t + rs.getString(1));
System.out.println(\tNAME :\t + rs.getString(2));
System.out.println(\tCITY :\t + rs.getString(3));
System.out.println(\tSTATE :\t + rs.getString(4));
i++;
}
rs.close();
stmt.close() ;
System.out.println(\n\t*--- QUERY test is done
successful ---*\n);
}
catch (SQLException e ) {
System.out.println(e);
}
finally{
try{
if(con != null)
con.close();
}
catch(Exception ignored){}
}
}
}
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Powell
Sent: Wednesday, March 24, 2010 6:49 PM
To: U2 Users List
Subject: Re: [U2] JDBC - Finally - Hitch
This text was supposed to be strikethrough to indicate that it needs to
be removed since it's declared outside the outer try scope.
On 03/24/2010 05:40 PM, Jeff Powell wrote:
*Connection* con = DriverManager ...
Should read
con = DriverManager ...
___
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] svn with U2
Hi Stuart, Long time no speak. I will put something together on how they are used for you. Cheers, LeRoy Sent from my iPhone 3Gs On 25 Mar 2010, at 12:23 AM, Boydell, Stuart stuart.boyd...@spotless.com.au wrote: Hi Leroy, Just had a quick look. I didn't even know those commands existed (or maybe I did and forgot). Loadfile sounds interesting. Just parsing UVread... $UVread usage: UVread [-q] [-f] [-s] file item ... $UVread -q VOC WHO 'V' 'WHO' 'I' 'G' $UVread -f /pathToOtherAccount/VOC WHO WHO V WHO I G $UVread -s VOC WHO I get the -f (formatted?) -q (quoted?) options -s ? Is there any documentation on these OS calls anywhere? Could someone provide it? Pick Pocket Guide update maybe ;) Cheers, Stuart Boydell -Original Message- You can accomplish a complete solution using the tools UV comes with, i.e. the tools that are used to install configure it, such as loadfile, UVread, UVwrite and so forth. Just determine how the .u files are structure, but take note that they are harder to user if you need to format one with records that are sub-valued. UV doesn't come with an example of how to do it. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users To read FRSTIA's disclaimer for the e-mail go to http://www.frstia.co.za/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Writeseq - getting to the EOF
George, Have you tried the SEEK statement, ie, SEEK filehandle, 0 , 2 The 0 (zero) is the offset and the 2 is relative to the end of the file. Caution, untested code! Good luck, Don Robinson From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, March 24, 2010 5:25:31 PM Subject: [U2] Writeseq - getting to the EOF ok. UV 10.0.2 Is there a quick way to get to the end of a file to start appending after an OPENSEQ Otherthan, a loop to READSEQ until it hits the EOF. Right now, that is not a problem, but this file could grow to some considerable size, and that loop might take a little bit to cycle through. I didn't see any options for the OPENSEQ to start at the EOF, and didn't find any commands that would set the eof (other than WEOFSEQ which doesn't seem likely to help). Thanks George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.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] svn with U2
Gidday Thanks - I'd appreciate that. Maybe it could go up on the U2UG site. S -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Leroy Dreyfuss Sent: Thursday, 25 March 2010 10:30 To: U2 Users List Cc: U2 Users List Subject: Re: [U2] svn with U2 Hi Stuart, Long time no speak. I will put something together on how they are used for you. Cheers, LeRoy Sent from my iPhone 3Gs On 25 Mar 2010, at 12:23 AM, Boydell, Stuart stuart.boyd...@spotless.com.au wrote: Hi Leroy, Just had a quick look. I didn't even know those commands existed (or maybe I did and forgot). Loadfile sounds interesting. Just parsing UVread... $UVread usage: UVread [-q] [-f] [-s] file item ... $UVread -q VOC WHO 'V' 'WHO' 'I' 'G' $UVread -f /pathToOtherAccount/VOC WHO WHO V WHO I G $UVread -s VOC WHO I get the -f (formatted?) -q (quoted?) options -s ? Is there any documentation on these OS calls anywhere? Could someone provide it? Pick Pocket Guide update maybe ;) Cheers, Stuart Boydell -Original Message- You can accomplish a complete solution using the tools UV comes with, i.e. the tools that are used to install configure it, such as loadfile, UVread, UVwrite and so forth. Just determine how the .u files are structure, but take note that they are harder to user if you need to format one with records that are sub-valued. UV doesn't come with an example of how to do it. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users To read FRSTIA's disclaimer for the e-mail go to http://www.frstia.co.za/ ___ 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
