Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mcupryk
Yak Posting Veteran
91 Posts |
 Posted - 2013-08-12 : 12:35:06
|
| I have the following file that I need to convert to sql any help would be great. Record: NAME_REC of File: NAME_REC Organization: INDEXED Type: RMS Open: USER_DAT:NAMES.DAT Record Format: Fixed Supersede: No Record Size: 110 Bytes-- Record Contents -- Item Type Size Occ Offset RECORD_STATUS CHARACTER 1 0 CREATE_USERNAME CHARACTER 12 1 CREATE_DATE CHARACTER 8 13 CREATE_TIME CHARACTER 4 21 EDIT_USERNAME CHARACTER 12 25 EDIT_DATE CHARACTER 8 37 EDIT_TIME CHARACTER 4 45 PRIME_NAME CHARACTER 1 49 _PRIME_ALIAS CHARACTER 1 49 USER_SEX CHARACTER 1 50 USER_NAME_STRUCT CHARACTER 50 51 .LAST_NAME CHARACTER 25 51 .GIVEN_NAMES CHARACTER 25 76 USER_NUM ZONED UNSIGNED 9 101-- Index Contents -- ** SEX is a 60 byte REPEATING PRIMARY ASCENDING index ** Segment Type Size USER_SEX CHARACTER 1 LAST_NAME CHARACTER 25 GIVEN_NAMES CHARACTER 25 USER_NUM ZONED UNSIGNED 9 ** USER_NUMBER is a 35 byte REPEATING ALTERNATE ASCENDING index ** Segment Type Size USER_NUM ZONED UNSIGNED 9 PRIME_NAME CHARACTER 1 LAST_NAME CHARACTER 25Any help would be awesome. |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2013-08-12 : 14:20:19
|
| There is no straight conversion of that type of file - you need to use your VMS system to export the data from that file into a delimited text file that you can then copy to the SQL Server system and import. |
 |
|
|
|
|
|
VMS RMS File to sql