Re: [U2] Unibasic: Sample program - to extract data from Table
Dattatraya - in unibasic almost any string handling task is possible! Hmm - funny how the original topic of this thread and the subsequent discussion of specifications, or lack of, seems to have come full circle. Starting with REC - as read from disk. Presume REC has one or more multivalued fields. REC is to be written to the output file multiple times, subsequent lines taking the 1st, 2nd etc multivalue where the attribute is multivalued and taking the entire attribute otherwise. * Count how many multivalues are in each attribute MV.COUNT = NUM.ATTRS = DCOUNT(REC,@AM) FOR A = 1 TO NUM.ATTRS MV.COUNT1,A = DCOUNT(RECA,@VM) NEXT A * And find the highest number MAX.MVS = MAXIMUM(MV.COUNT) * Convert specific attributes to date format. * Note the OCONVS handles multivalued data - it converts each value separately. REC9 = OCONVS(REC9,D2/) * Now output a line for each multivalue FOR A = 1 TO MAX.MVS OUT.LINE = FOR B = 1 TO NUM.ATTRS IF MV.COUNT1,A EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B = RECB,A NEXT B WRITESEQ OUT.LINE ... NEXT A OUT.LINE = CHANGE(OUT.LINE,@VM,,) * Hope this helps - I've not compiled it so it might need a bit of tweaking to get it working. Ed -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude Sent: 16 October 2009 05:20 To: U2 Users List Subject: 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 --- Please remember to recycle wherever possible. Reduce, reuse, recycle, think do you need to print this e-mail? --- This e-mail and any attachment(s), is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the addressee
Re: [U2] Unibasic: Sample program - to extract data from Table
Yes, and I've just spotted the first mistake - the last line should have been a couple of lines higher... * Count how many multivalues are in each attribute MV.COUNT = NUM.ATTRS = DCOUNT(REC,@AM) FOR A = 1 TO NUM.ATTRS MV.COUNT1,A = DCOUNT(RECA,@VM) NEXT A * And find the highest number MAX.MVS = MAXIMUM(MV.COUNT) * Convert specific attributes to date format. * Note the OCONVS handles multivalued data - it converts each value separately. REC9 = OCONVS(REC9,D2/) * Now output a line for each multivalue FOR A = 1 TO MAX.MVS OUT.LINE = FOR B = 1 TO NUM.ATTRS IF MV.COUNT1,A EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B = RECB,A NEXT B * Turn multivalues in the output line to commas OUT.LINE = CHANGE(OUT.LINE,@VM,,) * And write the line to the output file WRITESEQ OUT.LINE ... NEXT A * -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: 16 October 2009 08:06 To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Dattatraya - in unibasic almost any string handling task is possible! Hmm - funny how the original topic of this thread and the subsequent discussion of specifications, or lack of, seems to have come full circle. Starting with REC - as read from disk. Presume REC has one or more multivalued fields. REC is to be written to the output file multiple times, subsequent lines taking the 1st, 2nd etc multivalue where the attribute is multivalued and taking the entire attribute otherwise. * Count how many multivalues are in each attribute MV.COUNT = NUM.ATTRS = DCOUNT(REC,@AM) FOR A = 1 TO NUM.ATTRS MV.COUNT1,A = DCOUNT(RECA,@VM) NEXT A * And find the highest number MAX.MVS = MAXIMUM(MV.COUNT) * Convert specific attributes to date format. * Note the OCONVS handles multivalued data - it converts each value separately. REC9 = OCONVS(REC9,D2/) * Now output a line for each multivalue FOR A = 1 TO MAX.MVS OUT.LINE = FOR B = 1 TO NUM.ATTRS IF MV.COUNT1,A EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B = RECB,A NEXT B WRITESEQ OUT.LINE ... NEXT A OUT.LINE = CHANGE(OUT.LINE,@VM,,) * Hope this helps - I've not compiled it so it might need a bit of tweaking to get it working. Ed -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude Sent: 16 October 2009 05:20 To: U2 Users List Subject: 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
Re: [U2] Unibasic: Sample program - to extract data from Table
Dattatraya if you are a programmer you should be able to do this - i would use the same technique in .net, java or databasic. The only difference is the way you get the information out of the arrays in the first place. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude Sent: 16 October 2009 05:20 To: U2 Users List Subject: 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 ___ 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 all of you Now final code is: ==start code OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER' OPENSEQ 'OUTPUT.CSV' TO CSVFIL ELSE NULL WEOFSEQ CSVFIL SELECT FIL LOOP WHILE READNEXT ID DO READ REC FROM FIL,ID THEN * Count how many multivalues are in each attribute MV.COUNT = NUM.ATTRS = DCOUNT(REC,@AM) FOR A = 1 TO NUM.ATTRS MV.COUNT1,A = DCOUNT(RECA,@VM) NEXT A * And find the highest number MAX.MVS = MAXIMUM(MV.COUNT) * Convert specific attributes to date format. * Note the OCONVS handles multivalued data - it converts each value separately. REC9 = OCONVS(REC9,D2/) * Now output a line for each multivalue FOR A = 1 TO MAX.MVS OUT.LINE = FOR B = 1 TO NUM.ATTRS IF MV.COUNT1,A EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B = RECB,A NEXT B * Turn multivalues in the output line to commas *OUT.LINE = CHANGE(OUT.LINE,@VM,,) OUT.LINE = '' : CHANGE(CHANGE(OUT.LINE,@AM,','),@VM,',') : ',':ID * And write the line to the output file WRITESEQ OUT.LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE' * WRITESEQ OUT.LINE ... NEXT A END REPEAT ==End code :BASIC BP outfile Compiling Unibasic: BP/outfile in mode 'u'. compilation finished :RUN BP outfile In BP/_outfile at line 10 WARNING: UNINITIALIZED VARIABLE USED! Zero ssumed! : And output is :- ( Missing C,R in multivalve, date also not converted) Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6 Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6 Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6 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: Friday, October 16, 2009 12:39 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Yes, and I've just spotted the first mistake - the last line should have been a couple of lines higher... * Count how many multivalues are in each attribute MV.COUNT = NUM.ATTRS = DCOUNT(REC,@AM) FOR A = 1 TO NUM.ATTRS MV.COUNT1,A = DCOUNT(RECA,@VM) NEXT A * And find the highest number MAX.MVS = MAXIMUM(MV.COUNT) * Convert specific attributes to date format. * Note the OCONVS handles multivalued data - it converts each value separately. REC9 = OCONVS(REC9,D2/) * Now output a line for each multivalue FOR A = 1 TO MAX.MVS OUT.LINE = FOR B = 1 TO NUM.ATTRS IF MV.COUNT1,A EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B = RECB,A NEXT B * Turn multivalues in the output line to commas OUT.LINE = CHANGE(OUT.LINE,@VM,,) * And write the line to the output file WRITESEQ OUT.LINE ... NEXT A * -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: 16 October 2009 08:06 To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Dattatraya - in unibasic almost any string handling task is possible! Hmm - funny how the original topic of this thread and the subsequent discussion of specifications, or lack of, seems to have come full circle. Starting with REC - as read from disk. Presume REC has one or more multivalued fields. REC is to be written to the output file multiple times, subsequent lines taking the 1st, 2nd etc multivalue where the attribute is multivalued and taking the entire attribute otherwise. * Count how many multivalues are in each attribute MV.COUNT = NUM.ATTRS = DCOUNT(REC,@AM) FOR A = 1 TO NUM.ATTRS MV.COUNT1,A = DCOUNT(RECA,@VM) NEXT A * And find the highest number MAX.MVS = MAXIMUM(MV.COUNT) * Convert specific attributes to date format. * Note the OCONVS handles multivalued data - it converts each value separately. REC9 = OCONVS(REC9,D2/) * Now output a line for each multivalue FOR A = 1 TO MAX.MVS OUT.LINE = FOR B = 1 TO NUM.ATTRS IF MV.COUNT1,A EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B = RECB,A NEXT B WRITESEQ OUT.LINE ... NEXT A OUT.LINE = CHANGE(OUT.LINE,@VM,,) * Hope this helps - I've not compiled it so it might need a bit of tweaking to get it working. Ed -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude Sent: 16 October 2009 05:20 To: U2 Users List Subject: 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
Re: [U2] Unibasic: Sample program - to extract data from Table
Thanks Ed, Will debug code, as you asked. Thanks Regards, Dattatraya Walgude DBA Team Rsystems International Ltd, Pune, ( : +91-20-22909212 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Friday, October 16, 2009 3:29 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Dattatraya, (Possible) correction added. You really need to take the time to understand the example code we're giving you. There will still be problems in the code below - for example, I can't see why the date conversion is failing or why (despite the uninit var) the C and R are missing. Really at this point you are in the best position to debug the program as you have the source data, which I'm having to guess the format of. Debugging - there's a proper debugger built into unidata but for quick and dirty checking, use CRT variable to display the contents of a variable to screen, and INPUT X,1 to have the program wait until you press a key - useful if you're displaying a lot of values and want to add a pause - for example after each record has been processed. Ed OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER' OPENSEQ 'OUTPUT.CSV' TO CSVFIL ELSE NULL WEOFSEQ CSVFIL SELECT FIL LOOP WHILE READNEXT ID DO READ REC FROM FIL,ID THEN * Count how many multivalues are in each attribute MV.COUNT = NUM.ATTRS = DCOUNT(REC,@AM) MV.COUNT = FOR A = 1 TO NUM.ATTRS MV.COUNT1,A = DCOUNT(RECA,@VM) NEXT A * And find the highest number MAX.MVS = MAXIMUM(MV.COUNT) * Convert specific attributes to date format. * Note the OCONVS handles multivalued data - it converts each value separately. REC9 = OCONVS(REC9,D2/) * Now output a line for each multivalue FOR A = 1 TO MAX.MVS OUT.LINE = FOR B = 1 TO NUM.ATTRS IF MV.COUNT1,A EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B = RECB,A NEXT B * Turn multivalues in the output line to commas *OUT.LINE = CHANGE(OUT.LINE,@VM,,) OUT.LINE = '' : CHANGE(CHANGE(OUT.LINE,@AM,','),@VM,',') : ',':ID * And write the line to the output file WRITESEQ OUT.LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE' * WRITESEQ OUT.LINE ... NEXT A END REPEAT ==End code :BASIC BP outfile Compiling Unibasic: BP/outfile in mode 'u'. compilation finished :RUN BP outfile In BP/_outfile at line 10 WARNING: UNINITIALIZED VARIABLE USED! Zero ssumed! : And output is :- ( Missing C,R in multivalve, date also not converted) Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6 Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6 Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6 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: Friday, October 16, 2009 12:39 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Yes, and I've just spotted the first mistake - the last line should have been a couple of lines higher... * Count how many multivalues are in each attribute MV.COUNT = NUM.ATTRS = DCOUNT(REC,@AM) FOR A = 1 TO NUM.ATTRS MV.COUNT1,A = DCOUNT(RECA,@VM) NEXT A * And find the highest number MAX.MVS = MAXIMUM(MV.COUNT) * Convert specific attributes to date format. * Note the OCONVS handles multivalued data - it converts each value separately. REC9 = OCONVS(REC9,D2/) * Now output a line for each multivalue FOR A = 1 TO MAX.MVS OUT.LINE = FOR B = 1 TO NUM.ATTRS IF MV.COUNT1,A EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B = RECB,A NEXT B * Turn multivalues in the output line to commas OUT.LINE = CHANGE(OUT.LINE,@VM,,) * And write the line to the output file WRITESEQ OUT.LINE ... NEXT A * -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: 16 October 2009 08:06 To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Dattatraya - in unibasic almost any string handling task is possible! Hmm - funny how the original topic of this thread and the subsequent discussion of specifications, or lack of, seems to have come full circle. Starting with REC - as read from disk. Presume REC has one or more multivalued fields. REC is to be written to the output file multiple times, subsequent lines taking the 1st, 2nd etc multivalue where the attribute is multivalued and taking the entire attribute otherwise. * Count how many multivalues are in each attribute MV.COUNT = NUM.ATTRS = DCOUNT(REC,@AM) FOR A = 1 TO NUM.ATTRS MV.COUNT1,A = DCOUNT(RECA,@VM) NEXT A * And find the highest number MAX.MVS = MAXIMUM(MV.COUNT) * Convert specific attributes to date format. * Note the OCONVS handles multivalued data - it converts each value separately. REC9 = OCONVS(REC9,D2/) * Now output a line
Re: [U2] Unibasic: Sample program - to extract data from Table
Now Date is converted, but multivalue ( C , R ) still missing. ,Jones, Bob,123 E. 23rdst.,Arvada,CO,80276,3037768854,V4341,04/24/94,D,7,R,6 ,Jones, Bob,123 E. 23rdSt.,Arvada,CO,80276,3037768854,V4341,04/24/94,D,7,R,6 ,Jones, Bob,123 E. 23rdSt.,Arvada,CO,80276,3037768854,V4341,04/24/94,D,7,R,6 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: Friday, October 16, 2009 3:29 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Dattatraya, (Possible) correction added. You really need to take the time to understand the example code we're giving you. There will still be problems in the code below - for example, I can't see why the date conversion is failing or why (despite the uninit var) the C and R are missing. Really at this point you are in the best position to debug the program as you have the source data, which I'm having to guess the format of. Debugging - there's a proper debugger built into unidata but for quick and dirty checking, use CRT variable to display the contents of a variable to screen, and INPUT X,1 to have the program wait until you press a key - useful if you're displaying a lot of values and want to add a pause - for example after each record has been processed. Ed OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER' OPENSEQ 'OUTPUT.CSV' TO CSVFIL ELSE NULL WEOFSEQ CSVFIL SELECT FIL LOOP WHILE READNEXT ID DO READ REC FROM FIL,ID THEN * Count how many multivalues are in each attribute MV.COUNT = NUM.ATTRS = DCOUNT(REC,@AM) MV.COUNT = FOR A = 1 TO NUM.ATTRS MV.COUNT1,A = DCOUNT(RECA,@VM) NEXT A * And find the highest number MAX.MVS = MAXIMUM(MV.COUNT) * Convert specific attributes to date format. * Note the OCONVS handles multivalued data - it converts each value separately. REC9 = OCONVS(REC9,D2/) * Now output a line for each multivalue FOR A = 1 TO MAX.MVS OUT.LINE = FOR B = 1 TO NUM.ATTRS IF MV.COUNT1,A EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B = RECB,A NEXT B * Turn multivalues in the output line to commas *OUT.LINE = CHANGE(OUT.LINE,@VM,,) OUT.LINE = '' : CHANGE(CHANGE(OUT.LINE,@AM,','),@VM,',') : ',':ID * And write the line to the output file WRITESEQ OUT.LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE' * WRITESEQ OUT.LINE ... NEXT A END REPEAT ==End code :BASIC BP outfile Compiling Unibasic: BP/outfile in mode 'u'. compilation finished :RUN BP outfile In BP/_outfile at line 10 WARNING: UNINITIALIZED VARIABLE USED! Zero ssumed! : And output is :- ( Missing C,R in multivalve, date also not converted) Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6 Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6 Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6 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: Friday, October 16, 2009 12:39 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Yes, and I've just spotted the first mistake - the last line should have been a couple of lines higher... * Count how many multivalues are in each attribute MV.COUNT = NUM.ATTRS = DCOUNT(REC,@AM) FOR A = 1 TO NUM.ATTRS MV.COUNT1,A = DCOUNT(RECA,@VM) NEXT A * And find the highest number MAX.MVS = MAXIMUM(MV.COUNT) * Convert specific attributes to date format. * Note the OCONVS handles multivalued data - it converts each value separately. REC9 = OCONVS(REC9,D2/) * Now output a line for each multivalue FOR A = 1 TO MAX.MVS OUT.LINE = FOR B = 1 TO NUM.ATTRS IF MV.COUNT1,A EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B = RECB,A NEXT B * Turn multivalues in the output line to commas OUT.LINE = CHANGE(OUT.LINE,@VM,,) * And write the line to the output file WRITESEQ OUT.LINE ... NEXT A * -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: 16 October 2009 08:06 To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Dattatraya - in unibasic almost any string handling task is possible! Hmm - funny how the original topic of this thread and the subsequent discussion of specifications, or lack of, seems to have come full circle. Starting with REC - as read from disk. Presume REC has one or more multivalued fields. REC is to be written to the output file multiple times, subsequent lines taking the 1st, 2nd etc multivalue where the attribute is multivalued and taking the entire attribute otherwise. * Count how many multivalues are in each attribute MV.COUNT = NUM.ATTRS = DCOUNT(REC,@AM) FOR A = 1 TO NUM.ATTRS MV.COUNT1,A = DCOUNT(RECA,@VM) NEXT A * And find the highest number MAX.MVS
Re: [U2] Unibasic: Sample program - to extract data from Table
Try changing IF MV.COUNT1,A EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B = RECB,A To IF MV.COUNT1,B EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B = RECB,A -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude Sent: 16 October 2009 12:17 To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Now Date is converted, but multivalue ( C , R ) still missing. ,Jones, Bob,123 E. 23rdst.,Arvada,CO,80276,3037768854,V4341,04/24/94,D,7,R,6 ,Jones, Bob,123 E. 23rdSt.,Arvada,CO,80276,3037768854,V4341,04/24/94,D,7,R,6 ,Jones, Bob,123 E. 23rdSt.,Arvada,CO,80276,3037768854,V4341,04/24/94,D,7,R,6 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: Friday, October 16, 2009 3:29 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Dattatraya, (Possible) correction added. You really need to take the time to understand the example code we're giving you. There will still be problems in the code below - for example, I can't see why the date conversion is failing or why (despite the uninit var) the C and R are missing. Really at this point you are in the best position to debug the program as you have the source data, which I'm having to guess the format of. Debugging - there's a proper debugger built into unidata but for quick and dirty checking, use CRT variable to display the contents of a variable to screen, and INPUT X,1 to have the program wait until you press a key - useful if you're displaying a lot of values and want to add a pause - for example after each record has been processed. Ed OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER' OPENSEQ 'OUTPUT.CSV' TO CSVFIL ELSE NULL WEOFSEQ CSVFIL SELECT FIL LOOP WHILE READNEXT ID DO READ REC FROM FIL,ID THEN * Count how many multivalues are in each attribute MV.COUNT = NUM.ATTRS = DCOUNT(REC,@AM) MV.COUNT = FOR A = 1 TO NUM.ATTRS MV.COUNT1,A = DCOUNT(RECA,@VM) NEXT A * And find the highest number MAX.MVS = MAXIMUM(MV.COUNT) * Convert specific attributes to date format. * Note the OCONVS handles multivalued data - it converts each value separately. REC9 = OCONVS(REC9,D2/) * Now output a line for each multivalue FOR A = 1 TO MAX.MVS OUT.LINE = FOR B = 1 TO NUM.ATTRS IF MV.COUNT1,A EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B = RECB,A NEXT B * Turn multivalues in the output line to commas *OUT.LINE = CHANGE(OUT.LINE,@VM,,) OUT.LINE = '' : CHANGE(CHANGE(OUT.LINE,@AM,','),@VM,',') : ',':ID * And write the line to the output file WRITESEQ OUT.LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE' * WRITESEQ OUT.LINE ... NEXT A END REPEAT ==End code :BASIC BP outfile Compiling Unibasic: BP/outfile in mode 'u'. compilation finished :RUN BP outfile In BP/_outfile at line 10 WARNING: UNINITIALIZED VARIABLE USED! Zero ssumed! : And output is :- ( Missing C,R in multivalve, date also not converted) Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6 Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6 Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6 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: Friday, October 16, 2009 12:39 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Yes, and I've just spotted the first mistake - the last line should have been a couple of lines higher... * Count how many multivalues are in each attribute MV.COUNT = NUM.ATTRS = DCOUNT(REC,@AM) FOR A = 1 TO NUM.ATTRS MV.COUNT1,A = DCOUNT(RECA,@VM) NEXT A * And find the highest number MAX.MVS = MAXIMUM(MV.COUNT) * Convert specific attributes to date format. * Note the OCONVS handles multivalued data - it converts each value separately. REC9 = OCONVS(REC9,D2/) * Now output a line for each multivalue FOR A = 1 TO MAX.MVS OUT.LINE = FOR B = 1 TO NUM.ATTRS IF MV.COUNT1,A EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B = RECB,A NEXT B * Turn multivalues in the output line to commas OUT.LINE = CHANGE(OUT.LINE,@VM,,) * And write the line to the output file WRITESEQ OUT.LINE ... NEXT A * -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: 16 October 2009 08:06 To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Dattatraya - in unibasic almost any string handling task is possible! Hmm - funny how the original topic of this thread and the subsequent discussion of specifications, or lack of, seems to have come full circle. Starting with REC - as read from
Re: [U2] Unibasic: Sample program - to extract data from Table
Thanks Ed, It comes correct (only two records), missing another rows:- Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,04/24/94,D,7,6 Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,04/24/94,C,7,6 Thanks Regards, Dattatraya Walgude DBA Team Rsystems International Ltd, Pune, ( : +91-20-22909212 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Friday, October 16, 2009 4:49 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Try changing IF MV.COUNT1,A EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B = RECB,A To IF MV.COUNT1,B EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B = RECB,A -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude Sent: 16 October 2009 12:17 To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Now Date is converted, but multivalue ( C , R ) still missing. ,Jones, Bob,123 E. 23rdst.,Arvada,CO,80276,3037768854,V4341,04/24/94,D,7,R,6 ,Jones, Bob,123 E. 23rdSt.,Arvada,CO,80276,3037768854,V4341,04/24/94,D,7,R,6 ,Jones, Bob,123 E. 23rdSt.,Arvada,CO,80276,3037768854,V4341,04/24/94,D,7,R,6 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: Friday, October 16, 2009 3:29 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Dattatraya, (Possible) correction added. You really need to take the time to understand the example code we're giving you. There will still be problems in the code below - for example, I can't see why the date conversion is failing or why (despite the uninit var) the C and R are missing. Really at this point you are in the best position to debug the program as you have the source data, which I'm having to guess the format of. Debugging - there's a proper debugger built into unidata but for quick and dirty checking, use CRT variable to display the contents of a variable to screen, and INPUT X,1 to have the program wait until you press a key - useful if you're displaying a lot of values and want to add a pause - for example after each record has been processed. Ed OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER' OPENSEQ 'OUTPUT.CSV' TO CSVFIL ELSE NULL WEOFSEQ CSVFIL SELECT FIL LOOP WHILE READNEXT ID DO READ REC FROM FIL,ID THEN * Count how many multivalues are in each attribute MV.COUNT = NUM.ATTRS = DCOUNT(REC,@AM) MV.COUNT = FOR A = 1 TO NUM.ATTRS MV.COUNT1,A = DCOUNT(RECA,@VM) NEXT A * And find the highest number MAX.MVS = MAXIMUM(MV.COUNT) * Convert specific attributes to date format. * Note the OCONVS handles multivalued data - it converts each value separately. REC9 = OCONVS(REC9,D2/) * Now output a line for each multivalue FOR A = 1 TO MAX.MVS OUT.LINE = FOR B = 1 TO NUM.ATTRS IF MV.COUNT1,A EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B = RECB,A NEXT B * Turn multivalues in the output line to commas *OUT.LINE = CHANGE(OUT.LINE,@VM,,) OUT.LINE = '' : CHANGE(CHANGE(OUT.LINE,@AM,','),@VM,',') : ',':ID * And write the line to the output file WRITESEQ OUT.LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE' * WRITESEQ OUT.LINE ... NEXT A END REPEAT ==End code :BASIC BP outfile Compiling Unibasic: BP/outfile in mode 'u'. compilation finished :RUN BP outfile In BP/_outfile at line 10 WARNING: UNINITIALIZED VARIABLE USED! Zero ssumed! : And output is :- ( Missing C,R in multivalve, date also not converted) Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6 Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6 Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6 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: Friday, October 16, 2009 12:39 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Yes, and I've just spotted the first mistake - the last line should have been a couple of lines higher... * Count how many multivalues are in each attribute MV.COUNT = NUM.ATTRS = DCOUNT(REC,@AM) FOR A = 1 TO NUM.ATTRS MV.COUNT1,A = DCOUNT(RECA,@VM) NEXT A * And find the highest number MAX.MVS = MAXIMUM(MV.COUNT) * Convert specific attributes to date format. * Note the OCONVS handles multivalued data - it converts each value separately. REC9 = OCONVS(REC9,D2/) * Now output a line for each multivalue FOR A = 1 TO MAX.MVS OUT.LINE = FOR B = 1 TO NUM.ATTRS IF MV.COUNT1,A EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B = RECB,A NEXT B * Turn multivalues in the output line to commas OUT.LINE = CHANGE
Re: [U2] Unibasic: Sample program - to extract data from Table
Thousand thanks to you ED, Now output is:- Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,04/24/94,D,7,6 Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,04/24/94,C,7,6 Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,04/24/94,R,7,6 Frobisher, Kamal,P.O. Box 9845,Denver,CO,80209-,3037780880,,,K,33,204 Frobisher, Kamal,,Denver,CO,80209-,3037780880,,,O,33,204 Steven Spender,1212 W. 44th,Denver,CO,80401,30344578783,90 Jamieson, Dale,999 Independence Way,Seattle,WI,98733,,V6670,04/24/94,,8,12 Chase, Carl,12 W. Main,Kenosha,WI,53142,414666,V8481,04/20/94,,11,9 Chase, Carl,Suite 1414,Kenosha,WI,53142,414666,V1254,04/20/94,,11,9 Chase, Carl,,Kenosha,WI,53142,414666,V4951,04/21/94,,11,9 Wagner, Pat,403 S. Pennsylvania,Denver,CO,80209,3037222680,,,R,4,201 Wagner, Pat,First Floor,Denver,CO,80209,3037222680,,,S,4,201 Wagner, Pat,Deliveries to rear door,Denver,CO,80209,3037222680,,,H,4,201 Wagner, Esther,1455 30th Avenue,Kenosha,WI,53140,4145527433,,,M,5,210 Wagner, Esther,Woodcreek Condos,Kenosha,WI,53140,4145527433,,,T,5,210 Wagner, Esther,,Kenosha,WI,53140,4145527433,,,P,5,210 Wagner, Esther,,Kenosha,WI,53140,4145527433,,,K,5,210 Wagner, Esther,,Kenosha,WI,53140,4145527433,,,B,5,210 Thanks Regards, Dattatraya Walgude DBA Team Rsystems International Ltd, Pune, ( : +91-20-22909212 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Friday, October 16, 2009 4:49 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Try changing IF MV.COUNT1,A EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B = RECB,A To IF MV.COUNT1,B EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B = RECB,A -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude Sent: 16 October 2009 12:17 To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Now Date is converted, but multivalue ( C , R ) still missing. ,Jones, Bob,123 E. 23rdst.,Arvada,CO,80276,3037768854,V4341,04/24/94,D,7,R,6 ,Jones, Bob,123 E. 23rdSt.,Arvada,CO,80276,3037768854,V4341,04/24/94,D,7,R,6 ,Jones, Bob,123 E. 23rdSt.,Arvada,CO,80276,3037768854,V4341,04/24/94,D,7,R,6 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: Friday, October 16, 2009 3:29 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Dattatraya, (Possible) correction added. You really need to take the time to understand the example code we're giving you. There will still be problems in the code below - for example, I can't see why the date conversion is failing or why (despite the uninit var) the C and R are missing. Really at this point you are in the best position to debug the program as you have the source data, which I'm having to guess the format of. Debugging - there's a proper debugger built into unidata but for quick and dirty checking, use CRT variable to display the contents of a variable to screen, and INPUT X,1 to have the program wait until you press a key - useful if you're displaying a lot of values and want to add a pause - for example after each record has been processed. Ed OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER' OPENSEQ 'OUTPUT.CSV' TO CSVFIL ELSE NULL WEOFSEQ CSVFIL SELECT FIL LOOP WHILE READNEXT ID DO READ REC FROM FIL,ID THEN * Count how many multivalues are in each attribute MV.COUNT = NUM.ATTRS = DCOUNT(REC,@AM) MV.COUNT = FOR A = 1 TO NUM.ATTRS MV.COUNT1,A = DCOUNT(RECA,@VM) NEXT A * And find the highest number MAX.MVS = MAXIMUM(MV.COUNT) * Convert specific attributes to date format. * Note the OCONVS handles multivalued data - it converts each value separately. REC9 = OCONVS(REC9,D2/) * Now output a line for each multivalue FOR A = 1 TO MAX.MVS OUT.LINE = FOR B = 1 TO NUM.ATTRS IF MV.COUNT1,A EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B = RECB,A NEXT B * Turn multivalues in the output line to commas *OUT.LINE = CHANGE(OUT.LINE,@VM,,) OUT.LINE = '' : CHANGE(CHANGE(OUT.LINE,@AM,','),@VM,',') : ',':ID * And write the line to the output file WRITESEQ OUT.LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE' * WRITESEQ OUT.LINE ... NEXT A END REPEAT ==End code :BASIC BP outfile Compiling Unibasic: BP/outfile in mode 'u'. compilation finished :RUN BP outfile In BP/_outfile at line 10 WARNING: UNINITIALIZED VARIABLE USED! Zero ssumed! : And output is :- ( Missing C,R in multivalve, date also not converted) Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6 Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6 Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6 Thanks Regards
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: [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 ) with followinf contents Facing compilation error OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER' OPENSEQ 'OUTPUT.CSV' TO CSVFIL WEOFSEQ CSVFIL SELECT FIL LOOP WHILE READNEXT ID DO READ REC FROM FIL,ID THEN LINE = '' : CHANGE(CHANGE(REC,@AM,','),@SVM,',') : '' WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE' END REPEAT
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 RECattributenumber,valuenumber e.g. REC4,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: [U2] Unibasic: Sample
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 sly...@fwdco.com 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 bren...@marketamerica.com To: U2 Users List u2-users@listserver.u2ug.org 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 bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org 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
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 - 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 ) with followinf contents Facing compilation error
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] 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
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
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
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 sly...@fwdco.com To: U2 Users List u2-users@listserver.u2ug.org 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 bren...@marketamerica.com To: U2 Users List u2-users@listserver.u2ug.org 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 bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org 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
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] 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
Exactly - i still stick to the belief that a small team of highly skilled programmers will code quicker from a single page spec than a thousand low quality coders using a high detail spec. Many an institution disagrees, or rather has been stung by smaller teams giving promises that they can then not deliver, I suppose this is what bureaucracy is all about, something simple runs perfectly until someone slips up, then all hell breaks loose and 15 procedures are put into place and before you know it you have a team of 20 doing what one guy did all on his own. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: 13 October 2009 22:54 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table If you are going to go that far with the minutia then why not just type it in and get done with it? Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, October 13, 2009 2:09 PM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Actually for many it is mass produced. Specification is being done to the absolute minutia, for example in the Unified Rational process, when generating use cases these get transmitted down to the architectural specifications and become the actual classes in the code (there is even software to build such skeleton code), with each method and property defined, again this is then used by the test plan to test each class/method/property etc. The coder kind of just fills in the gaps. In my previous employment we had whole teams of BA's, DBA's, System Architects, UI Designers, UX analysts etc, Then a bunch of people in the Philipines to do exactly as was written down in front of them. This kind of scenario happens a lot in larger projects. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: 13 October 2009 18:00 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table I don't see where you are coming from here. Every program I ever produce is for a specific purpose. We don't create one program and then have an assembly line that types it in several times over and over again. We just make copies of it. Programming takes skill, intelligence, and imagination. It is not a massed produced product like linen or towels where they have to have a body to recreate the product over and over. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, October 13, 2009 9:43 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms are pretty much the same as any other - if you get a small highly focused team of experts they will achieve a lot. The problem is when you get large pools of programmers of various skill levels, and so need more management time than it would take to program it in the first place. But then this is in theory more scalable. I live in the north west of England, just outside Manchester, the Industrial revolution started here, It was once very big in the textile industry- However no textiles are made here anymore, the old Victorian buildings that used to produce these are now trendy apartments, or business parks. There are a few specialist providers, I can kind of see software going the same way. Much of software is grinding out work, that can be done very cheaply in India/China/and Africa soon. All we in the western world will be doing is niche specialist development. Perhaps -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: 12 October 2009 22:09 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms aren't all they're cracked up to be, especially in anything other than Microsoft technologies. I've seen exactly this progression in other language lists to which I belong. Indian firm gets contract based on price and claim to know the language. Indian firm tries to get free help from mailing lists, newsgroups, etc, because they don't understand the technology. Indian firm loses contract or is not renewed. We've got personal experience in taking development contracts away from this type of firm. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net Sent: Monday, October 12, 2009 1:47 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Doesn't matter which. We
Re: [U2] Unibasic: Sample program - to extract data from Table
Alleluia! Brother! Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, October 14, 2009 5:00 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Exactly - i still stick to the belief that a small team of highly skilled programmers will code quicker from a single page spec than a thousand low quality coders using a high detail spec. Many an institution disagrees, or rather has been stung by smaller teams giving promises that they can then not deliver, I suppose this is what bureaucracy is all about, something simple runs perfectly until someone slips up, then all hell breaks loose and 15 procedures are put into place and before you know it you have a team of 20 doing what one guy did all on his own. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: 13 October 2009 22:54 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table If you are going to go that far with the minutia then why not just type it in and get done with it? Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, October 13, 2009 2:09 PM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Actually for many it is mass produced. Specification is being done to the absolute minutia, for example in the Unified Rational process, when generating use cases these get transmitted down to the architectural specifications and become the actual classes in the code (there is even software to build such skeleton code), with each method and property defined, again this is then used by the test plan to test each class/method/property etc. The coder kind of just fills in the gaps. In my previous employment we had whole teams of BA's, DBA's, System Architects, UI Designers, UX analysts etc, Then a bunch of people in the Philipines to do exactly as was written down in front of them. This kind of scenario happens a lot in larger projects. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: 13 October 2009 18:00 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table I don't see where you are coming from here. Every program I ever produce is for a specific purpose. We don't create one program and then have an assembly line that types it in several times over and over again. We just make copies of it. Programming takes skill, intelligence, and imagination. It is not a massed produced product like linen or towels where they have to have a body to recreate the product over and over. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, October 13, 2009 9:43 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms are pretty much the same as any other - if you get a small highly focused team of experts they will achieve a lot. The problem is when you get large pools of programmers of various skill levels, and so need more management time than it would take to program it in the first place. But then this is in theory more scalable. I live in the north west of England, just outside Manchester, the Industrial revolution started here, It was once very big in the textile industry- However no textiles are made here anymore, the old Victorian buildings that used to produce these are now trendy apartments, or business parks. There are a few specialist providers, I can kind of see software going the same way. Much of software is grinding out work, that can be done very cheaply in India/China/and Africa soon. All we in the western world will be doing is niche specialist development. Perhaps -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: 12 October 2009 22:09 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms aren't all they're cracked up to be, especially in anything other than Microsoft technologies. I've seen exactly this progression in other language lists to which I belong. Indian firm gets contract based on price and claim to know the language. Indian firm tries to get free help from mailing lists, newsgroups, etc, because they don't understand the technology. Indian firm loses contract or is not renewed. We've got personal experience in taking development contracts away from this type of firm. Larry Hiscock Western Computer
Re: [U2] Unibasic: Sample Program
Should those thousand low quality coders quit their jobs and line up at the local soup kitchen? If it is true that the world needs more computer programs... it follows that the world needs more programmers, not less. -Original Message- From: Symeon Breen Sent: Wednesday, October 14, 2009 6:00 AM Exactly - i still stick to the belief that a small team of highly skilled programmers will code quicker from a single page spec than a thousand low quality coders using a high detail spec. Many an institution disagrees, or rather has been stung by smaller teams giving promises that they can then not deliver, I suppose this is what bureaucracy is all about, something simple runs perfectly until someone slips up, then all hell breaks loose and 15 procedures are put into place and before you know it you have a team of 20 doing what one guy did all on his own. ___ 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
As a programmer who has had to maintain and enhance systems that were written apparently based on a one-page spec that everyone on the team understood, when the team members are no longer there, and the documentation was all between their ears (and left with them), I am a big believer in detailed written specs that get turned into test plans and then into documentation. Eventually the lack of specs turns around and bites the organization that allowed it to happen (unless the application was a one-time quick-and-dirty project that will never have to be resurrected). Susan Lynch - Original Message - From: jpb-u2ug jpb-u...@hotmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: 10/14/2009 8:18 AM Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Alleluia! Brother! Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, October 14, 2009 5:00 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Exactly - i still stick to the belief that a small team of highly skilled programmers will code quicker from a single page spec than a thousand low quality coders using a high detail spec. Many an institution disagrees, or rather has been stung by smaller teams giving promises that they can then not deliver, I suppose this is what bureaucracy is all about, something simple runs perfectly until someone slips up, then all hell breaks loose and 15 procedures are put into place and before you know it you have a team of 20 doing what one guy did all on his own. ___ 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
John, I agree that listening to the super users is critical. However, writing a detailed spec will give those super users the ability to review the spec, add their 'second thoughts' (and the wow, this is really cool - could it also do this? ideas before the files are designed and the code written, and really does not take a lot of time. It ensures that the coding team all understand all the aspects of the project the same way. So even with super users, I always waited for a sign-off on the detailed spec before laying out the files and writing the code. I had clients that I worked with for years, and knew their business very well, but taking the time to write a detailed spec was never a waste of my time. I am glad for you that your system works well, but I hope I never have to come in after you all retire! ;-) Susan Lynch - Original Message - From: Israel, John R. johnisr...@daytonsuperior.com To: U2 Users List u2-users@listserver.u2ug.org Sent: 10/14/2009 12:14 PM Subject: Re: [U2] Unibasic: Sample program - to extract data from Table You cannot buy knowledge of a business. Experience with a technology: yes. Knowledge of how a specific company works: no. That only comes with time working at that site. A key to our success is having super-users that really know how the business works, how the software works, and the ability to clearly describe how they want things enhanced. The other half of this coin is having programmer/analysts that understand what the user wants, where the data is stored (or will need to be stored), who ask the right questions, and can work with those super-users. Our users are very happy with what we produce. We have a small U2 team, but a well seasoned team. I rarely have specs and never very detailed. It is all screen shots with hand written notes that come from a meeting or two with the super-users. Requests from non-super-users must go through the super-users. It is my job to understand what they want (which is usually, but not always what they ask for). However, not every business will have these conditions. Contractors have it even tougher since they may have little knowledge of the business they are trying to help. Just my experience... John Israel -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 12:00 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table As a programmer who has had to maintain and enhance systems that were written apparently based on a one-page spec that everyone on the team understood, when the team members are no longer there, and the documentation was all between their ears (and left with them), I am a big believer in detailed written specs that get turned into test plans and then into documentation. Eventually the lack of specs turns around and bites the organization that allowed it to happen (unless the application was a one-time quick-and-dirty project that will never have to be resurrected). Susan Lynch - Original Message - From: jpb-u2ug jpb-u...@hotmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: 10/14/2009 8:18 AM Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Alleluia! Brother! Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, October 14, 2009 5:00 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Exactly - i still stick to the belief that a small team of highly skilled programmers will code quicker from a single page spec than a thousand low quality coders using a high detail spec. Many an institution disagrees, or rather has been stung by smaller teams giving promises that they can then not deliver, I suppose this is what bureaucracy is all about, something simple runs perfectly until someone slips up, then all hell breaks loose and 15 procedures are put into place and before you know it you have a team of 20 doing what one guy did all on his own. ___ 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
Susan, As a contractor, I agree completely about getting a sign off on specs. I have been in that boat too. The same is true if you have super-users who may not really be that super. In my current position (on-staff code-monkey), the level of trust is very high between the U2 team and the super-users. It is my job to ask the right questions, present the options/risks/etc, and propose additional benefits at that time. I never make any changes of note w/o bashing out the situation with the super-users first. It is also my job to bring up any unforeseen issues that occurs as the coding takes shape. I will never retire! I will die with one hand on the keyboard and a Dt. Dew in the other. John Israel Senior Programmer/Analyst Dayton Superior Corporation -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 12:35 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table John, I agree that listening to the super users is critical. However, writing a detailed spec will give those super users the ability to review the spec, add their 'second thoughts' (and the wow, this is really cool - could it also do this? ideas before the files are designed and the code written, and really does not take a lot of time. It ensures that the coding team all understand all the aspects of the project the same way. So even with super users, I always waited for a sign-off on the detailed spec before laying out the files and writing the code. I had clients that I worked with for years, and knew their business very well, but taking the time to write a detailed spec was never a waste of my time. I am glad for you that your system works well, but I hope I never have to come in after you all retire! ;-) Susan Lynch - Original Message - From: Israel, John R. johnisr...@daytonsuperior.com To: U2 Users List u2-users@listserver.u2ug.org Sent: 10/14/2009 12:14 PM Subject: Re: [U2] Unibasic: Sample program - to extract data from Table You cannot buy knowledge of a business. Experience with a technology: yes. Knowledge of how a specific company works: no. That only comes with time working at that site. A key to our success is having super-users that really know how the business works, how the software works, and the ability to clearly describe how they want things enhanced. The other half of this coin is having programmer/analysts that understand what the user wants, where the data is stored (or will need to be stored), who ask the right questions, and can work with those super-users. Our users are very happy with what we produce. We have a small U2 team, but a well seasoned team. I rarely have specs and never very detailed. It is all screen shots with hand written notes that come from a meeting or two with the super-users. Requests from non-super-users must go through the super-users. It is my job to understand what they want (which is usually, but not always what they ask for). However, not every business will have these conditions. Contractors have it even tougher since they may have little knowledge of the business they are trying to help. Just my experience... John Israel -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 12:00 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table As a programmer who has had to maintain and enhance systems that were written apparently based on a one-page spec that everyone on the team understood, when the team members are no longer there, and the documentation was all between their ears (and left with them), I am a big believer in detailed written specs that get turned into test plans and then into documentation. Eventually the lack of specs turns around and bites the organization that allowed it to happen (unless the application was a one-time quick-and-dirty project that will never have to be resurrected). Susan Lynch - Original Message - From: jpb-u2ug jpb-u...@hotmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: 10/14/2009 8:18 AM Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Alleluia! Brother! Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, October 14, 2009 5:00 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Exactly - i still stick to the belief that a small team of highly skilled programmers will code quicker from a single page spec than a thousand low quality coders using a high detail spec. Many an institution disagrees
Re: [U2] Unibasic: Sample program - to extract data from Table
In message 02fb01ca4c38$ab3ad6c0$01b084...@com, Symeon Breen syme...@gmail.com writes Actually for many it is mass produced. Specification is being done to the absolute minutia, for example in the Unified Rational process, when generating use cases these get transmitted down to the architectural specifications and become the actual classes in the code (there is even software to build such skeleton code), with each method and property defined, again this is then used by the test plan to test each class/method/property etc. The coder kind of just fills in the gaps. In my previous employment we had whole teams of BA's, DBA's, System Architects, UI Designers, UX analysts etc, Then a bunch of people in the Philipines to do exactly as was written down in front of them. This kind of scenario happens a lot in larger projects. Which is probably why so many larger projects are either a disaster from the start, or rapidly turn into legacy (often before they're deployed) as the business needs change. Cheers, Wol -- Anthony W. Youngman pi...@thewolery.demon.co.uk 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick ___ 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
I'm with Susan on this. My job as a consultant is to help clients define what they want so that anyone can code it. My job as a programmer is to implement the spec that was defined. These are two separate skills. Without specs the programmer codes what he/she thinks is required, leaving the client later to ask why isn't 'this' in there, or why did you do 'that'? A spec helps to eliminate the questions, to make sure things aren't forgotten, and to prevent rifts between client expectations and contractor delivery. It's certainly true that people can take specs to extremes, with four hours spent on specs and one on code. But there have been times when some number of hours spent on a spec revealed that there wasn't enough information to begin coding, or that the project was much more extensive than imagined, so no programming was done at all. Compare this to situations where weeks or months of coding is done and then trashed because someone down the line realized the code wasn't necessary, or that it all needed to be re-written because it didn't agree with existing policies. Getting the job done isn't just about creating functional code, it's should include making sure that the next person in line understands both what the code does and why it does it. Creating a proper balance between spec time and coding time is yet another skill that people should develop over time - and this is what helps to separate professionals from amateurs. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com NEW: Follow TonyGravagno on Twitter remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! ___ 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
Documenting the program or application is always a good idea, it also helps if changes to the programs are documented, but having to write the specs to the smallest minutia is overkill. Unless, you are writing the specs for someone else that doesn't know your business or the next person in line shouldn't be in the position to start with. Jerry Banker -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 11:35 AM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table John, I agree that listening to the super users is critical. However, writing a detailed spec will give those super users the ability to review the spec, add their 'second thoughts' (and the wow, this is really cool - could it also do this? ideas before the files are designed and the code written, and really does not take a lot of time. It ensures that the coding team all understand all the aspects of the project the same way. So even with super users, I always waited for a sign-off on the detailed spec before laying out the files and writing the code. I had clients that I worked with for years, and knew their business very well, but taking the time to write a detailed spec was never a waste of my time. I am glad for you that your system works well, but I hope I never have to come in after you all retire! ;-) Susan Lynch - Original Message - From: Israel, John R. johnisr...@daytonsuperior.com To: U2 Users List u2-users@listserver.u2ug.org Sent: 10/14/2009 12:14 PM Subject: Re: [U2] Unibasic: Sample program - to extract data from Table You cannot buy knowledge of a business. Experience with a technology: yes. Knowledge of how a specific company works: no. That only comes with time working at that site. A key to our success is having super-users that really know how the business works, how the software works, and the ability to clearly describe how they want things enhanced. The other half of this coin is having programmer/analysts that understand what the user wants, where the data is stored (or will need to be stored), who ask the right questions, and can work with those super-users. Our users are very happy with what we produce. We have a small U2 team, but a well seasoned team. I rarely have specs and never very detailed. It is all screen shots with hand written notes that come from a meeting or two with the super-users. Requests from non-super-users must go through the super-users. It is my job to understand what they want (which is usually, but not always what they ask for). However, not every business will have these conditions. Contractors have it even tougher since they may have little knowledge of the business they are trying to help. Just my experience... John Israel -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 12:00 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table As a programmer who has had to maintain and enhance systems that were written apparently based on a one-page spec that everyone on the team understood, when the team members are no longer there, and the documentation was all between their ears (and left with them), I am a big believer in detailed written specs that get turned into test plans and then into documentation. Eventually the lack of specs turns around and bites the organization that allowed it to happen (unless the application was a one-time quick-and-dirty project that will never have to be resurrected). Susan Lynch - Original Message - From: jpb-u2ug jpb-u...@hotmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: 10/14/2009 8:18 AM Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Alleluia! Brother! Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, October 14, 2009 5:00 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Exactly - i still stick to the belief that a small team of highly skilled programmers will code quicker from a single page spec than a thousand low quality coders using a high detail spec. Many an institution disagrees, or rather has been stung by smaller teams giving promises that they can then not deliver, I suppose this is what bureaucracy is all about, something simple runs perfectly until someone slips up, then all hell breaks loose and 15 procedures are put into place and before you know it you have a team of 20 doing what one guy did all on his own. ___ U2-Users mailing list
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
Re: [U2] Unibasic: Sample Program
Yes, some people also call it scrum. 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 Brutzman, Bill Sent: Wednesday, October 14, 2009 3:21 PM To: U2 Users List 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
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 bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org 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
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 bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org 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
Re: [U2] Unibasic: Sample program - to extract data from Table
On the other hand some of us end up spending senseless days re-engineering a product every time management changes it's mind what the product should do. It's a good thing I get paid for doing what the boss says rather than getting paid by completed projects. My boss actually brags about our ability to program on the fly. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unibasic: Sample Program
I agree, agile and scrum are the way to go However, this is not just a term for no specifications and an open ended project. This methodology requires a commitment of time and effort by all parties, most importantly a dedicated person from the business tied to the project who has a stake in the project, not just a BA or someone who cannot directly or quickly make decisions about what direction or priorities the project should take. This person, is responsible for seeing that the project delivers what the business requires quickly and iteratively...therefore lessoning any chance that is does not deliver what and when. If this happens then the project will deliver what the business requires when it is completed. (at least that phase). This in contrast to a lot off waterfall style projects where the business does not often know what they need, at least in detail and so a spec is just a best guess. If not then it will take a very long time to get it 99% accurate with no payback for the business, (it will never be 100% unless the project is very simple). Consequently, there will always change control issues, debate about who should pay for the change etc...very unproductive...as well as a BA who is acting as a translator between IT and the business. While a spec, might be technical documentation, it requires a lot of effort on the part of everyone to write it but more importantly to maintain it going forward...as I find when the going gets tough and time and money is short...documentation is the first to go, a decision made by who is paying the bills not anyone elses...This is where agile and scrum come to the fore...however it does require a culture change within the entire organization to that of a shared partnership between all parties striving for the betterment of the business rather than a confrontational approach which a formal spec signoff/ contract represents... My 2 cents. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Brenda Price Sent: Thursday, 15 October 2009 8:31 a.m. To: U2 Users List 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 bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org 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
Re: [U2] Unibasic: Sample program - to extract data from Table
Mine did too - he came from the Cobol world and didn't think much of multivalue systems until he asked me to do a project, signed off on my spec, and 2 days later had a completed, documentated, ready to fly system up and running. He was stunned - he thought it was a 6 month project (and he became a devout convert to multi-value systems...) Susan Lynch - Original Message - From: Jeff Powell j...@powellclan.com To: u2-users@listserver.u2ug.org Sent: 10/14/2009 4:00 PM Subject: Re: [U2] Unibasic: Sample program - to extract data from Table On the other hand some of us end up spending senseless days re-engineering a product every time management changes it's mind what the product should do. It's a good thing I get paid for doing what the boss says rather than getting paid by completed projects. My boss actually brags about our ability to program on the fly. ___ 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
My experience in this is as a software vendor - it can be very dangerous to engage with a customer in an agile development - As a vendor we supply our packaged product with a certain amount of modification. It is very important that such modifications are ring fenced, costed and planned before the project even starts. i.e. part of the sales discussions. As hinted many see agile as somewhat open ended so great care is needed. It probably works better for internal projects as opposed to a vendor doing enhancements for a customer. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: 14 October 2009 20:56 To: U2 Users List Subject: Re: [U2] Unibasic: Sample Program I agree, agile and scrum are the way to go However, this is not just a term for no specifications and an open ended project. This methodology requires a commitment of time and effort by all parties, most importantly a dedicated person from the business tied to the project who has a stake in the project, not just a BA or someone who cannot directly or quickly make decisions about what direction or priorities the project should take. This person, is responsible for seeing that the project delivers what the business requires quickly and iteratively...therefore lessoning any chance that is does not deliver what and when. If this happens then the project will deliver what the business requires when it is completed. (at least that phase). This in contrast to a lot off waterfall style projects where the business does not often know what they need, at least in detail and so a spec is just a best guess. If not then it will take a very long time to get it 99% accurate with no payback for the business, (it will never be 100% unless the project is very simple). Consequently, there will always change control issues, debate about who should pay for the change etc...very unproductive...as well as a BA who is acting as a translator between IT and the business. While a spec, might be technical documentation, it requires a lot of effort on the part of everyone to write it but more importantly to maintain it going forward...as I find when the going gets tough and time and money is short...documentation is the first to go, a decision made by who is paying the bills not anyone elses...This is where agile and scrum come to the fore...however it does require a culture change within the entire organization to that of a shared partnership between all parties striving for the betterment of the business rather than a confrontational approach which a formal spec signoff/ contract represents... My 2 cents. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Brenda Price Sent: Thursday, 15 October 2009 8:31 a.m. To: U2 Users List 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 bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org 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
Re: [U2] Unibasic Sample Program
Two keys to making agile safe are [1] OSGI config management and [2] software test. Of course, customers want everything done yesterday. --Bill -Original Message- From: Symeon Breen Sent: Wednesday, October 14, 2009 4:27 PM My experience in this is as a software vendor - it can be very dangerous to engage with a customer in an agile development - As a vendor we supply our packaged product with a certain amount of modification. It is very important that such modifications are ring fenced, costed and planned before the project even starts. i.e. part of the sales discussions. As hinted many see agile as somewhat open ended so great care is needed. It probably works better for internal projects as opposed to a vendor doing enhancements for a customer. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unibasic: Sample Program - Scrum/Agile methodology
Possibly, and while it probably works better with internal teams, I think it goes back to what I was saying about it being a partnership approach. Most vendor/customer relationships are not partner at all, they may say it is a partnership, but the nature of the beast dictates otherwise. So if a vendor/customer can have a true partnership and it then I think it can work, it is just a matter of people defining what the project is, committing resources and producing results. Both sides have to buy in though and this is the big culture change for most if not all organisations... I do quite a lot of work in the BI field these days, and with the right tools we are usually able to deliver solutions quickly in a few days which gives the business user and idea of what they can achieve. To sit down and spec this with them would take a lot of time and effort and will will guarantee 100% there will be changes due to crappy data, missed business logic, or just not understanding what indeed they wanted or what they could achieve. Showing them by doing and pictures...what is it a picture is better than 1000 words...works far better in my experience. Again though the business user has to commit to the process as well and be available and focused in delivering a solution. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, 15 October 2009 9:30 a.m. To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample Program My experience in this is as a software vendor - it can be very dangerous to engage with a customer in an agile development - As a vendor we supply our packaged product with a certain amount of modification. It is very important that such modifications are ring fenced, costed and planned before the project even starts. i.e. part of the sales discussions. As hinted many see agile as somewhat open ended so great care is needed. It probably works better for internal projects as opposed to a vendor doing enhancements for a customer. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: 14 October 2009 20:56 To: U2 Users List Subject: Re: [U2] Unibasic: Sample Program I agree, agile and scrum are the way to go However, this is not just a term for no specifications and an open ended project. This methodology requires a commitment of time and effort by all parties, most importantly a dedicated person from the business tied to the project who has a stake in the project, not just a BA or someone who cannot directly or quickly make decisions about what direction or priorities the project should take. This person, is responsible for seeing that the project delivers what the business requires quickly and iteratively...therefore lessoning any chance that is does not deliver what and when. If this happens then the project will deliver what the business requires when it is completed. (at least that phase). This in contrast to a lot off waterfall style projects where the business does not often know what they need, at least in detail and so a spec is just a best guess. If not then it will take a very long time to get it 99% accurate with no payback for the business, (it will never be 100% unless the project is very simple). Consequently, there will always change control issues, debate about who should pay for the change etc...very unproductive...as well as a BA who is acting as a translator between IT and the business. While a spec, might be technical documentation, it requires a lot of effort on the part of everyone to write it but more importantly to maintain it going forward...as I find when the going gets tough and time and money is short...documentation is the first to go, a decision made by who is paying the bills not anyone elses...This is where agile and scrum come to the fore...however it does require a culture change within the entire organization to that of a shared partnership between all parties striving for the betterment of the business rather than a confrontational approach which a formal spec signoff/ contract represents... My 2 cents. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Brenda Price Sent: Thursday, 15 October 2009 8:31 a.m. To: U2 Users List 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
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 bren...@marketamerica.com To: U2 Users List u2-users@listserver.u2ug.org 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 bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org 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
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 sly...@fwdco.com 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 bren...@marketamerica.com To: U2 Users List u2-users@listserver.u2ug.org 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 bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org 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
Robert, there you have my favorite phrase If maintained properly - no matter what development practices, the key is to maintain the documentation so that the next change request can be reviewed against an accurate understanding of the system (particularly in light of the diverse tools now being used to access the systems - web products, SQL, and a whole host of query tools that make it more complex than ever to identify all the ripple effects from what one might think is a simple change). Susan Lynch - Original Message - From: Robert Porter ropor...@ochsner.org To: U2 Users List u2-users@listserver.u2ug.org Sent: 10/14/2009 6:04 PM 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unibasic: Sample Program
I think it also depends on a lot on the toolset you are using. This approach, if you are writing code in pure pick basic, with minimal dictionaries for the files you are using could be suicidal, yet with the right tools and mindset, this can be a VERY productive way of working. In this regard, I firmly agree with what Phil said in relation to his BI implementations - often it is far quicker to just do it than to describe what it is We have dubbed our implementation of agile, iterative development vRapid, and we have found it works very well in practice. Sit down with the customer, discover the data that needs to be (or is already being) kept and design some files and dictionaries around that. Document the inter-relationships as part of the Dictionary, and mock up some screens with these data definitions. These screens get fattened out appropriate business logic engaged during the iterative process, and in little more than the time it would take to develop a traditional spec you can have a fully functional application and the client has been engaged 100% during the whole process, so there are no surprises, and they are VERY HAPPY (and because they have seen how easy it is to accommodate change, the application IS likely to keep on growing organically, but this is controlled feature creep that you get paid for!) With the right framework in place, this approach can be a real winner, and deliverables can start to flow be deployed long before the entire project is complete, so it can become a win/win situation 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 phil walker Sent: Thursday, 15 October 2009 6:56 AM To: U2 Users List Subject: Re: [U2] Unibasic: Sample Program I agree, agile and scrum are the way to go However, this is not just a term for no specifications and an open ended project. This methodology requires a commitment of time and effort by all parties, most importantly a dedicated person from the business tied to the project who has a stake in the project, not just a BA or someone who cannot directly or quickly make decisions about what direction or priorities the project should take. This person, is responsible for seeing that the project delivers what the business requires quickly and iteratively...therefore lessoning any chance that is does not deliver what and when. If this happens then the project will deliver what the business requires when it is completed. (at least that phase). This in contrast to a lot off waterfall style projects where the business does not often know what they need, at least in detail and so a spec is just a best guess. If not then it will take a very long time to get it 99% accurate with no payback for the business, (it will never be 100% unless the project is very simple). Consequently, there will always change control issues, debate about who should pay for the change etc...very unproductive...as well as a BA who is acting as a translator between IT and the business. While a spec, might be technical documentation, it requires a lot of effort on the part of everyone to write it but more importantly to maintain it going forward...as I find when the going gets tough and time and money is short...documentation is the first to go, a decision made by who is paying the bills not anyone elses...This is where agile and scrum come to the fore...however it does require a culture change within the entire organization to that of a shared partnership between all parties striving for the betterment of the business rather than a confrontational approach which a formal spec signoff/ contract represents... My 2 cents. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Brenda Price Sent: Thursday, 15 October 2009 8:31 a.m. To: U2 Users List 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
Re: [U2] Unibasic: Sample Program
I could not put it more eloquently Ross. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Ross Ferris Sent: Thursday, 15 October 2009 1:00 p.m. To: U2 Users List Subject: Re: [U2] Unibasic: Sample Program I think it also depends on a lot on the toolset you are using. This approach, if you are writing code in pure pick basic, with minimal dictionaries for the files you are using could be suicidal, yet with the right tools and mindset, this can be a VERY productive way of working. In this regard, I firmly agree with what Phil said in relation to his BI implementations - often it is far quicker to just do it than to describe what it is We have dubbed our implementation of agile, iterative development vRapid, and we have found it works very well in practice. Sit down with the customer, discover the data that needs to be (or is already being) kept and design some files and dictionaries around that. Document the inter-relationships as part of the Dictionary, and mock up some screens with these data definitions. These screens get fattened out appropriate business logic engaged during the iterative process, and in little more than the time it would take to develop a traditional spec you can have a fully functional application and the client has been engaged 100% during the whole process, so there are no surprises, and they are VERY HAPPY (and because they have seen how easy it is to accommodate change, the application IS likely to keep on growing organically, but this is controlled feature creep that you get paid for!) With the right framework in place, this approach can be a real winner, and deliverables can start to flow be deployed long before the entire project is complete, so it can become a win/win situation 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 phil walker Sent: Thursday, 15 October 2009 6:56 AM To: U2 Users List Subject: Re: [U2] Unibasic: Sample Program I agree, agile and scrum are the way to go However, this is not just a term for no specifications and an open ended project. This methodology requires a commitment of time and effort by all parties, most importantly a dedicated person from the business tied to the project who has a stake in the project, not just a BA or someone who cannot directly or quickly make decisions about what direction or priorities the project should take. This person, is responsible for seeing that the project delivers what the business requires quickly and iteratively...therefore lessoning any chance that is does not deliver what and when. If this happens then the project will deliver what the business requires when it is completed. (at least that phase). This in contrast to a lot off waterfall style projects where the business does not often know what they need, at least in detail and so a spec is just a best guess. If not then it will take a very long time to get it 99% accurate with no payback for the business, (it will never be 100% unless the project is very simple). Consequently, there will always change control issues, debate about who should pay for the change etc...very unproductive...as well as a BA who is acting as a translator between IT and the business. While a spec, might be technical documentation, it requires a lot of effort on the part of everyone to write it but more importantly to maintain it going forward...as I find when the going gets tough and time and money is short...documentation is the first to go, a decision made by who is paying the bills not anyone elses...This is where agile and scrum come to the fore...however it does require a culture change within the entire organization to that of a shared partnership between all parties striving for the betterment of the business rather than a confrontational approach which a formal spec signoff/ contract represents... My 2 cents. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Brenda Price Sent: Thursday, 15 October 2009 8:31 a.m. To: U2 Users List 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
Re: [U2] Unibasic: Sample program - to extract data from Table
Excellent points. In my personal experience, I've had terrible dealings with overseas firms. On the flip side, the sharpest person I've ever worked with was from New Delhi. Getting back to the point at hand, I believe that Pick Systems had some development work done in Russia, during the early 90's. I remember their work as being very good and remarkably bug-free. (Of course, I also drank a lot during those days, so my memory may not be that good.) Now,all of a sudden, at the same time that Rocket Software picks up U2, we start getting questions from rsystems in India. Naturally, I wondered if Rocket Software was the company that hired them. Probably not, but I'm still curious. Larry Hiscock lar...@wcs-corp.com 10/12/2009 5:09 PM Indian development firms aren't all they're cracked up to be, especially in anything other than Microsoft technologies. I've seen exactly this progression in other language lists to which I belong. Indian firm gets contract based on price and claim to know the language. Indian firm tries to get free help from mailing lists, newsgroups, etc, because they don't understand the technology. Indian firm loses contract or is not renewed. We've got personal experience in taking development contracts away from this type of firm. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net Sent: Monday, October 12, 2009 1:47 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Doesn't matter which. We are the next group that will be asked to work for reduced pay or our work will go to India. Bruce M Neylon Health Care Management Group Phone: (301) 608-8633 ___ 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
Indian development firms are pretty much the same as any other - if you get a small highly focused team of experts they will achieve a lot. The problem is when you get large pools of programmers of various skill levels, and so need more management time than it would take to program it in the first place. But then this is in theory more scalable. I live in the north west of England, just outside Manchester, the Industrial revolution started here, It was once very big in the textile industry- However no textiles are made here anymore, the old Victorian buildings that used to produce these are now trendy apartments, or business parks. There are a few specialist providers, I can kind of see software going the same way. Much of software is grinding out work, that can be done very cheaply in India/China/and Africa soon. All we in the western world will be doing is niche specialist development. Perhaps -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: 12 October 2009 22:09 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms aren't all they're cracked up to be, especially in anything other than Microsoft technologies. I've seen exactly this progression in other language lists to which I belong. Indian firm gets contract based on price and claim to know the language. Indian firm tries to get free help from mailing lists, newsgroups, etc, because they don't understand the technology. Indian firm loses contract or is not renewed. We've got personal experience in taking development contracts away from this type of firm. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net Sent: Monday, October 12, 2009 1:47 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Doesn't matter which. We are the next group that will be asked to work for reduced pay or our work will go to India. Bruce M Neylon Health Care Management Group Phone: (301) 608-8633 ___ 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
I don't think anyone was questioning Jay's intelligence. He is probably a very intelligent person or he would not have been hired. What is in question is the intelligence of the individuals that hired the firm he works for and the intelligence of the people that gave him the work to do without first of having him trained on it. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Rubeor Sent: Tuesday, October 13, 2009 8:26 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Excellent points. In my personal experience, I've had terrible dealings with overseas firms. On the flip side, the sharpest person I've ever worked with was from New Delhi. Getting back to the point at hand, I believe that Pick Systems had some development work done in Russia, during the early 90's. I remember their work as being very good and remarkably bug-free. (Of course, I also drank a lot during those days, so my memory may not be that good.) Now,all of a sudden, at the same time that Rocket Software picks up U2, we start getting questions from rsystems in India. Naturally, I wondered if Rocket Software was the company that hired them. Probably not, but I'm still curious. Larry Hiscock lar...@wcs-corp.com 10/12/2009 5:09 PM Indian development firms aren't all they're cracked up to be, especially in anything other than Microsoft technologies. I've seen exactly this progression in other language lists to which I belong. Indian firm gets contract based on price and claim to know the language. Indian firm tries to get free help from mailing lists, newsgroups, etc, because they don't understand the technology. Indian firm loses contract or is not renewed. We've got personal experience in taking development contracts away from this type of firm. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net Sent: Monday, October 12, 2009 1:47 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Doesn't matter which. We are the next group that will be asked to work for reduced pay or our work will go to India. Bruce M Neylon Health Care Management Group Phone: (301) 608-8633 ___ 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
I don't see where you are coming from here. Every program I ever produce is for a specific purpose. We don't create one program and then have an assembly line that types it in several times over and over again. We just make copies of it. Programming takes skill, intelligence, and imagination. It is not a massed produced product like linen or towels where they have to have a body to recreate the product over and over. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, October 13, 2009 9:43 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms are pretty much the same as any other - if you get a small highly focused team of experts they will achieve a lot. The problem is when you get large pools of programmers of various skill levels, and so need more management time than it would take to program it in the first place. But then this is in theory more scalable. I live in the north west of England, just outside Manchester, the Industrial revolution started here, It was once very big in the textile industry- However no textiles are made here anymore, the old Victorian buildings that used to produce these are now trendy apartments, or business parks. There are a few specialist providers, I can kind of see software going the same way. Much of software is grinding out work, that can be done very cheaply in India/China/and Africa soon. All we in the western world will be doing is niche specialist development. Perhaps -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: 12 October 2009 22:09 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms aren't all they're cracked up to be, especially in anything other than Microsoft technologies. I've seen exactly this progression in other language lists to which I belong. Indian firm gets contract based on price and claim to know the language. Indian firm tries to get free help from mailing lists, newsgroups, etc, because they don't understand the technology. Indian firm loses contract or is not renewed. We've got personal experience in taking development contracts away from this type of firm. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net Sent: Monday, October 12, 2009 1:47 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Doesn't matter which. We are the next group that will be asked to work for reduced pay or our work will go to India. Bruce M Neylon Health Care Management Group Phone: (301) 608-8633 ___ 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
The two main ingredients in any good software are.. [1] Guts and [2] Brains. --B -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: Tuesday, October 13, 2009 12:53 PM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - I don't think anyone was questioning ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unibasic: Sample program
with a couple goto's spinkled in for good measure?? ;) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Tuesday, October 13, 2009 1:45 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program The two main ingredients in any good software are.. [1] Guts and [2] Brains. --B ___ 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
Actually for many it is mass produced. Specification is being done to the absolute minutia, for example in the Unified Rational process, when generating use cases these get transmitted down to the architectural specifications and become the actual classes in the code (there is even software to build such skeleton code), with each method and property defined, again this is then used by the test plan to test each class/method/property etc. The coder kind of just fills in the gaps. In my previous employment we had whole teams of BA's, DBA's, System Architects, UI Designers, UX analysts etc, Then a bunch of people in the Philipines to do exactly as was written down in front of them. This kind of scenario happens a lot in larger projects. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: 13 October 2009 18:00 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table I don't see where you are coming from here. Every program I ever produce is for a specific purpose. We don't create one program and then have an assembly line that types it in several times over and over again. We just make copies of it. Programming takes skill, intelligence, and imagination. It is not a massed produced product like linen or towels where they have to have a body to recreate the product over and over. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, October 13, 2009 9:43 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms are pretty much the same as any other - if you get a small highly focused team of experts they will achieve a lot. The problem is when you get large pools of programmers of various skill levels, and so need more management time than it would take to program it in the first place. But then this is in theory more scalable. I live in the north west of England, just outside Manchester, the Industrial revolution started here, It was once very big in the textile industry- However no textiles are made here anymore, the old Victorian buildings that used to produce these are now trendy apartments, or business parks. There are a few specialist providers, I can kind of see software going the same way. Much of software is grinding out work, that can be done very cheaply in India/China/and Africa soon. All we in the western world will be doing is niche specialist development. Perhaps -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: 12 October 2009 22:09 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms aren't all they're cracked up to be, especially in anything other than Microsoft technologies. I've seen exactly this progression in other language lists to which I belong. Indian firm gets contract based on price and claim to know the language. Indian firm tries to get free help from mailing lists, newsgroups, etc, because they don't understand the technology. Indian firm loses contract or is not renewed. We've got personal experience in taking development contracts away from this type of firm. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net Sent: Monday, October 12, 2009 1:47 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Doesn't matter which. We are the next group that will be asked to work for reduced pay or our work will go to India. Bruce M Neylon Health Care Management Group Phone: (301) 608-8633 ___ 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
With a number of the modern languages, there is a lot of code that is mind numbing boring and tedious. What is a couple of lines in unibasic is hundreds of lines in .Net, Java, etc. What is being outsourced is all the tedious unclever stuff such as defining variables and validations and other functions that don't require smarts but are responsible for a volume of the work in these languages. Ironically as in manufacturing, automation is replacing the manual repetitive work. The next release of .Net is reducing a lot of this unnecessary work. If you can structure coding to be like a production line catering for less skilled people, then you can automate it and that is what .Net is doing. Hence automation is going to kill the lucrative outsourcing business in the end. The key to survival is being resourceful, adaptive and innovative. The days of coding drones is becoming numbered. What businesses need are people who come up with innovative and clever ways of doing things that improves the bottom line. David Jordan ___ 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
If you are going to go that far with the minutia then why not just type it in and get done with it? Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, October 13, 2009 2:09 PM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Actually for many it is mass produced. Specification is being done to the absolute minutia, for example in the Unified Rational process, when generating use cases these get transmitted down to the architectural specifications and become the actual classes in the code (there is even software to build such skeleton code), with each method and property defined, again this is then used by the test plan to test each class/method/property etc. The coder kind of just fills in the gaps. In my previous employment we had whole teams of BA's, DBA's, System Architects, UI Designers, UX analysts etc, Then a bunch of people in the Philipines to do exactly as was written down in front of them. This kind of scenario happens a lot in larger projects. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: 13 October 2009 18:00 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table I don't see where you are coming from here. Every program I ever produce is for a specific purpose. We don't create one program and then have an assembly line that types it in several times over and over again. We just make copies of it. Programming takes skill, intelligence, and imagination. It is not a massed produced product like linen or towels where they have to have a body to recreate the product over and over. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, October 13, 2009 9:43 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms are pretty much the same as any other - if you get a small highly focused team of experts they will achieve a lot. The problem is when you get large pools of programmers of various skill levels, and so need more management time than it would take to program it in the first place. But then this is in theory more scalable. I live in the north west of England, just outside Manchester, the Industrial revolution started here, It was once very big in the textile industry- However no textiles are made here anymore, the old Victorian buildings that used to produce these are now trendy apartments, or business parks. There are a few specialist providers, I can kind of see software going the same way. Much of software is grinding out work, that can be done very cheaply in India/China/and Africa soon. All we in the western world will be doing is niche specialist development. Perhaps -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: 12 October 2009 22:09 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms aren't all they're cracked up to be, especially in anything other than Microsoft technologies. I've seen exactly this progression in other language lists to which I belong. Indian firm gets contract based on price and claim to know the language. Indian firm tries to get free help from mailing lists, newsgroups, etc, because they don't understand the technology. Indian firm loses contract or is not renewed. We've got personal experience in taking development contracts away from this type of firm. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net Sent: Monday, October 12, 2009 1:47 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Doesn't matter which. We are the next group that will be asked to work for reduced pay or our work will go to India. Bruce M Neylon Health Care Management Group Phone: (301) 608-8633 ___ 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
Re: [U2] Unibasic: Sample program - to extract data from Table
I would think you are better off getting an example from your VAR, or the people that supplied/wrote your application, who will be better equipped to discuss what data you wish to extract from which files (tables), and where you are looking at putting/using the extracted data 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 Dattatraya Walgude Sent: Monday, 12 October 2009 4:14 PM To: u2-users@listserver.u2ug.org Subject: [U2] Unibasic: Sample program - to extract data from Table Dear All I am new in Unidata/Unibasic, I want a sample program to extract data from one of our big history table. Kindly give me any link/ suggestion. Thanks Regards, Dattatraya Walgude 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 ___ 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
The big question is extract to what ? csv ? xml ? another data table ? Here is a very quick simple extract to a csv - this is just off the top of my head so i have not compiled it or tested it. OPEN 'FILE' TO FIL ESLE STOP 201,'FILE' OPENSEQ 'OUTPUT.CSV' TO CSVFIL WEOFSEQ CSVFIL SELECT FIL LOOP WHILE READNEXT ID DO READ REC FROM FIL,ID THEN LINE = '' : CHANGE(CHANGE(REC,@AM,','),@SVM,',') : '' WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE' END REPEAT Rgds Symeon. -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 06:14 To: u2-users@listserver.u2ug.org Subject: [U2] Unibasic: Sample program - to extract data from Table Dear All I am new in Unidata/Unibasic, I want a sample program to extract data from one of our big history table. Kindly give me any link/ suggestion. Thanks Regards, Dattatraya Walgude 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 ___ 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 Symeon I have created one program file (outfile ) with followinf contents Facing compilation error OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER' OPENSEQ 'OUTPUT.CSV' TO CSVFIL WEOFSEQ CSVFIL SELECT FIL LOOP WHILE READNEXT ID DO READ REC FROM FIL,ID THEN LINE = '' : CHANGE(CHANGE(REC,@AM,','),@SVM,',') : '' WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE' END REPEAT Facing compilation error :BASIC BP outfile Compiling Unibasic: BP/outfile in mode 'u'. main program: syntax error at or before line 2 OPENSEQ 'OUTPUT.CSV' TO CSVFIL --^ Expecting: ELSE compilation failed Thanks Regards, Dattatraya Walgude DBA Team Rsystems International Ltd, Pune, ( : +91-20-22909212 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Monday, October 12, 2009 4:28 PM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table The big question is extract to what ? csv ? xml ? another data table ? Here is a very quick simple extract to a csv - this is just off the top of my head so i have not compiled it or tested it. OPEN 'FILE' TO FIL ESLE STOP 201,'FILE' OPENSEQ 'OUTPUT.CSV' TO CSVFIL WEOFSEQ CSVFIL SELECT FIL LOOP WHILE READNEXT ID DO READ REC FROM FIL,ID THEN LINE = '' : CHANGE(CHANGE(REC,@AM,','),@SVM,',') : '' WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE' END REPEAT Rgds Symeon. -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 06:14 To: u2-users@listserver.u2ug.org Subject: [U2] Unibasic: Sample program - to extract data from Table Dear All I am new in Unidata/Unibasic, I want a sample program to extract data from one of our big history table. Kindly give me any link/ suggestion. Thanks Regards, Dattatraya Walgude 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 ___ 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
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 ) with followinf contents Facing compilation error OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER' OPENSEQ 'OUTPUT.CSV' TO CSVFIL WEOFSEQ CSVFIL SELECT FIL LOOP WHILE READNEXT ID DO READ REC FROM FIL,ID THEN LINE = '' : CHANGE(CHANGE(REC,@AM,','),@SVM,',') : '' WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE' END REPEAT Facing compilation error :BASIC BP outfile Compiling Unibasic: BP/outfile in mode 'u'. main program: syntax error at or before line 2 OPENSEQ 'OUTPUT.CSV' TO CSVFIL --^ Expecting: ELSE compilation failed Thanks Regards, Dattatraya Walgude DBA Team Rsystems International Ltd, Pune, ( : +91-20-22909212 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Monday, October 12, 2009 4:28 PM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table The big question is extract to what ? csv ? xml ? another data table ? Here is a very quick simple extract to a csv - this is just off the top of my head so i have not compiled it or tested it. OPEN 'FILE' TO FIL ESLE STOP 201,'FILE' OPENSEQ 'OUTPUT.CSV' TO CSVFIL WEOFSEQ CSVFIL SELECT FIL LOOP WHILE READNEXT ID DO READ REC FROM FIL,ID THEN LINE = '' : CHANGE(CHANGE(REC,@AM,','),@SVM,',') : '' WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE' END REPEAT Rgds Symeon. -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 06:14 To: u2-users@listserver.u2ug.org Subject: [U2] Unibasic: Sample program - to extract data from Table Dear All I am new in Unidata/Unibasic, I want a sample program to extract data from one of our big history table. Kindly give me any link/ suggestion. Thanks Regards, Dattatraya Walgude 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 ___ 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 --- Please remember to recycle wherever possible. Reduce, reuse, recycle, think do you need to print this e-mail? --- This e-mail and any attachment(s), is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the addressee, dissemination, copying or use of this e-mail or any of its content is prohibited and may be unlawful. If you are not the intended recipient please inform the sender immediately and destroy the e-mail, any attachment(s) and any copies. All liability for viruses is excluded to the fullest extent permitted by law. It is your responsibility to scan or otherwise check
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 ) with followinf contents Facing compilation error OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER' OPENSEQ 'OUTPUT.CSV' TO CSVFIL WEOFSEQ CSVFIL SELECT FIL LOOP WHILE READNEXT ID DO READ REC FROM FIL,ID THEN LINE = '' : CHANGE(CHANGE(REC,@AM,','),@SVM,',') : '' WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE' END REPEAT Facing compilation error :BASIC BP outfile Compiling Unibasic: BP/outfile in mode 'u'. main program: syntax error at or before line 2 OPENSEQ 'OUTPUT.CSV' TO CSVFIL --^ Expecting: ELSE compilation failed Thanks Regards, Dattatraya Walgude DBA Team Rsystems International Ltd, Pune, ( : +91-20-22909212 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Monday, October 12, 2009 4:28 PM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table The big question is extract to what ? csv ? xml ? another data table ? Here is a very quick simple extract to a csv - this is just off the top of my head so i have not compiled it or tested it. OPEN 'FILE' TO FIL ESLE STOP 201,'FILE' OPENSEQ 'OUTPUT.CSV' TO CSVFIL WEOFSEQ CSVFIL SELECT FIL LOOP WHILE READNEXT ID DO READ REC FROM FIL,ID THEN LINE = '' : CHANGE(CHANGE(REC,@AM,','),@SVM,',') : '' WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE' END REPEAT Rgds Symeon. -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 06:14 To: u2-users@listserver.u2ug.org Subject: [U2] Unibasic: Sample program - to extract data from Table Dear All I am new in Unidata/Unibasic, I want a sample program to extract data from one of our big history table. Kindly give me any link/ suggestion. Thanks Regards, Dattatraya Walgude 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 ___ 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 --- Please remember to recycle wherever possible. Reduce, reuse, recycle, think do you need to print this e-mail? --- This e-mail and any attachment(s), is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the addressee, dissemination
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 ) with followinf contents Facing compilation error OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER' OPENSEQ 'OUTPUT.CSV' TO CSVFIL WEOFSEQ CSVFIL SELECT FIL LOOP WHILE READNEXT ID DO READ REC FROM FIL,ID THEN LINE = '' : CHANGE(CHANGE(REC,@AM,','),@SVM,',') : '' WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE' END REPEAT Facing compilation error :BASIC BP outfile Compiling Unibasic: BP/outfile in mode 'u'. main program: syntax error at or before line 2 OPENSEQ 'OUTPUT.CSV' TO CSVFIL --^ Expecting: ELSE compilation failed Thanks Regards, Dattatraya Walgude DBA Team Rsystems International Ltd, Pune, ( : +91-20-22909212 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Monday, October 12, 2009 4:28 PM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table The big question is extract to what ? csv ? xml ? another data table ? Here is a very quick simple extract to a csv - this is just off the top of my head so i have not compiled it or tested it. OPEN 'FILE' TO FIL ESLE STOP 201,'FILE' OPENSEQ 'OUTPUT.CSV' TO CSVFIL WEOFSEQ CSVFIL SELECT FIL LOOP WHILE READNEXT ID DO READ REC FROM FIL,ID THEN LINE = '' : CHANGE(CHANGE(REC,@AM,','),@SVM,',') : '' WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE' END REPEAT Rgds Symeon. -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 06:14 To: u2-users@listserver.u2ug.org Subject: [U2] Unibasic: Sample program - to extract data from Table Dear All I am new in Unidata/Unibasic, I want a sample program to extract data from one of our big history table. Kindly give me any link/ suggestion. Thanks Regards, Dattatraya Walgude 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
Re: [U2] Unibasic: Sample program - to extract data from Table
The code is just an example to get you started - i suggest you read the manual or get on a course etc to understand better the data model and language. There are numerous things you can do to extend this program, you will need to ensure there are no in the data, the example is changing sub values to be comma delimited lists, again you will need to ensure there are no commas in the data - or you may want to normalise and produce a row in the csv per multi value, or perhaps if the multivalues are not an array of associated data but individual pieces of data you could split them to multiple columns, This very much depends on the structure of the data and what you are trying to achieve with it. To fix the below funny characters replace @SVM with @VM If you do have sub values in your data you may need to do some further conversions etc Rgds Symeon -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 ) with followinf contents Facing compilation error OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER' OPENSEQ 'OUTPUT.CSV' TO CSVFIL WEOFSEQ CSVFIL SELECT FIL LOOP WHILE READNEXT ID DO READ REC FROM FIL,ID THEN LINE = '' : CHANGE(CHANGE(REC,@AM,','),@SVM,',') : '' WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE' END REPEAT Facing compilation error :BASIC BP outfile Compiling Unibasic: BP/outfile in mode 'u'. main program: syntax error at or before line 2 OPENSEQ 'OUTPUT.CSV' TO CSVFIL --^ Expecting: ELSE compilation failed Thanks Regards, Dattatraya Walgude DBA Team Rsystems International Ltd, Pune, ( : +91-20-22909212 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Monday, October 12, 2009 4:28 PM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table The big question is extract to what ? csv ? xml ? another data table ? Here is a very quick simple extract to a csv - this is just off the top of my head so i have not compiled it or tested it. OPEN 'FILE' TO FIL ESLE STOP 201,'FILE' OPENSEQ 'OUTPUT.CSV' TO CSVFIL WEOFSEQ CSVFIL SELECT FIL LOOP WHILE READNEXT ID DO READ REC FROM FIL,ID THEN LINE = '' : CHANGE(CHANGE(REC,@AM,','),@SVM,',') : '' WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE' END REPEAT Rgds Symeon. -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 06:14 To: u2-users
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 Symeon Breen Sent: Monday, October 12, 2009 6:13 PM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table The code is just an example to get you started - i suggest you read the manual or get on a course etc to understand better the data model and language. There are numerous things you can do to extend this program, you will need to ensure there are no in the data, the example is changing sub values to be comma delimited lists, again you will need to ensure there are no commas in the data - or you may want to normalise and produce a row in the csv per multi value, or perhaps if the multivalues are not an array of associated data but individual pieces of data you could split them to multiple columns, This very much depends on the structure of the data and what you are trying to achieve with it. To fix the below funny characters replace @SVM with @VM If you do have sub values in your data you may need to do some further conversions etc Rgds Symeon -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 ) with followinf contents Facing compilation error OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER' OPENSEQ 'OUTPUT.CSV' TO CSVFIL WEOFSEQ CSVFIL SELECT FIL LOOP WHILE READNEXT ID DO READ REC FROM FIL,ID THEN LINE = '' : CHANGE(CHANGE(REC,@AM,','),@SVM,',') : '' WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE' END REPEAT Facing compilation error :BASIC BP outfile Compiling Unibasic: BP/outfile in mode 'u'. main program: syntax error at or before line 2 OPENSEQ 'OUTPUT.CSV' TO CSVFIL
Re: [U2] Unibasic: Sample program - to extract data from Table
Dattatraya Not wanting to be unhelpful here, but really even if you've never used the unidata version of Basic before there's enough information in the sample to see how to concatenate the ID of each record to the start of each line in the output file. Hint - It's the : operator. The variable ID in the example program holds the same value as @ID. Formatting a value as a date - see the OCONV function in the documentation. 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 14:24 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 Symeon Breen Sent: Monday, October 12, 2009 6:13 PM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table The code is just an example to get you started - i suggest you read the manual or get on a course etc to understand better the data model and language. There are numerous things you can do to extend this program, you will need to ensure there are no in the data, the example is changing sub values to be comma delimited lists, again you will need to ensure there are no commas in the data - or you may want to normalise and produce a row in the csv per multi value, or perhaps if the multivalues are not an array of associated data but individual pieces of data you could split them to multiple columns, This very much depends on the structure of the data and what you are trying to achieve with it. To fix the below funny characters replace @SVM with @VM If you do have sub values in your data you may need to do some further conversions etc Rgds Symeon -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
Re: [U2] Unibasic: Sample program - to extract data from Table
Dates are typically stored in internal format - so use something like OCONV(DATE.VAR,D4/) to format it. -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 6: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. ___ 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
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 ) with followinf contents Facing compilation error OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER' OPENSEQ 'OUTPUT.CSV' TO CSVFIL WEOFSEQ CSVFIL SELECT FIL LOOP WHILE READNEXT ID DO READ REC FROM FIL,ID THEN LINE = '' : CHANGE(CHANGE(REC,@AM,','),@SVM,',') : '' WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE' END REPEAT Facing compilation error :BASIC BP outfile Compiling Unibasic: BP/outfile in mode 'u'. main program: syntax error at or before line 2 OPENSEQ 'OUTPUT.CSV' TO CSVFIL --^ Expecting: ELSE compilation failed Thanks Regards, Dattatraya Walgude DBA Team Rsystems International Ltd, Pune, ( : +91-20-22909212 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Monday, October 12, 2009 4:28 PM To: 'U2 Users
Re: [U2] Unibasic: Sample program - to extract data from Table
And you are from outsource product develop company in India that has been tasked to work on this U2 system. http://www.rsystems.com/ It is a question that needs to be asked. Was this firm contracted for support or for development? ___ 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
Doesn't matter which. We are the next group that will be asked to work for reduced pay or our work will go to India. Bruce M Neylon Health Care Management Group Phone: (301) 608-8633 Charlie Rubeor crub...@1199nefunds.org Sent by: u2-users-boun...@listserver.u2ug.org 10/12/2009 04:10 PM Please respond to U2 Users List u2-users@listserver.u2ug.org To 'U2 Users List' u2-users@listserver.u2ug.org cc Subject Re: [U2] Unibasic: Sample program - to extract data from Table And you are from outsource product develop company in India that has been tasked to work on this U2 system. http://www.rsystems.com/ It is a question that needs to be asked. Was this firm contracted for support or for development? ___ 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
Indian development firms aren't all they're cracked up to be, especially in anything other than Microsoft technologies. I've seen exactly this progression in other language lists to which I belong. Indian firm gets contract based on price and claim to know the language. Indian firm tries to get free help from mailing lists, newsgroups, etc, because they don't understand the technology. Indian firm loses contract or is not renewed. We've got personal experience in taking development contracts away from this type of firm. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net Sent: Monday, October 12, 2009 1:47 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Doesn't matter which. We are the next group that will be asked to work for reduced pay or our work will go to India. Bruce M Neylon Health Care Management Group Phone: (301) 608-8633 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
