Search found 53125 matches

by ray.wurlod
Fri Nov 20, 2009 6:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: User profiles for each projects
Replies: 2
Views: 1103

In version 7 on UNIX there is only one administrator - you don't get a group and you don't get a table. (It's different on Windows, and it will be different when you get to version 8.) Groups really only protect developers' differential access to projects - they do not control who can run jobs. As C...
by ray.wurlod
Fri Nov 20, 2009 6:04 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: Datastage TX Tutorial Files
Replies: 30
Views: 46652

I would recommend that you learn when SMS-style abbreviations are appropriate and when they are not. Here, they are not. A little more care with the space bar would be a good skill for you to develop also. At DSXchange we strive for a professional standard of written English. This is partly because...
by ray.wurlod
Thu Nov 19, 2009 11:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Record on file DS_STAGETYPES can not be written
Replies: 20
Views: 8842

Permissions on DS_STAGETYPES or the files (DATA.30, OVER.30) within that directory?
by ray.wurlod
Thu Nov 19, 2009 11:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Record on file DS_STAGETYPES can not be written
Replies: 20
Views: 8842

Operating system permissions almost certainly.
by ray.wurlod
Thu Nov 19, 2009 10:15 pm
Forum: General
Topic: Texas Footwear
Replies: 0
Views: 957

Texas Footwear

Encountered this researching something else.

Note the spelling error.
by ray.wurlod
Thu Nov 19, 2009 9:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequntial File failing with grep command in filter.
Replies: 5
Views: 2706

grep twice, the second time conditional on the exit status of the first being zero.
by ray.wurlod
Thu Nov 19, 2009 8:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Range lookup
Replies: 17
Views: 19234

I wonder if it's the decimal data type. I recall that, when range lookup first became available, not all data types were supported. Would it be possible to represent, say, 100 * taxrate as an integer and see whether that works?
by ray.wurlod
Thu Nov 19, 2009 5:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Converting date to Timestamp !!
Replies: 3
Views: 1825

For the date portion Oconv(Iconv(Left(InLink.Fieldname,10),"DMDY"), "D-YMD[4,2,2]") For the time portion Oconv(Iconv(Right(InLink.Fieldname, 5), "MT"),"MTS") Concatenate these with a space between. Oconv(Iconv(Left(InLink.Fieldname,10),"DMDY"), "...
by ray.wurlod
Thu Nov 19, 2009 5:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Duplicate record insert with other value
Replies: 9
Views: 2839

Sort, generate key change column in Sort stage, use this to flag in Transformer stage when you need to "increment" the value.
by ray.wurlod
Thu Nov 19, 2009 5:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fixed length issue
Replies: 12
Views: 2950

You simply don't really have VarChar in a fixed width file - you have Char.
by ray.wurlod
Thu Nov 19, 2009 5:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Build stage
Replies: 12
Views: 3582

There's no point. You can Trim() the value in memory, but it still has to be reinstated into its fixed width.
by ray.wurlod
Thu Nov 19, 2009 5:16 pm
Forum: General
Topic: send an SMS using DS
Replies: 7
Views: 2357

"Carrier" is a company that offers a telephony service. The six names you mentioned are all carriers. "Cost effective" is a subjective assessment. Typically the justification goes something like "we have to send SMS messages, and there's no other convenient way to do so."
by ray.wurlod
Thu Nov 19, 2009 5:13 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: IA - ANALYZERPROJECT didnot get created during install
Replies: 5
Views: 2830

As well as checking that Information Analzyer is licensed, you also need to have created the IADB before installing the software. Refer to the installation manual for Information Server for details.
by ray.wurlod
Thu Nov 19, 2009 7:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Looping in Transformerstage
Replies: 6
Views: 1720

Please use Code tags to make your layout clear. For example: CM PM CL PL OP AMT A A 1 1 + B A 2 1 + 10 D C 4 3 + 5 E A 2 1 - C B 3 2 + 10 F E 3 2 + 5 G F 4 3 + 10 H G 5 4 + 5 That having been done, can you please try to paraphrase your exact requirement; I must profess myself still confused. I suspe...