Error in accessing table

alam_ather — Fri, 23 May 2014 09:07:27 GMT

Hi - I am unable to understand an error which I am continously getting while running a small code. Actually I am trying to access IBM AS400 table. Here is the code and error description

LIBNAME AS400 ODBC DSN = 'C400'; SYSTEM = TABLE_X SCHEMA=DIRECTORY;

PROC SQL;

Create Table SASUSER.TestRun AS

Select *

FROM AS400.TABLE_X

WHERE Me_ID EQ '0213456'

;

QUIT;

ERROR: CLI prepare error: [IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL data

type argument out of range.

SQL statement: SELECT * FROM TABLE_X.

On the other hand, when I try to access other table in the same database, it gives me all the desired results.Here is the code:

LIBNAME AS400 ODBC DSN = 'C400'; SYSTEM = TABLE_Y SCHEMA=DIRECTORY;

PROC SQL;

Create Table SASUSER.TestRun AS

Select CDNO, ACLMT, STS, NAME, BAL

FROM AS400.TABLE_Y;

QUIT

The code is same except the table names of the same databse. Please help me to resolve the problem.

thanks

Re: Error in accessing table

jakarman — Fri, 23 May 2014 10:17:16 GMT

do some debugging using sastrace. SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Third Edition

Re: Error in accessing table

Kurt_Bremser — Fri, 23 May 2014 10:31:29 GMT

The error most probably comes from the DB2 ODBC driver.

You might get a clue here:

IBM DB2 10.5 Information Center for Linux, UNIX, and Windows

Maybe the where condition is the culprit (numeric/char conversion?)

topic Error in accessing table in SAS Enterprise Guide

Error in accessing table

Re: Error in accessing table

Re: Error in accessing table