Re: pre compiler sql ds

[Daniel Gross <daniel@xxxxxxxx>]

Hi Renee,

AFAIK that is not directly possible. 

But you can create a long char field and set it to be "based" on a pointer 

   dcl-s xxx char(200) based(xxx_p);

And at the beginning of the program set the pointer to the address of the first field:

   xxx_p = %addr(sql_00006);

That should do it - you can then inspect the whole DS via the xxx field. 

HTH 
Daniel


> Am 20.03.2025 um 18:04 schrieb Renee Taylor <rjtaylor1@xxxxxxxxxxxxx>:
>
> When compiling an SQL program, the compiler listing shows
> Precompiler's generated DS:
> DCL-DS *N;
>    SQL_00006 BINDEC(4) INZ(128);
>    SQL_00007 BINDEC(4) INZ(8);
>    SQL_00008 UNS(10) INZ(0);
>    SQL_00009 CHAR(1) INZ('0') CCSID(*JOBRUNMIX);
>    SQL_00010 CHAR(118) CCSID(*JOBRUNMIX);
>    SQL_00011 CHAR(1) CCSID(*JOBRUNMIX);
>  END-DS;
> When debugging, is there a way to look at the entire DS at once?
> --
> Renee Taylor
> WISE Software Release Manager
> 3131 S Dixie Ave, Dayton OH 45439
> *O:* 937.245.8530 | *M:* 918.490.3208
> rjtaylor1@xxxxxxxxxxxxx
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.