DSXchange

You can try with column import/export. Example if you have A,B,C as 3 different columns. Through column import/export we can make it as A,B,C as a single individual column. But delimiter will be there or will exist. Probably you can try to get more from that. If you dont want delimiter then transfor...

There are two reasons when this error can occur. 1. May be you are trying to run two parallel query to do same operation on same table, without using PARALLEL= TRUE. 2. You may have already done some DML activity , which needs a COMMIT to be done on the table. When commit is not done for a table aft...

Table getting locked due to any DML statement getting not commited

If you need invocation_id for each loop activity, then you must declare a parameter called "instance no" or some thing. This parameter must be changing every time a new loop is running, it must be dynamically changing. One important point is job must be multi instance job and invocation id...

First analyze following things...which tool can't do -------------------------------------------------------- 1. Number of jobs to be migrated 2. Sequencer's need not be touched; they will work same as in server. Only few changes are to be done for the sequencers. 3. Number of jobs where HASH file i...

Hi We are calling SAP BW through Plug in. The job is PUSH job. There are two parameter's which we need to assign,that is Connection Name and Source System name. When we hard code the values for these parameters, the job is getting completed successfully. But when we pass the values through job param...

thanks Ray.
But is it good to use Message Handlers and make this warning as informational.

Hi I have many jobs in which I call only unix scripts using ExecuteSh using after_job_subroutine or before_job_subroutine. while running the jobs , its giving an warning as follows main_program: Step has no operators Which is correct,as my job does not have any stages. Is there a way to supress this...

Yes , you can use it in DS 7.5.2 We have implemented in 7.1 server job itself. But Insert/update is slow when using ODBC. Best Way for using GreenPlum with DataStage is use "gpfdist" fast greenplum loader using unix. Very soon they are coming with native connectivity between GreenPlum and ...

Please post the exact message. Check also that your project directory's file system is not full, and that you have write permission to it. Re-indexing is unlikely to help, as the log tables are ... Yes, I think my file system is full its almost 96% used. So what files I to delete from my project di...

When I am compiling any of my server job it throws an error " Error Calling RTLog<numbers>". Some times it says "check data stage is set up correctly"

Why is this occurring. Is rebuilding job index is the solution. I have searched forum but did not get solution.

Ok.

Is there a way to set ROW limit using API programs...or how to set row limit in Parallel jobs.

Dear All I am trying to set row limit for a job. I am writing code in Job(Job_UsingColumnGenerator) --> Job properties --> JobControl Tab. Code: ------- Job_handle=DSAttachJob("Job_UsingColumnGenerator",DSJ.ERRWARN) LimitErr = DSSetJobLimit(Job_handle,DSJ.LIMITROWS,5) Deterr = DSDetachJob(...

Thnks ArndW

ITs working. I gave the following command.
bin/dsjob -server <servername:port> -user <user> -password <pwd> -run <projectname> <job_name>

I got more information We have got two Datastage installed in same server 7.1 server and 7.5 PX. I am into PX server path U10/PX/ds7.5/Ascential/DataStage/DSEngine From there I am using bin/dsjob. I used bin/dsjob -ljobs ric_dss_dev, but this gives me all my server jobs created in different mount po...