#DateForumTypeThreadPost
1520 Aug 2015 @ 07:34 PDTToolsTopicTPT NPAM reading named pipe ,not ending. Please help urg!!Hello, please need help urgently with this problem!! I have a TPT update reading from a named pipe using np_axsmod the first tests were made manually, that is we had a file, then created a pipe a...
1414 Jul 2015 @ 10:20 PDTToolsTopicTPT DDL Merge Into. How to report rows inserted / updatedHello. We are using Merge into in a TPT DDL to load data to the destintation tables. Our problem is how to report the number of rows inserted/updated by the merge into sentence, because we cant u...
1314 Jul 2015 @ 10:13 PDTToolsReplyTPT: reading variable blanks at end of record. Filler?Thank you Steve.  
1206 Jul 2015 @ 07:05 PDTToolsTopicTPT: reading variable blanks at end of record. Filler?Hello. I am recieving a file with delimiters with 20 fields, the problem is that after the last field there are blanks until completing the end of the record.  It s some kind of mix between d...
1117 Mar 2014 @ 07:00 PDTToolsTopicportable Sql Assitant?Hello. Does anybody knows if there is a portable version of Sql Assistant? Like a folder I can copy to my pc and just run the .exe?   thanks
1017 Mar 2013 @ 06:34 PDTDatabaseTopicGRANT/REVOKE LOGON TO ROLE ?Hello. When the loading processes start I have to disable logon to users, and when the last process ends I have to enable logons. I'm doing this with a Revoke Logon on all to user_x, and then...
917 Jul 2012 @ 07:03 PDTDatabaseTopicHelp defining Partition Hi. I need your advice on this: I have a insurance model to load the data from diferent companies (customers, events, etc) in TD12 I currently have some tables, mainly event tables, ...
829 Mar 2012 @ 10:08 PDTDatabaseTopicsplit field into columns Hi all I have a record with several fields, and the las one has a large text.  This text has a separator ; so what i would like to do is go from 1 large field with separators to var...
730 Aug 2011 @ 07:33 PDTDatabaseReplyDROP OLDEST PARTITION AND ADD NEW PARTITION constraintText in dbc.indexConstraints with constraintType = ‘Q’ (PPI)   SEL CAST ((TRIM( SUBSTRING(constrainttext FROM (INDEX(constrainttext,'''')+1)&nb...
630 Aug 2011 @ 07:31 PDTDatabaseReplyFind out the oldest (first) partition of a table Found it!! constraintText in dbc.indexConstraints with constraintType = ‘Q’ (PPI)   SEL CAST ((TRIM( SUBSTRING(constrainttext FROM (INDEX(constrainttext,''&#...
529 Aug 2011 @ 04:34 PDTDatabaseTopicFind out the oldest (first) partition of a table HiI need to find out wich is the first partition of a table with or without data. If i do min(partition) it only works as long as the partition has data.  Does anybody knows how to ...
407 Jul 2011 @ 05:40 PDTDatabaseReplyHelp with CONTINUE HANDLER!!Dieter thank you for your quick response. I changed the handler to DECLARE CONTINUE HANDLER FOR SQLSTATE 'T5628', and put it an the begining of the SP, but now when the SP is called, it wont do an...
306 Jul 2011 @ 05:14 PDTDatabaseTopicHelp with CONTINUE HANDLER!!Hi all. I have a process that reads a table where the user defines wich stats should run each day of the week. Once I have the list of stats to run in a table, I use a Sp to read each record, reg...
203 Jul 2011 @ 03:54 PDTToolsTopicHow to use EXEC SQL in Bteq ?Hi all. I have a file with a list of stats i have to collect (id, sentemce, date), and the Id of the stat according to a parameters table. I need to run the stat and insert a record in a log tabl...
128 Jan 2008 @ 02:15 PSTToolsTopicMload Vs Insert/Select on a BIG table with PPIHi all.I'm having some doubts about which strategy to follow in order to load information on a big table.The situation is this: the table will hold info for about 6 months, and diary will load abo...