Re: [U2] Unibasic: Sample program - to extract data from Table
Dattatraya, oconv(9611,'d2/') will get you your date. Dattatraya Walgude wrote: But I want following way ( D,C,R are multivalue ) , date output also showing 9611 which is (04/24/94) is it possible? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unibasic: Sample program - to extract data from Table
Many Thanks George Now output is giving following way Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D C R,7,6 Frobisher, Kamal,P.O. Box 9845 ,Denver,CO,80209-,3037780880,,,K O,33,204 But I want following way ( D,C,R are multivalue ) , date output also showing 9611 which is (04/24/94) is it possible? Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,6 Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,C,7,6 Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,R,7,6 Thanks & Regards, Dattatraya Walgude -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, October 15, 2009 6:54 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Try first starting with: LINE = '' : CHANGE(CHANGE(REC,@AM,','),@VM,CHAR(10)) : ',':ID I think that the LF character might give you want you want George > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude > Sent: Thursday, October 15, 2009 1:59 AM > To: U2 Users List > Subject: Re: [U2] Unibasic: Sample program - to extract data from Table > > Sorry Symeon and all for asking such silly question. > > I manage @ID column in output.csv in following way, now I want > multivalue columns in new lines with all columns (now its comes in one > row/line) > > LINE = '' : CHANGE(CHANGE(REC,@AM,','),@VM,',') : ',':ID > > > Thanks & Regards, > Dattatraya Walgude > DBA Team ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Disclaimer * This mail, including any attachments contains confidential and privileged information for the sole use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and are unlawful. This e-mail may contain viruses. R Systems International Limited has taken every reasonable precaution to minimize this risk. R Systems International Limited is not liable for any damage you may sustain as a result of any virus in this e-mail. Before opening the e-mail or attachment, You should carry out your own virus checks. R Systems International Limited reserves the right to record, monitor, and inspect all email communications through its internal and external networks. R Systems International Ltd prohibits its information systems from being used to view, store or forward offensive or discriminatory material. End of Disclaimer ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Agile and Scrum
Hi David, The rollback can be pretty easy if you have a virtual environment for the database testing ... Great story! Ross Ferris Stamina Software Visage > Better by Design! >-Original Message- >From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- >boun...@listserver.u2ug.org] On Behalf Of David A Barrett >Sent: Friday, 16 October 2009 7:01 AM >To: u2-users@listserver.u2ug.org >Subject: [U2] Agile and Scrum > >There are some Agile concepts that are a little tough to implement in an >MV environment. Test Driven Development, for instance, is tough because >you need an automated testing tool, and most MV programs constantly >update >the database, which means you need to roll back your database in order >to >reuse the test cases. All of which is tough. > > > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Agile and Scrum
Good job and thank you for writing that up. I've been trying on the scrum front, after having some past project successes with various agile techniques, but I do not feel like I'm particularly successful on the Scrum front. We have our "tickets" for requirements (user stories) and tasks in Trac, so we attempted to get http://www.ohloh.net/p/agilo-scrum installed, to no avail. I am now attempting to use scrumy.com, which I like but it has no cross-reference to trac so that dual entry doesn't quite work for us and we haven't yet gotten into the swing of it. Of course the tools do not make Scrum, but it is difficult to do Scrum without at least a burn-down report. Additionally, there are a few best practices we do not have, such as all developers being remote (each typically being many states away from the next) and most work just a few sweat-equity hours each week on the project. I asked for suggestions on an agile list a while back and they suggested going to a weekly sprint, which I have tried a few times. The good news is that even with the few techniques we are using from Scrum, such as switching from a daily to a weekly Scrum meeting, and from having a "stand up meeting" to a skype conference call, but asking the same Scrum questions, we continue to move forward, even if at a very slow pace. We are not standing still, spinning or digging a hole as software projects can sometimes do. We are simply failing to use some of the key aspects of Scrum and failing to move fast, things I suspect might be related. I "feel like" I could do better, so any suggestions, given our constraints (no one co-located and no one getting paid, for example) would be much appreciated. Thanks. --dawn On Thu, Oct 15, 2009 at 3:01 PM, David A Barrett wrote: > As a Scrum practitioner in an MV environment for the past 5 years or so, I > think I can shed some light on this. First, the "Agile Manifesto": > >>We are uncovering better ways of developing >>software by doing it and helping others do it. >>Through this work we have come to value: >> >>Individuals and interactions over processes and tools >>Working software over comprehensive documentation >>Customer collaboration over contract negotiation >>Responding to change over following a plan >> >>That is, while there is value in the items on >>the right, we value the items on the left more. > > The basic idea behind Scrum is that you divide the work to be done into > little chunks and they are put in a list called the Product Backlog. > Usually each chunk is an individual feature. The customer prioritizes the > Product Backlog, usually in a meeting with the Development Team who supply > some time estimates. Then the Team decides what Backlog items they can > complete in a fixed time period (usually 30 days), called a Sprint. They > commit to completing those items. "Complete" means fully tested, > potentially implementable code. At the end of the Sprint, the Development > Teams shows what they have completed to the customer. Rinse and repeat. > > Once the Sprint has started, the list of PB items chosen cannot be > changed. This is the golden rule. If you need to change it, then cancel > the whole Sprint, deliver nothing, and start a new one. In 5 years, we've > done that once (and it turned out to be a waste of time). It's a big > stick. > > Really important is the idea that the customer sees completed work each > Sprint. This is guaranteed to give them ideas, and let them see where > problems may come up. The result of that is that some things in the > Product Backlog may move up or down in priority, and new items will be > added to the Product Backlog. I am constantly amazed at how poor > non-programmers are at visualizing how unwritten software will work. This > becomes a non-issue in Scrum. > > Any non-trivial bug is simply added to the Product Backlog. We don't > argue about whether or not something is a bug, a new feature, a change in > scope or mission from God any more. If it is going to take the > Development Team's time, then it goes in the Backlog and the customer can > assign a priority to it. End of discussion. > > In my opinion, it's a risk free approach to at least try on a project. > Worst case scenario, you waste some time working on the stuff the customer > thinks is the most important. > > There's no reason why you need to ditch documentation. Just make it part > of the definition of "complete". > > There are two major adjustments that programmers need to make. The first > just happens by itself: The programmers realize they don't "own" the > software. I can't remember the last time that we had a fight with the > users over how the software should work, or what it should look like or > whatever. If they're wrong, they'll see it in 30 days and they'll have to > commit more of the development time to fixing it, but they won't be able > to point fingers at the Team. We just build what they ask for. > > The second is that the programme
Re: [U2] Agile and Scrum
Agreed. An excellent post. And at 769 words, it's half an article. (Hint, hint.) David, if you (or anyone else reading this thread) would like to contribute an article to Spectrum magazine on this or related topics, please contact me. You can reach me at my "part-time" address, edi...@intl-spectrum.com, or at my regular address or phone number in the sig block below. An Agile Anecdote: I was going to try a simple form of XP (Extreme Programming) on a project several years ago. The client loved the idea and agreed to it with few reservations. I knew they just didn't "get it" when the next meeting they asked me to provide them with a Gantt chart showing the iteration milestones and what features would be in each iteration. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Oct 15, 2009, at 1:36 PM, Boydell, Stuart wrote: Good post! Stuart Boydell -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org ] On Behalf Of David A Barrett Sent: Friday, 16 October 2009 07:01 To: u2-users@listserver.u2ug.org Subject: [U2] Agile and Scrum As a Scrum practitioner in an MV environment for the past 5 years or so, I think I can shed some light on this. First, the "Agile Manifesto": ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Agile and Scrum
Good post! Stuart Boydell -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A Barrett Sent: Friday, 16 October 2009 07:01 To: u2-users@listserver.u2ug.org Subject: [U2] Agile and Scrum As a Scrum practitioner in an MV environment for the past 5 years or so, I think I can shed some light on this. First, the "Agile Manifesto": >We are uncovering better ways of developing >software by doing it and helping others do it. >Through this work we have come to value: > >Individuals and interactions over processes and tools >Working software over comprehensive documentation >Customer collaboration over contract negotiation >Responding to change over following a plan > >That is, while there is value in the items on >the right, we value the items on the left more. The basic idea behind Scrum is that you divide the work to be done into little chunks and they are put in a list called the Product Backlog. Usually each chunk is an individual feature. The customer prioritizes the Product Backlog, usually in a meeting with the Development Team who supply some time estimates. Then the Team decides what Backlog items they can complete in a fixed time period (usually 30 days), called a Sprint. They commit to completing those items. "Complete" means fully tested, potentially implementable code. At the end of the Sprint, the Development Teams shows what they have completed to the customer. Rinse and repeat. Once the Sprint has started, the list of PB items chosen cannot be changed. This is the golden rule. If you need to change it, then cancel the whole Sprint, deliver nothing, and start a new one. In 5 years, we've done that once (and it turned out to be a waste of time). It's a big stick. Really important is the idea that the customer sees completed work each Sprint. This is guaranteed to give them ideas, and let them see where problems may come up. The result of that is that some things in the Product Backlog may move up or down in priority, and new items will be added to the Product Backlog. I am constantly amazed at how poor non-programmers are at visualizing how unwritten software will work. This becomes a non-issue in Scrum. Any non-trivial bug is simply added to the Product Backlog. We don't argue about whether or not something is a bug, a new feature, a change in scope or mission from God any more. If it is going to take the Development Team's time, then it goes in the Backlog and the customer can assign a priority to it. End of discussion. In my opinion, it's a risk free approach to at least try on a project. Worst case scenario, you waste some time working on the stuff the customer thinks is the most important. There's no reason why you need to ditch documentation. Just make it part of the definition of "complete". There are two major adjustments that programmers need to make. The first just happens by itself: The programmers realize they don't "own" the software. I can't remember the last time that we had a fight with the users over how the software should work, or what it should look like or whatever. If they're wrong, they'll see it in 30 days and they'll have to commit more of the development time to fixing it, but they won't be able to point fingers at the Team. We just build what they ask for. The second is that the programmers need to adopt a "just good enough" approach to programming. There's no value in making the code you write bigger than you need it to be, or to build in features that no one has asked for. Write the bare minimum to do the job required and nothing more. This doesn't mean writing crappy code or painting yourself into a corner, but don't go peaking down the project plan building in stuff you haven't got to yet. There's always a chance that you'll never get to that future feature. Our experience is that we've been able to open up a firehose of new functionality on the users with a small team and without building up a massive maintenance burden. There have been a few occasions when we've actually put a project on hold because the customer needs time to digest what we've done, revamp procedures, train personnel and re-evaluate future development priorities. How cool is that?!!! There are some Agile concepts that are a little tough to implement in an MV environment. Test Driven Development, for instance, is tough because you need an automated testing tool, and most MV programs constantly update the database, which means you need to roll back your database in order to reuse the test cases. All of which is tough. Dave Barrett Project Manager, Lawyers' Professional Indemnity Company (LAWPRO®) This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an inte
[U2] Agile and Scrum
As a Scrum practitioner in an MV environment for the past 5 years or so, I think I can shed some light on this. First, the "Agile Manifesto": >We are uncovering better ways of developing >software by doing it and helping others do it. >Through this work we have come to value: > >Individuals and interactions over processes and tools >Working software over comprehensive documentation >Customer collaboration over contract negotiation >Responding to change over following a plan > >That is, while there is value in the items on >the right, we value the items on the left more. The basic idea behind Scrum is that you divide the work to be done into little chunks and they are put in a list called the Product Backlog. Usually each chunk is an individual feature. The customer prioritizes the Product Backlog, usually in a meeting with the Development Team who supply some time estimates. Then the Team decides what Backlog items they can complete in a fixed time period (usually 30 days), called a Sprint. They commit to completing those items. "Complete" means fully tested, potentially implementable code. At the end of the Sprint, the Development Teams shows what they have completed to the customer. Rinse and repeat. Once the Sprint has started, the list of PB items chosen cannot be changed. This is the golden rule. If you need to change it, then cancel the whole Sprint, deliver nothing, and start a new one. In 5 years, we've done that once (and it turned out to be a waste of time). It's a big stick. Really important is the idea that the customer sees completed work each Sprint. This is guaranteed to give them ideas, and let them see where problems may come up. The result of that is that some things in the Product Backlog may move up or down in priority, and new items will be added to the Product Backlog. I am constantly amazed at how poor non-programmers are at visualizing how unwritten software will work. This becomes a non-issue in Scrum. Any non-trivial bug is simply added to the Product Backlog. We don't argue about whether or not something is a bug, a new feature, a change in scope or mission from God any more. If it is going to take the Development Team's time, then it goes in the Backlog and the customer can assign a priority to it. End of discussion. In my opinion, it's a risk free approach to at least try on a project. Worst case scenario, you waste some time working on the stuff the customer thinks is the most important. There's no reason why you need to ditch documentation. Just make it part of the definition of "complete". There are two major adjustments that programmers need to make. The first just happens by itself: The programmers realize they don't "own" the software. I can't remember the last time that we had a fight with the users over how the software should work, or what it should look like or whatever. If they're wrong, they'll see it in 30 days and they'll have to commit more of the development time to fixing it, but they won't be able to point fingers at the Team. We just build what they ask for. The second is that the programmers need to adopt a "just good enough" approach to programming. There's no value in making the code you write bigger than you need it to be, or to build in features that no one has asked for. Write the bare minimum to do the job required and nothing more. This doesn't mean writing crappy code or painting yourself into a corner, but don't go peaking down the project plan building in stuff you haven't got to yet. There's always a chance that you'll never get to that future feature. Our experience is that we've been able to open up a firehose of new functionality on the users with a small team and without building up a massive maintenance burden. There have been a few occasions when we've actually put a project on hold because the customer needs time to digest what we've done, revamp procedures, train personnel and re-evaluate future development priorities. How cool is that?!!! There are some Agile concepts that are a little tough to implement in an MV environment. Test Driven Development, for instance, is tough because you need an automated testing tool, and most MV programs constantly update the database, which means you need to roll back your database in order to reuse the test cases. All of which is tough. Dave Barrett Project Manager, Lawyers' Professional Indemnity Company (LAWPRO®) This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please delete it and advise me (by return e-mail or otherwise) immediately. Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapporte
Re: [U2] Unibasic: Sample Program
Agile? The thing about Agile is mimics the real world. It supposed to allows flexibility in the design process and attach a business value to what's going on. That's what really what happens in practicality. I think it all depends on what being developed, as well. Creating an ERP System from the ground up requires a different kind of skill sets and environment than writing reports to meet end-user-requirements. The more I read on it the more it seems to be getting codified and stricter, which in itself is a paradox, because, as I understand it, Agile is supposed to be what its name means: agile or flexible. Rather than being a strict methodology, Agile should me more of a philosophy. It's the way most U2 shops work, that I've been in. However, it is becoming, itself, more strict from what I read. Ironic! Agile is a reaction to the top-down-hierarchical approach to IT, where the programmers are simply supposed to be "cogs in a wheel", rather than integral to the design and development process. The extreme top-down-hierarchical approach failed in the 70's at XEROX... a famous business case... - Original Message - From: "Susan Lynch" To: "U2 Users List" Sent: Wednesday, October 14, 2009 5:34:31 PM GMT -05:00 US/Canada Eastern Subject: Re: [U2] Unibasic: Sample Program Brenda, I did check it out, and it is interesting, but I still wonder if 3 years later, when the business requirements change, if anyone from the original team will a) be there, and b) remember all the intricacies of the design decisions made, and c) be part of the new team to modify the original stuff. Of course, the 'agile' concept does have a 'design' phase, which to me would mean developing the spec from the user's requests, which I write and save so that 3 years later, when I get called back and asked how to change something, I can hit the ground running rather than reading all the code again. I look forward to hearing back from you in a few years on how well this works in the real world! Susan Lynch - Original Message - From: "Brenda Price" To: "U2 Users List" Sent: 10/14/2009 3:28 PM Subject: Re: [U2] Unibasic: Sample Program > Well, when our company gets this fully implemented. You can count over > 250 Highlander's Immortals on the list! > > Seriously, check out "agile" and "scrum", it is interesting. > > Brenda L Price > UniVerse Programmer > Rapid Response Team > Market America, Inc. > Greensboro, NC > > >> -Original Message- >> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- >> boun...@listserver.u2ug.org] On Behalf Of Susan Lynch >> Sent: Wednesday, October 14, 2009 3:26 PM >> To: U2 Users List >> Subject: Re: [U2] Unibasic: Sample Program >> >> Ah, it must be lovely to know that you will live forever and will > never >> become ill or incapable of working... Eventually, if the company does >> not >> go out of business, or their business needs change so much that all >> your >> code is obsolete, somebody else will have to figure out how the system >> works. >> >> A good spec turns into good documentation, which (properly maintained >> through all the ensuing changes to the system for the changing needs > of >> the >> users, of course) is a blessing to the person who follows you. >> >> Sounds like we have at least 2 of Highlander's Immortals on the list! >> ;-) >> >> Susan Lynch >> - Original Message - >> From: "Brutzman, Bill" >> To: "U2 Users List" >> Sent: 10/14/2009 3:20 PM >> Subject: Re: [U2] Unibasic: Sample Program >> >> >> > >> > John's world is similar to my world here. When I realized that I >> would >> > be the only person reading the specs, I stopped writing to myself. >> At >> > the risk of no longer being a professional dinosaur, I learned that >> some >> > people call it "agile". >> > >> > Check out... Eckhart Tolle's book "The Power of Now". >> > >> > --B >> > >> > ___ >> > 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] Unibasic: Sample program - to extract data from Table
Hi. I am getting in on this discussion late. Although the programming on the fly approach is unavoidable to some degree, I am a firm believer in defining specs as much as possible up front. Yogi Berra says: "Be careful if you don't know where you're going. You might not know it when you get there." Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unibasic: Sample program - to extract data from Table
Try first starting with: LINE = '' : CHANGE(CHANGE(REC,@AM,','),@VM,CHAR(10)) : ',':ID I think that the LF character might give you want you want George > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude > Sent: Thursday, October 15, 2009 1:59 AM > To: U2 Users List > Subject: Re: [U2] Unibasic: Sample program - to extract data from Table > > Sorry Symeon and all for asking such silly question. > > I manage @ID column in output.csv in following way, now I want > multivalue columns in new lines with all columns (now its comes in one > row/line) > > LINE = '' : CHANGE(CHANGE(REC,@AM,','),@VM,',') : ',':ID > > > Thanks & Regards, > Dattatraya Walgude > DBA Team ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unibasic: Sample program - to extract data from Table
Thanks Jeff Sure, but right now preparing some basics concepts. Regards, Dattatraya Walgude -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Powell Sent: Thursday, October 15, 2009 5:42 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Dattatraya, Are you interested in getting training in UniData and SBClient? If so there are people (not me) on this list who have online training courses. If you are interested please let us know and I'm sure you'll get some recommendations. Jeff On 10/15/2009 12:59 AM, Dattatraya Walgude wrote: > Sorry Symeon and all for asking such silly question. > > I manage @ID column in output.csv in following way, now I want multivalue > columns in new lines with all columns (now its comes in one row/line) > > LINE = '' : CHANGE(CHANGE(REC,@AM,','),@VM,',') : ',':ID > > > Thanks& Regards, > Dattatraya Walgude > DBA Team > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug > Sent: Tuesday, October 13, 2009 1:12 AM > To: 'U2 Users List' > Subject: Re: [U2] Unibasic: Sample program - to extract data from Table > > This data is obviously from an company that deals with a Colorado data or is > based in Colorado. > And you are from outsource product develop company in India that has been > tasked to work on this U2 system. > > So...We have some programmers that know U2 that need more work... > So...Why are we teaching the competition?... > So...They are probably only charging 10 to 20 per hour... > So...We are charging a lot more per hour which is why we are not doing the > work... > > A discussion for a different time, so maybe my next blog. > > Regards, > Doug > www.u2logic.com > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya > Walgude > Sent: Monday, October 12, 2009 7:24 AM > To: U2 Users List > Subject: Re: [U2] Unibasic: Sample program - to extract data from Table > > Thanks for your support. > > We get output of multivalve columns. > Only things is we can not get out of DATE column is date format. > So please give your suggestions. > > Jones Bob123 E. 23rd St. Arvada CO 80276 3037768854 > V4341 9611D C R 7 > Frobisher Kamal P.O. Box 9845 Denver CO 80209- > 3037780880K O 33 > Steven Spender1212 W. 44thDenver CO 80401 3034457878 > 3 > Jamieson Dale 999 Independence WaySeattle WI 98733 > V6670 96118 > > > One more query > @ID column is missing in output.csv, please suggest how to get that @ID > column in output.csv. > > > Regards > Dattatraya Walgude > > > > > > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya > Walgude > Sent: 12 October 2009 12:58 > To: U2 Users List > Subject: Re: [U2] Unibasic: Sample program - to extract data from Table > > Output is not readable:- > > "14334ýITOý0ýAýý16811","14334ýCHAý CHA to Risk Rate: > Mass_Aýýý16811" > "14369ýITOý0ýAýý61491","14369ýCHAý CHA to Risk Rate: > Ten7_Aýýý61491" > "13977ýITAýýAýý60625" > "15030ýITOý0ýAýý70410","15030ýMEMý1ýPayment Responsibility ChangedýýFrom > To N On 23-02-09ýýAýý70410","15030ýITAýýAýý70410" > "13973ýITAýýAýý38781","13973ýCHAý CHA to Risk Rate: MASS_Aýýý38781" > "15142ýITOý0ýAýý40128","15142ýMEMý1ýPayment Responsibility ChangedýýFrom > To Y On 15-06-09ýýAýý40129" > "14369ýITOý0ýAýý64849","15263ýWKLýDC 040ýQueue 888Aýý47136" > "13910ýWKLýDC 040ýQueue 6AEAýý2898","13910ýSAPý13910ý6RE1ý1ý60+DAY EA > ROUTE 1ýQ6AEýAýý7858","13910ýSUSýFailed ValidationýýýWITH > SIXTYD.ABOVE.AMT.OVRD GE 10.00 ý6RE1ýAýý14692","13911ýAOWýFrom BF01G013ýTo > BF01G162ý6EQ.01ýQUEUE-SPLITTERýýAýý15360","13911ýWKLýDC 040ýQueue > 6EQ.03ýýQUEUE-SPLITTERýýAýý15360","13942ý > WKLýDC 040ýQueue 6AEAýý5421","13942ýSAPý13942ý6RE1ý1ý60+DAY EA ROUTE > 1ýQ6AEýAýý9757","13942ýSUSýFailed ValidationýýýWITH SIXTYD.ABOVE.AMT.OVRD GE > 10.00 ý > > Thanks& Regards, > Dattatraya Walgude > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya > Walgude > Sent: Monday, October 12, 2009 5:02 PM > To: U2 Users List > Subject: Re: [U2] Unibasic: Sample program - to extract data from Table > > Many Many Thanks Edward and Symeon > > Its work... > > Thanks& Regards, > Dattatraya Walgude > > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org]
Re: [U2] Unibasic: Sample program - to extract data from Table
Dattatraya, Are you interested in getting training in UniData and SBClient? If so there are people (not me) on this list who have online training courses. If you are interested please let us know and I'm sure you'll get some recommendations. Jeff On 10/15/2009 12:59 AM, Dattatraya Walgude wrote: Sorry Symeon and all for asking such silly question. I manage @ID column in output.csv in following way, now I want multivalue columns in new lines with all columns (now its comes in one row/line) LINE = '' : CHANGE(CHANGE(REC,@AM,','),@VM,',') : ',':ID Thanks& Regards, Dattatraya Walgude DBA Team -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Tuesday, October 13, 2009 1:12 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table This data is obviously from an company that deals with a Colorado data or is based in Colorado. And you are from outsource product develop company in India that has been tasked to work on this U2 system. So...We have some programmers that know U2 that need more work... So...Why are we teaching the competition?... So...They are probably only charging 10 to 20 per hour... So...We are charging a lot more per hour which is why we are not doing the work... A discussion for a different time, so maybe my next blog. Regards, Doug www.u2logic.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude Sent: Monday, October 12, 2009 7:24 AM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Thanks for your support. We get output of multivalve columns. Only things is we can not get out of DATE column is date format. So please give your suggestions. JonesBob123 E. 23rd St. Arvada CO 80276 3037768854 V4341 9611D C R 7 FrobisherKamal P.O. Box 9845 Denver CO 80209- 3037780880 K O 33 Steven Spender 1212 W. 44thDenver CO 80401 3034457878 3 Jamieson Dale 999 Independence WaySeattle WI 98733 V6670 96118 One more query @ID column is missing in output.csv, please suggest how to get that @ID column in output.csv. Regards Dattatraya Walgude -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude Sent: 12 October 2009 12:58 To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Output is not readable:- "14334ýITOý0ýAýý16811","14334ýCHAý CHA to Risk Rate: Mass_Aýýý16811" "14369ýITOý0ýAýý61491","14369ýCHAý CHA to Risk Rate: Ten7_Aýýý61491" "13977ýITAýýAýý60625" "15030ýITOý0ýAýý70410","15030ýMEMý1ýPayment Responsibility ChangedýýFrom To N On 23-02-09ýýAýý70410","15030ýITAýýAýý70410" "13973ýITAýýAýý38781","13973ýCHAý CHA to Risk Rate: MASS_Aýýý38781" "15142ýITOý0ýAýý40128","15142ýMEMý1ýPayment Responsibility ChangedýýFrom To Y On 15-06-09ýýAýý40129" "14369ýITOý0ýAýý64849","15263ýWKLýDC 040ýQueue 888Aýý47136" "13910ýWKLýDC 040ýQueue 6AEAýý2898","13910ýSAPý13910ý6RE1ý1ý60+DAY EA ROUTE 1ýQ6AEýAýý7858","13910ýSUSýFailed ValidationýýýWITH SIXTYD.ABOVE.AMT.OVRD GE 10.00 ý6RE1ýAýý14692","13911ýAOWýFrom BF01G013ýTo BF01G162ý6EQ.01ýQUEUE-SPLITTERýýAýý15360","13911ýWKLýDC 040ýQueue 6EQ.03ýýQUEUE-SPLITTERýýAýý15360","13942ý WKLýDC 040ýQueue 6AEAýý5421","13942ýSAPý13942ý6RE1ý1ý60+DAY EA ROUTE 1ýQ6AEýAýý9757","13942ýSUSýFailed ValidationýýýWITH SIXTYD.ABOVE.AMT.OVRD GE 10.00 ý Thanks& Regards, Dattatraya Walgude -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude Sent: Monday, October 12, 2009 5:02 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Many Many Thanks Edward and Symeon Its work... Thanks& Regards, Dattatraya Walgude -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Monday, October 12, 2009 4:55 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table ELSE NULL Will work. Syntax for all these commands is in BASR.PDF, downloadable from web for free... Edward -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude Sent: 12 October 2009 12:22 To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Thanks Symeon I have created one program file (outfile ) wit
Re: [U2] Unibasic: Sample Program
All, Clif Oliver has said that he'd love a good article on Agile and how it applies to MV for an upcoming Spectrum issue. I think the title he had floated past us was "MV: Agile for 30 Years" - Chuck ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unibasic: Sample Program
RUP, and others are also iterative and iterative is very important - especially if we are talking multi million dollar projects. Also important for such deals is definition of scope at the very start, 10% scope creep comes in at around a million dollars - i haven't got that in my back pocket... Agile does allow such definition but it is harder as teams often think it means they can just forget about a certain aspect till the time comes and this is not what it is all about As with anything you can have the best widget in the world, but if you do not use it properly it is flawed. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: 14 October 2009 23:05 To: U2 Users List Subject: Re: [U2] Unibasic: Sample Program Agile and Scrum (basically agile 30 days sprint cycles) doesn't mean the system does not get documented. It just means a more iterative process with decisions being made later in the cycle. "Welcoming the change request" does not mean that the change doesn't get documented. It means the documents change with the times. If maintained properly, the docs should be more likely to be correct. For many of us, we have external forces such as accrediting agencies that require us to maintain such documentation. BTW, if you haven't seen it before there's a product called OnTime from http://www.axosoft.com/ that works well in an agile shop. Check out the Scrum in 10 minutes video ... Robert Robert F. Porter, MCSE, CCNA, ZCE Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. >>> "Susan Lynch" 10/14/2009 4:34 PM >>> Brenda, I did check it out, and it is interesting, but I still wonder if 3 years later, when the business requirements change, if anyone from the original team will a) be there, and b) remember all the intricacies of the design decisions made, and c) be part of the new team to modify the original stuff. Of course, the 'agile' concept does have a 'design' phase, which to me would mean developing the spec from the user's requests, which I write and save so that 3 years later, when I get called back and asked how to change something, I can hit the ground running rather than reading all the code again. I look forward to hearing back from you in a few years on how well this works in the real world! Susan Lynch - Original Message - From: "Brenda Price" To: "U2 Users List" Sent: 10/14/2009 3:28 PM Subject: Re: [U2] Unibasic: Sample Program > Well, when our company gets this fully implemented. You can count over > 250 Highlander's Immortals on the list! > > Seriously, check out "agile" and "scrum", it is interesting. > > Brenda L Price > UniVerse Programmer > Rapid Response Team > Market America, Inc. > Greensboro, NC > > >> -Original Message- >> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- >> boun...@listserver.u2ug.org] On Behalf Of Susan Lynch >> Sent: Wednesday, October 14, 2009 3:26 PM >> To: U2 Users List >> Subject: Re: [U2] Unibasic: Sample Program >> >> Ah, it must be lovely to know that you will live forever and will > never >> become ill or incapable of working... Eventually, if the company does >> not >> go out of business, or their business needs change so much that all >> your >> code is obsolete, somebody else will have to figure out how the system >> works. >> >> A good spec turns into good documentation, which (properly maintained >> through all the ensuing changes to the system for the changing needs > of >> the >> users, of course) is a blessing to the person who follows you. >> >> Sounds like we have at least 2 of Highlander's Immortals on the list! >> ;-) >> >> Susan Lynch >> - Original Message - >> From: "Brutzman, Bill" >> To: "U2 Users List" >> Sent: 10/14/2009 3:20 PM >> Subject: Re: [U2] Unibasic: Sample Program >> >> >> > >> > John's world is similar to my world here. When I realized that I >> would >> > be the only person reading the specs, I stopped writing to myself. >> At >> > the risk of no longer being a professional dinosaur, I learned that >> some >> > people call it "agile". >> > >> > Check out... Eckhart Tolle's book "The Power of Now". >> > >> > --B >> > >> > ___ >> > U2-Users mailing list >> > U2-Users@listserver.u2ug.org >> > http://lists
Re: [U2] Unibasic: Sample program - to extract data from Table
I dont know what your background is - i presume you are a programmer - so just think of the MV fields as arrays - so you need to get the number of values in the arrays - see what the biggest one is - loop that many times and repeat the line for each MV just placing that MV's value in there To get the number of values in an array use COUNT or perhaps DCOUNT To extract just a single value from an array use REC e.g. REC<4,5> to get value 5 from attribute 4 To loop use FOR i = 1 TO max NEXT i You should be able to do this now. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude Sent: 15 October 2009 06:59 To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Sorry Symeon and all for asking such silly question. I manage @ID column in output.csv in following way, now I want multivalue columns in new lines with all columns (now its comes in one row/line) LINE = '' : CHANGE(CHANGE(REC,@AM,','),@VM,',') : ',':ID Thanks & Regards, Dattatraya Walgude DBA Team -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Tuesday, October 13, 2009 1:12 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table This data is obviously from an company that deals with a Colorado data or is based in Colorado. And you are from outsource product develop company in India that has been tasked to work on this U2 system. So...We have some programmers that know U2 that need more work... So...Why are we teaching the competition?... So...They are probably only charging 10 to 20 per hour... So...We are charging a lot more per hour which is why we are not doing the work... A discussion for a different time, so maybe my next blog. Regards, Doug www.u2logic.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude Sent: Monday, October 12, 2009 7:24 AM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Thanks for your support. We get output of multivalve columns. Only things is we can not get out of DATE column is date format. So please give your suggestions. JonesBob123 E. 23rd St. Arvada CO 80276 3037768854 V4341 9611D C R 7 FrobisherKamal P.O. Box 9845 Denver CO 80209- 3037780880 K O 33 Steven Spender 1212 W. 44thDenver CO 80401 3034457878 3 Jamieson Dale 999 Independence WaySeattle WI 98733 V6670 96118 One more query @ID column is missing in output.csv, please suggest how to get that @ID column in output.csv. Regards Dattatraya Walgude -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude Sent: 12 October 2009 12:58 To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Output is not readable:- "14334ýITOý0ýAýý16811","14334ýCHAý CHA to Risk Rate: Mass_Aýýý16811" "14369ýITOý0ýAýý61491","14369ýCHAý CHA to Risk Rate: Ten7_Aýýý61491" "13977ýITAýýAýý60625" "15030ýITOý0ýAýý70410","15030ýMEMý1ýPayment Responsibility ChangedýýFrom To N On 23-02-09ýýAýý70410","15030ýITAýýAýý70410" "13973ýITAýýAýý38781","13973ýCHAý CHA to Risk Rate: MASS_Aýýý38781" "15142ýITOý0ýAýý40128","15142ýMEMý1ýPayment Responsibility ChangedýýFrom To Y On 15-06-09ýýAýý40129" "14369ýITOý0ýAýý64849","15263ýWKLýDC 040ýQueue 888Aýý47136" "13910ýWKLýDC 040ýQueue 6AEAýý2898","13910ýSAPý13910ý6RE1ý1ý60+DAY EA ROUTE 1ýQ6AEýAýý7858","13910ýSUSýFailed ValidationýýýWITH SIXTYD.ABOVE.AMT.OVRD GE 10.00 ý6RE1ýAýý14692","13911ýAOWýFrom BF01G013ýTo BF01G162ý6EQ.01ýQUEUE-SPLITTERýýAýý15360","13911ýWKLýDC 040ýQueue 6EQ.03ýýQUEUE-SPLITTERýýAýý15360","13942ý WKLýDC 040ýQueue 6AEAýý5421","13942ýSAPý13942ý6RE1ý1ý60+DAY EA ROUTE 1ýQ6AEýAýý9757","13942ýSUSýFailed ValidationýýýWITH SIXTYD.ABOVE.AMT.OVRD GE 10.00 ý Thanks & Regards, Dattatraya Walgude -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude Sent: Monday, October 12, 2009 5:02 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Many Many Thanks Edward and Symeon Its work... Thanks & Regards, Dattatraya Walgude -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Monday, October 12, 2009 4:55 PM To: U2 Users List Subject: Re: [