Re: ODBC Error

[Dave Mahadevan <mahadevan@xxxxxxxx>]

Bill Phelps wrote:

> SELECT CKSWORK.CKACNO, CKSWORK.CKCHNO
> FROM *N.QS36F.CKSWORK CKSWORK
> WHERE (CKSWORK.CKACNO=0563002)
>
> One thing I am curious about is where is the  *N is coming from.  Is
> this the proper structure for SQL statements passed through ODBC?

The *N is the relational database name.  You did not provide the name in
the AS/400.  Do the following.  WRKRDBDIREand add the system name.  I
suggest using the same name as shown in your DSPNETA.  IMO *N should not
have caused your error.


--
Thank You.

Regards

Dave Mahadevan.. mailto:mahadevan@fuse.net


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---