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
