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