https://www.macsqlclient.com/
never used it, don't know if it is any good

or  https://docs.microsoft.com/en-us/sql/azure-data-studio/download?view=sql-server-2017 - forgot that this new thing existed

Should not be to hard to format the sql but...

This gives the desire result for the supplied data - as no rules were defined I assumed the following

have a look at http://blog.bittersweetryan.com/2012/01/using-oracles-free-sql-developer-as.html?m=1

you will also need jTDS https://sourceforge.net/projects/jtds/ (mentioned on the link above) and follow a few steps

care must be taken with the exact...

theres a connection string setting for that. and another JAR that may be required as far as I remember.

Going to try and find it out as I did...

one of the possible issues is a big log file with lots and lots of virtual files

do this on the database and see how many you got. If...

Sorry for the delay and for the long post below.

If any one has any comments/questions/suggestions all are welcome.

I've decided to have a go at processing this...

I do prefer convert due to the extra functionality over cast. And from a standard point of view I think its better to stick with a single format type unless...

Looks like you are having fun:D

I do have a comment - avoid FORMAT if the same formatting can be achieved with convert - check https://sqlperformance.com/2015/06/t-sql-queries/format-is-nice-and-all-but

Just a quick note to say this is not forgotten - just complex and with other things to do at the moment.
Part of the work done though.

@jeff...

tell them you need to load this to a SQL Server database - they should already have had that request many times, and its easy enough for them to do...

Hi,

Had a look at the file and its going to be a bit more complex as it has multiple record types on it.

I may be able...

File is indeed ebcdic - but as it contains COBOL packed fields you will need to convert those independently within SSIS before loading to the database.

Have a look...