The CL Corner: Introducing the New Run SQL Command. (interactively or imbedded within a CL program). RUNSQL SQL('Update SAMPLE. SQL data access, and more.

Hello, I've a syntax problem with our AS400 and our SQL Server 2005. We have a connection via Linked Server, which is used for selects and Updates. For example: ' UPDATE AS400.LINKSTRING.LIBNAME.TABLENAME SET FIELDNAME = '222' WHERE FIELDNAME = '111' out of a SQL query runs fine.

Now I want to execute a CL program on the iSeries. We do this since today with Microsoft Access in a VBA script. Is there any way to execute the CL program in a stored procedure??? I have no idea how to do this (. Like execute AS400.LINKSTRING.LIBNAME.PROGNAME.???) It would be very nice, if someone can help me.

Thanks Joerg. Gianluca Sartori (8/30/2011). Into a stored procedure and then call it from SQL Server.Gianluca Hi Gianluca, thanks for your reply! Ok, if this is a way, I try it.

COuld you say me 'how to start a stored procedure on the AS/400 side out of the SQL Server'? We do some changes in data in the SQL Server, then insert the modified records in AS/400 tables. Then we must start the programm on the AS/400. In the past we do this with triggers in tables (SQL Server change a value in an AS/400 table and the AS/400 program looks every minute into this table if there is a changing and starts then another prog - but this is not a very good way.) Bye Joerg. We do some changes in data in the SQL Server, then insert the modified records in AS/400 tables. Then we must start the programm on the AS/400. In the past we do this with triggers in tables (SQL Server change a value in an AS/400 table and the AS/400 program looks every minute into this table if there is a changing and starts then another prog - but this is not a very good way.) Bye Joerg If it polls a table every one minutes it's not a trigger, but a totally different thing.

Indeed, a trigger could really be a way to implement it. -- Gianluca Sartori. You can't post new topics. You can't post topic replies. You can't post new polls.

You can't post replies to polls. You can't edit your own topics. You can't delete your own topics. You can't edit other topics. You can't delete other topics.

You can't edit your own posts. You can't edit other posts. You can't delete your own posts. You can't delete other posts.

You can't post events. You can't edit your own events. You can't edit other events. You can't delete your own events. You can't delete other events. You can't send private messages.

You can't send emails. You can read topics. You can't vote in polls. You can't upload attachments. You can download attachments. You can't post HTML code. Business 7th edition czinkota andras horvath. You can't edit HTML code.

You can't post IFCode. You can't post JavaScript. You can post emoticons. You can't post or upload images.