| Author |
Message |
|
Topic: Transformer compilation error in AIX |
UCDI
Replies: 4
Views: 124
|
 Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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 ...
|
|
Topic: MQueue connector keep or delete |
UCDI
Replies: 5
Views: 245
|
Forum: 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 ...
|
|
Topic: MQueue connector keep or delete |
UCDI
Replies: 5
Views: 245
|
Forum: 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 ...
|
|
Topic: MQueue connector keep or delete |
UCDI
Replies: 5
Views: 245
|
Forum: 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 ...
|
|
Topic: MQueue connector keep or delete |
UCDI
Replies: 5
Views: 245
|
Forum: 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
|
Forum: 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?
|
|
Topic: How to retain ONE record after comparing 2 different columns |
UCDI
Replies: 5
Views: 560
|
Forum: 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 ...
|
|
Topic: [File Connector] Not delimited Files |
UCDI
Replies: 13
Views: 975
|
Forum: 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
|
Forum: 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 ...
|
|
Topic: How to retain ONE record after comparing 2 different columns |
UCDI
Replies: 5
Views: 560
|
Forum: 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 ...
|
| |
