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

New to using OPENQUERY. Need a small example of how to grab, convert, pass data to SQL.

I'm very new to using IBM Syntax, specifically a need for OPENQUERY.
I would appreciate it if someone could show me a small example of how to grab, convert, pass data to SQL.
I listed exactly what I'm trying to do below. Many thanks to whoever could help. :)
Wally
---------------------------------------------------------
SOURCE IBM DB2 DATABASE I want to convert/pull data from:
---------------------------------------------------------
IBM DB = SD0D1, Two Tablenames = Dist_State & Dist_State_Nodes. 
Two Columns (data I want to convert/import). Column 1 = Dist_State.LABEL (Unicode String, Length = 32) Values contained here are just application names (i.e. MSOFFICE). Column 2 = Dist_State_Nodes.Node_Name (Unicode String, Length = 251). Values contained here are Computer Name (i.e. JOESPC).
 
---------------------------------------------------------
DESTINATION SQL DATABASE I want to Convert/Import data to:
---------------------------------------------------------
SQL DB Name = DMS, Two Tablenames = Dms.dbo.Node.Name (Varchar(75), not null) &  Dms.dbo.Packages.Name (Varchar(251), not null). 
Both of these columns will need to have an PK/Identity Seed.
 
I need to figure out how to use OPENQUERY to convert/import data by getting data from
(DB2) Dist_State.LABEL --> (SQL) Dms.dbo.Packages.Name db/table/column AND
(DB2) Dist_State_Nodes.Node_Name --> (SQL) Dms.dbo.Nodes.Name.

Open in new window

0
wally_davis
Asked:
wally_davis
  • 2
  • 2
1 Solution
 
momi_sabagCommented:
what do you mean by the identity seed?
0
 
wally_davisAuthor Commented:
By Identity Seed I mean Auto Row numbering.
0
 
momi_sabagCommented:
take a look here
http://www.mcpressonline.com/database/db2/db2-integration-with-sql-server-2005-part-i-linked-server-enhancements.html

regarding the identity columns, just define them as you would with any other table
0
 
wally_davisAuthor Commented:
Momi, Thank you for the link. It gives a a nice place to start.
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

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