[U2] Creating a comma seperated flat file in UniData.
OS: Windows 2K U2: UniData 6.0.6 System Builder 5.2.4 I'm suffering a senior moment. I need to output a comma separated file to disk for importation into a 3rd party application. System Builder is too cumbersome (from what I can see) and want to do it in UniBasic. However, I have forgotten how to the command(s) to create a new flat file in an existing folder. So some examples would be helpful. Al DeWitt Stylmark, Inc. 763-574-8705 [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Creating a comma seperated flat file in UniData.
HELP LIST list ... TO DELIM , textFileName ??? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Al DeWitt Sent: Thursday, July 15, 2004 11:11 AM To: [EMAIL PROTECTED] Subject: [U2] Creating a comma seperated flat file in UniData. OS: Windows 2K U2: UniData 6.0.6 System Builder 5.2.4 I'm suffering a senior moment. I need to output a comma separated file to disk for importation into a 3rd party application. System Builder is too cumbersome (from what I can see) and want to do it in UniBasic. However, I have forgotten how to the command(s) to create a new flat file in an existing folder. So some examples would be helpful. Al DeWitt Stylmark, Inc. 763-574-8705 [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Creating a comma seperated flat file in UniData.
LIST [DICT] filename [record_IDs] [selection_criteria] [sorting_criteria] [attributes | ALL] [format_options] [report_options] [TO [DELIM char] text_file] Unidata 5.2 query... :LIST A.FILE WITH JUNK=1 TO DELIM , D:\TEMP\JUNK.CSV Marty -Original Message- From: Al DeWitt [mailto:[EMAIL PROTECTED] Sent: Thursday, July 15, 2004 1:11 PM To: [EMAIL PROTECTED] Subject: [U2] Creating a comma seperated flat file in UniData. OS: Windows 2K U2: UniData 6.0.6 System Builder 5.2.4 I'm suffering a senior moment. I need to output a comma separated file to disk for importation into a 3rd party application. System Builder is too cumbersome (from what I can see) and want to do it in UniBasic. However, I have forgotten how to the command(s) to create a new flat file in an existing folder. So some examples would be helpful. Al DeWitt Stylmark, Inc. 763-574-8705 [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Creating a comma seperated flat file in UniData.
Just OS write access - and the directory you are writing to has to exist... You can either use the full path (as in the example he gave) or use just the file name to put it in the current directory. hth -- Colin Alfke Calgary, Alberta Canada Just because something isn't broken doesn't mean that you can't fix it Stu Pickles -Original Message- From: Buffington, Wyatt [mailto:[EMAIL PROTECTED] Sent: Thursday, July 15, 2004 1:13 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Creating a comma seperated flat file in UniData. Is there anything special one needs to set up to be able to write the file to your C or D drives? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, July 15, 2004 1:23 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Creating a comma seperated flat file in UniData. LIST [DICT] filename [record_IDs] [selection_criteria] [sorting_criteria] [attributes | ALL] [format_options] [report_options] [TO [DELIM char] text_file] Unidata 5.2 query... :LIST A.FILE WITH JUNK=1 TO DELIM , D:\TEMP\JUNK.CSV Marty --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Creating a comma seperated flat file in UniData.
On second reading: unless by your you mean the users local hard drive. In that case you will need to use the facilities in your connection method to the server. The original poster had SB+, so if using SBClient there are a number of options. You can also use full unc paths. Note that my quick tests showed lines were delimited with a char(10) and not the DOS Usual CHAR(10):CHAR(13). hth -- Colin Alfke Calgary, Alberta Canada Just because something isn't broken doesn't mean that you can't fix it Stu Pickles -Original Message- From: Buffington, Wyatt [mailto:[EMAIL PROTECTED] Sent: Thursday, July 15, 2004 1:13 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Creating a comma seperated flat file in UniData. Is there anything special one needs to set up to be able to write the file to your C or D drives? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Creating a comma seperated flat file in UniData.
Al DeWitt wrote: I'm suffering a senior moment. I need to output a comma separated file to disk for importation into a 3rd party application. I skimmed the other answers, and didn't see anyone mention Cedarville's DOWNLOAD utility. It's the only thing we use for output files, much more flexible than LIST...TO... You can get it from ftp.cedarville.edu . -- Wendy Smoak Application Systems Analyst, Sr. ASU IA Information Resources Management --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Creating a comma seperated flat file in UniData.
I second Wendy on this. It doesn't takes even 10 minutes to install it. You can create the flat file from TCL. --- Wendy Smoak [EMAIL PROTECTED] wrote: Al DeWitt wrote: I'm suffering a senior moment. I need to output a comma separated file to disk for importation into a 3rd party application. I skimmed the other answers, and didn't see anyone mention Cedarville's DOWNLOAD utility. It's the only thing we use for output files, much more flexible than LIST...TO... You can get it from ftp.cedarville.edu . -- Wendy Smoak Application Systems Analyst, Sr. ASU IA Information Resources Management --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/