Forum Discussion

Sharon_hurley's avatar
Sharon_hurley
Copper Contributor
Apr 12, 2022

Hexadecimal flat files

Hi i need to import large hexidecimal flat files into one table in the sql server with a line having up to 2000 characters. The record does not need to be broken up yet.  Any suggestions?  I’m worr...
olafhelper's avatar
olafhelper
Bronze Contributor
Apr 13, 2022

Sharon_hurley , sorry, but for me it is not clear what your requirements are nor what you try to achieve here?

What's a hexdecimal file, an unusally term?

A binary file like an image?

Or a text file with hexadecimal representation of numbers?

And how does the target table look like (DDL statement)?

 

Olaf

Sharon_Hurley850's avatar
Sharon_Hurley850
Copper Contributor
Apr 13, 2022

 

Hi
Thanks for the questions. The text file has hexadecimal characters.  I don’t have any tables yet.  
 
I usually use SAS so that am not familiar with SQL server terms. In SAS I just infile the file and apply formats. Right now I am trying to do the same with SQL but worry about decimals and end of file characters. 
Sharon
  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Apr 14, 2022
    Still to less informations about the source file format & content.

    Olaf
    • Sharon_Hurley850's avatar
      Sharon_Hurley850
      Copper Contributor
      Apr 14, 2022

      Hi

       Thanks again for your reply. We receive the file from a large company using an interface built by COBOL. The file contains hexadecimal characters. 
      Sharon

Resources