RE: Error grabbing the next reacord key from Alps system.

At first glance it looks like SQL syntax error, but can't be sure without
additional data.

You can get logs & other trace data by changing the odbc data source Tracing
tab as well individual data source Diagnostic tab (dbmon etc.). To start
odbc administrator click on Start->Run->odbcad32->OK.

Once you arm yourself with this debug data, you'll be able to tell what is
the SQL statement that's failing and be able to figure out how to correct
the issue.

Elvis

Celebrating 10-Years of SQL Performance Excellence

-----Original Message-----
Subject: Error grabbing the next reacord key from Alps system.

Anyone know what's preventing us from uploading to our AS/400?

Exception : Error grabbing the next reacord key from Alps system.
Inner Exception (1) : ERROR [42000] [IBM][Client Access Express ODBC
Driver (32-bit)][DB2/400 SQL]SQL0104 - Token . was not valid. Valid
tokens: ( TABLE LATERAL <IDENTIFIER>.

Description:
System.Data.Odbc.OdbcException: ERROR [42000] [IBM][Client Access
Express ODBC Driver (32-bit)][DB2/400 SQL]SQL0104 - Token . was not
valid. Valid tokens: ( TABLE LATERAL <IDENTIFIER>.
at System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle,
SQL_HANDLE hType, RETCODE retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior
behavior, String method)
at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior
behavior)
at AISDataObjectsConcrete.ODBCDBConnection.ExecuteDataReader(String
psQueryString)