6/13/2023 0 Comments Ebcdic file viewer![]() Initially I tried to view the data without defining the record separator but ODI threw exceptions stating ".dataset.DataSetException: Execution of query failed." and ": Record separator cannot be null for file C:/FILENAME" ![]() Inspecting the data file through a hex dump I can verify there are no record separator characters present. I specified the EBCDIC newline character (hex 0x15) for this field, but this was just an educated guess. Presumably this is because it never finds the record separator character that I was forced to define in the "Files" tab. Using the "View Data" feature I can see all my fields being translated perfectly, but it doesn't go beyond the first record. I'm connecting to the file using the .file.FileDriver / jdbc:snps:dbfile driver. I'm experiencing the same issue in ODI 11g.įirst I ftp'd (in binary mode) a copy of the EBCDIC file to my local drive (Windows XP) and defined the file format manually in ODI Studio.
0 Comments
Leave a Reply. |