Search found 53125 matches

by ray.wurlod
Thu Feb 17, 2011 3:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to read and write BLOB datatype in datastage 8.1
Replies: 4
Views: 10658

Another, rather old-fashioned, approach is to treat them as very long (perhaps even unbounded) VARCHAR and apply hex conversion (for example RAWTOHEX in Oracle, HEX in MySQL) while extracting, and use the reverse functions when loading.
by ray.wurlod
Thu Feb 17, 2011 3:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Load same teradata table 2 times in a single job
Replies: 21
Views: 7526

My point is that many of them (such as my east Asian customers) can not easily understand these forms.
by ray.wurlod
Thu Feb 17, 2011 3:42 pm
Forum: General
Topic: dsjob fails when executed via shell script
Replies: 2
Views: 2275

Add an echo command so you can learn what the script is actually trying to execute.

Code: Select all

echo ${ov_PATHAPP}/dsjob -server ${ov_hostname} -user ${DSTAGE_USER} -password ${DSTAGE_PASSWORD} -run ${ov_PROYECTO} ${ov_JOBCONTROL} 
by ray.wurlod
Thu Feb 17, 2011 4:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hashed-file issue with read/write access
Replies: 4
Views: 2088

A common group is probably a better solution, and making sure that the umask for all users is set to 002.
by ray.wurlod
Thu Feb 17, 2011 4:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Orchadmin command
Replies: 7
Views: 4365

It's in the PXEngine's bin directory.
by ray.wurlod
Thu Feb 17, 2011 4:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Importing parametrs from one project to another
Replies: 4
Views: 1989

ppgoml wrote:There is a file named "DSParam" that includes parameters information.
No there isn't.

But there is one called DSParams.
by ray.wurlod
Thu Feb 17, 2011 4:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Load same teradata table 2 times in a single job
Replies: 21
Views: 7526

Not "u", but "you". Not "abt", but "about".

U was a city in ancient Babylonia. Abt was an engineer who invented a particular style of cogged railway for steep ascents and descents.
by ray.wurlod
Thu Feb 17, 2011 4:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Throttling performance on a grid?
Replies: 12
Views: 4908

Do ALL variants of grid management software work that way? In particular, does Sun Grid Manager behave thus?
by ray.wurlod
Wed Feb 16, 2011 7:51 pm
Forum: General
Topic: Code Quality Tool for DataStage
Replies: 6
Views: 6268

If you happen to be in the UK you will be able to find any number of peers in the House of Lords.
:lol:
by ray.wurlod
Wed Feb 16, 2011 7:50 pm
Forum: General
Topic: Renaming a project during migration
Replies: 7
Views: 4020

Do you need to migrate them at all? Would it be sufficient to have jobs running in the new environment create them afresh? (That's one of the things Validate Job is useful to do.)
by ray.wurlod
Wed Feb 16, 2011 7:48 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Call a job sequence from ISD
Replies: 8
Views: 5696

I'd be very surprised if a sequence could be ISD enabled. Any job that can be ISD enabled needs to able to listen (e.g. ISD Input stage) and send. There's nothing in a sequence that fulfils this requirement.
by ray.wurlod
Wed Feb 16, 2011 7:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Importing JObs from 8.5 back into 8.1
Replies: 3
Views: 4218

Internal formats were the same in 7.5, 8.0 and 8.1 (for example the major version number for jobs was 50 if I recall correctly). The internal format is different in 8.5 (for example looping in Transformer) and the major version number for jobs is 56. They are incompatible. You could try editing the ...
by ray.wurlod
Wed Feb 16, 2011 6:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need suggestions on Shell Script Learning
Replies: 4
Views: 2093

There are some good online tutorials, which you can find using an Internet search engine.

The ones from .edu web sites seem to be more thorough.
by ray.wurlod
Wed Feb 16, 2011 6:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DAT file
Replies: 14
Views: 7417

DIS file and DAT file. Say it, rather than read it.

Neither is a particularly meaningful suffix.
by ray.wurlod
Wed Feb 16, 2011 4:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: PIVOT stage question
Replies: 2
Views: 1099

I don't believe the Pivot stage supports multiple outputs but, if it did, you have an easy answer.

Otherwise use a Copy stage to distribute the required columns to three independent Pivot stages.