DSXchange

my DBA also checked the free space as mentioned in earlier responses; but he thinks that this is not the problem on temp tablespace;

hi I hit a similar problem; however I am using the newer version 8.0.1 running on windows 2003 server. my sqlldr return code is 7; Input is 9,999,999 records and it failed about 1.8 million records (trying with 800,000 and 1,5 milllion records were ok). I have tried to use the normal sqlldr and all ...

To the last post : it is a root installation. Anyway, managed to login through TCL --------- cd $DSHOME bin/dssh >LOGTO ABC --------- Did a DS.TOOLS and selected rebuild indexes repository. Restarted datastage; and now I am able to connect to the server. Suspected that the indexes were corrupted by ...

Have checked that the process dsprc is running. Also Encountered error 'Failed to connect to host : aa.bb.cc.dd, project UV' (The connection is broken (81002)) from datastage administrator.

Would have to check output of netstat-a command and update outocme.

Encountered error 'Failed to connect to host : aa.bb.cc.dd, project abc' (The connection is broken (81002)) from datastage designer Encountered error 'Failed to connect to host : aa.bb.cc.dd, project UV' (The connection is broken (81002)) from datastage administrator The connections used to be fine ...

Input : Oracle Output : Oracle I have 5 input structured address fields (Block-House-No, Street Name, Building Name, Floor No, Unit No). These fields are to be concatenated into a single output address field but with multiple lines : (Line 1 : Block-house-no, Floor No and Unit NO; [linefeed] line 2 ...

hi I was used to DataStage V6 but now introduced to DataStage V7.0 - parallel extender as we require speed during data loading. Noticed that there are 2 types of jobs : Server and Parallel; while the server job seems to operate in the same manner as in V6, the parallel version seems different. The m...

hi
Just an update that the reinstall did not seem to work. Maybe the uninstall does not clean up the registry (??)

Anyway attempted what Arron suggested and it worked....

Thank you for all the help given
Regards

thank you; would attempt the reinstall option Regards and have a great day!

The menu bar is the one where the 'FILE VIEW TOOLS HELP' options are situated. It is quite troublesome without this bar in situations where you have opened many windows and would like to close them or to exit from Datastage designer..

Thank you

How do you enable the menu bar on the datastage designer client after it has been closed accidently?

My sample file is like this :[done via vi editor in Unix] F1510849P20030305T01T02S7118151515151515 F1600980Q20030304T37T42T3021151516181616 S8617285B20030305R14S80S8523181818201818 S8630534H20030305R14T38S6227191919191919 ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ "regdata_sample.txt" [Incomple...

My DS job reads an input file. This input file is from an external source; so we could not control how the file is created. The file must reside on Unix;when using the Unix command 'wc -l filename'; the number returned is always n-1 (where n is the number of records). If we use telnet from dos; then...

I am using Oracle 9.2.0.4;
Where could I find the relevant documentation on upsert ?? I could not find it in the Datastage designer manual.

Thank you
Regards

Just to clarify my original posting : I have hardcoded a directory in my DS job parameter /u01/ascential/DataStage/Projects/Data/dsdvstud/ The requirement is to remove the 'hardcoding' by using something of the form ~/DataStage/Projects/Data/dsdvstud/ where ~ is the unix home directory for Datastage...