DSXchange

Thanks for the reply Ray. I see both LIBPATH and LD_LIBRARY_PATH in the job log. Is that correct ? I thought we should only see LIBPATH as the OS is AIX but I am not sure where does the job get that LD variable as it's not there in the dsenv file and also in the profile of the user. I even tried to ...

Does anyone know why we get this warning and how can I correct it ? node_db2node0: Warning: the following libraries failed to load: "V14S0_JOBNAME_trn_fmt_tpa": Could not load "V14S0_JOBNAJME_trn_fmt_tpa": Could not load module . System error: No such file or directory; for class...

It is nullable in Source stage.

Expect 14 spaces in a decimal field? It will not allow that. it will show 000000.00 for the specified precision. You may want to convert the target field to string to get empty instead of 0s NULL will be NULL in varchar field. It will not become 0s unless it is specifically converted. Tell us the s...

It does not work even If I covert it to Varchar. I still see 0's in the file.

I am having problem handling nulls when I write to a seq file stage. It's a decimal column and I made it as nullable and in the Null Field Value I put 14 spaces as the length is 12 and precision is 3. But I see 0's in the output file. Two queastions. 1. Is there a better way than typing 14 nulls in ...

Yes. I read the same. We made some progress. There was a problem with Webservice and I also added a trasformer before and after WSTransform stage. I mapped the input field to in and output field to out field in the transformers. Now my question is how do we pass more than one field to web service as...

Can anyone tell me what am I missing ? Is someone can tell me what are the stpes to call a webservice ?

I have a documentation which I followed and apparently it does not work it seems. Job does not fail but I am not getting the response correctly.

We have a small job where we are trying to call the Web service. It's a sample webservice which is going to pass the request as response meaning if I pass a string it should return the same string. Job design is as follows... Seq File---->Transformer----->WSTransformer---->Seq File Input seq file ha...

We are looking into the possibility of accessing web services from DataStage. By searching this forum I found that we need web service pack for that. When I looked at what we have we found the following. 60806-DSWSEX RTI Agent Is this the web service pack ? Is that all we need ? If this is not the o...

But what If I have multiple updates coming in the same batch ? Now, some of those updates I may not want to take it to Target as they may be dummy. For this I need to look for the last record updated in the Database which is possible only with dynamic lookup. I think to get the functionality of dyna...

This is not compilation error. This warning comes when we run the job and even the job finishes fine. I am just wondering why this warning is coming.

Just FYI...We just upgraded to EE...

We can't do upsert as we do capture intra day changes and moreover using upsert will slow thigns down. What I meant by dynamic lookup is that when I insert a row in the table I shoule be able to see that in the lookup immediately as we capture intra day changes and we may get insert and update in th...

All of sudden we are getting the following error. node_db2node0: Warning: the following libraries failed to load: "V10S0_JobName_trn": Could not load "V10S0_JobName_trn": Could not load module . System error: No such file or directory; for class "APT_TransformOperatorImplV10...

I mentioned 0 and it worked. Now I have my constraints as follows: If Column_From_Lookup = 0 then Insert Else Update and then I am passing only Inserts to Target. I am facing a different problem though...when we have both Insert and update coming in the same load even though I mentioned Array size a...