Hi,
I'm currently working on a task where a dynamic prodataset might be a perfect solution. From the 10.1B online help I just can't find how to create a dynamic temp-table with a before table.
I tried to create a second table with identical schema and assigned this temp-table handle to the BEFORE-TABLE attribute prior to calling TEMP-TABLE-PREPARE and that raises the error, that BEFORE-TABLE is not a setable attribute...
Is there a trick I did not find or is that not supported?
And if it's not supported are there plans to support that in a future release?
Thanks!
Mike
Hi Mike,
The before-table for a dynamic temp-table will be created when you set tracking-changes to true.
The before-table name is derived from the temp-table name with a "BI" prefix.
There is currently no way to change the name.
It seems that you are right that the online help lacks info about this.
Thanks,
Håvard
Great stuff. I did oversee that.
And I was very surprised, that I can pass a dynamic prodataset (where before-table names were build dynamically) to a procedure with a static prodataset definition where before-table names don't match that naming schema and I don't loose the change information.
Thank you Havard!
Mike