ibm-information-center/dist/eclipse/plugins/i5OS.ic.dbp_5.4.0.1/rbafocrepf.htm

86 lines
5.5 KiB
HTML
Raw Permalink Normal View History

2024-04-02 14:02:31 +00:00
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="en-us" xml:lang="en-us">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="security" content="public" />
<meta name="Robots" content="index,follow" />
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
<meta name="DC.Type" content="task" />
<meta name="DC.Title" content="Create a physical file" />
<meta name="abstract" content="This topic shows how to create a physical file using data description specifications (DDS)." />
<meta name="description" content="This topic shows how to create a physical file using data description specifications (DDS)." />
<meta name="DC.subject" content="physical file, creating, file, physical, creating physical" />
<meta name="keywords" content="physical file, creating, file, physical, creating physical" />
<meta name="DC.Relation" scheme="URI" content="rbafophysf.htm" />
<meta name="DC.Relation" scheme="URI" content="rbafocrtlib.htm" />
<meta name="DC.Relation" scheme="URI" content="rbafocsrce.htm" />
<meta name="DC.Relation" scheme="URI" content="rbafosrcwrk.htm" />
<meta name="DC.Relation" scheme="URI" content="rbafosetcom.htm" />
<meta name="DC.Relation" scheme="URI" content="../cl/crtpf.htm" />
<meta name="DC.Relation" scheme="URI" content="../cl/crtsrcpf.htm" />
<meta name="DC.Relation" scheme="URI" content="../rzatc/rzatcgetstartinav.htm" />
<meta name="DC.Relation" scheme="URI" content="../db2/rbafzmsthctabl.htm" />
<meta name="copyright" content="(C) Copyright IBM Corporation 1998, 2006" />
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 1998, 2006" />
<meta name="DC.Format" content="XHTML" />
<meta name="DC.Identifier" content="rbafocrepf" />
<meta name="DC.Language" content="en-us" />
<!-- All rights reserved. Licensed Materials Property of IBM -->
<!-- US Government Users Restricted Rights -->
<!-- Use, duplication or disclosure restricted by -->
<!-- GSA ADP Schedule Contract with IBM Corp. -->
<link rel="stylesheet" type="text/css" href="./ibmdita.css" />
<link rel="stylesheet" type="text/css" href="./ic.css" />
<title>Create a physical file</title>
</head>
<body id="rbafocrepf"><a name="rbafocrepf"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">Create a physical file</h1>
<div><p>This topic shows how to create a physical file using data description
specifications (DDS). </p>
<div class="p">You need to create a library and a source file before you create a
physical file.</div>
<div class="section"> <p>To create a physical file, follow these steps:</p>
</div>
<ol><li class="stepexpand"><span>If you are using DDS, enter DDS for the physical file into a source
file. </span> This can be done using the source entry utility (SEU). SEU
is part of IBM<sup>®</sup> WebSphere<sup>®</sup> Development
Studio for iSeries™. </li>
<li class="stepexpand"><span>Create the physical file. </span> You can use the Create Physical
File (CRTPF) command, or the Create Source Physical File (CRTSRCPF) command.</li>
</ol>
<div class="section"> <div class="p">The
following command creates a one-member file using DDS and places it in a library
called DSTPRODLB. <pre>CRTPF FILE(DSTPRODLB/ORDHDRP)
TEXT('Order header physical file')</pre>
</div>
<p>As shown, this
command uses defaults. For the SRCFILE and SRCMBR parameters, the system uses
DDS in the source file called QDDSSRC and the member named ORDHDRP (the same
as the file name). The file ORDHDRP with one member of the same name is placed
in the library DSTPRODLB.</p>
<p>Similar to physical files are tables. Tables
can be created using iSeries Navigator or using the CREATE TABLE SQL statement. </p>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbafophysf.htm" title="These topics discuss the unique considerations for creating a physical file.">Set up physical files</a></div>
</div>
<div class="relconcepts"><strong>Related concepts</strong><br />
<div><a href="rbafocrtlib.htm" title="A library is a system object that serves as a directory to other objects. It groups related objects and allows the user to find objects by name.">Create a library</a></div>
<div><a href="rbafocsrce.htm" title="These topics describe how to create a source file.">Create a source file</a></div>
<div><a href="rbafosrcwrk.htm" title="These topics describe how to enter and maintain data using various methods.">Work with source files</a></div>
<div><a href="rbafosetcom.htm" title="These topics introduce several methods for describing iSeries database files, with focus on how to describe database files using data description specifications (DDS) because DDS has the most options for defining data.">Describe database files</a></div>
<div><a href="../rzatc/rzatcgetstartinav.htm">Get started with iSeries Navigator</a></div>
</div>
<div class="relref"><strong>Related reference</strong><br />
<div><a href="../cl/crtpf.htm">Create Physical File (CRTPF) command</a></div>
<div><a href="../cl/crtsrcpf.htm">Create Source Physical File (CRTSRCPF) command</a></div>
<div><a href="../db2/rbafzmsthctabl.htm">CREATE TABLE</a></div>
</div>
</div>
</body>
</html>