Select Code to Download

@Clusters = qw/    Cluster_ID INT IDENTITY(1,1) PRIMARY KEY, Cluster_N
+ame VARCHAR(50) not NULL unique, DC_ID INT not NULL CONSTRAINT Cluste
+r_2_DC FOREIGN KEY REFERENCES dbo.Data_Centers(DC_ID)/;    


@Hosts = qw/Host_ID INT IDENTITY(1,1) PRIMARY KEY, Host_Name NVARCHAR(
+50) NULL, Cluster_ID int CONSTRAINT Host_2_Cluster FOREIGN KEY REFERE
+NCES dbo.Clusters(Cluster_ID), DC_ID int not NULL CONSTRAINT Host_2_D
+C FOREIGN KEY REFERENCES dbo.Data_Centers(DC_ID)/;

sub sql_write
{
...
            
    }
}

my $rec_id = &sql_write($host_data,$Ids,"srv")

$Ids->{DC} = $dc_id;
$Ids->{Cluster} = $cluster_id;

DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL Serve
+r]The INSERT statement conflicted with the FOREIGN KEY cons
raint "Host_2_Cluster". The conflict occurred in database "DEV1111", t
+able "dbo.Clusters", column 'Cluster_ID'. (SQL-23000) [er
 was 1 now 1] [state was 23000 now 01000]
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been 
+terminated. (SQL-01000) at U:\Doccuments\test.pl line 104, <DATA> lin
+e 1.