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 - 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 - 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 - 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 - 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 - 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 - 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 - 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
[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