On the mainframe you have line 5 and 6 Line 5 is telling proc sql to connect to DB2 Line 6 is telling proc sql sql to create a sas table in the sas environment Than it continues to do a sql statement on that connection returning the count from a db2 table named db2acpt.client_adress There is a conversion db2 to sas included not everything is running in db2. These two instructions are not there in your converted pc code approach. It goes from line 380 to 381. What is left is a syntax correct coded statements without any input and without output. Runs correctly and it does nothing. No error no warning as you have that coded correct. I expect you are needing more settings options as just that said. When lucky somebody has set that for you. When not you have to solve that first. Defining a libname as db2acpt.client_adress to that schema is the most reliable way to do. When you have that working it is easy coding getting the os count like reeza did for the sashelp datasets. This should be as good as the coding with that connect instruction. SAS has to convert that to the correct db2 approach as implicit pass through.
... View more
Cynthia, oops, thanks! I will open ask via the link provided! FYI...This issue is showing in ZOS, most if not all the attributes are the same defaults. I am sure there are some new ones in version 9.
... View more