DSXchange

ray.wurlod

You should not need an IF expression. Initialize the stage variable to the partition number, and increment by the number of partitions. This sequence is guarantee to be unique across all partitions.

ray.wurlod

It's an alert. It tells you that there is a possibility that a number arriving as a dfloat may not fit into an sfloat. If you are 100%, totally, absolutely certain that your numbers will never be larger than sfloat's maximum size, then you can either change the upstream data type to sfloat or implem...

ray.wurlod

Hi I am loading data into the Oracle table.But the data volume is relatively huge so the job is getting aborted....as per DBA we are running at the highest table space....is there any performance tuning that we can do to avoid this problem Yes. You have more data than the Oracle tablespace allows f...

ray.wurlod

Are you installing with superuser privilege (that is, as a user who is a member of the local machine's Administrators group)?

ray.wurlod

That is definitely one for the Favorites folder!

ray.wurlod

Welcome aboard. Do I understand correctly that you are asking how to handle a two-character delimiter (specifically "|~") in a sequential file in server jobs? Probably easiest is to use sed as a filter command to change the two-character delimiter to a single character globally. Since you ...

ray.wurlod

Drag and drop works. But that's a move.

To copy, Create a copy, move the copy (drag and drop) then rename the copy.

Routine names must be unique within the project. (The routine name is the primary key to the local repository table in which they are stored.)

ray.wurlod

For that specific case, with "X" as the pad character and 4 as the width of the output:

Code: Select all

Right(Str("X",4):InLink.TheField, 4)

Generalize to other requirements.

ray.wurlod

XML (extensible markup language) is a way of encapsulate metadata (in the form of tags) with data. DataStage can read and write XML via specific stages (XML Input and XML output).

ray.wurlod

Find out the cause of failure and implement steps that prevent it.

No server job need ever abort.

ray.wurlod

If the only change is the Oracle patch then there's your culprit. But be very, very certain that that IS the only change. Have data volumes increased?

ray.wurlod

So the logic is

Code: Select all

If Month <= 3 Then Year - 1 Else Year

Extract month and year into stage variables and implement the logic either in another stage variable or directly in the FiscalYear output column.

ray.wurlod

You're programming a computer (albeit by drawing pictures). It will do whatever you tell it to do. Ideally, what you program will accurately reflect what the business analysts specified.

ray.wurlod

... and that means that the DRS stage supports LongVarChar, not CLOB.

ray.wurlod

Code: Select all

FUNCTION RandomTLA(Arg1)

Ans = Char(65+Rnd(26)) : Char(65+Rnd(26)) : Char(65+Rnd(26))

RETURN(Ans)

DSXchange

Search found 53125 matches

Re: Job is getting aborted Coz of lack of table space,

The Ultimate IBM Tool