DSXchange

Hi, We have few jobs for which the Monitor does not show the count. It shows the count as zero, even though data flows through those links. Is there any setting that has gone wrong ?. Some times the performance statistics on the designer screen also comes incorrect. NOTE: However for most of the oth...

Hi,

As mentioned in my earlier mail, my input sequential file is over 11 GB in size and ulimit is unlimited.

I have used both 4 node and 8 node configuration fie.

$ ulimit -a
file(blocks) unlimited

Any other inputs ?

I have a job which reads from a sequential file and writes to a fileset. This job runs fine when my input sequential file has 38 million records ( 3 GB in size) However when my input file grows big to 140 million ( 11 GB) in size, my job gives the following error. File_Set_11,0: Bad read in APT_File...

How does one use transforms that are under transforms category ?
How can I write a custom transform and how can I use it ?

I am facing the following problem in one of the parallel jobs that I run using more than 1 node: (The job contains only Input File sets, Output Seq files, Join Stages and Basic Transformer stages) 1) When the input to a job is changed after successfully running it several times with the previous inp...

Hi Craig, I work using DB2 API Stage using PX version 7.0 . View data fires the sql taking the job parameter and it works fine. However while running the job, it ignores the singles quotes in the job parameter. Is it a bug or is there a way to escape the single quotes and pass it to the SQL Rgds

Hi Craig,
I work using DB2 API Stage using PX version 7.0 . View data fires the sql taking the job parameter. However while running the job, it ignores the singles quotes in the job parameter. Is it a bug or is there a way to escape the single quotes and pass it to the SQL

Rgds

Hi Craig,
I tried putting double quotes around the single quotes and it still doesnot work. Could you give me a solution.

Not only that, I need a generic solution. I just gave a sample query to explain my requirement.
Thanks... I would appreciate if some could give me a solution

Regards

Hi All, I am also facing a similar situation and which to escape the quote character. I tried all tricks like putting two single quotes together... I would suggest doing: PARAM2= '#datevalue#' and leave the quotes out of your value. That way your date parameter can be set to a type of 'Date', which ...

Hi Folks,
Could someone suggest which is the best method to truncate a temp table in udb/db2 using "db2 api stage or enterprise stage "after I have done my processing on the temp table.

Any inputs would be great...

Thanks

Hi, I need to incorporate handling of database rejects. DB2 stage doesnot seem to be supporting the creation of reject link. The pdf help docs say that it is possible as given below,but I am not clear where to put the transformer stage. Has anyone successfully tried it before Any help wud be appreci...

But the help file for PX in the pdf doc says its is possible.

Can some one give me inputs. Any tried this before.

Thanks

Hi Vincent / Ray, I am replying to the same issue as I wanted to discuss more. Create a transformer with one link going to the DB2 stage and one a reject link with the reject check box checked. Any row sent down to the DB2 stage that fails will be handled as a rejected row back in the transformer. I...

Hi All, I need to call a function written using C++ into a static library ( .a file ) I am getting run time errors. I learnt from the help file that it is possible External Function. This calls a function from a UNIX shared library, and may be used anywhere an expression can be defined. Any external...