Hardcoding values into Copy statement
Hello, I have a scenario where in I need to load table from flat file using COPY command The file has just one column the table has 5 columns first column needs to be loaded form the flat file and 3 column need to be hardoced( with some values) and last column is a sysdate(). Can anybody help me to achieve this. I wonder how copy statement can hardcode the value for specific columns.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.