Search found 42189 matches

by chulett
Mon Jan 03, 2011 7:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File Pattern -- Reading sequentially
Replies: 13
Views: 6249

You've got things in the right place as it is trying to do what you asked. And I wasn't specific enough in my previous reply - that "dir /b" output is an example of what the stage needs, not the actual command itself to be used there. Sorry. Try simply putting "D:/Employee*.txt" ...
by chulett
Mon Jan 03, 2011 7:04 am
Forum: General
Topic: Not able to run job in command prompt
Replies: 2
Views: 2172

Try passing in full credentials - server, domain, user and password.
by chulett
Mon Jan 03, 2011 7:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: example for sqlsrvrwrite function
Replies: 4
Views: 7315

Welcome. Can you please edit your first post and let us know your Release, Job Type and OS? Thanks.
by chulett
Sun Jan 02, 2011 8:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential file delimiter
Replies: 8
Views: 2668

Yes. You'll need to switch from Delimiter to Delimiter String to use more than a single character.
by chulett
Sun Jan 02, 2011 9:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: String to Date
Replies: 2
Views: 1463

Now on to your question... First tell us if you have these formats in different fields, meaning you know what format will be coming where, or if they are all mixed into a single source field. The former is pretty straight-forward while the latter will require you to identify the proper format to use...
by chulett
Sun Jan 02, 2011 8:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: String to Date
Replies: 2
Views: 1463

:!: Split from this topic. When you have a problem or question, please start a new post rather than jumping on the end of someone else's conversation. That way we know what product and version you have and you have full control over the destiny of the post since you 'own' it. If you really feel that...
by chulett
Sun Jan 02, 2011 8:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to generate sequence number in datastage
Replies: 8
Views: 4735

Always good to help people out, but best to stick to posting in threads that are current... this one is two years old and I'm sure they figured out what they needed to do some time ago.
by chulett
Sat Jan 01, 2011 10:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Get Previous day log information
Replies: 1
Views: 1396

You mean statistics from the previous run (or runs I assume) not the previous day... and you can't. Not through this mechanism, that is, as it is strictly for the 'most recent' run of the job. If you need them, you should be capturing and archiving them on an on-going basis. Since I assume you're no...
by chulett
Fri Dec 31, 2010 10:13 am
Forum: General
Topic: Find location of a job using UNIX script or DS server job
Replies: 6
Views: 1612

8)
by chulett
Fri Dec 31, 2010 8:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML file name in column
Replies: 1
Views: 1211

How are you 'reading' the XML files - how exactly is your job designed? You should be doing something to get the filenames to process and having the XML Input stage do the actual reading using the 'URL/File Path' option which should also mean you already have the filename. Just pass it through using...
by chulett
Fri Dec 31, 2010 7:59 am
Forum: General
Topic: Return code handling
Replies: 3
Views: 1279

This can also be caused by the 'Automatically handle' compilation option in the Sequence. The built-in help explains how to override that "anything other than 0 is a failure" behaviour.
by chulett
Thu Dec 30, 2010 4:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Split one row to multiple rows
Replies: 17
Views: 8356

So... even without one?
by chulett
Thu Dec 30, 2010 4:05 pm
Forum: General
Topic: Find location of a job using UNIX script or DS server job
Replies: 6
Views: 1612

Ah... the word you are looking for is 'Category', that must be what you are trying to dig out of the repository with your query. Sure, you can run those same commands from a script, it will actually be the same way (using TCL / UV) but you could parameterize and script it. Check this post for a disc...
by chulett
Thu Dec 30, 2010 2:44 pm
Forum: General
Topic: Find location of a job using UNIX script or DS server job
Replies: 6
Views: 1612

Clarify for us exactly what you mean by "the path of a job". They all live in their respective projects, are you unsure where those are? What are you planning to use this "path" for - answering that may lead us to providing you with a better / more proper solution.
by chulett
Thu Dec 30, 2010 11:26 am
Forum: General
Topic: dsjob command help
Replies: 14
Views: 5193

This just gets more confusing as we go deeper down the rabbit hole. :?

What makes you think your Sequence job is not passing the parameters properly to any jobs it runs? Are you using the Job Activity stage to run the jobs or some other mechanism?