LISUG

© Copyright LISUG 2013

Meeting Information


LISUG Meeting Information

Our September meeting:
Wednesday
September 27, 2017

Cocktail and Networking
Hour starts at 6:00pm
Followed by LISUG Q&A
Session and Dinner (7:00pm)

Main Presentation (8:00pm):
SQL Views for Dummies

presented by

Scott Forstie
SQL views provide the modern user interface to obtain system level information traditionally available via OUTFILE and API support. Attend this session and learn how easy it is to use a SQL view. SQL views provide the administrator of the system easy access to lots of system configuration and management information. This session will provide a list of available SQL views and their purpose as well as examples of how to use them. I will explain how the examples work and you'll leave with the skills necessary to be a better and more system administrator. This is not an introduction to SQL class, but rather an explanation of why you need to add SQL to your toolset and a quick-start guide showing you how to become a better systems administrator or security officer.

 

Presession (5:00pm):
SQL for the Security Officer

presented by

Scott Forstie
The pressures and expectations for the security officer have never been higher. Come to this session to learn how to use SQL to accomplish critical security tasks, including the ability to easily automate security policies. You do not have to be an SQL expert to gain something from this session. I will give you examples that you can take back and use. In the session, I will explain how the examples work and you'll leave with the skills necessary to be a better and more productive IBM i security officer.

 

Main Presentation (8:00pm):
ACS Run SQL Scripts & Other DB2 for i Tools Re-invented

presented by

Scott Forstie
With the demise of the iAccess for Windows and it not being supported on Windows 10, we needed to come with new interfaces and tools to help the database engineer (DBE) do their job. This session will introduce the brand new Run SQL Scripts interface, show a number of live Demos as well as other tools centric to the success of the DB Engineer. The session will also include and explanation and demonstration of all the database tooling that has been added to this java-based tool.

 

© Copyright LISUG 2013

Meeting Location

The Westbury Manor is located at 1100 Jericho Turnpike Westbury, NY 11590. (see map at bottom).  Their telephone number is (516) 333-7117.  
Please note: the restaurant does NOT take reservations for the LISUG meeting.

© Copyright LISUG 2013

Meeting Prices

Meeting Prices

General Meeting Fees

 

- Member

- Non-Member

- Annual Prepay

At the Door (Cash/Check)

 

$65

$85

$580

Advance Payment (PayPal)

 

$60

$80

$580

Annual Membership
$75
$75

Annual  Prepay

This option includes a annual LISUG Membership , prepaid attendance at 8 General Meetings and the Annual Education Day , and can be paid by cask, check, or PayPal.The savings for this option includes the $75 Membership Fee , and $25 per meeting (based on the Non-Member rate), for potential annual savings of approximately $300. This option can also be shared by different employees of the same company.

Annual Membership

An annual LISUG Membership represents a savings of $20 for each meeting attended and includes the members-only participation in LISUG's group memberships in LISTnet and COMMON.

© Copyright LISUG 2013

Registration

Registration information

Registration link is not currently available, Please try later

© Copyright LISUG 2013

Membership

Effective September 2013 LISUG has decided to revert back to an annual membership Starting in September. If you have been part of the "rolling 12 month membership" or you would like to join LISUG in a month other than September, your annual membership cost will be the following:

  Month  
  September $75 (Save $105)  
  October $70 (Save $90)  
  November $65 (Save $75)  
  December $60 (Save $60)  
  January $55 (Save $45)  
  February $50 (Save $30)  
  March $45 (Save $15)  
  April $40 (Break Even)  
  May $75, with membership through to the following August  

Note: Savings are based upon attending all of the remaining meetings at renewal time.
We have also changed the new and renewing Membership process. It is now simply an option on the Registration Page for each meeting.
 
Here is a summary of current LISUG Membership benefits:

Annual Pre-pay Members (who save $300 per year) will continue to receive their membership free as part of the Annual Pre-pay package

© Copyright LISUG 2013

Tips

Technical Tips
The REXX Calculator Pre-Loaded Loops The Source Debugger - A Technical Tip Three AS/400 Technologies vs. One Problem Configuring PASSTHRU with a LAN How To Retrieve Your CL Program's Name AND Library (ILE) Testing for Omitted Parameters How To Sort a Data Structure on One or more Subfields (in memory) The new GUI iSeries debugger How to prevent iSeries Access Emulator from disconnecting when used remotely Displaying the attribute characters on your Green Screen Case-Insensitive Programming Debugging in 132-column mode Summary Files Using SQL iSeries Navigator Does SQL and More Allow a User without *ALLOBJ Special Authority to View a User's Active Job Log That Does Have *ALLOBJ Special Authority My Favorite BIF (Built-In Function):  %dec

© Copyright LISUG 2013

About Us

About Us

LISUG (the Long Island Systems Users Group) was originally formed in 1984.  Started originally as the Long Island System/38 Users group by a number of System/38 users and with IBM's help, it has become one of the largest and most technical user groups in the country.  When IBM announced the AS/400, LISUG decided to drop its System/38 name to become the Long Island Systems Users Group, now chartered to advance the knowledge of all computer users on all platforms.

