|
View previous topic :: View next topic
|
| Author |
Message |
dejunzhu
Active User
Joined: 08 May 2008
Posts: 390
Location: China
|
|
|
|
I'm going to generate a large volume of data, say, containing 1,000,000,000 records, and load the DS into a table.
for example, I have below table definition,
| Code: |
CREATE TABLE AAAAA.ATTTTT(
ACCTID INTEGER NOT NULL,
ACCTNAME CHAR(2) NOT NULL,
TEL CHAR (9) NOT NULL,
PRIMARY KEY(ACCTID)
)
IN TESTDB01.TSATTT; |
do you have better way to generate this dataset using DFSort ?
thanks. |
|
| Back to top |
|
 |
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
| You could use IEBDG. |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
dejunzhu,
You could use one record in SORTIN and specify OUTFIL with REPEAT and SEQNUM to generate a large number of output records. (But I'm not really sure what you're trying to do exactly so that may or may not be relevant). |
|
| Back to top |
|
|
dejunzhu
Active User
Joined: 08 May 2008
Posts: 390
Location: China
|
|
|
|
| Frank Yaeger wrote: |
dejunzhu,
You could use one record in SORTIN and specify OUTFIL with REPEAT and SEQNUM to generate a large number of output records. (But I'm not really sure what you're trying to do exactly so that may or may not be relevant). |
thanks, Frank,
this is just what I'm looking for. |
|
| Back to top |
|
|
|
|
