topic Re: RTDM DS2 SQL Example Code in SAS Customer Intelligence

RTDM DS2 SQL Example Code

faisalbasra — Mon, 13 Nov 2017 09:55:32 GMT

Hello,

I need to execute a complex SQL query which data process can't handle. I have searched a lot but unfortunately can't find a complete example how I can execute such SQL query in DS2 SAS Process.

I would be very thankful if anyone shares any concrete example.

Thanks

Re: RTDM DS2 SQL Example Code

VamsiM — Wed, 22 Nov 2017 21:11:45 GMT

Hello,

Here is an example of using a Sql Statement to query a DBMS.

Hope this helps.

Re: RTDM DS2 SQL Example Code

faisalbasra — Thu, 23 Nov 2017 06:19:42 GMT

Thanks very much Vamsi for sharing DS2 code example.

As I'm new to RTDM, would you like to give some more help? I will be really thankful to you.

Here I'm looking for some more help.

What steps are required in Fed Server before running this code example? I have setup Libs in SMC, and they are accessible in CI Studio.
Where we define the values used in the following connection statement,
proc ds2 nolibs noprompt="driver=remts;server=&server;port=&port;protocol=bridge;uid=&user;pwd=&passwd;conopts=(driver=ds2;conopts=(driver=sql;conopts=(DSN=&DSN)))";

Looking for your kind reply.