DSXchange

DataStage Environment Variable APT_COMPILER/APT_LINKER should give the answer.

dspxguy wrote:how would i know from unix command line which supported c++ compiler is being used with datastage.
thanks

I cann't see there is a direct way to do it, but maybe it is not hard to translate the column definition csv file into a DataStage schema file. Hi, I have to import column definition from csv file. File structure is given as below: Column Name,Type,Size,Constraint ID,Number,10,Primary Key C_ADDR1,Ch...

Why did you remove the duplicates from the Reference stream if the below results are required? Try to get rid of the remove duplicate stage from the reference link or both. Reference Link: db2 stg -> remove dup stg -> Tx -> Join Target Dataset: (required) A B C - -- -- 1 J 33 1 J 78 1 J 44 2 K 65 2 ...

Just for your information only. I tried to create my own trim function using C to remove the leading and/or trainling spaces/tabs and it worked. I changed the contents of the input string and then the address of the input string was returned as the result. The string returned from Trim2 was correct ...

DSguru2B, I pasted your codes here, will the memory buffer (finOut) be released by DataStage (I am quite sure it will not be released by the routine itself)? That's OP's question. DataStage needs to call "free" or "delete" explicitly to release the memory. I cant find any documen...

Not sure whats inside DataStage. Maybe DataStage uses global memory buffer...maybe DataStage cleans up the momoery area used by the standard routines. I don't know how and where I can find the C codes DataStage generates for a job. Otherwise we can get the answer from there. :? Interesting - so if I...

I guess youself should clean up the momory by calling delete in your routine. I have rewritten your codes in my way :) (i know its not the perfect way): #include <string.h> char* GenerateStringFromParameter (char* StringParameter, char* buffer) { // copy the contents of the argument strcpy(buffer, S...

I don't think this is the proper way to return a string from a function. The temporary buffer address should not be referred outside the routine. Did you try to compile and run the routine in a C++ program? In my opinion the buffer address to hold the changed value should be passed into the routine....

Did you use the same input data for both? I guess there must be non-numeric characters in IncomingCol. By the way why not use the interal function FLOOR? I guess it does the same thing as your code "Left(TempVal, index(TempVal,'.',1)-1)"?? TempVal: StripWhiteSpace(Link1.IncomingCol) * 100 ...

No idea

abc123 wrote:TempVal: StripWhiteSpace(Link1.IncomingCol) * 100

I took back what I said in my previous post. All the columns have to be keys to get the exact result (in this case only keep the Deletes). You may also want to remove the duplicates after change data capture. ============================================= Does the metadata matches between the before ...

Did you notice that the first two records of the source don't match the lookup? You can change the action for the Lookup Failure condition if you want the job to contine. my source is teradata table. my target is also a teradata table. I have to do lookup get the related records where there is key m...

Good idea!

DSguru2B wrote:What about the Change Data Capture stage? ...

Can you post the sqlldr control and log files? It would be helpful for us to identify the issue.

ssunda6 wrote:I am able to insert a blank field(one space) manually into one of the Varchar2(1 char) field of the table.

Try the combination of Outer join and filter stages.

ramesh_c wrote:Hi all,

I want to perform the minus which we will do in oracle through datastage .Is there any stage which will perform this .

Thanks in advance

Ramesh .