Issue reported in JDE.LOG while in Table / View Design

JDE.LOG when a View is created over an existing table
=====================================================

1036/3960 Sun May 22 12:58:10 2011 ODBC_P3.C734
ODB0000149 - SQLPrepare failed in F4111

1036/3960 Sun May 22 12:58:10 2011 ODBC_P3.C737
[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL5016 - Qualified object name F4111 not valid. - SQLSTATE: S1000

1036/3960 Sun May 22 12:58:10 2011 JDBODBC.C3089
ODB0000009 - Unable to get table spec. numbers

1036/3960 Sun May 22 12:58:10 2011 jdb_drvm.c1374
JDB9900184 - Failed to get table specs from db

1036/3960 Sun May 22 12:58:10 2011 jdb_rq1.c6597
JDB9900275 - Failed to get foreign table specs

1036/3960 Sun May 22 12:58:10 2011 jdb_rq1.c6282
JDB3100050 - Failed to load table information

While creating the view over the new table
===========================================

956/2908 Sun May 22 15:35:06 2011 ODBC_P3.C734
ODB0000149 - SQLPrepare failed in F55UST2

956/2908 Sun May 22 15:35:06 2011 ODBC_P3.C737
[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL5016 - Qualified object name F55UST2 not valid. - SQLSTATE: S1000

956/2908 Sun May 22 15:35:06 2011 JDBODBC.C3089
ODB0000009 - Unable to get table spec. numbers

956/2908 Sun May 22 15:35:06 2011 jdb_drvm.c1374
JDB9900184 - Failed to get table specs from db

956/2908 Sun May 22 15:35:06 2011 jdb_rq1.c6597
JDB9900275 - Failed to get foreign table specs

956/2908 Sun May 22 15:35:06 2011 jdb_rq1.c6282
JDB3100050 - Failed to load table information



XE Update 4, SP23H, IBM-V5R3

I am not sure why you posted the same question twice in the forum. Try the top one from this LINK .