 |
 |
Archives of the TeradataForum
Message Posted: Thu, 27 Feb 2003 @ 21:44:42 GMT
| Subj: | | Re: MLOAD Changes from 07.05.00 to 07.06.00 |
| |
| From: | | John Adams |
Hi, Todd,
In answer to your questions:
| | - Did you just upgrade utilities or was the Teradata RDBMS changed also (egto V2R5.0)? | |
We went from 4.1.0 to 4.1.3. We did not go to V2R5.
| | These sound like DBMS issues not Mload. | |
I thought so too, but the person to whom it was assigned felt otherwise, so (until I have time to look closely) I defer to his
judgment.
| | - Utilities are designed and intended to be compatible release to release unless specifically identified otherwise in the
release documentation. This should be handled as an incident with Teradata support. | |
| | - Derived tables in Mload?? | |
No, of course not--now that I have the docs in front of me, I see this was in a bteq session. Here's the code which failed:
select count(*) (title ' ') (char(17))
from (select
fld1 (CHAR(20)),
'FIELD 1' (CHAR(10)),
fld2 (CHAR(10)),
'FIELD 2' (char(10)),
'20030101' (date, FORMAT 'YYYYMMDD') (date)
from vbus.acct_hist
where '20030101' (date, FORMAT 'YYYYMMDD') between START_DT AND END_DT
group by fld1,'FIELD 1',fld2,'FIELD 2','20030101' (date, FORMAT 'YYYYMMDD')) a ;
And here's what we replaced it with:
select count(*) (title ' ') (char(17))
from (select
fld1 (CHAR(20)),
'FIELD 1' (CHAR(10)),
fld2 (CHAR(10)),
'FIELD 2' (char(10)),
'20030101' (date, FORMAT 'YYYYMMDD') (date)
from vbus.acct_hist
where '20030101' (date, FORMAT 'YYYYMMDD') between START_DT AND END_DT
group by fld1,'FIELD 1',fld2,'FIELD 2','20030101' ) a
(c1, c2, c3, c4, c5) ;
Not much difference, is there? My thought is that something which was deprecated finally had its time run out.
Thanks,
John A
| |
