× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Michael and Rob,

On your questions:

Common thread -  Just about everything.   That is to say, I created all
the tables using the same SQL via Ops Navigator.  Dropping and
recreating the tables doesn't help.

No messages in QSYSOPR msg queue but I did find some more in my joblog
(I'm running this from my userid):  

   Data Mapping error on member BFUT145AP

This seems crazy since, as I said before, I created the source and
target tables from the same SQL.  But at least this "deeper" error
explains the top level error of "Unable to open or create target ..."

QTFTP* jobs in QSYSWRK don't show any problems

there are no exit points

the libraries involved are MY libraries and my storage is *NOMAX

All scripts are built similar.   I can follow the run of the failing
scripts with a rerun of those that FTP against the other files that
never had a problem and they will rerun perfectly.    Doesn't matter if
I CD to my library or not; same problem.    I'd tried CLRPF as well as
DROPPING and re-CREATING the tables; no luck when FTPing.

What's even more weird is I can run some SQL that does an INSERT from a
SELECT of data from a copy of the master table on the same LPAR  (my
tables are a subset of the columns of the original table and a copy of
the original is found in both LPARs) and the INSERT works perfectly.   

I'm stumped.   Any more ideas?

Thanks for helping.

Dave



I've experimented and find a couple of things

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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

This mailing list archive is Copyright 1997-2024 by midrange.com 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.