Solved

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

Posted on 2008-09-30
4
652 Views
Last Modified: 2012-08-13
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
Comment
Question by:wally_davis
  • 2
  • 2
4 Comments
 
LVL 37

Expert Comment

by:momi_sabag
ID: 22606956
what do you mean by the identity seed?
0
 

Author Comment

by:wally_davis
ID: 22607011
By Identity Seed I mean Auto Row numbering.
0
 
LVL 37

Accepted Solution

by:
momi_sabag earned 500 total points
ID: 22607754
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
 

Author Closing Comment

by:wally_davis
ID: 31501614
Momi, Thank you for the link. It gives a a nice place to start.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

895 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now