?
Solved

Trying to write data to a Linked Server Table on a AS400 from a 2008 SQL Server R1

Posted on 2011-02-18
1
Medium Priority
?
174 Views
Last Modified: 2012-05-11
Hello everyone, thanks for you time.  I have a very unique situation here.  The company i work for has a IBM AS400 that is running Accounting systems on it.  We have a Sales and Marketing system that is running a SQL Server 2008 R1.  I have the AS400 as a linked the server and I can select*from from the table on the AS400 with zero problems.  I have set a blank table on the AS400 and I have a view setup on the SQL Server to add data to the table on the AS400.  I have done all of the PTF updates on the AS400 for the database and the hyper system.  I am trying to write a statement that will select the data from the SQL view and place it in the table on the AS400.  Here is what I have so far.  I am a novice at SQL, I am more of a network engineer.  Any help at all would be greatly appreciate.  The following is the statement I have thus far, that is giving me syntax errors.

SELECT*FROM [TSWDATA_ClientCustom].[dbo].[vw_rb_ar_CreateGLTrans]
            ([GLProject]
           ,[CardType]
           ,[TRType]
           ,[GLMajor]
           ,[SourceDesc]
           ,[TransactionDate]
           ,[PostingPeriod]
           ,[DepartmentSub]
           ,[Amount]
           ,[TransDescription])
    VALUES (<GLProject, varchar(20),>
           ,<CardType, varchar,>
           ,<TRType, varchar(2),>
           ,<GLMajor, varchar(4),>
           ,<SourceDesc, varchar(6),>
           ,<TransactionDate, varchar(10),>
           ,<PostingPeriod, varchar(7),>
           ,<DepartmentSub, varchar(7),>
           ,<Amount, decimal(15,2),>
           ,<TransDescription, varchar(20),>)
INSERT INTO [AS400].[S069E014].[TSW].[GLTRN]
           ([TCOPRJ]
           ,[TCARDT]
           ,[TRTTYPE]
           ,[TMAJOR]
           ,[TSOURC]
           ,[TDATE]
           ,[TPPER]
           ,[TCPTSU]
           ,[TAMT]
           ,[TRDESC])
     VALUES
           (<TCOPRJ, varchar(20),>
           ,<TCARDT, varchar,>
           ,<TRTTYPE, varchar(2),>
           ,<TMAJOR, varchar(4),>
           ,<TSOURC, varchar(6),>
           ,<TDATE, varchar(10),>
           ,<TPPER, varchar(7),>
           ,<TCPTSU, varchar(7),>
           ,<TAMT, decimal(15,2),>
           ,<TRDESC, varchar(20),>)

Thanks again for your time
0
Comment
Question by:PlantationResort
[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
1 Comment
 
LVL 21

Accepted Solution

by:
Alfred1 earned 2000 total points
ID: 35824968
OK.  Try this out:
INSERT INTO [AS400].[S069E014].[TSW].[GLTRN]
           ([TCOPRJ]
           ,[TCARDT]
           ,[TRTTYPE]
           ,[TMAJOR]
           ,[TSOURC]
           ,[TDATE]
           ,[TPPER]
           ,[TCPTSU]
           ,[TAMT]
           ,[TRDESC])
SELECT [GLProject]
           ,[CardType]
           ,[TRType]
           ,[GLMajor]
           ,[SourceDesc]
           ,[TransactionDate]
           ,[PostingPeriod]
           ,[DepartmentSub]
           ,[Amount]
           ,[TransDescription]
FROM [TSWDATA_ClientCustom].[dbo].[vw_rb_ar_CreateGLTrans]

Open in new window

0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I recently went through the process of creating a Calendar Control of events with the basis of using a database to keep track of the dates that are selectable, one requirement was to have the selected date pop-up in a simple lightbox.  At first this…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

771 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