DSXchange

thebird, could you tell us what the compiler error is? Arnd, I am pasting my Transformer Compilation Error message below. Output from transformer compilation follows: ##I TFCN 000001 07:26:12(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5.1A Copyright (c) 2004, 1997-2004 Ascenti...

Hi, I have created 2 parallel routines - 1. Checks if an input string has invalid characters, and if so replace them with an "_". 2. Returns 1 if the input string contains invalid Cahracters, else returns 0. When I try to use these routines in a single transformer, the job gives me a trans...

This is a good suggestion. But if I am not not wrong, we need to set the 'Abort on Difference ' property to False right? Balki Hi Balki, If the requirement is to abort the job if the threshold is crossed, then the 'Abort on Difference ' property has to be set to TRUE, only then shall the job abort,...

Hi, I modified the code a little for my routine as - #include "cstring" #include "cstdio" #include "cctype" #include "cstdlib" #define PTR_INIT (char *) 1 char *stripinvalidchars(char *inpstr, char *termstring, char *replace) { int i, termlen, stringlen; char ...

Hi Eric, THe server is indeed running on a Unix platform. It is HP-UX. As Amey, had mentioned in the post above, by renaming the variable string to someother name,I was able to successfully compile the job, but when running, it is throwing the error - Transformer_21: Failed to load the library "...

Ray, The job that I am using to test the routine is a simple one - Seq File-------->Transformer------------->Seq File. The sequential file has a single field, which is passed to the routine along with 2 other arguements. When I remove the routine, the job compiles fine. So, I believe that the proble...

Hi, I am trying to create a Parallel routine using a C++ code. I have the C++ code compiled and saved as a shared object string_one.o . I have linked this object to the routine TestStripRoutine , but while trying to test this routine in a job, I get the following compilation error in the Transformer...

Hi, In the above post, there was a typo. Please find below the corrected potion , for the above post. - I have a set of load jobs (parallel) that reads from multiple sequential files (atleast 8 files per job) using the wild character option, does look ups on 2 tables, does a few validations on the k...

Hi All, If anyone has worked with the Oracle SQL*Loader (sqlldr) utility, can they please give me a brief comparison between that and a DataStage Parallel job that would load an Oracle table from a sequential file. I have a set of load jobs (parallel) that reads from multiple sequential files (atlea...

Hi,

For some reasons, the link that I had put here just didnt show up.

Sending this again.

viewtopic.php?t=89244&highlight=change+capture

Regards,

The Bird.

Hi, In my job I am generating the Row Number Column when reading from a sequential file by setting the stage's Row Number Column property. I get a warning in the director that says - When checking operator: When binding input interface field "RowNum" to field "RowNum": Implicit c...

Hi,

This topic has been discussed earlier in this forum.

Please go through the link below to find one of the postings on the same topic.

Regards,

The Bird.

Index is in UNUSABLE state . I am not able to disable the index. Can you disable that index and do an appropriate SELECT on the table? Hi, The index will have to be rebuilt . While doing a load into the Oracle table, if there occurs an error or a constraint violation then the index goes to the unus...

Hi, Can DataStage connect to Manugistics? We have requirement in which legacy data from JDA MMS system has to extracted and load into Manugistics IGP Tables. I was wondering if this can be done through DataStage. Are there any packs to connect to these systems? Has anyone ever had a tryst with this?...

If you have embedded quotes in a string they are doubled (the following is a correctly formatted CSV string: "This line is about 4"" long.",1,2,3,"Hello's to all. ""Hi There"" all!" Arnd, In this case how do I read the data in the right format from ...