DSXchange

Server jobs have basic routines. Parallel jobs use C routines that need to be coded. None provided with the product. Search the forum for examples and sample routines, including instructions on how to set it up.

Search the archives, I believe Ray also has some information about 8.0 jotted down somewhere here.

Welcome to DSXchange
Please feel free to use the website's searchengine to query for results. This topic has been covered before. Give search a shot.

What database is it? With either oracle or db2 or even sybase for that matter, you can probably write a small routine that invokes command line sql using DSExecute(), queries the table and returns the value. What parameter value to get?, that could be decided with an input parameter that you send to...

The complete solution by premium posters is viewable by becoming a premium member. Check out here for more info.

What do you mean by "some of them work and some of them dont". Which ones are not working? Insepect the data to analyze why its not working.

Incorporate Len(field) = 0 in your check and get rid of the first check.

Contact support. They might be able to direct you in the right direction.

What are the error messages? Can you copy paste them here as you see in your log file.
Is your target oracle? If yes then change the date format to YYYY-MM-DD using iconv/oconv and send it in as date. The insert will put a TO_DATE() function itself. You can verify that by reviewing the sql.

ag_ram wrote:Use a Change Capture and Change Apply Stage in conjunction

Does DataStage TX comprise of those stages ?
I am not sure how you will do this with TX but since your on unix, you can easily do this with a simple 4-5 liner shell script.

Welcome Aboard Please dont use words like 'ASAP' and 'urgent' as this is an all volunteer site and folks respond to their convenience. Having that said, please be informed that the search utility of the website is very powerful and will get answers pretty quick. Please search on keywords column unex...

Do an exact search on keywords SQLFetch: Error retrieving results from server

It might, but no need to land it to a flat file. It can be taken care of in the transformer itself. vinaymanchinila , the sample data and output that you provided gave me the impression that the hypen (-) needs to be replaced with a space and hence my resolution. Had you made it clear in your origin...

It will act uppon the trigger conditions you set. If your waiting for file to appear and its there, it wil show OK. Branch your execution accordingly.

Read about DSExecute() in help. Its not used to schedule anything. Its usage is as defined in its help. A lot of topics around that function on this website. Search for specific examples for a better understanding.