DSXchange

Or straigt away use Server job.
http://www.dsxchange.com/viewtopic.php? ... ght=waveno

A quick search on SQLSTATE=22005 will should you that, its due to data type mismatch. The same reason why Arnd asking the question.
Also check if the value that been send for lookup fields (key1 and key2) are of compatiable datatype.

How are you trying it? Write a routine which calls the UserStatus function. It has been discussed serveral times. Following will be the code for the function. INCLUDE DSINCLUDE JOBCONTROL.H *FUNCTION UpdateUserStatus(Arg1) Call DSSetUserStatus(Arg1) Ans = Arg1 RETURN(Ans)

Hmm... thats interesting to find all these online.

ChangeCapture/Difference stages are also available for this reason.

May be not in the same job. Chances to get Read error or unexpected result based on the design of your job. Why do you need to use it in the same job?

By the way, what are you trying to do through dataset Management window? Are you trying to delete a file?
What you see if you click on 'Output'?

Wrap the statement in a stored procedure and call the SP from Datastage. There should be other way as well, but the above mentioned is doable.

Is it Server Edition?
There is no data available for the given data in the reference table.

http://www.dsxchange.com/viewtopic.php? ... 32&start=0

You can just have look in to this thread.

Paddu - There could be of various reasons for this. Search for your error or create a new topic as mentioned.

Its my mistake. I failed to give a space after '.' and ".

FOR /f "tokens=2-4 delims=."

. Though it created the directory, it was gives out permission error for that directory.

xinhuang66 - The reason explained earlier. Bind variables not been used. Thats the reason, Fully generated query is advised, which will be taken care by it self. The query will return the tows as you expect. But while doing a lookup, it matches with only the first row in the array irrespective any c...

ray.wurlod wrote:I suspect kumar_s meant "linking" rather than "liking".

Problem with Keyboard and Chair.
Ray, You could have used atleast LoL emoticons.

By the 'Edit/Delete this Post' option. You can delete from reverse order.