Error while parameterize the surrogate file in SCD stage

nirdesh2 · Post by **nirdesh2** » Thu Feb 12, 2009 3:13 am

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.

richdhan · Post by **richdhan** » Thu Feb 12, 2009 4:38 am

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

nirdesh2 · Post by **nirdesh2** » Thu Feb 12, 2009 5:32 am

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

priyadarshikunal · Post by **priyadarshikunal** » Thu Feb 12, 2009 6:20 am

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

Code: Select all

#$DS_LAND#/surr_file.txt

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

And tell us the result.

Regards,

ray.wurlod · Post by **ray.wurlod** » Thu Feb 12, 2009 1:58 pm

Please advise what the precise compiler error is.

Mike · Post by **Mike** » Thu Feb 12, 2009 4:12 pm

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

Mike

DSguru2B · Post by **DSguru2B** » Thu Feb 12, 2009 4:28 pm

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

richdhan · Post by **richdhan** » Fri Feb 13, 2009 12:28 am

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

Mike · Post by **Mike** » Fri Feb 13, 2009 7:09 am

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

nirdesh2 · Post by **nirdesh2** » Mon Feb 16, 2009 2:14 am

Using job parameter, it is working.