Search found 34 matches

by sankar18
Tue Dec 17, 2002 4:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Checking for Null value
Replies: 5
Views: 1548

For Null reject rows
--------------------
In Constraint field,

Len(Trim(column))0

T Sankar



Edited by - sankar18 on 12/17/2002 06:35:31
by sankar18
Tue Dec 17, 2002 12:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to tranfer tables from SQLServer to Oracle
Replies: 6
Views: 2844

How to tranfer tables from SQLServer to Oracle

Hi All, Assume the case --------------- If a SQLServer Database is having 1000 tables and 100 stored procedures, how to transfer all the 1000 tables and 100 stored procedures to Oracle Database. Is there any option in DataStage which is similar to Data Transformation Service in SQLServer. Thanks in ...
by sankar18
Mon Dec 16, 2002 7:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Create Sequential Files only if they somme row
Replies: 5
Views: 1510

What do you with second sequential file.If there is no record in the sequential file, you want to delete it.Are you asking how to send the not null to first sequential file andthe null to second sequential file.can you make it clear.
by sankar18
Mon Dec 16, 2002 1:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to rectify this error
Replies: 2
Views: 1109

How to rectify this error

Hi All, I am trying to send mail from transform, The function DSSendmailTester function is taken from routine and placed it in the derivation of the new column. while executing of the job, I am getting this error ____________________________________________________________________ The following toke...