What you perhaps can do is the following.

Create a user on the AS400 with the same details on the NT Domain.

The IFS uses the same username and password the the...

Hi Steve,

I would look at the impotance of the software (cost, maintenance etc) and then compare the cost and effort of installing sql server as linked server VS a router...

Hi All,

Your problem is Security related.

I have the same problem running iSeries 830 in Win2000 Domain.

Sometimes it works and other time it fails. This is totally random.

I would suggest...

Hi Jay,

What is your remote db ?

I had the same problem with IBM DB2/400. Had to change the database default for ansi padding and warnings in the end.

Regards CJ

Hi Peg,

Dave is quit right.

The statement would be written as

select school_code, grade, NoStudents, FinalSubmit from spring_2004_data

where

(grade='k' OR grade='1' OR grade='2' OR grade='3') AND

((NoStudents='N' and FinalSubmit='Y') or NoStudents='Y')

An easy way of...