DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 23 matches
Author Message
Resolved
 Topic: Duplicate records to Error
Gius

Replies: 4
Views: 308

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 07, 2018 8:38 am   Subject: Duplicate records to Error
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 D ...
Resolved
 Topic: Duplicate records to Error
Gius

Replies: 4
Views: 308

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 01, 2018 11:04 pm   Subject: Duplicate records to Error
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Additional info: Send duplicates Error (for a key), 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 k ...
 Topic: file connector schema file
Gius

Replies: 3
Views: 349

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Sep 18, 2018 12:24 am   Subject: file connector schema file
yes, it did not work the schema file method. If I put in the schema file the delimiter "#" for the fields, this did not work, I had in the output file the "|".

Yes I used the RC then I suppose that ...
 Topic: file connector schema file
Gius

Replies: 3
Views: 349

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Sep 11, 2018 1:02 am   Subject: file connector schema file
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
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 ...
 Topic: xml
Gius

Replies: 3
Views: 821

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Dec 05, 2017 11:01 am   Subject: xml
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hello,
I need to do the following but don´t know which STAGE to use.

1- Read from a table (just one field XML_INPUT_FIELD LonNVarchar)
This table contains in this fields the XML.

Thi ...
 Topic: how to abort a parallel job
Gius

Replies: 4
Views: 1660

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Apr 28, 2016 3:49 am   Subject: how to abort a parallel job
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
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 abort ...
 Topic: regular expression
Gius

Replies: 2
Views: 1083

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Mar 08, 2016 2:55 am   Subject: regular expression
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
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 -wor ...
 Topic: Remove all salacious words
Gius

Replies: 3
Views: 2886

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri Mar 04, 2016 2:52 am   Subject: Remove all salacious words
DataStage® Release: 11x
Job Type: Server
OS: Windows
Hello, I have the same problem [url=http://www.dsxchange.com/viewtopic.php?t=120886]as noted here but still don't see the solution.

I have to replace in an input string ( for example ADDRESS ) al ...
 Topic: lookup with LIKE and not with EQUAL
Gius

Replies: 9
Views: 2533

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Feb 16, 2016 5:21 am   Subject: lookup with LIKE and not with EQUAL
Hello,
the problem is the "Word" , is not just ONE word , is a list of words
thank you -
 Topic: lookup with LIKE and not with EQUAL
Gius

Replies: 9
Views: 2533

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 15, 2016 9:59 am   Subject: lookup with LIKE and not with EQUAL
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 swea ...
 Topic: lookup with LIKE and not with EQUAL
Gius

Replies: 9
Views: 2533

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 15, 2016 8:34 am   Subject: lookup with LIKE and not with EQUAL
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
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 ...
 Topic: remove strange character
Gius

Replies: 9
Views: 2958

PostForum: General   Posted: Tue Jun 09, 2015 8:06 am   Subject: remove strange character
well it is exactly what "priyadarshikunal" wrote in is answer => �
it is what i see when i do a select in db2
when i do the oposite with seq () it give me the value 0
 Topic: remove strange character
Gius

Replies: 9
Views: 2958

PostForum: General   Posted: Tue Jun 09, 2015 7:26 am   Subject: remove strange character
well I tried in a transform this :

if DSLink253.PER_FIRST_INITIAL = char ( 65533 ) then 'ok ' else 'ko'

but it always give my ko ...
 Topic: remove strange character
Gius

Replies: 9
Views: 2958

PostForum: General   Posted: Tue Jun 09, 2015 4:15 am   Subject: remove strange character
Well

Convert("�", "", DSLink7.firstInitial)


this not work as when I paste the strange caracter in the transform, it paste

? instead �
 Topic: remove strange character
Gius

Replies: 9
Views: 2958

PostForum: General   Posted: Tue Jun 09, 2015 4:01 am   Subject: remove strange character
DataStage® Release: 11x
Job Type: Server
OS: Windows
hello
in my job , i call a web service that return me in some field this : �
but i'm not able to remove this strange caracter
Someone know how to do this ?
thank you
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours