Thanks for all the info. It looks like we will apply SI42565 to fix this issue. I am currently looking at QRECOVERY.QSQ901 to see what helpful information is in there.


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Monday, June 06, 2011 1:03 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Create table with USING clause not working

On 06-Jun-2011 12:29 , Tom E Stieger wrote:
I was trying to create a backup of some data before a did a mass
update and thought this would work:

create table mylib.FILE_BACKUP as
rthd, opseq, opdsc
amflibp.rtghdr join
using (STID, RTID, RTVR)
) with data

The underlying SQL for the select statement works, but the create
table causes the following errors:

SQL State: 58004
Vendor Code: -901
Message: [SQL0901] SQL system error. Cause . . . . . : An SQL system
error has occurred...The previous message identifier was MCH3601.
Internal error type 6101 has occurred...

MCH3601: Pointer not set for location referenced.

When I change my select statement to use on criteria in the join it
works just fine.

create table mylib.FILE_BACKUP as
rthd, opseq, opdsc
amflibp.rtghdr A join
amflibp.rtgopr B
on A.stid=B.stid and A.rtid = B.rtid and A.rtvr = B.rtvr
) with data

Does anyone know why the USING clause doesn't work with the "CREATE
TABLE as (select statement) with data"?
We are at 6.1.

Since the SQL0901 is little like the CPF9999 logged after some prior failure, but for processing within the SQL processor itself. While the failing statement is important, the details of the prior msgMCH3601 are generally the most informative for identifying any match to any known origin of the problem. FWiW there is a "database-wide logger" available to collect some information [including MSGS details] about such errors:

Regardless, probably?:
R610 SI42565 1000 [1000 means cumulative *none; r610=v6r1]

Regards, Chuck
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,
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].