I get the MAX(update_date) from target and store that in control table. In Process flow, I am trying to get the date from control table in procedure and store that in variable. Please let me know where I have give the DBMS credentials to run the procedure in process flow. Also find the below procedure for your reference.
-DEFAULT &CREATEDDATE = '1900/01/01' -DEFAULT &MODIFIEDDATE = '1900/01/01' SQL SQLMSS Select MAX(CREATEDDATE) as CREATEDDATE,MAX(MODIFIEDDATE) as MODIFIEDDATE FROM cafc_stage.controltable WHERE TABLE_NAME = ('stg_sfc_scd');
TABLE FILE SQLOUT "sqlout IS.." PRINT * ON TABLE HOLD END -RUN -READFILE HOLD -TYPE &CREATEDDATE; -TYPE &MODIFIEDDATE; -SET &&MODIFIEDDATE = &MODIFIEDDATE; -SET &&CREATEDDATE = &CREATEDDATE;This message has been edited. Last edited by: Tamra,
WebFOCUS 8.0 Windows, All Outputs
July 25, 2014, 12:11 PM
Clif
You supply credentials in the connection string for MS SQL Server when you configure an adapter.
In your focexec specify a connection name or else it uses the first one, for example:
ENGINE SQLMSS SET SERVER CON02This message has been edited. Last edited by: Clif,
N/A
July 29, 2014, 02:32 AM
Karthik
Thanks for your inputs Clif. Can you tell me what is the SQL engine for Postgres?
WebFOCUS 8.0 Windows, All Outputs
July 30, 2014, 11:02 AM
Clif
SQLPSTGR
After you create the adapter you can find the string in your edasprof.prf or user profile.