Question SQLOperation to select tables to drop

Hi!

First of all, happy new year!

Second, I have a process wich is composed of two SQLOperations :
- the first one : select the table to drop on the database

- the second one : linked by a DirectBind to the first one, is getting the select result from # and is supposed to drop the tables

But... it doesn't do anything...
Any idea?

Thanks a lot!

Leo

Hi Thomas,

After execution, CORE_BIND_ITERATIONS = 0

I know that's not a good sign

When I execute the query on MSSQL Studio, it returns lines, but the same query executed in Stambia returns 0 line.
I think there is something wrong with the schema, it's like the query is not executed with the schema I set up in the parameters of the SQLOperation.

All good, it's working the DB + schema in the query!

Thanks!

Hello.

I have a problem similar to the one related to this topic

I must first create the list of queries to shrink periodically all our tables
Then I have to execute all the alter table queries, in the right order.

I have one Action Code object with this select query :
SELECT
'alter table DEV_PREPUSER2.' || table_name || ' enable row movement' LINE_1
,'alter table DEV_PREPUSER2.' || table_name || ' shrink space compact' LINE_2
,'alter table DEV_PREPUSER2.' || table_name || ' shrink space cascade' LINE_3
,'alter table DEV_PREPUSER2.' || table_name || ' disable row movement' LINE_4
FROM
user_tables
WHERE
TABLE_NAME not like '%$%'
AND rownum = 1

I first wanted to test the creation of the 4 alter table queries, for only 1 table. The aim is to delete the clause "AND rownum=1", in order to shrink all the tables.

I have a second Action Code object, linked to the first one by a Direct Bind, with this code :
:{LINE_1}:;
:{LINE_2}:;
:{LINE_3}:;
:{LINE_4}:;

Result : for only 1 table, the execution is working well, but when I delete the clause on the rownum, it doesn't work

What is missing in my 2 objects ? What has to be modified ?

Thanks in advance for your answers

Alex