DSXchange

Which version of 7.5 series you're using, to connect to 11g.
What I know is Only after 7.5.3 V series supports 11g because we are using 7.5.3 to connect to 11g.

We have upgraded the Datastage Server from 7.5.1.A to 7.5.3 recently and we started encountering below error: Parallel job reports failure (code 139), Contents of phantom output file => 22100 Segmentation Fault - core dumped Job is simply inserts /updates few tables and was working in older version ...

Yep, Culprit was Continue itself.

Thanks to you all over there.

I have a shell script like: flag=1 tail +2 $1 | while read LINE do tag=`echo $LINE | awk -F',' '{print toupper($7)}'` chk=`echo $tag | tr "[:lower:]" "[:upper:]"` if [ $chk = "ACCEPTED" ] ; then continue; else flag=0 break fi done echo $flag This script checks for the v...

I have a routine which just calls the Shell script and the returned value from the script should be used for further processing.But whenever i call the script from rouitne,it results in uneven result .But the same script if I execute in unix box, it works fine.Can any body elaborate me on it's misbe...

Still I am not able to get any alternative in my design.now i am facing following error: XML_Input_0,0: Error: Unable to resolve prefix 'env'. pattern = '/env:Envelope/env:Body/ns:getSnapshotsIntraDayResponse/ns:subscription/ns:snapshot/ns:curve'(Unknown URI, 12, 147) Remaining tokens: ('/') when i ...

xml simple format : <?xml version="1.0" encoding="UTF-8"?> <env:Envelope xmlns:env="http://schemvalues.zzzz.org/llll/envelope/"> <env:Body> <ns:gevalue7nvaluepshovalue7OneDvaluey xmlns:ns="http://xyz.com/dlws/value8clevaluer/20070930"> <ns:hevalueder> <ns:web...

Hello all, we have xml data file which we need to convert into relational format and load into Database. we need to have multiple repeating elements needs to be considered and in the same time i am unable to build xpath expressions for the same. I have gone through the Kim's XML best practices and u...

I mean to say,It's simple select statement even not involves any where clause also in it.

My test environment is on single node only,so there is no issue with the partition at all, but the same will run in production environment peacefully which is 4 node combination. It was running fine everytime, for past 2 years but from past 3 days it's showing this kind of unethical behaviour. I nev...

Hello All, We have a DS Job which will just pull the data from the database table and update or insert the data into another table. Data is pulled from a DRS stage through the Autogenerated sql and propogated ahead for further processing.There is an Index on the source table and is Disabled too. Now...

All, we have a server routine,which was previously working in production environment nicely.Due to changes in requirement ,we just modified that routine and is working fine in development environment. But when we overwrite that existing with the new one in production ,we are facing the issues. Actua...

Andrew/Chulet,

with your help ,we are able to do it.
your "In.string<2>" done the magic.
If i would have able to get your "output<14>", that would have only done this magic early.

anyway Thanks in tonnes.

I edited my existing routine and without using any datastage functions Some how i managed to get output as shown below : now all i need is only emailid part like:

Could you elaborate more...
Actaully there are some newline cahracters involved in it after firing my function:
Ans=trimF(trim(Field(Field(Output,'>',2),'',1),'-','A')) ..

i want the result which exists in 4th line.
4th line has got my email id which i need to extract.

Thanks..