Midrange News for the IBM i Community


Posted by: ssammik
SQL server database
has no ratings.
Published: 06 Sep 2012
Revised: 23 Jan 2013 - 3785 days ago
Last viewed on: 03 Jun 2023 (4465 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: 10 years 8 months 29 days 29 minutes ago

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

Chris Ringer

Posted by: ssammik
Premium member *
Comment on: SQL server database
Posted: 10 years 8 months 28 days 7 hours 34 minutes ago
Thanks Chris, this looks like what I need
Posted by: clbirk
Premium member *
Comment on: SQL server database
Posted: 10 years 8 months 28 days 5 hours 35 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: 10 years 8 months 27 days 3 hours 15 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: 10 years 8 months 24 days 7 hours 30 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