Search found 15603 matches

by ArndW
Fri Aug 28, 2009 3:59 am
Forum: General
Topic: iNTRINSIC cONVERSION
Replies: 2
Views: 743

a) Please don't use just uppercase - it is considered shouting
b) Using "ASAP" usually means that you get a slower answer since this is a forum staffed by volunteers.
c) Please post the exact error message
by ArndW
Fri Aug 28, 2009 3:04 am
Forum: General
Topic: Information Server Manager: error while creating a package
Replies: 4
Views: 1302

That is too bad, it sounds like you have the dubious honour of getting to open up a support call. At least you have a reproduceable test case for them.
by ArndW
Fri Aug 28, 2009 3:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compress Stage making Timestamp field invalid.
Replies: 2
Views: 861

In order for a timestamp to be compressed, it needs to be converted to a string. Likewise, the string value is decompressed and then put into a timestamp format. I would wager that the problem here is the default string formatting of the timestamp field; since the "*"s you see usually come...
by ArndW
Fri Aug 28, 2009 2:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Abort
Replies: 2
Views: 1555

Have you specified "reset if required" in the sequence where you are calling up this job? If not, please do so - if you don't have that set and try to run a job which is in an "aborted" state you would get an error message like this.
by ArndW
Fri Aug 28, 2009 2:44 am
Forum: General
Topic: Information Server Manager: error while creating a package
Replies: 4
Views: 1302

Is this the only repository error that you have seen? It would seem to indicate xmeta repository inconsistancies and/or errors. I've seen RID errors that are temporary and go away at a second attempt. Could it be that it is trying to insert a new category tree where one exists already - is this a fr...
by ArndW
Thu Aug 27, 2009 9:14 am
Forum: General
Topic: Need help setting up UVSH
Replies: 10
Views: 2548

the "Item-ID" column output is not affected by the terminal width setting. The items are listed correctly, though. The item ID you displayed is the complete record ID that is locked.
by ArndW
Thu Aug 27, 2009 5:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: julian_day_from_date(date) issue error mesage
Replies: 11
Views: 3413

I vaguely recall that a modify can't use two functions, but am not in a position to test tht right now. I guess I always cheat and use a transform stage instead.
by ArndW
Thu Aug 27, 2009 5:54 am
Forum: General
Topic: Need help setting up UVSH
Replies: 10
Views: 2548

The SET.TERM.TYPE command isn't a UNIX command, but needs to be executed inside the TCL session, i.e. when you have the ">" prompt.
by ArndW
Thu Aug 27, 2009 3:58 am
Forum: General
Topic: User defined component and stage
Replies: 2
Views: 1106

User defined stages are a way of extending DataStage functionality; if you need something specific done which cannot be handled otherwise you can write your own stage. It is much more complex and involved than just using an external routine or BuildOp. We use one here which performs a two-phase-comm...
by ArndW
Thu Aug 27, 2009 3:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: advantages of trimleading
Replies: 3
Views: 1034

TrimLeading only trims leading characters, Trim() by default trims leading and trailing. Both are different functions and one can't be "better" than the other. It depends upon what you are trying to achieve.
by ArndW
Thu Aug 27, 2009 3:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: datastage job error
Replies: 19
Views: 5574

You might be lucky and be able to clear the log file from the director to get rid of this error. Or edit the job, save as another name, delete the original and rename the copy. This will get rid of the log file error.
by ArndW
Thu Aug 27, 2009 3:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How does DataStage store Annotations?
Replies: 17
Views: 5496

This hashed file is internal to DataStage and is not documented anywhere.
by ArndW
Thu Aug 27, 2009 3:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: advantages of trimleading
Replies: 3
Views: 1034

Since both functions do different things you cannot compare them that way.
by ArndW
Wed Aug 26, 2009 10:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue while logging into DS Client
Replies: 10
Views: 1806

An uninstall should also involve removing the Windows registry settings.
by ArndW
Wed Aug 26, 2009 10:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: installing different datastage server in a single unix box
Replies: 2
Views: 1188

Yes, you can have multiple instances of the same DataStage server running concurrently. They are installed using different ports and I think that this capability has gone away with version 8.x - i.e. one cannot run two or more 8.x servers on the same machine.