DSXchange

I need to transfer file from Datastage unix server to other server

but ,before moving that file , need to check whether the folder is available or not, if folder not available then need to create the folder

please suggest best approach for this

Thanks

Thanks ray

Hi, while iam loading data into SQL server table using ODBC connector,getting below error message, my columname FUNCTION, its reserved sql name so getting the below one,please suggest how to handle this ODBC function "SQLExecute" reported: SQLSTATE = 42000: Native Error Code = 156: Msg = [...

Please ignore the above post, posted in confusion, it got resolved,

sorry for the inconvinience

We have generic job, which compares the data and creates dataset, based on that out put dataset my second job will run, but the problem is if we didnt have data compare job not creating dataset, so the second job getting failed and throwing error no input dataset available.. Can you please help to p...

Hi,

I have 4 job activities in a sequence , my first activity job got finished but its not giving status as success , still its in running mode , that's the reason my sequence not moving to next job activity. up to yesterday it was fine. can you please help on this

Thanks.

Hi , i am running 12 jobs parallelly using sequencer and jobactivity stages . my requirement is if any of the job then all the jobs should abort.i had prepared job using exception handler and terminater activity stage to do that .but it aborting the sequencer if any of the job aborts but the jobs in...

Hi All, My job got aborted by giving of error "There is a circularity in the dataflow between operators." .if i run the same job by adding of APT_DISABLE_COMBINATION=TRUE its running continuosly and not giving any result. iam comparing source data with target using Change capture stage in ...

Thank you so much BillB. its working fine after adding of ENV

thank you all.

Hi all, Iam loading data from sqlserver to oracle using sqlserver stage and oracle enterprise stage. if the source having data in sqlserver there is no issue if there is no data its giving error"the call to sqlldr failed the return code = 1" my target oracle option is load--append mode can...