EXEC_SP and Non-Persisted tables

crisg0112

Hi,

Is it possible for a stored procedure to return a result set in a NonPersisted BO's?

I tried using the 'RETURN npResult' but its not returning anything.

BenHayat

This is just a memory object/collection that is created bt Aware server that has a limited life span. So, there is nothing stored on disk to be retrieved by SQL engine.

crisg0112

BenHayat wrote
This is just a memory object/collection that is created bt Aware server that has a limited life span. So, there is nothing stored on disk to be retrieved by SQL engine.

Thanks for the reply Ben!

Was hoping theres a way to use 'session variables' when you do Exec in SQL. Our user (dbadmin) doesn't really like using 'temp tables' as issues can come up if a process fails to finish (like clearing it afterwards).

any ideas? Or you really have to use an awareim BO to hold the result?

BenHayat

Cris, None-persisted DB, is NOT even a temp table. It's a memory object/collection that only reside in Aware's domain runtime memory. No one else have access to it.

It's a great feature, I use it many places when I only need data not to be stored in DB.
You need to use regular BO objects to be seen by others.

crisg0112

BenHayat wrote
Cris, None-persisted DB, is NOT even a temp table. It's a memory object/collection that only reside in Aware's domain runtime memory. No one else have access to it.

It's a great feature, I use it many places when I only need data not to be stored in DB.
You need to use regular BO objects to be seen by others.

Thanks Ben!

Is there a way for AwareIM to read temporary sql tables? Say I have this sql statement as part of my stored procedure

SELECT deptnum, location, count(*) as cnt
INTO #LocCount
FROM employees
GROUP BY deptnum, location

and then create a query using #LocCount?

The fact that the table starts with a '#', SQL treats it as a temporary table and the 'table disappears' after the whole process. SQL manages this table so it will be cleaner in a database point-of-view.

BenHayat

crisg0112 wrote
BenHayat wrote
Cris, None-persisted DB, is NOT even a temp table. It's a memory object/collection that only reside in Aware's domain runtime memory. No one else have access to it.

It's a great feature, I use it many places when I only need data not to be stored in DB.
You need to use regular BO objects to be seen by others.

Thanks Ben!

Is there a way for AwareIM to read temporary sql tables? Say I have this sql statement as part of my stored procedure

SELECT deptnum, location, count(*) as cnt
INTO #LocCount
FROM employees
GROUP BY deptnum, location

and then create a query using #LocCount?

The fact that the table starts with a '#', SQL treats it as a temporary table and the 'table disappears' after the whole process. SQL manages this table so it will be cleaner in a database point-of-view.

I haven't got to this area of Aware yet, so I can't answer that question. Sorry!

crisg0112

BenHayat wrote
crisg0112 wrote
BenHayat wrote
Cris, None-persisted DB, is NOT even a temp table. It's a memory object/collection that only reside in Aware's domain runtime memory. No one else have access to it.

It's a great feature, I use it many places when I only need data not to be stored in DB.
You need to use regular BO objects to be seen by others.

Thanks Ben!

Is there a way for AwareIM to read temporary sql tables? Say I have this sql statement as part of my stored procedure

SELECT deptnum, location, count(*) as cnt
INTO #LocCount
FROM employees
GROUP BY deptnum, location

and then create a query using #LocCount?

The fact that the table starts with a '#', SQL treats it as a temporary table and the 'table disappears' after the whole process. SQL manages this table so it will be cleaner in a database point-of-view.

I haven't got to this area of Aware yet, so I can't answer that question. Sorry!

Thats ok Ben! IF I get it working, will post the solution here. Appreciate your time 🙂