iSeries Web Applications

John Quarantello, IBM iSeries Tools executive recently attended a PlanetJ hosted WOW demonstration.  Here is what he had to say:  "PlanetJ's webinar on WOW was one of the best presentations and demo's I've seen from an iSeries Tools partner.”  Register for a WOW demo today!

 

We are proud of our partnership with IBM!  WOW is Server Proven and a part of IBM’s Roadmap for Developers.

 

PlanetJ powers rapid application development with WebSphere Express.  See the .pdf here. 

Check out the next set of PlanetJ online classes—become a WOW programmer in two short days!!

PlanetJ teams with IBM to promote WOW and iSeries middleware

Do you have a question to share?  A PlanetJ Expert can answer them.  Anything from installation, configuration, design, SQL, etc. Ask our experts here! 

To remove your name from our mailing list click here

 

Questions or comments: info@planetjavainc..com or call 760-432-0600 

 

Interested in a WOW users group?  Click here.

 

Visit us at:  www.planetjavainc.com

Thanks to Kent Milligan of IBM for presenting to Southern CA User Groups!

WOW for iSeries

Click here to attend  Thursday, July 21st at 11 am PST

 

Click here to attend Wednesday, August 10th at 1 pm PST

 

Meeting Instructions will be sent to you upon registration!

iSeries WebSphere News, Tips, Reviews, Industry Analysis

WOW SQL Tips and Other Cool Stuff

See a WOW Demo!

Register for a Webinar!

On a daily time entry WOW operation, I've used the report break function and it works fine.  I'm trying to sum hours and minutes.  Do you know a way I can do this and account for hours and minutes so if I have more than 60 minutes I can have the hour field incremented? 

 SQL has full date/time arithmetic.  Here is a reference on W3 SQL school for data time math

 

Can I default select field values when using insert to add a record.  If I use the option to enter daily time there is a prompt for technician and date and all of the time for the select date is displayed. The user then sees all of his/her time logged for that date with subtotals.  If I press insert the technician and date should be defaulted to the values initially selected.  How can I do this? 

 Associated Inserts.... for example:   insert into log (technican, datefld, start, end) (??currentTec, ??date, ?, ?)  

See the WOW manual section 10.4.3 - Associated Inserts 

July 2005 Edition

The IT Jungle provides many useful tips and resource information for the iSeries professional.  If you have not accessed this electronic newsletter, please check it out.  We love it!  Here is an article recently published that we would like to share with you—Why SQL, Why Now?

 

http://www.itjungle.com/fhg/fhg011404-story01.html

 

By learning SQL, improve your WOW proficiency and ability to create your applications quickly and easily!  Here is another site we found particularly useful:  http://www.w3schools.com/

Why SQL?  This programming language provides users flexibility and power!