RTDM DS2 SQL Example Code

[faisalbasra]

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

[VamsiM]

Hello,

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

Hope this helps. 

[faisalbasra]

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.