DSXchange

Can be implemented in a C routine and call it from the transformer..

There are number of ways to implement this... best way is to use filter stage ........

Hi,

Provide the default precision in the decimal ...
like decimal(11,2) in the field definition....
<transform> Error when checking composite operator: Function "decimal_from_string [line 39,character 15]" returns decimal, default precision is used

Can you check the space in /tmp ...may have reached 100%...

Hi Brid,

I have 2 input files ( trm1.txt and trm2.txt ). It is picking up the trm2.txt file name and putting in the file_name column even for trm1.txt records...
trm

Hi The Bird,

When I set APT_IMPORT_PATTERN_USES_FILESET this parameter to TRUE it is printing the output file name not the input file name ...

is there any other param to set for input filename?

trm

Hi Roy,

Thanks...I want to include the file name in the column list while reading the data.......I want the actual file not the file name with wild char..

Thanks
trm

Hi,

I am using sequential file stage to read data from *XYZ*.txt files. when I select file name column in the output file name is coming as *XYZ*.txt ..
My question is how to get the actual file name while reading the data from sequential file..

Thanks in advance....
trm

There are two ways to release the locks..

1. In director release the resources for that job.

2. at command level on server side use UNLOCK user # all to release the job

resource allocation will be doubled ..( scrach disk, resource disks ) . in our environment we found lot of difference..

Define 2 logical nodes in /etc/hosts file and use those in your configuration file { node "node1" { fastname " wawdb14_new " pools "" resource disk "/var/Ascential/DataStage/Datasets" {pools ""} resource scratchdisk "/var/Ascential/DataStage/Scr...

Hi,
You can create multiple records with the help of Custom build OPD..
in the opd call Buildrecord() and 'C' control structures if and else

ram

here is the command for compiling external C/C++ routines in UNIX

aCC -c +z file_name

call this a.out from Datastage routine as external routine..

Ram

nrevezzo wrote:Here is the ecase assigned for the fix to this problem: ecase #58139.

This ecase was created 8/2004. I'm surprised it wasn't fixed in v7.5

will this issue ( ecase #58139 ) be resolved in the next Datastage release ?

Thanks

I have a job with a transformer which takes in 907,124 rows. it has two outputs, both with constraint on non null char(1) column. The 1st has constraint input.colX='5' The other has constraint input.colX <> '5' The output counts are 814,682 and 60,142 respectively, which add up to 874,824. This is ...