Search found 77 matches

by rajiivnb
Wed Mar 16, 2005 5:01 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Mutex error with only released jobs....Urgent..
Replies: 1
Views: 3327

Mutex error with only released jobs....Urgent..

Hi, 1. We are facing a problem in running released jobs through server edition. Its giving mutex error problem for the IPC stage. The same job is running fine with non_released version i.e., the original job. Its throwing error only for the released version. we are sure that we released the exact jo...
by rajiivnb
Tue Mar 15, 2005 12:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to release multiple jobs...
Replies: 6
Views: 1746

How to release multiple jobs...

Hi group,

Can any one tell me how to release multiple jobs. if i give the sequence to be relased, the job name given inside the seqeunce is not atomatically changing to the released version of the job. can any one suggest me a proper way how to release the jobs...


Thnx in advance..
by rajiivnb
Mon Mar 14, 2005 9:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Steps to carry while creating New Project
Replies: 1
Views: 734

Steps to carry while creating New Project

Hi all,

Can any one tell me, what are the steps to be done for creating a new project and copying a project which has parameters..

Also please tel me wht are all the way i can add more performance to that project...

thnx in Advance..
by rajiivnb
Wed Mar 02, 2005 7:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Join tables from 2 different databases
Replies: 14
Views: 5859

Hi madhonrougeuri ,
ODBC stage pulling should be used as reference link .Get into transformer properties and input tab of the reference link at the bottom you can see the option.

Regards,
Rajiivnb
by rajiivnb
Wed Mar 02, 2005 3:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Join tables from 2 different databases
Replies: 14
Views: 5859

Thanks sumit i found them
by rajiivnb
Wed Mar 02, 2005 3:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Join tables from 2 different databases
Replies: 14
Views: 5859

Hi sumit, I use the Hash file for lookup but finding many rows with match values ,the same way when i use a odbc also i see many rows with matching values but it takes only last value what is the solution for this??.You gave some option In the transformer properties > Input tab select the "Refe...
by rajiivnb
Wed Mar 02, 2005 12:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: writing no matching columns from lookup to a file
Replies: 2
Views: 740

Thanks Ray.

Regards,
Rajiivnb
by rajiivnb
Tue Mar 01, 2005 9:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: writing no matching columns from lookup to a file
Replies: 2
Views: 740

writing no matching columns from lookup to a file

Hi,
My lookup doesnt have any matching condition.But i required to track the status of the column which is not matching to a file and finally sud mail that file.Is this possible with 7.1 version.

Regards,
Rajiivnb
by rajiivnb
Sun Feb 27, 2005 9:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to trace the warnings illegal date/time value
Replies: 5
Views: 2359

Hi, My routine is working fine with the manager test by giving the @date but the same when i call them in designer gives me the date/time illegal values.Well i m using 7.1 and informix database with unix platform.I still have this warning thrown.And a specific column is date type but when i try pass...
by rajiivnb
Sun Feb 27, 2005 9:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: calling a sequencer from command line (urgent)
Replies: 15
Views: 3668

Hi,
my client is 7.1...is it possible to run from cmd line
by rajiivnb
Fri Feb 25, 2005 1:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: calling a sequencer from command line (urgent)
Replies: 15
Views: 3668

calling a sequencer from command line (urgent)

Hi,
My server running in unix environment and i require to call my sequence from a command line from my client machine.What is the command for that.??
Thanks in advance.

Regards,
Rajiivnb
by rajiivnb
Thu Feb 24, 2005 10:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to trace the warnings illegal date/time value
Replies: 5
Views: 2359

Hi ray,
I understood the problem .When ever i call a @date function for todayz date it tells me the problem as date/time illegal.And my routine which i call is also taking @date as the input arg.what should i do to avoid this problem in using @date?

Thanks in advance.

Regards,
Rajiivnb
by rajiivnb
Thu Feb 24, 2005 9:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to trace the warnings illegal date/time value
Replies: 5
Views: 2359

Unable to trace the warnings illegal date/time value

Hi,
SQLSTATE=22008, DBMS.CODE=0
[DataStage][SQL Client]Illegal date/time value



This is the warnings in my job.Any resolutions on this warning.????

Regards,
Rajiivnb
by rajiivnb
Thu Feb 24, 2005 4:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: file should be cleared after taking values from the file
Replies: 5
Views: 2029

Hi Arnd,
That was really Helpful.Is it possible for you to pass me a shell command that the way to invoke the command in the after routine.

Regards,
Rajiivnb
by rajiivnb
Thu Feb 24, 2005 4:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: file should be cleared after taking values from the file
Replies: 5
Views: 2029

file should be cleared after taking values from the file

Hi,
I have certain values from a flatfile to be moved to a table and once it is moved i should be able to clear the file for next process.How could this be made possible.

Thanks in advance.
Regards,
Rajiivnb