William:
A technique I use to put the Grand Totals at the top of the report is by using a "false page header," that is, making Group 1 a formula something like: if isnull({table.field}) then 'Total' else 'Total'. This way, summary fields can be put in the Group 1 header that reflect the entire...
eerich:
1) Have an odbc connection to your DB2 data source. If you can use the IBM Client Access ODBC Driver, you will have access to DB2 functions as well as data tables. Your queries will run faster if your mdb file is close to the DB2 table (on a server on the same backplane).
2) Open MS...
Does Teradata support native DSQL? If I want to execute only one of say, seven different SELECT statements, nested in an if-then-else type structure, and pick this by a parameter at runtime, how do I do this? Can this be done easier with a Macro? a Command Object? some kinda native dynamic...
What is the equivalent advanced Teradata SQL code for the PL/SQL SELECT below?
Suppose you have a select or subselect which filescans 1 billion records, and you need several elements from this set of records. How can you do this with one filescan? What is the Advanced Teradata SQL equivalent...
Naith,
No CE9 for UNIX yet. Might be out with CE95; no published release date. ALL situations with CE9 will require CR9, as both are unicode. Is the CE app service on UNIX, or just the database? If just the database, it is not a problem. What volume of reports and data are you running...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.