DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 356 matches
Author Message
 Topic: Transformer compilation error in AIX
UCDI

Replies: 4
Views: 124

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 15, 2019 10:00 pm   Subject: Transformer compilation error in AIX
"/usr/include/string.h". this concerns me. string.h is part of the C language and should not need a path to include it; has someone tried to override the standard one?

try this sample program. ...
 Topic: Run time column propogation
UCDI

Replies: 6
Views: 477

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Apr 11, 2019 9:36 pm   Subject: Run time column propogation
how complex are these rules, and can you change your extract?
seems like a coalesce or similar statement for each rule would work if the rules are binary (eg column rule 1 = if any of these are null ...
 Topic: delete all data sets in a folder using orchadmin in Windows
UCDI

Replies: 2
Views: 136

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Apr 11, 2019 9:27 pm   Subject: delete all data sets in a folder using orchadmin in Windows
this works on ours as a routine -- *.* style wildcards work just fine...
I don't know how much it needs to change for windows. Could be an OS problem though.. maybe unix allows *.ds and windows did ...
 Topic: VB scripts for windows file activities
UCDI

Replies: 8
Views: 1147

PostForum: General   Posted: Wed Apr 10, 2019 2:30 am   Subject: VB scripts for windows file activities
it should not be from scratch.
what you have should work with only minor adaptation, and once it works, adding the write to log messages isnt too bad (but if you need help, ask).

this link is ...
 Topic: VB scripts for windows file activities
UCDI

Replies: 8
Views: 1147

PostForum: General   Posted: Tue Apr 09, 2019 9:48 pm   Subject: VB scripts for windows file activities
whatever is printed to the console is brought back by execute command BUT I don't know if that is only done at the end of execution or if it picks it up midstream.

Is there any reason you can't pu ...
 Topic: Column Analysis Sample - recommendations, best practices
UCDI

Replies: 2
Views: 98

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Tue Apr 09, 2019 9:35 pm   Subject: Column Analysis Sample - recommendations, best practices
We had this problem as well, and while we half-solved it by putting the CA workload on its own server, I ended up making a C++ routine that did pretty much the same thing and was able to do the analys ...
Workaround Reported
 Topic: MQueue connector keep or delete
UCDI

Replies: 5
Views: 245

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Mar 28, 2019 2:55 am   Subject: MQueue connector keep or delete
Not yet. I wanted to make sure its not just me not knowing where to click.
sigh. Their support ... leaves a lot to be desired. Just getting them to admit there is a problem to bother with fixin ...
Workaround Reported
 Topic: MQueue connector keep or delete
UCDI

Replies: 5
Views: 245

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Mar 27, 2019 7:59 am   Subject: MQueue connector keep or delete
I gave up and made 2 connectors for now, with some smoke and mirrors on the deletion side to determine if it is enabled or not. But I would still love to understand if this is a bug or something I d ...
Workaround Reported
 Topic: MQueue connector keep or delete
UCDI

Replies: 5
Views: 245

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Mar 27, 2019 1:12 am   Subject: MQueue connector keep or delete
I think I did that. Inside the MQ connector, there is a button-column with 3 red arrows on the button. I used that and picked 'create new' which build a pre-generated list-parameter and added it to ...
Workaround Reported
 Topic: MQueue connector keep or delete
UCDI

Replies: 5
Views: 245

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Mar 26, 2019 7:03 am   Subject: MQueue connector keep or delete
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I have a MQ job that I want to control whether it keeps or deletes the messages on the queue via a parameter. I have clicked in the parameter and selected create new, and it happily populated the fi ...
 Topic: Evaluate Arithmatic Expression coming in input string
UCDI

Replies: 13
Views: 925

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Feb 13, 2019 4:38 am   Subject: Evaluate Arithmatic Expression coming in input string
are they all of the same format, like A operator B operator C?
Resolved
 Topic: How to retain ONE record after comparing 2 different columns
UCDI

Replies: 5
Views: 560

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Feb 06, 2019 8:15 am   Subject: How to retain ONE record after comparing 2 different columns
you can do something snarky like make the key A*B (200*300 is the same as 300*200) or sort the 2 keys (stage variables can do this for 2 values really simple) and put them in the same order every tim ...
Workaround Reported
 Topic: [File Connector] Not delimited Files
UCDI

Replies: 13
Views: 975

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Feb 06, 2019 8:08 am   Subject: [File Connector] Not delimited Files
for fixed positions, left and right should do it. you can string these together eg
f1 = left(in, 12)
f2 = left(right(in,12),12)
etc
 Topic: How to abort job when a string value is in a decimal field?
UCDI

Replies: 1
Views: 497

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jan 31, 2019 3:56 am   Subject: How to abort job when a string value is in a decimal field?
Feed it to a transformer.

In the transformer, have two output links. On one of the links, have a constraint send the data down if the column value is NULL. Also set the the link properties to abo ...
Resolved
 Topic: How to retain ONE record after comparing 2 different columns
UCDI

Replies: 5
Views: 560

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jan 31, 2019 3:52 am   Subject: How to retain ONE record after comparing 2 different columns
is the data really big? If not, can you copy the input and then do a join stage? I think that might work, what you wold do is something like

read file
copy stage
modify left, add party1 as new f ...
 

 Jump to:   



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