[SOLVED] SQL Insert

Can someone please help me with the syntax to run a SQL command which returns a result set and then insert it into a predefined master file table. This will give you an idea of what I am trying to do.

ENGINE SQLMSS SET DEFAULT_CONNECTION DevSalesDB
SQL SQLMSS
EX pss_GetMarketAnalysis 29645, 20723,0,0,1,0,'';

-RUN
SQL
INSERT INTO pss_getmarketanalysis (contractID, contractTermID) VALUES (contractID,contractTermID)

-RUN

This message has been edited. Last edited by: Kerry,

Posts: 118 | Location: Wisconsin | Registered: January 16, 2008

<JG>

posted

something along the lines of

 
ENGINE SQLMSS SET DEFAULT_CONNECTION DevSalesDB
SQL SQLMSS
EX pss_GetMarketAnalysis 29645, 20723,0,0,1,0,'';
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD FORMAT ALPHA
END
-RUN
-READ HOLD &contractID.An. &contractTermID.An.
SQL
INSERT INTO pss_getmarketanalysis (contractID, contractTermID) VALUES (&contractID.EVAL,&contractTermID.EVAL)
END
-RUN

Where n is the length of the column

Tony A

Expert

posted

Hide Post

Don't forget the semi colon and the TABLE FILE SQLOUT etc.

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

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Show Post

Waz

Expert

posted

Hide Post

For the Insert step, you could also use MODIFY or MAINTAIN

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!