Re: SQL0952 when dropping a column

[a4g atl <a4ginatl2@xxxxxxxxx>]

I was able to resolve the issue. I added another message ID CPA32B2 with
reply I and that did the trick.
Thanks, Darryl.

On Fri, Jan 21, 2022 at 3:28 PM a4g atl <a4ginatl2@xxxxxxxxx> wrote:

> @Paul, That would be a lot of work.
>
> On Fri, Jan 21, 2022 at 3:16 PM Therrien, Paul via MIDRANGE-L <
> midrange-l@xxxxxxxxxxxxxxxxxx> wrote:
>
> > If you are running an interactive session and execute the drop statement
> > within STRSQL then you should be able to respond to that error.
> > Somehow, I don't think this helps your situation though.
> >
> > How about creating a 2nd table by selecting only the columns you want to
> > keep from the original table.
> >
> > -----Original Message-----
> > From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
> > a4g atl
> > Sent: Friday, January 21, 2022 2:56 PM
> > To: midrange-l@xxxxxxxxxxxxxxxxxx
> > Subject: SQL0952 when dropping a column
> >
> > I am trying to drop a few columns from a work file. I can only delete the
> > fields after the file is built.
> >
> > When I run ALTER TABLE QTEMP.XXX DROP COLUMN X1, I get SQL0952.
> > I displayed the job log and see the drop triggers a message CPD32CC that
> > cannot be displayed advising that data will be lost. The system cancels the
> > job.
> >
> > I added CHGJOB INQMSGRPY(*SYSREPL).and added an entry monitoring for
> > CPD32CC which is displayed in the job log.
> >
> > This did not help.
> >
> > What other suggestions are there?
> >
> > TIA, Darryl Freinkel
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
> > subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives at
> > https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate
> > link: https://amazon.midrange.com
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate
> > link: https://amazon.midrange.com