Search found 40 matches

by aravindk
Mon Feb 02, 2004 5:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to set the stage variable within a routine?
Replies: 12
Views: 3164

In my case, both StageVar1 and StageVar2 are same, giving me the impression that it assigns StageVar2 *after* deriving StageVar1.
by aravindk
Mon Feb 02, 2004 4:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to set the stage variable within a routine?
Replies: 12
Views: 3164

That elegant solution is really spoiling me... I am back here again looking for help. Expanding the previous problem, *before* incrementing the stage variable, I want to save the the current value of the stage variable into another stage variable. Is this possible? e.g. I have one stage variable, le...
by aravindk
Mon Feb 02, 2004 2:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to set the stage variable within a routine?
Replies: 12
Views: 3164

Worked like Charm! elegant solution indeed....

Thanks to both of you!
by aravindk
Mon Feb 02, 2004 12:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to set the stage variable within a routine?
Replies: 12
Views: 3164

Yes I did. While it doesnt return any error, it doesnt give the required output.
by aravindk
Mon Feb 02, 2004 12:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to set the stage variable within a routine?
Replies: 12
Views: 3164

This is what I am trying to achieve If InField1 = 0 then StageVar = KeyMgtGetNextValue AND OutField1 = StageVar Else OutField1 = StageVar This topic was recently discussed in http://www.dsxchange.com/viewtopic.php?t=86271 wherein it was suggested that a function can be written to update the stage va...
by aravindk
Mon Feb 02, 2004 10:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to set the stage variable within a routine?
Replies: 12
Views: 3164

How to set the stage variable within a routine?

How can I refer to a stage variable within a routine? What I am trying to do is set a stage variable based on certain conditions tested on the input columns.
by aravindk
Wed Dec 17, 2003 9:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: AS400 Connectivity
Replies: 10
Views: 2650

The no of tabs on a ODBC has drastically come down ever since and now they have only 8 tabs with some 50 options! In the Client Access ODBC, I can limit the libraries to be cataloged, to the default library list attached to the user id there by limiting the tables being downloaded. I am sure similar...
by aravindk
Tue Dec 16, 2003 3:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: AS400 Connectivity
Replies: 10
Views: 2650

Once you choose the download the Metadata from the AS400, first it downloads the all the files/tables (names only) from the systems. This took about 45 minutes on our server. After which it lists down all the tables with their qualifications. You can select the tables for which you want to download ...
by aravindk
Tue Dec 16, 2003 9:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: AS400 Connectivity
Replies: 10
Views: 2650

It works!

Steve & Ray,

Thank you! It does work. I think I should take a refresher course in Patience.

Regards,
by aravindk
Mon Dec 15, 2003 3:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: AS400 Connectivity
Replies: 10
Views: 2650

AS400 Connectivity

Hello all, We have Datastage on Unix and am trying to configure the AS400 connectivity on DataStage. For the past couple of weeks I was trying to configure the Data Direct ODBC for this purpose and finally I gave up. (The last error message I got was <L805 program name not found in plan>). Now I hav...