LISUG hosts dinner meetings at the Fox Hollow Inn in Woodbury, NY (call (516) 921-1415 for directions) usually on the third Wednesday of each month September through June (no meetings held during July and August unless a special meeting is convened by the Board of Directors).  The meetings begin at 6 PM and end about 9:30 PM. The format of the meeting is a cocktail hour from 6 - 7 PM, with scrumptious hors d'oeuvres and open bar (use this time to network with your peers), followed by a sit down dinner beginning at 7 PM (during dinner we have a Q/A session that is most interesting), sometimes we are treated to a wonderful buffet!  The balance of the meeting (usually 8 PM - 9:30 PM) our speaker gives his/her presentation (stay after the presentation and quiz the people that are developing the latest hardware and software technologies!).  LISUG attracts some of the industry's top speakers, including folks from IBM Rochester and Toronto labs.

Reservations for the dinner meeting are not required, but are appreciated.  To make your reservation, please click on the meeting registration link.

You do not need to join LISUG to attend its meetings, however, there is a monetary incentive to do so!  You can save up to $100.00 as a member attending all 10 meetings.  Members pay $65.00 a meeting whereas non-members pay $85.00 (saving $180.00).  You can save an additional $50.00 annually if you pre-pay your meeting fees.  Members also benefit because LISUG is a member of the national IBM user group COMMON, so if your organization is not a member of COMMON but do attend its conferences this can save your company hundreds of dollars on COMMON registration fees.

So! Check us out, come to a meeting, query our Directors and Officers, question the expert speakers, save time and money while advancing your knowledge and career!!

 

Should you need to send mail to LISUG please use the following address:
LISUG
57 Ira Road - Suite 101
Syosset NY 11791-3504

© Copyright LISUG 2013

Code of Ethics

Code of Ethics
  1. There Shall be No Vendor Initiated Sales Contacts with Attendees at USERS GROUP Meetings.
  2. There Shall be No Vendor Displays at Meetings Unless Approved by the Board of Directors in Advance.
  3. There Shall be No Vendor Sales Presentations Initiated at Any Regularly Scheduled Meetings Unless Approved by the Board of Directors in Advance.
  4. Sales Notices of Any Type are Not to be Placed on Bulletins Boards, Left on Tables, or Made Publicly Available.
  5. Offers of Employment are Not to be Made at Any Time at Meetings.

© Copyright LISUG 2013

Board of Directors

LISUG Officers
President
Mike Jacobs .

Executive Vice President
Rick Amato 631-588-9500

Vice President
Anne Schnarwyler-Cognato 631-436-6558

Treasurer
Mark Giordano 516-326-1350

Secretary
Don Johnston 516-236-5441

LISUG Board of Directors
Alan Baisch
631-750-2087

Allen Brunette
.

Charles Guarino
516-932-3200

Charles Kaplan
516-458-3080

Perry Molina
516-428-9466

Steve Wolk
.

Full Web Site

Full Web Site
Lisug.org Web Site

Welcome to LISUG


IBM i for Business
Welcome to the
Long Island System User's Group.
We are an organization dedicated to the education of system professionals that utilize the IBM power platform including AS/400, iSeries, and System i. Our meetings are held once a month (with the exception of June, July and August). The meeting format usually consists of a pre-meeting followed by a cocktail hour, which is then followed by dinner and the main presentation. In the month of May we usually hold our May Education day in which the format is different. Our wide variety of speakers and members provide for a very interesting and knowledgeable experience. Should you have any questions, you may contact one of our organizations directors or board members who can assist you.

Membership Benefits

There are many benefits to becoming a member of LISUG. These benefits include the following.

Meeting Dates

<<< LISUG Meeting Dates 2017 >>>
General Speaker Topic Board
01-18-2017Pete Massiello/
Pete Massiello
Using iNavigator to make you a RockStar System Administrator
What you need to know to upgrade to 7.2 or 7.3
01-25-2017
02-22-2017Patrick Behr/
Patrick Behr
How to setup Wordpress to begin your own blogging site
Shallow Dive into Database modernization
03-01-2017
03-2017No MeetingNo Meeting03-2017
04-26-2017Robin Tatam/
Robin Tatam
IFS Security
State of IBM i Security
05-03-2017
05-17-2017Ted Holt/
Liam Allan/
Liam Allan
Fun!(damental) and Fun!(ctional) Table-Driven Programming
Open Source ILE Concepts
Open-Source Tools for RPG/ILE Development
05-31-2017
06-2017No MeetingNo Meeting06-2017
07-2017No MeetingNo Meeting07-2017
08-2017No MeetingNo Meeting08-2017
09-27-2017Scott Forstie/
Scott Forstie/
Scott Forstie
SQL Views for Dummies
SQL for the Security Officer
ACS Run SQL Scripts & Other DB2 for i Tools Re-invented
10-04-2017
10-18-2017

10-25-2017
11-15-2017

11-29-2017
12-06-2017

12-13-2017