Even though the records are fetched by SPUFI for the query,the SQLCODE is shown as 100. Why?
- We mentioned MAX SELECT LINES ===> 200000. As only 5 rows returned SPUFI returned SQLCODE 100.If we change this MAX SELECT LINES to 1
How do you comment the SQL in the SPUFI input dataset?
By prefixing – -
When you run a Update Query in SPUFI, the changes will be made permanent automatically?
It depends on the AUTOCOMMIT option.
I ran a query to fetch remarks which is of 250 VARCHAR item of an employee. But SPUFI shows only 80 characters. There is truncation. What could be the possible reason?
That could be the limit you set up for CHAR item.