Connect With Us

Database/SQL

RSS
paul-tuohy-sql-teacher

SQL Awesomeness Explained: Paul Tuohy Answers Our Qs  

  • Mar 14, 2014
    video
    iPro Developer

    Session 5: How to use the Microsoft JDBC driver on the IBM i  

    In the final session, you'll learn how to configure and use the Microsoft JDBC driver on your IBM i to connect to your SQL Server. You will work with a sample Java application that runs on your IBM i to read and modify data on the SQL Server. Once you know how to install, configure, test and debug a JDBC connection from your IBM i to SQL Server, you will be able to use tools in RPG (for example, Scott Klement’s JDBCR4 programs) to access SQL Server through the JDBC driver. You do not need to know the Java programming language to benefit from this session; the complete sample code is included, along with instructions on how to install and run the program on your IBM i....More
  • Mar 14, 2014
    video
    iPro Developer

    Session 4: Work with the SQL Server Import and Export Wizard  

    In this session, you'll learn how to work with the SQL Server Import and Export Wizard to quickly develop data transfer applications. You will work with the DtExecUI and DtExec programs to run a saved data transfer application, and you’ll learn how you can use the SQL Server Agent to run data transfers on a schedule....More
  • Mar 14, 2014
    video
    iPro Developer

    Session 3: The SQL Server Model Database, Logins, and Schemas  

    In this session, you will learn about the model database that is included with SQL Server, and what you need to know about creating and working with user-defined databases. You’ll see how to define and work with schemas within a database and how to control authorization to database objects....More
  • Mar 14, 2014
    video
    iPro Developer

    Session 2: Work with Linked Servers  

    In this session, you'll learn how to create a linked server on SQL Server to connect to your IBM i. You'll see how to replicate data from your IBM i to SQL Server or from SQL Server to your IBM i, using the linked server. You'll also learn about some of the tools that are provided with SQL Server to manage its configuration and usage and how to use scripting tools within SQL Server to create script files. You will also use the SQLCMD command line tool and the SQL Server Agent to create scheduled jobs that you can use to run the scripts that you develop....More
  • Mar 7, 2014
    video
    iPro Developer

    Session 1: Install, Configure and Connect to SQL Server  

    To get started, you'll see how you can install SQL Server on your PC for development and testing. You'll learn how to use the IBM i Database providers, supplied with every IBM i, to connect your IBM i to SQL Server. You'll also get a high-level overview of some of the major features of SQL Server, with particular emphasis on how those features relate to working with the IBM i database. In the lab, you will create and run a query within SQL Server to prove that you have a connection to your IBM i....More
iPro Forums

Get answers to questions, share tips, and engage with the iPro Community in our Forums.

From the Blogs
Application Modernization Redbook Unleashed
Mar 27, 2014
blog

Application Modernization Redbook Unleashed  

The Application Modernization Redbook draft version has been released! Tim Rowe has the details....More
Free-Form RPG Transformation, Part 2
Mar 19, 2014
blog

Free-Form RPG Transformation, Part 2  

Tim Rowe continues his series on ISV tools for free-form RPG with a look at Linoma Software's free-format transformation tool, RPG Toolbox....More

Sponsored Introduction Continue on to (or wait seconds) ×