I have some fields in my tables defined as Date Data Types. By default, the data types are set to 01/01/0001. On the display, I use keyword MAPVAL(('01/01/0001' *BLANK)) to display the field as blank. There doesn't appear to be a similar keyword for external Print Files. Anyone have any tips on...

Hello,

I'm trying to create a User-Defined Table Function (UDTF) which receives 2 parameters: a CLOB_LOCATOR which is, for example, the full content of a UTF-8 text file and a VARCHAR(2) delimiter value which specifies what character(s) (e.g. x'0D0A') indicate a line break within the first...

Tried to move an integrated web server webservice from http to https and received message about certificate not trusted. Eventually decided to revert to http and try again another day. Now I've got another problem, the http version of the webservice now fails. I've recreated it several times without...

Check below example,

Exec Sql Declare cursor c1 for
Select fld1, fld2 from tempfile;

Exec Sql Open c1

Dow Sqlcod = 0;
Exec Sql Fetch c1 into :Outfile; // clob file
Enddo;

Problem when there are no records, the file is still created...

Hello,

I have an interactive program that is not working properly.
In my program, I fill in a temporary file (via SQL) and then I process the file.

Here is the SQL :
EXEC SQL insert into wfictmp1
(wservic, wimmeub, wnumcop, wdattrt)
select servic, immeub,...