Solved

Linked server on SQL server 2008 R2

Posted on 2012-04-02
3
768 Views
Last Modified: 2012-04-02
I've linked our iSeries to our SQL server.  I've created a view with this:

Create View View_name as
 
SELECT *
 FROM [10.1.1.253].[S10778CE].[AIR400].[AGENT]

Where would I find this view?
0
Comment
Question by:bergertime
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 18

Accepted Solution

by:
Dave Ford earned 250 total points
ID: 37797285
As far as I can see, that view would live in your SQL Server box. It just references a linked table that points to your iSeries.

Check it out, and let us know what your find.

HTH,
DaveSlash
0
 
LVL 15

Assisted Solution

by:Deepak Chauhan
Deepak Chauhan earned 250 total points
ID: 37797578
This view will be created in your sql server where you created it and you can find it in the view folder of the database i which u run this command.
0
 
LVL 2

Author Closing Comment

by:bergertime
ID: 37797710
Ok.....so sometimes Im a little slow.  Refresh is my friend.  Sorry and thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Powershell error using sql agent job 24 40
Do not display comma when no last name 8 48
TDE for SQL Web Edition 1 40
Datatable / Dates ? 4 31
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question