DSXchange

Hi Craig, I did search, but I didn't find anything relevant to this error and upgrade to Oracle 11g. It's entirely possible I missed it, or my search criteria was insufficient to find the correct answer. If you're aware of a prior posting that might help, could I impose on you to point me to the rel...

Hello everyone, I'm hoping someone can assist us. We just upgraded our Oracle Development Database from 10g to 11g. We are testing all our applications and DataStage jobs for compatibility with 11g. Since the upgrade, we are experiencing random "Controller problem: Error calling DSRunJob | code...

Hi Chulett- That's how I had it setup, but based on shamshad's post I thought maybe I had it setup wrong. Here's the output from running the job from SQL Server Management Studio: Msg 8152, Level 16, State 13, Procedure CMI_Business_Unit, Line 43 String or binary data would be truncated. The stateme...

Hi Shamshad- I had the SP initially setup so it accepted one input parameter which was just a dummy parameter. The way I setup the Server Job was to first have a Dynamic RDBMS stage perform a dummy select statement on the MS SQL Server as follows: "SELECT 'X' " It then passed the result of...

Wow, I feel like the Economics Teacher in Ferris Bueller Day off. Anyone? Anyone? Have I stumped the guru's here?

Greetings- I have a DataStage Server job that I created that calls a stored procedure in MS SQL Server 2005. For some reason none of us can figure out, the Procedure acts differently when executed from MS SQL Server Management Studio versus from DataStage - the same account was used in both instance...

Ray-

So lets say the first job in the Job Sequence does a record count for the current year, and the record count comes back zero. How do I get that value and conditionally execute another stage?

Hi- I need to replicate records from an Oracle table to a SQL Server table. I have the replication working with the following critera on the source OCI stage "WHERE fiscal_year = TO_CHAR (SYSDATE, 'YYYY')". Here's the issue, when the calendar year changes, there may not be any data in the ...

Hi- Is DataStage capable of creating an actual MS Excel File - not a CSV file, an actual MS Excel File. Please note, our DataStage server is deployed on UNIX, not Windows. Alternatively if DataStage is not capable of creating an Excel file, but I have an Excel template, is it possible to open it and...

Greetings all- I'm looking for advice on how to approach a project I'm just starting to work on. The project requires that I have two tables, the first table will contain transactional records, the second table will contain summarized records from the transaction table. Once I have the records in th...

Thanks for the fast response. I wasn't aware that of the dynamic array, are there any documents I can review to learn more about this?

I do want to say that if it wasn't for the DSXchange forums, I never would have know to use the EReplace command. Thanks to all who helped!

Hi- Thanks to your help, I finally got this working!! Just one last question. I was getting the following error: pass_param..JobControl (@recv_param): Controller problem: Error calling DSSetParam(FILE_DATE), code=-4 [ParamValue/Limitvalue is not appropriate] I did some searching on DSXchange and dis...

Hi- Two questions: 1. I know how to create an Execute Command Stage in a Job Sequence, but I'm not entirely sure how I would get it to read a text file as "paddu" suggests, and have it populate the variable FileDate. Can someone provide an example? 2. Once I have received a value for the p...

Hi- I have a Server Job that needs to create two Sequential Files, the two files are identical with the exception being that one of the files needs to be dynamically named. In order to dynamically name the file, I need to execute a query against a table in our database as follows: select to_char( ma...

Hi, please re-read my original post, I've already tried this.