April 19th, 2022
If you’ve ever had to export AS/400 data to an Excel file, the process may have looked something like this:
- Create an AS/400 query to extract your data.
- In the query, send the results to an output file.
- Use Access Client Solutions (ACS) to download that output file to an Excel file on your PC.
With the ACS Run SQL Scripts feature, though, you can make that process even easier. After running an SQL script to select your data, the output is displayed in the results window on the bottom portion of your screen. To create an Excel file, simply right-click on the result data and select “Save Results…” to save the results to any number of file types, including Excel. (If the Save Results option isn’t enabled, you can enable it with Settings/Preferences or Options > Enable Save Results, depending on your ACS version.) You’re welcome!
April 28th, 2021
In addition to attending EXPO in person, Silveredge Consulting will also be presenting a session at Common NAViGATE 2021! Silveredge’s Doug Artis will present a session on Dashboards: The Case for KPI’s and Business Users on Wednesday, May 26th at 9am!
Doug will demonstrate the WHY of graphical user interface based dashboards – how they connect the technical programmer’s point of view with the various business needs of management within a company. Illustrations of relevant models within an organization will be shown as examples.
EXPO
And as always, don’t forget to stop by and say hi to Silveredge at EXPO on May 24th & 25th! Network and meet with colleagues and vendors, including Silveredge. Ambrose Marton (co-founder) and Doug Artis (consultant) will be there in person. Don’t hesitate to let us know how we may be able to help you. In addition to stopping by for a chat, we can set up zoom meetings on the fly for a more personalized experience. No matter what challenges you are facing, chances are – we’ve done that!
More Information
For more detailed information including registration info, please visit COMMON NAViGATE 2021 Conference & Expo – IBM Power Systems Education.
We can’t wait to see you there!
April 27th, 2021
Finally, COMMON NAViGATE 2021 is here! This spring’s conference will be a hybrid of in-person and virtualized sessions and will be just as thought-provoking as ever. The conference will take place in Columbus, OH from May 24th through 26th. Like previous events, this is a great opportunity for AS/400 education and networking!
In addition, Silveredge’s Doug Artis will be presenting a session on Dashboards: The Case for KPI’s and Business Users on Wednesday, May 26th at 9am! Users will be exposed to the WHY of graphical user interface based dashboards in an effort to bridge the technical programmer’s point of view with the various business needs of management within a company. Instances of appropriate templates in an organization will be shown as examples.
Overview
Over 100 speakers will present over 250 quick-hit sessions covering areas to help your company get the most out of your investment in the AS/400 system and for you to advance your professional development.
There’ll be sessions covering areas to enhance your skills, such as: Application Development; Business and Personal Development; Database; Hardware; Middleware; Security; Systems Management and Security. Pick one area or engage in sessions from multiple areas, whichever works best for you.
EXPO
This year’s EXPO promises to be as exciting as ever! EXPO is always an exciting networking opportunity to meet with IBM collegues and vendors, including Silveredge. We’ll be attending in person, so please stop by our booth and say hi to Ambrose Marton (co-founder) and Doug Artis (consultant).
Let us know how we may be able to help you. In addition to stopping by for a chat, we can set up zoom meetings on the fly for a more personalized experience. No matter what challenges you are facing, chances are – we’ve done that!
More Information
For more detailed information including registration info, please visit COMMON NAViGATE 2021 Conference & Expo – IBM Power Systems Education.
We can’t wait to see you there!
August 28th, 2020
At long last, COMMON POWERUp20 is finally here! This year’s conference has been rescheduled and virtualized and promises to be just as engaging as ever. The conference will run virtually from September 14th through 17th, with workshops following on September 18th. As always, this is a great opportunity for AS/400 education and networking!
Overview
Over 100 speakers will present over 250 sessions covering at least 15 areas to help your company leverage your investment in the AS/400 system and for you to advance your IT skills and career. (Yes, we know that it is no longer the AS/400. Problem is: search engines show everyone still searches on AS/400 rather than the re-names!)
There’ll be sessions covering areas to enhance your technical skills, such as: Application Development; Business Development; Database; Internet of Things (IoT); Middleware; Open Source Languages; RPG; Security; Systems Management; Virtualization; and Web Applications. Focus on a single area or participate in sessions from multiple areas, whichever works best for you.
EXPO
All of this means this year’s EXPO will be more exciting than ever! EXPO is an incredible networking opportunity to meet with IBM i peers and vendors, including Silveredge. Stop by our virtual booth and say hi to Sue Boers (President), Ambrose Marton (co-founder), and some of our consultants. With the number of hours available to you, we should be available most of the time in addition to the Expo hours.
Let us know how we may be able to help you. In addition to chat, we can set up zoom meetings on the fly for a more personalized experience. No matter what challenges you are facing, chances are – we’ve done that!
More Information
For more detailed information including registration info, please visit COMMON POWERUp20 Conference & Expo – IBM Power Systems Education.
We look forward to seeing you there!
March 18th, 2020
We have been informed by the conference organizers that they will not hold the Summit in Dallas from March 24th – 26th as scheduled. We’re sure this must have been a difficult decision for Susan Gantner, Jon Paris, and Paul Tuohy. The System i Developer folks care deeply about the iSeries community and we know this must have been a hard choice to make, but the right one for sure.
But stay tuned! When we learn any new details, you’ll be the first to hear about them!