Re: [U2] Dumping data to file from TCL
Hi Phil, If it's just a matter of turning a two-step process into one step, would a Paragraph be reasonable? Just thinking of something along the lines of... PA IF I2,File = '' THEN GO ENDIT IF I3,IType = '' THEN GO ENDIT IF I4,ExportDirectory = '' THEN GO ENDIT IF I5,Datadump.dat = '' THEN GO ENDIT SELECT I2,File SAVING I3,IType LIST I2,File TO I4,ExportDirectory I5,Datadump.dat REQUIRE.SELECT ENDIT: Regards, Keith ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Dumping data to file from TCL
Phil If you really want to do that .. You can use SAVING with an EVAL clause and save the results to your SAVEDLISTS. SELECT MYFILE SAVING EVAL \MYFIELD:,:MYOTHERFIELD:,:MYLASTFIELD\ SAVE.LIST SomeList.txt But why don't you want to use DOWNLOAD or another program like EXPORT (from my website)? That's what they are designed to do. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: 20 February 2013 20:57 To: U2 Users List Subject: [U2] Dumping data to file from TCL Does Universe now have the ability to dump data to a file using a SELECT or LIST from TCL? I believe Unidata does have this capability.. For example, I can do a SELECT File SAVING IType SAVE.LIST ExportDirectory Datadump.dat But I would rather just say LIST File IType TO ExportDirectory Datadump.dat I know I could use DOWNLOAD or use LIST File Itype TOXML But I don't want to really use xml for this as there are a large number of records and the contents of IType are long and I would prefer not to use DOWNLOAD, or have to write a program if I can help it. Any ideas? ___ 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] Dumping data to file from TCL
Get outta here! I've never seen anyone try this before. Now I have to try it but with bar separators. -Original Message- From: Brian Leach br...@brianleach.co.uk To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Thu, Feb 21, 2013 1:42 am Subject: Re: [U2] Dumping data to file from TCL Phil If you really want to do that .. You can use SAVING with an EVAL clause and save the results to your SAVEDLISTS. SELECT MYFILE SAVING EVAL \MYFIELD:,:MYOTHERFIELD:,:MYLASTFIELD\ SAVE.LIST SomeList.txt But why don't you want to use DOWNLOAD or another program like EXPORT (from my website)? That's what they are designed to do. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: 20 February 2013 20:57 To: U2 Users List Subject: [U2] Dumping data to file from TCL Does Universe now have the ability to dump data to a file using a SELECT or LIST from TCL? I believe Unidata does have this capability.. For example, I can do a SELECT File SAVING IType SAVE.LIST ExportDirectory Datadump.dat But I would rather just say LIST File IType TO ExportDirectory Datadump.dat I know I could use DOWNLOAD or use LIST File Itype TOXML But I don't want to really use xml for this as there are a large number of records and the contents of IType are long and I would prefer not to use DOWNLOAD, or have to write a program if I can help it. Any ideas? ___ 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] Dumping data to file from TCL
Does Universe now have the ability to dump data to a file using a SELECT or LIST from TCL? I believe Unidata does have this capability.. For example, I can do a SELECT File SAVING IType SAVE.LIST ExportDirectory Datadump.dat But I would rather just say LIST File IType TO ExportDirectory Datadump.dat I know I could use DOWNLOAD or use LIST File Itype TOXML But I don't want to really use xml for this as there are a large number of records and the contents of IType are long and I would prefer not to use DOWNLOAD, or have to write a program if I can help it. Any ideas? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Dumping data to file from TCL
If you use Accuterm, you can turn on capturing, and create an Idesc which encapsulates all fields you want, within tabs, then you output that one field, then turn capturing off and you're done. -Original Message- From: Phil Walker p...@gnosys.co.nz To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Feb 20, 2013 12:57 pm Subject: [U2] Dumping data to file from TCL Does Universe now have the ability to dump data to a file using a SELECT or LIST from TCL? I believe Unidata does have this capability.. For example, I can do a SELECT File SAVING IType SAVE.LIST ExportDirectory Datadump.dat But I would rather just say LIST File IType TO ExportDirectory Datadump.dat I know I could use DOWNLOAD or use LIST File Itype TOXML But I don't want to really use xml for this as there are a large number of records and the contents of IType are long and I would prefer not to use DOWNLOAD, or have to write a program if I can help it. Any ideas? ___ 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] Dumping data to file from TCL
Another way is to use the SETPTR, to save the printout output to a HOLD file item (which is a directory) and a .txt or .csv type file, then just Print, in columns and rows (comma or tab seperated or whatever), and the results are in your nice neat O/S level text file. -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Wed, Feb 20, 2013 1:02 pm Subject: Re: [U2] Dumping data to file from TCL If you use Accuterm, you can turn on capturing, and create an Idesc which encapsulates all fields you want, within tabs, then you output that one field, then turn capturing off and you're done. -Original Message- From: Phil Walker p...@gnosys.co.nz To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Feb 20, 2013 12:57 pm Subject: [U2] Dumping data to file from TCL Does Universe now have the ability to dump data to a file using a SELECT or LIST from TCL? I believe Unidata does have this capability.. For example, I can do a SELECT File SAVING IType SAVE.LIST ExportDirectory Datadump.dat But I would rather just say LIST File IType TO ExportDirectory Datadump.dat I know I could use DOWNLOAD or use LIST File Itype TOXML But I don't want to really use xml for this as there are a large number of records and the contents of IType are long and I would prefer not to use DOWNLOAD, or have to write a program if I can help it. Any ideas? ___ 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] Dumping data to file from TCL
If using Rocket's Dynamic Connect, it is easy to copy and paste green screen data into say Windows NotePad. --Bill On Wed, Feb 20, 2013 at 3:56 PM, Phil Walker p...@gnosys.co.nz wrote: Does Universe now have the ability to dump data to a file using a SELECT or LIST from TCL? I believe Unidata does have this capability.. For example, I can do a SELECT File SAVING IType SAVE.LIST ExportDirectory Datadump.dat But I would rather just say LIST File IType TO ExportDirectory Datadump.dat I know I could use DOWNLOAD or use LIST File Itype TOXML But I don't want to really use xml for this as there are a large number of records and the contents of IType are long and I would prefer not to use DOWNLOAD, or have to write a program if I can help it. Any ideas? ___ 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] Dumping data to file from TCL
No we aren't and this needs to be an automated script executed by cron or other mechanisms e.g. EXECUTE command CAPTURING output etc. I can create a paragraph do to below if needed. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman Sent: Thursday, 21 February 2013 10:19 a.m. To: U2 Users List Subject: Re: [U2] Dumping data to file from TCL If using Rocket's Dynamic Connect, it is easy to copy and paste green screen data into say Windows NotePad. --Bill On Wed, Feb 20, 2013 at 3:56 PM, Phil Walker p...@gnosys.co.nz wrote: Does Universe now have the ability to dump data to a file using a SELECT or LIST from TCL? I believe Unidata does have this capability.. For example, I can do a SELECT File SAVING IType SAVE.LIST ExportDirectory Datadump.dat But I would rather just say LIST File IType TO ExportDirectory Datadump.dat I know I could use DOWNLOAD or use LIST File Itype TOXML But I don't want to really use xml for this as there are a large number of records and the contents of IType are long and I would prefer not to use DOWNLOAD, or have to write a program if I can help it. Any ideas? ___ 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] Dumping data to file from TCL
On Wed, Feb 20, 2013 at 1:05 PM, Wjhonson wjhon...@aol.com wrote: Another way is to use the SETPTR, to save the printout output to a HOLD file item (which is a directory) and a .txt or .csv type file, then just Print, in columns and rows (comma or tab seperated or whatever), and the results are in your nice neat O/S level text file. I did exactly that for a few applications over the years. Dumping the output to a HOLD worked fine when we were transferring data from Universe systems to another platform. John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Dumping data to file from TCL
For some weird reason I tend to like to Pipe delimit my outputs created this way. Don't ask me why. Maybe it's more visual, you can't see Tabs. This is the first place I've been where they are really big on creating electronic versions only, not using paper. And then we have an routing system, that copies reports to multiple parties auto-magically each day, week and month. -Original Message- From: John Lorentz john.lore...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Feb 20, 2013 2:33 pm Subject: Re: [U2] Dumping data to file from TCL On Wed, Feb 20, 2013 at 1:05 PM, Wjhonson wjhon...@aol.com wrote: Another way is to use the SETPTR, to save the printout output to a HOLD file item (which is a directory) and a .txt or .csv type file, then just Print, in columns and rows (comma or tab seperated or whatever), and the results are in your nice neat O/S level text file. I did exactly that for a few applications over the years. Dumping the output to a HOLD worked fine when we were transferring data from Universe systems to another platform. John ___ 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] Dumping data to file from TCL
Doing that I will end up with page delimiters and headers/footers will I not? I just want the data and nothing else and don't want to have to strip crap out if possible ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Lorentz Sent: Thursday, 21 February 2013 11:33 a.m. To: U2 Users List Subject: Re: [U2] Dumping data to file from TCL On Wed, Feb 20, 2013 at 1:05 PM, Wjhonson wjhon...@aol.com wrote: Another way is to use the SETPTR, to save the printout output to a HOLD file item (which is a directory) and a .txt or .csv type file, then just Print, in columns and rows (comma or tab seperated or whatever), and the results are in your nice neat O/S level text file. I did exactly that for a few applications over the years. Dumping the output to a HOLD worked fine when we were transferring data from Universe systems to another platform. John ___ 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] Dumping data to file from TCL
No you can set no hdr and no page options -Original Message- From: Phil Walker p...@gnosys.co.nz To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Feb 20, 2013 2:37 pm Subject: Re: [U2] Dumping data to file from TCL Doing that I will end up with page delimiters and headers/footers will I not? I just want the data and nothing else and don't want to have to strip crap out if possible ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Lorentz Sent: Thursday, 21 February 2013 11:33 a.m. To: U2 Users List Subject: Re: [U2] Dumping data to file from TCL On Wed, Feb 20, 2013 at 1:05 PM, Wjhonson wjhon...@aol.com wrote: Another way is to use the SETPTR, to save the printout output to a HOLD file item (which is a directory) and a .txt or .csv type file, then just Print, in columns and rows (comma or tab seperated or whatever), and the results are in your nice neat O/S level text file. I did exactly that for a few applications over the years. Dumping the output to a HOLD worked fine when we were transferring data from Universe systems to another platform. John ___ 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] Dumping data to file from TCL
On 20/02/13 21:24, Phil Walker wrote: No we aren't and this needs to be an automated script executed by cron or other mechanisms e.g. EXECUTE command CAPTURING output etc. I can create a paragraph do to below if needed. If you're happy using a program written by someone else there are several on PickWiki. They'll dump to csv, or there's a Hollerith one there that takes its column width from the dictionary and dumps in fixed-width format. Take a look and take your pick ... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman Sent: Thursday, 21 February 2013 10:19 a.m. To: U2 Users List Subject: Re: [U2] Dumping data to file from TCL If using Rocket's Dynamic Connect, it is easy to copy and paste green screen data into say Windows NotePad. --Bill On Wed, Feb 20, 2013 at 3:56 PM, Phil Walker p...@gnosys.co.nz wrote: Does Universe now have the ability to dump data to a file using a SELECT or LIST from TCL? I believe Unidata does have this capability.. For example, I can do a SELECT File SAVING IType SAVE.LIST ExportDirectory Datadump.dat But I would rather just say LIST File IType TO ExportDirectory Datadump.dat I know I could use DOWNLOAD or use LIST File Itype TOXML But I don't want to really use xml for this as there are a large number of records and the contents of IType are long and I would prefer not to use DOWNLOAD, or have to write a program if I can help it. Any ideas? ___ 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] Dumping data to file from TCL
http://curl.haxx.se/docs/manpage.html On Wed, Feb 20, 2013 at 3:03 PM, Wols Lists antli...@youngman.org.ukwrote: On 20/02/13 21:24, Phil Walker wrote: No we aren't and this needs to be an automated script executed by cron or other mechanisms e.g. EXECUTE command CAPTURING output etc. I can create a paragraph do to below if needed. If you're happy using a program written by someone else there are several on PickWiki. They'll dump to csv, or there's a Hollerith one there that takes its column width from the dictionary and dumps in fixed-width format. Take a look and take your pick ... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman Sent: Thursday, 21 February 2013 10:19 a.m. To: U2 Users List Subject: Re: [U2] Dumping data to file from TCL If using Rocket's Dynamic Connect, it is easy to copy and paste green screen data into say Windows NotePad. --Bill On Wed, Feb 20, 2013 at 3:56 PM, Phil Walker p...@gnosys.co.nz wrote: Does Universe now have the ability to dump data to a file using a SELECT or LIST from TCL? I believe Unidata does have this capability.. For example, I can do a SELECT File SAVING IType SAVE.LIST ExportDirectory Datadump.dat But I would rather just say LIST File IType TO ExportDirectory Datadump.dat I know I could use DOWNLOAD or use LIST File Itype TOXML But I don't want to really use xml for this as there are a large number of records and the contents of IType are long and I would prefer not to use DOWNLOAD, or have to write a program if I can help it. Any ideas? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Dumping data to file from TCL
Hi Mike, I might be just being dumb, but how would curl help me here? Cheers Phil -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mike McGuane Sent: Thursday, 21 February 2013 12:26 p.m. To: U2 Users List Subject: Re: [U2] Dumping data to file from TCL http://curl.haxx.se/docs/manpage.html On Wed, Feb 20, 2013 at 3:03 PM, Wols Lists antli...@youngman.org.ukwrote: On 20/02/13 21:24, Phil Walker wrote: No we aren't and this needs to be an automated script executed by cron or other mechanisms e.g. EXECUTE command CAPTURING output etc. I can create a paragraph do to below if needed. If you're happy using a program written by someone else there are several on PickWiki. They'll dump to csv, or there's a Hollerith one there that takes its column width from the dictionary and dumps in fixed-width format. Take a look and take your pick ... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman Sent: Thursday, 21 February 2013 10:19 a.m. To: U2 Users List Subject: Re: [U2] Dumping data to file from TCL If using Rocket's Dynamic Connect, it is easy to copy and paste green screen data into say Windows NotePad. --Bill On Wed, Feb 20, 2013 at 3:56 PM, Phil Walker p...@gnosys.co.nz wrote: Does Universe now have the ability to dump data to a file using a SELECT or LIST from TCL? I believe Unidata does have this capability.. For example, I can do a SELECT File SAVING IType SAVE.LIST ExportDirectory Datadump.dat But I would rather just say LIST File IType TO ExportDirectory Datadump.dat I know I could use DOWNLOAD or use LIST File Itype TOXML But I don't want to really use xml for this as there are a large number of records and the contents of IType are long and I would prefer not to use DOWNLOAD, or have to write a program if I can help it. Any ideas? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Dumping data to file from TCL
From: Mike McGuane http://curl.haxx.se/docs/manpage.html From: Phil Walker Hi Mike, I might be just being dumb, but how would curl help me here? I'm, guessing he posted to the wrong thread. That's the right answer to the question by Peter in the Consuming HTTPS service thread where he asks: Is it possible to have a UV basic program communicate with or consume / use a restful http service? I use cURL all the time because it's independent of MV platform and OS. I have standard wrappers for parsing responses to various queries. Rather than wondering what SoapCreateRequest() or protocolLogging() will do for you under the covers, personally I choose to have full access to the source and control my own destiny. Symeon said as much in his note about Restful webservices are nothing magical, William also posted here about using Dynamic Connect, and I think cURL is a possible replacement for some applications for that as well. As to something like SELECT File SAVING IType, uh, if File is a remote datasource then you could use cURL for that, otherwise as we degos say, fuggedaboudit. :) Regards, T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
