DSXchange

Hi,

I have a XMLStream passed to a Transformer.i need to delete a specific element (eg xpath: /Root/Country/Name)from the xml.
Is it possible to delete an xml element entirely from an xml
using DataStage?



Thanks
vsi

if the first few characters is same, index function returns value > 0 pText = "CA,NJ,NY,TEXAS" Each value is delimited with a comma in the string Index(pText,"TEX",1) returns value > 0. But the value "TEX" does not exists in the input string. i am expecting return value...

Hi,

I have a certain values in a string with delimiter as comma.
values CAN BE DIFFERENT and can be in ANY order

example:
pText = "CA,NJ,NY,TEXAS"

I want to check, if "AR" exists in the string.

please advise.


Thanks
vsi

Is there any harm,if the field with varchar datatype is mentioning field length?

Hi,

Is it a good practise to define a column without defining length?

I have bunch of fields of varchar datatype, without putting length.

Thanks

I have an xml file <Root> <node/> <node/> <node/> </Root> Is it possible to count number of nodes(/Root/node) from an xml file within datastage. In xslt i can use <xsl:value-of select=count("/Root/node")/> Can someone tell me,where to use in xml transformer within datastage? Thanks

That don't work, as i am reading the file entirely.. and the delimiter count is different for each line. Here is the file looks like HEADER|&Value1|&Value2|&Value3 Body|&Val1|&Val2|&|Val3|&Val4 Body|&Val5|&Val6|&|Val7|&Val8 Tail|&Date I am splitting th...

Hi,
I have a file with |& as the delimiter.
eg: abc|&cde|&fgh|&ijk

I need to extract the values based on the delimiter |&

Tried Field () function, but didn't work here.

any other idea?

Thanks

iF THERE ARE multiple timezones on location
timezone should be null
if there is only one timezone ..Then I have to take the timezone as it is

if the location has a null timezone and a timezone . I have to take timezone

I have data like this Location Timezone 1000 CST 1000 PST 1000 EST 1000 1100 IST 1100 1200 1300 GMT 1300 CST My Output should look like Location Timezone 1000 1100 IST 1200 1300 How Can I get this .....sort keychange is not helping i.e if there are multiple timezones i need to keep null else data

Please add the database entry in tnsnames.ora file,Please send email to DBA,he will add it.
Thanks

Thanks, Craig

Job design just reading data from DRS and loading in Seq file with one lookup table.

Hi, Iam getting the following error while loading data in seq file. I have checked that no other process is using these file names error: ds_seqopen() - Win32 error in CreateFile - The process cannot access the file because it is being used by another process. Please help in this regard Thanks, VSI

Hi , a) when I execute the code, I don't get any thing on the terminal. It appears to be hanged. Only way that I could come out of it is press Ctrl+C.. When I press Ctr+C. Optioins to exit TCL prompt are shown. I tried to end the sql with ";", still the same result I checked the re-directe...

I tried to do the same with below statments. For some reason it doesnt work. The terminal just hangs and only quits when I press Ctrl+C or Q Is changing to project directory only solution??? cd `cat /.dshome` . ./dsenv bin/dssh <<EOF > $File LOGTO <project_name> SELECT * FROM DS_JOBS Q EOF