Search found 5168 matches

by kumar_s
Fri May 19, 2006 6:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: From where can I get the information regarding Plugin Stages
Replies: 2
Views: 1093

There is no seperate forum for plugins. Its all depends on which edition you use. If it is a PX you have a option to define you own stages. You have similar options available in server to build transforms and routines.
by kumar_s
Tue May 16, 2006 11:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: performance
Replies: 7
Views: 2062

Hi, If performance is much concerned. make the key with hash partition on both reference link as well as data link. (Even If it is a MMP system) If the partition not made clear and exact on the key it is always better to have entire partition to the reference link and make required key partiion on t...
by kumar_s
Sun May 14, 2006 11:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need help in defining metadata
Replies: 1
Views: 620

Since the column name should be unique, you may be forced to change either on of the name. You can try to use alias name in you query like SELECT Employee.Deptno As EMP_Deptno, Deparment.Deptno As DEP_Deptno..... from .... and you can change the name in the medatada accordingly.
by kumar_s
Sun May 14, 2006 11:12 pm
Forum: Site/Forum
Topic: What's this to Charter Member
Replies: 6
Views: 3423

Ya I got it. Yes the link has 'sid' in it.
But not sure if somthing happened today for the link forwarding. The same link shows the full message today. :D So I guess the issue is no more.
by kumar_s
Sun May 14, 2006 11:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: To Get maximum of two input fields
Replies: 3
Views: 918

Hi and Welcome Aboard :D Use transformer Stage and do the transformations as you wish. You can use the simple logic of If Link1.COLA > Link1.COLB Then Link1.COLA Else Link1.COLB Go through the given documentation and do a search on this forum before you trigger a question. Almost all you doubts migh...
by kumar_s
Sun May 14, 2006 11:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How could I process all files from a directory?
Replies: 9
Views: 1993

I dont have the access to Server Edition now. If you have "File Pattern" pattern option as available in PX editon you job will become easiar.
by kumar_s
Sun May 14, 2006 10:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Backup and Exporting AT commands
Replies: 6
Views: 1274

You can optionally search in Duke's page for scheduled backups.
by kumar_s
Sun May 14, 2006 10:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Running Parallel jobs on Windows 2003 Server
Replies: 4
Views: 1692

You can find the exact version at Adminstrator client window under general tab.
by kumar_s
Sun May 14, 2006 7:36 am
Forum: Site/Forum
Topic: What's this to Charter Member
Replies: 6
Views: 3423

What's this to Charter Member

If a post is marked as Premium contentet by Premium posters, and if any link was provided by them, the new page (post) doest show up fully, rather it comes with What's this/"Premium content" green button. (Though I am a Chartered Member). If i search for the same post and enter to the same, it show ...
by kumar_s
Sun May 14, 2006 7:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to create a new job and open an existing job
Replies: 14
Views: 5353

BTW what you mean "When I was executing the command cd $DSHOME or cd $DHOME it takes to the remote directory unless I tried cd $DSHOME/bin" What the output for echo $DSHOME. Check your .profile whether DSHOME is assigned to a value. Else try to source dsenv file. And the above procedures. But you ca...
by kumar_s
Sun May 14, 2006 2:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in DS Load Library
Replies: 2
Views: 1242

Should you be checking the path given for LD_LIBRARY_PATH in dsenv or the permission change for the tables.
by kumar_s
Sun May 14, 2006 2:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to create a new job and open an existing job
Replies: 14
Views: 5353

fixtool is available in home directry.

Code: Select all

cd $DHOME
>fixtool -fix {filename}
by kumar_s
Sun May 14, 2006 2:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: VSAM to Flat File
Replies: 2
Views: 898

As the warning, there may be some range limitation. What is the datatype of the column. There may be mismatch between the metadata and the value of the given column.
by kumar_s
Sun May 14, 2006 2:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to create a new job and open an existing job
Replies: 14
Views: 5353

Even the parallel version uses the CREATE.FILE command internally to create the necessary log files.
Alternatiely you can use UVFIXFILE from TCL to fix it, but it is always suggested after backup.
by kumar_s
Sun May 14, 2006 2:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Fatal Error When insering in to a DB2 table
Replies: 5
Views: 1629

Is the table have necessary Insert permissions for the user?