Search found 2288 matches

by roy
Tue Jun 21, 2005 4:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: odbc from ds on lnux to as400/db2
Replies: 4
Views: 1055

update:
Well after having support online for 1 hour (not by me) I gather they added an entry in the .odbc.ini configuration for that connection and it shows the NLS, with some issues, but its working.

I've yet to get the exact details.
by roy
Tue Jun 21, 2005 4:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: IBM have buried DataStage
Replies: 4
Views: 1538

I've had the same expiricane a while back. On the other hand they were very quick in changing Ascential's site to introduce the IBM WebSphere prefix to every product. I wonder how long will it take them to at least update their site to hold links for the Ascential's site and get a search results poi...
by roy
Mon Jun 20, 2005 1:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequencer stage takes 8 minutes to open in Designer
Replies: 2
Views: 1069

Hi,
This topic was covered recently.
Basicly it depends on several things
please search for the post.

(I'll try to find it if I find time to)
Try http://www.dsxchange.com/viewtopic.php?t=93122
by roy
Mon Jun 20, 2005 1:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How do we find the release of a DataStage version
Replies: 10
Views: 3371

Hi vinodlakshmanan , I just wanted to note that normally the only time you'll find this info usufull is if and when you report a problem and at that time your support will ask and guide you to the correct manor in which to get exact version for server/EE. And having minor release numbers like 7.0.0 ...
by roy
Mon Jun 20, 2005 10:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Exporting Jobs/Sequencers
Replies: 5
Views: 1888

Ok,
Can you do the same operation to each dsx file you already have?
even using DS itself :?: :idea:
IHTH,
by roy
Mon Jun 20, 2005 10:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Locked Job.. need help
Replies: 8
Views: 2136

Hi, you'r left with 2 options or so. 1. use ds.tools to try and clear locks left. using the DS telnet or running ds.tools in the Administrator's command and using option 5 to administer locks. I admit using the administrator's command option has no good format to the menues but it does the job if yo...
by roy
Mon Jun 20, 2005 10:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Eternal Informix Problem
Replies: 7
Views: 2168

might be so, check your plugin docs and install guide for supported client versions if any. after you install it try testing the ifx client using the demo esqlc program of the client. using dbaccess means nothing since it is part of the ifx server install and doesn't simulate any client activity you...
by roy
Mon Jun 20, 2005 10:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to measure performance?
Replies: 19
Views: 5910

Hi, I'd like to help if I can. Naturally I think publishing performance numbers on different platforms and configurations is benefitial to everyone including the site publishing them, So I'll try encorraging most of the ones I know to participate. p.s. AFAIK using NLS has conciderable impact on perf...
by roy
Mon Jun 20, 2005 10:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Exporting Jobs/Sequencers
Replies: 5
Views: 1888

Hi, Are you talking about making a dsx for each individual component automatically? (not available as of today) If so, the only way you can do it today would be to export the entire thing and manipulate the dsx file to form multiple files each containing a seperate component. You did mention you nee...
by roy
Mon Jun 20, 2005 9:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sybase Cubes
Replies: 2
Views: 1174

Hi,
AFAIK,
If you can do it via regular sql select, yes.
If it requires special handling or connections it might be another thing.

By the way you will probably need a certified answer so please post what your support provider's answer is.

Good Luck,
by roy
Mon Jun 20, 2005 7:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: full outer join
Replies: 6
Views: 1721

Hi, change capture will get you a new column indicating insert/update/delete/same regarding the records from file a to file b. this can be interpreted to exactly what you need. again performing lookups one against the other, each time a different file as source and the other as lookup, might be quic...
by roy
Mon Jun 20, 2005 6:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: full outer join
Replies: 6
Views: 1721

Hi,
Sounds to me like simple change capture then filter stage to split the data to files.
check in the docs on how they work.

IHTH,
by roy
Mon Jun 20, 2005 3:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: initialization of job parameters
Replies: 3
Views: 1862

Hi,
ways to achieve your goal:
1. get parameter manager.
2. hack your way and unpdate repository.
3. manipulate an export dsx file.

Personaly I'm not for option 2 by definition
and this was covered befor so try searching for it in this forum.

Good Luck,
by roy
Mon Jun 20, 2005 2:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: New EtlStats soon
Replies: 34
Views: 13529

Thanks Kim,
for all the effort you put in it :)
Alas I have yet to try it :(
by roy
Mon Jun 20, 2005 2:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Want to populate a calender with a single day input
Replies: 3
Views: 935

Hi and welcome aboard , I think this was covered so use search. In any case your most easy to implement solution would be using a transformer to manufacture 365 rows (or perhaps 366) performing manipulation on the givven parameter date and using Iconv()/Oconve() to manipulate dates generating the 1 ...