Search found 27 matches
- Mon May 27, 2019 2:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: WebService Time Out
- Replies: 5
- Views: 4758
Well, the WSDL I imported is defining the Response with the Tag : GetPriceResp But I spoke with the guy that wrote the WebServices and WSDL, and he told me that the outcome of the WebService can be also : Fault NO Timeout with : <?xml version=1.0 encoding=UTF-8?> < GetPriceResp xmlns=http://domgen.c...
- Sun May 26, 2019 8:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: WebService Time Out
- Replies: 5
- Views: 4758
Re: WebService Time Out
I found why the Stage is giving a Time out, but don't know if I can resolve this in Datastage. In the Output XML, is expecting the TAG : <GetPriceResp> ... </GetPriceResp> But in some errors , the WebService does not send those TAG, <?xml version="1.0" encoding="utf-8"?> <soapen...
- Sun May 26, 2019 4:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: WebService Time Out
- Replies: 5
- Views: 4758
Re: WebService Time Out
This is the XML Output I should receive ... (from Postman, it is a Soap GUI) <?xml version="1.0" encoding="utf-8"?> <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"> <soapenv:Body> <soapenv:Fault> <faultcode>Client</faultcode> <faultstring>An ...
- Sun May 26, 2019 4:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: WebService Time Out
- Replies: 5
- Views: 4758
WebService Time Out
Hello, I'm calling a WebService (using the WebService Transformer). When the WebService return a correct answer, all is ok. But when for example, I change the value of a field in the XML input then the WebService should return me a controled Error, But the WebService is giving me a timeout. If for t...
- Tue Mar 19, 2019 6:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Order of execution
- Replies: 4
- Views: 3465
Order of execution
Hello, I have a parallel job and inside this parallel job I have 2 flows ( 2 sources and 2 target ). Is it possible to do something like ; # First run the first sources db2 and when it finish, run the 2d sources db2. # If not then run the first flow, when it finish, run the 2d flow. Right now I have...
- Wed Nov 07, 2018 8:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Duplicate records to Error
- Replies: 4
- Views: 3722
yes thank you, the sort with create key change column worked fine. Another solution was to do a Loop Condition within the Transform. The requirement was if 12 records dup, 11 to error and 1 (max Date) to output. If I had to send the 12 to Error, I think I would do a join after , between the unique k...
- Thu Nov 01, 2018 11:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Duplicate records to Error
- Replies: 4
- Views: 3722
Duplicate records to Error
Hello,
I 'm reading a file, where the fields , Person Identifier and the Item Identifier, are keys.
I would like to send to Error (for example an output file), all the duplicates records and just keep one (max load date). But don't know really how to do that , could you help me please ?
Thank You -
I 'm reading a file, where the fields , Person Identifier and the Item Identifier, are keys.
I would like to send to Error (for example an output file), all the duplicates records and just keep one (max load date). But don't know really how to do that , could you help me please ?
Thank You -
- Tue Sep 18, 2018 12:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: file connector schema file
- Replies: 3
- Views: 2671
- Tue Sep 11, 2018 1:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: file connector schema file
- Replies: 3
- Views: 2671
file connector schema file
Hello, I'm trying to use a file connector to write a file but using a schema file and run time column propagation. I need to use a schema file as my output delimiter will depend on the type of file I will generate as output. I've read that for this I have to create a file, with the <output_file_name...
- Thu Apr 28, 2016 3:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to abort a parallel job
- Replies: 4
- Views: 3555
how to abort a parallel job
Hello,
We need to create a parallel job that when a query retrieves rows, the job aborts.
Something like a source (with an inside query) then if the query retrieves some records, the job aborts.
thank you -
We need to create a parallel job that when a query retrieves rows, the job aborts.
Something like a source (with an inside query) then if the query retrieves some records, the job aborts.
thank you -
- Tue Mar 08, 2016 2:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: regular expression
- Replies: 2
- Views: 2147
regular expression
Hello, In example , We would like to replace any of the folling word1 with empty " in this sentence , change all this wordToChange to the string empty " " in this sentence , change all this -wordToChange- to the string empty " " in this sentence , change all this ?wordToChan...
- Fri Mar 04, 2016 2:52 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Remove all salacious words
- Replies: 3
- Views: 5610
Remove all salacious words
Hello, I have the same problem as noted here but still don't see the solution. I have to replace in an input string ( for example ADDRESS ) all the salacious words with Empty string for example ADDRESS = "Street Ass" then my output should be ADDRESS = "Street" If I use the erepla...
- Tue Feb 16, 2016 5:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: lookup with LIKE and not with EQUAL
- Replies: 9
- Views: 6154
- Mon Feb 15, 2016 9:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: lookup with LIKE and not with EQUAL
- Replies: 9
- Views: 6154
Sorry , it is not 2 input tables, but 2 input files Exactly what we have to do is we have one file with the addresses and another that is a catalog ( with swear words ) and we find one of those swear word in the address , then we have to blank it. The catalog file with the swear word is not fixed , ...
- Mon Feb 15, 2016 8:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: lookup with LIKE and not with EQUAL
- Replies: 9
- Views: 6154
lookup with LIKE and not with EQUAL
Hello, We have a small table , that contains "words". Then I have a table with one field of address What I have to do is to check if the address contains the words". In SQL is something like select * from table_adress , table_words where table_adress.address like '%words%' As we are n...