DSXchange

Noticed if your replacement string is nothing(""), job ends with a SIGSEGV fatal. You can probably use Trim to remove a string instead though.

thx

Found the problem.

The return type in my parallel routine was char . I should have selected char* . My bad.


thanks

Hello All, I found this post and it describes the same scenario I am facing. I have created the HelloWorld c++ code: #include <stdlib.h> #include <stdio.h> char * ObjTestOne() { char* OutStr; OutStr="Hello World - Object Testing"; return OutStr; } I tested the version with main() in it and...

Thanks Everyone for the suggestions. I was about to post the solution when I read acx_dyates post, which describes what IBM found to be the problem also. We replaced our 8.5 DSParams file with an 8.1 version(resulting in missing functions, sysvars and probably other things in our 8.5 environment). D...

Below is text in the copyright box from the Creator tab of \Stage Types\All\Processing\Transformer: Licensed Materials - Property of IBM, (C) Copyright IBM Corp. 1999, 2010 All Rights Reserved. On a side note, we installed 8.5 about a month ago and this is the first time we have tried the looping fu...

Thanks. I currently don't have the 'Last Row Handling' branch in the function tree. I also added the following to my 'loop condition': @ITERATION <= 3 Note - I had to type in @ITERATION, as it is not available for selection. When I validate the 'loop condition', I get the following message: variable...

Hi Ray,

Yes, there is a loop condition in the transformer. Job was created in datastage 8.5.

I also created a new job in 8.5(in case something was corrupt in my original job), but see same problem in new job.


I have created a PMR with IBM.

Thanks

Yes, running 8.5

thx

I have read several threads pertaining to the LastRowInGroup(), LastRow() and LastTwoInGroup() functions. I want to include one of the above functions in the derivation of a staging var, but none seem to be there. Only see the standard functions(Date & Time, Mathematical, Null Handling, String, ...

I just noticed in Greg Knights post, he also mentions using the funciton lastrowingroup to achieve a vertical pivot. My bad. Bad Robert

I have used Kaps recommendation in this thread(using staging vars and then remove dupes). I noticed a reference in this thread to using the loop construct in a transformer stage in 8.5. Everything I have read so far indicates the xfm loop allows one to split a single row into many or add an aggregat...

Hello All, I am using a pivot stage and the pivoting works fine. However if I pass additional nullable columns thru the pivot stage(not pivoted columns, just columns needed later in the job), job bombs with the message below. Pivot_Enterprise_237,0: Fatal Error: Null value on the accessor interfacin...

Just Curious. When I open the config file editor in designer, it is looking for config files in the following directory: /ibm/app/Server/Configurations/ I want to keep my config files in another directory and still be able to edit them with the config file editor in designer. Anyone know where this ...

Thanks for the feedback. This sounds kind of crazy. It is one particular schema. For example: If I import metadata for any table from schema 'A'(with primary keys), import fails. If I do same import, without primary keys it works. If I import metadata for any table in schema 'B', 'C', 'x',... (with ...

We actually had a different issue with the odbc connector, but I think we may have found the problem. We will probably use odbc if this solution works.

thx