Midrange News for the IBM i Community


Posted by: ssammik
SQL server database
has no ratings.
Published: 06 Sep 2012
Revised: 23 Jan 2013 - 4112 days ago
Last viewed on: 26 Apr 2024 (4747 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

SQL server database Published by: ssammik on 06 Sep 2012 view comments(5)

My company is in the process of getting new software. I have been told to learn how to access the SQL server database from an RPG program. Does anyone have experience with this process. I do not know anything about SQL databases, when I goggle it I get a lot of topics on MySQL but I am not sure if this is the same thing. Thanks for any help.

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS

(Sign in to Post a Comment)
Posted by: Ringer
Premium member *
Comment on: SQL server database
Posted: 11 years 7 months 20 days 9 hours 33 minutes ago

Read this: http://www.scottklement.com/jdbc/

Chris Ringer

Posted by: ssammik
Premium member *
Comment on: SQL server database
Posted: 11 years 7 months 19 days 16 hours 38 minutes ago
Thanks Chris, this looks like what I need
Posted by: clbirk
Premium member *
Comment on: SQL server database
Posted: 11 years 7 months 19 days 14 hours 39 minutes ago
typically when folks say SQL server, they are referring to Micro$oft's SQL server, which primarily runs on a windows platform. You will see it abbreviated as MSSQL at times.
Posted by: clbirk
Premium member *
Comment on: SQL server database
Posted: 11 years 7 months 18 days 12 hours 19 minutes ago
another means to access the information is through web services. You set up on the server a page that will respond back with the information you need to know. Then from your rpg program, you make a call to that webservice and get back the information. YOu could get it back as xml or as not. Example, when we are doing a phone order, we need to know the amount left on a person's gift card (assuming they are paying with it). So I make a call to a webservice and it returns the amount that is left. That call would be done with software like isockets or brad stone's (www.bvstools.com) geturi tool for example.
Posted by: ssammik
Premium member *
Comment on: SQL server database
Posted: 11 years 7 months 15 days 16 hours 34 minutes ago

I downloaded the code and since I am not familiar with Java I am having trouble understanding some of the code.  Maybe I need to get a Java book, it might help.  Anyway can anyone tell me the difference between programs JDBCTEST3 and JDBCTEST4?  Thanks