Good idea !! This sounds feasible, I'll give it a go on Monday and let you know how it goes. However I think there is still one potential issue which I forgot to mention earlier. Some of the parameters to the SQL script need to bee macro variables.
... View more
Thanks SAS Kiwi, Yes it produces a very large result set. Also, inserting the code between braces is not practical because as I mentioned, some of these queries are 5000+ lines long. regards K
... View more
I have a number of large SybaseIQ SQL scripts (5000+ lines each). The READ statement for each contains a number of parameters. Is there a way to execute the READ through the Proc SQL procedure using the SAS/ACCESS for SybaseIQ interface? many thanks in advance K
... View more
