Archives of the TeradataForum
Message Posted: Fri, 19 Oct 2001 @ 17:23:14 GMT
Neil, Good observation about our stored procedures! They are NEW in V2R4 and as such I certainly wouldn't expect them to be on par with other RDBMSs that have had them. We have been criticized for a long time that we did not have them (and triggers as well) but our customers seemed to have mastered SQL, BTEQ and MACRO's well enough to not need them to accomplish their tasks.
Yes, we have a long way to go and I know that there will be improvements with every release as we find out how customers use them. Feedback through the PAC is the best way to accomplish this - have you considered joining it? I think you would be an excellent participant and could contribute a lot with your background!
Observation - I've done a few migrations from SQL Server and Informix and have never found a situation where we could not do the same as the Stored Procedures in those databases we migrated. The approach I took with my teams is to analyze each SP, document what it was doing then re-write the processes in 'Teradataese'. I believe that if you try to convert them 1:1, you are asking for a lot of frustration. Taken the approach we have has been a lot less stressful and also helped us understand what the code was trying to do from a process/business standpoint as well.
Anyway, just though I'd share that with you for what it's worth and thanks for your participation in the forum! Hope this finds you well!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|