DSXchange

Hi All,

Thanks for your replies,

my pad string is 0x20. If I am not wrong this means space.

I changed my trim function as follows and with surprise it worked.
Can anyone explain me why ???

Any idea how to remove this pad string. ??

Hi all, I have following job design FF ---> Transformer ---> Transformer2 ---> FF2 FF - Fixed Length, All columns are characters Transformer -> converts Characters to Varchar Transformer2--> Uses Stage variable (svLength) svLength=Len(Trim(Input.Col1[1,8])) However svLength always gives me 8, even f...

To nagarjuna It rejects with the error text as "Row not updated" with error code "0" which says successful completion. To jreddy Before this load job i have Transformer job where i m taking CDC, finding which are update and insert and then merging them. The thing is my insert th...

Hi guys, I am using ORACLE Connector stage. For upsert If i use Insert then update it works fine, however as my files has updates more then insert it takes too much time. So i Changed it to Update then insert . Now the problem is when it fails to update the rows rather then inserting it sends it to ...

no there is no problem with the path. i copy the command generated by sequence from log and run on shell and it gives output.

this is also not working.
if i will call above script like as below, it will list all the files However if i call same script with same parameter from Execute command it prints only following line
aa*1

Hi All, I have a shell script which i am calling from command activity, the script gives desired output when i run from Shell but it behaves weird when i call it from command activity. I debug the script and figure it out that there is a particualr part in script which bahevs unexpected when i call ...

Hi, I got this option while searching.. https://www-304.ibm.com/support/docview.wss?uid=swg1JR38643 /NODEPENDENTS however the problem is.. when i do export i want both job design and executable. And when I export using command i only gets Job design and if i use option /EXEC i m able to export only ...

Hi All, I am trying to export the datastage jobs using command line. I am using following command but the problem is it is executing with dependent object also.. is there any way I can export without dependent object, both executable and design. dsexport.exe /D=dev244:9080 /U=gaurang.shah /P=passwor...

Hi All, I am using netezza enterprise stage in one of my job. The problem is table into which i have to load the data has composite key. So in netezza stage in keycolumns i provided both... and in uniquekey column i have provided one of them. Now it gives me this Error "None of the Keys of the ...

I know how to handle through message handler. i want to know is there any way apart from that ????

Hi all,

Is there any way i can use the varriable or command output in "Email Body" of notification activity ???

ShaneMuir wrote:It is possible with message handlers.

However what is the warning message? Is it something that can be resolved without suppressing the message?

warning message is as follow

ORA_DB,2: Number of records rejected on the current node: 2272

Hi guys I have sequence which send the mail... in the attachment it is as follows. #UserVariables_Activity.files# and in the UserVariables_Activity variable file is as below /apps/dev/project/abc.rej sequence hangs when it goes to attach the file... any can tell what is the possible reason ???