DSXchange

I have a job which has a DB2 API stage as source and DB2 bulk load as Target. While I am compiling the job I am getting the error "minimum 1 output stream(s) required" in DB2 Bulk Load stage. Can any one of you help me in fixing this error. Thanks in advance. I have faced this problem bef...

Please read this post. In case you find a better approach please don't forget to post it. :D

Please switch off RCP only in the input stages to the join, keep RCP on in the joiner output.

What language was that :?: How about, we're loathe to tell people how to tip-toe thru a minefield, becuase 9 out 10 times folks don't follow our directions exactly. I am sorry :oops: But your responsibility is probably to spread knowledge ... because never can u ensure that somebody won't do someth...

Yes, I did test it from within SQLServer console & the main calling routine calls and completed all stored procs that needed to be called.. One more thing i found, in the documentation about RDBMS plug-in, in before/after SQL, it mentions that calling stored proc is NOT supported. I guess this ...

The help says that it also includes 'added functionality in DataStage routines' but not sure I could honestly say what that would be, in spite of having used these stages. :? As an example, if you import the metadata of any webservice you will find a server routine being created for each function s...

.. I suspect DataStage only send Execute on main StoredProc1 and then exit .. ?? That's right but (which then stopped the unfinished storedproc from running) this is not correct. Datastage will issue an execute and terminate and all database errors have to be treated inside the procedure itself. Da...

I continue to recommend a manual process, or hire an expert (who is cognizant of the dangers) to create your script. Your support provider will be able to source one, IBM can provide these services, some of the posters here can also do so. And so they won't discuss the steps to do it. Cuz u kn, u g...

Hi, ... a stage called folder stage which takes two columns in the second i will the contents.in the input of the XML input stage i need to mention abt the contents either as a columns from folder stage or URL. I really got confused, may be you can try to rephrase. Are you asking for a way to pass ...

So if i have understood your requirement correctly, the number of times a particular record will be inserted will depend upon a parameter value. Correct? A couple of ways, -look into the start loop and end loop activity in a sequence job. Run the same job n number of times -build your load ready fi...

Really nice

By the way, it is smarter to just right click on the file stage and do a view data

:D

Hi all, i'd like to automate the process of deleting an existing build and importing a full build. At the moment, I have a batch script which extracts a full build from VSS and imports it into DSManager. However, before this happens I have to manually delete the jobs/folders from manager. So to ans...

chulett wrote:Seems like it's hacked out of something like a PowerPoint presentation: "Let me describe the elements of the Ascential suite starting from the center and working out"...

The IBM website is the best place for such airy stuff about X-Stages. Check this out.

I am experiencing the same issue and wondering if there is an explanation. I have the following PX job: seq --> xfm --> DB2/UDB API There is a date field in the incomoing data with YYYY-MM-DD format. The coressponding field in the DB2 database is of type Date. In the tranform stage, I am using the ...

Eric wrote:As I remember. the rules of SQL say You can't INSERT into a VIEW that is made from multiple tables. Is this still true?

Absolutely, the error message says it all - <VIEW> does not exist or it is a view.