|
V7R1M0
I'm testing a change to an SQLRPGLE which has been in use for some
years.
The program object was created using PDM work with Objects to copy
the program from a production lib into a special test lib I'm using
just for this test.
I'm wondering why I received SQL0601 on the following embedded SQL:
DECLARE GLOBAL TEMPORARY TABLE lcp980wk1
( delloc CHAR(4) NOT NULL,
<<SNIPped>>
)
WITH REPLACE NOT LOGGED
My assumption was "WITH REPLACE" would allow the table to be replace
in the event it exists ?
Would it be better practice to start with a DROP command ?
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.