Search found 15603 matches

by ArndW
Mon Nov 13, 2006 8:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unwanted Folders
Replies: 3
Views: 1049

Each job you create will generate these folders/hashed files. If you wish to get rid of some of these then you should look at your project and delete or export those jobs you no longer need.

If you manually delete any of these from the OS level you will corrupt your project.
by ArndW
Mon Nov 13, 2006 8:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with DSGetStageInfo
Replies: 7
Views: 2474

The file also contains the requisite

Code: Select all

 Deffun DSGetStageInfo(JobHandle, StageName, InfoType)
statement which was missing in the original code so that the program takes DSGetStageInfo as a routine and not an array.
by ArndW
Mon Nov 13, 2006 5:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Link status, statistics
Replies: 3
Views: 1089

You haven't specified what exactly you mean by "status" of a link - but I think that it is easier to pass this "status" from one link to the next as a temporary column value that is dropped when no longer needed.
by ArndW
Mon Nov 13, 2006 5:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion of Chinese characters (sap ext and load into ora)
Replies: 5
Views: 1795

Pavan,

are you using NLS in your DataStage implementation? It is not necessary to have NLS to do this, but whether you have it installed or not does change how you would go about doing this. You will also need to identify where in the process your Chinese (BIG-5?) is being incorrectly converted.
by ArndW
Mon Nov 13, 2006 5:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Limitation in Parameter size
Replies: 2
Views: 702

The parameters are passed in memory, so the limit will be close whatever your environment's setting for memory is set to. The 2Gb limit applies only to some OS's and their maximum file size. DataStage variables are not limited in that fashion. More likely you will have a limitation on parameters by ...
by ArndW
Mon Nov 13, 2006 5:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how transformer works internally in datastage PX
Replies: 5
Views: 4724

bhargava129189 wrote:...not able to compile jobs when...


What errors are you getting when you try to compile such a job?
by ArndW
Mon Nov 13, 2006 5:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with DSGetStageInfo
Replies: 7
Views: 2474

You need to add this line to the beginning of your code:

Code: Select all

   $INCLUDE DSINCLUDE JOBCONTROL.H
by ArndW
Thu Oct 26, 2006 11:38 am
Forum: Site/Forum
Topic: Not receiving any email notifications of replies today...
Replies: 7
Views: 3858

I've received notifications today...
by ArndW
Thu Oct 26, 2006 6:03 am
Forum: General
Topic: How to use Tab Delimiter in New Job
Replies: 7
Views: 5854

then change the delimiter in the designer Sequential stage tab for "format" to use comma and you will be all set.
by ArndW
Thu Oct 26, 2006 5:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Aborting job for a paticular input
Replies: 4
Views: 1046

One method is to put a condition in your transform stage variable

Code: Select all

IF [column contains a specific value] THEN UtilityAbortToLog('Oh no, Mr. Bill') ELSE ''
by ArndW
Thu Oct 26, 2006 5:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Installation
Replies: 4
Views: 1159

You can install on JFS (DataStage won't know the difference). I don't think you can install on an NFS mounted drive; and even if you could it isn't a good idea to do so.
by ArndW
Thu Oct 26, 2006 5:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server and client sizing
Replies: 10
Views: 2790

Devyani, great (that rules out me being able to sell you my old PC, though). What UNIX hardware platform is currently used in-house; usually companies prefer homogenous hardware? Any UNIX system can process 1TB from a sequential file to a sequential file in that time period. But if your database isn...
by ArndW
Thu Oct 26, 2006 5:21 am
Forum: General
Topic: How to use Tab Delimiter in New Job
Replies: 7
Views: 5854

In some places where you cannot click on a "tab" selector you can use the 3 digit numeric representation of 009.

What type of job and what stage and place within that stage are you referring to?
by ArndW
Thu Oct 26, 2006 3:28 am
Forum: General
Topic: Datastage Sequencer Properties Box not opening
Replies: 12
Views: 4002

Since it is designer it is a known bug that your service provider can supply with a patch for, this would be the "SP2 Patch".
by ArndW
Thu Oct 26, 2006 1:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server and client sizing
Replies: 10
Views: 2790

Ok, I recommend using an old Intel 486 processor (or a Pentium if you feel like splurging) and the minimum amount of memory that the IBM/Ascential datastage guide suggests, but you could probably make do with 512Mb. This will be your cheapest solution. (do you now understand that this is why you've ...