SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 VMS RMS File to sql
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mcupryk
Yak Posting Veteran

Canada
90 Posts

Posted - 08/12/2013 :  12:35:06  Show Profile  Reply with Quote
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 25

Any help would be awesome.

jeffw8713
Aged Yak Warrior

USA
798 Posts

Posted - 08/12/2013 :  14:20:19  Show Profile  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000