RE: Error inserting into iSeries DB2 table with long name viaSQL Server2000 linked Server

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

Veron,

The case doesn't matter unless the name is in quotes.

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vernon Hamberg
> Sent: Monday, January 23, 2006 8:46 AM
> To: Midrange Systems Technical Discussion
> Subject: RE: Error inserting into iSeries DB2 table with long 
> name viaSQL Server2000 linked Server
> 
> Does the case match on the short name? It doesn't in your example. 
> Not sure whether that will matter.
> 
> OTOH, if you are interested in pulling from the iSeries instead of 
> pushing to it, give me a call. (verndor response). Sometimes that is 
> not an option, as the data is changed at the SQL Server box, and that 
> is the one in control. But who knows?
> 
> Vern
> 888.rjs.soft
> 
> At 06:47 AM 1/23/2006, you wrote:
> 
> >So nobody else has run into this?
> >
> >Are you using long names on your iSeries tables?
> >
> >Anybody out there with an SQL server they could try this on?
> >
> >Thanks,
> >
> >Charles Wilt
> >--
> >iSeries Systems Administrator / Developer
> >Mitsubishi Electric Automotive America
> >ph: 513-573-4343
> >fax: 513-398-1121