I too couldn't find any documentation, hence my convoluted method of trying achieve the goal. Now that I know the command, I found some reference in a posting from 2001 and also reference in TSM 5.1 and 4.2 documentation.
It's a shame that IBM won't (re)-document it, but thanks to this thread, I certainly won't be forgetting it. David, I appreciate your help. Leigh -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David E Ehresman Sent: 31 January 2007 20:32 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] exporting scripts I learned about "q script format=macro" either on this list or at Share. I also could not find it documented in the TSM doc so I opened a PMR with TSM support. Matthew Armstrong eventually reported that " The product is considered working as designed and there is essentially nowhere further we can go with this issue." and therefore they could not take a doc apar against it. So I guess it will continue to be secret information that you find out about on adsm-l! David Ehresman >>> "Choudarapu, Ramakrishna (GTI)" <[EMAIL PROTECTED]> 1/25/2007 12:46 PM >>> Looks great! But where is it documented? I do not see f=macro on HELP QUERY SCRIPT!!! -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David E Ehresman Sent: Thursday, January 25, 2007 12:37 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] exporting scripts q script f=macro > script.mac will create a file script.mac which contains DEFINE statements to recreate all your scripts. Just move the file to your new system and execute it with a macro script.mac command. David >>> Leigh Reed <[EMAIL PROTECTED]> 1/25/2007 12:25 PM >>> Geoff, I am doing the exact same thing at the moment. I think that there should be an easier way than this, but this is what I have so far select distinct 'query script',name,'f=raw outputfile=',name from scripts > scripts.scr This gives you a text file of the format below for every script that you have (you will have to delete a space between outputfile and scriptname) query script <scriptname> f=raw outputfile=<scriptname> You can then run this file as a macro/script to output all of your scripts in raw format to an individual text file with the respective script name as the filename. You can then copy these files to your new server. Using find and replace or text editing tools you can slightly modify your generated script from above to the format def script <scriptname> file=<filename> Then run this script and it will generate all your scripts on your new server. I have to add that using the select to generate the original script is not my own work, I stole it from a previous posting enquiring how to script a number of move datas, but it is neat. Credit the original poster (IIRC WP) If I find a better way, I'll let you know, likewise visa versa. Leigh -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gill, Geoffrey L. Sent: 25 January 2007 16:40 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] exporting scripts I think this has been asked before but I can't seem to find anything so hopefully my asking again won't be a big deal. I am trying to figure out if there is a way to export all of my scripts from one server so I can import them to another. I have tried to manually create these scripts but sometimes the 5.3 GUI chokes and won't let me, even though I have copied them exactly. If anyone has any thoughts on the easiest way to accomplish this I would appreciate it. This second server is for testing so I'm not looking to make anything permanent. Geoff Gill TSM Administrator PeopleSoft Sr. Systems Administrator SAIC M/S-G1b (858)826-4062 Email: [EMAIL PROTECTED] -------------------------------------------------------- If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/ --------------------------------------------------------