Archives of the TeradataForum
Message Posted: Fri, 11 Nov 2005 @ 19:48:44 GMT
Subj: | | Re: Stored procedures results |
|
From: | | Eric Friedman |
I'm a relative newcomer to Teradata (5 months), having done Oracle architecture design and development for several years. I wrote a highly
flexible and efficient table-driven Oracle9/10 reporting application based on over 100 stored procedures that code-generate dynamic SQL,
interfacing with a MS ASP ADO-based web front end that also generates dynamic SQL to populate its dropdown lists and display report results (since
you never know ahead of time where the user will want to go).
From this discussion thread, it appears that there's no practical way to port such an application to Teradata at this time. What a shame! At
least with BTEQ there's a serious kludge that allows you to retrieve dynamic SQL results by using BTEQ export to write them to a local Unix file,
then using Unix utilities such as awk to parse the results and read them into Unix script environment variables. This allows your script to make
branching decisions (although not within the BTEQ session) and quasi-generate dynamic SQL.
Unfortunately, it appears that both BTEQ and SP have a long way to go before they catch up to the competition.
Eric Friedman
|