Free-Hand SQL - BO 5.1.7 1

[BrianTyler]

Is it possible to allow complex freehand SQL when querying against DB2.

I am trying to use the 'WITH' structure to create a temporary table repeatedly used in a long query containg about 10 UNIONS.

The error message says that I am only allowed to use SELECT statements.

Thanks

Brian

 

[blom0344]

There is a supervisor setting under 'Query Technique' that refers to 'Restrict SQL to select only'

Did you try to reset this?
By the way, I do not think this is a DB2 issue.
It is a BO issue.



Ties Blom

 

[BrianTyler]

Thanks Tiers,

I missed that bit of supervisor. I'll look at it over the next few days.

Regards

Brian

 

[BrianTyler]

Hi,

Ties was right (again). It worked fine.

Thank again

Brian