Search found 53125 matches

by ray.wurlod
Fri Apr 01, 2005 6:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Handling Multi-lingual data
Replies: 10
Views: 4351

Another excellent reference is the DataStage NLS manual. However, this does not fully explain in detail the idiosyncratic encoding of Unicode used within DataStage with NLS enabled. Then again, I guess "they" reckon you don't really need to know.
by ray.wurlod
Thu Mar 31, 2005 4:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Is there any DB2 SQL Builtin Conversion from EBCDIC - ASCII
Replies: 3
Views: 1754

Surely you can find this in DB2 manuals/help? Or ask your DBA? I suspect there is no such function in DB2's SQL but I don't know for sure. One thing you can do is to extract in EBCDIC and convert to ASCII within DataStage. However, you also baffle me with a claim that the column is "in binary"; how ...
by ray.wurlod
Thu Mar 31, 2005 4:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Assigning Server Jobs to run on another node
Replies: 2
Views: 893

Only if that other node also has a DataStage server installed. The whole point about server jobs (and why they are so named) is that they must run on the DataStage server.
by ray.wurlod
Thu Mar 31, 2005 4:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Handling multipls files.
Replies: 15
Views: 4834

If you have version 7.5 you can use a StartLoop activity based on a list of file names.
by ray.wurlod
Thu Mar 31, 2005 4:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Any suggestions on this
Replies: 6
Views: 1610

You've initialized a variable called Mange but used a variable called Menge in your code, without using Mange anywhere. Do you think this might be affecting what you're trying to do, or even your thought processes? You did not mention the names of the routine's arguments. Can you describe in words t...
by ray.wurlod
Thu Mar 31, 2005 4:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: usage of slowly changing dimensions in datastage
Replies: 4
Views: 2471

The good news is that all types can be accommodated. However, please do search the forum; it has been covered previously. A really friendly gesture would be to reply to this thread with links (use the URL button) to the answers you find. For example here is one post on SCD technique in DataStage.
by ray.wurlod
Thu Mar 31, 2005 4:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dslictool file.
Replies: 5
Views: 1866

Earlier than version 6 it is called uvlictool . Version 6 of DataStage was the first after IBM purchased UniVerse so that the code paths for UniVerse and DataStage began to diverge. Version 5.2 of DataStage used UniVerse version 9.6 as its repository database and as its engine. If dslictool is missi...
by ray.wurlod
Thu Mar 31, 2005 4:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: what does bin/uv mean
Replies: 10
Views: 1676

On UNIX systems it is necessary to be able to find certain libraries to run the bin/uv (or bin/dssh) command successfully. In the $DSHOME directory there is a shell script called dsenv which, among other things, adjusts the library search path environment variable (LIBPATH, SHLIB_PATH or LD_LIBRARY_...
by ray.wurlod
Thu Mar 31, 2005 4:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SeqCALLCENTERCAGLIARICcm has finished, status = 96 (Crashed)
Replies: 11
Views: 3988

The error is accurately diagnosed by DataStage in the "from previous run" message. Unable to load DSLogWarning routine. It is looking for a routine called DSLogWarning, which exists somewhere in your code. My guess is that this is in (a Routine called from) the job DSD.RUN LogH3GITmisSTGtoDDSTADMAAC...
by ray.wurlod
Thu Mar 31, 2005 4:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: what does bin/uv mean
Replies: 4
Views: 2768

You may find that the uv command disappears from the product in a future release. Prefer dssh to enter the DataStage Engine environment.
by ray.wurlod
Thu Mar 31, 2005 4:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Stored Procedure Stage - how does it work?
Replies: 4
Views: 1568

It's a plug-in that you plugged in when you selected the plug-in stages when installing the server. :wink:

Almost all server job stage types are plug-ins; only the eight (?) that came with version 1.0 aren't.
by ray.wurlod
Thu Mar 31, 2005 4:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Help!! I've lost my poroject
Replies: 8
Views: 2854

If you still can't see the projects after installing the server with a different serial number, it may still be possible to recover. In essence you need to update the "system tables" (particularly UV.ACCOUNT and the SQL Catalog) with references to the extant projects. Post again if this turns out to...
by ray.wurlod
Thu Mar 31, 2005 4:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error from Folder Stage
Replies: 4
Views: 1481

That suggests that someone had deleted the hidden file .nlsmap from the original directory, or had altered it to contain incorrect character map information.
by ray.wurlod
Thu Mar 31, 2005 4:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Difference stage issues lots of warnings.
Replies: 13
Views: 7247

Enterprise Edition (EE) is a superset of Server Edition. With Server Edition you can create server jobs and job sequences. With Enterprise Edition you can create server jobs, parallel jobs and job sequences. Enterprise Edition MVS is a superset of Enterprise Edition. With Enterprise Edition MVS you ...
by ray.wurlod
Thu Mar 31, 2005 2:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: 2 sequence daily job call a monthly job?
Replies: 7
Views: 2931

I'd have to agree with David. These activities aren't too heavy on memory consumption so, unless you have a really minimally configured client, I'd try uninstalling and re-installing DataStage client. All your work is saved on the server, so you won't lose any of that, though you may lose some custo...