Search found 42189 matches

by chulett
Thu Aug 25, 2011 7:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Writing in multiple files according to column value
Replies: 6
Views: 4103

As noted, a Server job will make this quite simple. Another possibility, write to a single output file and then use csplit to create the separate files if your member codes are actually in the output and not just used to determine the output filename.
by chulett
Thu Aug 25, 2011 7:27 am
Forum: General
Topic: log
Replies: 6
Views: 1699

I thought you already "retrieved this information"? dsjob -linkinfo
by chulett
Thu Aug 25, 2011 7:21 am
Forum: General
Topic: from citrix to local
Replies: 2
Views: 885

You get your hands on the media and install it locally.
by chulett
Wed Aug 24, 2011 6:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to use XSD and WSDL in webservices transformer stage
Replies: 13
Views: 11051

Begin by starting your own new post and giving us your particulars - version, O/S and the exact error you are getting. Jumping on the end of a post from 2008 isn't the way to get your issue resolved.
by chulett
Wed Aug 24, 2011 6:04 pm
Forum: General
Topic: log
Replies: 6
Views: 1699

Link counts for the most recent run are stashed in the RT_STATUSnnn hashed file, from what I recall.
by chulett
Wed Aug 24, 2011 3:02 pm
Forum: General
Topic: Shell Script Needed
Replies: 1
Views: 797

You shouldn't need a script, a single cat command should do what you need: cat ErrorFile* > ConsolidatedErrorFile The names are illustrative only. Use a wildcard pattern that will match all of the source files and a consolidated name that does not match the wildcard pattern... or put it elsewhere.
by chulett
Wed Aug 24, 2011 12:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DATASTAGE Upgrade from Server 7.5.2 to Parallel 8.1
Replies: 5
Views: 3337

I don't see a problem with what you posted. Is there any significant difference between what you are using and what the stage generates? Taking the NEXTVAL usage out of the picture, of course.
by chulett
Wed Aug 24, 2011 10:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DATASTAGE Upgrade from Server 7.5.2 to Parallel 8.1
Replies: 5
Views: 3337

So, DS 8.1 Enterprise Edition. These are still Server jobs I assume. Do you have eight columns defined in the target OCI stage? Does your executing user have the proper grants to the Sequence object? I imagine so since it used to work but seems like it should be asked.
by chulett
Wed Aug 24, 2011 10:15 am
Forum:
Topic: Multiple XMETA databases for a single DS instance
Replies: 5
Views: 2328

Appreciate that, this is one of the product specific forums with that specific product being MetaData Workbench.
by chulett
Wed Aug 24, 2011 9:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion error from varchar to Timestamp
Replies: 3
Views: 6906

So you don't have a timestamp but rather it's a date. You are telling it you have time information in your string when in fact you do not. Either add a zero time or use StringtoDate instead.
by chulett
Wed Aug 24, 2011 9:05 am
Forum: General
Topic: Scheduling using Datastage Director
Replies: 7
Views: 3477

Then what you've got should be fine. I was thinking a loop but it doesn't sound like it would buy you all that much. And we have sensitive data on our servers but that doesn't preclude the use of scripts, it just means that any we use have be 'hardened' against mischief and pass a security audit. Fo...
by chulett
Wed Aug 24, 2011 8:31 am
Forum: General
Topic: Scheduling using Datastage Director
Replies: 7
Views: 3477

What you've got is pretty simple. Clarify something for us - when exactly do you need to send this email notification and what is its purpose? Is it just one after all jobs have been run, or one after every job completes? Or is it just for error notification? Do you want something more... "flex...
by chulett
Wed Aug 24, 2011 6:10 am
Forum:
Topic: Multiple XMETA databases for a single DS instance
Replies: 5
Views: 2328

Could you please start posting these questions in the correct forum? This isn't it... they belong in the General forum. :?
by chulett
Wed Aug 24, 2011 6:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with Milliseconds
Replies: 7
Views: 5544

FYI - It only exists on UNIX servers. As an alternative, add it as a custom environment variable via the Administrator.
by chulett
Wed Aug 24, 2011 5:59 am
Forum: General
Topic: find category name
Replies: 9
Views: 2965

I guess those are actually in DS_JOBOBJECTS. I was referring to the bits Ray excluded with the "not like" syntax he added. Category records? Embedded henderson joints? Temporal fragments? :?