Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 27 Feb 2003 @ 21:44:42 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


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



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016