I want to write to a Teradata database in a WF report and nobody here has ever done that. Can someone provide an example of the code to do this? I did a search and didn't get what I needed.This message has been edited. Last edited by: Ted Michalski,
7.7.02 Windows EXCEL, PDF, CSV, TEXT
August 17, 2010, 08:24 AM
Tony A
Ted,
Look at using SQL passthru - search on SQL UPDATE from the link top right.
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
August 17, 2010, 09:07 AM
Ted Michalski
Thanks Tony, but I misspoke. I need to update a SQL Server database. I found this code but I can't see where it actually writes to the SQL Server table:
TABLE FILE CAR PRINT DCOST RCOST BY COUNTRY BY CAR BY MODEL BY BODYTYPE -*DEFAULT HOLD NAME IS HOLD WHEN AS IS NOT USED ON TABLE HOLD AS HOLDCAR END -RUN MODIFY FILE CAR2 FIXFORM FROM HOLDCAR MATCH COUNTRY CAR MODEL BODYTYPE ON MATCH UPDATE * ON NOMATCH INCLUDE DATA ON HOLDCAR END
7.7.02 Windows EXCEL, PDF, CSV, TEXT
August 17, 2010, 09:33 AM
Tony A
Try this link which is what you should have got from your search on SQL UPDATE.
Also see the code below
SQL SQLDBC
your SQL code which can include INSERT, UPDATE, DROP, CREATE ect. etc. etc.
;
END
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10