# ---
# jupyter:
#   jupytext:
#     text_representation:
#       extension: .py
#       format_name: light
#       format_version: '1.5'
#       jupytext_version: 1.14.4
# ---

# # Module 6: Lecture load data
#
#
# ## Problems
#
# When you load data from a CSV file, you have to ensure the dataset get assigned correctly the different data types and formats. An area that could be particularly problematic is the one with the DATES, HOURS and TIMESTAMPS, because his formats can vary significantly.
#
# In the case that the database instance doesn't recognize automatically the data format correctly, or the default configuration doesn't match, you have to fix it manually before load into the database, otherwise it's possible to get errors like ` SQLSTATE=22007`
#
# ## Fix
#
# To avoid this errors, on the DB2 console, you can get a preview of the datatypes and the format that are assigned automatically.
# If there are any problem, usually Db2 identifies it and shows you with a warning message.
#
# To fix this, you can check pressing the clock icon to see the different formats available, if there aren't visible yet.
#
# First, check if already exist a default format that match with your date/hour/timestamp format. If not, select the correct format from the available ones.
#
#
#
#
#

StarcoderdataJupyterScriptsDedupFiltered