I tried it in the LEI forum , but I got no answer - Problem with SQL statement

HCL Domino Domino Forum
1

Hi,I´ve a LEI Command-Activity with an SQL statement.

With this sql I want to change a field attribute in a db2. when I start this sql directly on the iSeries, everything is ok.

But when I start this sql with a Command-Activity I get an error message.

I don´t know what is wrong !!

Here the error message from the lei (sorry some parts are in German)

13.07.2005 16:41:25 Activity started

13.07.2005 16:41:28 Trace Statement: <ALTER TABLE AKMNL.BRANCHEN ALTER COLUMN IDENTIFIER SET DATA TYPE CHAR (254 ) CCSID 273 NOT NULL >, Connector ‘SYS0099A’, Method -Execute-

13.07.2005 16:41:28 Error: Verarbeitung der SQL-Anweisung beendet. Ursachencode 10., Connector ‘SYS0099A’, Method -Execute- (-952)

13.07.2005 16:41:36 Activity Ended With An Error

My sql statement is:

ALTER TABLE AKMNL.BRANCHEN ALTER COLUMN IDENTIFIER SET DATA TYPE CHAR (254 ) CCSID 273 NOT NULL

Every tipp is welcome !!!

Stefanie

2

Subject: I tried it in the LEI forum , but I got no answer - Problem with SQL statement

Hallo Stefanie,

stinkt wie ein ODBC Problem.

Is your LEI on a iSeries or an external box. It is very likely, that the table structure can only be altered when working on the admin level. So you can start checking:

a) does the user used for LEI have sufficient priviledges for alter table?

b) can alter table run when the table is locked by the LEI task (I doubt that)

…

Short way out:

Redesign the app, so you don’t need to alter any tables

Hth

:wink: stw