Search found 52 matches

by yserrano
Tue Feb 19, 2008 11:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can't view code in Server Routine window
Replies: 3
Views: 1315

Yes, fix pack 1 is installed. Using, for example, the routine KeyMgtGetNextValueConcurrent the code does not appear in the Code tab of the Server Routine Window. But, If I export it, the code is there in the exported file. And, If I check the same routine on a version 7 installation, the code is the...
by yserrano
Mon Feb 18, 2008 3:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete custom routine exported by mistake as read-only
Replies: 7
Views: 4324

Delete custom routine exported by mistake as read-only

Hello, I am trying to accomplish what is described in this Resolved Topic , but, I am using DataStage V8 and the the query: UPDATE DS_ROUTINES SET READONLY = 'NRO' WHERE DSRID = 'routinename' works only for those routines which come with the base product. My custom routine is not in that table. I wi...
by yserrano
Mon Feb 18, 2008 2:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can't view code in Server Routine window
Replies: 3
Views: 1315

Can't view code in Server Routine window

Hello all, Previously with version 7, I was able to see routines code by starting the Manager, double-clicking on the selected routine and opening the Code tab. Now, using Designer, the Code tab is empty, there is only a funcion name and an empty canvas. I do not know if this is a problem with my in...
by yserrano
Mon Feb 04, 2008 12:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to refresh a lookup in every job iteration
Replies: 9
Views: 2321

I am working right now on the "Hash-Files" approach, and it seems like it is going to work. But I am curious about SHARAD post. It would be nice if he (she) could develop a little more into his (her) idea. This is how my original server job looks like: http://img265.imageshack.us/img265/17...
by yserrano
Thu Jan 31, 2008 4:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to refresh a lookup in every job iteration
Replies: 9
Views: 2321

mmm... :? it seems that I'll have to sign up for the Premium Membership to see your complete answer.
Let me see if my boss wants to authorize that expense.

Regards,

YS
by yserrano
Thu Jan 31, 2008 2:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to refresh a lookup in every job iteration
Replies: 9
Views: 2321

to a database table
(the same table I am inserting and updating records into)
by yserrano
Thu Jan 31, 2008 2:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to refresh a lookup in every job iteration
Replies: 9
Views: 2321

How to refresh a lookup in every job iteration

Hello all, please excuse me if this is a newbie question, I am actually new to DataStage development. Is it possible to refresh a lookup to reflect inserts done to the lookup table within the same job? My job writes records to a table X, It is capable of insert new records, insert new versions and u...