Search found 53125 matches

by ray.wurlod
Thu Feb 15, 2007 9:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error while scheduling a job in datastage
Replies: 11
Views: 4420

I wonder if this is related to the mucking about you've been doing with Multi-Client Manager? Have you successfully scheduled jobs in the past?
by ray.wurlod
Thu Feb 15, 2007 9:00 pm
Forum: General
Topic: Installing MCM
Replies: 20
Views: 6245

OK, now I've go a doubt. Are you trying to install MCM, as per your subject, or to use MCM? I've been assuming the former.

If the latter, where did you install the DataStage 7.0 client and where did you install the DataStage 7.5 client?
by ray.wurlod
Thu Feb 15, 2007 8:57 pm
Forum: General
Topic: How to calculate the size of the text file
Replies: 19
Views: 11188

Just for interest, do the calculations like I did earlier. Keep one byte per delimiter and use 14 bytes/record as the storage overhead. Post your calculations, so I can be certain you understand.
by ray.wurlod
Thu Feb 15, 2007 6:20 pm
Forum: General
Topic: Installing MCM
Replies: 20
Views: 6245

I normally use the user ID Administrator, which is always the local Administrator user. I don't know the answer to your question.
by ray.wurlod
Thu Feb 15, 2007 6:19 pm
Forum: Site/Forum
Topic: Ray hits 18K !!!
Replies: 19
Views: 8974

Oh, no, over-use of the "!" character. I certainly don't have 18K factorial factorial factorial posts. Not even sure there's that many protons in the universe!
by ray.wurlod
Thu Feb 15, 2007 6:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: using UniVerse and UniData
Replies: 12
Views: 3475

No you didn't. Neither UniData stage can be used to access data in DataStage hashed files. means that neither (of the two UniData stages) can be used to access data in DataStage hashed files. Whilst I did not say so, the UniData stages do access hashed files - but these are UniData hashed files, whi...
by ray.wurlod
Thu Feb 15, 2007 6:01 pm
Forum: General
Topic: How to calculate the size of the text file
Replies: 19
Views: 11188

The calculations are different for hashed files, as there are internal pointers that also must be taken into account. The Hashed File Calculator (on your DataStage clients CD in the unsupported utilities folder) knows about these. You can use, as an estimate, 14 bytes per row for regular hashed file...
by ray.wurlod
Thu Feb 15, 2007 5:59 pm
Forum: General
Topic: Installing MCM
Replies: 20
Views: 6245

That's correct - you must give a user ID that is a local Administrator for that machine - you can not install as a domain Administrator (unless that user is also a local Administrator).
by ray.wurlod
Thu Feb 15, 2007 5:42 pm
Forum: General
Topic: How to calculate the size of the text file
Replies: 19
Views: 11188

There's probably an end-of-file byte (Ctrl-Z on Windows, Ctrl-D on UNIX) as well, but I didn't think a difference of one byte would be of concern.
by ray.wurlod
Thu Feb 15, 2007 5:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading multiple input files into a funnel stage using sym
Replies: 3
Views: 893

Don't use a funnel stage. Use a single Sequential File stage, with the File Mode property set to "File Pattern" and specify a regular expression for extracting the files in question. They must, of course, all have the same record structure - but that would also be true to use a Funnel stage. If ther...
by ray.wurlod
Thu Feb 15, 2007 5:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with Parallel custom Stage(Build)
Replies: 8
Views: 3735

"Duplicate symbol" warnings typically result from over-enthusiastic inclusion of header files. The APT_operator superclass ought to be automatically available in a BuildOp.
by ray.wurlod
Thu Feb 15, 2007 5:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File pattern warning in Sequential file
Replies: 9
Views: 1654

Wait For File stage does not work with a file pattern.
by ray.wurlod
Thu Feb 15, 2007 5:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQL*Loader-500: Unable to open file
Replies: 10
Views: 11659

Where is your project folder? This is determined when the project is created, and can be recovered using the Administrator client - when the project is selected the project folder's pathname is displayed in the status bar. Give it a second or two to refresh.
by ray.wurlod
Thu Feb 15, 2007 5:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: using UniVerse and UniData
Replies: 12
Views: 3475

Yes there is, but we'd better not go there. The UniVerse stage can access data in DataStage hashed files, but only if a pointer to the hashed file exists in VOC. Search the forum for the SETFILE command for more information. In the UniVerse stage specify the pre-allocated DSN localuv. Neither UniDat...
by ray.wurlod
Thu Feb 15, 2007 5:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: REGARDING ODBC STAGE
Replies: 4
Views: 1167

Ask your friend HOW it's possible, since your friend appears to have - or at least to claim - some expertise. Posting the answer back here will help anyone who encounters this question in future.