The results from ddcoltype look OK to me. I'm not sure what they all mean (this verb is not mentioned on the http://code.jsoftware.com/wiki/ODBC/Data_Driver WIKI page).
query ddcoltype ch +++++------------------++-+-------+--+---+-+-++--+-+ |||||sales_region ||1|varchar|12|10 |0|0||12|0| +++++------------------++-+-------+--+---+-+-++--+-+ |||||country ||2|varchar|12|256|0|0||12|0| +++++------------------++-+-------+--+---+-+-++--+-+ |||||historic_save_rate||3|float |6 |53 |0|0||6 |0| +++++------------------++-+-------+--+---+-+-++--+-+ |||||target_save_rate ||4|float |6 |53 |0|1||6 |0| +++++------------------++-+-------+--+---+-+-++--+-+ I was not able to get ddsparm to work either. I tried writing to the database some data I had just read from it. data =: ddfch sh, 10 ddend sh 0 (q2;data) ddsparm ch _1 dderr '' ISI08 Bad arguments q2 insert into t4b.sales.r_bl_inside_sales_ccf_country_target(sales_ region, country, historic_save_rate, target_save_rate) values(?,?,?,?) On Wed, Oct 5, 2016 at 11:34 AM, bill lam <[email protected]> wrote: > Sorry Michael, I misread your message and only notice the insert > statement in ddsql. > > I didn't try owner/catalog qualifiers. Can test what is the > output of ddcoltype and is it a reasonable result? > > query ddcoltype ch > > also test if ddsparm can work, something like this > > ('insert into t4b.sales.r_bl_inside_sales_ccf_country_target(sales_ > region, > country, historic_save_rate, target_save_rate) values(?, > ?,?,?)';data) ddsparm ch > > > Ср, 05 окт 2016, Michael Berry написал(а): > > Hi Bill, > > > > I'm still confused. The query in my example *is* a select statement and > it > > works fine as such: > > > > query > > > > select sales_region, country, historic_save_rate, target_save_rate from > > t4b.sales.r_bl_inside_sales_ccf_country_target > > > > sh=: query ddsel ch > > > > sh > > > > 6260928 > > > > ddfet sh > > > > ┌────────┬─────────┬───┬────┐ > > > > │Americas│Argentina│0.8│0.83│ > > > > └────────┴─────────┴───┴────┘ > > > > The error message is "Invalid Object Name". > > > > I rewrote my application to generate insert statements for ddsql which > > works fine but ddins still seems to be complaining about a table name > which > > is a transformation of the name in my query. > > > > On Tue, Oct 4, 2016 at 7:59 PM, bill lam <[email protected]> wrote: > > > > > The syntax is incorrect for ddins. It expected a select statement. see > > > > > > http://code.jsoftware.com/wiki/ODBC/Methods/Bulk_Insert > > > > > > you may also try ddparm/ddsparm > > > > > > On Oct 5, 2016 6:26 AM, "Michael Berry" <[email protected]> wrote: > > > > > > > Hello All, > > > > > > > > I apologize if this is a repeat. I am a subscriber to this list and > > > didn't > > > > see my post, so I feared maybe no one else did either. > > > > > > > > I am having trouble doing a bulk insert using ddins from the J ODBC > > > > library. The error message is "Invalid object name" and the object > name > > > > included in the error message is indeed invalid, but also not what I > > > typed. > > > > All the underscores and periods have been removed. Note that other > SQL > > > > operations, including INSERT, work fine with this same table. Does > anyone > > > > know what is going on? The database I am connected to is SQL Server. > My J > > > > version is 802. My operating system is Windows 7 Professional (64 > bit) > > > > > > > > Any help appreciated. -Michael > > > > > > > > > > > > > > > > Some sample output for context: > > > > > > > > dddbms ch > > > > > > > > ┌────┬────────┬─────────┬──────────┬─────┬──────────┬─────── > > > > ──────┬──────────┬─┬─┬───┐ > > > > > > > > │ODBC│t4bwhsql│US\mberry│T4BSQL01AD│MSSQL│12.00.5000│sqlncli > > > > 11.dll│11.00.2100│3│1│256│ > > > > > > > > └────┴────────┴─────────┴──────────┴─────┴──────────┴─────── > > > > ──────┴──────────┴─┴─┴───┘ > > > > > > > > query > > > > > > > > select sales_region, country, historic_save_rate, target_save_rate > from > > > > t4b.sales.r_bl_inside_sales_ccf_country_target > > > > > > > > sh=: query ddsel ch > > > > > > > > sh > > > > > > > > 6260928 > > > > > > > > ddfet sh > > > > > > > > ┌────────┬─────────┬───┬────┐ > > > > > > > > │Americas│Argentina│0.8│0.83│ > > > > > > > > └────────┴─────────┴───┴────┘ > > > > > > > > ddend sh > > > > > > > > 0 > > > > > > > > 'truncate table t4b.sales.r_bl_inside_sales_ccf_country_target' > ddsql ch > > > > > > > > 0 > > > > > > > > 'insert into t4b.sales.r_bl_inside_sales_ccf_country_target(sales_ > > > region, > > > > country, historic_save_rate, target_save_rate) values(''Americas'', > > > > ''Argentina'', 0.8, 0.83)' ddsql ch > > > > > > > > 0 > > > > > > > > sh=: query ddsel ch > > > > > > > > sh > > > > > > > > 71014208 > > > > > > > > ddfet sh > > > > > > > > ┌────────┬─────────┬───┬────┐ > > > > > > > > │Americas│Argentina│0.8│0.83│ > > > > > > > > └────────┴─────────┴───┴────┘ > > > > > > > > ddend sh > > > > > > > > 0 > > > > > > > > data > > > > > > > > ┌────────┬─────────────┬────────┬────┐ > > > > > > > > │Americas│Argentina │0.820513│0.83│ > > > > > > > > │Americas│Bolivia │0.923077│ 0.9│ > > > > > > > > │Americas│Brazil │0.909091│ 0.9│ > > > > > > > > │Americas│Canada │0.795918│0.81│ > > > > > > > > │Americas│Chile │ 0.85 │0.86│ > > > > > > > > │Americas│Colombia │0.904762│ 0.9│ > > > > > > > > │Americas│Costa Rica │0.805556│0.82│ > > > > > > > > │Americas│Ecuador │0.888889│ 0.9│ > > > > > > > > │Americas│Mexico │0.840909│0.85│ > > > > > > > > │Americas│other │ 0.89 │ 0.9│ > > > > > > > > │Americas│Peru │0.666667│0.68│ > > > > > > > > │Americas│United States│0.837709│0.85│ > > > > > > > > └────────┴─────────────┴────────┴────┘ > > > > > > > > (query;data) ddins ch > > > > > > > > _1 > > > > > > > > dderr '' > > > > > > > > 42S02 208 [Microsoft][SQL Server Native Client 11.0][SQL > Server]Invalid > > > > object name *'t4bsalesrblinsidesalesccfcountrytarget'*. - more error > > > info > > > > available (1) > > > > ------------------------------------------------------------ > ---------- > > > > For information about J forums see http://www.jsoftware.com/ > forums.htm > > > ---------------------------------------------------------------------- > > > For information about J forums see http://www.jsoftware.com/forums.htm > > ---------------------------------------------------------------------- > > For information about J forums see http://www.jsoftware.com/forums.htm > > -- > regards, > ==================================================== > GPG key 1024D/4434BAB3 2008-08-24 > gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 > gpg --keyserver subkeys.pgp.net --armor --export 4434BAB3 > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
