Re: Received FTP files have TYPE P

[Jeff Crosby <jlcrosby@xxxxxxxxxxxxxxxx>]

OK, that makes more sense.

I had googled it and found this:

https://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.sqlref/src/tpc/db2z_sysibmsystablestable.dita

which I know is z/OS but I just assumed they would be the same.


On Mon, Apr 18, 2016 at 3:35 PM, Rob Berendt <rob@xxxxxxxxx> wrote:

> Jeff,
> IDK where you are getting your information on systables.
>
> http://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/db2/rbafzcatsystbls.htm?lang=en
> T=Table
> P=Physical file
>
> In this case I believe it is calling it a P because a straight FTP instead
> of a file transfer will not have a truly externally defined table.
>
> For example, if on my PC I dir
> DIR >DIROUT.TXT
> NOTEPAD DIROUT.TXT
> and trim off the header and the footer so that it at least looks somewhat
> formatted.
> Then I ftp this (in ascii mode) to a new file on my IBM i it creates a
> file with one field named the same as the file.
> Might be a snooty thing on it's part but it refuses to call that a table.
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>           Garrett, IN 46738
> Ship to:  Dock 108
>           6928N 400E
>           Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> From:   Jeff Crosby <jlcrosby@xxxxxxxxxxxxxxxx>
> To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Date:   04/18/2016 03:06 PM
> Subject:        Received FTP files have TYPE P
> Sent by:        "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
>
>
>
> All,
>
> Curiosity question.  When I use FTP on the IBM i and get file(s) from a
> Windows system, the SYSTABLES field TYPE contains a "P" not a "T" and I
> just wonder why that is.
>
> T = Table
> P = Table that was implicitly created for XML columns
>
> Anybody know?
>
> Thanks.
>
>
> --
>
>
> Jeff Crosby
> VP Information Systems
> UniPro FoodService/Dilgard
> P.O. Box 13369
> Ft. Wayne, IN 46868-3369
> 260-422-7531
> www.dilgardfoods.com
>
> The opinions expressed are my own and not necessarily the opinion of my
> company.  Unless I say so.
> --
> 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.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
>
> --
> 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.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.