DSXchange

try this function TRIM(input.col,""","B").

If the target in your job is an Oraclestage then you can create a reject link and send the details into the reject file. after u have executed your job and if there are any records that are not getting inserted into the db thru oracle stage then those records will be saved into this reject file alon...

using the function Convert(char(10),' ',Column1) i am able to replace the new line with a space. but i want to replace the new line with '*****'(5stars) in the column.can any one please tell me if this possible??

thanks

I would also suggest you to check if all the columns before this column have been given values or not. if any column misses the value even 'null' then the datatype of this column expects some values which it could not find. not sure if this is the exact solution. but this mite help you if the issues...

Yes as suggested by Ray the issue was with some lock on a table. i have modified the rows of the table manually and forgot to commit the db. there was a before job script which is trying to update hte same row in the same table. but since the lock was already made on the row the job was waiting for ...

Yes as suggested by Ray the issue was with some lock on a table. i have modified the rows of the table manually and forgot to commit the db. there was a before job script which is trying to update hte same row in the same table. but since the lock was already made on the row the job was waiting for ...

That is confusing me alot. there are no changes done to the job. we are jus testing the job and we are not sure what changes are done to the job. i am getting this error while compiling through designer Error Generating transform operator for stage LD_BATCH.Trns_Records Press the "Show Error&qu...

My job has three stages. one ds file as soruce, transformer and oracle stage to load the data into db.
Syntax and all are looking fine in the transformer stage becouse this job even worked fine previously. but when i am trying to compile the job nw it is throwing me this error.

Facing this error while compiling a job. not sure why this is coming. help pls

"Error Generating transform operator for stage LD_BATCH.Trns_Records"

thanks.

one of my job is getting stuck and i have given the command "ps -ef | grep phantom" in the unix. i am able to see a process assocaited with my job. how can i stop that job! please help me in this.

hi, i have a shell script which has the code like this FATAL=0 SUCCESS=1 SOURCEFILAPATH=$1 FILENAME=$2 if test -w $SOURCEFILEPATH/$FILENAME then echo "$FILENAME HAS BEEN RECEIVED " else echo "$FILENAME IS NOT PRESENT IN THE PATH " exit $FATAL fi The file text1.txt is present unde...

This is the query we are using:

select test_seq.nextval from dual

We are using oracle seq.nextval in select statement of an Oracle eneterprise. When we run the job its incrementing the sequence by 2.
Same query with ODBC increments the sequence by1 and works as expected.

we are unable to find whats causing this.

Please help.

we are already generating the sequence value in oraclestage1 and has to use the same and send it to both file and oraclestage2. so i cannot use nextval in my oraclestage2.

actually i was also thinking on the same lines.but was not sure if i can give it that way...but tried as per ur suggestion and got it...thanks alot