Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

How to convert a file from EBCDIC format to ASCII using SQL LOADER in ATP Database

user-b7crrMar 2 2023

Hi All,

We have a requirement to load a data file coming in EBCDIC format to a table in ATP database. We are trying to push the file to object storage and load file to ATP via DBMS_CLOUD api.

However in source file in a single row, we have multiple records with a character delimiter for each record (380 characters). Due to this we are only able to decrypt the file partially while loading to database.

Below is the .ctl file snippet used in the older system(On Prem ODI - going to sunset) with character delimiter of fixed 380 characters. Could anyone suggest a way around to implement in ATP+ Object Storage ?

INFILE "/integro/INTERFACES/GLINT06/PROCESS/GIBF_L265_20221002.101145" "FIX 380"
BADFILE "/integro/INTERFACES/GLINT06/LOG/GLINT06_HEADER_RECORD.bad"
DISCARDFILE "/integro/INTERFACES/GLINT06/PROCESS/GLINT06_HEADER_RECORD.dsc"
DISCARDMAX 9999999

Thanks,

Anoop

Comments
Post Details