DSXchange

Thanks for the feedback. So data can go down 1 or both task. Example would be a list of 1 or 3 tables....... in the case of 1 table task one would get a table and task 2 would check to see if its null and then go to Sequence 447. In the case of 3 tables, task 1 would get a table, task 2 would get a ...

I have a job sequence that does several tables updates and then I use a sequencer to split off 2 task . Task 1 does a set of things (updates tables, updates some files ) and then checks to see if everything in task 1 is complete. At the same time I have Task 2 doing other task (more updates.....), j...

I did get the code to compile however when I run this routine in a job I get the following error. "Transformer_0: Error when checking composite operator: Failed to load the library "V0S0_cpp_test_routine_2_Transformer_0.so"; either the directory containing the library file is not on t...

Trying to figure out how to get this function to return a integer. Im no c++ programmer and Im not sure how to get this to work... Any help would be appreciated. The only thing I need is to pass in a string (from DS) and Apt_hash to return the integer back to ds. #include <apt_framework/orchestrate....

Yep Ill make the changes. Im still trying to figure out what Im doing, and how to do it.

Thanks for the help.

Thanks Andy..... You would not believe how long it took me to see that -o and -O on the compile line is not the same.

Very simple code. I'm just trying to get a integer returned to a test job. Below is the code. It compiles ok, but when I run it I get: "Error Compiling parallel transformer cpp_test_routine". While making the routine I have 2 int as input and the return value is int also... #include <strin...

Hi Julio, Thanks for the suggestion, I did incorporate the same and it did work. Added NLS_LANG to user defined environmental variables in DS Admin Client. Used the parameter in the job with the value set to "AMERICAN_AMERICA.WE8MSWIN1252" and ran the job. I see a perfect match between sou...

Hi Criag, Thanks for the reply. Yes in the schema file we can define it. Instead of "string" as the datatype if we define the datatype as "ustring", that will just act as extended "Unicode" for the varchar. But if we have 200 staging tables, i will have to define 200 sc...

Thanks Craig and Andy. I will probably try Craig's suggestion. I can script to remove old files.

Hello: We receive daily file on our FTP server and I load it in the table fine. Currently, its a small (pipe delimited) file (30 rows) with the following naming convention: EXTRACT_CTCC_032216.txt (EXTRACT_CTCC_<TodaysDate>.txt) In Datastage, I created a batch and job. Batch: I manipulate the file n...

Yes. I searched and got the explanation.

This did it. Thanks!!

Hi, We get daily file with change in date. Example:Today's file: FILE_NAME_20160225.txt. I will be passing this as a parm in datastage job. TodaysDate = Oconv(Date(), "DYMD[4,2,2]"); FileString1 = 'FILE_NAME_':TodaysDate:'.txt' I am getting date in YYYY/MM/DD format instead of YYYYMMDD for...

I asked the folks on how backups are done and he said they back-up the entire server and its directories. Sorry, I am lost. I asked him to restore the back-up and I can see the jobs in director now and run them fine but can't open in designer (errors on every job saying job is not in repository). Su...