Automatically appending to a SQL statement...

[NJCam]

Quick question...

We're using Impromptu 6.0.317 with DB2 v7.1 and DB2 Client which is installed on each users PC. Currently, DB2 will always append "For Fetch Only" to the end of each SQL statement prior to executing it.

Is there any way we can append "With UR" instead of "For Fetch Only"? I've been searching high and low for this value in INI files and also with the settings of the DB2 Client. Haven't found anything so far...

Any help would be much appreciated.

Thanks in advance,
- Sam

 

[Shek]

You are edit the sql ( change for fetch only to..) once you run a report, but after that you cannot format any columns and manipulation of the report has to be thru the sql window In Report--->Query---> Sql.

HTH