This page (revision-3) was last changed on 26-Nov-2021 10:22 by JEscott

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
3 26-Nov-2021 10:22 3 KB JEscott to previous
2 26-Nov-2021 10:22 4 KB JEscott to previous | to last
1 26-Nov-2021 10:22 2 KB JEscott to last

Page References

Incoming links Outgoing links
CONVERSION FILE LAYOUTS
CONVERSION FILE LAYOUTS

Version management

Difference between version and

At line 25 removed 2 lines
You may stop providing fields at any point after the mandatory fields are provided, as all subsequent fields in the file will be treated as NULL.
At line 31 added 4 lines
Dates must be provided in the date format DD-Mon-YYYY unless you override the default date format in the SQL Loader control file.
Effective date files may leave the EFFECTIVE date null, and it will default to the “beginning of time” date.
At line 43 removed 7 lines
If you are using SQL Loader as your feeder program, there are certain considerations that must be made for the ASCII file that the SQL Loader program will read.
You may stop providing fields at any point after the mandatory fields are provided, as all subsequent fields in the file will be treated as NULL.
Dates must be provided in the date format DD-Mon-YYYY unless you override the default date format in the SQL*Loader control file.
At line 56 removed 6 lines
Effective date files may leave the EXPIRY date null, and it will default to the “end of time” date.
Effective date files may leave the EFFECTIVE date null, and it will default to the “beginning of time” date.
Effective date files that have records with different effective dates will cause “date-splitting” to occur.
At line 54 added 5 lines
----
![Notes|Edit:Internal.CONVERSION+FILE+LAYOUTS]
[{InsertPage page='Internal.CONVERSION+FILE+LAYOUTS' default='Click to create a new notes page'}]
This page (revision-3) was last changed on 26-Nov-2021 10:22 by JEscottTop