Search found 53 matches

by Ush
Tue Jan 01, 2008 11:17 pm
Forum: General
Topic: Calling Server routines from a parallel job
Replies: 4
Views: 1726

Hi

Thanks for your reply.I used transformer in parallel job and when I r-click it shows only parallel routines.Please let me know if I am missing something

Thanks
by Ush
Tue Jan 01, 2008 10:54 pm
Forum: General
Topic: Calling Server routines from a parallel job
Replies: 4
Views: 1726

Calling Server routines from a parallel job

Hi

Is it possible to call a server routine written in BASIC from a parallel job

Thanks
by Ush
Mon Dec 31, 2007 3:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Current Date
Replies: 2
Views: 939

Current Date

Hi

Please let me know predefined function for the following:

At the first call in a job, the function should call the operating system for the date. On the second and subsequent calls, the function returns the value of the first call.

Thanks
by Ush
Fri Dec 14, 2007 12:38 am
Forum: General
Topic: NullToEmpty
Replies: 1
Views: 1987

NullToEmpty

Hi

We say NullToZero converts Null value to zero.When we use Null toEmpty.
Please let me know how Empty value is stored in Datastage

Thanks
by Ush
Tue Dec 11, 2007 9:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dynamic prepared Sql using routines
Replies: 4
Views: 1419

Dynamic prepared Sql using routines

Has anyone created user-defined dynamic SQL in routine. I have a lookup table that contains the name of the column I need to update. I want to pass the column name to my update statement.

I want this to be done only using routines

Thanks
by Ush
Tue Dec 11, 2007 6:29 am
Forum: General
Topic: Save log details of a particular job in file
Replies: 1
Views: 884

Save log details of a particular job in file

Hi

Please let me know as how to Save log details of a particular job in file

Thanks
UshaRani
by Ush
Tue Dec 11, 2007 6:29 am
Forum: General
Topic: Save log details of a particular job in file
Replies: 2
Views: 989

Save log details of a particular job in file

Hi

Please let me know as how to Save log details of a particular job in file

Thanks
UshaRani
by Ush
Tue Dec 11, 2007 6:26 am
Forum: General
Topic: Dynamic Sql in routines
Replies: 2
Views: 1173

Dynamic Sql in routines

Hi

Please let me know how to implement dynamic sql in routines.Thanks in advance

Thanks
Ush