#DateForumTypeThreadPost
927 Jun 2016 @ 01:47 PDTToolsReplyHow do people handle no file found error in BTEQ IMPORT on Network Attached systems?And actually for 15.10.01 there is now a more recent .03 efix but it is .02 that you minimally need.  
827 Jun 2016 @ 01:43 PDTToolsReplyHow do people handle no file found error in BTEQ IMPORT on Network Attached systems?Efix versions equal to or higher than what I listed will have it. So to get it now, you will need to pick up the latest efix version for 15.10.01 which is... 15.10.01.02 It will also be in the bas...
727 Jun 2016 @ 12:54 PDTToolsReplyHow do people handle no file found error in BTEQ IMPORT on Network Attached systems?Very recently, by way of BTEQ efixes, we've added support for using a new SYSTEMRETURNCODE keyword as part of an .IF command condition to enable the return code value resulting from using a .OS...
626 Apr 2016 @ 10:10 PDTToolsReplyreport with different numbering expected * BTEQ *Hi. You are getting default formats when you use BTEQ unless you supply format clauses as part of the SQL request. You will need to review SQL reference documentation about how to use FORMAT clause...
519 Apr 2016 @ 06:20 PDTToolsReplyTPT Error loading CSV as Double QuotesFor posterity... Like the Inserter, BTEQ uses plain SQL sessions to talk to the database. Unlike the Inserter, BTEQ can send more than one import record for each insert request. The subject of this...
423 Dec 2015 @ 02:13 PSTToolsReplyBTEQ - Row Level COMMITMy apologies. I just figured out that you are not asking about BTEQ but rather about SQL -- and specifically the MERGE INTO statement. Someone else will need to respond to you on that. But you prob...
323 Dec 2015 @ 10:57 PSTToolsReplyBTEQ - Row Level COMMITPlease post the versions of the DBS and BTEQ being used. To get that, you can logon via BTEQ and issue this command:      .SHOW VERSIONS
223 Sep 2015 @ 01:15 PDTToolsReplyLogon Error (BTEQ)So Fred's question was spot on. The very first thing BTEQ sees is the word "bteq". Since "bteq" is not a recognized BTEQ command keyword, BTEQ submits the instruction as an ...
123 Sep 2015 @ 12:38 PDTToolsReplyLogon Error (BTEQ)Also, try redirecting stdout and stderr to an output file so you can see all the messages BTEQ produces. For example...    bteq < my.in > my.out 2>&1