Data load new record command

The LOAD command!

In various data loading tools and programming languages, the LOAD command is used to load new data records into a database, file, or data structure. Here are a few examples:

DB2

In DB2, the LOAD command is used to load data from a file into a database table. The syntax is:

LOAD FROM 'file_name' OF DEL MODIFIED BY
  CHARDELIM AS ',' TERMINATED BY ',' 
  INTO TABLE table_name

Oracle

In Oracle, the LOAD command is used to load data from a file into a database table. The syntax is:

LOAD DATA
  INFILE 'file_name'
  INTO TABLE table_name
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
  TRAILING NULLCOLS

Microsoft Access

In Microsoft Access, the LOAD command is used to load data from a file into a table. The syntax is:

DoCmd.TransferText acLoadData, "Text Import Specification", "Table Name", "File Name"

Python

In Python, the LOAD command is not a built-in command. However, you can use libraries like pandas to load data from a file into a DataFrame:

import pandas as pd

df = pd.read_csv('file_name.csv')

SQL Server

In SQL Server, the BULK INSERT command is used to load data from a file into a table. The syntax is:

BULK INSERT table_name
FROM 'file_name'
WITH
  (FORMATFILE = 'format_file_name.xml',
   FIRSTROW = 2,
   IGNOREBLANKROWS = 1)

These are just a few examples of the LOAD command in different contexts. The specific syntax and options may vary depending on the tool or language being used.