Got it. Needed to specify the actual field names in the select statement SELECT IMLITM AS ManuItem......etc. Thanks alot

I'm sorry, I'm having a heck of a time with this. Below is the latest code and error.

USE [MyDB]

GO

/****** Object: StoredProcedure [dbo].[SP_MyProcedure] Script Date: 5/5/2020 1:26:19 PM ******/

SET ANSI_NULLS ON

GO

SET...

OLE DB provider "MSDASQL" for linked server "ISERIES" returned message "[IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0104 - Token . was not valid. Valid tokens: , FROM INTO.".

Msg 7321, Level...

Thanks,

Not working as you described but sends me down a new path