DSXchange

Hi all, Thanks for reply. I am unable to see the Andrew message because I am not a premium member. My project is divided into several levels (1, 2, 3, 4, and 5) Levels 1-4: loaded high volume of data. As I understand, Using parallel jobs, loading huge amount of data, the performance is good (Server ...

Operating system: Unix (HP-UX)

Thanks for giving replay, I tried with a simple cpp code.I followed the same procedure which I used previously but there are no arguments. #include <stdlib.h> #include <stdio.h> int ObjTestOne() { int OutStr=321; return OutStr; } Object file creation: Compile and create object file: bCC -O -c -ext -...

I created a parallel routine // This is a C++ Routine (Sample1 routine) #include <stdlib.h> #include <stdio.h> #include <iostream.h> #include <string> { <Code> } Object file creation: Compile and create object file: bCC -O -c -ext -z +Z Sample1.cpp Note: The compiler path is same as in the administr...

Hi, I tried the below syntax for converting decimal to string using modify stage. Source column:CUST_ID/decimal/38/Key column Modify stage Derivation:CUST_ID:string[2]=string_from_decimal[suppress_zero](CUST_ID) Target column: CUST_ID/varchar/1 I am getting the below warning: Error when checking ope...

Output from transformer compilation follows: ##I TFCN 000001 01:46:17(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5.2 Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Rights Reserved ##I TUTL 000031 01:46:17(001) <main_program> The open files limit is 2048; rais...

Hi I am getting compilation error. Parameter specified but not used in flow: DSWorkingDir When I removed the stage variable of the Relation then it is working fine. But I need to substring of the Relation. Any inputs greatly appreciated. Source column: Relation/Integer/2 Transformer stage variable\ ...

First i converted the source column into varchar then I used the below string function
Convert('.','',col1)

It is working fine now.

Thanks,
SuRi

Hi, Source column name/data type/length: customerid/Numeric/2 Server transformer Column derivation: Iconv (DSLink79.customerid,"MD0") Now I am doing migration from server to parallel. As I understand from the fourm; ICONV/OCONV functions are only applicable to basic transformer not to the ...

Hi, Now I am able to get the value of the column is null then 0.00 Source column Col1 Datatype/length is Decimal/13.2 First created a stage variable Stg1 Derivation expression: If (Trim(Link1.Col) = '' Or IsNull(Link1.Col)) Then '0.00' Else Link1.Col data type/length of the stage variable: Deciaml 1...

Source column is col1 data type is Decimal(13,2). In the tranformer i am passing to a column derivation. If (Trim(Link.EMP_COl1) = '' Or IsNull(Link.EMP_COl1)) Then '0.00' Else If Lnk.REL = 1 Then Link.EMP_COl1 Else '0.00' Target column length: Decimal(9,2) Example Source :487.67 Output shuold get: ...

Thanks a lot.

i am able to see the exact time of deletion of the job.

Is it possible we can find the system ip,. beacuse we are using the same login user name for 10 members.

THANKS FOR REPLY. I TRIED IN THE ADMINSTRATOR COMMAND PROMPT Command: LIST DS_AUDIT WITH KEY LIKE Jobname12 it is showing no records found. I tired with LIST DS_JOBS Is is showing the present jobs. it is not showing previous jobs. as i checked in the Director->clean up resources-> i didnot find the ...

Hi,
we created jobs under a category.
the category is deleted. We didnot take any back up. Please let me know how can we track who deleted the category?
and how we will revoke the code?

Please share with me if any one have solution.

if i give the actual length for all the columns same in the source and target. it is working fine. But in my oracle stage user defined Sql: select nvl(a.col1,999) as col1,a.col2,b.col3 from table a when ever i use the functions like nvl, to_char, min,max and so on in the sql query it is showing that...