| Author |
|
GadgetGuy
Super User
Joined: June 01 2008
Location: United States
Online Status: Offline
Posts: 942
|
| Posted: January 23 2009 at 09:26 | IP Logged
|
|
|
I've written a lot of code in my day, except for two things.... I never got to write any IBM/360 machine code, nor any SQL code, thus a pretty basic question here, but one I don't see answered anywhere in the forum nor can I find any PH doco that explains.
The forum is full of macro examples that are in the form of "insert into macroheader values" etc statements.
Per se these are almost impossible to read and understand as macros as there is also SGL info embedded in the lines.
How does one take these examples (Copy) and Paste them into PH. I assume the Multi-Editor is the tool, but what exactly are the steps to take these examples and get them into PH where they can then be looked at in the Macros area of PH Explorer, so they can be understood and used?
__________________
Ken B - Live every day like it's your last. Eventually, you'll get it right!
|
| Back to Top |
|
| |
BeachBum
Super User
Joined: April 11 2007
Location: United States
Online Status: Offline
Posts: 1880
|
| Posted: January 23 2009 at 10:06 | IP Logged
|
|
|
Well I’ve written a lot of 360 Assembler and know how to read machine language dumps and have no SQL experience. Said that it does not help me with PH. Trial and Error and experience are my best tools. If someone has exported a macro to the forum and you want to import it then you copy it to the Multi-Editor as you said. Once it’s there then go to Edit and Execute Script. It will be in your Macro list.
EDIT: Thks Noel
Edited by BeachBum - January 23 2009 at 10:40
__________________
Pete - X10 Oldie
|
| Back to Top |
|
| |
nadler
Super User
Joined: February 25 2006
Location: United States
Online Status: Offline
Posts: 354
|
| Posted: January 23 2009 at 10:12 | IP Logged
|
|
|
Copy and paste to the multi-editor. A second tool bar
appears with all the multi-editor's functionality. Make
sure you are in SQL as opposed to the other options.
Click on execute and viola the macro will appear in you
list of macros. If you click execute a second time you
will get an error message indicating the macro name is
already being used.
Noel
|
| Back to Top |
|
| |
GadgetGuy
Super User
Joined: June 01 2008
Location: United States
Online Status: Offline
Posts: 942
|
| Posted: January 23 2009 at 15:06 | IP Logged
|
|
|
Thanks. That worked.
How about the inverse to this action? What does one do
to be able to share macros. I don't spot a SQL Export
function in the editor.
__________________
Ken B - Live every day like it's your last. Eventually, you'll get it right!
|
| Back to Top |
|
| |
BeachBum
Super User
Joined: April 11 2007
Location: United States
Online Status: Offline
Posts: 1880
|
| Posted: January 23 2009 at 16:15 | IP Logged
|
|
|
"Export" right click in the right pane.
__________________
Pete - X10 Oldie
|
| Back to Top |
|
| |
GadgetGuy
Super User
Joined: June 01 2008
Location: United States
Online Status: Offline
Posts: 942
|
| Posted: January 24 2009 at 07:16 | IP Logged
|
|
|
Pete - Right-Click in what pane?
It is not the macro window, unless I'm not seeing all the context menue items there for some reason.
If it is the Multi-Edit SQL window then I'm still stumped as my question is how do you get the SQL sequences in the first place.
That is if all I have is a macro, how do I turn it into an SQL sequence to share with others?
__________________
Ken B - Live every day like it's your last. Eventually, you'll get it right!
|
| Back to Top |
|
| |
TonyNo
Moderator Group
Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
|
| Posted: January 24 2009 at 08:49 | IP Logged
|
|
|
You Export the macro from the top Macros window by right clicking on the macro name in the list in the right-pane.
In the PH Explorer, click on Macros.
|
| Back to Top |
|
| |
BeachBum
Super User
Joined: April 11 2007
Location: United States
Online Status: Offline
Posts: 1880
|
| Posted: January 24 2009 at 09:59 | IP Logged
|
|
|
Ken, sorry for the lack of detail. PH Explorer – left click on Macros (name NOT plus) – right click on the Macro (name) and select Export. You will be given an opportunity to Save As.
__________________
Pete - X10 Oldie
|
| Back to Top |
|
| |
Active Topics 
Memberlist 
Search 
Help
Register 
Login
PowerHome Messageboard : PowerHome Programming
Topic: How to Use SQL Editor
