DSXchange

Hi Ernie, I think that answers my question. I was not sure if there was some other way to generate the document without subjecting the chunks through additional stages. It appears that Datastage job designs/designers have to keep this in mind ( I will, as I continue to work on XML :D ). Now I can re...

.... On the output side, have a column called myNewXML....give it varchar and a long length mostly for doc purposes, with a single "/" in the Description property (also without quotes). Should work like a charm. Ernie Hi Ernie, As I am not an expert on the XML stages in DS, i would apprec...

Hi ds2000, One of the tutorials on this link http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0703xiong/ has differnt XML Tasks. Although it is not a direct solution to your question, it will help you reach there, especially task#2, if you were to define the output as a file. Again, ...

Hi, I tried a simple test "server" job using a SQL Server table and an XSD file. I do see this issue in the output file. I will provide the datbase and data here for reference. Table DDL CREATE TABLE [dbo].[EmpMaster]( [EmpId] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [N...

Thanks Craig. 2 items not to worry about :D :D

Erine, Craig and Ray, Thanks a lot for your time and feedback. Looks like EE would be a better choice, if one were to think strategically. Ernie's thoughts on certain features not being available in EE (Folder, String length) are "gotchas" based on past experience, appreciate your input. I...

Hi Group, Is there any recommended approach for XML tasks when choosing "Server vs Parallel" job? If there are any DS XML experts (I am sure there must be quite a good number), what in your experience, would be helpful if I were to deal with a few million records, that involves joins and f...

Hi DSGuru2B, Ray, Nick, Many Many thanks for your invaluable time and thoughtful suggestions. My apologies for the temporary hiatus . I got pulled :( into a couple of other criticial tasks and also had a 1-week Datastage Training (IBM) :D :D . Back to DS now and hope to continue my visits, explorati...

Hi Gurus, Need your invaluable input and suggestions. We have a requirement to extract data from a database (e.g Oracle) and load this into another database (e.g Sybase). There are a lot of business rules that should be applied to select the data from the source. There are transformation rules that ...

Hi chulett & ray.wurlod,
Apologies for the delay.....
Thanks a lot for your time and feedback. Your suggestions were helpful.

Cheers!!!
-V

Hi Group, I am a newbie here and would appreciate your help or direct me to the correct group, if this is an incorrect forum. I have Datastage Client 7.5.2 and created a sample XML project that reads data from an ODBC source, and outputs via simple transform to an XML Output stage. The XML Output is...