I am getting a syntax error message on the following IF THEN ELSE statement.

IF J1.SEG01.LICENSE EQ '' THEN J0.SEG01.NONABACARDNUMBER ELSE J1.SEG01.LICENSE

I am trying to say if the field LICENSE is null then use NONABACARDNUMBER else use LICENSE

I am new to webfocus and couldn't find a function and/or not sure how to handle the 'null' scenario in a report section of a procedure.

This message has been edited. Last edited by: <Kathryn Henning>,

What is the size and format of the 2 fields you're using in the if,,,then,,,else?
The field on the left if the = sign must be the same size and format of those on the right side of the = sign.

Please show us the entire line of code.

You also need to put a semicolon at the end of the expression.

Use IS MISSING for a null test.

IF J1.SEG01.LICENSE IS MISSING THEN J0.SEG01.NONABACARDNUMBER ELSE J1.SEG01.LICENSE

As Tewy points out, you can use IS MISSING to test for missing data, but you can also use the IS-NOT MISSING syntax to test that there is data present.

You might find this link of use.

You might want to check out the use of SET MISSING = ON/OFF, (also SET HOLDMISS and SET COMPMISS) and how they might change the way you check for missing values in differing data sources (e.g. RDBMS, HOLD files etc.)

T

quote:

IF J1.SEG01.LICENSE EQ '' THEN J0.SEG01.NONABACARDNUMBER ELSE J1.SEG01.LICENSE

You might also want to check for blanks:

IF J1.SEG01.LICENSE EQ MISSING THEN J0.SEG01.NONABACARDNUMBER ELSE
IF J1.SEG01.LICENSE EQ ' ' THEN J0.SEG01.NONABACARDNUMBER ELSE
J1.SEG01.LICENSE

Thanks folks I believe the issue is with checking from the Nonabacardnumber which is an I11 type and Licence is an A6 type. I did an FPRINT(ABACARDNUMBER,'I11','A11') to convert it and then tried the SUBSTR on that define and still couldn't get it to work. Anyone have ideas on how to convert an I11 to an A6? The field never has anything more than 6 characters in it.

With FPRINT, the incoming format does not have to fully represent the actual format of the column that you are converting -

FPRINT(ABACARDNUMBER,'I6','A6')

or with leading zeroes

FPRINT(ABACARDNUMBER,'I6L','A6')

T

[SOLVED]