DSXchange

i am using upsert option. does the insert starts immediately inserting the rows. bcoz...my job ran for 2hrs and aborted in the middle due to connection failure and non of the rows are inserted. What could be the reason for this?

actually there are no rows before in this table. I have truncated all of them and trying to insert new rows. I tried to insert a row at the database level through sqlplus and it is working and i dont know whats the problem with datastage not able to insert but when i see from toad it is still not sh...

i am running same kind of jobs for around 7 tables and all of them are showing like that and there are no rows in the reject link till now

Hi...i am inserting rows into oracle table using upsert mode. The job is showing the number of rows it is processing from input to output , but when i see through toad in the table i am not seeing any rows inserted? My job is dataset---->oracle enterprise stage Can any one let me know the reason for...

i am not using variable APT_STRING_PADCHAR at job level but in the administrator it is 0x0. Do i need to change to any value?

This is happening to all the varchar columns in the table. If the decalred length is more than the actual value then it is including the spaces at the end. Is there anything i can do? i also tried trim before loading, but it is not use. And one more thing is i am not able to see the control file, i ...

I am setting PRESERVE_BLANKS to false and yes it is also a varchar. Actually PRESERVE_BLANKS is set to true at project level but it is set to false at job level which i use to truncate and load. Is that OK? Isn't this just a matter of setting PRESERVE_BLANKS to false during the load? Also assuming t...

Hi.i am loading an oracle table with sqlloader. I have a column varchar(11), but the real data consists of 6 digits in length. I have written this table to a dataset using PRESERVE_BLANKS as true. Now i want to load back to the table without blanks for that particular column. When i use trim functio...

I am doing an oracle load with sql loader. For a column i am using unicode? will it introduce an extra space in the table? please let me know?

i am truncating and loading a 5 million table. It loaded all except 200 rows with bad data. and enabled all the constraints in the end. but the job status shows as aborted and refers to see the log file. I want to know if even a single row is rejected , does it shows as aborted or is there anything ...

can any one let me know the possible reasons for this...now i am able unlock the jobs. but each time i compile a job it is just hanging and i have to close it through end task and then unlock it.

i tried it many times but i am not able to compile any new jobs...already some jobs are running.

i am not able to understand its behaviour . now iam able to see the list but
when i give the following command..it is giving error


UNLOCK USER 63824 ALL
Unknown option, please check command line

that was the error before...

but again when i logoff and login to telnet server it is working.. but when i give list.readu command it says Verb "LIST.READU" is not in your VOC.

i am not able to see even the list of locked jobs

My designer is hanging when i try to compile my jobs and when i close the designer using endtask , the job is getting locked.

Once i login to datastage telnet server and try to unlock the job i get the error

USER keyword requires a user number

What is the reason for this behavior?

lookup file is just 10,000 records with 2 cols. The input table is huge and i think the lookup stage doesnot accomodate that amount of data. it contains 10 million records. i do lookup on one column. In order to avoid problems in the future i am using join stage.