DSXchange

use xmtype as string and datastage type as longnvarchar

Reference link -
http://publib.boulder.ibm.com/infocente ... pings.html

1. How to verify patch JR30015 is installed.
-- version.xml specifies the patches installed

2. How to install FixPack1 installed for 8.1.
-- there is a standard procedure doc from ibm on this.

Regards
Sreeni

The datatype XMLTYPE in ORACLE is derived from CLOB.
You can use LONGNVARCHAR or LONGVARCHAR and try out.

Regards
Sreeni

OMD.XMLDIR is use to store metatdata information of the job.
More details as you search:)

Regards
Sreeni

I think its quite a clear message from the 'SQLServer DB' that the 'DB is being shutdown'

Regards
Sreeni

You can use a 'dummy input' using rowgenerator and a 'dummy ouput' (dummy output if you do not need error handling)

Regards
Sreeni

I found that generally the developers use 'xmleditors' but the 'operations/users' use browsers to look into the contents of the xml

Regards
Sreeni

Normally all XML parser's can read an empty tag in the format <empty/> which is equalent to <empty></empty>. May I know the files you produced, are you viewing through any browser like internet explorer / mozilla etc.. if yes then it will by default show you in the format <empty/> but if you open t...

Hi VMCBurney,

Can you try SQLSMALLDATETIME ?

Regards
Sreeni

There is no 'linear or exponential' relation between the number of recrods and the number of cpus

Regards
Sreeni

1.Write to a 'flag file' with the status 0 (finished),1(not finished) after the 'index related work'
2.A job which polls the file using the waitforactivity stage
3.Use the job created in step2 before any datastage jobs which uses the table

Regards
Sreeni

You can do it by providing the right path in the code but its not advisable to change 'datastage system files as the datastage job runs'

Regards
Sreeni

There is a BLOB column feature in Oracle. There could surely be something similar in DB2

Very Nice to hear that 'non-repeating key' element is removed. Now we need to handle these duplicates inside the job which is in a way 'visible flow in design' You mentioned about additional capabilities in the XML input stage. That's good news as well since these features are already present in oth...

This is a very constrained OR limiting feature of XML usage in Datastage. Hopefully this 'non-repeating key' element feature is not present in 8.5

Regards
Sreeni