• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 365
  • Last Modified:

Set SQl Server 2008 r2 to As400 in the database folder in Object Exploer

How can I get a table/link in the database folder to the AS400?

Right now I have to write

SELECT fld1, fld2
FROM OPENQURY (ODBC, '
SELECT *
FROM Table1
Where x=2')

ORDER BY fld1
0
jaymz69
Asked:
jaymz69
  • 2
  • 2
1 Solution
 
Kobe_LenjouCommented:
I'm not exacly seeing any problem?

What statement would you like to write instead?
0
 
jaymz69Author Commented:
I was wondering if I could do it in one SELECT
0
 
Kobe_LenjouCommented:
Create the link as a lnked server. Then you can use the 4 part naming.

However technical it doesn't change a thing (depends in the ODBC/middleware component in fact)
0
 
jaymz69Author Commented:
what is the 4 part naming?

I have a ODBC too named that I used for VFP and Access to the AS400 Files
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now