Can somebody tell me what is wrong with this?

This is my fex for the dynamic address

-INCLUDE testrcst
-RUN
-IF &LINES EQ 0 GOTO ENDRPT;
SET ASNAMES =ON
TABLE FILE MYADD
PRINT
MY_ADD AS 'DEST'
ON TABLE PCHOLD
END

-ENDRPT
SET ASNAMES =ON
TABLE FILE MYADD
PRINT
MY_ADD AS 'DEST'
ON TABLE PCHOLD
END

I am getting an error; the number of character equal to the length of my email address are added infront of my email address making my email address invalid.


Thanks.

The leading character count is the same behavior we see in 7.1.3 with VARCHARS. We had to make the setting change in edasprof...
ENGINE DB2 SET VARCHAR OFF

Don't know about your data source or WF version, but that is the same behavior we now see with VARCHARS unless we make the setting above.

Hope this helps,

Kevin

WF 7.1.3 AND Oracle.
I will try that setting and see if it cures the problem.

Thanks.

Thank you very much Kevin!

Yes, adding that solved the problem.

You are welcome...I should mention that that setting can be applied dynamically inside your focexecs and can be reversed in the focexecs as well. We made the choice to turn VARCHAR OFF globally (in edasprof)rather than retrofit all of our existing code. If we do run across the need for this new VARCHAR fuctionality, we know we will have to issue the ENGINE DB2 SET VARCHAR ON command on an individual focexec basis.

Glad it worked for you,

Kevin

Just a note here:

If you set the VARCHAR stuff before you create the master files, then they will be built without the "V" on the USAGE and ACTUAL attributes. Otherwise, you can edit your masters and remove the "V"'s so you will not have to issue the VARCHAR setting anymore.

d,

Good point if you are using MFDs to access the data. If however, you are using SQL pass-thru the SQL VARCHAR command is invaluable.

Keivn