DSXchange

What is your full job desing? What is the full error log?
What is the message about TRANSSIZE?
If you feel the message is cryptic, enable APT_DISABLE_COMBINATION to False at job level. Reset the job, to get more detailed log.

Is your topic Resolved?

In your other post Ray has given all these info with the necessary code to include in your routine.
$IFNDEF JOBCONTROL.H
$INCLUDE DSINCLUDE JOBCONTROL.H
$ENDIF

Also check this.

This need to be installed when you create a project. Atleast before your Project template. This is the only option to resolve (Not work around).

Non partitioned or Auto partitioned data will not assure you that identical key data will flow in the same partition. Say if you have 4 partitions in your system (as decided by you config file), the data will be split in to 4 streams in each active stage. So Join stage will have 4 streams in left an...

What is the syntax you use to convert? Try %HH%NN%SS.xxxxxx.
Alternatively you can convert it into microseconds, and can use time_from_microseconds() function.

Is it a delimiter or Fixedwidth, if its fixed width, you can eliminate the last character to read in.

Hi Sumesh,
Hashed file is Datastage entity and Stored procedure is Database entity. So you need to find, where that Hashed file is getting loaded from. There you need to tweak to give the default as zero.

Hi Sai,
There are some freewares available in market but why can you change the line termination for the existing job.
At the worst case, you can write a seperate job, with single varchar column with delimeter as none, and replace the last character (/r/n) with /n char(13).

Oh is Arnd Back

Hi Uma,
What you mean by enabled? It the stage not found in your client pc? If so try customization or install that stage from your CD.

Where are you calling this command? And what is the command about? What is the full log that shows you this info?

Whale - Arent you more intend to work in Server edtion

If you haven't cleared the file, LIST filename in TCL or adminstrator client, should get the content in the console, and you can use that if you can make it up.