iPro Developer Website & Magazine Forum

iPro Developer Website & Magazine Forum

1,972 members
  • Join

    When you join a group, other members will be able to see your profile and message you. The group logo will be visible on your profile unless you change that setting.

  • Information and settings

Have something to say? Join LinkedIn for free to participate in the conversation. When you join, you can comment and post your own discussions.

Amy

Working with SQL for i

Independent Marketing/Communications Strategist

For those of you interested in doing more with SQL . . . session abstracts for the SQL for i Spotlight conference + workshops (taught by Kent Milligan, Mike Cain, Skip Marchesani, Susan Gantner and Paul Tuohy) are available at http://bit.ly/J7V7bV

What are you doing with SQL right now?

  • Comment (15)
  • April 26, 2012
  • Close viewer

Comments

  • Wayne M.

    Wayne

    Wayne M.

    Application Development Manager at Lustig, Glaser & Wilson, PC

    I think in the System i realm there needs to be more education available that focuses in on the nuts and bolts of advanced SQL concepts. I am talkling specifically about inner and outer joins, the various ways to join files and especially with SQL Update and Delete type of staetments. So far, in all my experience over the last 20 years, and as many conferences both local and national that I have atteneded, no one ever gets this deep.

    Also, please keep in mind that syntax for SQL seems to vary from platform to platform. So the SQL book you might purchase and read does not always apply to SQL on the System i. Same thing for what can be found on the web. It may apply to MySql or Microsofts's SQL or Oracles SQL, but that syntax does not always work on the System i. So yes, I'd like to see some of the "gurus" of SQL put together some really advanced sessions that are System i syntax specific.

  • Kent M.

    Kent

    Kent M.

    DB2 Consultant at IBM

    I've done sessions at past RPG & DB2 Summit conferences that cover many of the advanced join concepts that you mention. The next SQL for i Spotlight will cover the nuances of doing joins with Update & Delete statements

  • Rita-Lyn S.

    Rita-Lyn

    Rita-Lyn S.

    Communications Specialist at Battle Ground School District

    Hi Wayne, you have some great suggestions for article topics and I'm going to look into these right away. We have wonderful authors, including Kent and Scott Forstie, who can cover these for iPro Developer magazine.
    -Rita

  • Wayne M.

    Wayne

    Wayne M.

    Application Development Manager at Lustig, Glaser & Wilson, PC

    Thanks, I look forward to it.

  • James

    James M.

    Project Leader at Gannett Inc. Co

    I use SQL for i as part of Ruby on Rails. It works!

  • David M.

    David

    David M.

    Sr. Programmer analyist at Fike Corporation

    topics like creating FUNCTIONS is also a good subject, i use them for many features that i can't do because its not availble, we are a JDE world shop so julian date conversions are a big thing, i also use procedures created in SQL to interface with ODBC calls for interfacing EXCEL VBA to the iseries rpgle. but i had to learn all of this on my own, but they are very helpful.

  • Amy L.

    Amy

    Amy L.

    Independent Marketing/Communications Strategist

    James, great use! Have you been able to transfer those SQL skills to other types of IBM i development, too?

    And Wayne, you're absolutely right about the i having its own flavor of SQL. It sounds as if you've been working with SQL for i for some time. Where do you find it most useful? Also, based on Kent's comments, you may find the in-depth content you're looking for at the SQL for i Spotlight in Boston - http://bit.ly/J7V7bV. Granted, it's live training rather than the free articles that Rita is looking into providing, and we know budgets can be an issue. But however you end up getting the detailed info you're looking for, kudos for continuing to refine your skills!

Have something to say? Join LinkedIn for free to participate in the conversation. When you join, you can comment and post your own discussions.

Your group posting status

Your posts across groups are being moderated temporarily because one of your recent contributions was marked as spam or flagged for not being relevant. Learn more.

Feedback