RE: Accessing AIX Oracle data from IBM i

On system GDISYS:
STRSQL

create table rob.deletemey as (
select * from gdihq.rob.ann)
with data

On system gdihq:
WRKOBJLCK OBJ(ROB/ANN) OBJTYPE(*FILE)
Job User Lock Status Scope
QRWTSRVR QUSER *SHRRD HELD *JOB

on system gdisys
commit

on system gdihq
(There are no locks for the specified object)


Trying to figure out how to do this "with nc" but haven't yet.
create table rob.deletemez as (
select * from gdihq.rob.ann
with nc)
with data
Keyword not expected. Valid tokens: .
create table rob.deletemez as (
select * from gdihq.rob.ann)
with data
with nc
Token <END-OF-STATEMENT> was not valid. Valid tokens: ON.



Rob Berendt