Search found 15603 matches

by ArndW
Wed Jun 14, 2006 6:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: load two diff text files using single sequential file stage
Replies: 23
Views: 3881

Marking several jobs disables the RUN button. This is because each job can have different parameters (both names, number and values) and different settings. This has never functioned and probably never will be implemented. I think you've gotten quite a few suggestions on the different ways to implem...
by ArndW
Wed Jun 14, 2006 6:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: load two diff text files using single sequential file stage
Replies: 23
Views: 3881

Craig - he marked both jobs in the director and wished to start them together and when you do that the "run" button greys out.
by ArndW
Wed Jun 14, 2006 6:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: decompiler
Replies: 10
Views: 2930

Kim - I shouldn't have said "not too difficult" Piotrek - The engine is stack based (think of inverse-Polish notation or the programming of old HP calculators); there aren't too many compiled OPCodes but there are special ones that have variable number of parameters (i.e. elements to pop off the sta...
by ArndW
Wed Jun 14, 2006 5:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Projects on AIX - some work, some don't
Replies: 6
Views: 1349

The problem is now solved. It seems that the user(s) who couldn't run jobs in the "bad" path didn't have the group "system" in their group list. Once that was added the user(s) could run jobs. There still isn't a difference visible that would account for why they could run jobs on projects in other ...
by ArndW
Wed Jun 14, 2006 5:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: load two diff text files using single sequential file stage
Replies: 23
Views: 3881

Amar - there is nothing stopping you running these at the same time. You wanted to know how to start them at the same time and the answer that you got was "use a sequence". You can start the jobs at the same time from the command line using dsjob or from the director (you can't click on both and run...
by ArndW
Wed Jun 14, 2006 5:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date Addition
Replies: 6
Views: 1713

In order to do anything with dates you will need to convert them from display to internal format; the most common way is to use the ICONV() function with the appropriate Date conversion [see the manual under "conversions" for details]. When you do have that integer date you can perform simple math a...
by ArndW
Wed Jun 14, 2006 5:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: decompiler
Replies: 10
Views: 2930

Yes, you can decompile DS/Basic and UV/Basic code.
There is a product available out there which you can purchase. This will decompile programs and routines. Years ago I wrote a decompiler and it wasn't too difficult {I don't have the specs anymore, so can't help you}.
by ArndW
Wed Jun 14, 2006 5:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: load two diff text files using single sequential file stage
Replies: 23
Views: 3881

Create a sequence with 2 job activity stages; put the correct instance name (any names will do as long as they are different) and the correct parameter file name, compile and run.
by ArndW
Wed Jun 14, 2006 3:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Controller Jobs
Replies: 7
Views: 1188

Re: Controller Jobs

...Is there any possibility to call the conroller job in a sub job... You cannot recursively call jobs, you can call a multi-instance "parent" job from a sub-job with a different invocation ID. But I am not sure if I have understood your question. It seems that you are just adding one more step to ...
by ArndW
Wed Jun 14, 2006 2:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: load two diff text files using single sequential file stage
Replies: 23
Views: 3881

Amar - instances are designed so that they can run at the same time. Can you tell us what problems you are having when you try to run them at the same time?
by ArndW
Wed Jun 14, 2006 1:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to import MySQL tables?
Replies: 1
Views: 669

Using ODBC to MySQL is the best method. What problems are you facing?
by ArndW
Wed Jun 14, 2006 12:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Projects on AIX - some work, some don't
Replies: 6
Views: 1349

Thanks Kim. We did check to make sure that no ACLs were set, the umask is set to 002 as well, and the groups are aligned, we even did chmod 777/chown/chgrp to all files/directories yesterday as well. Access rights are identical between the project in a "good" mount point and the "bad" one. I'll forc...
by ArndW
Wed Jun 14, 2006 12:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: routine for control table/hash file it has read from
Replies: 4
Views: 1671

Before someone is going to write some custom code for you, could you please post your hashed file layout, particularly which column you are interested in. You can write a custom routine which is passed the hashed file name, key value and column number which contains the value you wish returned. This...
by ArndW
Wed Jun 14, 2006 12:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: load two diff text files using single sequential file stage
Replies: 23
Views: 3881

Make your DataStage load job into a multinstance job, start two concurrent instances of this job, each using a different source file passed in as a parameter and you have your solution.
by ArndW
Tue Jun 13, 2006 4:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Projects on AIX - some work, some don't
Replies: 6
Views: 1349

There are no error codes. Even with tracing enabled there are no error codes, the &PH& entry contains the 1-liner "Project not found", but as that use I can look at UV.ACCOUNT and have put in a test program to call up DSR_PROJECT as well and that returns a valid value. If the job has a statu...