#DateForumTypeThreadPost
2327 Jun 2016 @ 01:37 PDTToolsReplyHow do people handle no file found error in BTEQ IMPORT on Network Attached systems?Hooray! Thanks for the enhancement! Thank you! Thank you! So I suppose any minor version equal to or higher than the ones listed here in each of the major versions will have this enhancement ...
2227 Jun 2016 @ 09:16 PDTToolsTopicHow do people handle no file found error in BTEQ IMPORT on Network Attached systems?When the IMPORT file is missing BTEQ issues an error and continues with the next SQL Statement in the Network attached system. In the mainframe systems this ab ends the script.  ...
2109 Jan 2015 @ 09:34 PSTToolsReplyMLOAD and loading of: Empty Strings and Null StringsI tried Ivy's script and data above and it worked as expected.. :) Puts a null string only if the column is blank and trimmed with VARTEXT.. Thanks you both! data from the Ivy'...
2031 Dec 2014 @ 07:54 PSTToolsReplyMLOAD and loading of: Empty Strings and Null StringsThanks Stevef.  Even without the TRIM the blank columns are loaded as empty string with the TEXT format.  With the VARTEXT format both the blanks and the NULL (two adjacent delimitter cha...
1923 Dec 2014 @ 01:10 PSTToolsReplyMLOAD and loading of: Empty Strings and Null StringsIvyuan/Fred, Thanks for your reply.  The behavior of loading NULL is what I expect. Try loading a fixed length file with a column value all blanks. this column is loaded as an empty-string ra...
1817 Dec 2014 @ 09:01 PSTToolsTopicMLOAD and loading of: Empty Strings and Null StringsWhen loading data from flat files (text ascii) to tables I find that if the file is a delimited file with all the fields defined as VARCHAR for the columns the columns with blank values (all spaces...
1712 Nov 2012 @ 12:33 PSTPrivate Forum
1615 Aug 2012 @ 01:58 PDTPrivate Forum
1515 Aug 2012 @ 09:15 PDTExtensibilityTopicSYSXML.XMLELEMENT FUNCTION I am adding an element of string content using the above function.  What I was hoping is that the string content to be cleaned or converted to entities of characters that are not otherwise ...
1416 Jul 2012 @ 09:47 PDTToolsReplyTTU14.00 - hung MLOAD There is a DR released for this.
1319 Jun 2012 @ 11:58 PDTGeneralReplyGrouping Contiguous Data I have an initial iteration with an assumption that the data is unique on name and starttime, the below sql should give a starting poing wherever the succesive lines' time overlaps they...
1218 Jun 2012 @ 12:45 PDTConnectivityReplySocket Error 804 (1) The socket connection is originating and ending at the same IP I don't think that could be a net work issue!! (2) 'database restart' error most likely reported as an error of...
1118 Jun 2012 @ 10:12 PDTGeneralReplyROW_NUMBER() OVER (PARTITION BY col1,col2.... order by col1) The use of the function is limited by the imagination of the developer.  The row_number just does that numbers the row partitioned by col1, col2 order by col1.  Did you try out this fu...
1018 Jun 2012 @ 08:52 PDTConnectivityReplySocket Error 804 Is this error repeatble or occurring at random? if occurring at random intervals try to increase the "concurrent" limit from 3 to 10. if you hit this error every single time, try unins...
918 Jun 2012 @ 08:44 PDTPrivate Forum
817 Jun 2012 @ 08:55 PDTToolsTopicSQL Assistant 14.0.0.1 I am using SQLA 14.0.0.1 in my test system with dot not 13.11.0.1. I notice few minor issues. (1) The sql assistant icon stays on the status bar stays 'red-eyed' even after the execu...
715 Jun 2012 @ 11:55 PDTToolsTopicTTU14.00 - hung MLOAD I have upgraded my TTU from 12.x to 14.x about a month and half ago. Since then almost every day experiencing few random hung mload jobs, most exhibit a 'DBC Restart' error while some do...
621 May 2012 @ 10:29 PDTDatabaseReplyFastexport is not creating full length file you can use a work around with bteq add a dummy column of '|' to the end and later replace the pipe with space or null
511 May 2012 @ 08:52 PDTPrivate Forum
411 May 2012 @ 06:51 PDTDatabaseReplyFinding PPI database administration physical implementation documentation is what you need to browse.. All physical implementation are centered around even distribution of data and providing best access...
311 May 2012 @ 06:44 PDTDatabaseReplyChecktable Try "cnsremote"  -- tool intended just for automating these tasks -Sankar
211 May 2012 @ 06:42 PDTPrivate Forum
131 Jan 2012 @ 10:09 PSTPrivate Forum