RE: SQL0952 when dropping a column

I was not aware of that preference setting. Thanks!

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob Berendt
Sent: Friday, January 21, 2022 4:02 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: SQL0952 when dropping a column

I had this same thing in iACS.
Edit, Preferences, General, New connections, check Suppress inquiry messages.

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 7310 Innovation Blvd, Suite 104
Ft. Wayne, IN 46818
Ship to: 7310 Innovation Blvd, Dock 9C
Ft. Wayne, IN 46818
http://www.dekko.com


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of a4g atl
Sent: Friday, January 21, 2022 3:30 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: SQL0952 when dropping a column

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.


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

--
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