Focal Point
[CLOSED] DBMS connection in Procedure

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/1547048176

July 24, 2014, 12:43 PM
Karthik
[CLOSED] DBMS connection in Procedure
Hi,

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 CON02

This message has been edited. Last edited by: Clif,
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.