Search found 53125 matches

by ray.wurlod
Mon Aug 06, 2007 2:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting the Director list of executed jobs
Replies: 10
Views: 2184

Read your original post, which explicitly mentions the Director screen. Yes, this can readily be done in a job, but that job would include custom code. It can not be done with a server job alone, because there is no single source of data; every job has a separate set of hashed files containing its r...
by ray.wurlod
Mon Aug 06, 2007 2:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to subtrace date column values?
Replies: 1
Views: 602

DaysFromDateSince() function.
by ray.wurlod
Mon Aug 06, 2007 2:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Converting months in to date
Replies: 12
Views: 3094

Almost certainly you will need to create a function. You can find the logic here but this is a server (BASIC) function. You will need to "translate" it into C++ code.
by ray.wurlod
Mon Aug 06, 2007 2:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Metadata repository for IS v8 (mandatory or non-mandatory??)
Replies: 5
Views: 1081

Bundled, but licensed only to be used as IIS Repository.
by ray.wurlod
Mon Aug 06, 2007 2:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem with column import stage
Replies: 8
Views: 2223

Is the 174th byte 0x00?
This might be interpreted as a C-language string terminator.
by ray.wurlod
Mon Aug 06, 2007 2:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to get substring from string
Replies: 5
Views: 2009

Despite bkumar103's confident assertion there IS a direct operation available in parallel jobs. In the Transformer stage use the square bracket notation mentioned by earlier posters. In the Modify stage use the substring() function, noting that character position is a zero-based number - that is, th...
by ray.wurlod
Mon Aug 06, 2007 2:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid assignment of quote character on sequential file
Replies: 9
Views: 3757

Quite. Specify the Quote Character property (on the Format tab) as double.
by ray.wurlod
Mon Aug 06, 2007 2:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using DSGetJobInfo
Replies: 15
Views: 16091

ReturnInfo in your code should be a character string, the name of the link whose row count you want to return. It is not a DSLINKINFO structure (the function's return value may well be the value of a property of such a structure).
by ray.wurlod
Mon Aug 06, 2007 2:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting the Director list of executed jobs
Replies: 10
Views: 2184

You have filters available in the Director.
You can also disable the display of Category (in the View menu) then sort by Status - this will bring all the Aborted jobs to the top, and group all the Finished jobs together.
by ray.wurlod
Mon Aug 06, 2007 2:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to get value of an Env variable in a stage of a job
Replies: 4
Views: 1139

Procedural Note We don't do "urgent" here. If you want urgent support, sign up with your support provider for premium support, and learn the true cost of urgent. This is an all-volunteer site; people post as and when they can, and are not paid for doing so. Personal Note Anyone marking a post as ur...
by ray.wurlod
Mon Aug 06, 2007 2:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Review request-WP 'Finite Separation Band of Static H File'
Replies: 9
Views: 2811

Particularly on a weekend. You can send it to me, but I am REALLY BUSY at the moment, so it would have to be on the basis of "when I can get around to it". If that's not acceptable, please send it to someone else.
by ray.wurlod
Mon Aug 06, 2007 2:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: delete a record from hashed file
Replies: 2
Views: 757

No consequences; the record(s) specified in the WHERE clause get deleted. Beware, though, that this is an auto-committed transaction; no rollback is available.
by ray.wurlod
Mon Aug 06, 2007 2:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: value larger than specified precision allows for this column
Replies: 7
Views: 1561

Allow display positions for the sign and the decimal place holder. For Decimal(9,3) use 14, for Decimal(10,3) use 15.
by ray.wurlod
Mon Aug 06, 2007 2:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: String varchar yyyymmdd to Oracle date error
Replies: 4
Views: 1302

You don't seem to have any quote characters in the row, where the data type is obviously string. This may be an artifact of how the error is reported. You might also try [4,2,2] rather than [4,Z,Z] in the Oconv() function.
by ray.wurlod
Mon Aug 06, 2007 1:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Change capture issue
Replies: 4
Views: 1354

Are you using the default codes for the change type? Or are you setting your own specific codes? Have you inspected the result, to see whether what is being reported is being reported correctly?