DSXchange

When you say this is happening in one server, is this only table that is affected or all tables in that particular database ? This is happing for all the tables in that paticular server :( That is we are not able to use Load and truncate option for any of tables in the particular database :x I also...

chulett wrote:That plus this should help, and there's no need to concat that extra delimiter.

ps. The Field() usage could be made more generic to always ...

Thanks all for the reply !!
Now the job is working fine

Again Thanks all for the support

Hi, We are still facing the same issue... The problem is really strange,for only one particular server we are not able to use the Write Method=Load ,Write Mode=Truncate ,but for the rest of the servers we can use this option... :? Infact when we use the Write Method=Upsert,records are getting insert...

Hi, We are still facing the same issue... The problem is really strange,for only one particular server we are not able to use the Write Method=Load ,Write Mode=Truncate ,but for the rest of the servers we can use this option... :? Infact when we use the Write Method=Upsert,records are getting insert...

Try double-quoting the filename with spaces, as the operating system will read space seperated strings as more than one argument. Thanks for reply!! It really worked. :) In the sequential file stage we ahve added the fileNameColumn inorder to know which records are coming from the respective files....

Hi, We are facing problem while reading the file which are having name sperated with spaces. eg: abc file.csv abc file1.csv We have tried to use File pattern in sequential file,where in we can able to read the file but in the data we also want the file name column currently the value is coming as &q...

Hi,

I actually used this parameter,but still it is giving me SIGSEGV error.
Also i tried to run the job with the Write Mode=Append, for this also it is giving same error message(SIGSEGV).

Thanks for the reply!!

Amey are you able to run sqlldr through command line because internally it calls sqlldr . Thanks Sanjay Apart from running in one node, can you try using "APT_ORA_WRITE_FILES" to keep the oracle loader files and to see if that can be run outside of DataStage without a problem? ... Thanks ...

If source is a file. definitely this will be the file issue. can you please post the source file format and job design. And do you have any constraints in transformer stage. Thanks for the reply!! But the job is pretty simple.Our source is Oracle .... We are testing the whether we are able to load ...

Apart from running in one node, can you try using "APT_ORA_WRITE_FILES" to keep the oracle loader files and to see if that can be run outside of DataStage without a problem? ... Thanks for the reply!! I have used the parameter APT_ORA_WRITE_FILES=/home/dir/abc/sqlldr.txt Now the problem i...

Hi, We are facing the problem while loading the data into Oracle table.The job is aborting due to "SIGSEGV" error.We are using following option in the target table: Write Method=Load Write Mode=Truncate We are facing these problem for a particular Oracle database server(rest for all other ...

Also while seraching the forum I have found the below link:

viewtopic.php?t=120194&start=0&sid=ad71 ... cf858b1774

But since in our tables there are no columns with numeric data type we can't implement this

Thanks for your reply! I can't change the Excecution Mode. :( But if I select ,in the properties Partition column =key_column then will the ODBC stage read the records parallelly? I am bit confused :? , as per the document it mentioned that : Execution mode. This property determines whether your Dat...

Hi, We want to read the records from SQL Server,for this we are using ODBC Enterprise stage.But the problem is that since our data volumn is huge we want read the data parallely.Can we achieve through ODBC Enterprise stage or ODBC Connector. :( If we use SQL Server stage,can we read the data paralle...

Hi, We have used the Sybase Enterprise stage to select the records from the sybase database.There are 4 columns in one of the sybase tables.We have used the user defined query to fetch the records. The columns and sample data are : SEQ_NUM(Numeric),NAME(Varchar),UPDT_NAME(varchar),UPDT_APPL(varchar)...