Search found 53125 matches

by ray.wurlod
Sat Dec 13, 2008 2:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to remove box character insequential file
Replies: 17
Views: 5976

Have you tried specifying DOS-style line terminators?
by ray.wurlod
Sat Dec 13, 2008 2:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Get the Value of Project Environment Varaible in Job Control
Replies: 6
Views: 1414

You could read the DSParams file.
by ray.wurlod
Sat Dec 13, 2008 2:55 pm
Forum: IBM QualityStage
Topic: Reference match job does not some matches
Replies: 2
Views: 1412

Not without a lot more information, including samples of the records that should have generated matches but didn't, the cutoff settings that you used, the weights that these records generated, what blocking fields and matching fields you used, whether weight overrides were in effect, and so on.
by ray.wurlod
Fri Dec 12, 2008 7:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: access to oracle
Replies: 12
Views: 3200

The present tense plural form of the verb "to be" is spelled "are", not "r". DSXchange is not a mobile telephone, and we expect users to employ professional standards of written English, not least because it is a difficult enough language for those whose first language...
by ray.wurlod
Fri Dec 12, 2008 12:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regd An Error Calling a Routine
Replies: 7
Views: 1692

Hint: your routine CalculateDate does not return 0.
by ray.wurlod
Fri Dec 12, 2008 12:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Masking using parallel jobs
Replies: 11
Views: 8369

The RoadMap presentation at IOD 2008 conference mentioned that this is functionality "they" (IBM) are looking at including in a future release. Possibly as early as 8.2, but no promises.
by ray.wurlod
Fri Dec 12, 2008 12:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple Rows to One Row (Vertical Pivoting)
Replies: 3
Views: 1477

Just generalize to two pivot keys from the solutions given. For example use additional stage variables.
by ray.wurlod
Fri Dec 12, 2008 12:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Juluan day Error
Replies: 2
Views: 1093

No, because we have no idea at all of what your job design is attempting to do and because you have operator combination enabled which prevents you and us from determining which actual operator is throwing the error.
by ray.wurlod
Fri Dec 12, 2008 12:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Preferred method to read DB2 tables on Mainframes
Replies: 1
Views: 936

You can use DB2 Connect or Federation Server to access the DB2 tables as if they were local.
by ray.wurlod
Fri Dec 12, 2008 12:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS Startup problem
Replies: 5
Views: 2989

What are the values of UVTEMP in the uvconfig file and of the TMP and/or TEMP environment variables?
by ray.wurlod
Fri Dec 12, 2008 12:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need to read a CSV file from remote server by using FTP stag
Replies: 4
Views: 1622

sagar deshmukh wrote:can you please mail me the sulution to sagarddd@gmail.com please.
We don't do that, except sometimes in exchange for money, and particularly not to non-work email addresses. You might be a spy from the "dark side" for all we know!
by ray.wurlod
Fri Dec 12, 2008 12:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need help
Replies: 3
Views: 1388

And are the data in the file encoded using the same UTF-8 ? (Note that there are many UTF encodings of Unicode, not just one.)
by ray.wurlod
Fri Dec 12, 2008 12:13 pm
Forum: General
Topic: External filter stage
Replies: 3
Views: 1240

You can't. An External Filter stage requires both an input and an output link.

Try thinking about other stage types, perhaps an External Source stage.
by ray.wurlod
Fri Dec 12, 2008 12:12 pm
Forum: General
Topic: Column Length function
Replies: 1
Views: 808

Officially, no. In theory you can access the metadata in the job design, but that would require knowledge if how these are stored, documentation of which is not in the public domain. You would need to derive the Columns collection from the link record in the RT_CONFIGnnn table pertinent to the parti...
by ray.wurlod
Fri Dec 12, 2008 3:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Control Error
Replies: 11
Views: 2633

Len, that's the code generated by DataStage. Try it some time - create a job control routine "the old way". I agree with you, even so. Indeed, what ever happened to "you must treat the handle variable as opaque"?