Viewing 7 posts - 16 through 22 (of 22 total)
Phil makes a good point. There are in fact some slight syntax differences between SQL Server and DB2. If you ever decide to make the jump to SQL...
October 21, 2009 at 7:19 am
What version of SQL Server are you using?
October 20, 2009 at 4:25 pm
Let's try something a little simpler to verify the syntax and connection.
Create a CL program that sends a break message to your profile. Make sure the CL runs and...
October 20, 2009 at 3:43 pm
Within SQL Server, under Linked Servers, expand Providers.
Locate IBMDASQL and select Properties.
Make sure "Allow InProcess" is CHECKED.
Also, select Properties of your as400 linked server and verify the following...
Data Access =...
October 20, 2009 at 2:01 pm
My bad .. varchar needs to be at least big enough to hold your string. Try 256 and see if that helps.
October 20, 2009 at 1:36 pm
Have you tried ...
UPDATE IC1480BFPD.XROHUB
SET XUBCUNO = '72065795'
WHERE XUBCUNO = '7206579'
October 20, 2009 at 1:12 pm
try using a T-SQL task within SSIS.
You will need to setup a Linked Server to your AS400.
DECLARE @VAR1 VARCHAR(100)
SET @VAR1 = 'SBMJOB ....'
EXECUTE (@VAR1) AT [AS400]
October 20, 2009 at 12:57 pm
Viewing 7 posts - 16 through 22 (of 22 total)