RE: SQL Option for DSPFFD

We all have our days!

From: Don Brown <DBrown@xxxxxxxxxx>
Sent: Wednesday, July 19, 2023 5:36 PM
To: Therrien, Paul <ptherrien@xxxxxxxxxxx>
Cc: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: SQL Option for DSPFFD

Thanks Paul

You are correct.

I have no idea what I was doing when it was failing

Doh!!!

Cheers

Don




From: "Therrien, Paul" <ptherrien@xxxxxxxxxxx<mailto:ptherrien@xxxxxxxxxxx>>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>>
Cc: "Don Brown" <DBrown@xxxxxxxxxx<mailto:DBrown@xxxxxxxxxx>>
Date: 19/07/2023 10:07 PM
Subject: RE: SQL Option for DSPFFD
________________________________



I disagree with this... I can do DSPFFD on my SQL tables (IBM I 7.4)

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx<mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx>> On Behalf Of Don Brown via MIDRANGE-L
Sent: Wednesday, July 19, 2023 4:39 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: Don Brown <DBrown@xxxxxxxxxx<mailto:DBrown@xxxxxxxxxx>>
Subject: SQL Option for DSPFFD

Hi

I thought this would be an easy google search ...

I have a utility that uses a combination of DSPFD and DSPFFD to provide a quick list of fields in a file.

It does not work on sql tables

DSPFFD does not work on SQL tables.

What are the options to display the field definitions in a SQL table.

Thanks

Don



--
This email has been scanned for computer viruses. Although MSD has taken reasonable precautions to ensure no viruses are present in this email, MSD cannot accept responsibility for any loss or damage arising from the use of this email or attachments..
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx> To subscribe, unsubscribe, or change list options,
visit: https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_midrange-2Dl&d=DwIF-g&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=Kys-lxRCMpPr7up01Pp1FRjOe49ne6imWwi1b-ue8yQ&m=SjaL8tOmSNuFFOzFG6FMGEVbg8Nwbomz8B0CzdUEi6y8oBiIs3lx358YWrRL3KpD&s=PT2iit6vleAhsOwT1XOG4LbYweUMmIba6ax0w2vkkio&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives at https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwIF-g&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=Kys-lxRCMpPr7up01Pp1FRjOe49ne6imWwi1b-ue8yQ&m=SjaL8tOmSNuFFOzFG6FMGEVbg8Nwbomz8B0CzdUEi6y8oBiIs3lx358YWrRL3KpD&s=5wSgenxIXcU_0kBrpOWrgjhrt9ld-AfzRs1P8ycgBlo&e=.

Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.