Search found 5 matches

by shwetha.st
Wed Sep 19, 2007 1:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Warnings for Null Values
Replies: 3
Views: 1568

Warnings for Null Values

Hi All My requirement is that i have to see warnings for the null values also. My source is a csv file with 5 columns only and target is relational table. Taret is something like EMPID,ENAME,LEVEL1,LEVEL2,LEVEL3. EMPID is a primary key. My scenario is if the level1,level2,level3 are null there must ...
by shwetha.st
Thu Aug 16, 2007 2:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Log file path
Replies: 3
Views: 2767

Log file path

Hi all

I want to know the default path in which the logfile is created.
And can i see this log file.
My requirement is that i want to send a logfile attached in a mail the logfile is nothing but the details you see in the director after a job run.

Thanks in advance.
Shwetha :lol:
by shwetha.st
Wed Apr 18, 2007 1:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: rows to column
Replies: 4
Views: 2081

rows to column

Hi all I rows something like this A B C D and i want it like A B C D iam trying to use a pivot but i am getting the output same as that of the input. I am not able to see any options in Pivot so that i can change. It is having just the STAGE,INPUT and OUTPUT.Where can i set the things which will wor...
by shwetha.st
Wed Mar 28, 2007 12:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC connection Dead
Replies: 3
Views: 2346

Re: ODBC connection Dead

Thank's for your reply,but i have checked the password in my job as well,its the correct password. [quote="shwetha.st"]Hi, Iam trying to run a job which has an ODBC as the lookup, but getting an error as [[color=red]b][DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driv...
by shwetha.st
Tue Mar 27, 2007 11:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC connection Dead
Replies: 3
Views: 2346

ODBC connection Dead

Hi, Iam trying to run a job which has an ODBC as the lookup, but getting an error as [ b][DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-12203: unable to connect to destination|.[/b] Previously our database password was changed and this change has been done in ...