DSXchange

I am unaware of any mechanism for preventing Transformer stage from generating warnings. I had assumed, because you said "tried the following with Modify too" that you had a Modify stage in the job ... Thanks Ray for your input. I just tried having a Modify for this purpose, to eliminate ...

Add an extra Specification to the Modify stage. This new Specification contains the single word NOWARN. ... Thanks Ray..That worked w/o a warning. But I have to introduce a Modify just for this in my stream. If you could suggest something in a Transformer, that would be great. I'm still trying on m...

:idea: Any time you see "internal error" involve your support provider. Even if the debugger were available in your PATH, its output is highly unlikely to be meaningful to you. ... Narrowed down the account that caused the problem. Huge volume of records for this customer, and after few e...

I am working with columns containing similar values. In my case, I added a filter of "tr '/000' '?'" to replace the 0x000 nulls with question marks in the string. n.b. 0x000 is NUL, not an SQL NULL ... ArndW, What I did is take this X(35)'s first two bytes into a single byte field and che...

If you are sure that the input data will fit into Decimal 8,1 and Decimal 9,0 for fields 1 and 2 respectively, then you can directly map them from source to target. However DataStage will generate a warning. And you can suppress the warning to informational from the Director log. Yes..I'm getting W...

Hi, Searched for DecimalToDecimal, found few posts, but it isn't clear atleast for me, as I have to do the follwoing and struggling to get the right syntax [Transformer is what i'm using] Field 1 Input Field : Decimal 12,1 Output Field Decimal 8,1 Field 2 Input Field: Decimal 12,0 Output Field: Deci...

Hi, I have a field ABC which is X(35) coming from Mainframe wherein the value looks like this in hexadecimal: X'000000000000000000000000000000000000404040404040" in this fashion. This field when it is colum exported gets truncated and causes problem. Is there a way to Handle this using IsNull. ...

Hi, I'm encountering a strange error in Aggregator stage Internal Error: (!p2d->leadingZero() || !(*(a2 + 1) & 0xF0)): decimal/decimal.f.C: 2805 Traceback: Could not obtain stack trace; check that 'gdb' and 'sed' are installed and on your PATH This happens for one type of file from last week and...

Hi,
We have 116 files and tried using Sequential file/File pattern read, but reading takes a long time, so thinking of an alternative.
Similar to Sequential file file pattern, is there any workaround to read a pattern of Datasets [using orchadmin commands or so] ?
Thanks in advance
Vijay

Hi All We are using the File pattern property for reading a set of FIles in a directory. The Job hangs up when the Number of Files matching the Pattern are more than 500...It doesn't log any Messages and just sits there forever.... But when the Number of Files are less than 50 in the Directory...it...

Hi, I have a requirement that needs to retrive the data from the source where the lookup is not matched. Suppose if source have the 10 records and look up has the 3 matched records remaining 7 unmatched records should be taken forward to Output link. What i am doing is i taken normal lookup and a r...

Hi Prasad, If col1 values are consistent( 'M','C' & 'U'). Use the transformer stage to filter the col1 using constarints and to get three output streams.Define a common dummy column in all three outstreams with the same constant value.Next use the merge stage to merge all the three streams. Or ...

Hi Prasad, If col1 values are consistent( 'M','C' & 'U'). Use the transformer stage to filter the col1 using constarints and to get three output streams.Define a common dummy column in all three outstreams with the same constant value.Next use the merge stage to merge all the three streams. Or ...

You mean add the record length of each row to the end of the row, or keep a total of the sum of all lengths in a stage variable? ... Requirement would be to keep a running total of record lengths of all the rows pertaining to a group of records that belong to an account, so as to create an index fi...

Stage variables store information from header row. Each is updated only if it's a header row. For example svHCol2 might be drived as If InLink.Col1 = "H" Then InLink.Col2 Else svCol2 ...[/quote] Not to hijack this thread, but while going thru this, I have a question. When I am creating a ...