DSXchange

When I give the full path of surrogate flat file in SCD stage to generate the Surrogate key, it works fine. But when I parameterize the surrogate flat file , SCD stage gives compile error. Please let me the reason.
ex..var/spool/hs/land/surr_file.txt----It works fine.
$DS_LAND$/surr_file.txt---It gives compilation error.

Hi,

It should be #$DS_LAND#/surr_file.txt.

How did you insert the parameter?

Dont do the hand coding. Use the GUI to insert the parameter.

HTH
--Rich

I am not hard coding. I am giving the parameter using Parameter GUI and its like #$DS_LAND#/surr_file.txt

nirdesh2 wrote:I am not hard coding. I am giving the parameter using Parameter GUI and its like #$DS_LAND#/surr_file.txt

If its really and its not working then try using job parameter instead of Environment variable.

And tell us the result.

Regards,

Please advise what the precise compiler error is.

There's a bug. See viewtopic.php?t=125177

Mike

Is there any patch for it? If no then take the error to IBM support engineers.

Hi,

We used to face the same issues with Teradata multiload stage in DS 7.5. We could not use the $. What we did was to create local job parameter say DS_LAND. Then we use the actual environment variable say $DS_LAND in the Job Sequence as a parameter. We map the $DS_LAND to DS_LAND in the job activity. This is a work around.

HTH
--Rich

IF I remember correctly, I think we did get a patch from support for this issue. It didn't work... and I wasn't in the mood to pursue it further. I just did a workaround by using a regular job parameter.

I was using AIX 5.3 server, Windows XP client, and version 8.0.1. Maybe the patch works on other releases... maybe the patch has been patched... I ran into this last fall.

Mike

Using job parameter, it is working.