DSXchange

Hi, I need to truncate a table based on a conditon.........For a column 'Input' There will be two values A and B . I need to truncate only for the value A . Previously when there was no condition I used to use Stored Procedrue to truncate the entire table.........Now can I use SP with a condition to...

Hi, My requirement is to read a file. Actually there will be a file in the ftp Common folder. We have a script that will take the file from there and keep it in our project folder. When I'm trying to do a view data...I'm unable to..... :cry: . I did a VI and saw that there are some trailing spaces[^...

Hi,

Whenever i try to set triggers for the Sequencer, the designer closes automatically. Is there any way in making it not to close like that. Please tell me if there is any way........


Thanks in Advance
Purush

Hi,

I want to filter the Duplicate records and also capture them.I can use a Remove Duplicate Stage by which I can remove duplicates but cannot capture the Duplicate Records. Can I use a Transformer for this.If so, Can anyone tell me how can I implement the Logic......

Purush

Hi,

I want to read an excel sheet in an ODBC Stage.Is there any way to do that.

If there is any solution,please respond.

Thanks,
Purush

Hi, I have to put Timestamp to a table and i'm using a macro for the same in the Transformer to get the Timestamp,and after that I'm loading into a Oracle Table.For the same I'm using an Oracle-OCI9 stage in the Job(Server Canvas). Whenever I try to load the Job,I'm getting an error as ORA-01861: li...

Hi, I was using COLUMN_NAME=? in the sqlquery inthe ODBC stage to make a LookUp. Now the requirement is to use an DB2 stage,if I'm using the same query it is throwing an warning saying incorrect number of parameters. [IBM][CLI Driver] CLI0100E Wrong number of parameters. SQLSTATE=07001 Can anybody h...

Hi, Whenever I try to view data from an ODBC stage, I'm getting the following error and the Job is getting aborted DSD.BCIConnect connecting to DB2D, call to SQLConnect failed. SQLSTATE=S1000, DBMS.CODE=-719 [DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver][DB2]BIND ADD ERROR;...

Thanks Kumar...........

Got the Option........

Guys, I'm new to DataStage and in my Job I will Loading the Data from a DataSet to a Oracle Enterprise Stage in a parallel canvas. I didn't even find the Index mode only. I saw that Loading can be happen in three ways- Load, Upsert and Delete. I'm not knowing where this Indexed mode is coming into P...

Thanks for the Replies.......... See I have the options of the APT_ORACLE_LOAD_OPTIONS defined as (DIRECT=Y,PARALLEL=TRUE,SKIP_INDEX_MAINTENANCE =Y). I'm not using this parameter anywhere in the Job.I'm declaring it only as Job Parameter. When will this options will be taken by the compiler? Purusho...

Hi All,

I'm able to load data into the Oracle Table and using the parameter "APT_ORACLE_LOAD_OPTIONS". But i'm using it blindly.Please can anybody tell me abt this?

I will be very thankful to them...

Purushotham

We are making a Job to read data from a .txt file and write it to a .ds file and using the dataset.

Is there any simpler way to do this,as orchadmin is there to copy .ds file to a .txt file.

Need Suggestions........

Hi ,

We got the same problem when we installed the 7.5x2. Whenever we compile any Job which is having a transformer we used to get the same error.The pre-requisite for the transformer stage is .NET FrameWork, which needs to be installed before.

Purushotham

Whenever I compile a Job which has the Transformer stage I get the following message in the warning......... ##E TBLD 000000 02:27:08(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 10496. Please respond........as this is an urgent issue that is...