DSXchange

I don't know if the job matters. Can any other users run jobs? (Identifies if it's a userid issue) Is this the first job being run in this new install? (Identifies installation issue) Does any other project work? (Identifies if it's a project or permissions issue) Can you start the job using dsjob ...

We installed the 7.5.1 recently. I am trying to run a job from director using the dsadm user, iam getting the following error Run-time error '449' Argument Not Optional This is a sequence job with one job parameter. When i copy and paste the parameter and try to run, i am getting this error and late...

djoni wrote:You bet!

Did you select the job before you checked the Release JOB. Unless one of the job is selected, it will not be enabled

Craig, Noe I am facing some other type of problem. Now We want to run the successding sequence even if the preceeding sequence finishes with warnings. But if the preceeding sequence aborts then only we do not want to run the succeeding sequence. Now when I put "Otherwise" in the second li...

mimi wrote:Hello,
Is it possible to install Datastage server and client on the same computer ?

Thanks for your help

It is possible to install But it will not work with XP Home edition

Hai Iam using FTP stage to read the source file. I have to abort the job if the source file is empty. If the iam reading from the sequential file then i can use wc -file name then trigger my job. But using FTP plugin stage I have no clue how to handle this. I can do the rowcount after the job and a...

Hello Everybody, I want to know how merge stage works. I know that we can merge columns from different sources. Do Merge key need to have same metadata? 1) same column name 2) same type and same length. Thanks in Advance Nair Both the column name and the data type should be the same. If you have th...

Hi All. I have a DB2 stage that is selecting data from multiple tables and writing into a flat file. I am using a column generated sql. When I validate my job I don't get any errors. However, when I run the job, I get the following error - [IBM][CLI Driver] CLI0131E Invalid string or buffer length....

Hi, We have numerous prod jobs which makes the log full. We have a scenario where we want to know which job has created the particular log. Is there is any routine/ utility which can give the tell which log file is been created by which job. Thanks in advance..... Regards Easiest way is to go to th...

We have a set of scripts running the datastage sequencers in Datastage 6.0....... recently we upgraded the datastage to 7.5.1 and this is causing the problem I am getting an error saying "ld.so.1: dsjob: fatal: libvmdsapi.so: open failed: No such file or directory Killed " when i try to us...

I truncated the table finally . But still I don't know how database is accepting different rows with same ID.BTW our database in Oracle 10g. You could hint it to use a different index or use the NOINDEX hint: /*+ INDEX_NOINDEX(table_name index_name) */ to facilitate removal of the problem rows befor...

Index is in UNUSABLE state . I am not able to disable the index.

ArndW wrote:Can you disable that index and do an appropriate SELECT on the table?

Hi Arnd, How can I get rid of the rows in the table now? This there any way other than droping and creating the table again. If you chose a "table load" (i.e. bulk load) then you will have an "index mode" option in the Oracle stage, set to either "maintenance" or "...

Hi All, I have 2 jobs developed in Parallel Extender that are loading data into same table.In both the jobs I am using surrogate key generator to create id. I ran both the jobs with out specifying start value. So it took default value and now I see 2 records with each ID in the database , I didn't g...

Hello Arndw, This is how it works.... Source scol1 (is key) ,scol2, scol3 ,scol4 Reference rcol1 ( code), rcol2(has scol names except scol1) Target scol1, rcol1(code for each col in source), scol value for particular code. So we are splitting each record in source to multiple records and we have loo...