We are currently in the process of moving data from a DEC Alpha machine using VMS to SQL Server 2000. All the files on the DEC were created using VAX Basic. I have one file, on the DEC, that is made up of a number of fields that are arrays with up to 300 elements in each array. The problem I have is the boss wants the files on the sql server 2000 to line up with the dec file. I had the elements broken down as a seperate table on the server 2000 with a header that pointed to the (elements) data table. Not good enough. Everything I have read does not lead me to believe what the boss wants can be done. Anyone have thoughts (good or bad) on what I can do to solve this.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
using arrays in sql server 2000
- Thread starter flyrodder
- Start date
Man ... a blast from the past! Had a similar project w/ a company in Austin TX that was converting from flat file on a OpenVMS system using DEC Basic. You were correct in setting up the tables as you described. There are no arrays in SQL Server. Closest object that resembles an array in SQL Server is a table variable. Not much help there. You are on the right track! Normalize the flat file structure and build upon that.
Thanks
J. Kusch
Thanks
J. Kusch
Not sure if this will help you, but i was looking at array usage yesterday and found this document
- Status
Similar threads
- Locked
- Question
- Locked
- Question