Search found 53125 matches

by ray.wurlod
Sun Oct 18, 2009 9:32 pm
Forum: General
Topic: Oracle to Teradata migration
Replies: 10
Views: 5485

Gosh, that's how UniVerse table storage (and Unidata table storage) is handled too! Both of these, however, were invented in the 1980s. They were also Y2K compliant from day one.
by ray.wurlod
Sun Oct 18, 2009 1:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is it possible to create DB2 temporary tables in DB2 stage
Replies: 2
Views: 1355

Your diagnosis "with no luck" is not helpful. What actual command did you issue, did you also issue GRANT commands, and what error message (if any) was returned from the Open command?
by ray.wurlod
Sat Oct 17, 2009 3:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: need a steps to instalation
Replies: 8
Views: 2456

I'm surprised you can still get version 5.1. It's been withdrawn by the vendor, and you won't get any support for it.
by ray.wurlod
Sat Oct 17, 2009 3:49 pm
Forum: General
Topic: Version Control for dsx
Replies: 8
Views: 4113

Version Control does not include a check-out/check-in capability.

Its replacement (IBM Information Server Manager) will do so in a near future release, according to the road map presentations at last year's IOD conference.
by ray.wurlod
Sat Oct 17, 2009 12:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Excellent Job Opportunity with a leading Healthcare Client!
Replies: 1
Views: 723

Will your client support work visa sponsorship, relocation expenses, etc.? Are there any other obstacles such as citizenship/residency requirements?
by ray.wurlod
Sat Oct 17, 2009 12:28 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Datastage Export from Commandline
Replies: 8
Views: 9591

None of the above seems to be related to the Information Analyzer product. Have I missed something?
by ray.wurlod
Fri Oct 16, 2009 5:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Migrating jobs from 7.5 to 8.1
Replies: 2
Views: 877

No changes should be necessary. The job(s) should have been upgraded automatically as the project was upgraded.
by ray.wurlod
Fri Oct 16, 2009 4:59 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: How to perform Bulk delete oe optimize delete operation
Replies: 4
Views: 1970

No such thing if you have to provide selective keys. The best you can do is to find the optimum balance between array size and transaction size. The first will be a function of your row size; the second should be an integer multiple of the first.
by ray.wurlod
Fri Oct 16, 2009 2:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trim in Modify stage
Replies: 20
Views: 22465

Technically you can trim a Char data type but it is padded before being transferred to the output link. The pad character is defined using the environment variable APT_STRING_PADCHAR. A Char field has a constant size on an output link.
by ray.wurlod
Fri Oct 16, 2009 2:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Informatica to DataStage Conversion
Replies: 7
Views: 10237

Question: do detail design documents exist for the Informatica implementation? In that case option 2 might not be as costly as you believe.
by ray.wurlod
Fri Oct 16, 2009 2:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: irreconcilable constraints
Replies: 6
Views: 10647

Moderator: please move this thread to Enterprise Edition (parallel) forum
by ray.wurlod
Fri Oct 16, 2009 2:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage logs
Replies: 6
Views: 2336

Another possibility is that your Director log view is filtered (probably to the most recent 100 entries, which is the default filter). If the view is filtered, the word "Filtered" appears in the status bar. Press Ctrl-T or right-click in the log background to gain access to the Filter dial...
by ray.wurlod
Fri Oct 16, 2009 1:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error calling subroutine DSR_EDIT (Action = 2)
Replies: 9
Views: 5423

@ID is a column name within UNIVERSE.INCLUDE. You may need to enclose it in double quotes. Or you can use the RetrieVe query language.

Code: Select all

LIST UNIVERSE.INCLUDE WITH @ID = 'ODBC.H'
by ray.wurlod
Fri Oct 16, 2009 1:29 am
Forum: General
Topic: Difference between DSX and DSX 7-bit encoded
Replies: 3
Views: 2011

It's even simpler than that. Any character over DEL (127) is represented as \nnn where nnn is the ASCII code point for the character.
by ray.wurlod
Fri Oct 16, 2009 1:28 am
Forum: General
Topic: Can i import 7.5.X version DSX into 8.x version of DataStage
Replies: 5
Views: 2350

kumarkb wrote:Are there any issues which might occur if i try to run 7.5.x jobs in 8.x ?
No.

Provided, of course, that all pathnames, database connections, etc., have been re-created.