<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Regarding Referential integrity constraint (urgent) in SAS Enterprise Guide</title>
    <link>https://communities.sas.com/t5/SAS-Enterprise-Guide/Regarding-Referential-integrity-constraint-urgent/m-p/3675#M1190</link>
    <description>Hi All,&lt;BR /&gt;
I am getting the following error while executing my code in EG on AIX server.&lt;BR /&gt;
&lt;BR /&gt;
&lt;B&gt;ERROR:&lt;/B&gt; Unable to obtain constraint information for data set &lt;B&gt;ia.temp1&lt;/B&gt; because it is within a concatenated library and contains a referential integrity constraint.&lt;BR /&gt;
&lt;BR /&gt;
&lt;BR /&gt;
This dataset has 3 fileds A,B, C and A is the primary key here.&lt;BR /&gt;
The value which I am trying to insert in the table is unique.&lt;BR /&gt;
&lt;BR /&gt;
The code which I tried executing is:&lt;BR /&gt;
&lt;BR /&gt;
&lt;B&gt;proc sql noprint;&lt;BR /&gt;
	insert into ia.temp1 values('SPAAA' , 'pain', ',');&lt;BR /&gt;
quit;&lt;BR /&gt;
run;&lt;/B&gt;&lt;BR /&gt;
&lt;BR /&gt;
Any suggestion would be appreciable.</description>
    <pubDate>Mon, 02 Jul 2007 12:40:18 GMT</pubDate>
    <dc:creator>deleted_user</dc:creator>
    <dc:date>2007-07-02T12:40:18Z</dc:date>
    <item>
      <title>Regarding Referential integrity constraint (urgent)</title>
      <link>https://communities.sas.com/t5/SAS-Enterprise-Guide/Regarding-Referential-integrity-constraint-urgent/m-p/3675#M1190</link>
      <description>Hi All,&lt;BR /&gt;
I am getting the following error while executing my code in EG on AIX server.&lt;BR /&gt;
&lt;BR /&gt;
&lt;B&gt;ERROR:&lt;/B&gt; Unable to obtain constraint information for data set &lt;B&gt;ia.temp1&lt;/B&gt; because it is within a concatenated library and contains a referential integrity constraint.&lt;BR /&gt;
&lt;BR /&gt;
&lt;BR /&gt;
This dataset has 3 fileds A,B, C and A is the primary key here.&lt;BR /&gt;
The value which I am trying to insert in the table is unique.&lt;BR /&gt;
&lt;BR /&gt;
The code which I tried executing is:&lt;BR /&gt;
&lt;BR /&gt;
&lt;B&gt;proc sql noprint;&lt;BR /&gt;
	insert into ia.temp1 values('SPAAA' , 'pain', ',');&lt;BR /&gt;
quit;&lt;BR /&gt;
run;&lt;/B&gt;&lt;BR /&gt;
&lt;BR /&gt;
Any suggestion would be appreciable.</description>
      <pubDate>Mon, 02 Jul 2007 12:40:18 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Enterprise-Guide/Regarding-Referential-integrity-constraint-urgent/m-p/3675#M1190</guid>
      <dc:creator>deleted_user</dc:creator>
      <dc:date>2007-07-02T12:40:18Z</dc:date>
    </item>
    <item>
      <title>Re: Regarding Referential integrity constraint (urgent)</title>
      <link>https://communities.sas.com/t5/SAS-Enterprise-Guide/Regarding-Referential-integrity-constraint-urgent/m-p/3676#M1191</link>
      <description>Hi:&lt;BR /&gt;
  If this is an urgent need for problem resolution, then your best bet is to contact SAS Technical Support: &lt;A href="http://support.sas.com/techsup/contact/index.html" target="_blank"&gt;http://support.sas.com/techsup/contact/index.html&lt;/A&gt;&lt;BR /&gt;
 &lt;BR /&gt;
cynthia</description>
      <pubDate>Mon, 02 Jul 2007 22:10:25 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Enterprise-Guide/Regarding-Referential-integrity-constraint-urgent/m-p/3676#M1191</guid>
      <dc:creator>Cynthia_sas</dc:creator>
      <dc:date>2007-07-02T22:10:25Z</dc:date>
    </item>
  </channel>
</rss>

