Re: SQL Fun

[Richard ECUYER <recuyer@xxxxxxx>]

You don't need the external DS for your sql statement.

Robert Munday a écrit :
> Tommy,
>
>
> -----Original Message-----
>   
> > From: Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx
> >     
>
> <<<  use prefixes on the external DS...  >>>
>
> As I said before, that has not worked.  Here is what I coded:
>
>  *  Detail File                                           
> D PDTOTDTL      E DS                  ExtName(PDTOTDTL) Prefix(D_)
>
> C/Exec SQL                                                          
>  +  Select Count(D_QCORD#) Into :Count From FPTOTDTL                
>  +   Where D_QCORD# = :$ORDER                 -- Count Order Records
> C/End-Exec                                                          
>
>
> This is the error it generates:
>
> SQL0206  30     431  Position 23 Column D_QCORD# not in specified tables.
> SQL0206  30     432  Position 17 Column D_QCORD# not in specified tables.
>
> Is there an interim step or something I'm missing?
>
>
>
> Robert Munday
> Munday Software Consultants
> Montgomery, AL
> having SQL fun in Dublin, OH
>
>
>