ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

how to create a PF file

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • how to create a PF file

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

    Thanks

  • #2
    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
    "Tis better to be thought a fool then to open one's mouth and remove all doubt." - Benjamin Franklin

    Comment


    • #3
      Re: how to create a PF file

      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

      Comment


      • #4
        Re: how to create a PF file

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

        bests

        Comment


        • #5
          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

          Comment


          • #6
            Re: how to create a PF file

            Ok i got it how

            thanks for your help

            Comment


            • #7
              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?

              Comment


              • #8
                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
                IS Director, eCommerce & Web Development
                Acceptance Insurance Corporation
                www.AcceptanceInsurance.com
                www.ProvatoSys.com

                Comment


                • #9
                  Re: how to create a PF file

                  Thanks Tom

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

                  Comment


                  • #10
                    Re: how to create a PF file

                    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

                    Comment


                    • #11
                      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 10, 2009, 09:44 AM.

                      Comment


                      • #12
                        Re: how to create a PF file

                        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

                        Comment


                        • #13
                          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 10, 2009, 10:03 AM.

                          Comment


                          • #14
                            Re: how to create a PF file

                            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

                            Comment

                            Working...
                            X