Here's a workaround for ddcol if anyone else hits this:
hd=. ;:'TABLE_NAME COLUMN_NAME'
NB. NOTE: code broken by recent changes to
NB. (ddcol) Sep 9, 2021
NB.
NB. d=. PDIprodland ddcol ch
NB. tc=. }.((0{d) i. hd) {"1 d
NB. d=. PDIorgland ddcol ch
NB. tc=. tc , }.((0{d) i. hd) {"1 d
NB. d=. PDIdataland ddcol ch
NB. tc=. tc , }.((0{d) i. hd) {"1 d
NB. hd , tc [ dddis ch
NB. NOTE: alternate based on SQLServer schema
sql=. 'select ',(}.;',' ,&.> hd),' from INFORMATION_SCHEMA.COLUMNS where
TABLE_NAME in '
sql=. sql,'(',(}.;',' ,&.> quote&.> PDIprodland;PDIorgland;PDIdataland),')'
sql=. sql,' order by ',(>0{hd),' desc'
On Thu, Sep 9, 2021 at 10:23 AM John Baker <[email protected]> wrote:
> It seems the recent change to the ODBC addon has changed how ddcol works
> on SQLServer.
>
> ddcol normally returns information about the columns of a table given a
> connection. Now it's returning nothing but header columns.
>
> Has anyone else noticed this?
>
> --
> John D. Baker
> [email protected]
>
--
John D. Baker
[email protected]
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
