Re: Oracle in system i termonology

["Mark S. Waterbury" <mark.s.waterbury@xxxxxxx>]

Hi, Bruce:

Was it this article?

   http://www.ibmdatabasemag.com/db_area/archives/2002/q1/kolluru.shtml
and
   http://i.cmpnet.com/db2mag/db_area/archives/2002/q1/pdfs/Kolluru.pdf

Cheers,

Mark S. Waterbury

> R Bruce Hoffman wrote:
> DB2 Magazine, Quarter 2, 2002.
>
> There was a comparison of basic commands and terminology from Oracle to 
> DB2. Users, instances, databases, tablespaces, select, insert, etc. 
> That's a good starting point. If you can't locate the article (say at a 
> large city library's archives... <vbg>) then contact me offline and I 
> will try to dig up the two pages I saved of the comparison and scan them 
> and send them to you.
>
> Also, the "bible" in Oracle land is the "Oracle xx The Complete 
> Reference" (replacing xx with whatever the current version is). It's 
> straight forward and actually comes close to being complete. Used to be 
> published by Osborne. Have not used it since 8i, but should still be out 
> there.
>
>
> bruce.hoffman@xxxxxxxxxxxxxxxxx
>
>
>
> Vern Hamberg wrote:
>   
> > Ah OK -
> >
> > As Charles said, the statement might also work in Oracle - but one must 
> > find the syntax - I have Oracle 10G on my PC - the free version. Took a 
> > quick look - not familiar enough yet with where to get the documentation.
> >
> > Good luck on your job and take care.
> > Vern
> >
> > Adam West wrote:
> >   
> >     
> > > Vern, I didn't explain sufficiently. I unfortunately could no longer find work in the I world so I have taken a more simple position that utilizes some skills i have with Crystal Reports and Business Objects however this is strictly an Oracle shop.
> > >
> > > I am following this list strictly as an As/400 Anonymous type of thing. That may be the wrong term but you get my drift.
> > >
> > >
> > >
> > >
> > > ________________________________
> > > From: Vern Hamberg <vhamberg@xxxxxxxxxxx>
> > > To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> > > Sent: Thursday, March 12, 2009 6:20:23 PM
> > > Subject: Re: Oracle in system i termonology
> > >
> > > Adam
> > >
> > > You have a couple nice options - you can create tables with data from 
> > > another table, or combination of tables.
> > >
> > > create table newlib/newtable as (select * from oldlib/oldtable) with data
> > >
> > > You could even put that into a QM query with substitution variables for 
> > > the table and library names, even other parameters from CPYF if you 
> > > wanted, then put a command and CL program in front of that QM query.
> > >
> > > The above statement works in V5R3, at least, I believe.
> > >
> > > HTH
> > > Vern
> > >
> > > Adam West wrote:
> > >   
> > >     
> > >       
> > > > Thank you. One of the things I miss is the ability to quickly make test data. Something like the CPYF would be good.
> > > >
> > > >
> > > >
> > > >
> > > > ________________________________
> > > > From: Charles Wilt <charles.wilt@xxxxxxxxx>
> > > > To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> > > > Sent: Thursday, March 12, 2009 4:33:52 PM
> > > > Subject: Re: Oracle in system i termonology
> > > >
> > > > Index = keyed logical
> > > > View = unkeyed logical with dropped fields, substringed fields, ect...
> > > > plus lots more you can do in an DDS logical.
> > > >
> > > > One thing to understand, with RPG and record level access, you
> > > > explicitly open and use a keyed logical.
> > > >
> > > > Whereas with SQL, on either the i or Oracle, you use the physical
> > > > table (PF) or view and behind the scenes the query engine may or may
> > > > not use the index.
> > > >
> > > > HTH,
> > > > Charles
> > > >
> > > > On Thu, Mar 12, 2009 at 4:01 PM, Adam West <adamster@xxxxxxxxx> wrote:
> > > >   
> > > >     
> > > >       
> > > >         
> > > > > HI I was wondering if there is someone in the group who knows both system i and Oracle and could then explain the basiscs to me in system i terms of the Oracle setup. I am not sure for example what is meant by indices or is this like a Logical file.
> > > > >
> > > > > TIA,Adam
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > 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,
> > > > > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > > > > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > > > > Before posting, please take a moment to review the archives
> > > > > at http://archive.midrange.com/midrange-l.
> > > > >
> > > > >
> > > > >     
> > > > >       
> > > > >         
> > > > >           
>
>