Error using Parameters in stage SybaseIQ Load

[BI]

We are using stage SybaseIQ Load. We can set parameters like DBNAME, SERVER, etc. Job compiles without error but when we execute the job we get an error and by checking the log in director we can see that the variables have not been replaced by the value specified in the parameter file (We see that DBNAME is #DBNAME# while we would expect to be replaced by the real value).

Does anyone know how to solve the problems ? Can it be a "bug" in datastage ?

Thanks for your answers.

BI.

[ray.wurlod]

Welcome aboard.

When you see #DBNAME# (or any value surrounded by "#") in your job log it suggests strongly that that job parameter was not set for this job run.

Could it be that your job uses environment variables, and the parameter reference should therefore have been #$DBNAME# ? Or is the parameter reference simply misspelled where it is used in the job design?

There are probably other things you could check, but it's not a bug in DataStage.

[uegodawa]

Create an environment variables and assign the values over there.

In your job add those environment variables as parameters and set default value to $PROJDEF.

Now, in your Sybase IQ stage variable should look likes #$DBNAME#

[BI]

Create an environment variables and assign the values over there.

In your job add those environment variables as parameters and set default value to $PROJDEF.

Now, in your Sybase IQ stage variable should look likes #$DBNAME#

Thanks for your reply we did it a try but it didn't work. We have entered a PMR at IBM for resolution. I keep you posted.