Default APL Types in SQAPL

General APL language issues

Default APL Types in SQAPL

Postby paulmansour on Thu Feb 26, 2015 4:40 am

When doing a query using SQAPL, the ODBC data types are converted to certain APL types, unless the statement uses bind variables in either an inline or matrix form, in which case the types will be cast as specified.

What if you want to change the defaults? For example, I might like all of the defaults except that I want ODBC BigInts to be cast to 1287 (G) instead of Float.

I don't think I can reasonably do this with bind variables, because (in my case) I don't know ahead of time the name of the columns, or the details of the select statement. I just know I get back a result set and that I would, say, prefer that any BigInts be mapped to 1287, and maybe dates be brought back in one of the numeric forms rather than text.

So, is there some way to do this?
Posts: 375
Joined: Fri Oct 03, 2008 4:14 pm

Return to Language

Who is online

Users browsing this forum: No registered users and 1 guest