RE: DSPFD SQL instructions

[vhamberg@xxxxxxxxxxx]

David, et al.

You can also find this in the system catalog - field is TEXT in SYSVIEWS. Here is an SQL SELECT to see it

select text from sysviews where name = 'your-view' and dbname = 'your-lib'

-------------- Original message -------------- 
From: David FOXWELL <David.FOXWELL@xxxxxxxxx> 

> Thanks ! Found this command GENDDLSRC, here : 
> http://www.ibmsystemsmag.com/i5/october07/technicalcorner/18376p1.aspx 
>
>
> -----Message d'origine----- 
> De : midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] De 
> la part de Wilt, Charles 
> Envoyé : mardi 29 juillet 2008 15:40 
> À : Midrange Systems Technical Discussion 
> Objet : RE: DSPFD SQL instructions 
>
> DSPFD won't give it to you. 
>
> You can use iSeries Navigator, right click on the table and select "Generate 
> SQL...". 
>
> Or you could write a program that uses the API yourself. The API to use is 
> Generate Data Definition Language (QSQGNDDL) API 
>
> You might find that somebody has already put together such a program. 
>
> HTH, 
>
> Charles Wilt 
> -- 
> Software Engineer 
> CINTAS Corporation - IT 92B 
> 513.701.1307 
> wiltc@xxxxxxxxxx 
>
>
> > -----Original Message----- 
> > From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l- 
> > bounces@xxxxxxxxxxxx] On Behalf Of David FOXWELL 
> > Sent: Tuesday, July 29, 2008 9:14 AM 
> > To: Midrange Systems Technical Discussion 
> > Subject: DSPFD SQL instructions 
> >
> > Hi, 
> >
> > Option 5 in PDM objects on an SQL view show me the instructions needed 
> > to regenerate the view. 
> >
> > I should be able to retrieve these instructions with DSPFD into an 
> > *OUTFILE. If this is possible, what is the parameter setting for TYPE 
> > on the DSPFD command? 
> >
> > Thanks. 
> >
> >
> > -- 
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> > list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, 
> > unsubscribe, or change list options, 
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take 
> > a moment to review the archives at 
> > http://archive.midrange.com/midrange-l. 
>
>
>
> This e-mail transmission contains information that is intended to be 
> confidential and privileged. If you receive this e-mail and you are not a named 
> addressee you are hereby notified that you are not authorized to read, print, 
> retain, copy or disseminate this communication without the consent of the sender 
> and that doing so is prohibited and may be unlawful. Please reply to the 
> message immediately by informing the sender that the message was misdirected. 
> After replying, please delete and otherwise erase it and any attachments from 
> your computer system. Your assistance in correcting this error is appreciated. 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To 
> post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or 
> change list options, 
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment 
> to review the archives at http://archive.midrange.com/midrange-l. 
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list 
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
> To subscribe, unsubscribe, or change list options, 
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
> or email: MIDRANGE-L-request@xxxxxxxxxxxx 
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/midrange-l.