#DateWhereItemComment
1512 Apr 2016 @ 08:17 PDTUDAPhased Rollouts in Unity Director & LoaderNote there are new commands in Unity 15.00.01 that make step 3.2 much easier! You can now see and change where a object is managed with the unityadmin commands: OBJECT SHOW [object name] MANAGED O...
1408 Apr 2016 @ 05:36 PDTUDARouting Options in Unity Director 15.00 Thanks Brandon!
1327 Apr 2015 @ 06:28 PDTUDAWorking with Identity Columns and Unity Director and LoaderHi Slemme, That's an excellent question, which does cause some confusion. This article deals with identity columns and a multisystem environment using Unity Director. In working with multipl...
1225 Mar 2015 @ 01:09 PDTGeneralWorking with Stored Procedures in Unity DirectorHi Adeel, No, this article and the part about error handlers is specific to stored procedures.
1118 Feb 2015 @ 09:57 PSTGeneralWorking with Stored Procedures in Unity DirectorThanks!   In ANSI mode, you wouldn't use a BT/ET aronud the SP, but you would still use a locking statement, followed by the PS call.   No, the BT/ET outside of the SP isn't i...
1021 Jan 2015 @ 06:17 PSTUDAWorking with Identity Columns and Unity Director and LoaderThanks butchec. There's a wide range of use-cases for Director/Loader and there's no need to use it for everything all at once. Some sites will simply use Director for reporting - they don...
921 Jan 2015 @ 06:11 PSTGeneralWorking with Stored Procedures in Unity DirectorHi butchec, Sorry for the slow response. We've figured out that the RESIGNAL is not returning a 2164 instead of a 2616 because of a database bug. I'm told it is fixed in TDBMS_14.10.05h.49.
818 Dec 2014 @ 02:39 PSTUDAWorking with Identity Columns and Unity Director and LoaderHi KS, Your index create is failing because you are trying to use an identity column in a composite index, which isn't allowed. You might try the seconday index without Identity column in it....
711 Dec 2014 @ 07:30 PSTUDAWorking with Identity Columns and Unity Director and LoaderHi Ulrich, Yes, you are exactly correct - the UUID UDF isn't suitable if you are issuing a single request like an insert-select. Unity Director/Loader will sets the current time for the reques...
610 Dec 2014 @ 07:10 PSTUDAWorking with Identity Columns and Unity Director and LoaderUlrich, I think you may have taken the math slightly out of context - the entire key consists of the timestamp and the random number, not just the random number and is intended to provide a surroga...
509 Dec 2014 @ 10:47 PSTGeneralWorking with Stored Procedures in Unity DirectorYes, you're correct, adding resignal will change the behaviour of that stored procedure. In the orignal version, you are capturing the error, and returning a success return code, with the error...
426 Nov 2014 @ 12:20 PSTGeneralWorking with Stored Procedures in Unity DirectorThanks Smarak! >It will be great if we can have a similar article about the Locking Mechanism of Unity Ah, that's a good idea, thanks! I will see what I can do about realizing it in the ne...
303 Nov 2014 @ 06:07 PSTUDAAccessing Historical and Current Data with Unity DirectorI'm happy to point out that setting up a set of tables has now been simplified in Unity Director 14.10. You can now accomplish the same thing this article did, simply by creating a history view...
203 Nov 2014 @ 06:04 PSTUDAAccessing Historical and Current Data with Unity DirectorHi Raja, Sorry, I didn't see your question until now. >So Unity Director  syncs up tables in both systems only if both tables have same names? Yes, Unity Director sync...
103 Nov 2014 @ 06:00 PSTUDAAccessing Historical and Current Data with Unity DirectorYes, you are correct, all tables created via Unity Director will be created on all managed Teradata systems the user is routed to. Creating objects via Unity Director is generally a best practice, ...