DSXchange

thanks chulett, I asked the user to send the files in CSV format so that I can get the data from the files through sequential file stage. My other issue is the files are sent to remote server. I did a search and found that FTP stage should be used for reading a file from remote server. I never used ...

The user sends files to the server once in a week and there are about 5 files. the format of these files is xls format. And these files should be mapped and transformed as per the requirement and loaded in the DB. Do I need to change the format to csv and use sequential file to get the data as a sou...

main_program: When preparing operator: When setting up transfer for "entity_id":Implicit conversion from source type "string[max=10]" to dest type "int32": Converting string to number.


please let me know any changes to get rid of the above warning

I designed a webservice with three operations seperately. Invoked the WSDL in soap UI and tested the service. the first operation has a very good performance. the second one takes 5 to 10 seconds for the response. (it has pad character environment variable in the job) the third takes 20 seconds for ...

I tried doing in the following way to get the output. The input for the transformer is in the following way INPUT user_id,user_code 123,ABAB 123,CDCD 123,KSKS 123,EFEF 456,UNKNOWN 456,CDCD 456,ABAB Using If then else condition the input is changed to user_id,user_code 123,Null 123,Null 123,KSKS 123,...

sai,thanks for the response My job is invoked as webservice so it runs always,sparse lookup is the best way i can do. ray, I searched the forum but could not find the right stagevar. can you post me the 2 stage variables for the transformer to get the required output INPUT user_id,user_code 123,ABAB...

Yes, ray my SQL would not get the result required and the output I get using the given query is 123,KSKS 123,Null 456,Null so I thought of removing the extra row with transformer. please help me with the function which you were telling about using in transformer with out using the query as ODBC is n...

Actually, the table has multiple userID's the table is something like... user_id,user_code 123,ABAB 123,CDCD 123,KSKS 123,EFEF 456,UNKNOWN 456,CDCD 456,ABAB and the output I require is 123,KSKS 456,Null i.e If KSKS is found get the ID and Code if not found get the ID and code(null) Is this possible ...

I used a query in ODBC which is select user_id, case user_code when 'KSKS' then 'KSKS' Else 'NULL' end as user_code from user_spec_ct where ORCHESTRATE.user_id=user_id; the problem is when I execute this query in aqua data studio(tool I use to execute queries) this works fine but when I use this in ...

I am using sparse lookup in the ODBC connector. with the normal lookup I get no errors or warnings but it takes long time to run the job. Using sparse lookup I see the following warnings... 1.Lookup_254: Schema field prefix in input data set 0 not present in design time information. Extended field p...

actually I will explain in detail what the job does I have a sequential file in the server which has data as ID Name pwd 123,abc,ert 456,jkk,yui 678,kjg,uiy each row is a request to a service(external service) I have a wsdl for that. Now I need to call this service by using this input file and send ...

this is in my dsenv file in the path /opt/IBM/InformationServer/Server/DSEngine #################################################################### # PLATFORM SPECIFIC SECTION set +u if [ -z "$DSHOME" ] && [ -f "/.dshome" ] then DSHOME=`cat /.dshome` export DSHOME fi if...

do we need to use only server jobs for calling a service( I mean for using web services pack) I tried parallel job got some errors ,now tried server job ang got this error I did search for "unable to create Java Virtual Machine" found reply which says setting the env variables DATASTAGE_JV...

I tried the server job using the temperature convertion service sequential------------->webservicetransformer---------->sequential compilation is fine but when I execute the job it throws an error TJClient::initialize: unable to create Java Virtual Machine; classpath = /opt/IBM/InformationServer/Ser...

Thanks ernie!! I am using 8.0.1 The sequential file input has input data as three different columns after that the stage webservice transformer is used and after that Sequential File output is used. Do I need to change the format to XML while sending the input to the webservice transformer or leave ...