[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 674
  • 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

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