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
173 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 500 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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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 have developed many web applications with asp & asp.net and to add and use a dropdownlist was always a very simple task, but with the new asp.net, setting the value is a bit tricky and its not similar to the old traditional method. So in this a…
Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

695 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