Re: Implicitly hidden column & EXTNAME D/S

[Brian Parkins <goodprophet.bp@xxxxxxxxx>]

Unless I am missing something, the PRTSQLINF report appears to provide 
little useful information in this context, i.e. which columns the SELECT 
* delivers. Apart from a repetition of the compile command, all I get is:

SELECT * INTO : H ,: H ,: H FROM xxxxxx / TABLETEST
  SQL4021  Access plan last saved on 20-05-05 at 16:29:17.
  SQL4020  Estimated query run time is 0 seconds.
  SQL4010  Table scan access for table 1.

Is there more I should be seeing?

Brian.


On 04/05/2020 16:22, Mark Waterbury wrote:
> Rather than speculating about what may or may not be happening at "compile-time" versus "run-time", use the PRTSQLINF command ...
>
> The output will show you what the SQL precompiler has stored within the program object -- this will show you what SQL statements will be executed "at run-time."