Search found 53125 matches

by ray.wurlod
Thu Aug 17, 2006 8:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Switchboard type Sequencer
Replies: 3
Views: 861

You might like to put Nested Condition activities immediately after the Sequencer to make the decision about whether to run each particular downstream job, perhaps based on an activity variable from one or more of the upstream activities.
by ray.wurlod
Thu Aug 17, 2006 8:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: "Check DS is set up correctly error"
Replies: 7
Views: 2746

This message can indicate that indexing in the DataStage Repository has become out of synch. When you can get exclusive access to the project, execute the DS.REINDEX ALL command (through the Administrator client Command window perhaps) and service is likely to resume.
by ray.wurlod
Thu Aug 17, 2006 7:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Append date with file
Replies: 30
Views: 4442

Before-after subroutines can not be tested in the routines editor.

In UNIX ren is meaningless, except as something to do with stimpy (these were a pair of hostnames at one of my client sites).
by ray.wurlod
Thu Aug 17, 2006 7:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Aggregate - Out of Sequence - Underscore before A-Z
Replies: 7
Views: 2326

Greg's sample data are all upper-case, but this might be a valid point if the sort were case sensitive and he advised the Aggregator otherwise.
by ray.wurlod
Thu Aug 17, 2006 7:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Running DataStage using Shells Script
Replies: 5
Views: 2044

Can you add either -wait or -jobstatus to the dsjob command, to make it synchronous? Check also that all the environment variables referred to have properly been set. If not, your dsjob command will have a syntax error.
by ray.wurlod
Thu Aug 17, 2006 7:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL Server Binary TimeStamp
Replies: 6
Views: 3019

Seems to be related to that other SQL Server idiosyncracy, the GUID (guaranteed unique ID). Can you ask your DBA whether it's the same? (I'm just curious, having solved GUID issues with DataStage in the past. You can search the forum for those solutions.)
by ray.wurlod
Thu Aug 17, 2006 7:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL Server Binary TimeStamp
Replies: 6
Views: 3019

Seems to be related to that other SQL Server idiosyncracy, the GUID (guaranteed unique ID). Can you ask your DBA whether it's the same? (I'm just curious, having solved GUID issues with DataStage in the past. You can search the forum for those solutions.)
by ray.wurlod
Thu Aug 17, 2006 7:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: unix question
Replies: 7
Views: 1755

The answer is in two parts - the operating system permissions and the DataStage roles. Other posters have addressed the first; you check the Permissions tab in the Administrator client to view the second.
by ray.wurlod
Thu Aug 17, 2006 7:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File Lookup
Replies: 10
Views: 2948

Part of which is "less than US$1 per week". :idea:

(There are also corporate premum memberships available that discount this even further!)

Buy now! Send money, for free receipt! :lol:
by ray.wurlod
Wed Aug 16, 2006 6:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Recursive lookups in Hash files
Replies: 4
Views: 1200

This is NOT a recursive lookup. You do a lookup, the lookup does not succeed, so you write a new record into the hashed file. The next lookup attempt does not occur until you are processing the next row. It is not recursive. In the job design, the link that performs the lookup should have read cache...
by ray.wurlod
Wed Aug 16, 2006 6:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine To Create a HASHFILE
Replies: 8
Views: 2689

Hi, I need to call a Routine in the Before-Job Subroutine to create the hashfile,if it does not exists in the specified path.If exists then dont need to do any thing. Planning to pass hashfilename as a parameters to the routine. Only one column need to be in the hashfile with data type Char(100). n...
by ray.wurlod
Wed Aug 16, 2006 6:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ftp or copy
Replies: 14
Views: 3810

You can't believe me, believe me! 8)
by ray.wurlod
Wed Aug 16, 2006 6:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using DSSetParam and DSGetParamInfo in a job control
Replies: 4
Views: 2792

No you are not doing anything wrong, this is one of those strange behaviours of DataStage. If you run the job, and retrieve the parameter values afterwards with DSJ.PARAMVALUE, you will get back what you set. But, until the job has run, you do not. It is sufficient, in your case, to test the value r...
by ray.wurlod
Wed Aug 16, 2006 6:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Portability of Datastage Code?
Replies: 6
Views: 1984

No, he means parallel Transformer. The binary ("object") code produced by your C++ compiler is almost certainly not portable to other platforms.
by ray.wurlod
Wed Aug 16, 2006 6:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using BAPI stage (SAP Pack)
Replies: 5
Views: 3425

Of course, with nearly a year gone by, Rachana may no longer be there. :oops: