Add input error

[techas400]

I have a program RPGLE which conditonally invokes a function key.

For instance:
If Screen A is opened then this RPG will have a function key F15 and if Screen B is opened this rpg will check if indicator is on and accordingly hide the functionality of this key.
I have been able...

[abercrombieande]

Seems straight forward but always returns 0.

CREATE FUNCTION ABC.TEST ( 
	AB VARCHAR(32) ) 
	RETURNS INTEGER   
	LANGUAGE SQL 
	
	BEGIN 
IF 1 = 1 THEN 
                    
	RETURN 1 ; 
ELSE 
	RETURN 2;

...

[abercrombieande]

I have this function that checks if a date is valid. Every time a date is invalid the sql exception occurs and fills my job log. Any ideas on how to keep this out of the job log?


CREATE FUNCTION testyt.ISDATE (
@DATE VARCHAR(10) )
RETURNS CHAR(1)
LANGUAGE...

[abercrombieande]

I really am lost. I have the "same" function in two libraries. The one in DWEXTLIB works fine but the one in DWPRDLIB does not. Its called from the same table so the results should be the same. Maybe its the square things in the screen shot. I really have no idea


...

[Fireloque]

Hi

Can someone please advise how my function should be written to do the following;

I've got a table that I want to count records for that match an input key value and another criteria. If this count is <= 12 then another table value is to be read and returned, otherwise...