-
Notifications
You must be signed in to change notification settings - Fork 8
/
createfileutility.htm
236 lines (235 loc) · 22.6 KB
/
createfileutility.htm
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
<!DOCTYPE HTML>
<html id="hs-topic-p">
<!-- saved from url=(0025)http://www.helpsmith.com/ -->
<head>
<title>CreateFile Utility</title>
<meta charset="windows-1252" />
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<meta name="generator" content="HelpSmith 9.4 (Build 22.705)" />
<style type="text/css" media="screen">
html {
overflow: hidden;
margin: 0;
padding: 0;
height: 100%;
}
body {
overflow: hidden;
margin: 0;
padding: 0;
height: 100%;
}
#non-scrolling-area {
padding: 0 10px 0 10px;
background-color: #5e5f5f;
}
#container {
overflow: auto;
-webkit-overflow-scrolling: touch;
}
#content {
padding: 0 10px 5px 10px;
}
</style>
<link type="text/css" rel="stylesheet" href="../css/topics/style.css" />
<script type="text/javascript" src="../js/jquery-3.6.0.min.js"></script>
<script type="text/javascript" src="../js/nsa.js?0a86901a"></script>
<script type="text/javascript" src="../js/settings.js?f55a7ab4"></script>
<script type="text/javascript" src="../js/core.min.js?0a86901a"></script>
<script type="text/javascript" src="../js/topic.min.js?0a86901a"></script>
<script type="text/javascript">
var topicContext = 2360;
</script>
<!-- Web Help Topic -->
<!-- HTML Help (CHM) Topic -->
</head>
<body>
<div id="non-scrolling-area">
<h1 class="hd0"><span class="ts0">CreateFile Utility</span></h1>
</div>
<div id="container">
<div id="content-background">
<div id="content">
<p> </p>
<p class="ps1"><span class="ts2">The CreateFile utility allows you to create ISAM files based on repository file or structure definitions.</span></p>
<p class="ps1"><span class="ts2">The command line options for the CreateFile utility are as follows:</span></p>
<p class="ps1"><span class="ts3"> CreateFile -f <fname> | -s <sname> [-out filespec] [-r] [-h]</span></p>
<p class="ps1"><span class="ts3"> -f <fname> </span><br /><span class="ts3"> Name of repository file definition to process.</span></p>
<p class="ps1"><span class="ts3"> -s <sname></span><br /><span class="ts3"> The name of the repository structure definition to process.</span></p>
<p class="ps1"><span class="ts3"> -in <infile></span><br /><span class="ts3"> Name of JSON input file containing the details of file(s) to create.</span></p>
<p class="ps1"><span class="ts3"> -out <filespec></span><br /><span class="ts3"> File spec of file to create, overriding repository file spec. Not used with -in.</span></p>
<p class="ps1"><span class="ts3"> -r Replace existing files. The default is not to replace existing files. Not used with -in.</span></p>
<p class="ps1"><span class="ts3"> -h Display this usage information.</span></p>
<p class="ps1"><span class="ts2">When creating a file based on a repository file definition, the key specifications will be determined by the keys defined in the first structure that is assigned to the file. When creating a file based on a repository file structure, the file specifications will be determined by the first file that the structure is assigned to. CreateFile assumes that the repository key definitions are defined in the same sequence as the keys that they refer to. It is assumed that the first defined key is the primary key, the second key (if any) is the first alternate key, and so on. </span></p>
<p class="ps1"><span class="ts2">The -f and -s options can only be used to create ISAM files. The -in option can be used to create ISAM and RELATIVE files, but RELATIVE files can only be created if an input file containing initial data is provided.</span></p>
<p class="ps1"><span class="ts2">The input file used with the -in option must be a JSON file similar to this:</span></p>
<p class="ps1"><span class="ts3"> [</span><br /><span class="ts3"> {</span><br /><span class="ts3"> "RepositoryFileName": "CUSTOMER",</span><br /><span class="ts3"> "CreateFile": "DAT:CUSTOMER.ISM",</span><br /><span class="ts3"> "LoadFromFile": "TESTDATA:CUSTOMER.TXT",</span><br /><span class="ts3"> "OverwriteExistingFile": true</span><br /><span class="ts3"> },</span><br /><span class="ts3"> {</span><br /><span class="ts3"> "RepositoryFileName": "OPTIONS",</span><br /><span class="ts3"> "CreateFile": "DAT:OPTIONS.DDF",</span><br /><span class="ts3"> "LoadFromFile": "TESTDATA:OPTIONS.TXT",</span><br /><span class="ts3"> "OverwriteExistingFile": false</span><br /><span class="ts3"> }</span><br /><span class="ts3"> ]</span></p>
<p><span class="ts2">Including "CreateFile" is optional. By default the file spec of the repository file definition is used.</span></p>
<p><span class="ts2"> </span></p>
<p><span class="ts2">Including "LoadFromFile" is optional for ISAM files, if not provided an empty file will be created. For relative files you mUST provide an initial data file and that file MUST contain at least one record of the appropriate length.</span></p>
<p><span class="ts2"> </span></p>
<p><span class="ts2">Including "OverwriteExistingFile" is optional. By default files will NOT be overwritten.</span></p>
<p><span class="ts2"> </span></p>
<h2 class="hd1"><span class="ts1">Example 1</span></h2>
<p class="ps1"><span class="ts3">C:\> createfile -f CUSTFIL</span></p>
<p class="ps1"><span class="ts3">DAT:customer.ism -> File created.</span></p>
<h2 class="hd1"><span class="ts1">Example 2</span></h2>
<p class="ps1"><span class="ts3">C:\> createfile -s CUSTOMER</span></p>
<p class="ps1"><span class="ts3">DAT:customer.ism -> File created.</span></p>
<h2 class="hd1"><span class="ts1">Example 3</span></h2>
<p class="ps1"><span class="ts3">C:\> createfile -f CUSTFIL -f DAT:customer_save.ism</span></p>
<p class="ps1"><span class="ts3">DAT:customer_save.ism -> File created.</span></p>
<p class="ps1"><span class="ts1">Example 4</span><span class="ts3"> </span></p>
<p class="ps1"><span class="ts3">C:\> CreateFile -in CreateAndLoadFiles.json</span></p>
<p><span class="ts2">Where CreateAndLoadFiles,json contains:</span></p>
<p><span class="ts3"> </span></p>
<p class="ps13"><span class="ts19">[</span></p>
<p class="ps13"><span class="ts19"> {</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"RepositoryFileName"</span><span class="ts19">: </span><span class="ts21">"MEMBERS"</span><span class="ts19">,</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"CreateFile"</span><span class="ts19">: </span><span class="ts21">"CUFILES:MEMB01.DDF"</span><span class="ts19">,</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"LoadFromFile"</span><span class="ts19">: </span><span class="ts21">"SEQ:MEMB01.SEQ"</span><span class="ts19">,</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"OverwriteExistingFile"</span><span class="ts19">: </span><span class="ts45">true</span></p>
<p class="ps13"><span class="ts19"> },</span></p>
<p class="ps13"><span class="ts19"> {</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"RepositoryFileName"</span><span class="ts19">: </span><span class="ts21">"ACCOUNTS"</span><span class="ts19">,</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"CreateFile"</span><span class="ts19">: </span><span class="ts21">"CUFILES:MEMB02.DDF"</span><span class="ts19">,</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"LoadFromFile"</span><span class="ts19">: </span><span class="ts21">"SEQ:MEMB02.SEQ"</span><span class="ts19">,</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"OverwriteExistingFile"</span><span class="ts19">: </span><span class="ts45">true</span></p>
<p class="ps13"><span class="ts19"> },</span></p>
<p class="ps13"><span class="ts19"> {</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"RepositoryFileName"</span><span class="ts19">: </span><span class="ts21">"PERSONS"</span><span class="ts19">,</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"CreateFile"</span><span class="ts19">: </span><span class="ts21">"CUFILES:PERMST.DDF"</span><span class="ts19">,</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"LoadFromFile"</span><span class="ts19">: </span><span class="ts21">"SEQ:PERMST.SEQ"</span><span class="ts19">,</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"OverwriteExistingFile"</span><span class="ts19">: </span><span class="ts45">true</span></p>
<p class="ps13"><span class="ts19"> },</span></p>
<p class="ps13"><span class="ts19"> {</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"RepositoryFileName"</span><span class="ts19">: </span><span class="ts21">"CHCARD"</span><span class="ts19">,</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"CreateFile"</span><span class="ts19">: </span><span class="ts21">"CUFILES:CHCARD.DDF"</span><span class="ts19">,</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"LoadFromFile"</span><span class="ts19">: </span><span class="ts21">"SEQ:CHCARD.SEQ"</span><span class="ts19">,</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"OverwriteExistingFile"</span><span class="ts19">: </span><span class="ts45">true</span></p>
<p class="ps13"><span class="ts19"> },</span></p>
<p class="ps13"><span class="ts19"> {</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"RepositoryFileName"</span><span class="ts19">: </span><span class="ts21">"TRANSMAS"</span><span class="ts19">,</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"CreateFile"</span><span class="ts19">: </span><span class="ts21">"CUTRX:TRANSMAS.DDF"</span><span class="ts19">,</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"LoadFromFile"</span><span class="ts19">: </span><span class="ts21">"SEQ:TRANSMAS.SEQ"</span><span class="ts19">,</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"OverwriteExistingFile"</span><span class="ts19">: </span><span class="ts45">true</span></p>
<p class="ps13"><span class="ts19"> },</span></p>
<p class="ps13"><span class="ts19"> {</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"RepositoryFileName"</span><span class="ts19">: </span><span class="ts21">"OPTIONS"</span><span class="ts19">,</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"LoadFromFile"</span><span class="ts19">: </span><span class="ts21">"SEQ:OPTIONS.SEQ"</span><span class="ts19">,</span></p>
<p class="ps13"><span class="ts19"> </span><span class="ts20">"OverwriteExistingFile"</span><span class="ts19">: </span><span class="ts45">true</span></p>
<p class="ps13"><span class="ts19"> }</span></p>
<p class="ps13"><span class="ts19">]</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts2">The output looks like this:</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3">********************************************************************************</span></p>
<p><span class="ts3">Processing file MEMBERS</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> - ISAM file CUFILES:MEMB01.DDF replaced</span></p>
<p><span class="ts3"> - Data load command: fconvert -s -it SEQ:MEMB01.SEQ -ai CUFILES:MEMB01.DDF</span></p>
<p><span class="ts3"> - Data load starting at: 14:43:34</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> Summary of Statistics</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> Records Read/Write: 000004/000004 Errors Read/Write: 0/0</span></p>
<p><span class="ts3"> Exception Records: 0</span></p>
<p><span class="ts3"> Elapsed Time: 00:00:01 Kb/sec: 5.8594</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> - Data load ending at: 14:43:34</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3">********************************************************************************</span></p>
<p><span class="ts3">Processing file ACCOUNTS</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> - ISAM file CUFILES:MEMB02.DDF replaced</span></p>
<p><span class="ts3"> - Data load command: fconvert -s -it SEQ:MEMB02.SEQ -ai CUFILES:MEMB02.DDF</span></p>
<p><span class="ts3"> - Data load starting at: 14:43:34</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> Summary of Statistics</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> Records Read/Write: 000004/000004 Errors Read/Write: 0/0</span></p>
<p><span class="ts3"> Exception Records: 0</span></p>
<p><span class="ts3"> Elapsed Time: 00:00:01 Kb/sec: 7.8125</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> - Data load ending at: 14:43:34</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3">********************************************************************************</span></p>
<p><span class="ts3">Processing file PERSONS</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> - ISAM file CUFILES:PERMST.DDF replaced</span></p>
<p><span class="ts3"> - Data load command: fconvert -s -it SEQ:PERMST.SEQ -ai CUFILES:PERMST.DDF</span></p>
<p><span class="ts3"> - Data load starting at: 14:43:34</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> Summary of Statistics</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> Records Read/Write: 000003/000003 Errors Read/Write: 0/0</span></p>
<p><span class="ts3"> Exception Records: 0</span></p>
<p><span class="ts3"> Elapsed Time: 00:00:01 Kb/sec: 4.7402</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> - Data load ending at: 14:43:34</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3">********************************************************************************</span></p>
<p><span class="ts3">Processing file CHCARD</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> - ISAM file CUFILES:CHCARD.DDF replaced</span></p>
<p><span class="ts3"> - Data load command: fconvert -s -it SEQ:CHCARD.SEQ -ai CUFILES:CHCARD.DDF</span></p>
<p><span class="ts3"> - Data load starting at: 14:43:34</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> Summary of Statistics</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> Records Read/Write: 000003/000003 Errors Read/Write: 0/0</span></p>
<p><span class="ts3"> Exception Records: 0</span></p>
<p><span class="ts3"> Elapsed Time: 00:00:01 Kb/sec: 2.9297</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> - Data load ending at: 14:43:34</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3">********************************************************************************</span></p>
<p><span class="ts3">Processing file TRANSMAS</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> - ISAM file CUTRX:TRANSMAS.DDF replaced</span></p>
<p><span class="ts3"> - Data load command: fconvert -s -it SEQ:TRANSMAS.SEQ -ai CUTRX:TRANSMAS.DDF</span></p>
<p><span class="ts3"> - Data load starting at: 14:43:34</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> Summary of Statistics</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> Records Read/Write: 000034/000034 Errors Read/Write: 0/0</span></p>
<p><span class="ts3"> Exception Records: 0</span></p>
<p><span class="ts3"> Elapsed Time: 00:00:01 Kb/sec: 34.8965</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> - Data load ending at: 14:43:34</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3">********************************************************************************</span></p>
<p><span class="ts3">Processing file OPTIONS</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> - RELATIVE file CUFILES:CUNOPT.DDF will be created</span></p>
<p><span class="ts3"> - Data load command: fconvert -s -it SEQ:OPTIONS.SEQ -or -fr 651 CUFILES:CUNOPT.DDF</span></p>
<p><span class="ts3"> - Data load starting at: 14:43:34</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> Summary of Statistics</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> Records Read/Write: 000005/000005 Errors Read/Write: 0/0</span></p>
<p><span class="ts3"> Exception Records: 0</span></p>
<p><span class="ts3"> Elapsed Time: 00:00:01 Kb/sec: 0.0049</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> - Data load ending at: 14:43:34</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3">********************************************************************************</span></p>
<p><span class="ts3">Processing summary:</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3"> - 6 files created, 0 failed.</span></p>
<p><span class="ts3"> - 6 files loaded, 0 failed.</span></p>
<p><span class="ts3"> </span></p>
<p><span class="ts3">********************************************************************************</span></p>
<p class="ps13"><span class="ts8"> </span></p>
<p><span class="ts2"> </span></p>
<p><span class="ts2"> </span></p>
<div>
<hr class="hline1" />
</div>
<p class="ps8"><span class="ts10">Copyright © 2021 Synergex International, Inc.</span></p>
</div>
</div>
</div>
</body>
</html>