Search found 380 matches
- Thu Apr 11, 2019 9:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: delete all data sets in a folder using orchadmin in Windows
- Replies: 2
- Views: 3089
- Wed Apr 10, 2019 2:30 am
- Forum: General
- Topic: VB scripts for windows file activities
- Replies: 8
- Views: 6312
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 a huge help: https://www.ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg.im.iis.ds.serverjob.dev.d...
- Tue Apr 09, 2019 9:48 pm
- Forum: General
- Topic: VB scripts for windows file activities
- Replies: 8
- Views: 6312
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 put the basic into a routine (which CAN write directly to the logs easily) and call that in a routine acti...
- Tue Apr 09, 2019 9:35 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Column Analysis Sample - recommendations, best practices
- Replies: 2
- Views: 14517
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 analysis as fast as the database could be read, piped thru a quality stage job that did the statistics on ...
- Thu Mar 28, 2019 2:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MQueue connector keep or delete
- Replies: 5
- Views: 3544
- Wed Mar 27, 2019 7:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MQueue connector keep or delete
- Replies: 5
- Views: 3544
- Wed Mar 27, 2019 1:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MQueue connector keep or delete
- Replies: 5
- Views: 3544
- Tue Mar 26, 2019 7:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MQueue connector keep or delete
- Replies: 5
- Views: 3544
MQueue connector keep or delete
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 field with the parameter and put the new param in the job params with a default and all seems good... ex...
- Wed Feb 13, 2019 4:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Evaluate Arithmatic Expression coming in input string
- Replies: 13
- Views: 8860
- Wed Feb 06, 2019 8:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to retain ONE record after comparing 2 different columns
- Replies: 5
- Views: 4349
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 time (so that 200,300 is 200,300 no matter how they came into the functions). Multiply has a risk of oth...
- Wed Feb 06, 2019 8:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: [File Connector] Not delimited Files
- Replies: 10
- Views: 7014
- Thu Jan 31, 2019 3:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to abort job when a string value is in a decimal field?
- Replies: 1
- Views: 2718
- Thu Jan 31, 2019 3:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to retain ONE record after comparing 2 different columns
- Replies: 5
- Views: 4349
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 field 'key' modify right, add party2 as new field 'key' join stage, on key if the data is too big for this,...
- Tue Jan 15, 2019 11:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Check if multiple rows returned from Lookup Stage
- Replies: 5
- Views: 4921
- Thu Jan 03, 2019 8:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Write to excel using Unstructured Data stage
- Replies: 1
- Views: 3179
I use it all the time. Its kinda like a dataset: if you have an input, you can't have an output, and if you have an output, you can't have an input. Its either the start or the end of a chain of work, in other words. to use the stage you have to click to get the java or whatever it is external gui f...