Re: Query Fails In PHP db2_exec But Is Good in System I Navigator.

On 12/4/2015 1:00 PM, Rob wrote:

I did notice that when I created the tables in SiN...( Sounds funny )..
that it reported that the tables would not be journaled.

I have since gone into SiN and dropped the table.

I then created the table from the PHP script.

Unless I deeply misunderstand something, you still do not have a table
which is journaled. In order to journal a table, one needs to:
1) Issue STRJRNPF against it - see your system admins!
2) Create the table in a schema which in turn was created with the SQL
CREATE SCHEMA statement. This schema will automatically journal tables
created within it.

This may not turn out to be the issue for this particular problem, but
it is useful to know, so I'm leaving it here for the archives.