Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Load command

Status
Not open for further replies.
ddiamond

ddiamond

Programmer
Apr 22, 2005
918
US
On linux and windows, the fastest way to bulk load data into a table is using the load command. Does OS400 have anything similar? If not, what is the best way to load data into DB2 on OS400?
 
Sort by date Sort by votes
That depends on where your data is. You can use CPYFRMIMPF if your data is in a flat file in the IFS.

Typy CPYFRMIMPF on the command line and press F1 for the command's help text (don't press Enter).

Feles mala! Cur cista non uteris? Stramentum novum in ea posui!

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

DMo42
  • Locked
  • Question
DB2 11.1 SQL1022C There is not enough memory available to process the command
Replies
0
Views
275
DMo42
DMo42
mpezeur
  • Locked
  • Question
coredump on DB2 v10.1 upgrade database command
Replies
2
Views
91
papadba
papadba
vikramrao
  • Locked
  • Question
How to pass IN param value also to db2 load utility
Replies
0
Views
47
vikramrao
vikramrao
MarcLodge
  • Locked
  • Question
Load mainframe db2 from Excel spreadsheet
Replies
7
Views
144
fredericofonseca
fredericofonseca
tekpr00
  • Locked
  • Question
DB2 on AIX equivalet commands of Oracle on Unix.
Replies
0
Views
61
tekpr00
tekpr00

Part and Inventory Search

Sponsor

Back
Top