Archives of the TeradataForum

Message Posted: Tue, 16 Aug 2005 @ 12:49:34 GMT

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

Hi Bill,

          > SELECT CountyNbr,
          > ProgramID,
          > SubString(IssueDate From 1 For 6) AS PayDate,
          > sum( NetPaymentAmount) As Amount
          > FROM xxxxxViews.yyyyyV
          > WHERE IssueDate between '20050101' AND '20050831'
          >   AND ProgramID <> 'ft'
          >   AND CountyNbr =3D (31)
          > group by 1,2,3
          > ORDER BY 1, 2, 3;

Thanks for this teaser.

I have only vague conjectures and no answers right now. Do you have more information for us?

What does the query actually return?

Is there EBCDIC somewhere around? (This is my favorite lead.)

How deep is the nesting of views, i.e. how many levels you need to go through between xxxxxViews.yyyyyV and the base table?

You are still on V2R3?

Regards,

Victor

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