SQAPL, ODBC and SAS

General APL language issues

SQAPL, ODBC and SAS

Postby Hannu on Tue Jan 21, 2014 11:00 am

Hi! I'am using Dyalog 12.1 Classic, SQAPL and ODBC inteface to read from SAS data sets and write data to SAS data sets. Reading the data is much more quicker than writing it from APL using SQALP. For intance, to read a 50 000 x 4 -matrix of integers takes only 0.017 minutes but writing it back to SAS takes 3.267 minutes! Reading is done by SQADo (simple select) and writing: SQADo, SQAPrepare and SQAExecN.
Some options for SQAConnect (MaxRows, Blocksize, Cache) seems to have only tiny effect.
[From the SAS driver support http://support.sas.com/documentation/cdl/en/odbcdref/64777/PDF/default/odbcdref.pdf I found that the function SQLPutData is not supported by SAS.]

Is there any tricks to make the writing process more efficient? Or should I consider something else than ODBC here?

Thanks in advance!
Hannu
 
Posts: 5
Joined: Tue Jan 25, 2011 1:21 pm

Return to Language

Who is online

Users browsing this forum: No registered users and 1 guest