MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2012

Re: cool, neat trick on IBM i v7.1 with CREATE TABLE



fixed

I can query the table on DBSTEST from the remote system so it's not the
RDB entry. Plus using DSPFD it shows the correct number of columns &
record length. If it weren't valid it wouldn't be able to query the table
at all, much less create a table (or half-way create one as the case may
be lol)


Thanks,
Tommy Holden



From: Evan Harris <auctionitis@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>,
Date: 10/04/2012 04:04 PM
Subject: Re: cool, neat trick on IBM i v7.1 with CREATE TABLE
Sent by: midrange-l-bounces@xxxxxxxxxxxx



So what RDB entry do you have set up against DBSTEST ?

On Fri, Oct 5, 2012 at 9:15 AM, <Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx>
wrote:
I can create a table using RDB by doing this:
create table SENDLIB/TESTRDB as
(select * from DBSTEST.LIBD42.PCPPIST0) DEFINITION ONLY

but even though the file is created i can't use it lol
UPDDTA SENDLIB/TESTRDB
File TESTRDB in library SENDLIB was not found.

DSPFD shows me all of the file's attributes, etc.
DSPFFD gets the
File TESTRDB in library SENDLIB was not found.

using SQL
SELECT * FROM SENDLIB/TESTRDB
gets this:
TESTRDB in SENDLIB type *FILE not found.

it does create the table, you just can't access it or edit it's
authority,
etc. you can't get rid of it using DROP TABLE or DLTF from the command
line but you can delete it from WRKF lol. methinks there's a bug in the
system somewhere...
running IBM i v7.1 TR4 with all the latest & greatest CUME, Group &
Hipers installed

Can anyone else duplicate this? If so then perhaps a PMR is in order...

Thanks,
Tommy Holden








Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact