57992 - "Access Violation" errors might occur when multiple tables are joined with the UNION operator in SAS® Scalable Performance Data Server

Problem Note 57992: "Access Violation" errors might occur when multiple tables are joined with the UNION operator in SAS® Scalable Performance Data Server

Modify the macro variables to match your environment setting before submitting the code.

%let dom=spds51;
%let host=myhost.domain;
%let portno=5200;


libname foo sasspds "&dom" host="&host" serv="&portno" user='admin' password='secret' IP=YES LIBGEN=YES;

data foo.class;
 set sashelp.class;
run;

%macro crttab (n_unions);

proc sql;
 create table work.class as
   select * from foo.class
%do i=1 %to &n_unions;
	 union
	select * from foo.class
%end;
;
quit;
%put Unions &n_unions: sqlrc=&sqlrc syserr=&syserr syscc=&syscc; 
%mend;

%crttab(14);

Product Family	Product	System	Product Release		SAS Release
Product Family	Product	System	Reported	Fixed*	Reported	Fixed*
SPDS	SAS Scalable Peformance Data Server	HP-UX IPF	5.1 HF4	5.1 HF6
		64-bit Enabled Solaris	5.1 HF4	5.1 HF6
		64-bit Enabled AIX	5.1 HF4	5.1 HF6
		Windows 7 Professional x64	5.1 HF4	5.1 HF6
		Windows 7 Enterprise x64	5.1 HF4	5.1 HF6
		Microsoft Windows Server 2012 R2 Std	5.1 HF4	5.1 HF6
		Microsoft Windows Server 2012 R2 Datacenter	5.1 HF4	5.1 HF6
		Microsoft Windows Server 2012 Datacenter	5.1 HF4	5.1 HF6
		Microsoft Windows Server 2008 for x64	5.1 HF4	5.1 HF6
		Microsoft® Windows® for x64	5.1 HF4	5.1 HF6
		Linux for x64	5.1 HF4	5.1 HF6
		Solaris for x64	5.1 HF4	5.1 HF6

Type:	Problem Note
Priority:	high

Date Modified:	2016-04-13 09:13:48
Date Created:	2016-04-04 11:01:24

Support

Problem Note 57992: "Access Violation" errors might occur when multiple tables are joined with the UNION operator in SAS® Scalable Performance Data Server

Operating System and Release Information