IBMiAccess




Results 1 to 14 of 14

Thread: how to create a PF file

  1. #1
    Code400 Newbie
    Join Date
    Jun 2009
    Location
    Yemen
    Posts
    33
    Rep Power
    447

    how to create a PF file

    I want to know step by step how i can create a physical file ?

    Thanks

  2. # 666
    Circuit advertisement
    Join Date
    Aug 1965
    Location
    Yakutsk, Russia
    Posts
    1,000,000
     

  3. #2
    Analyst MdnghtPgmr's Avatar
    Join Date
    Oct 2005
    Location
    Topeka, KS
    Age
    56
    Posts
    517
    Rep Power
    2226

    Re: how to create a PF file

    newp,

    Check out the CRTPF command. Until you learn to use an editor it's gonna be kinda rough...

    HTH,
    MdnghtPgmr

  4. #3
    Harbinger of Doom tomholden's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Tennessee, United States
    Posts
    4,335
    Rep Power
    8657

    Re: how to create a PF file

    Quote Originally Posted by newp View Post
    I want to know step by step how i can create a physical file ?

    Thanks
    or better yet, forget DDS and use SQL CREATE TABLE.
    I'm not anti-social, I just don't like people -Tommy Holden

  5. #4
    Code400 Newbie
    Join Date
    Jun 2009
    Location
    Yemen
    Posts
    33
    Rep Power
    447

    Re: how to create a PF file

    thank you , but can you elaborate ! or if you know any helpful link

    bests

  6. #5
    Harbinger of Doom tomholden's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Tennessee, United States
    Posts
    4,335
    Rep Power
    8657

    Re: how to create a PF file

    let me google that for you http://tinyurl.com/l5afsj
    I'm not anti-social, I just don't like people -Tommy Holden

  7. #6
    Code400 Newbie
    Join Date
    Jun 2009
    Location
    Yemen
    Posts
    33
    Rep Power
    447

    Re: how to create a PF file

    Ok i got it how

    thanks for your help

  8. #7
    Blreen-O-holic vikramx's Avatar
    Join Date
    May 2006
    Location
    Chennai, India
    Posts
    242
    Rep Power
    1397

    Re: how to create a PF file

    @Tom
    It may be unrelated to the question of newp, but considering am new to using SQL RPGLE, I would like to know where exactly does the table get created when we use CREATE TABLE command in the program? Does the table last till the job/program ends or till we issue a DROP TABLE command?

  9. #8
    Lord of the Dance
    Join Date
    Aug 2008
    Location
    Memphis - Nashville TN
    Posts
    1,692
    Rep Power
    4714

    Re: how to create a PF file

    I would like to know where exactly does the table get created when we use CREATE TABLE command in the program? Does the table last till the job/program ends or till we issue a DROP TABLE command?
    You can specify the library to create the table:

    CREATE TABLE PGF.BILLOFMATERIAL

    This creates table BillOfMaterial in library PGF.

    The table remains until you drop it. If you want it to automatically be deleted at the end of the job, then you can create it in library QTEMP.
    Michael Catalani
    Manager of eCommerce Development
    Acceptance Insurance Corporation
    www.AcceptanceInsurance.com
    www.ProvatoSys.com

  10. #9
    Code400 Newbie
    Join Date
    Jun 2009
    Location
    Yemen
    Posts
    33
    Rep Power
    447

    Re: how to create a PF file

    Thanks Tom

    from proramming point whats the differnce by using DDS or SQL to create a database?.

  11. #10
    Harbinger of Doom tomholden's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Tennessee, United States
    Posts
    4,335
    Rep Power
    8657

    Re: how to create a PF file

    Quote Originally Posted by newp View Post
    Thanks Tom

    from proramming point whats the differnce by using DDS or SQL to create a database?.
    from programming there's absolutely no difference at all (unless your program is using SQL to access the table data, then SQL tables will perform better). the main thing is that DDS is no longer being enhanced while IBM is committed to continue to improve/enhance SQL. it's far better to use what is currently being enhanced vs. using a stagnant method JMO.
    I'm not anti-social, I just don't like people -Tommy Holden

  12. #11
    Code400 Newbie
    Join Date
    Jun 2009
    Location
    Yemen
    Posts
    33
    Rep Power
    447

    Re: how to create a PF file

    Thanks tom ,

    I still wanting to understand the structure on as400 technology

    I am just in the begining , hope i will get the idea soon

    what is the most unique feaure you see it in as400 which make it different than other systems
    Last edited by newp; June 10th, 2009 at 10:44 AM.

  13. #12
    Harbinger of Doom tomholden's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Tennessee, United States
    Posts
    4,335
    Rep Power
    8657

    Re: how to create a PF file

    Quote Originally Posted by newp View Post
    Thanks tom ,

    I still want to understand the structure on as400 technology

    I am just in the begining , hope i will get the idea soon

    what is the most unique feaure you see it in as400 which make it different than other systems
    my suggestion is to a) get a good book/tutorial on the system or b) take a class or c) find a seminar or a local user group to help you learn. most of us here don't have the time to write a tutorial on the entire system, database, etc. especially when all of those are on the web. go to IBM's infocenter, tons of info there as well. google is your friend
    I'm not anti-social, I just don't like people -Tommy Holden

  14. #13
    Code400 Newbie
    Join Date
    Jun 2009
    Location
    Yemen
    Posts
    33
    Rep Power
    447

    Re: how to create a PF file

    ok thanks alot .
    because of that people always like open sources .
    i get also why only few ppl as400's experts. But how people will learn if their is no one have the ability to facilitate learning..

    who said if you want to learn you have to pay thousands ,I think as400 forum is the best place to ask ..
    Last edited by newp; June 10th, 2009 at 11:03 AM.

  15. #14
    Harbinger of Doom tomholden's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Tennessee, United States
    Posts
    4,335
    Rep Power
    8657

    Re: how to create a PF file

    Quote Originally Posted by newp View Post
    ok thanks alot .
    because of that people always like open sources .
    i get also why only few ppl as400's experts. But how people will learn if their is no one have the ability to facilitate learning..

    who said if you want to learn you have to pay thousands ,I think as400 forum is the best place to ask ..
    IBMs infocenter is 100% free...
    I'm not anti-social, I just don't like people -Tommy Holden

  16. # 666
    Circuit advertisement
    Join Date
    Aug 1965
    Location
    Yakutsk, Russia
    Posts
    1,000,000
     

Facebook Comments


Similar Threads

  1. Regarding Journaling
    By Sandeep D in forum RPG/RPGLE
    Replies: 3
    Last Post: November 16th, 2009, 07:37 AM
  2. Retrieve OUTQ Content List into PF
    By Shogun1950 in forum CLP/CLLE
    Replies: 9
    Last Post: August 11th, 2009, 09:28 AM
  3. Regd moving
    By sudha in forum Iseries System administration
    Replies: 4
    Last Post: April 26th, 2007, 09:17 AM
  4. Transferring Save file
    By vivek in forum RPG/RPGLE
    Replies: 13
    Last Post: July 10th, 2006, 10:32 PM
  5. reg RLU
    By shankar.as400 in forum ANY THING GOES
    Replies: 7
    Last Post: April 5th, 2006, 11:18 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •