Invali Argu Value -Missing Warning thrown

aninash · Post by **aninash** » Mon Jun 03, 2013 3:42 am

I have check condition with list of around 20 columns in AND condition which should check either null or 0 from a file.This is made as configurable,such as this condition is written to a file and it is passed as a parameter to the stage varaible of a job.Then checked as If this Paramter then N else Y.If N then i need to filter those records.
When i pass the entire expression in a stage varaible the records are filtered but when i pass via parameter i am receiving a warning called INVALID ARGUE VALUE and the expression is missing and no records are passed to filter link.

Kindly help.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 03, 2013 4:16 am

Welcome aboard. The first thing to determine is precisely what values are being passed as parameters. Inspect the "job starting" event in the job log, and let us know what you see.

aninash · Post by **aninash** » Mon Jun 03, 2013 4:46 am

Thanks Sir.
The entire expression given in the file is passed to the job parameter when the job triggered.
I have given in the file as e.g (three columns) ((Lnk_Zero_Position.A=0 Or Trim(NullToEmpty(Lnk_Zero_Position.A))='"") and (Lnk_Zero_Position.B=0 Or Trim(NullToEmpty(Lnk_Zero_Position.B))='"") and (Lnk_Zero_Position.C=0 Or Trim(NullToEmpty(Lnk_Zero_Position.C))='"") )
This i am reading as cat filename in execute command stage and passed as paramter to job.
So this expression is assigned to parameter when i check the job starting.

In Transformer i assigned this parameter to a stage variable of varchar 255 like If Zero_Pos=1 then 'N' else 'Y' but it is passing for all records as Y when i checked in Peek stage.

The incoming value may have empty string/0/sum numeric values.

Now i have a doubt whether that expression is executed but when i put the entrie expression in constraint it is working but not via parameter.

Reason behind paramterizng the constraints is currently we need to check the same for 24 columns ,later they may reduce or add the columns.So there should not be any code chnage often for this purpose.

Kindly help

chulett · Post by **chulett** » Mon Jun 03, 2013 6:18 am

Unfortunately, you cannot pass expressions like that as parameters. It just becomes a string value at that point as there aren't two levels of resolution here.

aninash · Post by **aninash** » Mon Jun 03, 2013 6:30 am

In this case how can i handle this scenario.

I tried through unix script but here issue is the filtering record should undergo lookup with another file to check if same Account is available if so shouldnt filter the same.
That's the reason i tried to implement this in Datastage.
Is there any otehr solution to handle this?

Kindly advise.

chulett · Post by **chulett** » Mon Jun 03, 2013 6:41 am

I wasn't sure off the top of my head what your alternative is here which is why I didn't include that in my reply. I know the topic has been discussed here but not sure what key words would turn them up for you. Already running late this morning so hopefully someone else can chime in here shortly...

aninash · Post by **aninash** » Mon Jun 03, 2013 6:45 am

No Problem Sir.Thanks a lot.I am searching with keywords parameter but mainly discussed about passing in a query and nested parameter is discussed.

chulett · Post by **chulett** » Mon Jun 03, 2013 7:00 am

One last thought. Basically, what you're looking for is a "rules engine", see if an exact search here for those two words turn up anything.