#DateForumTypeThreadPost
1601 Aug 2016 @ 04:47 PDTThird Party SoftwareReplySublime text as Interactive BTEQ editorDid you manage to do it yourself?
1509 Jun 2016 @ 07:36 PDTDatabaseReplyGet database hierarchy to create similar directory structure on filesystem@CarlosAL Thanks mate. Looks like that's exactly what I want. Let me decipher it as I'm not used to recursion.   Cheers
1409 Jun 2016 @ 05:42 PDTDatabaseTopicGet database hierarchy to create similar directory structure on filesystemI'm struggling with a query to fetch entire database hierarchy and calculating path of each node from root. I need to create same directory structure on the file system whereby each directory r...
1319 Sep 2014 @ 02:37 PDTToolsReplyGetting error on Fastload..."nvalid state for Load"My job failed leaving the loading table, ET and UV tables locked. The ET and UV tables were accidently droped. After that when the fastload was run on the same table (which is still locked), this e...
1219 Sep 2014 @ 02:36 PDTDatabaseReplyRDBMS error 2635: Error tables are invalid when doing a fastloadMy job failed leaving the loading table, ET and UV tables locked. The ET and UV tables were accidently droped. After that when the fastload was run on the same table (which is still locked), this e...
1117 Sep 2014 @ 11:06 PDTToolsReplyRestarting Fastload if we have error with the source data fileRemove the TPT checkpoints. That worked for me
1017 Sep 2014 @ 11:05 PDTDatabaseReplyTPT10508: RDBMS error 2634: Existing ERROR table(s) or Incorrect use of TS_IDP_MM in Fast Load operationRemoving TPT checkpoints worked for me when I faced the same problem
915 Sep 2014 @ 01:49 PDTGeneralReplyStrategic Vs Tactical queriesRaja, Very well explained. Thank you
829 Aug 2014 @ 12:57 PDTToolsTopicTPT: How to forcefully fail the jobIs there any way I can forcefully/manually stop/fail TPT while it is loading (while TPT is in application phase) the staging tables so that the table being loaded is locked and there is no way to a...
729 Aug 2014 @ 12:34 PDTToolsReplyTD Wallet and TPT  In your operator definition, you could replace: VARCHAR UserPassword = @jobvar_password, with:  VARCHAR UserPassword = '$tdwallet(password_proddev)',   Al...
623 Apr 2014 @ 10:31 PDTExtensibilityReplyalways got failure 7980 when try to create Java External store procedure. Compilation on Java 1.5 worked for me as well. Thanks
517 Apr 2014 @ 09:18 PDTDatabaseReplyDifference between X and V viewsThank you all, that was helpful
411 Apr 2014 @ 12:53 PDTDatabaseTopicDifference between X and V viewsWhat is the difference between simple system view like dbc.tables, X views and V views and which one is better - performace wise? Does every system view like dbc.tables will always have a correspo...
303 Mar 2014 @ 11:12 PSTConnectivityReplyName not in HOSTS file error - LinuxI had the same problem with my TPT scritp and it was resolved by fixing the following attributes of Export operator  DEFINE OPERATOR Export_Accounts     TYPE EXPORT  ...
223 Jun 2011 @ 02:39 PDTDatabaseReplyConverting DECODE into CASE statementCASE WHEN 'Y' = ( CASE WHEN NOTES_QS_CODE.name = 'QS-9000 Certified'THEN 'Y' ELSE NULL END ) THEN 'QS-9000 Certified' WHEN 'Y' = ( CASE WHEN NOTES_ISO_CODE.name = 'ISO Certified' THEN '...
122 Jun 2011 @ 04:24 PDTDatabaseTopicConverting DECODE into CASE statementI had difficulty in translating this nested DECODE function into CASE statements. Please help DECODE('Y', (DECODE(NOTES_QS_CODE.name, 'QS-9000 Certified', 'Y')), 'QS-9000 Certified', ...